<?php
 
 
$user="root";
$password="panda";
$db="cms";
 
mysql_connect(localhost, $user, $password);
 
@mysql_select_db($db) or die (mysql_error());
$sql="CREATE TABLE IF NOT EXISTS cms_access_levels (
 
access_level tinyint (4) NOT NULL auto_increment,
access_name varchar (50) NOT NULL default '',
PRIMARY KEY (access_level)
 
)";
 
$result=mysql_query($sql) or die (mysql_error());
 
mysql_query ("INSERT INTO cms_access_levels (access_level, access_name) VALUES ('1', 'user', '2', 'moderator', '3', 'adminstrator')")
or die (mysql_error());
 
$sql2= "CREATE TABLE IF NOT EXISTS cms_articles (
 
article_id int (11) NOT NULL auto_increment,
author_id int (11) NOT NULL default '0',
is_published tinyint(1) NOT NULL default '0',
date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
date_published datetime NOT NULL default '0000-00-00 00:00:00',
title varchar (255) NOT NULL default '',
body mediumtext NOT NULL,
primary key (article_id),
)";
 
$result=mysql_query($sql2) or die (mysql_error());
 
$sql3="CREATE TABLE IF NOT EXISTS cms_comments (
 
comments_id int (11) NOT NULL auto_increment,
article_id int (11) NOT NULL default '0',
comment_date datetime NOT NULL default '0000-00-00 00:00:00',
comment_user int (11) NOT NULL default '0',
comment text NOT NULL,
PRIMARY KEY (comment_id),
)";
 
$sql4= "CREATE TABLE IF NOT EXISTS cms_users (
 
user_id int (11) NOT NULL auto_increment,
email varchar (255) NOT NULL default '',
password varchar (30) NOT NULL default '',
name varchar (50) NOT NULL default '',
access_level tinyint (4) NOT NULL default '1',
PRIMARY KEY (user_id),
)";
 
$result=mysql_query ($sql) or die (mysql_error());
 
$adminemail="yakzuaman@hotmail.co.uk";
$adminpass="panda2";
$adminname="tony";
 
mysql_query ("INSERT IGNORE INTO cms_users VALUES (NULL, '$adminemail', '$adminpass', '$adminname', '3',)") or die (mysql_error());
 
 
?>