<?php

/*
* Dati connessione
*/
$hostname = '';
$username = '';
$password = '';
$database = '';

/*
*Admin setting
*/
$admin_username = '';
$admin_password = '';
$admin_email    = '';
$admin_permesso = '3'; // Non modificare!

$md5_adminpass = md5($admin_password);

$connect = mysql_connect($hostname, $username, $password);
mysql_select_db($database, $connect);

mysql_query("CREATE TABLE `users` (
                                `id` INT NOT NULL AUTO_INCREMENT,
                                `permesso` ENUM( '1', '2', '3'),
                                `username` VARCHAR ( 20 ) NOT NULL,
                                `password` VARCHAR ( 40 ) NOT NULL,
                                `email` VARCHAR( 40 ) NOT NULL,
                                PRIMARY KEY ( `id` ))");

mysql_query("CREATE TABLE `post` (
                               `id` INT NOT NULL AUTO_INCREMENT,
                               `titolo` VARCHAR( 40 ) NOT NULL,
                               `testo` TEXT NOT NULL,
                               `autore` VARCHAR( 40 ) NOT NULL,
                               `date` DATE NOT NULL,
                               PRIMARY KEY ( `id` ))");

mysql_query("CREATE TABLE `comment` (
                                  `id` INT NOT NULL AUTO_INCREMENT,
                                  `post_id` INT NOT NULL,
                                  `testo` TEXT NOT NULL,
                                  `autore` VARCHAR( 40 ) NOT NULL,
                                  `date` DATE NOT NULL,
                                  `app` ENUM( '0', '1') NOT NULL,
                                  PRIMARY KEY( `id` ))");

mysql_query("INSERT INTO users (id, permesso, username, password, email)
             VALUES ('1', '$admin_permesso', '$admin_username', '$md5_adminpass', '$admin_email')
            ");

mysql_close($connect);

include('complete.htm');

?>