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

Timestamp:

02/22/10 17:51:28 (2 years ago)

Author:

gbastien

Message:

Added a forgotten constraint to the hotspot_graph_element_has_content table to fix #701

Files:

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

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

@@ -48 +48 @@
  * Define current database schema version
  */
-define('REQUIRED_SCHEMA_VERSION', 68);
+define('REQUIRED_SCHEMA_VERSION', 69);
 /** Used to test a new shecma version before modyfying the database */
 define('SCHEMA_UPDATE_TEST_MODE', false);
@@ -1525 +1525 @@
     }
     
-    
+    $new_schema_version = 69;
+    if ($schema_version < $new_schema_version && $new_schema_version <= $targetSchema) {
+        printUpdateVersion($new_schema_version);
+        $sql .= "\n\nUPDATE schema_info SET value='$new_schema_version' WHERE tag='schema_version';\n";
+        $sql .= "\n\nALTER TABLE hotspot_graph_element_has_content ADD CONSTRAINT contentfk FOREIGN KEY (content_id) REFERENCES content(content_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+    }
+   
     /*
      $new_schema_version = ;