suhan1996
16 lines
727 B
SQL
16 lines
727 B
SQL
create table user_tmp
|
|
(
|
|
uid integer primary key autoincrement not null,
|
|
name text collate nocase not null,
|
|
password text,
|
|
email text collate nocase,
|
|
gender integer not null,
|
|
language text not null,
|
|
is_admin boolean not null default false,
|
|
create_by text not null,
|
|
avatar_updated_at timestamp not null default '1970-01-01 00:00:00',
|
|
created_at timestamp not null default current_timestamp,
|
|
updated_at timestamp not null default current_timestamp
|
|
);
|
|
|
|
create unique index user_tmp_email on user (email); |