Advanced Search

Project Management Database Setup Script

/ Published in: MySQL
Save to your folder(s)
Sets up the database for my project management software (in development - C#)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE DATABASE myprojectmanager;
  2. USE myprojectmanager;
  3.  
  4. CREATE TABLE project_information(
  5.         id			INT         NOT NULL AUTO_INCREMENT,
  6. 	project_name	 	VARCHAR(50) NOT NULL,
  7. 	start_date		DATETIME    NOT NULL,
  8. 	end_date		DATETIME        NULL,
  9. 	description		TEXT        NOT NULL,
  10. 	current_version	 	DOUBLE      NOT NULL,
  11. 	active		     	BIT         NOT NULL,
  12. 	last_updated     	DATETIME    NOT NULL,
  13. 	local_repository 	VARCHAR(60) NOT NULL,
  14. 	git_repository	 	VARCHAR(60)     NULL,
  15. 	working_repository      VARCHAR(60) NOT NULL,
  16. 	priority 		INT         NOT NULL,
  17. 	stage 			INT         NOT NULL,
  18. 	dependency 	        INT         NOT NULL,
  19. 	PRIMARY KEY (id)
  20. )ENGINE=InnoDB;

URL: Project_Manager_DB_Setup

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.