Brightdayler
Search engine checker
 
ASPX script for creating Brightdayler tables
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.

Home/Set Up/dbCreate Script
Menu for non Javascript users and search engines
All site Copyright © 1996-2005 PHD Computer Consultants Ltd, phdcc