Changeset 1351 for trunk/wifidog-auth/sql/wifidog-postgres-initial-data.sql

Timestamp:

06/11/08 02:10:17 (2 years ago)

Author:

benoitg

Message:

• Authenticator.php: Fix SQL error closing connections.
• auth/index.php: Probably fix the "Access denied" message when user click twice problem that resurfaced.
• At long last, implement operational Dynamic abuse control (out of the embryo of the token architecture)! Configurable in Network preferences if you have the permissions. Unlike static limits, this is a sliding window (typically a month) during which user have a bandwidth and connection duration limit, per node, and totalled throughout the network.
• UIAllowedBandwidth: New, simplistic content type to show the user how much of his allocation he consumed. Off course, the goal is actually to make it into a pretty graph....

Files:

• trunk/wifidog-auth/sql/wifidog-postgres-initial-data.sql (modified) (2 diffs)

trunk/wifidog-auth/sql/wifidog-postgres-initial-data.sql

@@ -197 +197 @@
 INSERT INTO virtual_hosts (virtual_host_id, hostname, default_network) VALUES ('DEFAULT_VHOST', 'localhost', 'default-network');
 INSERT INTO server (server_id, default_virtual_host) VALUES ('SERVER_ID', 'DEFAULT_VHOST');
-INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_SYSADMIN', 'Server');
-INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_SYSADMIN', 'Network');
+INSERT into roles (role_id, stakeholder_type_id) VALUES ('SERVER_OWNER', 'Server');
+INSERT into roles (role_id, stakeholder_type_id) VALUES ('NETWORK_OWNER', 'Network');
 --
 -- PostgreSQL database dump
@@ -215 +215 @@
 --
 
-INSERT INTO schema_info (tag, value) VALUES ('schema_version', '56');
+INSERT INTO schema_info (tag, value) VALUES ('schema_version', '61');