Post by UncommonTrend » Sun Aug 25, 2013 3:09 am

Alright, so -- I was in the phpMyAdmin area of my server and I kind of messed up on something: I deleted the oc_profile table. Could somebody tell me the values of everything under this table, or at least explain how to restore it? I don't have a backup because my store exceeds the maximum gbs for a backup on my server.

Please help. I've noticed that with this table missing, everybody who is online cannot access the site.

Newbie

Posts

Joined
Thu Jul 25, 2013 7:35 am

Post by MarketInSG » Sun Aug 25, 2013 9:55 am

Code: Select all

CREATE TABLE `oc_profile` (
  `profile_id` int(11) NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `frequency` enum('day','week','semi_month','month','year') NOT NULL,
  `duration` int(10) unsigned NOT NULL,
  `cycle` int(10) unsigned NOT NULL,
  `trial_status` tinyint(4) NOT NULL,
  `trial_price` decimal(10,4) NOT NULL,
  `trial_frequency` enum('day','week','semi_month','month','year') NOT NULL,
  `trial_duration` int(10) unsigned NOT NULL,
  `trial_cycle` int(10) unsigned NOT NULL,
  PRIMARY KEY (`profile_id`)
) ENGINE=MyISAM COLLATE=utf8_general_ci;


User avatar
Guru Member

Posts

Joined
Wed Nov 16, 2011 11:53 am
Location - Singapore
Who is online

Users browsing this forum: No registered users and 48 guests