tags: mysql create tables if not exists

[github/wallabag/wallabag.git] / install / mysql.sql

diff --git a/install/mysql.sql b/install/mysql.sql
index 66c4bb31274ff14dc4466a749c811b3ce1abad56..d16381d83b3df33fcff5ddfd6cd8cbd869831472 100644 (file)
--- a/install/mysql.sql
+++ b/install/mysql.sql
@@ -33,17 +33,17 @@ CREATE TABLE IF NOT EXISTS `users_config` (
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
-CREATE TABLE tags (
+CREATE TABLE IF NOT EXISTS `tags` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `value` varchar(255) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
-CREATE TABLE tags_entries (
+CREATE TABLE IF NOT EXISTS `tags_entries` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `entry_id` int(11) NOT NULL,
   `tag_id` int(11) NOT NULL,
   FOREIGN KEY(entry_id) REFERENCES entries(id) ON DELETE CASCADE,
   FOREIGN KEY(tag_id) REFERENCES tags(id) ON DELETE CASCADE,
   PRIMARY KEY (`id`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
\ No newline at end of file
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;