Soln. for MySql 1005 (Can't create table)
Add the followings in front and rear of the script
At front
SET FOREIGN_KEY_CHECKS = 0;
At Rear
SET FOREIGN_KEY_CHECKS = 1;
Sample query:
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `mailings`;
CREATE TABLE `mailings` (
mailingid INTEGER NOT NULL,
brandid INTEGER NOT NULL,
campaignid INTEGER UNSIGNED NOT NULL,
mailingcategoryid INTEGER UNSIGNED NOT NULL,
mailingname VARCHAR(255) NOT NULL,
mailingdesc VARCHAR(500) NULL,
issplited VARCHAR(3) NOT NULL DEFAULT 'no',
limitbyconfirmation VARCHAR(25) NOT NULL,
maxrecipients INTEGER UNSIGNED NULL,
isforwardtofriend VARCHAR(3) NULL,
forwardtofriendurl TEXT NULL,
mailingcontenttype VARCHAR(10) NOT NULL,
templateid INTEGER UNSIGNED NULL,
totalrecipients INTEGER UNSIGNED NULL,
isactive VARCHAR(3) NOT NULL DEFAULT 'yes',
createdon DATE NOT NULL,
createdby INTEGER NOT NULL,
updatedon DATE NULL,
updatedby INTEGER NULL,
deletedon DATE NULL,
deletedby INTEGER NULL,
PRIMARY KEY (`mailingid`),
KEY `mailingcategoryid` (`mailingcategoryid`),
KEY `campaignid` (`campaignid`),
KEY `brandid` (`brandid`),
CONSTRAINT `mailings_ibfk_1` FOREIGN KEY (`mailingcategoryid`) REFERENCES `mailingcategory` (`mailingcategoryid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `mailings_ibfk_2` FOREIGN KEY (`campaignid`) REFERENCES `campaign` (`campaignid`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `mailings_ibfk_3` FOREIGN KEY (`brandid`) REFERENCES `brandmaster` (`brandid`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET FOREIGN_KEY_CHECKS = 1;