|
Revision 29, 0.6 kB
(checked in by d0nut, 6 years ago)
|
|
many, many updates in trackback mod. bis step to 0.0.2
|
| Line | |
|---|
| 1 | ALTER TABLE wbb1_1_post ADD hasTrackback TINYINT(1) UNSIGNED NOT NULL; |
|---|
| 2 | ALTER TABLE wbb1_1_post ADD trackbackUrls TEXT NOT NULL DEFAULT ''; |
|---|
| 3 | |
|---|
| 4 | CREATE TABLE wbb1_1_trackback ( |
|---|
| 5 | postID int(10) unsigned NOT NULL, |
|---|
| 6 | postURL varchar(255) NOT NULL DEFAULT '', |
|---|
| 7 | title varchar(255) NOT NULL DEFAULT '', |
|---|
| 8 | excerpt varchar(255) NOT NULL DEFAULT '', |
|---|
| 9 | url varchar(255) NOT NULL DEFAULT '', |
|---|
| 10 | blog_name varchar(255) NOT NULL DEFAULT '', |
|---|
| 11 | checked datetime NOT NULL, |
|---|
| 12 | errorCount tinyint(1) unsigned NOT NULL, |
|---|
| 13 | isSpam tinyint(1) unsigned NOT NULL, |
|---|
| 14 | PRIMARY KEY (threadID, url) |
|---|
| 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
