-- This is included by gregslist.sql
-- These are new tables that haven't existed in association with gregslist (my_contacts)
CREATE TABLE t_job_current
(
	id				INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title			VARCHAR(64),
	salary		INTEGER,
	start_date	DATE
);
DESC t_job_current;

CREATE TABLE t_job_desired
(
	id				INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title			VARCHAR(64),
	salary_low	INTEGER,
	salary_high	INTEGER,
	available	DATE,
	years_exp	INTEGER
);
DESC t_job_desired;

CREATE TABLE t_job_listings
(
	id				INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
	title			VARCHAR(64),
	salary		INTEGER,
	zipcode		VARCHAR(5),
	description	VARCHAR(256)
);
DESC t_job_listings;
