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

Timestamp:

07/03/05 12:20:00 (8 years ago)

Author:

fproulx

Message:

2005-07-03 Francois Proulx <francois.proulx@…>

• Updated the XML venues status format ( version 1.0, once approved )
• Added long / lat fields to nodes table ( for mapping purposes )

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', 19);
+define('REQUIRED_SCHEMA_VERSION', 20);
 
 /** Check that the database schema is up to date.  If it isn't, offer to update it. */
@@ -464 +464 @@
         }
         
+        $new_schema_version = 20;
+        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 nodes ADD COLUMN latitude NUMERIC(16, 6);\n";
+            $sql .= "ALTER TABLE nodes ADD COLUMN longitude NUMERIC(16, 6);\n";
+        }
+        
                 $db->ExecSqlUpdate("BEGIN;\n$sql\nCOMMIT;\n", true);
                 echo "</html></head>";