HI
Code:
CREATE TABLE IF NOT EXISTS `orders` (
`id` int(10) unsigned NOT NULL auto_increment,
`user_id` int(10) unsigned NOT NULL default '0',
`plan_id` int(10) unsigned NOT NULL default '0',
`date` int(10) unsigned NOT NULL default '0',
`domain_name` varchar(200) collate utf8_unicode_ci default NULL,
`customer_id` varchar(200) collate utf8_unicode_ci default NULL,
`fname` varchar(200) collate utf8_unicode_ci default NULL,
`lname` varchar(200) collate utf8_unicode_ci default NULL,
`gender` varchar(1) collate utf8_unicode_ci default NULL,
`firm` varchar(200) collate utf8_unicode_ci default NULL,
`zip` varchar(10) collate utf8_unicode_ci default NULL,
`city` varchar(200) collate utf8_unicode_ci default NULL,
`state` varchar(200) collate utf8_unicode_ci default NULL,
`country` varchar(200) collate utf8_unicode_ci default NULL,
`email` varchar(200) collate utf8_unicode_ci default NULL,
`phone` varchar(200) collate utf8_unicode_ci default NULL,
`fax` varchar(200) collate utf8_unicode_ci default NULL,
`street1` varchar(200) collate utf8_unicode_ci default NULL,
`street2` varchar(200) collate utf8_unicode_ci default NULL,
`status` varchar(255) collate utf8_unicode_ci default NULL,
PRIMARY KEY (`id`)
) ;