Advanced Search

Return to Snippet

Revision: 66295
at April 12, 2014 01:57 by JordanRowles
Initial Code 
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;
Initial URL 
Project_Manager_DB_Setup
Initial Description 
Sets up the database for my project management software (in development - C#)
Initial Title 
Project Management Database Setup Script
Initial Tags 
mysql, database
Initial Language 
MySQL