
DROP TABLE IF EXISTS `0_projects`;
CREATE TABLE IF NOT EXISTS `0_projects` (
    `proj_id` int(11) NOT NULL AUTO_INCREMENT,
    `proj_name` varchar(100) NOT NULL,
    `proj_description` varchar(100) DEFAULT NULL,
    `proj_type` tinyint(1) NOT NULL DEFAULT 0,
    `created_date` date NOT NULL,
    `closed_date` date DEFAULT NULL,
    `begin_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `owner_id` int(11) NOT NULL,
    `closed` tinyint(1) NOT NULL DEFAULT 0,
    PRIMARY KEY (`proj_id`)
) ENGINE=InnoDB;