cms/sql.txt at master · yubang/cms · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
create table if not exists cms_message(
    id int(11) auto_increment,
    title varchar(200) not null,
    status tinyint(1) not null,
    token varchar(32),
    code varchar(32),
    updateTime timestamp,
    primary key(id),
    key(title),
    key(code,token)
);

create table if not exists cms_message_content(
    id int(11) auto_increment,
    mid int(11) not null,
    content text not null,
    updateTime timestamp,
    primary key(id)
);

create table if not exists cms_account(
    id int(11) auto_increment,
    username varchar(30),
    password varchar(32),
    createTime timestamp,
    primary key(id)
);
insert into cms_account(username,password) values('root','root');