Mine

CREATE TABLE `z_shop_history_item` (  `id` int(11) NOT NULL auto_increment,  `to_name` varchar(255) NOT NULL default '0',  `to_account` int(11) NOT NULL default '0',  `from_nick` varchar(255) NOT NULL,  `from_account` int(11) NOT NULL default '0',  `price` int(11) NOT NULL default '0',  `offer_id` int(11) NOT NULL default '0',  `trans_state` varchar(255) NOT NULL,  `trans_start` int(11) NOT NULL default '0',  `trans_real` int(11) NOT NULL default '0',  PRIMARY KEY  (`id`));