projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
d9e530d
)
change to use parent id
author
Alan
<alan@roojs.com>
Fri, 30 Dec 2022 03:37:11 +0000
(11:37 +0800)
committer
Alan
<alan@roojs.com>
Fri, 30 Dec 2022 03:37:11 +0000
(11:37 +0800)
DataObjects/pman.links.ini
patch
|
blob
|
history
sql/core_company.sql
patch
|
blob
|
history
diff --git
a/DataObjects/pman.links.ini
b/DataObjects/pman.links.ini
index
8b29a40
..
ec531e1
100644
(file)
--- 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
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
[core_office]
company_id = core_company:id
diff --git
a/sql/core_company.sql
b/sql/core_company.sql
index
cd082d2
..
e630953
100644
(file)
--- 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 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 '';
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 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 ;
ALTER TABLE core_company ADD COLUMN address1 text ;
ALTER TABLE core_company ADD COLUMN address2 text ;
ALTER TABLE core_company ADD COLUMN address3 text ;