Fix #6706 - Projects - Edit
authorAlan Knowles <alan@roojs.com>
Wed, 5 May 2021 08:52:10 +0000 (16:52 +0800)
committerAlan Knowles <alan@roojs.com>
Wed, 5 May 2021 08:52:10 +0000 (16:52 +0800)
DataObjects/Core_project_group.php [new file with mode: 0644]
DataObjects/pman.links.ini
sql/core_column_settings.sql [new file with mode: 0644]
sql/core_project.sql
sql/core_project_group.sql [new file with mode: 0644]

diff --git a/DataObjects/Core_project_group.php b/DataObjects/Core_project_group.php
new file mode 100644 (file)
index 0000000..10f8d71
--- /dev/null
@@ -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
index 6e1c70d..ec12fd7 100644 (file)
@@ -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 (file)
index 0000000..e69de29
index b4a7417..d4d0806 100644 (file)
@@ -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 (file)
index 0000000..e52f5f5
--- /dev/null
@@ -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;