Changeset 1261 for trunk/wifidog-auth/sql/wifidog-postgres-schema.sql

Timestamp:

07/21/07 00:59:33 (5 years ago)

Author:

benoitg

Message:

• At long last, implement #9: Automatic new node creation. When attempting to login from an unknown node, the user (if he has the permissions) will be prompted to create the node, or "steal" en existing one (for hardware swaps).
• Refactor Node:getSelectNodeUI().
• Menu.php: Fix small oversight causing menu not to clear.

Files:

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

trunk/wifidog-auth/sql/wifidog-postgres-schema.sql

@@ -532 +532 @@
     is_splash_only_node boolean DEFAULT false,
     custom_portal_redirect_url text,
-    gw_id text NOT NULL
+    gw_id text NOT NULL,
+    last_heartbeat_sys_uptime integer,
+    last_heartbeat_wifidog_uptime integer,
+    last_heartbeat_sys_memfree integer,
+    last_heartbeat_sys_load real
 );
 
@@ -1158 +1162 @@
 
 --
+-- Name: idx_connections_timestamp_in; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+--
+
+CREATE INDEX idx_connections_timestamp_in ON connections USING btree (timestamp_in);
+
+
+--
 -- Name: idx_connections_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
 --