/* 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)");
?>