From: Alan <alan@roojs.com>
Date: Fri, 30 Dec 2022 03:37:11 +0000 (+0800)
Subject: change to use parent id
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=602bc1a350c428109dd57d4eaca768e6cf1f7a74

change to use parent id
---

diff --git a/DataObjects/pman.links.ini b/DataObjects/pman.links.ini
index 8b29a404..ec531e17 100644
--- a/DataObjects/pman.links.ini
+++ b/DataObjects/pman.links.ini
@@ -24,6 +24,7 @@ logo_id = Images:id
 owner_id = core_person:id
 main_office_id = core_office:id
 comptype_id = core_enum:id
+parent_id = core_company:id
 
 [core_office]
 company_id = core_company:id
diff --git a/sql/core_company.sql b/sql/core_company.sql
index cd082d2f..e6309533 100644
--- a/sql/core_company.sql
+++ b/sql/core_company.sql
@@ -33,6 +33,10 @@ ALTER TABLE core_company ADD COLUMN    country varchar(4) NOT NULL DEFAULT '';
 ALTER TABLE core_company ADD COLUMN    comptype varchar(32)  NOT NULL DEFAULT '';
 -- not sure if this needs to change.. << there is code in core/update that fills this in??
 ALTER TABLE core_company ADD COLUMN    comptype_id INT(11) DEFAULT 0;
+
+ALTER TABLE core_company ADD COLUMN parent_id NOT NULL DEFAULT 0;
+
+
  
 ALTER TABLE core_company CHANGE COLUMN isOwner isOwner int(11);
 ALTER TABLE core_company CHANGE COLUMN comptype comptype  VARCHAR(32) DEFAULT '';
@@ -41,6 +45,10 @@ ALTER TABLE core_company CHANGE COLUMN comptype comptype  VARCHAR(32) DEFAULT ''
 ALTER TABLE core_company ALTER owner_id SET DEFAULT 0;
 ALTER TABLE core_company ALTER url SET DEFAULT '';
 
+
+
+
+
 ALTER TABLE core_company ADD COLUMN    address1 text ;
 ALTER TABLE core_company ADD COLUMN    address2 text ;
 ALTER TABLE core_company ADD COLUMN    address3 text ;