DROP TABLE IF EXISTS Department;

CREATE TABLE Department (
	dept_id SERIAL,
	name VARCHAR(255) NOT NULL,
	description VARCHAR(255) NOT NULL

);

DROP TABLE IF EXISTS Content_Type;

CREATE TABLE Content_Type (
	type_id SERIAL,
	name VARCHAR(255) NOT NULL

);

DROP TABLE IF EXISTS Content;

CREATE TABLE Content (
	content_id 	SERIAL,
	dept_id 	INT NOT NULL,
	content_type 	INT NOT NULL,
	title 		VARCHAR(255) NOT NULL,
	description 	TEXT NOT NULL,
	bid_date 	DATE,
	create_date 	TIMESTAMP
			DEFAULT now() NOT NULL,
	created_by 	VARCHAR(255) NOT NULL,
	last_upd_date 	TIMESTAMP NOT NULL,
	last_update_by 	VARCHAR(255) NOT NULL	

);

DROP TABLE IF EXISTS Dept_User;

CREATE TABLE Dept_User (
	user_name 	VARCHAR(255)
	UNIQUE NOT NULL,
	dept_id INT NOT NULL,
	contact_name VARCHAR(255) NOT NULL,
	company_name VARCHAR(255) NOT NULL,
	address VARCHAR(255) NOT NULL,
	city VARCHAR(255) NOT NULL,
	state VARCHAR(255) NOT NULL,
	zip VARCHAR(255) NOT NULL,
	password VARCHAR(255) NOT NULL,
	create_date TIMESTAMP
	DEFAULT now() NOT NULL,
	email VARCHAR(255),
	contact_phone VARCHAR (255),
	fax VARCHAR(255)

);

DROP TABLE IF EXISTS Content_Download;

CREATE TABLE Content_Download (
	download_id SERIAL,
	content_id INT(6) NOT NULL,
	file_name VARCHAR(255) NOT NULL
);


2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:

    * In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
    * Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
    * If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
    * In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".
    * If you are using Hardened-PHP, you might want to increase request limits.
    * The directory specified in the php.ini directive session.save_path does not exist or is read-only.