From: Alan Knowles <alan@roojs.com>
Date: Wed, 5 May 2021 06:06:16 +0000 (+0800)
Subject: sql/core_project_group.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=81da632cc8eabc6c29878927868db847dfdfb64c

sql/core_project_group.sql
---

diff --git a/sql/core_project_group.sql b/sql/core_project_group.sql
index 057562dd..cd11d8bc 100644
--- a/sql/core_project_group.sql
+++ b/sql/core_project_group.sql
@@ -3,4 +3,7 @@ CREATE TABLE core_project_group (
   id int(11) NOT NULL auto_increment,
   PRIMARY KEY  (id)
   
-) ;
+);
+
+ALTER TABLE  core_project  ADD COLUMN   group_id int(11) default NULL default 0;
+ALTER TABLE  core_project  ADD COLUMN   project_id int(11) default NULL default 0;