]>
Commit | Line | Data |
---|---|---|
1 | CREATE TABLE IF NOT EXISTS `config` ( | |
2 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
3 | `name` varchar(255) NOT NULL, | |
4 | `value` varchar(255) NOT NULL, | |
5 | PRIMARY KEY (`id`) | |
6 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
7 | ||
8 | CREATE TABLE IF NOT EXISTS `entries` ( | |
9 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
10 | `title` varchar(255) NOT NULL, | |
11 | `url` varchar(255) NOT NULL, | |
12 | `is_read` tinyint(1) NOT NULL DEFAULT 0, | |
13 | `is_fav` tinyint(1) NOT NULL DEFAULT 0, | |
14 | `content` blob NOT NULL, | |
15 | `user_id` int(11) NOT NULL, | |
16 | PRIMARY KEY (`id`) | |
17 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
18 | ||
19 | CREATE TABLE IF NOT EXISTS `users` ( | |
20 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
21 | `username` varchar(255) NOT NULL, | |
22 | `password` varchar(255) NOT NULL, | |
23 | `name` varchar(255) NOT NULL, | |
24 | `email` varchar(255) NOT NULL, | |
25 | PRIMARY KEY (`id`) | |
26 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
27 | ||
28 | CREATE TABLE IF NOT EXISTS `users_config` ( | |
29 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
30 | `user_id` int(11) NOT NULL, | |
31 | `name` varchar(255) NOT NULL, | |
32 | `value` varchar(255) NOT NULL, | |
33 | PRIMARY KEY (`id`) | |
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
35 | ||
36 | CREATE TABLE IF NOT EXISTS `tags` ( | |
37 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
38 | `value` varchar(255) NOT NULL, | |
39 | PRIMARY KEY (`id`) | |
40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
41 | ||
42 | CREATE TABLE IF NOT EXISTS `tags_entries` ( | |
43 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
44 | `entry_id` int(11) NOT NULL, | |
45 | `tag_id` int(11) NOT NULL, | |
46 | FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE, | |
47 | FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE, | |
48 | PRIMARY KEY (`id`) | |
49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |