· 7 years ago · Oct 02, 2018, 04:18 PM
1create table if not exists fb.accounts
2(
3 id int auto_increment,
4 username varchar(20) null,
5 password varchar(15) null,
6 access_token text null,
7 uid varchar(15) not null,
8 created_at datetime default CURRENT_TIMESTAMP null,
9 dead tinyint(1) default '0' null,
10 synclimit tinyint(1) default '0' null,
11 constraint accounts_id_uindex
12 unique (id),
13 constraint accounts_uid_uindex
14 unique (uid),
15 constraint accounts_username_uindex
16 unique (username)
17)
18;
19
20alter table fb.accounts
21 add primary key (id)
22;