[Summary view] [Print] [Text view]

   1  #
   2  # PHPWCMS database update script
   3  # ==============================
   4  # 22-04-2003
   5  
   6  # extending structure category for direct redirect link
   7  ALTER TABLE `phpwcms_articlecat` ADD `acat_redirect` VARCHAR( 255 ) NOT NULL ;
   8  
   9  # table for new content part BID
  10  CREATE TABLE `phpwcms_bid` (
  11    `bid_id` int(11) NOT NULL auto_increment,
  12    `bid_cid` int(11) NOT NULL default '0',
  13    `bid_email` text NOT NULL,
  14    `bid_hash` varchar(255) NOT NULL default '',
  15    `bid_amount` float NOT NULL default '0',
  16    `bid_created` timestamp(14) NOT NULL,
  17    `bid_verified` int(1) NOT NULL default '0',
  18    `bid_trashed` int(1) NOT NULL default '0',
  19    `bid_vars` mediumblob NOT NULL,
  20    PRIMARY KEY  (`bid_id`)
  21  ) TYPE=MyISAM AUTO_INCREMENT=1 ;