Changeset 574 for trunk/wifidog-auth/wifidog/include/schema_validate.php

Timestamp:

04/25/05 16:07:04 (8 years ago)

Author:

fproulx

Message:

2005-04-25 Fran�ois Proulx <francois.proulx@…>

• More stylesheets work

Files:

• trunk/wifidog-auth/wifidog/include/schema_validate.php (modified) (2 diffs)

trunk/wifidog-auth/wifidog/include/schema_validate.php

@@ -29 +29 @@
 require_once BASEPATH.'classes/AbstractDb.php';
 require_once BASEPATH.'classes/Session.php';
-define('REQUIRED_SCHEMA_VERSION', 11);
+define('REQUIRED_SCHEMA_VERSION', 12);
 
 /** Check that the database schema is up to date.  If it isn't, offer to update it. */
@@ -366 +366 @@
             
         } 
+        
+        $new_schema_version = 12;
+        if($schema_version < $new_schema_version)
+        {
+            echo "<h2>Preparing SQL statements to update schema to version  $new_schema_version</h2>\n";
+            $sql .= "\n\nUPDATE schema_info SET value='$new_schema_version' WHERE tag='schema_version';\n"; 
+            $sql .= "ALTER TABLE flickr_photostream DROP CONSTRAINT flickr_photostream_content_group_fkey;";
+            $sql .= "ALTER TABLE flickr_photostream ADD CONSTRAINT flickr_photostream_content_fkey FOREIGN KEY (flickr_photostream_id) REFERENCES content (content_id) ON UPDATE CASCADE ON DELETE CASCADE;";
+        }
+        
                 $db->ExecSqlUpdate("BEGIN;\n$sql\nCOMMIT;\n", true);
                 echo "</html></head>";