diff options
| author | Thomas Citharel <tcit@tcit.fr> | 2015-04-07 23:07:02 +0200 |
|---|---|---|
| committer | Thomas Citharel <tcit@tcit.fr> | 2015-04-07 23:07:02 +0200 |
| commit | 6f136f4df2f8f5daeca2878e61015ee7fa162bb7 (patch) | |
| tree | f2d702a3461dcff2751a1eb749431e111bf4a4d3 | |
| parent | dfc1d3e8f325cdd90d76e26d45668870181ec3b8 (diff) | |
| download | wallabag-1.9.1alpha2.tar.gz wallabag-1.9.1alpha2.tar.zst wallabag-1.9.1alpha2.zip | |
remove unnecessary spaces1.9.1alpha2
| -rw-r--r-- | install/mysql.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/install/mysql.sql b/install/mysql.sql index 1b65cd35..8319ad08 100644 --- a/install/mysql.sql +++ b/install/mysql.sql | |||
| @@ -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=utf8mb4; | 17 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| 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` varchar(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=utf8mb4; | 26 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| 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,13 +31,13 @@ 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=utf8mb4; | 34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| 35 | 35 | ||
| 36 | CREATE TABLE IF NOT EXISTS `tags` ( | 36 | CREATE TABLE IF NOT EXISTS `tags` ( |
| 37 | `id` int(11) NOT NULL AUTO_INCREMENT, | 37 | `id` int(11) NOT NULL AUTO_INCREMENT, |
| 38 | `value` varchar(255) NOT NULL, | 38 | `value` varchar(255) NOT NULL, |
| 39 | PRIMARY KEY (`id`) | 39 | PRIMARY KEY (`id`) |
| 40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | 40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| 41 | 41 | ||
| 42 | CREATE TABLE IF NOT EXISTS `tags_entries` ( | 42 | CREATE TABLE IF NOT EXISTS `tags_entries` ( |
| 43 | `id` int(11) NOT NULL AUTO_INCREMENT, | 43 | `id` int(11) NOT NULL AUTO_INCREMENT, |
| @@ -46,4 +46,4 @@ CREATE TABLE IF NOT EXISTS `tags_entries` ( | |||
| 46 | FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE, | 46 | FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE, |
| 47 | FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE, | 47 | FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE, |
| 48 | PRIMARY KEY (`id`) | 48 | PRIMARY KEY (`id`) |
| 49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | 49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |