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

Timestamp:

08/28/06 00:40:29 (6 years ago)

Author:

benoitg

Message:

• clickthrough.php, HyperLink?.php: Implement working hyperlink

clickthrough tracking (no reporting yet).

Works for Langstring, FlickrPhotoStream?, Picture,

RssAggregator? and their subclasses.

• Make HTMLeditor inherit from Langstring. Allowed a massive

reduction of line count and will stop the codebases from needlessly
drifting apart.

• Do not log content displayed as metadata, and log their

clickthrough as the parent's.

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', 42);
+define('REQUIRED_SCHEMA_VERSION', 43);
 
 /**
@@ -888 +888 @@
         }
 
+        $new_schema_version = 43;
+        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 .= "CREATE TABLE content_clickthrough_log ( \n";
+            $sql .= "  user_id text REFERENCES users (user_id) ON UPDATE CASCADE ON DELETE CASCADE,\n";
+            $sql .= "  content_id text NOT NULL REFERENCES content ON UPDATE CASCADE ON DELETE CASCADE,\n";
+            $sql .= "  clickthrough_timestamp timestamp NOT NULL DEFAULT now(),\n";
+            $sql .= "  node_id text NOT NULL REFERENCES nodes ON UPDATE CASCADE ON DELETE CASCADE,\n";
+            $sql .= "  destination_url text NOT NULL CHECK (destination_url<>'')\n";
+            $sql .= ");\n";
+        }
+        
         /*
         $new_schema_version = 43;