Changeset 450 for wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/MySQL.pm

Timestamp:

07/12/08 01:49:47 (4 years ago)

Author:

dom

Message:

Cater for the case where the index being added in MySQL schema 10 was manually created in the database beforehand

Files:

• wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/MySQL.pm (modified) (2 diffs)

wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/MySQL.pm

@@ -179 +179 @@
 
 my %upgrades = (
-'9_to_10' => [ qq|
-CREATE UNIQUE INDEX node_name ON node (name)
-|, qq|
+    '9_to_10' => [ sub {
+        my $dbh = shift;
+        my $sth = $dbh->prepare('SHOW INDEX FROM node WHERE key_name="node_name"');
+        $sth->execute();
+        unless ( $sth->rows ) {
+            $dbh->do('CREATE UNIQUE INDEX node_name ON node (name)')
+                or croak $dbh->errstr;
+        }
+    },
+    qq|
 ALTER TABLE content ADD COLUMN verified datetime default NULL
 |, qq|
@@ -187 +194 @@
 |, qq|
 UPDATE schema_info SET version = 10
-|
-],
+| ]
+
 );