Changeset 34 for trackback/install.sql

Timestamp:

09/30/07 22:26:19 (6 years ago)

Author:

d0nut

Message:

updated trackback to 0.0.4 - from now on we also support pingbacks.
for that reason i took some gpl licensed code from the wordpress project.
this version does not work. there are some TODOs.

Files:

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

trackback/install.sql

@@ -1 +1 @@
 ALTER TABLE wbb1_1_post ADD hasTrackback TINYINT(1) UNSIGNED NOT NULL;
-ALTER TABLE wbb1_1_post ADD trackbackUrls TEXT NOT NULL DEFAULT '';
 
 CREATE TABLE wbb1_1_trackback (
@@ -15 +14 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+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;