DROP TABLE IF EXISTS probid_bulktmp; CREATE TABLE `probid_bulktmp` ( `id` int(11) NOT NULL auto_increment, `userid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `desc` longtext NOT NULL, `category` varchar(40) NOT NULL default '', `category2` varchar(40) NOT NULL default '', `qty` int(11) NOT NULL default '0', `auctiontype` varchar(20) NOT NULL default '', `currency` varchar(40) NOT NULL default '', `price` double(16,2) NOT NULL default '0.00', `usereserve` char(1) NOT NULL default '', `reserve` double(16,2) NOT NULL default '0.00', `usebuynow` char(1) NOT NULL default '', `buynow` double(16,2) NOT NULL default '0.00', `useinc` char(1) NOT NULL default '', `inc` double(16,2) NOT NULL default '0.00', `duration` varchar(10) NOT NULL default '', `whopays` varchar(40) NOT NULL default '', `shipinter` char(1) NOT NULL default '', `paydirect` text NOT NULL, `paymethods` text NOT NULL, `postcosts` double(16,2) NOT NULL default '0.00', `postnote` varchar(255) NOT NULL default '', `service` varchar(250) NOT NULL default '', `insurance` double(16,2) NOT NULL default '0.00', `homefeat` char(1) NOT NULL default '', `homefeatdesc` longtext NOT NULL, `catfeat` char(1) NOT NULL default '', `bold` char(1) NOT NULL default '', `highlight` char(1) NOT NULL default '', `private` char(1) NOT NULL default '', `relist` char(1) NOT NULL default '0', `relistalways` char(1) NOT NULL default '0', `relisttimes` varchar(255) NOT NULL default '', `allowswap` char(1) NOT NULL default '', `voucher` varchar(250) NOT NULL default '', `hasimage` varchar(10) NOT NULL default '', `pictures` longtext NOT NULL, `auctionstore` varchar(40) NOT NULL default 'auction', `movie` longtext NOT NULL, `usebuyout` char(1) NOT NULL default '', `buyout1` double(16,2) NOT NULL default '0.00', `buyout2` double(16,2) NOT NULL default '0.00', `customdata` text NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=60 ; -- -- Dumping data for table `probid_bulktmp` --