Posted By

JordanRowles on 04/12/14


Tagged

mysql database project software setup management


Versions (?)

Project Management Database Setup Script


 / Published in: MySQL
 

URL: Project_Manager_DB_Setup

Sets up the database for my project management software (in development - C#)

  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;

Report this snippet  

You need to login to post a comment.