gistfile1.txt

CREATE TABLE `job` (
	`id` INT(10) UNSIGNED NOT NULL,
	`title` VARCHAR(255) NOT NULL,
	`location` VARCHAR(255) NULL DEFAULT NULL,
	`description` TEXT NOT NULL,
	`status` ENUM('DRAFT','PENDING','PUBLISHED','REJECTED','FILLED') NOT NULL,
	`contact_email` VARCHAR(255) NOT NULL,
	`email` VARCHAR(255) NULL DEFAULT NULL,
	`email_subject_prefix` VARCHAR(255) NULL DEFAULT NULL,
	`adverstiser_name` VARCHAR(255) NULL DEFAULT NULL,
	`advertiser_url` VARCHAR(255) NULL DEFAULT NULL,
	`question_1` TEXT NOT NULL,
	`question_2` TEXT NOT NULL,
	`question_3` TEXT NOT NULL,
	`external_id` VARCHAR(255) NULL DEFAULT NULL,
	`published_at` DATETIME NULL DEFAULT NULL,
	`updated_at` DATETIME NULL DEFAULT NULL,
	`create_at` DATETIME NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE INDEX `job_external_id_uk` (`external_id`)
)
ENGINE=InnoDB
;