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

Timestamp:

06/12/08 09:56:08 (4 years ago)

Author:

benoitg

Message:

• Use bigint for dynamic abuse control byte values
• UIAllowedBandwidth: Format values in a human-readable way

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', 61);
+define('REQUIRED_SCHEMA_VERSION', 62);
 /** Used to test a new shecma version before modyfying the database */
 define('SCHEMA_UPDATE_TEST_MODE', false);
@@ -1405 +1405 @@
         
     }
-    
+    $new_schema_version = 62;
+    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 .= "ALTER TABLE networks ALTER COLUMN connection_limit_network_max_total_bytes TYPE bigint;\n";
+        $sql .= "ALTER TABLE networks ALTER COLUMN connection_limit_node_max_total_bytes TYPE bigint;\n";
+
+        $sql .= "ALTER TABLE nodes ALTER COLUMN connection_limit_node_max_total_bytes_override TYPE bigint;\n";
+        
+    }
     /*
      $new_schema_version = ;