There are various versions of this script and you will need to use the one that matches the dialect of SQL that your database
server uses.
The MySQL version is in mydbcreator.aspx and follows format like:
USE phd1;
DROP TABLE IF EXISTS `ixt_global`;
CREATE TABLE `ixt_global` ( `ID` int(11) NOT NULL auto_increment, `descrip` varchar(50) default NULL, `lastDate` datetime default NULL, `value` int(11) default '0', PRIMARY KEY (`ID`));
INSERT INTO `ixt_global` VALUES (1,'lastrun','2005-01-01',0),(2,'maxresults','2005-01-01',250);
The MS SQL Server version is in msdbcreator.aspx and follows format like:
USE phd1;
DROP TABLE ixt_global;
CREATE TABLE ixt_global (ID int PRIMARY KEY NOT NULL IDENTITY(1,1), descrip varchar(50) default NULL, lastDate datetime default NULL, value int default 0);
SET IDENTITY_INSERT ixt_global ON;
INSERT INTO ixt_global (ID, descrip, lastDate, value) VALUES (1,'lastrun','2005-01-01',0);
INSERT INTO ixt_global (ID, descrip, lastDate, value) VALUES (2,'maxresults','2005-01-01',250);
SET IDENTITY_INSERT ixt_global OFF;
In addition you will have to edit the database connection string to match dbconn.txt see the page on databases.