goblog/schema_sqlite.sql at main · Wuvist/goblog · 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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
PRAGMA foreign_keys = OFF;

DROP TABLE IF EXISTS articles;
CREATE TABLE articles (
  "index" INTEGER PRIMARY KEY AUTOINCREMENT,
  title TEXT,
  blogger INTEGER NOT NULL,
  content TEXT,
  ref INTEGER NOT NULL DEFAULT 0,
  add_date DATETIME,
  cate INTEGER,
  Comment INTEGER NOT NULL DEFAULT 0,
  Recommend INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_articles_add_date ON articles(add_date);
CREATE INDEX idx_articles_blogger ON articles(blogger);
CREATE INDEX idx_articles_cate ON articles(cate);

DROP TABLE IF EXISTS blogger;
CREATE TABLE blogger (
  "index" INTEGER PRIMARY KEY AUTOINCREMENT,
  id TEXT NOT NULL,
  nick TEXT,
  DOB DATETIME NOT NULL,
  blogname TEXT NOT NULL,
  blogskin INTEGER NOT NULL,
  email TEXT NOT NULL,
  visitor INTEGER NOT NULL DEFAULT 0,
  intro TEXT,
  blogs INTEGER NOT NULL DEFAULT 0,
  IP TEXT,
  TS INTEGER NOT NULL DEFAULT 0,
  Last_log DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  Last_post DATETIME,
  Activate INTEGER NOT NULL DEFAULT 0,
  Reveal INTEGER NOT NULL DEFAULT 1,
  userpic INTEGER NOT NULL DEFAULT 20,
  lang TEXT NOT NULL DEFAULT 'zh_cn',
  widget TEXT
);

DROP TABLE IF EXISTS comment;
CREATE TABLE comment (
  "index" INTEGER PRIMARY KEY AUTOINCREMENT,
  blogger INTEGER,
  article INTEGER NOT NULL,
  title TEXT NOT NULL,
  content TEXT NOT NULL,
  author TEXT,
  homepage TEXT,
  add_date DATETIME NOT NULL,
  ip TEXT,
  utype INTEGER NOT NULL DEFAULT 0,
  uid TEXT
);
CREATE INDEX idx_comment_article ON comment(article);
CREATE INDEX idx_comment_blogger ON comment(blogger);

DROP TABLE IF EXISTS links;
CREATE TABLE links (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  blogger INTEGER NOT NULL,
  link TEXT NOT NULL,
  URL TEXT NOT NULL,
  reveal INTEGER NOT NULL DEFAULT 1
);

DROP TABLE IF EXISTS userdefinecategory;
CREATE TABLE userdefinecategory (
  "index" INTEGER PRIMARY KEY AUTOINCREMENT,
  blogger INTEGER NOT NULL,
  cate TEXT NOT NULL,
  files INTEGER NOT NULL DEFAULT 0
);