[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[16384] trunk

[<sy...@us...>]

Revision: 16384
          http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=16384&view=rev
Author:   sylvieg
Date:     2009-01-23 15:23:35 +0000 (Fri, 23 Jan 2009)

Log Message:
-----------
[FIX] for mysql4

Modified Paths:
--------------
    trunk/db/tiki-3.0-mysql.sql
    trunk/db/tiki-3.0-mysqli.sql
    trunk/db/tiki-3.0-oci8.sql
    trunk/db/tiki-3.0-pgsql.sql
    trunk/db/tiki-3.0-sqlite.sql
    trunk/db/tiki-3.0-sybase.sql
    trunk/db/tiki.sql
    trunk/installer/schema/20090120_sefurl_rules_tiki.sql

Modified: trunk/db/tiki-3.0-mysql.sql
===================================================================
--- trunk/db/tiki-3.0-mysql.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-mysql.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -3755,7 +3755,7 @@
   `comment` varchar(256),
   `order` int(11) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left` (`left`(256)),
   INDEX `idx1` (silent, type, feature(30))
 );
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki');

Modified: trunk/db/tiki-3.0-mysqli.sql
===================================================================
--- trunk/db/tiki-3.0-mysqli.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-mysqli.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -3755,7 +3755,7 @@
   `comment` varchar(256),
   `order` int(11) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left` (`left`(256)),
   INDEX `idx1` (silent, type, feature(30))
 );
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki');

Modified: trunk/db/tiki-3.0-oci8.sql
===================================================================
--- trunk/db/tiki-3.0-oci8.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-oci8.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -5583,7 +5583,7 @@
   `comment` varchar(256),
   `order` number(11) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left` (`left`(256)),
   "INDEX" `idx1` (silent, type, feature(30))
 );
 

Modified: trunk/db/tiki-3.0-pgsql.sql
===================================================================
--- trunk/db/tiki-3.0-pgsql.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-pgsql.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -4895,10 +4895,10 @@
   "comment" varchar(256),
   "order" bigint NULL default 0,
   PRIMARY KEY ("id"),
-  UNIQUE KEY (left),
   "INDEX" idx1 (silent, type, feature(30))
 );
 
+CREATE UNIQUE INDEX "tiki_sefurl_regex_out_left" ON "tiki_sefurl_regex_out"(substr("left", 0, 256));
 INSERT INTO "tiki_sefurl_regex_out" ("left","right","type","feature") VALUES ('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki');
 
 INSERT INTO "tiki_sefurl_regex_out" ("left","right","type","feature") VALUES ('tiki-slideshow.php\\?page=(.+)', 'show:$1', '', 'feature_wiki');

Modified: trunk/db/tiki-3.0-sqlite.sql
===================================================================
--- trunk/db/tiki-3.0-sqlite.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-sqlite.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -4906,7 +4906,7 @@
   comment varchar(256),
   order bigint NULL default 0,
   PRIMARY KEY(id),
-  UNIQUE KEY (left),
+  UNIQUE KEY left (left(256)),
   "INDEX" idx1 (silent, type, feature(30))
 );
 

Modified: trunk/db/tiki-3.0-sybase.sql
===================================================================
--- trunk/db/tiki-3.0-sybase.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki-3.0-sybase.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -7320,7 +7320,7 @@
   `comment` varchar(256),
   `order` numeric(11,0) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left` (`left`(256)),
   "INDEX" `idx1` (silent, type, feature(30))
 )
 go

Modified: trunk/db/tiki.sql
===================================================================
--- trunk/db/tiki.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/db/tiki.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -3755,7 +3755,7 @@
   `comment` varchar(256),
   `order` int(11) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left` (`left`(256)),
   INDEX `idx1` (silent, type, feature(30))
 );
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki');

Modified: trunk/installer/schema/20090120_sefurl_rules_tiki.sql
===================================================================
--- trunk/installer/schema/20090120_sefurl_rules_tiki.sql	2009-01-23 15:02:43 UTC (rev 16383)
+++ trunk/installer/schema/20090120_sefurl_rules_tiki.sql	2009-01-23 15:23:35 UTC (rev 16384)
@@ -9,7 +9,7 @@
   `comment` varchar(256),
   `order` int(11) NULL default 0,
   PRIMARY KEY(`id`),
-  UNIQUE KEY (`left`),
+  UNIQUE KEY `left`(`left`(256)),
   INDEX `idx1` (silent, type, feature(30))
 );
 INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki');


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.