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