From a7df42e556c2e11720b0f90abf83c7d13f93b670 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Wed, 5 May 2021 16:52:10 +0800
Subject: [PATCH] Fix #6706 - Projects - Edit

---
 DataObjects/Core_project_group.php | 11 +++++++++++
 DataObjects/pman.links.ini         |  5 +++++
 sql/core_column_settings.sql       |  0
 sql/core_project.sql               |  2 +-
 sql/core_project_group.sql         |  9 +++++++++
 5 files changed, 26 insertions(+), 1 deletion(-)
 create mode 100644 DataObjects/Core_project_group.php
 create mode 100644 sql/core_column_settings.sql
 create mode 100644 sql/core_project_group.sql

diff --git a/DataObjects/Core_project_group.php b/DataObjects/Core_project_group.php
new file mode 100644
index 00000000..10f8d716
--- /dev/null
+++ b/DataObjects/Core_project_group.php
@@ -0,0 +1,11 @@
+<?php
+/**
+ */
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
+
+class Pman_Core_DataObjects_Core_project_group extends DB_DataObject 
+{
+  
+    public $__table = 'core_project_group'; 
+  
+}
\ No newline at end of file
diff --git a/DataObjects/pman.links.ini b/DataObjects/pman.links.ini
index 6e1c70df..ec12fd76 100644
--- a/DataObjects/pman.links.ini
+++ b/DataObjects/pman.links.ini
@@ -92,6 +92,11 @@ template_id = core_template:id
 [core_template_element]
 template_id = core_template:id
 
+[core_project_group]
+project_id = core_project:id
+group_id = core_group:id
+
+
 [database__render]
 core_project = name
 core_company= name
diff --git a/sql/core_column_settings.sql b/sql/core_column_settings.sql
new file mode 100644
index 00000000..e69de29b
diff --git a/sql/core_project.sql b/sql/core_project.sql
index b4a74177..d4d0806f 100644
--- a/sql/core_project.sql
+++ b/sql/core_project.sql
@@ -32,4 +32,4 @@ ALTER TABLE core_project ADD INDEX lookup_agency_id (agency_id);
 
 ALTER TABLE core_project ADD INDEX lookup_open_by (open_by);
 ALTER TABLE core_project ADD INDEX lookup_owner_id (owner_id);
- 
\ No newline at end of file
+
diff --git a/sql/core_project_group.sql b/sql/core_project_group.sql
new file mode 100644
index 00000000..e52f5f55
--- /dev/null
+++ b/sql/core_project_group.sql
@@ -0,0 +1,9 @@
+
+CREATE TABLE core_project_group (
+  id int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (id)
+  
+);
+
+ALTER TABLE  core_project_group  ADD COLUMN   group_id int(11) default NULL default 0;
+ALTER TABLE  core_project_group  ADD COLUMN   project_id int(11) default NULL default 0;
-- 
2.39.2