Re: Error 1062 while restoring backup
Posted by:
Subin S
Date: January 20, 2013 11:21PM
Thanks Rick.
Attachments table:
| Attachments | CREATE TABLE `Attachments` (
`id` int(11) NOT NULL auto_increment,
`TransactionId` int(11) NOT NULL,
`Parent` int(11) NOT NULL default '0',
`MessageId` varchar(160) character set ascii default NULL,
`Subject` varchar(255) default NULL,
`Filename` varchar(255) default NULL,
`ContentType` varchar(80) character set ascii default NULL,
`ContentEncoding` varchar(80) character set ascii default NULL,
`Content` longblob,
`Headers` longtext,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Attachments2` (`TransactionId`),
KEY `Attachments3` (`Parent`,`TransactionId`)
) ENGINE=InnoDB AUTO_INCREMENT=871313 DEFAULT CHARSET=utf8 |
Tickets table:
| Tickets | CREATE TABLE `Tickets` (
`id` int(11) NOT NULL auto_increment,
`EffectiveId` int(11) NOT NULL default '0',
`Queue` int(11) NOT NULL default '0',
`Type` varchar(16) character set ascii default NULL,
`IssueStatement` int(11) NOT NULL default '0',
`Resolution` int(11) NOT NULL default '0',
`Owner` int(11) NOT NULL default '0',
`Subject` varchar(200) default '[no subject]',
`InitialPriority` int(11) NOT NULL default '0',
`FinalPriority` int(11) NOT NULL default '0',
`Priority` int(11) NOT NULL default '0',
`TimeEstimated` int(11) NOT NULL default '0',
`TimeWorked` int(11) NOT NULL default '0',
`Status` varchar(10) character set ascii default NULL,
`TimeLeft` int(11) NOT NULL default '0',
`Told` datetime default NULL,
`Starts` datetime default NULL,
`Started` datetime default NULL,
`Due` datetime default NULL,
`Resolved` datetime default NULL,
`LastUpdatedBy` int(11) NOT NULL default '0',
`LastUpdated` datetime default NULL,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
`Disabled` smallint(6) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `Tickets1` (`Queue`,`Status`),
KEY `Tickets2` (`Owner`),
KEY `Tickets6` (`EffectiveId`,`Type`)
) ENGINE=InnoDB AUTO_INCREMENT=276429 DEFAULT CHARSET=utf8 |
Transactions table:
| Transactions | CREATE TABLE `Transactions` (
`id` int(11) NOT NULL auto_increment,
`ObjectType` varchar(64) character set ascii NOT NULL,
`ObjectId` int(11) NOT NULL default '0',
`TimeTaken` int(11) NOT NULL default '0',
`Type` varchar(20) character set ascii default NULL,
`Field` varchar(40) character set ascii default NULL,
`OldValue` varchar(255) default NULL,
`NewValue` varchar(255) default NULL,
`ReferenceType` varchar(255) character set ascii default NULL,
`OldReference` int(11) default NULL,
`NewReference` int(11) default NULL,
`Data` varchar(255) default NULL,
`Creator` int(11) NOT NULL default '0',
`Created` datetime default NULL,
PRIMARY KEY (`id`),
KEY `Transactions1` (`ObjectType`,`ObjectId`)
) ENGINE=InnoDB AUTO_INCREMENT=2277059 DEFAULT CHARSET=utf8 |
Edited 1 time(s). Last edit at 01/20/2013 11:24PM by Subin S.