[platal.git] / upgrade / 0.9.2 / 00_auth_user_quicl.sql

create table auth_user_quick (
    user_id smallint not null,
    lastnewslogin timestamp not null,
    skin tinyint not null,
    primary key(user_id)
);

insert into  auth_user_quick (
     select  user_id,lastnewslogin,skin
       from  auth_user_md5
);

alter table auth_user_md5 drop column lastnewslogin;
alter table auth_user_md5 drop column skin;
Commit	Line	Data
0337d704	1	create table auth_user_quick (
	2	user_id smallint not null,
	3	lastnewslogin timestamp not null,
	4	skin tinyint not null,
	5	primary key(user_id)
	6	);
	7
	8	insert into auth_user_quick (
	9	select user_id,lastnewslogin,skin
	10	from auth_user_md5
	11	);
	12
	13	alter table auth_user_md5 drop column lastnewslogin;
	14	alter table auth_user_md5 drop column skin;