Show
Ignore:
Timestamp:
11/24/07 14:31:28 (5 years ago)
Author:
d0nut
Message:
  • first effort: all packages are installable
  • second effort: the concept works
  • what follows: the implementation ;)
Files:
1 modified

Legend:

Unmodified
Added
Removed

  • donation/optionals/de.easy-coding.wcf.donation.wishlist/install.sql

    r91 r108  
     1DROP TABLE IF EXISTS wcf1_donation_wishlist; 
    12CREATE TABLE wcf1_donation_wishlist ( 
    23  wishlistID int(10) unsigned NOT NULL, 
    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, 
    47  timestamp int(12) NOT NULL, 
    58  userID int(10) unsigned NOT NULL, 
    69  message text NOT NULL, 
    7   PRIMARY KEY (code) 
     10  PRIMARY KEY (wishlistID) 
    811) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    912 
    10  
     13DROP TABLE IF EXISTS wcf1_donation_wishlist_images; 
    1114CREATE TABLE wcf1_donation_wishlist_images ( 
    1215  wishlistImageID int(10) unsigned NOT NULL, 
    13   data MEDIUMBLOB NOT NULL 
     16  data MEDIUMBLOB NOT NULL, 
    1417  filetype VARCHAR( 50 ) NOT NULL , 
    1518  PRIMARY KEY (wishlistImageID)