include("common.php");
$link = mysql_connect($dbhost, $dbuser, $dbpassword) OR die("Could not connect: " . mysql_error());
mysql_select_db($dbname);
mysql_query("DROP TABLE IF EXISTS `t_Banners`") OR die("Oops t_Banners: ".mysql_error());
mysql_query("CREATE TABLE `t_Banners` (
`n_ID` bigint(20) NOT NULL auto_increment,
`n_UserID` bigint(20) default NULL,
`b_Authorised` tinyint(4) default '0',
`s_URL` char(80) default NULL,
`s_Graphic` char(80) default NULL,
`n_Category` int(11) default NULL,
`n_Displays` bigint(20) default '0',
`n_Clicks` bigint(20) default '0',
`n_ExpireViews` bigint(20) default '0',
`n_ExpireClicks` bigint(20) default '0',
`b_Paid` tinyint(4) default '0',
PRIMARY KEY (`n_ID`)
) TYPE=MyISAM;") OR die("Oops t_Banners: ".mysql_error());
mysql_query("DROP TABLE IF EXISTS `t_Categories`") OR die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Categories` (
`n_ID` int(11) NOT NULL auto_increment,
`n_ParentID` int(11) default NULL,
`s_Name` char(32) default NULL,
`b_Selectable` tinyint(4) default NULL,
PRIMARY KEY (`n_ID`)
) TYPE=MyISAM;") OR die("Oops: ".mysql_error());
mysql_query("DROP TABLE IF EXISTS `t_Stats`") OR die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Stats` (
`n_ID` int(11) NOT NULL default '0',
`s_Name` varchar(32) NOT NULL default '',
`s_Description` varchar(64) NOT NULL default '',
`n_Value` bigint(20) NOT NULL default '0',
UNIQUE KEY `n_ID` (`n_ID`)
) TYPE=MyISAM;") OR die ("Oops: ".mysql_error());
mysql_query("INSERT INTO `t_Stats` VALUES (0, 'totalviews', 'Banners served to date', 0);") OR die ("Oops this: ".mysql_error());
mysql_query("DROP TABLE IF EXISTS `t_Users`") OR die("Oops: ".mysql_error());
mysql_query("CREATE TABLE `t_Users` (
`n_ID` bigint(20) NOT NULL auto_increment,
`s_Username` char(16) default NULL,
`s_Password` char(16) default NULL,
`n_Credits` float(20,2) default NULL,
`s_Email` char(32) default NULL,
`n_Views` bigint(20) default NULL,
`n_Clicks` bigint(20) default NULL,
`n_Rand` int(11) default NULL,
`b_Authedban` tinyint(4) default '0',
`b_Admin` tinyint(4) default '0',
`b_Newsletter` tinyint(4) default NULL,
`b_Activated` tinyint(4) default '0',
`n_RefererID` bigint(20) default NULL,
`logged_ip` varchar(50) NOT NULL default '',
PRIMARY KEY (`n_ID`)
) TYPE=MyISAM;") OR die ("Oops: ".mysql_error());
mysql_query("INSERT INTO `t_Users` VALUES (1, 'admin', 'admin', '10000000.00', 'your@site.com', 0, 0, 905, 0, 1, 1, 1, 1, 1);") OR die ("Oops this: ".mysql_error());
$q1 = "DROP TABLE IF EXISTS job_banners_m";
mysql_query($q1) OR die(mysql_error()." job_banners_m drop: at line ".__LINE__);
$q1 = "CREATE TABLE job_banners_m (
bc char(1) NOT NULL default '')";
mysql_query($q1) OR die(mysql_error()." job_banners_m: at line ".__LINE__);
$q1 = "DROP TABLE IF EXISTS job_banners_t";
mysql_query($q1) OR die(mysql_error()." job_banners_t drop: at line ".__LINE__);
$q1 = "CREATE TABLE job_banners_t (
b_id varchar(10) NOT NULL default '',
fn varchar(100) NOT NULL default '',
burl varchar(100) NOT NULL default '',
alt varchar(255) default NULL)";
mysql_query($q1) OR die(mysql_error()."job_banners_t: at line ".__LINE__);