Current time: 11-17-2024, 04:07 AM Hello There, Guest! (LoginRegister)


Post Reply 
Emergency help ! I accidentally droped a table of IspCP
Author Message
suriv520 Offline


Posts: 2
Joined: Mar 2011
Reputation: 0
Post: #1
Emergency help ! I accidentally droped a table of IspCP
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 !
03-15-2011 11:43 AM
Find all posts by this user Quote this message in a reply
mydebians Offline
Junior Member
*

Posts: 27
Joined: Apr 2007
Reputation: 0
Post: #2
RE: Emergency help ! I accidentally droped a table of IspCP
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`)
) ;
03-16-2011 06:52 AM
Find all posts by this user Quote this message in a reply
suriv520 Offline


Posts: 2
Joined: Mar 2011
Reputation: 0
Post: #3
RE: Emergency help ! I accidentally droped a table of IspCP
Thks a lot !
03-16-2011 10:26 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)