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

Timestamp:

06/29/05 23:04:21 (8 years ago)

Author:

fproulx

Message:

2005-06-17 Francois Proulx <francois.proulx@…>

• Added IFrame and SimpleIFrame content types.

Files:

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

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

@@ -27 +27 @@
 require_once BASEPATH.'classes/AbstractDb.php';
 require_once BASEPATH.'classes/Session.php';
-define('REQUIRED_SCHEMA_VERSION', 18);
+define('REQUIRED_SCHEMA_VERSION', 19);
 
 /** Check that the database schema is up to date.  If it isn't, offer to update it. */
@@ -451 +451 @@
         }
         
+        $new_schema_version = 19;
+        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 .= "CREATE TABLE iframes (";
+            $sql .= "iframes_id text NOT NULL PRIMARY KEY REFERENCES content ON DELETE CASCADE ON UPDATE CASCADE,";
+            $sql .= "url text,";
+            $sql .= "width int4,";
+            $sql .= "height int4";
+            $sql .= ");\n";
+        }
+        
                 $db->ExecSqlUpdate("BEGIN;\n$sql\nCOMMIT;\n", true);
                 echo "</html></head>";