Changeset 709

Timestamp:

09/03/05 12:43:21 (8 years ago)

Author:

aprilp

Message:

Added last_paged to table 'nodes'

Location:

trunk/wifidog-auth

Files:

• ChangeLog (modified) (1 diff)
• wifidog/include/schema_validate.php (modified) (2 diffs)

trunk/wifidog-auth/ChangeLog

@@ +1 @@
+2005-09-03 Philippe April  <philippe@ilesansfil.org>
+        * Schema change: Added last_paged column to nodes table
+
 2005-09-01 Benoit Grégoire  <bock@step.polymtl.ca>
         WARNING:  DO NOT use the CVS auth server in production until further notice.  

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

@@ -28 +28 @@
 require_once BASEPATH.'classes/AbstractDb.php';
 require_once BASEPATH.'classes/Session.php';
-define('REQUIRED_SCHEMA_VERSION', 26);
+define('REQUIRED_SCHEMA_VERSION', 27);
 
 /** Check that the database schema is up to date.  If it isn't, offer to update it. */
@@ -597 +597 @@
                         $sql .= ");\n";
                 }
+
+                $new_schema_version = 27;
+                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 last_paged timestamp;\n";
+
+                }
+
                 $db->ExecSqlUpdate("BEGIN;\n$sql\nCOMMIT;\n", true);
                 //$db->ExecSqlUpdate("BEGIN;\n$sql\nROLLBACK;\n", true);