X-Git-Url: https://git.immae.eu/?a=blobdiff_plain;f=install%2Fmysql.sql;h=d16381d83b3df33fcff5ddfd6cd8cbd869831472;hb=9bc32632af80130ca6aff968b800ceb43aa86576;hp=66c4bb31274ff14dc4466a749c811b3ce1abad56;hpb=05d6dd487ceaf8c00510ebe5e0e762fcc11df691;p=github%2Fwallabag%2Fwallabag.git 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` ( 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;