|
Revision 1, 0.5 kB
(checked in by d0nut, 6 years ago)
|
|
initial release: tape 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 | title varchar(255) NOT NULL DEFAULT '', |
|---|
| 7 | excerpt varchar(255) NOT NULL DEFAULT '', |
|---|
| 8 | url varchar(255) NOT NULL DEFAULT '', |
|---|
| 9 | blog_name varchar(255) NOT NULL DEFAULT '', |
|---|
| 10 | checked datetime NOT NULL, |
|---|
| 11 | errorCount tinyint(1) unsigned NOT NULL, |
|---|
| 12 | isSpam tinyint(1) unsigned NOT NULL, |
|---|
| 13 | PRIMARY KEY (threadID, url) |
|---|
| 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
