diff options
author | Nicolas LÅ“uillet <nicolas.loeuillet@gmail.com> | 2014-01-08 11:28:53 +0100 |
---|---|---|
committer | Nicolas LÅ“uillet <nicolas.loeuillet@gmail.com> | 2014-01-08 11:28:53 +0100 |
commit | 2744d07d71e50caa1b438741991eb736f1999cc6 (patch) | |
tree | ff1f9cab5a50b02096af96b9085df9ffdf60e2ae /install/mysql.sql | |
parent | 5ed8050791ef562ff4351ede3a077ab1e8b0d916 (diff) | |
parent | c3b261e321811cd3cdb5a886edbce1a0ca973119 (diff) | |
download | wallabag-2744d07d71e50caa1b438741991eb736f1999cc6.tar.gz wallabag-2744d07d71e50caa1b438741991eb736f1999cc6.tar.zst wallabag-2744d07d71e50caa1b438741991eb736f1999cc6.zip |
Merge branch 'dev' of https://github.com/inthepoche/poche into dev
Diffstat (limited to 'install/mysql.sql')
-rw-r--r-- | install/mysql.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/install/mysql.sql b/install/mysql.sql index d16381d8..de5640e4 100644 --- a/install/mysql.sql +++ b/install/mysql.sql | |||
@@ -9,8 +9,8 @@ CREATE TABLE IF NOT EXISTS `entries` ( | |||
9 | `id` int(11) NOT NULL AUTO_INCREMENT, | 9 | `id` int(11) NOT NULL AUTO_INCREMENT, |
10 | `title` varchar(255) NOT NULL, | 10 | `title` varchar(255) NOT NULL, |
11 | `url` varchar(255) NOT NULL, | 11 | `url` varchar(255) NOT NULL, |
12 | `is_read` tinyint(1) NOT NULL, | 12 | `is_read` tinyint(1) NOT NULL DEFAULT 0, |
13 | `is_fav` tinyint(1) NOT NULL, | 13 | `is_fav` tinyint(1) NOT NULL DEFAULT 0, |
14 | `content` blob NOT NULL, | 14 | `content` blob NOT NULL, |
15 | `user_id` int(11) NOT NULL, | 15 | `user_id` int(11) NOT NULL, |
16 | PRIMARY KEY (`id`) | 16 | PRIMARY KEY (`id`) |
@@ -20,7 +20,7 @@ CREATE TABLE IF NOT EXISTS `users` ( | |||
20 | `id` int(11) NOT NULL AUTO_INCREMENT, | 20 | `id` int(11) NOT NULL AUTO_INCREMENT, |
21 | `username` varchar(255) NOT NULL, | 21 | `username` varchar(255) NOT NULL, |
22 | `password` varchar(255) NOT NULL, | 22 | `password` varchar(255) NOT NULL, |
23 | `name` int(255) NOT NULL, | 23 | `name` varchar(255) NOT NULL, |
24 | `email` varchar(255) NOT NULL, | 24 | `email` varchar(255) NOT NULL, |
25 | PRIMARY KEY (`id`) | 25 | PRIMARY KEY (`id`) |
26 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 26 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |