diff options
| author | Lester Caine <lester@lsces.co.uk> | 2026-05-26 19:52:14 +0100 |
|---|---|---|
| committer | Lester Caine <lester@lsces.co.uk> | 2026-05-26 19:52:14 +0100 |
| commit | ecc4499b657e1ccb65835e42007174f0352fcb8b (patch) | |
| tree | 5c9fe043db4c74b8442eb840cf4d4fe7a050826a /admin | |
| parent | 86e4180e484068f5a3d2be924a383ba0611f42e8 (diff) | |
| download | stock-ecc4499b657e1ccb65835e42007174f0352fcb8b.tar.gz stock-ecc4499b657e1ccb65835e42007174f0352fcb8b.tar.bz2 stock-ecc4499b657e1ccb65835e42007174f0352fcb8b.zip | |
Add kitlocker xref group and items to stockassembly schema defaults
KLPR (price) and KLURL (datasheet URL) in the kitlocker group,
assembly-only (stockassembly content_type_guid), both single-value.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Diffstat (limited to 'admin')
| -rwxr-xr-x | admin/schema_inc.php | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index d927f4a..c11455c 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -172,6 +172,11 @@ foreach( [ 'stockcomponent', 'stockassembly' ] as $guid ) { $xrefItems[] = "INSERT INTO `{$X}liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`,`data`) VALUES ('PKG','{$guid}','values','Package/Footprint', 0,3,'','text',NULL)"; } +// stockassembly kitlocker group — price and datasheet URL from KitLocker +$xrefTypes[] = "INSERT INTO `{$X}liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('kitlocker','stockassembly','KitLocker Details',1,3,'')"; +$xrefItems[] = "INSERT INTO `{$X}liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`,`data`) VALUES ('KLPR', 'stockassembly','kitlocker','Kitlocker Price',0,3,'','text',NULL)"; +$xrefItems[] = "INSERT INTO `{$X}liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`,`data`) VALUES ('KLURL','stockassembly','kitlocker','Details URL', 0,3,'','text',NULL)"; + // stockmovement xref — requisition reference links $xrefTypes[] = "INSERT INTO `{$X}liberty_xref_group` (`x_group`,`content_type_guid`,`title`,`sort_order`,`role_id`,`type_href`) VALUES ('reference','stockmovement','Reference',1,3,'')"; $xrefItems[] = "INSERT INTO `{$X}liberty_xref_item` (`item`,`content_type_guid`,`x_group`,`cross_ref_title`,`multiple`,`role_id`,`cross_ref_href`,`template`,`data`) VALUES ('REQN','stockmovement','reference','Requisition',1,3,'','text',NULL)"; |