aboutsummaryrefslogtreecommitdiffhomepage
path: root/install/mysql.sql
diff options
context:
space:
mode:
authorNicolas LÅ“uillet <nicolas.loeuillet@gmail.com>2014-01-08 11:28:53 +0100
committerNicolas LÅ“uillet <nicolas.loeuillet@gmail.com>2014-01-08 11:28:53 +0100
commit2744d07d71e50caa1b438741991eb736f1999cc6 (patch)
treeff1f9cab5a50b02096af96b9085df9ffdf60e2ae /install/mysql.sql
parent5ed8050791ef562ff4351ede3a077ab1e8b0d916 (diff)
parentc3b261e321811cd3cdb5a886edbce1a0ca973119 (diff)
downloadwallabag-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.sql6
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;