diff options
| author | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2013-11-25 02:00:07 -0800 |
|---|---|---|
| committer | Nicolas Lœuillet <nicolas.loeuillet@gmail.com> | 2013-11-25 02:00:07 -0800 |
| commit | c2b7a11c772a5b503896add11ea18838999f8d58 (patch) | |
| tree | 1976b248eb85e335febc13e0442b8fe766b91687 /install/mysql.sql | |
| parent | cd8a3441561fa63b9da1b705c4b28dee787f79b0 (diff) | |
| parent | 7a4482b8a43afca7f5c311ae7e44b3f0c4d239c0 (diff) | |
| download | wallabag-c2b7a11c772a5b503896add11ea18838999f8d58.tar.gz wallabag-c2b7a11c772a5b503896add11ea18838999f8d58.tar.zst wallabag-c2b7a11c772a5b503896add11ea18838999f8d58.zip | |
Merge pull request #326 from inthepoche/dev
1.2.0
Diffstat (limited to 'install/mysql.sql')
| -rw-r--r-- | install/mysql.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/install/mysql.sql b/install/mysql.sql index cb232a84..9b01e32c 100644 --- a/install/mysql.sql +++ b/install/mysql.sql | |||
| @@ -3,7 +3,7 @@ CREATE TABLE IF NOT EXISTS `config` ( | |||
| 3 | `name` varchar(255) NOT NULL, | 3 | `name` varchar(255) NOT NULL, |
| 4 | `value` varchar(255) NOT NULL, | 4 | `value` varchar(255) NOT NULL, |
| 5 | PRIMARY KEY (`id`) | 5 | PRIMARY KEY (`id`) |
| 6 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | 6 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 7 | 7 | ||
| 8 | CREATE TABLE IF NOT EXISTS `entries` ( | 8 | CREATE TABLE IF NOT EXISTS `entries` ( |
| 9 | `id` int(11) NOT NULL AUTO_INCREMENT, | 9 | `id` int(11) NOT NULL AUTO_INCREMENT, |
| @@ -14,7 +14,7 @@ CREATE TABLE IF NOT EXISTS `entries` ( | |||
| 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`) |
| 17 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | 17 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 18 | 18 | ||
| 19 | CREATE TABLE IF NOT EXISTS `users` ( | 19 | CREATE TABLE IF NOT EXISTS `users` ( |
| 20 | `id` int(11) NOT NULL AUTO_INCREMENT, | 20 | `id` int(11) NOT NULL AUTO_INCREMENT, |
| @@ -23,7 +23,7 @@ CREATE TABLE IF NOT EXISTS `users` ( | |||
| 23 | `name` int(255) NOT NULL, | 23 | `name` int(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=latin1; | 26 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 27 | 27 | ||
| 28 | CREATE TABLE IF NOT EXISTS `users_config` ( | 28 | CREATE TABLE IF NOT EXISTS `users_config` ( |
| 29 | `id` int(11) NOT NULL AUTO_INCREMENT, | 29 | `id` int(11) NOT NULL AUTO_INCREMENT, |
| @@ -31,4 +31,4 @@ CREATE TABLE IF NOT EXISTS `users_config` ( | |||
| 31 | `name` varchar(255) NOT NULL, | 31 | `name` varchar(255) NOT NULL, |
| 32 | `value` varchar(255) NOT NULL, | 32 | `value` varchar(255) NOT NULL, |
| 33 | PRIMARY KEY (`id`) | 33 | PRIMARY KEY (`id`) |
| 34 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; \ No newline at end of file | 34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; \ No newline at end of file |