mirror of
https://github.com/zhufuyi/sponge.git
synced 2025-10-05 08:46:57 +08:00
17 lines
640 B
SQL
17 lines
640 B
SQL
create table user
|
|
(
|
|
id bigint unsigned auto_increment
|
|
primary key,
|
|
created_at datetime null,
|
|
updated_at datetime null,
|
|
deleted_at datetime null,
|
|
name char(50) not null comment 'username',
|
|
password char(100) not null comment 'password',
|
|
email char(50) not null comment 'email',
|
|
phone bigint unsigned not null comment 'phone number',
|
|
age tinyint not null comment 'age',
|
|
gender tinyint not null comment 'gender, 1:male, 2:female, 3:unknown',
|
|
constraint user_email_uindex
|
|
unique (email)
|
|
);
|