|
Revision 108, 0.6 kB
(checked in by d0nut, 5 years ago)
|
- first effort: all packages are installable
- second effort: the concept works
- what follows: the implementation ;)
|
| Line | |
|---|
| 1 | DROP TABLE IF EXISTS wcf1_donation_wishlist; |
|---|
| 2 | CREATE TABLE wcf1_donation_wishlist ( |
|---|
| 3 | wishlistID int(10) unsigned NOT NULL, |
|---|
| 4 | wishlistImageID int(10) unsigned NOT NULL, |
|---|
| 5 | title varchar(80) NOT NULL, |
|---|
| 6 | text text NOT NULL, |
|---|
| 7 | timestamp int(12) NOT NULL, |
|---|
| 8 | userID int(10) unsigned NOT NULL, |
|---|
| 9 | message text NOT NULL, |
|---|
| 10 | PRIMARY KEY (wishlistID) |
|---|
| 11 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
| 12 | |
|---|
| 13 | DROP TABLE IF EXISTS wcf1_donation_wishlist_images; |
|---|
| 14 | CREATE TABLE wcf1_donation_wishlist_images ( |
|---|
| 15 | wishlistImageID int(10) unsigned NOT NULL, |
|---|
| 16 | data MEDIUMBLOB NOT NULL, |
|---|
| 17 | filetype VARCHAR( 50 ) NOT NULL , |
|---|
| 18 | PRIMARY KEY (wishlistImageID) |
|---|
| 19 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
|---|
