Скрипт дополнений к ЕГАИС - История изменений

Agk в 13:05, 27 сентября 2016

2016-09-27T13:05:08Z

Aleksnick в 12:26, 23 августа 2016

2016-08-23T12:26:11Z

BeTePoK в 06:46, 21 июля 2016

2016-07-21T06:46:22Z

Aleksnick: Новая страница: «

 set term ^;  create generator GEN_EGAIS_SHOP_ID; ^  create table EGAIS_SHOP (ID integer not null, PART_ID DM_ID_NULL / DM_ID_NULL = bigint /, SNAME DM_TEXT1…»

2016-07-20T11:22:57Z

Новая страница: «<pre> set term ^; create generator GEN_EGAIS_SHOP_ID; ^ create table EGAIS_SHOP (ID integer not null, PART_ID DM_ID_NULL / DM_ID_NULL = bigint /, SNAME DM_TEXT1…»

Новая страница

<pre>
set term ^;

create generator GEN_EGAIS_SHOP_ID;
^

create table EGAIS_SHOP (ID integer not null, PART_ID DM_ID_NULL / DM_ID_NULL = bigint /, SNAME DM_TEXT1024 / DM_TEXT1024 = varchar (1024) /, QUANT DM_DOUBLE / DM_DOUBLE = double precision /, EGAIS_QUANT DM_DOUBLE / DM_DOUBLE = double precision /, ALCCODE DM_TEXT1024 / DM_TEXT1024 = varchar (1024) /, UNITTYPE DM_TEXT / DM_TEXT = varchar (250) /, ALCVOLUME DM_DOUBLE / DM_DOUBLE = double precision /, PRODUCTVCODE DM_STATUS / DM_STATUS = integer /, PRODUCER_ID DM_TEXT / DM_TEXT = varchar (250) /);
^

create or alter trigger EGAIS_SHOP_BI for EGAIS_SHOP
active before insert position 0
as
begin
if (new.ID is null) then
new.ID = gen_id(GEN_EGAIS_SHOP_ID, 1);
end^

create or alter view VW_WARESHOP (
ID,
PART_ID,
SNAME,
QUANT,
EGAIS_QUANT,
ALCCODE,
UNITTYPE,
ALCVOLUME,
PRODUCTVCODE,
PRODUCER_ID)
as
select ID,
PART_ID,
SNAME,
QUANT,
EGAIS_QUANT,
ALCCODE,
UNITTYPE,
ALCVOLUME,
PRODUCTVCODE,
PRODUCER_ID
from EGAIS_SHOP;
^

set term;
^
</pre>

@@ Строка 69: / Строка 69: @@
 set term;
+^
 </pre>

@@ Строка 21: / Строка 21: @@
+^
-create table EGAIS_SHOP (ID integer not null, PART_ID DM_ID_NULL / DM_ID_NULL = bigint /, SNAME DM_TEXT1024 / DM_TEXT1024 = varchar (1024) /, QUANT DM_DOUBLE / DM_DOUBLE = double precision /, EGAIS_QUANT DM_DOUBLE / DM_DOUBLE = double precision /, ALCCODE DM_TEXT1024 / DM_TEXT1024 = varchar (1024) /, UNITTYPE DM_TEXT / DM_TEXT = varchar (250) /, ALCVOLUME DM_DOUBLE / DM_DOUBLE = double precision /, PRODUCTVCODE DM_STATUS / DM_STATUS = integer /, PRODUCER_ID DM_TEXT / DM_TEXT = varchar (250) /);
+create table EGAIS_SHOP (
+^