require_once ('baza/baza.php');

$sql = <<
CREATE TABLE IF NOT EXISTS cms_access_levels (
access_lvl tinyint(4) NOT NULL auto_increment,
access_name varchar(50) NOT NULL default '' ,
PRIMARY KEY (access_lvl)
)EOS;


$result = mysql_query($sql)
or die(mysql_error());


$sql = "INSERT INGNORE INTO cms_access_levels " .
"VALUES (1,'Użytkownik'), " .
"(2,'Moderator'), " .
"(3,'Administrator')";


$result = mysql_query($sql)
or die(mysql_error());

$sql = <<
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),
KEY IdxArticle (author_id,date_submitted),
FULLTEXT KEY IdxText (title.body)
)EOS;

$result = mysql_query($sql)
or die (mysql_error());

$sql = <<
CREATE TABLE IF NOT EXISTS cms_comments (
comment_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),
KEY IdxComment (article_id)
)EOS;

$result = mysql_query($sql)
or die (mysql_error());

$sql = <<
CREATE TABLE IF NOT EXISTS cms_users (
user_id int(11) NOT NULL auto_increment,
email varchar(255) NOT NULL default '' ,
passwd varchar(50) NOT NULL default '' ,
name varchar(100) NOT NULL default '' ,
access_lvl tinyint(4) NOT NULL default '1' ,
PRIMARY KEY (user_id),
UNIQUE KEY uniq_email (email)
)EOS;

$result = mysql_query($sql)
or die (mysql_error());

$adminemail = "admin@witryna.pl";
$adminpass = "admin";
$adminname = "admin";

$sql = "INSERT IGNORE INTO cms_users" .
"VALUES (NULL, '$adminemail' , '$adminpass' , '$adminname' , 3)";

$result = mysql_query($sql)
or die (mysql_error());

echo "Tabele dla CMS zostały utworzone. Oto początkowe informacje wymagane do zalogowania:\n";
echo "

• Nazwa użytkownika: " . $adminemail . "\n";
  echo "
• Hasło: " . $adminpass . "

\n";

?>