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

Timestamp:

08/31/06 07:31:33 (7 years ago)

Author:

benoitg

Message:

• Server.php: Make sure getCurrentServer returns the default server if the hostname isn't recognised.
• Content manager:

-Allow deleting simple (trivial) but persistent content
-Remove the sponsor info field from Content Metadata. Best practices is now to use the project info field to show this information.

• Add the necessary schema constraints to allow manually deleting networks, nodes and users. Be carefull, removing any of theses will remove all traces of connection statistics as well. You've been warned.
• Do not display the network in the login interface if there is only one.
• Add a pseudo-random content ordering mode. Pick content elements randomly, but do not display the same content twice untill all content has been seen.
• Allow setting a title but not displaying it (very usefull for reusable content)

Files:

• trunk/wifidog-auth/wifidog/include/schema_validate.php (modified) (2 diffs)

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

@@ -47 +47 @@
  * Define current database schema version
  */
-define('REQUIRED_SCHEMA_VERSION', 44);
+define('REQUIRED_SCHEMA_VERSION', 45);
 
 /**
@@ -909 +909 @@
         }
 
+        $new_schema_version = 45;
+        if ($schema_version < $new_schema_version) {
+            printUpdateVersion($new_schema_version);
+            $sql .= "\n\nUPDATE schema_info SET value='$new_schema_version' WHERE tag='schema_version';\n";
+            $sql .= "ALTER TABLE content DROP COLUMN sponsor_info;\n";
+            $sql .= "ALTER TABLE users DROP CONSTRAINT account_origin_fkey;\n";
+            $sql .= "ALTER TABLE users ADD CONSTRAINT account_origin_fkey FOREIGN KEY (account_origin) REFERENCES networks (network_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+            $sql .= "ALTER TABLE nodes DROP CONSTRAINT network_id_fkey;\n";
+            $sql .= "ALTER TABLE nodes ADD CONSTRAINT network_id_fkey FOREIGN KEY (network_id) REFERENCES networks (network_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                $sql .= "ALTER TABLE users DROP CONSTRAINT check_account_origin_not_empty;\n";
+                $sql .= "ALTER TABLE connections DROP CONSTRAINT fk_nodes;\n";
+                $sql .= "ALTER TABLE connections ADD CONSTRAINT fk_nodes FOREIGN KEY (node_id) REFERENCES nodes (node_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                $sql .= "ALTER TABLE connections DROP CONSTRAINT fk_users;\n";
+                $sql .= "ALTER TABLE connections ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                $sql .= "ALTER TABLE node_stakeholders DROP CONSTRAINT \"$2\";\n";
+                $sql .= "ALTER TABLE node_stakeholders ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                        $sql .= "ALTER TABLE network_stakeholders DROP CONSTRAINT \"$1\";\n";   
+                        $sql .= "ALTER TABLE network_stakeholders ADD CONSTRAINT fk_network FOREIGN KEY (network_id) REFERENCES networks (network_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                        $sql .= "ALTER TABLE network_stakeholders DROP CONSTRAINT \"$2\";\n";
+                        $sql .= "ALTER TABLE network_stakeholders ADD CONSTRAINT fk_users FOREIGN KEY (user_id) REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE;\n";
+                        $sql .= "ALTER TABLE content ADD COLUMN title_is_displayed bool;\n";
+                        $sql .= "ALTER TABLE content ALTER COLUMN title_is_displayed SET DEFAULT true;\n";
+            $sql .= "UPDATE content SET title_is_displayed=true;\n";            
+            $sql .= "ALTER TABLE content ALTER COLUMN title_is_displayed SET NOT NULL;\n\n";
+                                
+        
+        }
         /*
         $new_schema_version = 44;