Changeset 36 for trackback/install.sql

Timestamp:

10/01/07 21:30:41 (6 years ago)

Author:

d0nut

Message:

finished all known TODOs. Outgoing links are filtered. Outgoing trackbacks are logged. The difference is recognized.

Files:

• trackback/install.sql (modified) (2 diffs)

trackback/install.sql

@@ -1 +1 @@
 ALTER TABLE wbb1_1_post ADD hasTrackback TINYINT(1) UNSIGNED NOT NULL;
 
+--incoming
 CREATE TABLE wbb1_1_trackback (
   postID int(10) unsigned NOT NULL,
@@ -14 +15 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+--outgoing
 CREATE TABLE wbb1_1_trackbackLog (
   postID int(10) unsigned NOT NULL,
   alienURL varchar(255) NOT NULL DEFAULT '',
   timestamp int(12) NOT NULL DEFAULT 0,
-  message varchar(255) NOT NULL DEFAULT '',
   PRIMARY KEY (postID, alienUrl)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;