Missing database tables

[cbolt]

Hi

 

Unfortunatly I've lost some tables due to InnoDB corruption and my backups are broken too.

Luckily they are not important tables and WHMCS still runs OK.

 

Could someone who is still running version 5.3.14 please post the structure for the following tables so I can re-build them:

 

tbldomainreminders

tblticketfeedback

tbltickettags

tbltransientdata

[PropelMWS]

Sure thing cbolt,

 

The 4 table structures you need are:

 

 

== tbldomainreminders ==

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for tbldomainreminders

-- ----------------------------

DROP TABLE IF EXISTS `tbldomainreminders`;

CREATE TABLE `tbldomainreminders` (

 `id` int(10) NOT NULL AUTO_INCREMENT,

 `domain_id` int(10) NOT NULL,

 `date` date NOT NULL,

 `recipients` text NOT NULL,

 `type` tinyint(4) NOT NULL,

 `days_before_expiry` tinyint(4) NOT NULL,

 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=4211 DEFAULT CHARSET=utf8;

== tbltransientdata ==

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for tbltransientdata

-- ----------------------------

DROP TABLE IF EXISTS `tbltransientdata`;

CREATE TABLE `tbltransientdata` (

 `id` int(10) NOT NULL AUTO_INCREMENT,

 `name` varchar(1024) NOT NULL,

 `data` text NOT NULL,

 `expires` int(10) NOT NULL,

 PRIMARY KEY (`id`),

 KEY `name` (`name`(255))

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

 

 

== tbltickettags ==

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for tbltickettags

-- ----------------------------

DROP TABLE IF EXISTS `tbltickettags`;

CREATE TABLE `tbltickettags` (

 `id` int(10) NOT NULL AUTO_INCREMENT,

 `ticketid` int(10) NOT NULL,

 `tag` text NOT NULL,

 PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

== tblticketfeedback ==

 

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for tblticketfeedback

-- ----------------------------

DROP TABLE IF EXISTS `tblticketfeedback`;

CREATE TABLE `tblticketfeedback` (

 `id` int(10) NOT NULL AUTO_INCREMENT,

 `ticketid` int(10) NOT NULL,

 `adminid` int(10) NOT NULL,

 `rating` int(2) NOT NULL,

 `comments` text NOT NULL,

 `datetime` datetime NOT NULL,

 `ip` text NOT NULL,

 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=799 DEFAULT CHARSET=latin1;

 

Best,

Trevor~

[cbolt]

Thanks heaps!!