hello again, I am building an install script for my CMS, and I was wondering if this sql would work. I kept the semi colons, but I ddon't know if they need to be kept or removed, any ideas?
<?
$sql = "
CREATE TABLE `".$_SESSION['Install']['pre']."Article_Comments` (
`Comment_ID` bigint(10) NOT NULL auto_increment,
`Story_ID` tinyint(10) NOT NULL default '0',
`Comment_Author` varchar(255) NOT NULL default '',
`Comment_Date` varchar(255) NOT NULL default '',
`Comment_Time` int(50) NOT NULL default '0',
`Comment_Content` longtext NOT NULL,
PRIMARY KEY (`Comment_ID`),
FULLTEXT KEY `Comment` (`Comment_Content`)
) ENGINE=InnoDB AUTO_INCREMENT;
........SESSION['Install']['pre']."smilies` VALUES (3, '(idea)', 'lightbulb.gif');
INSERT INTO `".$_SESSION['Install']['pre']."smilies` VALUES (2, '(!)', 'exclamation.gif');
INSERT INTO `".$_SESSION['Install']['pre']."smilies` VALUES (1, ':-S', 'confused.gif');
CREATE TABLE `".$_SESSION['Install']['pre']."stats_today` (
`year` int(50) NOT NULL default '0',
`month` int(50) NOT NULL default '0',
`date` int(50) NOT NULL default '0',
`hour` int(50) NOT NULL default '0',
`hits` int(50) NOT NULL default '0'
) ENGINE=InnoDB;
CREATE TABLE `".$_SESSION['Install']['pre']."topics` (
`id` bigint(5) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`img` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT;
CREATE TABLE `".$_SESSION['Install']['pre']."user_groups` (
`group_id` bigint(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`group_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT;
CREATE TABLE `".$_SESSION['Install']['pre']."users` (
`user_id` bigint(11) NOT NULL auto_increment,
`username` varchar(25) NOT NULL default '',
`root_admin` tinyint(5) NOT NULL default '0',
`user_email` varchar(255) NOT NULL default '',
`user_website` varchar(255) NOT NULL default '',
`user_avatar` varchar(255) NOT NULL default '',
`user_regdate` varchar(255) NOT NULL default '',
`user_group` int(10) NOT NULL default '0',
`user_icq` varchar(15) default NULL,
`user_occ` varchar(100) default NULL,
`user_from` varchar(255) default NULL,
`user_interests` mediumtext NOT NULL,
`user_sig` mediumtext,
`user_viewemail` tinyint(2) default NULL,
`user_theme` varchar(255) NOT NULL default 'BlueBaby',
`user_aim` varchar(18) default NULL,
`user_yim` varchar(25) default NULL,
`user_msnm` varchar(25) default NULL,
`user_password` varchar(40) NOT NULL default '',
`newsletter` int(1) NOT NULL default '0',
`user_posts` int(10) NOT NULL default '0',
`user_level` int(10) NOT NULL default '1',
`user_active` int(50) NOT NULL default '0',
`user_lang` varchar(255) NOT NULL default 'english',
`last_ip` varchar(15) NOT NULL default '0',
`user_security_question` varchar(255) NOT NULL default '',
`user_security_answer` varchar(255) NOT NULL default '',
`verify_code` varchar(255) NOT NULL default '',
`applied` int(11) NOT NULL default '0',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=2;
INSERT INTO `".$_SESSION['Install']['pre']."users` VALUES (1, 'Guest', 0, 'Guest@mysite.com', '', '', '', 0, NULL, NULL, NULL, '', NULL, NULL, 'PHPublisher', NULL, NULL, NULL, 'Guest', 0, 0, 0, 0, '".$_SESSION['Install']['Language']."', '', '', '', '', 0);
";
?>
