Допродажи (сопутствующие товары) к синхронизации — различия между версиями

Текущая версия на 18:08, 27 марта 2017

@@ Строка 1: / Строка 1: @@
-<pre>
+==Установить скрипт==
-ALTER TABLE ACCOMPANY
+[[:Файл:СкриптКСинхронизации.txt|СкриптКСинхронизации.txt]]
-ADD D$SRVUPDDT DM_DATETIME;
-ALTER TABLE ACCOMPANY
-ADD D$UUID DM_UUID;
-ALTER TABLE ACCOMPANY
-ADD CONSTRAINT UNQ1_ACCOMPANY
-UNIQUE (D$UUID);
-SET SQL DIALECT 3;
-SET TERM ^ ;
-CREATE OR ALTER TRIGGER ACCOMPANY_BD_DISTR FOR ACCOMPANY
-ACTIVE BEFORE DELETE POSITION 0
-AS
-begin
-  update or insert into g$distribute (TABLENAME,UUID,SOPER,FROM_PROFILE_ID)
-values ('ACCOMPANY',old.d$uuid,2,null)
-  matching (TABLENAME,UUID);
-end
-^
-SET TERM ; ^
-SET SQL DIALECT 3;
-SET TERM ^ ;
-CREATE OR ALTER TRIGGER ACCOMPANY_BU_DISTR FOR ACCOMPANY
-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 ('ACCOMPANY',new.d$uuid,1,null) matching (TABLENAME,UUID);
-end
-^
-SET TERM ; ^
-SET SQL DIALECT 3;
-SET TERM ^ ;
-CREATE OR ALTER TRIGGER ACCOMPANY_BI_DISTR FOR ACCOMPANY
-ACTIVE BEFORE INSERT POSITION 0
-AS
-begin
-  if (new.d$uuid is null) then
-  begin
-    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 ('ACCOMPANY',new.d$uuid,0,null) matching (TABLENAME,UUID);
-  end
-end
-^
-SET TERM ; ^
-</pre>