|
Revision 91, 493 bytes
(checked in by d0nut, 6 years ago)
|
|
two new plugins for codeentries and wishlist
|
| Line | |
|---|
| 1 | CREATE TABLE wcf1_donation_wishlist ( |
|---|
| 2 | wishlistID int(10) unsigned NOT NULL, |
|---|
| 3 | wishlistID int(10) unsigned NOT NULL, |
|---|
| 4 | timestamp int(12) NOT NULL, |
|---|
| 5 | userID int(10) unsigned NOT NULL, |
|---|
| 6 | message text NOT NULL, |
|---|
| 7 | PRIMARY KEY (code) |
|---|
| 8 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 9 | |
|---|
| 10 | |
|---|
| 11 | CREATE TABLE wcf1_donation_wishlist_images ( |
|---|
| 12 | wishlistImageID int(10) unsigned NOT NULL, |
|---|
| 13 | data MEDIUMBLOB NOT NULL |
|---|
| 14 | filetype VARCHAR( 50 ) NOT NULL , |
|---|
| 15 | PRIMARY KEY (wishlistImageID) |
|---|
| 16 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
