diff options
| author | Nicolas Lœuillet <nicolas@loeuillet.org> | 2014-02-03 10:03:41 -0800 |
|---|---|---|
| committer | Nicolas Lœuillet <nicolas@loeuillet.org> | 2014-02-03 10:03:41 -0800 |
| commit | 38dafee05d52948fba4a06066d7b0343c8e3de9d (patch) | |
| tree | 2e3f7bd3a58bfdb046742c3e65ff082e31a9859b /install/mysql.sql | |
| parent | f355d2c87fa441221ca8a9339c426c1c95e7c2ac (diff) | |
| parent | fa0bfb775a53a074e0a9d642298685b5ed1af83f (diff) | |
| download | wallabag-38dafee05d52948fba4a06066d7b0343c8e3de9d.tar.gz wallabag-38dafee05d52948fba4a06066d7b0343c8e3de9d.tar.zst wallabag-38dafee05d52948fba4a06066d7b0343c8e3de9d.zip | |
Merge pull request #427 from wallabag/dev1.4.0
changelog 1.4
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; |