I am running CF9 64bit on windows 7. I created the database on mySQL 5.6 server. I created the datasource, theough the CF Admin, for kalendar and it verified. I then tried using the following code to create 2 table, but I recevied an error that just says "Error!" when I tried running the script. I posted the script on mySQL forums and was told the code ran fine. What am I not seeing?
<cfquery name="qCreateTable" datasource="kalendar">
CREATE TABLE tblkalendar (
EventID varchar(100) NOT NULL,
CategoryID int(10) NOT NULL,
IsDeleted tinyint(1) NOT NULL default '0',
IsPublished tinyint(1) NOT NULL default '0',
IsFeatured tinyint(1) NOT NULL default '0',
DateTimeCreated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
StartDate datetime NOT NULL,
EndDate datetime NOT NULL,
StartTime varchar(50) default NULL,
EndTime varchar(50) default NULL,
ContactPhone varchar(50) default NULL,
ContactName varchar(100) default NULL,
ContactEmail varchar(50) default NULL,
Title varchar(150) NOT NULL,
Location varchar(150) default NULL,
Teaser varchar(350) default NULL,
ExternalURL varchar(500) character set utf8 default NULL,
Description longtext NOT NULL,
PRIMARY KEY (EventID),
KEY IX_tblKalendar (StartDate,EndDate),
KEY FK_tblKalendar_tblKalendarCategories (CategoryID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE tblkalendarcategories (
CategoryID int(10) NOT NULL auto_increment,
CategoryName varchar(50) NOT NULL,
CategoryBGColor varchar(7) NULL,
CategoryTextColor varchar(7) NULL,
PRIMARY KEY (CategoryID)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
</cfquery>
