diff options
| author | Dmitry Sandalov <dmitry@sandalov.org> | 2013-12-19 16:24:49 +0300 |
|---|---|---|
| committer | Dmitry Sandalov <dmitry@sandalov.org> | 2013-12-19 16:24:49 +0300 |
| commit | 17bd2cc94c8558c754c05920938f7386f88b2d9a (patch) | |
| tree | 366efac7fdc2cf3eb059878b2644299e06159495 | |
| parent | 04fcbad8c50956336819f2b25db8298d50b5b800 (diff) | |
| download | wallabag-17bd2cc94c8558c754c05920938f7386f88b2d9a.tar.gz wallabag-17bd2cc94c8558c754c05920938f7386f88b2d9a.tar.zst wallabag-17bd2cc94c8558c754c05920938f7386f88b2d9a.zip | |
tags: mysql create tables if not exists
| -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 66c4bb31..d16381d8 100644 --- a/install/mysql.sql +++ b/install/mysql.sql | |||
| @@ -33,17 +33,17 @@ CREATE TABLE IF NOT EXISTS `users_config` ( | |||
| 33 | PRIMARY KEY (`id`) | 33 | PRIMARY KEY (`id`) |
| 34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 35 | 35 | ||
| 36 | CREATE TABLE 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=utf8; | 40 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 41 | 41 | ||
| 42 | CREATE TABLE 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, |
| 44 | `entry_id` int(11) NOT NULL, | 44 | `entry_id` int(11) NOT NULL, |
| 45 | `tag_id` int(11) NOT NULL, | 45 | `tag_id` int(11) NOT NULL, |
| 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=utf8; \ No newline at end of file | 49 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |