UPDATE GROUPS SET 
    STATUS = 0,
    DATA = X'504B03041400000008006C64B85825496E753A000000460000000F00000050726F6A656374312E737370726F6A8B76CBCC492D8EE5E502D186B6A1799925867A05C5C9BC5C3E8979E9A589E940410388AC737E695E89AD212F976F62661E482144352F172F1700504B03041400000008006C64B85892CEB6666E070000441D000009000000556E6974312E706375C5595B6C1455189EBD6F97825C14042F19632421D05624415353757BD96643BBDD76B7AD0FE06676F7B48CCCCEB433B3A54D8C1288CA0341880FC660041F309828090FC6048D093E5B89BE888921086A1A90A212959818FCCFEC9CEDDFD933BBB30FC6939C9C3997F9FEEFBF9CFF9C9D95CCB464142445EC9B2585B229E515222664856C0A0A5669817ACE7E762B11A83EE1396B6D8F22190631A2F6D05A68FB75696AAF5CA88E3D489769AAA96B8A11B2C736439BD0F492C1B0DAA0ED9525459BAC0EED8456CE4F97893EE7B7879E85B6980FDABD1E68CB6AB114B3FB496893DDBD12682519249B4E3CBE322B9999822E4F9949754213A2235AD9945562ACF2055352898463B95C6E309E4C41D33226E93235074C46E0D99A0F8F10A3AC98F7F6928222E992296B6A462BEB0592D68CC0BC108DEB9349B54866FD77A3835A519E90891E0997B494A69270BFA2E525251ACBCC19262965E7A6885F888DC9869C9715D99C8B446766D2E5BC2217042196341265B540E15B28668F56564DBFD0DA3D374226A03F2819FBFCC28A0A998A40614D8FA428B20A6BD519A2D257232D8542C62CD2F16572F4AA9C488513D6D06F4E73B5F3E73C28D7B2A6F22A295A61600146B3C9EE61EAB3285599CEC390ED466C8B08DF164BCC42E67479AAC82757F8BFC9452150734588343EBFFD5EF82D71081BA60EAEC40CEE3662B04E9B32E592A4E434BD48F4DC7459525DE2F4889738C56C8A1A08234DB189AA647F1D0A1F36492122AB2699247A531C5A2D025352619F3449F83C3EFEEF7808F70C4AB26A27186772897693BDD28CACE991A8914F41DE83C430AACA6625D0E9D3F6A5F43A00F579A86147DA8DA1E7792BE52D2F4BE268BA5C45B32ED4CB765267C5271CF6154B90174721730EC8795DD2E7D85CC85EEF2CF4FD8085E71316A0BD0B85CDBD2EBCE6CB92D294B5ADB2C512C65AE060F9EDF669A89738F3E634667FA749F6771AB0F7FBBCB3F73B0D6C8F33F6BF0BB53EB07216EBF4428DC08A2376FF98DD325F5352C31C21065148C11487D2ED3D43A3A96C0E7C9A8EF7EC8AF7F78992210E8FC653D96DE2506FFB607F2A978A0FF6899D08F02D0EA038A16B257168A4B76FA48A3494165FD464551C8F8FF465C4715153A940DACB257BC52E71BC1D1A9121AC81FA3607B90349FE8627D9925191DC1BCFC681B6250991A7A258078BE3C1B1E0E982BA96336F4E5322F4E2418367BDC3D95F0B315F6678809D016C38642F759620830280071C504F08BB852C9935B3192B731B41F4CE0D0E567664B40F93FF9E4B3E8C245E73487C18C8C7E18A3043187F8C57B58CAB3182FEE5781B7D315F9F36C133469003C68A08355067FE117BFE88637CC06E29A55738EFDB31CF8ED56D9CD3AD12C59501BA46DCBF97E84464B1D3D5C99ED826A58679CCEFB249B16DB6F83D07CA160E771C28EDFEFA81829DF609D7695164A979CE0AA6E50A26D5E7132E3AA49E04051232518ADD73F488E1297291034DE1C2B64D2E39203F10DA7D71A3A245D6C2C668973868D80DC7DCDC80B57DDFA3B6671CD472A06D1ACEFA92BBB667EA690B40E71C902F08077C7069AC686B61E31DFE17078DEE70ACF1829BC67893DFF237DAE418F2BE8007236E0DD47263BB0A1BB12DD074C8B471A071C8EC0C3413323B5DD068A1C76B6BA036AB3145B055F6B859651DB2CACB1C619C14830D74A079031DE0488920031D7640BE671928A16892596B9FC31C30A612B54F365051AD814ABB9115C29C1FF66028C92438AD1AC41439405D9D56B38DF9A0AB933D794AC4EFB8B90927E25301CF89F814C73C38119F0E784FC4CF70ECB23C1167392B78A9692CD874D08C71A0F1AECA059BD955390E1A76C386A0871CD2E651DB8E60D389B8A39EB600F454B05122C68E7B89EB38A62F55E50DCE8A9AAD7EBC79AF1DE7E0B6084B5E3BE1803C6D792D59F93959EBB6131CB856BBA59B7D36B8E4C6656AD83F775962A046F93CE82931B4A257E61BC0B3B1D550BFACF37590DEFEBE82F93D2EAA50597F369085CF809F83954D8D0BFBD2C0FA8F42FD031611C73A6C92A3A1A64D7232E4CD24F7437DD7B9D0A1F2471EB1D6433DDB00EB338F58F427D4A71C2C6CDE9990BB79D93A2AB325ECBE0E2797CB2197E48277E46F1C52353BF276A8E9CC729B835BDD9100F48F033205996569475AE058E744D8FDFAC1C6A93A29E7671A282BAB9F6AA817D29C159B10428933FFE3E20F57AEDEF8E9E6A27873F1D75FAE88B76F5DB9BE78F5FA42A7889135CE9B58878375FC46D7D1ED4CAD7D28BCDC6F3B20AA65D53435C8BBF40BBAF5F18BF3B5E510473EE67790338FE36563D8C361D4C101E15D68B7879B0E99ED2EF66321D319AE3D8CAA47AF858DB579D34D9B086309D3271C90E3C092FE15836E3918F3AC1B665573A8E71D98DF016656975443B2FE52E0697E9EA3391D62DFDD2E38201F128E2EFD3041D818F3429D68A007C31730FFAA631CEBFAAD175DAF35AFEBB5BABAFA84EB0EC80CE8DAA3954AB2B95C57CCF56F2F5CC391A6B9D2579C6535E2BAC1015900AE1953D2CDE5B8A887AF4B9B39E8E674F5D60CF85B1DF83780728ADE9A1D5CE9A1FB24ACDDE840C3D27635949676488B80B4099D707FFCEE8EB8581C034A1CC004026491B0036A9943AFF20F1BEBC55D56FD0B504B03041400000008006C64B858BFD5D836B00200007507000009000000556E6974312E707363C5555B6FDA30147EAFD4FF70A43ED08E286DB5B7301E52A015DA1A68A1E23132E440BD2536384E2FFFB6AD3669EA5636697F607652E702595F1709ECF87CE73B77278931DEDD01E88424565B0BCE04595ED399DA75389382876A77CA45A4962E25215FA80D9DAE1214F71604530B12164416F44FBA44922989B1B5BBB3BB73438466952B4BFD9265E0C0F855A9A5CF158D1F28BC03B114942DD243BE943422A1CF4580C25F25844907029E4C434CE50C6FD3432BFD5F92D917B240072893B840A120535C50969905A70D41648F315A5EE456534FEA25E25E2F1A628F2E3E29E99DD4C0468C21CE240C86766770E58DFDBEE70FDDCE47F7AC0724868B2BD71B5B30E8DAE7679EEFB9E73D6840336302B59D0B1EC1E0B2DBBBCCB50643F8CC2983897BD91BC10438D3E4FACDEF77A10D135B2D5596149FB174DDB1ABCCA55A25A35ACDBC345A7924EE4CD21BD47148916475D192DB6B1A22302E35A6C7E72AC7C6D86B06CDEB6BCA6A53624A68D5942D0B3C3BD0186512058271B1ED6C3A5B981A1241A2937B8F44B8DFC86107B6EACEB453D26856F629C530A881B9F1A868A832EF3F72A11F134946ADC1157623AE67AF8BBE9EA70699529E869CC8D4A137D3AE0E88C47252639475E6DB4E3625C6EFB69307F83FCA503057C6B6BDA95D24A49F0F74A14BE7B599FE502105798DACD0296E0CED6D195860308CB1AC915F21C57378A88CEFD7598F7850A13D508378943AA173E3A9CAB5AA54657F6A19037A53657C5789AF591156C89105ADED0EAA94712BC3DA0DE3D2DB1D5033035A396FAC26EC1DBFDF3B3E529BC6D7F5E3C3D38F6F2F6B7859FFFEF9007F7E3D3CAF9F9EBF3BFA56D3B7B5E4AA87F68DE1832DCBBD3B9CA9D66F55AA9F89C682B098A851E6CC4CF466CDB7811D1E45743BC03264248990A5838D54566B99A51A604E1909C3E2C3311788F9E59B8EBF3930C531EB5F504B03041400000008006164B858A297D4E806050000A40F00000A000000556E6974312E7E7063759557CB6F1B45189F751C7BED3E68220E2804B43DC00944DA0A044191E23C6B88AD24DE140E28CE7A77924CD987B33B0E31CA09A9E22121C8A1AAD4035CB850A45E38F107C0811BD04B2F282D14A13E9CAA3DC1257CB3BB638F97719A8CF4697667BEF9CDF7FB1EB3B3069D3702D3B0B5E92D6C36A851B3B136436C3C944661CB813453E8C0960551D078A83B691B418003351E1A847ED637EAEBC46C8F0D3335CFA5BE6707FDF1D88BD0CF78BE1370AC97A19F2286EDADB5875E859ED4361AD80F0D624363D05BB574FC360E7DC3B59C7CFC3E0D7D7162CA00564680F5F9999113BA412BA64FEAB4E8AE7A485DF41A94B83838A9A4CB868333F96AB55A2A14CBD0E52E183E61EE80C92C3C87F399451C346CFAF414366DC33728F1DC8AD7F04D3CEF05A96DB5E0AF155D0B6FA5F6D59267915582FD6CC6F1CA9E8B33B3B657336C355F6906143B7AB38E53287F8104A4466C429B59757373BE51B3898950BE18CC345C93A1E718E6A4D770690A1D9F682EE255782F19C1FB29742CB225DA100D4C1AB64D5CD07537B1CB966673A659A1161BEFDAC76FEF938D6C1209A6E8869CDCBB8720971B8896622BCC821050D58B130B2C642AA3CCE661288EA2E88BACDC171DCB544885AA05B194DB77F130F6756CC804D4076F8916ECF788C6532583B871A22493449DC0EBC626F1FCAC1AD4CA90BF10E12597D050AF9F3D9DE994C91C880E92ACA6BCF0BC1DA66E77EB6CC7569E64D503F2795C9CBC29E833C57220BF97A002E648CD37FC269FEB8FF5938DADEF0BF1147405FA7D687CEE63F489A263A71E064FB71C11EB8A048BB37A13E453C93CDDE04F53205F819C8FDFDF8AFB37E29E59B4274108B08D4DAAF13CD0567DCFD13CDFC27EF4FEC13AF6B1A69566CBD572A1343D36CA9FB869ECB4B826358D6DA9A2C8B1D7138EF8051D572A0B733C8F453F5C9780A53914007C9F803A8B96918EB7A85E09B32F784660FC5A32ECD07EBEF3A8F5B0754F3B3372FF0FEDD1EE2D6DEF9596F6C3D91191D0BF5242AA807C4A82CC5D738C5BAB286850E9B6B60AC4E7A1D09C8926CB6799030625D00C2E133BE0D904E432FA4881932164AF87D869C16D65099ABEB8D415BF8244876E6450C7E9E7137B3E0F340A70986EB619887896144F74DF87120D9E83A2FBB613FB7E0DFBCE106C5BBDDDB77D90FB402E2520BF45234A218892470FB145B44B3DD0586355B9A2FCFF6CE144DE1308FF23C169D4410B8BD51660AA79754AE0C8AB46C31B0DC3A563A361F712071E1B6DD76B549F0797E78E341C62795E560E5D9E97256062795E550E5F9EE3923BD061CA332D59D79D5F43120D59790EA78E5C9EC31268B13C5F483DA93CF90CF3A42BA0F1C413A9BE2DA5DA2F505D966884E922F25C393ACF15096E4EE079310159069E85A0E852BC86FD88288F0823F24DAA77A1F09D189D6B926D4FB4BFE60320DF4934C4ACFA5132FF67EBD6EEED7B771EB4B407AD87F777B5C77BBB775BB7EFFE2DE2FE74C08D9C59FEAB24548CE12914F9F84682E139B08AB8947A107B76450E6F45924BC48D03F66576FD2699175344F627D15D0D5F483464A7EDCED1B364E709D57055520DEDD336C416A9FC2EA592E526827BFF4AE0BD0326B2BF2CE1B412011F4B01DB9C41F61380370150F70D3730C27F0519E77D0928E3CB6F9199BE6EC8E7D0979D8FA5802D62B235BDDA69906C5FE76EC79B48F4A4647D37D1A1BE23131D928076882AE87402B20244273DC721B49BA868E8EB5243DB5F10401D4BA066C1D0551FB7D32F138F9F035990A045BF70FCADD043EB3F504B010214001400000008006C64B85825496E753A000000460000000F000000000000000100200000000000000050726F6A656374312E737370726F6A504B010214001400000008006C64B85892CEB6666E070000441D0000090000000000000000002000000067000000556E6974312E706375504B010214001400000008006C64B858BFD5D836B0020000750700000900000000000000010020000000FC070000556E6974312E707363504B010214001400000008006164B858A297D4E806050000A40F00000A00000000000000000020000000D30A0000556E6974312E7E706375504B05060000000004000400E3000000011000000000'
WHERE (ID = -521);



COMMIT WORK;

/******************************************************************************/
/***               Generated by IBExpert 28.05.2024 15:00:41                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/



CREATE TABLE ORDER_PACKAGE (
    WARE_ID           DM_UUID /* DM_UUID = CHAR(36) NOT NULL */,
    COUNT_IN_PACKAGE  DM_DOUBLE /* DM_DOUBLE = DOUBLE PRECISION */,
    D$UUID            DM_UUID /* DM_UUID = CHAR(36) NOT NULL */,
    D$SRVUPDDT        DM_DATETIME /* DM_DATETIME = TIMESTAMP */,
    INSERTDT          DM_DATETIME /* DM_DATETIME = TIMESTAMP */
);



/******************************************************************************/
/***                                Triggers                                ***/
/******************************************************************************/



SET TERM ^ ;



/******************************************************************************/
/***                          Triggers for tables                           ***/
/******************************************************************************/



/* Trigger: ORDER_PACKAGE_AD_DISTR */
CREATE OR ALTER TRIGGER ORDER_PACKAGE_AD_DISTR FOR ORDER_PACKAGE
ACTIVE AFTER DELETE POSITION 0
AS
begin
  update or insert into g$distribute (TABLENAME,UUID,SOPER,FROM_PROFILE_ID) values ('ORDER_PACKAGE',old.d$uuid,2,null)
    matching (TABLENAME,UUID);
end
^

/* Trigger: ORDER_PACKAGE_BI_DISTR */
CREATE OR ALTER TRIGGER ORDER_PACKAGE_BI_DISTR FOR ORDER_PACKAGE
ACTIVE BEFORE INSERT POSITION 0
AS
begin
  if (new.d$uuid is null) then
  begin
    new.insertdt = cast('now' as dm_datetime);
    new.d$uuid=UUID_TO_CHAR(GEN_UUID());
    new.d$srvupddt='2000-01-01';
    update or insert into g$distribute (TABLENAME,UUID,SOPER,FROM_PROFILE_ID) values ('ORDER_PACKAGE',new.d$uuid,0,null) matching (TABLENAME,UUID);
  end
end
^

/* Trigger: ORDER_PACKAGE_BU_DISTR */
CREATE OR ALTER TRIGGER ORDER_PACKAGE_BU_DISTR FOR ORDER_PACKAGE
ACTIVE BEFORE UPDATE POSITION 0
AS
begin
 -- if (new.D$SRVUPDDT=old.D$SRVUPDDT) then
    update or insert into g$distribute (TABLENAME,UUID,SOPER,FROM_PROFILE_ID) values ('ORDER_PACKAGE',new.d$uuid,1,null)
    matching (TABLENAME,UUID);
end
^
SET TERM ; ^



/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/


INSERT INTO SP$WDICTS (PARENT_ID, CAPTION, DESCRIPTION, SID, STATUS, INI, BMP)
               VALUES (0, 'Автозаказ: Норма Упаковки', NULL, 'ORDER_PACKAGE                  ', 0, '[insertsql]
insert into ORDER_PACKAGE
(ware_id)
values (:ware_id)

[deletesql_selected]

[deletesql]
delete from ORDER_PACKAGE where D$UUID=:D$UUID

[refreshsql]
select * from VW_ORDER_PACKAGE where D$UUID=:D$UUID

[selectsqlwithdeleted]

[selectsql]
select * from VW_ORDER_PACKAGE order by sname

[main]
sourcetablename=ORDER_PACKAGE
returnfieldname=ware_id
captionfieldname=sname
keyfieldname=D$UUID
ViewID=VW_ORDER_PACKAGE
RootGroupTableName=
ShowCaption=Автозаказ: Норма Упаковки
GetCaption=Автозаказ: Норма Упаковки
GroupSelect=0
foldergroup=
initfolder_id=
dataset=0
InitTMSGroup_id=0
folders_visible=0
Canfloating=0
hidetoppanel=0
ActivateDictAction=0

[cfSelect]
selectfieldexpression=iif(BARCODE IS NULL,'''',BARCODE)||iif(SNAME IS NULL,'''',SNAME)
AllwaysPartial=1

[form_show]
position=8
left=0
Top=0
Width=800
Height=400
MaxWidth=0
MaxHeight=0
MinWidth=800
MinHeight=400

[form_get]
position=8
left=0
Top=0
Width=800
Height=400
MaxWidth=0
MaxHeight=0
MinWidth=800
MinHeight=400

[childs]
bottomdock_units=0
bottomdock_size=0
rightdock_units=0
rightdock_size=0

[editfields]
COUNT_IN_PACKAGE=default

[addfields]
ware_id=WDICTS.NAME_WARE
', NULL);


COMMIT WORK;