4 id INTEGER PRIMARY KEY NOT NULL,
5 addtime datetime NOT NULL,
6 title character varying NOT NULL,
12 id INTEGER PRIMARY KEY NOT NULL,
13 name character varying NOT NULL,
17 CREATE TABLE post_tag_map (
18 post_id INTEGER KEY NOT NULL,
19 tag_id INTEGER NOT NULL,
20 PRIMARY KEY(post_id, tag_id)
23 CREATE TABLE comment (
24 id INTEGER PRIMARY KEY NOT NULL,
25 post_id INTEGER NOT NULL,
26 isauthor INTEGER(1) NOT NULL DEFAULT 0,
27 addtime datetime NOT NULL,
28 name character varying,
29 openid character varying,
30 email character varying,