JordanRowles on 04/12/14
Last Edited at 04/12/14 01:57am
CREATE DATABASE myprojectmanager;USE myprojectmanager; CREATE TABLE project_information( id INT NOT NULL AUTO_INCREMENT, project_name VARCHAR(50) NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME NULL, description TEXT NOT NULL, current_version DOUBLE NOT NULL, active BIT NOT NULL, last_updated DATETIME NOT NULL, local_repository VARCHAR(60) NOT NULL, git_repository VARCHAR(60) NULL, working_repository VARCHAR(60) NOT NULL, priority INT NOT NULL, stage INT NOT NULL, dependency INT NOT NULL, PRIMARY KEY (id))ENGINE=InnoDB;
URL: Project_Manager_DB_Setup
Report this snippet Tweet
Comment:
You need to login to post a comment.