+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Emergency help ! I accidentally droped a table of IspCP (/thread-13069.html)
Emergency help ! I accidentally droped a table of IspCP - suriv520 - 03-15-2011 11:43 AM
Anybody help ?
Just now , I accidentally droped the orders table of IspCP through PMA.
It a serious mistake.
Who can help me to export the orders table through the PMA and post it?
I think I can CREATE it with your help .
Sorry for my pool English , Ths !
RE: Emergency help ! I accidentally droped a table of IspCP - mydebians - 03-16-2011 06:52 AM
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`)
) ;RE: Emergency help ! I accidentally droped a table of IspCP - suriv520 - 03-16-2011 10:26 AM
Thks a lot !