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

Timestamp:

07/19/07 16:29:48 (5 years ago)

Author:

benoitg

Message:

UIUserList fixes:

• Node::getRecentUsers(): Get the 5 most recent users, not some random users in the last week. Also, exclude users currently logged-in.
• Node::getActiveUsers(): Function was unbearably slow, now limit the search space to the last 3 months. Get the 5 user who connected on the most differents days, instead of users with the worst wireless card ;)
• schema_validate.php: Add index for timestamp_in on connection table.

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', 55);
+define('REQUIRED_SCHEMA_VERSION', 56);
 /** Used to test a new shecma version before modyfying the database */
 define('SCHEMA_UPDATE_TEST_MODE', false);
@@ -1283 +1283 @@
         $sql .= "ALTER TABLE nodes ALTER COLUMN last_heartbeat_sys_load SET DEFAULT NULL;\n";
      }
+     
+     $new_schema_version = 56;
+     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 .= "CREATE INDEX idx_connections_timestamp_in ON connections (timestamp_in);\n";
+     }
+     
     /*
      $new_schema_version = ;