-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
117 lines (99 loc) · 2.93 KB
/
schema.sql
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
CREATE TABLE "global_state" (
"last_update" INTEGER --unix timestamp
);
CREATE TABLE "user" (
"name" STRING NOT NULL,
"pass" STRING NOT NULL, --hash(<real_pass><salt>)
"salt" STRING NOT NULL,
PRIMARY KEY("name")
);
INSERT INTO "user" ("name", "pass", "salt") VALUES
("root", "4a1b39fce8a333a215886ad6df812b85", "SALT"); --root:pass
CREATE TABLE "manga" (
"id" INTEGER NOT NULL,
"type" INTEGER NOT NULL,
"country_of_origin" STRING NOT NULL,
"publication_status" INTEGER NOT NULL,
"scanlation_status" BOOL NOT NULL,
"mal_id" INTEGER,
"anilist_id" INTEGER,
"mangaupdates_id" INTEGER,
"global_id" STRING NOT NULL DEFAULT '',
"last_update" INTEGER NOT NULL DEFAULT 0, --unix timestamp
PRIMARY KEY("id")
);
INSERT INTO "manga" ("id", "type", "country_of_origin", "publication_status", "scanlation_status", "mal_id", "anilist_id", "mangaupdates_id") VALUES
(1, 0, 'ja', 0, 0, 0, 0, 0),
(2, 0, 'ja', 0, 0, 0, 0, 0);
CREATE TABLE "title" (
"manga_id" INTEGER NOT NULL,
"name" TEXT NOT NULL
);
INSERT INTO "title" ("manga_id", "name") VALUES
(1, 'YuruYuri'),
(1, 'ゆるゆり'),
(2, 'Yuyushiki'),
(2, 'ゆゆ式');
CREATE TABLE "tag" (
"id" INTEGER NOT NULL,
"name" STRING NOT NULL,
PRIMARY KEY("id")
);
INSERT INTO "tag" ("id", "name") VALUES
(1, 'sol'),
(2, 'yuri'),
(3, 'cgdct'),
(4, 'comedy');
CREATE TABLE "manga_tag" (
"manga_id" INTEGER NOT NULL,
"tag_id" INTEGER NOT NULL
);
INSERT INTO "manga_tag" ("manga_id", "tag_id") VALUES
(1, 2),
(1, 4),
(2, 3),
(2, 4);
CREATE TABLE "person" (
"id" INTEGER NOT NULL,
"name" STRING NOT NULL,
PRIMARY KEY("id")
);
INSERT INTO "person" ("id", "name") VALUES
(1, 'Namori'),
(2, 'Komata Mikami');
CREATE TABLE "author" (
"manga_id" INTEGER NOT NULL,
"person_id" INTEGER NOT NULL
);
INSERT INTO "author" ("manga_id", "person_id") VALUES
(1, 1),
(2, 2);
CREATE TABLE "artist" (
"manga_id" INTEGER NOT NULL,
"person_id" INTEGER NOT NULL
);
INSERT INTO "artist" ("manga_id", "person_id") VALUES
(1, 1),
(2, 2);
CREATE TABLE "chapter" (
"id" INTEGER NOT NULL,
"manga_id" INTEGER NOT NULL,
"manga_global_id" STRING NOT NULL,
"chapter_no" INTEGER NOT NULL,
"chapter_postfix" STRING,
"ordinal" INTEGER NOT NULL,
"pages" INTEGER NOT NULL,
"title" STRING,
"version" INTEGER,
"language_id" STRING NOT NULL,
"group_id" INTEGER,
"date_added" INTEGER NOT NULL,
"ipfs_link" STRING NOT NULL,
"global_id" STRING NOT NULL DEFAULT '',
"last_update" INTEGER NOT NULL DEFAULT 0, --unix timestamp
PRIMARY KEY("id")
);
INSERT INTO "chapter" ("id", "manga_id", "manga_global_id", "chapter_no", "chapter_postfix", "ordinal", "pages", "title", "version", "language_id", "group_id", "date_added", "ipfs_link") VALUES
(1, 1, '', 1, NULL, 100, 13, '', 0, 'en', NULL, 0, ''),
(2, 1, '', 2, NULL, 200, 13, '', 1, 'en', NULL, 0, ''),
(3, 2, '', 1, NULL, 100, 13, '', 0, 'en', NULL, 0, '');