#用户信息
create table gass_fc_user_accounts(
uid int unsigned auto_increment primary key not null comment "用户ID",
username varchar(16) unique not null comment "用户名",
password varchar(32) not null comment "密码",
status tinyint not null default 1 comment "状态"
)comment="用户信息",engine=MyISAM default character set utf8 collate utf8_general_ci;
#flag提交信息
create table gass_fc_submissions(
sid int unsigned auto_increment primary key not null comment "提交ID",
uid int unsigned not null comment "用户ID",
flag text not null comment "Flag",
sub_at datetime not null default now() comment "签到时间",
status tinyint not null default 1 comment "状态"
)comment="flag提交信息",engine=MyISAM default character set utf8 collate utf8_general_ci;
#flag注册表
create table gass_fc_flags(
fid int unsigned auto_increment primary key not null comment "Flag ID",
flag text not null comment "Flag",
create_at datetime not null default now() comment "创建时间",
points int not null default 1 comment "分值",
status tinyint not null default 1 comment "状态"
)comment="flag注册表",engine=MyISAM default character set utf8 collate utf8_general_ci;