· 8 years ago · May 01, 2018, 06:00 PM
1CREATE TABLE IF NOT EXISTS "users" (
2 "id" int(11) unsigned NOT NULL auto_increment,
3 "username" varchar(32) NOT NULL,
4 "email" varchar(255) NOT NULL,
5 "password" varchar(32) NOT NULL,
6 "admin" tinyint(1) NOT NULL default 0,
7 "created_at" datetime default NULL,
8 "updated_at" datetime default NULL,
9 "last_login_at" datetime default NULL,
10 "auth_token" varchar(255) default NULL,
11 "auth_token_expires_at" datetime default NULL,
12 "confirmed" tinyint(1) NOT NULL default 0,
13 "identity_url" varchar(255) default NULL,
14 PRIMARY KEY ("id")
15);