From: Alan Knowles <alan@roojs.com>
Date: Fri, 7 Oct 2016 05:38:19 +0000 (+0800)
Subject: MOVED sql/core_projects.sql to sql/core_project.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=7e79065ac5e76dc3a01f527d3fabf41abd79dbaa

MOVED sql/core_projects.sql to sql/core_project.sql
---

diff --git a/sql/core_project.sql b/sql/core_project.sql
new file mode 100644
index 00000000..16df2f8f
--- /dev/null
+++ b/sql/core_project.sql
@@ -0,0 +1,29 @@
+
+CREATE TABLE Projects (
+  id int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (id)
+  
+) ;
+
+
+
+ALTER TABLE  Projects  ADD COLUMN name varchar(254)  NOT NULL  DEFAULT '';
+ALTER TABLE  Projects  ADD COLUMN   remarks text ;
+ALTER TABLE  Projects  ADD COLUMN   owner_id int(11) default NULL;
+ALTER TABLE  Projects  ADD COLUMN   code varchar(32)  NOT NULL  DEFAULT '';
+ALTER TABLE  Projects  ADD COLUMN   active int(11) default '1';
+ALTER TABLE  Projects  ADD COLUMN   type varchar(1)  NOT NULL default 'P';
+ALTER TABLE  Projects  ADD COLUMN   client_id int(11) NOT NULL default '0';
+ALTER TABLE  Projects  ADD COLUMN   team_id int(11) NOT NULL default '0';
+ALTER TABLE  Projects  ADD COLUMN file_location varchar(254)    NOT NULL default '';
+ALTER TABLE  Projects  ADD COLUMN open_date date default NULL;
+ALTER TABLE  Projects  ADD COLUMN open_by int(11) NOT NULL default '0';
+ALTER TABLE  Projects  ADD COLUMN updated_dt DATETIME NOT NULL;
+
+-- these should be removed, as they are code specific..
+ALTER TABLE Projects ADD COLUMN countries varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE Projects  ADD COLUMN languages varchar(128)  NOT NULL DEFAULT '';
+ALTER TABLE  Projects ADD COLUMN agency_id int(11)  NOT NULL DEFAULT 0 ;
+
+ALTER TABLE Projects ADD INDEX plookup (code);
+ 
\ No newline at end of file