· 9 years ago · Dec 14, 2016, 05:56 PM
1-- init.sql for SQLite3
2
3CREATE TABLE IF NOT EXISTS "user" (
4 "id" integer NOT NULL PRIMARY KEY,
5 "slack_user_id" varchar(254) NOT NULL,
6 "slack_team_id" varchar(254) NOT NULL,
7 "slack_user_name" varchar(254)NOT NULL
8);
9
10CREATE TABLE IF NOT EXISTS "cmk_list" (
11 "id" integer NOT NULL PRIMARY KEY,
12 "event_name" varchar(254),
13 "encoding" varchar(254),
14 "program_signature" varchar(254)
15);
16
17CREATE TABLE IF NOT EXISTS "cmk_list_circle" (
18 "id" integer NOT NULL PRIMARY KEY,
19 "parent_list_id" integer NOT NULL REFERENCES "cmk_list" ("id"),
20 "added_by_id" integer NOT NULL REFERENCES "user" ("id"),
21
22 "serial_number" integer unsinged NOT NULL,
23 "color_number" smallint unsigned,
24 "page_number" integer unsigned,
25 "cut_index" integer unsigned,
26 "week" varchar(1),
27 "area" varchar(1),
28 "block" varchar(1),
29 "space_number" smallint unsigned,
30 "genre_code" smallint unsigned,
31 "circle_name" varchar(254) NOT NULL,
32 "circle_name_yomi" varchar(254) NOT NULL,
33 "pen_name" varchar(254),
34 "book_name" varchar(254),
35 "url" varchar(254),
36 "mail_address" varchar(254),
37 "description" text,
38 "memo" text,
39 "map_x" integer,
40 "map_y" integer,
41 "map_layout" integer,
42 "space_number_sub" varchar(1),
43 "web_catalog_url" varchar(254),
44 "update_data" text,
45 "circlems_url" varchar(254),
46 "rss" varchar(254),
47 "rss_data" text,
48 "twitter_url" varchar(254),
49 "pixiv_url" varchar(254)
50);
51
52CREATE TABLE IF NOT EXISTS "cmk_list_unknown" (
53 "id" integer NOT NULL PRIMARY KEY,
54 "parent_list_id" integer NOT NULL REFERENCES "cmk_list" ("id"),
55
56 "circle_name" varchar(254) NOT NULL,
57 "circle_name_yomi" varchar(254) NOT NULL,
58 "pen_name" varchar(254),
59 "memo" text,
60 "color_number" smallint unsigned,
61 "book_name" varchar(254),
62 "url" varchar(254),
63 "mail_address" varchar(254),
64 "description" text,
65 "update_data" text,
66 "circlems_url" varchar(254),
67 "rss" varchar(254)
68);
69
70CREATE TABLE IF NOT EXISTS "cmk_list_color" (
71 "id" integer NOT NULL PRIMARY KEY,
72 "parent_list_id" integer NOT NULL REFERENCES "cmk_list" ("id"),
73
74 "color_number" smallint unsigned NOT NULL,
75 "check_color" varchar(7) NOT NULL,
76 "print_color" varchar(7) NOT NULL,
77 "color_description" text
78);