<?php
include("inc/config.php");
$q = mysql_query("
CREATE TABLE `accountinfo` (
`accountid` VARCHAR(255) NOT NULL default '',
`secquestion` varchar(255) NOT NULL default '',
`secanswer` varchar(255) NOT NULL default '',
`gender` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '0',
`dob` varchar(100) default 'MM/DD/YYYY' NOT NULL,
PRIMARY KEY (`accountid`)
) TYPE=MyISAM;
") or die(mysql_error());
if($q){
echo "Created table `accountinfo` Successfully... Please Wait...<br />";
}else{
echo "Failed to create table `accountinfo`... Please Wait";
echo "<meta http-equiv='Refresh' content='2; URL=index.php'/>";
}
$q2 = mysql_query("
CREATE TABLE `messages` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 255 ) NULL,
`message` TEXT NOT NULL ,
`from` INT( 11 ) NOT NULL ,
`to` INT( 11 ) NOT NULL ,
`from_viewed` BOOL NOT NULL DEFAULT '0',
`to_viewed` BOOL NOT NULL DEFAULT '0',
`from_deleted` BOOL NOT NULL DEFAULT '0',
`to_deleted` BOOL NOT NULL DEFAULT '0',
`from_vdate` DATETIME NULL ,
`to_vdate` DATETIME NULL ,
`from_ddate` DATETIME NULL ,
`to_ddate` DATETIME NULL ,
`created` DATETIME NOT NULL
) ENGINE = MYISAM;
") or die(mysql_error());
if($q2){
echo "Created table `messages` Successfully... Please Wait...";
echo "<meta http-equiv='Refresh' content='2; URL=index.php'/>";
}else{
echo "Failed to create table `messages`... Please Wait";
echo "<meta http-equiv='Refresh' content='2; URL=index.php'/>";
}
?>