Merge commit 'origin/master' into hruid

[platal.git] / upgrade / 0.9.16 / 08_forums.sql

diff --git a/upgrade/0.9.16/08_forums.sql b/upgrade/0.9.16/08_forums.sql
index f208a2a..00af187 100644 (file)
--- a/upgrade/0.9.16/08_forums.sql
+++ b/upgrade/0.9.16/08_forums.sql
@@ -1,4 +1,6 @@
-CREATE TABLE `forums.innd` (
+USE forums;
+
+CREATE TABLE IF NOT EXISTS `innd` (
   `id_innd` int(10) unsigned NOT NULL auto_increment,
   `ipmin` int(10) unsigned default '0' COMMENT 'ip_address',
   `ipmax` int(10) unsigned default '4294967295' COMMENT 'ip_address',
@@ -10,4 +12,4 @@ CREATE TABLE `forums.innd` (
   PRIMARY KEY  (`id_innd`)
 ) DEFAULT CHARSET=utf8;
 
-INSERT INTO `forums.innd` VALUES (1,0,4294967295,NULL,'xorg.*,!xorg.prive.*','xorg.*,!xorg.prive.*,!xorg.pa.emploi',0,'par defaut pour tous');
+INSERT INTO `innd` VALUES (1,0,4294967295,NULL,'xorg.*,!xorg.prive.*','xorg.*,!xorg.prive.*,!xorg.pa.emploi',0,'par defaut pour tous');