rendered paste body/* PAGE = INIT.PHP */
<?
/**************************************
INITIALIZE DATABASE AND ENTER
CREATE TABLES IF NONEXISTANT:
Users, Tickets, Problems, Solutions
**************************************/
mysql_connect("localhost", "efritz", "zarathustra");
mysql_select_db("support_ticket");
mysql_query("CREATE TABLE IF NOT EXISTS users
(email varchar(50), primary key(email))");
mysql_query("CREATE TABLE IF NOT EXISTS tickets
(ticket int not null auto_increment, primary key(ticket), email varchar(50), subject varchar(100), problem varchar(255), solution varchar(255), category varchar(10), status varchar(4), timestamp date)");
?>