Mine

CREATE TABLE `z_shop_offer` (  `id` int(11) NOT NULL auto_increment,  `points` int(11) NOT NULL default '0',  `itemid1` int(11) NOT NULL default '0',  `count1` int(11) NOT NULL default '0',  `itemid2` int(11) NOT NULL default '0',  `count2` int(11) NOT NULL default '0',  `offer_type` varchar(255) default NULL,  `offer_description` text NOT NULL,  `offer_name` varchar(255) NOT NULL,  PRIMARY KEY  (`id`));