--
-- DT411
-- 

ALTER TABLE DT411 MODIFY DI040869 VARCHAR2(2 CHAR);


--
-- DT808
-- 

ALTER TABLE DT808 MODIFY DI007041 VARCHAR2(20 CHAR);

--
-- DT823
-- 

ALTER TABLE DT823 MODIFY DI008822 VARCHAR2(20 CHAR);


--
-- DT827
-- 

ALTER TABLE DT827 MODIFY DI059290 VARCHAR2(2 CHAR);

--
-- DT003
--

-- ALTER TABLE DT003 MODIFY DI059203 NUMERIC(20) DEFAULT 0;
ALTER TABLE DT003 ALTER COLUMN DI059203 NUMERIC(20) NOT NULL;

ALTER TABLE DT003
  ADD CONSTRAINT DEFAULTVALUE_DT003_DI059203
  DEFAULT 0 FOR DI059203;

--
-- DT035
--

-- ALTER TABLE DT035 ALTER COLUMN DI059197 NUMERIC(20) DEFAULT 0;
ALTER TABLE DT035 ALTER COLUMN DI059197 NUMERIC(20) NOT NULL;

ALTER TABLE DT035
  ADD CONSTRAINT DEFAULTVALUE_DT035_DI059197
  DEFAULT 0 FOR DI059197;

--
-- DT345
--

ALTER TABLE DT345 ALTER COLUMN SYSTEMTYPE NUMERIC(5,0) NULL 

--
-- DT397
--

UPDATE DT397 SET DI059199 = 0 WHERE DI059199 IS NULL;

ALTER TABLE DT397 ALTER COLUMN DI059199 NUMERIC(20) NOT NULL;

ALTER TABLE DT397
  ADD CONSTRAINT DEFAULTVALUE_DT397_DI059199
  DEFAULT 0 FOR DI059199;

--
-- DT447
--

ALTER TABLE DT447 ALTER COLUMN DI041283 VARCHAR(30);

ALTER TABLE DT447
  ADD CONSTRAINT DEFAULTVALUE_DT447_DI041283
  DEFAULT 0 FOR DI041283;

--
-- DT460
--

UPDATE DT460 SET DI059202 = 0 WHERE DI059202 IS NULL;

ALTER TABLE DT460 ALTER COLUMN DI059202 NUMERIC(20);

ALTER TABLE DT460
  ADD CONSTRAINT DEFAULTVALUE_DT460_DI059202
  DEFAULT 0 FOR DI059202;

--
-- DT463
--

--ALTER TABLE DT463 ALTER COLUMN DI001097 VARCHAR(18) NOT NULL;
  
--
-- DT466
--

ALTER TABLE DT466 DROP CONSTRAINT PID466DT466;

ALTER TABLE DT466 ALTER COLUMN DI001390 VARCHAR(18) NOT NULL;
ALTER TABLE DT466 ALTER COLUMN DI001391 VARCHAR(18) NOT NULL;
ALTER TABLE DT466 ALTER COLUMN DI001392 VARCHAR(20) NOT NULL;

ALTER TABLE DT466 ADD CONSTRAINT PID466DT466 PRIMARY KEY (DI001390, DI001391, DI001392);

--
-- DT516
--

ALTER TABLE DT516 ALTER COLUMN DI024318 VARCHAR(20);

--
-- DT546
--

UPDATE DT546 SET DI059200 = 0 WHERE DI059200 IS NULL;

ALTER TABLE DT546 ALTER COLUMN DI059200 NUMERIC(20);

ALTER TABLE DT546
  ADD CONSTRAINT DEFAULTVALUE_DT546_DI059200
  DEFAULT 0 FOR DI059200;

--
-- DT814
--

ALTER TABLE DT814 ALTER COLUMN DI007881 VARCHAR(20);

--
-- DT828
-- 

ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008542 DEFAULT 0 FOR DI008542;

ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008544 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008544;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008545 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008545;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008546 DEFAULT 0 FOR DI008546;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008551 DEFAULT 0 FOR DI008551;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008552 DEFAULT 0 FOR DI008552;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008553 DEFAULT 0 FOR DI008553;
ALTER TABLE DT828 ADD CONSTRAINT DEFAULTVALUE_DT828_DI008808 DEFAULT 0 FOR DI008808;

CREATE INDEX IDX_UUID_UNIQUE_828 ON DT828 (UUID ASC);

ALTER TABLE DT828 ADD CONSTRAINT UUID_UNIQUE_828 UNIQUE (UUID);

--
-- DT829
-- 

ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008558 DEFAULT 0 FOR DI008558;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008559 DEFAULT 0 FOR DI008559;

ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008562 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008562;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008563 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008563;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008564 DEFAULT 0 FOR DI008564;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008569 DEFAULT 0 FOR DI008569;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008570 DEFAULT 0 FOR DI008570;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008571 DEFAULT 0 FOR DI008571;
ALTER TABLE DT829 ADD CONSTRAINT DEFAULTVALUE_DT829_DI008572 DEFAULT 0 FOR DI008572;

CREATE INDEX IDX_UUID_UNIQUE_829 ON DT829 (UUID ASC);

ALTER TABLE DT829 ADD CONSTRAINT UUID_UNIQUE_829 UNIQUE (UUID);

--
-- DT830
-- 

ALTER TABLE DT830 ALTER COLUMN DI008789 varchar(18) NULL;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008791 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008791;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008792 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008792;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008793 DEFAULT 0 FOR DI008793;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008798 DEFAULT 0 FOR DI008798;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008799 DEFAULT 0 FOR DI008799;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008800 DEFAULT 0 FOR DI008800;
ALTER TABLE DT830 ADD CONSTRAINT DEFAULTVALUE_DT830_DI008801 DEFAULT 0 FOR DI008801;

CREATE INDEX IDX_UUID_UNIQUE_830 ON DT830 (UUID ASC);

ALTER TABLE DT830 ADD CONSTRAINT UUID_UNIQUE_830 UNIQUE (UUID);

--
-- DT831
-- 

ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008863 DEFAULT 0 FOR DI008863;

ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008865 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008865;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008866 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008866;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008867 DEFAULT 0 FOR DI008867;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008872 DEFAULT 0 FOR DI008872;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008873 DEFAULT 0 FOR DI008873;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008874 DEFAULT 0 FOR DI008874;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008877 DEFAULT 0 FOR DI008877;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008878 DEFAULT 0 FOR DI008878;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008880 DEFAULT 0 FOR DI008880;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI008881 DEFAULT 0 FOR DI008881;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI028283 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028283;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI028284 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028284;
ALTER TABLE DT831 ADD CONSTRAINT DEFAULTVALUE_DT831_DI028285 DEFAULT 0 FOR DI028285;
ALTER TABLE DT831
ADD DI062990 numeric(5,0) DEFAULT 0;

ALTER TABLE DT831
ADD DI062996 numeric(5,0) DEFAULT 0;

ALTER TABLE DT831 DROP COLUMN DI034517;

--
-- DT832
-- 

ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008886 DEFAULT 0 FOR DI008886;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008887 DEFAULT 0 FOR DI008887;

ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008890 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008890;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008891 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008891;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008892 DEFAULT 0 FOR DI008892;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008897 DEFAULT 0 FOR DI008897;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008898 DEFAULT 0 FOR DI008898;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008899 DEFAULT 0 FOR DI008899;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008900 DEFAULT 0 FOR DI008900;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI008902 DEFAULT 0 FOR DI008902;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI028286 DEFAULT 0 FOR DI028286;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI028287 DEFAULT 0 FOR DI028287;
ALTER TABLE DT832 ADD CONSTRAINT DEFAULTVALUE_DT832_DI028288 DEFAULT 0 FOR DI028288;

CREATE INDEX IDX_UUID_UNIQUE_832 ON DT832 (UUID ASC);

ALTER TABLE DT832 ADD CONSTRAINT UUID_UNIQUE_832 UNIQUE (UUID);

--
-- DT833
-- 

ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008911 DEFAULT 0 FOR DI008911;

ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008916 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008916;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008917 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008917;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008918 DEFAULT 0 FOR DI008918;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008923 DEFAULT 0 FOR DI008923;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008924 DEFAULT 0 FOR DI008924;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008925 DEFAULT 0 FOR DI008925;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008931 DEFAULT 0 FOR DI008931;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008932 DEFAULT 0 FOR DI008932;
ALTER TABLE DT833 ADD CONSTRAINT DEFAULTVALUE_DT833_DI008933 DEFAULT 0 FOR DI008933;

CREATE INDEX IDX_UUID_UNIQUE_833 ON DT833 (UUID ASC);

ALTER TABLE DT833 ADD CONSTRAINT UUID_UNIQUE_833 UNIQUE (UUID);

--
-- DT834
-- 

ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008940 DEFAULT 0 FOR DI008940;

ALTER TABLE DT834 ALTER COLUMN DI008941 numeric(10) NULL;
ALTER TABLE DT834 ALTER COLUMN DI008942 varchar(2) NULL;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008944 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008944;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008945 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI008945;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008946 DEFAULT 0 FOR DI008946;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008951 DEFAULT 0 FOR DI008951;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008952 DEFAULT 0 FOR DI008952;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008953 DEFAULT 0 FOR DI008953;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008954 DEFAULT 0 FOR DI008954;
ALTER TABLE DT834 ADD CONSTRAINT DEFAULTVALUE_DT834_DI008956 DEFAULT 0 FOR DI008956;

CREATE INDEX IDX_UUID_UNIQUE_834 ON DT834 (UUID ASC);

ALTER TABLE DT834 ADD CONSTRAINT UUID_UNIQUE_834 UNIQUE (UUID);

--
-- DT835
-- 

ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029231 DEFAULT 0 FOR DI029231;

ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029233 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029233;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029234 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029234;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029235 DEFAULT 0 FOR DI029235;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029240 DEFAULT 0 FOR DI029240;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029241 DEFAULT 0 FOR DI029241;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029242 DEFAULT 0 FOR DI029242;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029249 DEFAULT 0 FOR DI029249;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029255 DEFAULT 0 FOR DI029255;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029256 DEFAULT 0 FOR DI029256;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029257 DEFAULT 0 FOR DI029257;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029258 DEFAULT 0 FOR DI029258;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029259 DEFAULT 0 FOR DI029259;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029260 DEFAULT 0 FOR DI029260;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029261 DEFAULT 0 FOR DI029261;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029262 DEFAULT 0 FOR DI029262;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029263 DEFAULT 0 FOR DI029263;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029287 DEFAULT 0 FOR DI029287;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042774 DEFAULT 0 FOR DI042774;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029288 DEFAULT 0 FOR DI029288;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029289 DEFAULT 0 FOR DI029289;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029290 DEFAULT 0 FOR DI029290;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042769 DEFAULT 0 FOR DI042769;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029291 DEFAULT 0 FOR DI029291;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029292 DEFAULT 0 FOR DI029292;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042776 DEFAULT 0 FOR DI042776;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029293 DEFAULT 0 FOR DI029293;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029294 DEFAULT 0 FOR DI029294;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029295 DEFAULT 0 FOR DI029295;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042770 DEFAULT 0 FOR DI042770;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029296 DEFAULT 0 FOR DI029296;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029297 DEFAULT 0 FOR DI029297;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042778 DEFAULT 0 FOR DI042778;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029298 DEFAULT 0 FOR DI029298;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029299 DEFAULT 0 FOR DI029299;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029300 DEFAULT 0 FOR DI029300;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042771 DEFAULT 0 FOR DI042771;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029301 DEFAULT 0 FOR DI029301;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029302 DEFAULT 0 FOR DI029302;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042780 DEFAULT 0 FOR DI042780;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029303 DEFAULT 0 FOR DI029303;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029304 DEFAULT 0 FOR DI029304;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029305 DEFAULT 0 FOR DI029305;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042772 DEFAULT 0 FOR DI042772;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029306 DEFAULT 0 FOR DI029306;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029307 DEFAULT 0 FOR DI029307;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042782 DEFAULT 0 FOR DI042782;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029308 DEFAULT 0 FOR DI029308;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029309 DEFAULT 0 FOR DI029309;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029310 DEFAULT 0 FOR DI029310;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042773 DEFAULT 0 FOR DI042773;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029311 DEFAULT 0 FOR DI029311;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029312 DEFAULT 0 FOR DI029312;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029313 DEFAULT 0 FOR DI029313;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029314 DEFAULT 0 FOR DI029314;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029315 DEFAULT 0 FOR DI029315;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI029316 DEFAULT 0 FOR DI029316;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042785 DEFAULT 0 FOR DI042785;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042786 DEFAULT 0 FOR DI042786;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042787 DEFAULT 0 FOR DI042787;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042788 DEFAULT 0 FOR DI042788;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042789 DEFAULT 0 FOR DI042789;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042790 DEFAULT 0 FOR DI042790;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042775 DEFAULT 0 FOR DI042775;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042777 DEFAULT 0 FOR DI042777;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042779 DEFAULT 0 FOR DI042779;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042781 DEFAULT 0 FOR DI042781;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042783 DEFAULT 0 FOR DI042783;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042841 DEFAULT 0 FOR DI042841;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042892 DEFAULT 0 FOR DI042892;
ALTER TABLE DT835 ADD CONSTRAINT DEFAULTVALUE_DT835_DI042893 DEFAULT 0 FOR DI042893;
ALTER TABLE DT835
ADD DI061418 float DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_835 ON DT835 (UUID ASC);

ALTER TABLE DT835 ADD CONSTRAINT UUID_UNIQUE_835 UNIQUE (UUID);

ALTER TABLE DT835 DROP COLUMN DI029243;
ALTER TABLE DT835 DROP COLUMN DI029244;
ALTER TABLE DT835 DROP COLUMN DI029245;
ALTER TABLE DT835 DROP COLUMN DI029246;
ALTER TABLE DT835 DROP COLUMN DI029247;
ALTER TABLE DT835 DROP COLUMN DI029248;
ALTER TABLE DT835 DROP COLUMN DI029250;
ALTER TABLE DT835 DROP COLUMN DI029251;
ALTER TABLE DT835 DROP COLUMN DI029252;
ALTER TABLE DT835 DROP COLUMN DI029253;
ALTER TABLE DT835 DROP COLUMN DI029254;
ALTER TABLE DT835 DROP COLUMN DI029264;
ALTER TABLE DT835 DROP COLUMN DI029265;
ALTER TABLE DT835 DROP COLUMN DI029266;
ALTER TABLE DT835 DROP COLUMN DI029267;
ALTER TABLE DT835 DROP COLUMN DI029269;
ALTER TABLE DT835 DROP COLUMN DI029270;
ALTER TABLE DT835 DROP COLUMN DI029271;
ALTER TABLE DT835 DROP COLUMN DI029272;
ALTER TABLE DT835 DROP COLUMN DI029273;
ALTER TABLE DT835 DROP COLUMN DI029274;
ALTER TABLE DT835 DROP COLUMN DI029275;
ALTER TABLE DT835 DROP COLUMN DI029276;
ALTER TABLE DT835 DROP COLUMN DI029277;
ALTER TABLE DT835 DROP COLUMN DI029278;
ALTER TABLE DT835 DROP COLUMN DI029279;
ALTER TABLE DT835 DROP COLUMN DI029280;
ALTER TABLE DT835 DROP COLUMN DI029281;
ALTER TABLE DT835 DROP COLUMN DI029282;
ALTER TABLE DT835 DROP COLUMN DI029283;
ALTER TABLE DT835 DROP COLUMN DI029284;

--
-- DT836
-- 

ALTER TABLE DT836 ADD UUID uniqueidentifier DEFAULT newid() not null;

ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029331 DEFAULT 0 FOR DI029331;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029334 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029334;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029335 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029335;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029336 DEFAULT 0 FOR DI029336;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029341 DEFAULT 0 FOR DI029341;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029342 DEFAULT 0 FOR DI029342;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029343 DEFAULT 0 FOR DI029343;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029344 DEFAULT 0 FOR DI029344;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029345 DEFAULT 0 FOR DI029345;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029346 DEFAULT 0 FOR DI029346;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029347 DEFAULT 0 FOR DI029347;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029348 DEFAULT 0 FOR DI029348;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029349 DEFAULT 0 FOR DI029349;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029350 DEFAULT 0 FOR DI029350;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029351 DEFAULT 0 FOR DI029351;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029352 DEFAULT 0 FOR DI029352;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029353 DEFAULT 0 FOR DI029353;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029354 DEFAULT 0 FOR DI029354;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029355 DEFAULT 0 FOR DI029355;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029356 DEFAULT 0 FOR DI029356;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029357 DEFAULT 0 FOR DI029357;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029358 DEFAULT 0 FOR DI029358;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029359 DEFAULT 0 FOR DI029359;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029360 DEFAULT 0 FOR DI029360;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029361 DEFAULT 0 FOR DI029361;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029362 DEFAULT 0 FOR DI029362;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029363 DEFAULT 0 FOR DI029363;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029364 DEFAULT 0 FOR DI029364;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029365 DEFAULT 0 FOR DI029365;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029366 DEFAULT 0 FOR DI029366;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029367 DEFAULT 0 FOR DI029367;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029368 DEFAULT 0 FOR DI029368;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029369 DEFAULT 0 FOR DI029369;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029370 DEFAULT 0 FOR DI029370;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029371 DEFAULT 0 FOR DI029371;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029372 DEFAULT 0 FOR DI029372;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029373 DEFAULT 0 FOR DI029373;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029374 DEFAULT 0 FOR DI029374;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029375 DEFAULT 0 FOR DI029375;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029377 DEFAULT 0 FOR DI029377;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029378 DEFAULT 0 FOR DI029378;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029379 DEFAULT 0 FOR DI029379;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029380 DEFAULT 0 FOR DI029380;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029381 DEFAULT 0 FOR DI029381;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029382 DEFAULT 0 FOR DI029382;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029383 DEFAULT 0 FOR DI029383;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029384 DEFAULT 0 FOR DI029384;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029385 DEFAULT 0 FOR DI029385;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029386 DEFAULT 0 FOR DI029386;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029387 DEFAULT 0 FOR DI029387;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029388 DEFAULT 0 FOR DI029388;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029389 DEFAULT 0 FOR DI029389;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029390 DEFAULT 0 FOR DI029390;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029391 DEFAULT 0 FOR DI029391;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029392 DEFAULT 0 FOR DI029392;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029395 DEFAULT 0 FOR DI029395;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029396 DEFAULT 0 FOR DI029396;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029397 DEFAULT 0 FOR DI029397;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029398 DEFAULT 0 FOR DI029398;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029399 DEFAULT 0 FOR DI029399;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029400 DEFAULT 0 FOR DI029400;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029401 DEFAULT 0 FOR DI029401;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029402 DEFAULT 0 FOR DI029402;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029403 DEFAULT 0 FOR DI029403;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029404 DEFAULT 0 FOR DI029404;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029405 DEFAULT 0 FOR DI029405;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029406 DEFAULT 0 FOR DI029406;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029407 DEFAULT 0 FOR DI029407;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029408 DEFAULT 0 FOR DI029408;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029409 DEFAULT 0 FOR DI029409;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029410 DEFAULT 0 FOR DI029410;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029411 DEFAULT 0 FOR DI029411;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029412 DEFAULT 0 FOR DI029412;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029413 DEFAULT 0 FOR DI029413;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029414 DEFAULT 0 FOR DI029414;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029415 DEFAULT 0 FOR DI029415;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029416 DEFAULT 0 FOR DI029416;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029417 DEFAULT 0 FOR DI029417;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029418 DEFAULT 0 FOR DI029418;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029419 DEFAULT 0 FOR DI029419;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029420 DEFAULT 0 FOR DI029420;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029421 DEFAULT 0 FOR DI029421;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029422 DEFAULT 0 FOR DI029422;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029423 DEFAULT 0 FOR DI029423;
ALTER TABLE DT836 ADD CONSTRAINT DEFAULTVALUE_DT836_DI029424 DEFAULT 0 FOR DI029424;

CREATE INDEX IDX_UUID_UNIQUE_836 ON DT836 (UUID ASC);

ALTER TABLE DT836 ADD CONSTRAINT UUID_UNIQUE_836 UNIQUE (UUID);

--
-- DT837
-- 

ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009077 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009077;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009078 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009078;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009079 DEFAULT 0 FOR DI009079;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009084 DEFAULT 0 FOR DI009084;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009085 DEFAULT 0 FOR DI009085;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009086 DEFAULT 0 FOR DI009086;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009088 DEFAULT 0 FOR DI009088;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009090 DEFAULT 0 FOR DI009090;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009089 DEFAULT 0 FOR DI009089;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009091 DEFAULT 0 FOR DI009091;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009092 DEFAULT 0 FOR DI009092;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009093 DEFAULT 0 FOR DI009093;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009094 DEFAULT 0 FOR DI009094;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009095 DEFAULT 0 FOR DI009095;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009096 DEFAULT 0 FOR DI009096;
ALTER TABLE DT837 ADD CONSTRAINT DEFAULTVALUE_DT837_DI009156 DEFAULT 0 FOR DI009156;

CREATE INDEX IDX_UUID_UNIQUE_837 ON DT837 (UUID ASC);

ALTER TABLE DT837 ADD CONSTRAINT UUID_UNIQUE_837 UNIQUE (UUID);

--
-- DT838
-- 

ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009099 DEFAULT 0 FOR DI009099;

ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009104 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009104;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009105 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009105;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009106 DEFAULT 0 FOR DI009106;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009111 DEFAULT 0 FOR DI009111;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009112 DEFAULT 0 FOR DI009112;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009113 DEFAULT 0 FOR DI009113;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009115 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009115;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009116 DEFAULT 0 FOR DI009116;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009119 DEFAULT 0 FOR DI009119;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009120 DEFAULT 0 FOR DI009120;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009121 DEFAULT 0 FOR DI009121;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009122 DEFAULT 0 FOR DI009122;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009123 DEFAULT 0 FOR DI009123;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009124 DEFAULT 0 FOR DI009124;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009125 DEFAULT 0 FOR DI009125;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009126 DEFAULT 0 FOR DI009126;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009127 DEFAULT 0 FOR DI009127;
ALTER TABLE DT838 ADD CONSTRAINT DEFAULTVALUE_DT838_DI009128 DEFAULT 0 FOR DI009128;

CREATE INDEX IDX_UUID_UNIQUE_838 ON DT838 (UUID ASC);

ALTER TABLE DT838 ADD CONSTRAINT UUID_UNIQUE_838 UNIQUE (UUID);

ALTER TABLE DT838 DROP COLUMN DI009117;

--
-- DT839
-- 

ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053214 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI053214;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053215 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI053215;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053216 DEFAULT 0 FOR DI053216;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053221 DEFAULT 0 FOR DI053221;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053222 DEFAULT 0 FOR DI053222;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053223 DEFAULT 0 FOR DI053223;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053224 DEFAULT 0 FOR DI053224;
ALTER TABLE DT839 ADD CONSTRAINT DEFAULTVALUE_DT839_DI053226 DEFAULT 0 FOR DI053226;

CREATE INDEX IDX_ITEXT_DT839DI053225 ON DT839 (DI053225 ASC);

CREATE INDEX IDX_UUID_UNIQUE_839 ON DT839 (UUID ASC);

ALTER TABLE DT839 ADD CONSTRAINT UUID_UNIQUE_839 UNIQUE (UUID);

--
-- DT840
-- 

ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009760 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009760;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009761 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009761;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009762 DEFAULT 0 FOR DI009762;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009767 DEFAULT 0 FOR DI009767;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009768 DEFAULT 0 FOR DI009768;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009769 DEFAULT 0 FOR DI009769;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009775 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009775;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009774 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009774;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009776 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009776;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009777 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009777;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009778 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009778;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009779 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009779;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009780 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009780;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009781 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009781;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009782 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009782;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009783 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009783;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009784 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009784;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009785 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009785;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009786 DEFAULT 0 FOR DI009786;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009787 DEFAULT 0 FOR DI009787;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009788 DEFAULT 0 FOR DI009788;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009802 DEFAULT 0 FOR DI009802;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009792 DEFAULT 0 FOR DI009792;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009793 DEFAULT 0 FOR DI009793;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009794 DEFAULT 0 FOR DI009794;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009795 DEFAULT 0 FOR DI009795;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009796 DEFAULT 0 FOR DI009796;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009799 DEFAULT 0 FOR DI009799;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009797 DEFAULT 0 FOR DI009797;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009798 DEFAULT 0 FOR DI009798;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009773 DEFAULT 0 FOR DI009773;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI009994 DEFAULT 0 FOR DI009994;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI010007 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010007;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI010079 DEFAULT 0 FOR DI010079;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022825 DEFAULT 0 FOR DI022825;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022826 DEFAULT 0 FOR DI022826;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022827 DEFAULT 0 FOR DI022827;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022828 DEFAULT 0 FOR DI022828;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022829 DEFAULT 0 FOR DI022829;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI022830 DEFAULT 0 FOR DI022830;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023471 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023471;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023472 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023472;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023635 DEFAULT 0 FOR DI023635;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023636 DEFAULT 0 FOR DI023636;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023637 DEFAULT 0 FOR DI023637;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023638 DEFAULT 0 FOR DI023638;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023639 DEFAULT 0 FOR DI023639;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023640 DEFAULT 0 FOR DI023640;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023641 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023641;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023642 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023642;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023643 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023643;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023644 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023644;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023645 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023645;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023646 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023646;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023821 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023821;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023822 DEFAULT 0 FOR DI023822;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023823 DEFAULT 0 FOR DI023823;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023825 DEFAULT 0 FOR DI023825;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023824 DEFAULT 0 FOR DI023824;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023826 DEFAULT 0 FOR DI023826;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023827 DEFAULT 0 FOR DI023827;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023828 DEFAULT 0 FOR DI023828;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023829 DEFAULT 0 FOR DI023829;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023830 DEFAULT 0 FOR DI023830;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023831 DEFAULT 0 FOR DI023831;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023832 DEFAULT 0 FOR DI023832;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023833 DEFAULT 0 FOR DI023833;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023834 DEFAULT 0 FOR DI023834;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023835 DEFAULT 0 FOR DI023835;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023838 DEFAULT 0 FOR DI023838;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023839 DEFAULT 0 FOR DI023839;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023840 DEFAULT 0 FOR DI023840;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023841 DEFAULT 0 FOR DI023841;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023849 DEFAULT 0 FOR DI023849;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023853 DEFAULT 0 FOR DI023853;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023854 DEFAULT 0 FOR DI023854;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023855 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023855;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023857 DEFAULT 0 FOR DI023857;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023858 DEFAULT 0 FOR DI023858;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023859 DEFAULT 0 FOR DI023859;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023860 DEFAULT 0 FOR DI023860;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023861 DEFAULT 0 FOR DI023861;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023874 DEFAULT 0 FOR DI023874;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023875 DEFAULT 0 FOR DI023875;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023876 DEFAULT 0 FOR DI023876;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023877 DEFAULT 0 FOR DI023877;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023886 DEFAULT 0 FOR DI023886;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023894 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023894;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023895 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023895;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023897 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023897;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023898 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023898;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023901 DEFAULT 0 FOR DI023901;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023902 DEFAULT 0 FOR DI023902;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023917 DEFAULT 0 FOR DI023917;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023918 DEFAULT 0 FOR DI023918;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023921 DEFAULT 0 FOR DI023921;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023926 DEFAULT 0 FOR DI023926;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023927 DEFAULT 0 FOR DI023927;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023928 DEFAULT 0 FOR DI023928;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023929 DEFAULT 0 FOR DI023929;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023933 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023933;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023936 DEFAULT 0 FOR DI023936;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023941 DEFAULT 0 FOR DI023941;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023942 DEFAULT 0 FOR DI023942;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023943 DEFAULT 0 FOR DI023943;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023944 DEFAULT 0 FOR DI023944;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023945 DEFAULT 0 FOR DI023945;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023899 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023899;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023900 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023900;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023938 DEFAULT 0 FOR DI023938;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023890 DEFAULT 0 FOR DI023890;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023892 DEFAULT 0 FOR DI023892;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023891 DEFAULT 0 FOR DI023891;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023889 DEFAULT 0 FOR DI023889;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023852 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023852;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023851 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023851;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023940 DEFAULT 0 FOR DI023940;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023887 DEFAULT 0 FOR DI023887;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023907 DEFAULT 0 FOR DI023907;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023905 DEFAULT 0 FOR DI023905;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023906 DEFAULT 0 FOR DI023906;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023842 DEFAULT 0 FOR DI023842;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023843 DEFAULT 0 FOR DI023843;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023844 DEFAULT 0 FOR DI023844;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023845 DEFAULT 0 FOR DI023845;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023846 DEFAULT 0 FOR DI023846;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023873 DEFAULT 0 FOR DI023873;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023916 DEFAULT 0 FOR DI023916;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023880 DEFAULT 0 FOR DI023880;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023881 DEFAULT 0 FOR DI023881;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023882 DEFAULT 0 FOR DI023882;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023883 DEFAULT 0 FOR DI023883;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023884 DEFAULT 0 FOR DI023884;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023862 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023862;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023863 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023863;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023864 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023864;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023865 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023865;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023866 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023866;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023850 DEFAULT 0 FOR DI023850;
ALTER TABLE DT840 ADD CONSTRAINT DEFAULTVALUE_DT840_DI023903 DEFAULT 0 FOR DI023903;

CREATE INDEX IDX_UUID_UNIQUE_840 ON DT840 (UUID ASC);

ALTER TABLE DT840 ADD CONSTRAINT UUID_UNIQUE_840 UNIQUE (UUID);

--
-- DT841
-- 

ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009811 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009811;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009812 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009812;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009813 DEFAULT 0 FOR DI009813;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009818 DEFAULT 0 FOR DI009818;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009819 DEFAULT 0 FOR DI009819;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009820 DEFAULT 0 FOR DI009820;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009821 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009821;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009822 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009822;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009823 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009823;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009824 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009824;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009825 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009825;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009826 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009826;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009827 DEFAULT 0 FOR DI009827;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009828 DEFAULT 0 FOR DI009828;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009829 DEFAULT 0 FOR DI009829;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009830 DEFAULT 0 FOR DI009830;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009831 DEFAULT 0 FOR DI009831;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009832 DEFAULT 0 FOR DI009832;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009833 DEFAULT 0 FOR DI009833;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009836 DEFAULT 0 FOR DI009836;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009837 DEFAULT 0 FOR DI009837;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009838 DEFAULT 0 FOR DI009838;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009839 DEFAULT 0 FOR DI009839;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009840 DEFAULT 0 FOR DI009840;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009841 DEFAULT 0 FOR DI009841;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009842 DEFAULT 0 FOR DI009842;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009969 DEFAULT 0 FOR DI009969;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009996 DEFAULT 0 FOR DI009996;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI009997 DEFAULT 0 FOR DI009997;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010003 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010003;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010004 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010004;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010009 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010009;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010010 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010010;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010011 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010011;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010012 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010012;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010017 DEFAULT 0 FOR DI010017;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010059 DEFAULT 0 FOR DI010059;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010060 DEFAULT 0 FOR DI010060;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010061 DEFAULT 0 FOR DI010061;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010064 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010064;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010065 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010065;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010067 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010067;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010068 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010068;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010069 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010069;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010070 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010070;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010071 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010071;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010072 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010072;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010073 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010073;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI010074 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010074;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023457 DEFAULT 0 FOR DI023457;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023458 DEFAULT 0 FOR DI023458;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023459 DEFAULT 0 FOR DI023459;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023946 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023946;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023956 DEFAULT 0 FOR DI023956;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023957 DEFAULT 0 FOR DI023957;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023963 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023963;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023966 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023966;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023968 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023968;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023974 DEFAULT 0 FOR DI023974;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023975 DEFAULT 0 FOR DI023975;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023976 DEFAULT 0 FOR DI023976;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023977 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023977;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023978 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023978;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023979 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023979;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023980 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023980;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023982 DEFAULT 0 FOR DI023982;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024007 DEFAULT 0 FOR DI024007;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024013 DEFAULT 0 FOR DI024013;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024004 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024004;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024005 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024005;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023992 DEFAULT 0 FOR DI023992;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024010 DEFAULT 0 FOR DI024010;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024008 DEFAULT 0 FOR DI024008;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024006 DEFAULT 0 FOR DI024006;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023983 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023983;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024011 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024011;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI024012 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024012;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023965 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023965;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023967 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023967;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023947 DEFAULT 0 FOR DI023947;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023951 DEFAULT 0 FOR DI023951;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023948 DEFAULT 0 FOR DI023948;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023952 DEFAULT 0 FOR DI023952;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023949 DEFAULT 0 FOR DI023949;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023953 DEFAULT 0 FOR DI023953;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023955 DEFAULT 0 FOR DI023955;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023950 DEFAULT 0 FOR DI023950;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023954 DEFAULT 0 FOR DI023954;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023990 DEFAULT 0 FOR DI023990;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023988 DEFAULT 0 FOR DI023988;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023989 DEFAULT 0 FOR DI023989;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023986 DEFAULT 0 FOR DI023986;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023999 DEFAULT 0 FOR DI023999;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023984 DEFAULT 0 FOR DI023984;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023997 DEFAULT 0 FOR DI023997;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023985 DEFAULT 0 FOR DI023985;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023998 DEFAULT 0 FOR DI023998;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023996 DEFAULT 0 FOR DI023996;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023958 DEFAULT 0 FOR DI023958;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023959 DEFAULT 0 FOR DI023959;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023960 DEFAULT 0 FOR DI023960;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023961 DEFAULT 0 FOR DI023961;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023962 DEFAULT 0 FOR DI023962;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023969 DEFAULT 0 FOR DI023969;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023970 DEFAULT 0 FOR DI023970;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023971 DEFAULT 0 FOR DI023971;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023972 DEFAULT 0 FOR DI023972;
ALTER TABLE DT841 ADD CONSTRAINT DEFAULTVALUE_DT841_DI023973 DEFAULT 0 FOR DI023973;

CREATE INDEX IDX_UUID_UNIQUE_841 ON DT841 (UUID ASC);

ALTER TABLE DT841 ADD CONSTRAINT UUID_UNIQUE_841 UNIQUE (UUID);

--
-- DT842
-- 

ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009850 DEFAULT 0 FOR DI009850;

ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009857 DEFAULT 0 FOR DI009857;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009858 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009858;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009859 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009859;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009860 DEFAULT 0 FOR DI009860;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009865 DEFAULT 0 FOR DI009865;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009866 DEFAULT 0 FOR DI009866;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI009867 DEFAULT 0 FOR DI009867;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI024051 DEFAULT 0 FOR DI024051;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI024052 DEFAULT 0 FOR DI024052;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI024053 DEFAULT 0 FOR DI024053;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI024049 DEFAULT 0 FOR DI024049;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI024054 DEFAULT 0 FOR DI024054;
ALTER TABLE DT842 ADD CONSTRAINT DEFAULTVALUE_DT842_DI010066 DEFAULT 0 FOR DI010066;

CREATE INDEX IDX_UUID_UNIQUE_842 ON DT842 (UUID ASC);

ALTER TABLE DT842 ADD CONSTRAINT UUID_UNIQUE_842 UNIQUE (UUID);

--
-- DT843
-- 

ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009877 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009877;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009878 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009878;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009879 DEFAULT 0 FOR DI009879;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009884 DEFAULT 0 FOR DI009884;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009885 DEFAULT 0 FOR DI009885;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009886 DEFAULT 0 FOR DI009886;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009887 DEFAULT 0 FOR DI009887;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009888 DEFAULT 0 FOR DI009888;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009889 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009889;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009890 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009890;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009891 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009891;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009892 DEFAULT 0 FOR DI009892;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009893 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009893;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009894 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009894;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024030 DEFAULT 0 FOR DI024030;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024031 DEFAULT 0 FOR DI024031;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024032 DEFAULT 0 FOR DI024032;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024033 DEFAULT 0 FOR DI024033;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024034 DEFAULT 0 FOR DI024034;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024035 DEFAULT 0 FOR DI024035;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024036 DEFAULT 0 FOR DI024036;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024037 DEFAULT 0 FOR DI024037;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024038 DEFAULT 0 FOR DI024038;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009902 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009902;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009903 DEFAULT 0 FOR DI009903;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI010076 DEFAULT 0 FOR DI010076;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024042 DEFAULT 0 FOR DI024042;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024043 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024043;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024044 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024044;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024045 DEFAULT 0 FOR DI024045;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024046 DEFAULT 0 FOR DI024046;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024047 DEFAULT 0 FOR DI024047;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024048 DEFAULT 0 FOR DI024048;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI022824 DEFAULT 0 FOR DI022824;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024018 DEFAULT 0 FOR DI024018;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024019 DEFAULT 0 FOR DI024019;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024015 DEFAULT 0 FOR DI024015;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024016 DEFAULT 0 FOR DI024016;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024017 DEFAULT 0 FOR DI024017;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024020 DEFAULT 0 FOR DI024020;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024021 DEFAULT 0 FOR DI024021;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024022 DEFAULT 0 FOR DI024022;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024023 DEFAULT 0 FOR DI024023;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024024 DEFAULT 0 FOR DI024024;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009901 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009901;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024026 DEFAULT 0 FOR DI024026;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024027 DEFAULT 0 FOR DI024027;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009895 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009895;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009899 DEFAULT 0 FOR DI009899;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009900 DEFAULT 0 FOR DI009900;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024039 DEFAULT 0 FOR DI024039;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024040 DEFAULT 0 FOR DI024040;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024041 DEFAULT 0 FOR DI024041;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009898 DEFAULT 0 FOR DI009898;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI024025 DEFAULT 0 FOR DI024025;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009896 DEFAULT 0 FOR DI009896;
ALTER TABLE DT843 ADD CONSTRAINT DEFAULTVALUE_DT843_DI009897 DEFAULT 0 FOR DI009897;

CREATE INDEX IDX_UUID_UNIQUE_843 ON DT843 (UUID ASC);

ALTER TABLE DT843 ADD CONSTRAINT UUID_UNIQUE_843 UNIQUE (UUID);

--
-- DT844
-- 

ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009906 DEFAULT 0 FOR DI009906;

ALTER TABLE DT844 ALTER COLUMN DI009909 varchar(18) NULL;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009913 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009913;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009914 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009914;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009915 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009915;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009916 DEFAULT 0 FOR DI009916;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009921 DEFAULT 0 FOR DI009921;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009922 DEFAULT 0 FOR DI009922;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009923 DEFAULT 0 FOR DI009923;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009924 DEFAULT 0 FOR DI009924;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009925 DEFAULT 0 FOR DI009925;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009926 DEFAULT 0 FOR DI009926;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009927 DEFAULT 0 FOR DI009927;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009928 DEFAULT 0 FOR DI009928;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009929 DEFAULT 0 FOR DI009929;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI009930 DEFAULT 0 FOR DI009930;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024067 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024067;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024090 DEFAULT 0 FOR DI024090;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024071 DEFAULT 0 FOR DI024071;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024084 DEFAULT 0 FOR DI024084;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024081 DEFAULT 0 FOR DI024081;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024080 DEFAULT 0 FOR DI024080;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024064 DEFAULT 0 FOR DI024064;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024065 DEFAULT 0 FOR DI024065;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024078 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024078;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024074 DEFAULT 0 FOR DI024074;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024089 DEFAULT 0 FOR DI024089;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024062 DEFAULT 0 FOR DI024062;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024091 DEFAULT 0 FOR DI024091;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024072 DEFAULT 0 FOR DI024072;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024063 DEFAULT 0 FOR DI024063;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024061 DEFAULT 0 FOR DI024061;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024068 DEFAULT 0 FOR DI024068;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024077 DEFAULT 0 FOR DI024077;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024087 DEFAULT 0 FOR DI024087;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024057 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024057;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024058 DEFAULT 0 FOR DI024058;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024085 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024085;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024082 DEFAULT 0 FOR DI024082;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024079 DEFAULT 0 FOR DI024079;
ALTER TABLE DT844 ADD CONSTRAINT DEFAULTVALUE_DT844_DI024055 DEFAULT 0 FOR DI024055;

CREATE INDEX IDX_UUID_UNIQUE_844 ON DT844 (UUID ASC);

ALTER TABLE DT844 ADD CONSTRAINT UUID_UNIQUE_844 UNIQUE (UUID);

--
-- DT845
-- 

ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009934 DEFAULT 0 FOR DI009934;

ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009941 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009941;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009942 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009942;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009943 DEFAULT 0 FOR DI009943;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009948 DEFAULT 0 FOR DI009948;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009949 DEFAULT 0 FOR DI009949;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009950 DEFAULT 0 FOR DI009950;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009952 DEFAULT 0 FOR DI009952;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009954 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009954;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009955 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI009955;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009956 DEFAULT 0 FOR DI009956;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009957 DEFAULT 0 FOR DI009957;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009958 DEFAULT 0 FOR DI009958;
ALTER TABLE DT845 ADD CONSTRAINT DEFAULTVALUE_DT845_DI009960 DEFAULT 0 FOR DI009960;

CREATE INDEX IDX_UUID_UNIQUE_845 ON DT845 (UUID ASC);

ALTER TABLE DT845 ADD CONSTRAINT UUID_UNIQUE_845 UNIQUE (UUID);

--
-- DT846
-- 

ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010121 DEFAULT 0 FOR DI010121;

ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010107 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010107;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010108 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010108;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010109 DEFAULT 0 FOR DI010109;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010114 DEFAULT 0 FOR DI010114;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010115 DEFAULT 0 FOR DI010115;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010116 DEFAULT 0 FOR DI010116;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI010167 DEFAULT 0 FOR DI010167;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI023652 DEFAULT 0 FOR DI023652;
ALTER TABLE DT846 ADD CONSTRAINT DEFAULTVALUE_DT846_DI023653 DEFAULT 0 FOR DI023653;

CREATE INDEX IDX_UUID_UNIQUE_846 ON DT846 (UUID ASC);

ALTER TABLE DT846 ADD CONSTRAINT UUID_UNIQUE_846 UNIQUE (UUID);

--
-- DT847
-- 

ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010160 DEFAULT 0 FOR DI010160;

ALTER TABLE DT847 ALTER COLUMN DI010161 numeric(10) NULL;
ALTER TABLE DT847 ALTER COLUMN DI010162 varchar(2) NULL;

ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010148 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010148;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010149 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010149;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010150 DEFAULT 0 FOR DI010150;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010155 DEFAULT 0 FOR DI010155;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010156 DEFAULT 0 FOR DI010156;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010157 DEFAULT 0 FOR DI010157;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010169 DEFAULT 0 FOR DI010169;
ALTER TABLE DT847 ADD CONSTRAINT DEFAULTVALUE_DT847_DI010196 DEFAULT 0 FOR DI010196;

CREATE INDEX IDX_UUID_UNIQUE_847 ON DT847 (UUID ASC);

ALTER TABLE DT847 ADD CONSTRAINT UUID_UNIQUE_847 UNIQUE (UUID);

--
-- DT848
-- 

ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022234 DEFAULT 0 FOR DI022234;

ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022220 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022220;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022221 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022221;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022222 DEFAULT 0 FOR DI022222;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022227 DEFAULT 0 FOR DI022227;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022228 DEFAULT 0 FOR DI022228;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022229 DEFAULT 0 FOR DI022229;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022239 DEFAULT 0 FOR DI022239;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022240 DEFAULT 0 FOR DI022240;
ALTER TABLE DT848 ADD CONSTRAINT DEFAULTVALUE_DT848_DI022243 DEFAULT 0 FOR DI022243;

CREATE INDEX IDX_UUID_UNIQUE_848 ON DT848 (UUID ASC);

ALTER TABLE DT848 ADD CONSTRAINT UUID_UNIQUE_848 UNIQUE (UUID);

--
-- DT849
-- 

ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022292 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022292;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022293 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022293;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022294 DEFAULT 0 FOR DI022294;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022299 DEFAULT 0 FOR DI022299;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022300 DEFAULT 0 FOR DI022300;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022301 DEFAULT 0 FOR DI022301;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022305 DEFAULT 0 FOR DI022305;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022306 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022306;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022307 DEFAULT 0 FOR DI022307;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022317 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022317;
ALTER TABLE DT849 ALTER COLUMN DI022318 VARCHAR(2);
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022362 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022362;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022364 DEFAULT 0 FOR DI022364;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022410 DEFAULT 0 FOR DI022410;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022563 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022563;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022752 DEFAULT 0 FOR DI022752;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI022982 DEFAULT 0 FOR DI022982;
ALTER TABLE DT849 ADD CONSTRAINT DEFAULTVALUE_DT849_DI041717 DEFAULT 0 FOR DI041717;

CREATE INDEX IDX_UUID_UNIQUE_849 ON DT849 (UUID ASC);

ALTER TABLE DT849 ADD CONSTRAINT UUID_UNIQUE_849 UNIQUE (UUID);

--
-- DT850
-- 

ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022319 DEFAULT 0 FOR DI022319;

ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022320 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022320;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022321 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022321;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022322 DEFAULT 0 FOR DI022322;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022327 DEFAULT 0 FOR DI022327;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022328 DEFAULT 0 FOR DI022328;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022329 DEFAULT 0 FOR DI022329;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022335 DEFAULT 0 FOR DI022335;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022336 DEFAULT 0 FOR DI022336;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022337 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022337;
ALTER TABLE DT850 ADD CONSTRAINT DEFAULTVALUE_DT850_DI022338 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022338;

CREATE INDEX IDX_UUID_UNIQUE_850 ON DT850 (UUID ASC);

ALTER TABLE DT850 ADD CONSTRAINT UUID_UNIQUE_850 UNIQUE (UUID);

--
-- DT851
-- 

ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022343 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022343;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022344 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022344;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022345 DEFAULT 0 FOR DI022345;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022350 DEFAULT 0 FOR DI022350;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022351 DEFAULT 0 FOR DI022351;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022352 DEFAULT 0 FOR DI022352;
ALTER TABLE DT851 ADD CONSTRAINT DEFAULTVALUE_DT851_DI022613 DEFAULT 0 FOR DI022613;

CREATE INDEX IDX_UUID_UNIQUE_851 ON DT851 (UUID ASC);

ALTER TABLE DT851 ADD CONSTRAINT UUID_UNIQUE_851 UNIQUE (UUID);

--
-- DT852
-- 

ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022423 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022423;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022424 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022424;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022425 DEFAULT 0 FOR DI022425;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022430 DEFAULT 0 FOR DI022430;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022431 DEFAULT 0 FOR DI022431;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022432 DEFAULT 0 FOR DI022432;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022436 DEFAULT 0 FOR DI022436;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022437 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022437;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022438 DEFAULT 0 FOR DI022438;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022439 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022439;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022442 DEFAULT 0 FOR DI022442;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022444 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022444;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022445 DEFAULT 0 FOR DI022445;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022446 DEFAULT 0 FOR DI022446;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022584 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022584;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022585 DEFAULT 0 FOR DI022585;
ALTER TABLE DT852 ADD CONSTRAINT DEFAULTVALUE_DT852_DI022588 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022588;

CREATE INDEX IDX_UUID_UNIQUE_852 ON DT852 (UUID ASC);

ALTER TABLE DT852 ADD CONSTRAINT UUID_UNIQUE_852 UNIQUE (UUID);

--
-- DT853
-- 

ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022451 DEFAULT 0 FOR DI022451;

ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022454 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022454;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022455 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022455;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022456 DEFAULT 0 FOR DI022456;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022461 DEFAULT 0 FOR DI022461;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022462 DEFAULT 0 FOR DI022462;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022463 DEFAULT 0 FOR DI022463;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022467 DEFAULT 0 FOR DI022467;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022468 DEFAULT 0 FOR DI022468;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022469 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022469;
ALTER TABLE DT853 ADD CONSTRAINT DEFAULTVALUE_DT853_DI022470 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022470;

CREATE INDEX IDX_UUID_UNIQUE_853 ON DT853 (UUID ASC);

ALTER TABLE DT853 ADD CONSTRAINT UUID_UNIQUE_853 UNIQUE (UUID);

--
-- DT854
-- 

ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022477 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022477;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022478 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022478;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022479 DEFAULT 0 FOR DI022479;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022484 DEFAULT 0 FOR DI022484;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022485 DEFAULT 0 FOR DI022485;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022486 DEFAULT 0 FOR DI022486;
ALTER TABLE DT854 ADD CONSTRAINT DEFAULTVALUE_DT854_DI022487 DEFAULT 0 FOR DI022487;

CREATE INDEX IDX_UUID_UNIQUE_854 ON DT854 (UUID ASC);

ALTER TABLE DT854 ADD CONSTRAINT UUID_UNIQUE_854 UNIQUE (UUID);

--
-- DT855
-- 

ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022656 DEFAULT 0 FOR DI022656;

ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022658 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022658;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022659 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022659;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022660 DEFAULT 0 FOR DI022660;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022665 DEFAULT 0 FOR DI022665;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022666 DEFAULT 0 FOR DI022666;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022667 DEFAULT 0 FOR DI022667;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022669 DEFAULT 0 FOR DI022669;
ALTER TABLE DT855 ADD CONSTRAINT DEFAULTVALUE_DT855_DI022671 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022671;

CREATE INDEX IDX_UUID_UNIQUE_855 ON DT855 (UUID ASC);

ALTER TABLE DT855 ADD CONSTRAINT UUID_UNIQUE_855 UNIQUE (UUID);

--
-- DT856
-- 

ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022983 DEFAULT 0 FOR DI022983;

ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022986 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022986;
ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022987 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022987;
ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022988 DEFAULT 0 FOR DI022988;
ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022993 DEFAULT 0 FOR DI022993;
ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022994 DEFAULT 0 FOR DI022994;
ALTER TABLE DT856 ADD CONSTRAINT DEFAULTVALUE_DT856_DI022995 DEFAULT 0 FOR DI022995;

CREATE INDEX IDX_UUID_UNIQUE_856 ON DT856 (UUID ASC);

ALTER TABLE DT856 ADD CONSTRAINT UUID_UNIQUE_856 UNIQUE (UUID);

--
-- DT858
-- 

ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023105 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023105;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023106 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023106;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023107 DEFAULT 0 FOR DI023107;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023112 DEFAULT 0 FOR DI023112;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023113 DEFAULT 0 FOR DI023113;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023114 DEFAULT 0 FOR DI023114;
ALTER TABLE DT858 ADD CONSTRAINT DEFAULTVALUE_DT858_DI023116 DEFAULT 0 FOR DI023116;
ALTER TABLE DT858
ADD DI062360 VARCHAR(10);

ALTER TABLE DT858
ADD DI062361 numeric(5,0) DEFAULT 0;

ALTER TABLE DT858
ADD DI062362 numeric(5,0) DEFAULT 0;

ALTER TABLE DT858
ADD DI063002 numeric(5,0) DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_858 ON DT858 (UUID ASC);

ALTER TABLE DT858 ADD CONSTRAINT UUID_UNIQUE_858 UNIQUE (UUID);

--
-- DT859
-- 

ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023053 DEFAULT 0 FOR DI023053;

ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023042 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023042;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023043 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023043;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023044 DEFAULT 0 FOR DI023044;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023049 DEFAULT 0 FOR DI023049;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023050 DEFAULT 0 FOR DI023050;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023051 DEFAULT 0 FOR DI023051;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023055 DEFAULT 0 FOR DI023055;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023056 DEFAULT 0 FOR DI023056;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023057 DEFAULT 0 FOR DI023057;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023058 DEFAULT 0 FOR DI023058;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023059 DEFAULT 0 FOR DI023059;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023060 DEFAULT 0 FOR DI023060;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023146 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023146;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023147 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023147;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI023149 DEFAULT 0 FOR DI023149;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040203 DEFAULT 0 FOR DI040203;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040247 DEFAULT 0 FOR DI040247;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040248 DEFAULT 0 FOR DI040248;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040249 DEFAULT 0 FOR DI040249;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040250 DEFAULT 0 FOR DI040250;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI040251 DEFAULT 0 FOR DI040251;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI041719 DEFAULT 0 FOR DI041719;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI041720 DEFAULT 0 FOR DI041720;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI041721 DEFAULT 0 FOR DI041721;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI041722 DEFAULT 0 FOR DI041722;
ALTER TABLE DT859 ADD CONSTRAINT DEFAULTVALUE_DT859_DI041723 DEFAULT 0 FOR DI041723;
ALTER TABLE DT859
ADD DI061322 float DEFAULT 0;

ALTER TABLE DT859
ADD DI061323 float DEFAULT 0;

ALTER TABLE DT859
ADD DI061355 float DEFAULT 0;

ALTER TABLE DT859
ADD DI061356 float DEFAULT 0;

ALTER TABLE DT859
ADD DI061354 float DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_859 ON DT859 (UUID ASC);

ALTER TABLE DT859 ADD CONSTRAINT UUID_UNIQUE_859 UNIQUE (UUID);

--
-- DT860
-- 

ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023097 DEFAULT 0 FOR DI023097;

ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023087 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023087;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023088 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023088;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023089 DEFAULT 0 FOR DI023089;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023094 DEFAULT 0 FOR DI023094;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023095 DEFAULT 0 FOR DI023095;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023096 DEFAULT 0 FOR DI023096;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI023139 DEFAULT 0 FOR DI023139;
ALTER TABLE DT860 ADD CONSTRAINT DEFAULTVALUE_DT860_DI041587 DEFAULT 0 FOR DI041587;

CREATE INDEX IDX_UUID_UNIQUE_860 ON DT860 (UUID ASC);

ALTER TABLE DT860 ADD CONSTRAINT UUID_UNIQUE_860 UNIQUE (UUID);

--
-- DT861
-- 

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023062 DEFAULT 0 FOR DI023062;

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023063 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023063;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023064 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023064;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023065 DEFAULT 0 FOR DI023065;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023070 DEFAULT 0 FOR DI023070;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023071 DEFAULT 0 FOR DI023071;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023072 DEFAULT 0 FOR DI023072;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023165 DEFAULT 0 FOR DI023165;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023166 DEFAULT 0 FOR DI023166;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023167 DEFAULT 0 FOR DI023167;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023168 DEFAULT 0 FOR DI023168;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023174 DEFAULT 0 FOR DI023174;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023175 DEFAULT 0 FOR DI023175;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023178 DEFAULT 0 FOR DI023178;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023179 DEFAULT 0 FOR DI023179;
ALTER TABLE DT861
ADD DI060780 float DEFAULT 0;

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023173 DEFAULT 0 FOR DI023173;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI023278 DEFAULT 0 FOR DI023278;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI034472 DEFAULT 0 FOR DI034472;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI034473 DEFAULT 0 FOR DI034473;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI034474 DEFAULT 0 FOR DI034474;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI034475 DEFAULT 0 FOR DI034475;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028556 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028556;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028558 DEFAULT 0 FOR DI028558;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028559 DEFAULT 0 FOR DI028559;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028560 DEFAULT 0 FOR DI028560;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028561 DEFAULT 0 FOR DI028561;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028562 DEFAULT 0 FOR DI028562;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028563 DEFAULT 0 FOR DI028563;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028564 DEFAULT 0 FOR DI028564;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028565 DEFAULT 0 FOR DI028565;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028566 DEFAULT 0 FOR DI028566;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028567 DEFAULT 0 FOR DI028567;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028568 DEFAULT 0 FOR DI028568;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028569 DEFAULT 0 FOR DI028569;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028570 DEFAULT 0 FOR DI028570;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028571 DEFAULT 0 FOR DI028571;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028572 DEFAULT 0 FOR DI028572;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028573 DEFAULT 0 FOR DI028573;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028574 DEFAULT 0 FOR DI028574;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028575 DEFAULT 0 FOR DI028575;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028576 DEFAULT 0 FOR DI028576;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028577 DEFAULT 0 FOR DI028577;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028578 DEFAULT 0 FOR DI028578;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028579 DEFAULT 0 FOR DI028579;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028580 DEFAULT 0 FOR DI028580;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028581 DEFAULT 0 FOR DI028581;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028582 DEFAULT 0 FOR DI028582;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028583 DEFAULT 0 FOR DI028583;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028584 DEFAULT 0 FOR DI028584;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028585 DEFAULT 0 FOR DI028585;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028586 DEFAULT 0 FOR DI028586;
ALTER TABLE DT861
ADD DI060779 float DEFAULT 0;

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI028831 DEFAULT 0 FOR DI028831;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040182 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI040182;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040198 DEFAULT 0 FOR DI040198;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040199 DEFAULT 0 FOR DI040199;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040200 DEFAULT 0 FOR DI040200;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040201 DEFAULT 0 FOR DI040201;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040202 DEFAULT 0 FOR DI040202;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI040282 DEFAULT 0 FOR DI040282;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041591 DEFAULT 0 FOR DI041591;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041590 DEFAULT 0 FOR DI041590;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041582 DEFAULT 0 FOR DI041582;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041580 DEFAULT 0 FOR DI041580;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041579 DEFAULT 0 FOR DI041579;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041581 DEFAULT 0 FOR DI041581;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041583 DEFAULT 0 FOR DI041583;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041622 DEFAULT 0 FOR DI041622;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041623 DEFAULT 0 FOR DI041623;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041624 DEFAULT 0 FOR DI041624;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041625 DEFAULT 0 FOR DI041625;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041626 DEFAULT 0 FOR DI041626;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041627 DEFAULT 0 FOR DI041627;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041628 DEFAULT 0 FOR DI041628;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041629 DEFAULT 0 FOR DI041629;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041630 DEFAULT 0 FOR DI041630;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041631 DEFAULT 0 FOR DI041631;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041632 DEFAULT 0 FOR DI041632;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041633 DEFAULT 0 FOR DI041633;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041634 DEFAULT 0 FOR DI041634;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041635 DEFAULT 0 FOR DI041635;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041636 DEFAULT 0 FOR DI041636;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041637 DEFAULT 0 FOR DI041637;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041638 DEFAULT 0 FOR DI041638;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041639 DEFAULT 0 FOR DI041639;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041640 DEFAULT 0 FOR DI041640;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041641 DEFAULT 0 FOR DI041641;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041642 DEFAULT 0 FOR DI041642;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041643 DEFAULT 0 FOR DI041643;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041644 DEFAULT 0 FOR DI041644;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041645 DEFAULT 0 FOR DI041645;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041646 DEFAULT 0 FOR DI041646;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041647 DEFAULT 0 FOR DI041647;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041648 DEFAULT 0 FOR DI041648;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041649 DEFAULT 0 FOR DI041649;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041650 DEFAULT 0 FOR DI041650;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041651 DEFAULT 0 FOR DI041651;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041652 DEFAULT 0 FOR DI041652;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041653 DEFAULT 0 FOR DI041653;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041654 DEFAULT 0 FOR DI041654;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041655 DEFAULT 0 FOR DI041655;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041656 DEFAULT 0 FOR DI041656;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041657 DEFAULT 0 FOR DI041657;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041658 DEFAULT 0 FOR DI041658;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041659 DEFAULT 0 FOR DI041659;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041660 DEFAULT 0 FOR DI041660;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041661 DEFAULT 0 FOR DI041661;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041662 DEFAULT 0 FOR DI041662;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041663 DEFAULT 0 FOR DI041663;
ALTER TABLE DT861
ADD DI061222 float DEFAULT 0;

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041664 DEFAULT 0 FOR DI041664;
ALTER TABLE DT861
ADD DI061223 float DEFAULT 0;

ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041665 DEFAULT 0 FOR DI041665;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041666 DEFAULT 0 FOR DI041666;
ALTER TABLE DT861 ADD CONSTRAINT DEFAULTVALUE_DT861_DI041667 DEFAULT 0 FOR DI041667;
ALTER TABLE DT861
ADD DI061224 float DEFAULT 0;

ALTER TABLE DT861
ADD DI061225 float DEFAULT 0;

ALTER TABLE DT861
ADD DI061227 float DEFAULT 0;

ALTER TABLE DT861
ADD DI060778 float DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_861 ON DT861 (UUID ASC);

ALTER TABLE DT861 ADD CONSTRAINT UUID_UNIQUE_861 UNIQUE (UUID);

ALTER TABLE DT861 DROP COLUMN DI023073;
ALTER TABLE DT861 DROP COLUMN DI023074;
ALTER TABLE DT861 DROP COLUMN DI023075;
ALTER TABLE DT861 DROP COLUMN DI023154;
ALTER TABLE DT861 DROP COLUMN DI023155;
ALTER TABLE DT861 DROP COLUMN DI023156;
ALTER TABLE DT861 DROP COLUMN DI023157;
ALTER TABLE DT861 DROP COLUMN DI023158;
ALTER TABLE DT861 DROP COLUMN DI023159;
ALTER TABLE DT861 DROP COLUMN DI023162;
ALTER TABLE DT861 DROP COLUMN DI023163;
ALTER TABLE DT861 DROP COLUMN DI023164;
ALTER TABLE DT861 DROP COLUMN DI023203;
ALTER TABLE DT861 DROP COLUMN DI023204;
ALTER TABLE DT861 DROP COLUMN DI023205;
ALTER TABLE DT861 DROP COLUMN DI023206;

--
-- DT861_MANUAL
-- 

ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059360 DEFAULT 0 FOR DI059360;
ALTER TABLE DT861_MANUAL
ADD UUID uniqueidentifier DEFAULT newid() not null;

ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059362 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI059362;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059363 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI059363;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059364 DEFAULT 0 FOR DI059364;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059369 DEFAULT 0 FOR DI059369;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059370 DEFAULT 0 FOR DI059370;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059371 DEFAULT 0 FOR DI059371;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059372 DEFAULT 0 FOR DI059372;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059373 DEFAULT 0 FOR DI059373;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059374 DEFAULT 0 FOR DI059374;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059375 DEFAULT 0 FOR DI059375;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059376 DEFAULT 0 FOR DI059376;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059377 DEFAULT 0 FOR DI059377;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059378 DEFAULT 0 FOR DI059378;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059379 DEFAULT 0 FOR DI059379;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059380 DEFAULT 0 FOR DI059380;
ALTER TABLE DT861_MANUAL
ADD DI061220 numeric DEFAULT 0;

ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059381 DEFAULT 0 FOR DI059381;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059382 DEFAULT 0 FOR DI059382;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059383 DEFAULT 0 FOR DI059383;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059384 DEFAULT 0 FOR DI059384;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059385 DEFAULT 0 FOR DI059385;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059386 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI059386;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059388 DEFAULT 0 FOR DI059388;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059389 DEFAULT 0 FOR DI059389;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059390 DEFAULT 0 FOR DI059390;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059391 DEFAULT 0 FOR DI059391;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059392 DEFAULT 0 FOR DI059392;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059393 DEFAULT 0 FOR DI059393;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059394 DEFAULT 0 FOR DI059394;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059395 DEFAULT 0 FOR DI059395;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059396 DEFAULT 0 FOR DI059396;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059397 DEFAULT 0 FOR DI059397;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059398 DEFAULT 0 FOR DI059398;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059399 DEFAULT 0 FOR DI059399;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059400 DEFAULT 0 FOR DI059400;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059401 DEFAULT 0 FOR DI059401;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059402 DEFAULT 0 FOR DI059402;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059403 DEFAULT 0 FOR DI059403;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059404 DEFAULT 0 FOR DI059404;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059405 DEFAULT 0 FOR DI059405;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059406 DEFAULT 0 FOR DI059406;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059407 DEFAULT 0 FOR DI059407;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059408 DEFAULT 0 FOR DI059408;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059409 DEFAULT 0 FOR DI059409;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059410 DEFAULT 0 FOR DI059410;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059411 DEFAULT 0 FOR DI059411;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059412 DEFAULT 0 FOR DI059412;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059413 DEFAULT 0 FOR DI059413;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059414 DEFAULT 0 FOR DI059414;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059415 DEFAULT 0 FOR DI059415;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059416 DEFAULT 0 FOR DI059416;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059417 DEFAULT 0 FOR DI059417;
ALTER TABLE DT861_MANUAL
ADD DI061221 numeric DEFAULT 0;

ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059419 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI059419;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059420 DEFAULT 0 FOR DI059420;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059421 DEFAULT 0 FOR DI059421;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059422 DEFAULT 0 FOR DI059422;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059423 DEFAULT 0 FOR DI059423;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059424 DEFAULT 0 FOR DI059424;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059425 DEFAULT 0 FOR DI059425;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059426 DEFAULT 0 FOR DI059426;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059427 DEFAULT 0 FOR DI059427;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059428 DEFAULT 0 FOR DI059428;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059429 DEFAULT 0 FOR DI059429;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059430 DEFAULT 0 FOR DI059430;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059431 DEFAULT 0 FOR DI059431;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059432 DEFAULT 0 FOR DI059432;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059433 DEFAULT 0 FOR DI059433;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059434 DEFAULT 0 FOR DI059434;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059435 DEFAULT 0 FOR DI059435;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059436 DEFAULT 0 FOR DI059436;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059437 DEFAULT 0 FOR DI059437;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059438 DEFAULT 0 FOR DI059438;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059439 DEFAULT 0 FOR DI059439;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059440 DEFAULT 0 FOR DI059440;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059441 DEFAULT 0 FOR DI059441;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059442 DEFAULT 0 FOR DI059442;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059443 DEFAULT 0 FOR DI059443;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059444 DEFAULT 0 FOR DI059444;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059445 DEFAULT 0 FOR DI059445;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059446 DEFAULT 0 FOR DI059446;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059447 DEFAULT 0 FOR DI059447;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059448 DEFAULT 0 FOR DI059448;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059449 DEFAULT 0 FOR DI059449;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059450 DEFAULT 0 FOR DI059450;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059451 DEFAULT 0 FOR DI059451;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059452 DEFAULT 0 FOR DI059452;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059453 DEFAULT 0 FOR DI059453;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059454 DEFAULT 0 FOR DI059454;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059455 DEFAULT 0 FOR DI059455;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059456 DEFAULT 0 FOR DI059456;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059457 DEFAULT 0 FOR DI059457;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059458 DEFAULT 0 FOR DI059458;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059459 DEFAULT 0 FOR DI059459;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059460 DEFAULT 0 FOR DI059460;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059461 DEFAULT 0 FOR DI059461;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059462 DEFAULT 0 FOR DI059462;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059463 DEFAULT 0 FOR DI059463;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059464 DEFAULT 0 FOR DI059464;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059465 DEFAULT 0 FOR DI059465;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059466 DEFAULT 0 FOR DI059466;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059467 DEFAULT 0 FOR DI059467;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059468 DEFAULT 0 FOR DI059468;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059469 DEFAULT 0 FOR DI059469;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059470 DEFAULT 0 FOR DI059470;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059471 DEFAULT 0 FOR DI059471;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059472 DEFAULT 0 FOR DI059472;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059473 DEFAULT 0 FOR DI059473;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059474 DEFAULT 0 FOR DI059474;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059475 DEFAULT 0 FOR DI059475;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059476 DEFAULT 0 FOR DI059476;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059477 DEFAULT 0 FOR DI059477;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT DEFAULTVALUE_DT861_MANUAL_DI059478 DEFAULT 0 FOR DI059478;

CREATE INDEX IDX_UUID_UNIQUE_861_MANUAL ON DT861_MANUAL (UUID ASC);

ALTER TABLE DT861_MANUAL ADD CONSTRAINT UUID_UNIQUE_861_MANUAL UNIQUE (UUID);

ALTER TABLE DT861_MANUAL DROP COLUMN DI023073;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023074;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023075;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023154;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023155;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023156;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023157;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023158;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023159;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023162;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023163;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023164;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023203;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023204;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023205;
ALTER TABLE DT861_MANUAL DROP COLUMN DI023206;

--
-- DT861_SAVE
-- 

DROP TABLE DT861_SAVE;

--
-- DT862
-- 

ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023084 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023084;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023012 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023012;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023013 DEFAULT 0 FOR DI023013;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023018 DEFAULT 0 FOR DI023018;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023019 DEFAULT 0 FOR DI023019;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023118 DEFAULT 0 FOR DI023118;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023033 DEFAULT 0 FOR DI023033;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023034 DEFAULT 0 FOR DI023034;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023250 DEFAULT 0 FOR DI023250;
ALTER TABLE DT862 ADD CONSTRAINT DEFAULTVALUE_DT862_DI023251 DEFAULT 0 FOR DI023251;

CREATE INDEX IDX_UUID_UNIQUE_862 ON DT862 (UUID ASC);

ALTER TABLE DT862 ADD CONSTRAINT UUID_UNIQUE_862 UNIQUE (UUID);

--
-- DT863
-- 

ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023021 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023021;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023022 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023022;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023023 DEFAULT 0 FOR DI023023;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023028 DEFAULT 0 FOR DI023028;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023029 DEFAULT 0 FOR DI023029;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023030 DEFAULT 0 FOR DI023030;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023285 DEFAULT 0 FOR DI023285;
ALTER TABLE DT863 ADD CONSTRAINT DEFAULTVALUE_DT863_DI023286 DEFAULT 0 FOR DI023286;

CREATE INDEX IDX_UUID_UNIQUE_863 ON DT863 (UUID ASC);

ALTER TABLE DT863 ADD CONSTRAINT UUID_UNIQUE_863 UNIQUE (UUID);

--
-- DT864
-- 

ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023228 DEFAULT 0 FOR DI023228;
ALTER TABLE DT864
ADD UUID uniqueidentifier DEFAULT newid() not null;

ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023230 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023230;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023231 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023231;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023232 DEFAULT 0 FOR DI023232;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023237 DEFAULT 0 FOR DI023237;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023238 DEFAULT 0 FOR DI023238;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI023239 DEFAULT 0 FOR DI023239;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028626 DEFAULT 0 FOR DI028626;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028627 DEFAULT 0 FOR DI028627;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028628 DEFAULT 0 FOR DI028628;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028629 DEFAULT 0 FOR DI028629;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028630 DEFAULT 0 FOR DI028630;
ALTER TABLE DT864 ADD CONSTRAINT DEFAULTVALUE_DT864_DI028631 DEFAULT 0 FOR DI028631;

CREATE INDEX IDX_UUID_UNIQUE_864 ON DT864 (UUID ASC);

ALTER TABLE DT864 ADD CONSTRAINT UUID_UNIQUE_864 UNIQUE (UUID);

--
-- DT865
-- 

ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023736 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023736;

ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023726 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023726;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023727 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI023727;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023728 DEFAULT 0 FOR DI023728;
ALTER TABLE DT865 ALTER COLUMN DI023729 VARCHAR(20);
ALTER TABLE DT865 ALTER COLUMN DI023730 VARCHAR(20);
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023733 DEFAULT 0 FOR DI023733;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023734 DEFAULT 0 FOR DI023734;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023735 DEFAULT 0 FOR DI023735;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023738 DEFAULT 0 FOR DI023738;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI023739 DEFAULT 0 FOR DI023739;
ALTER TABLE DT865 ADD CONSTRAINT DEFAULTVALUE_DT865_DI024781 DEFAULT 0 FOR DI024781;

CREATE INDEX IDX_UUID_UNIQUE_865 ON DT865 (UUID ASC);

ALTER TABLE DT865 ADD CONSTRAINT UUID_UNIQUE_865 UNIQUE (UUID);

--
-- DT866
-- 

ALTER TABLE DT866 DROP CONSTRAINT PID866DT866;

ALTER TABLE DT866 ALTER COLUMN DI028027 VARCHAR(8) NOT NULL;

ALTER TABLE DT866 ADD CONSTRAINT PID866DT866 PRIMARY KEY (DI028027);

ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028028 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028028;
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028029 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028029;
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028030 DEFAULT 0 FOR DI028030;
ALTER TABLE DT866 ALTER COLUMN DI028031 VARCHAR(20);
ALTER TABLE DT866 ALTER COLUMN DI028032 VARCHAR(20);
ALTER TABLE DT866 ALTER COLUMN DI028033 VARCHAR(4);
ALTER TABLE DT866 ALTER COLUMN DI028034 VARCHAR(8);
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028035 DEFAULT 0 FOR DI028035;
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028036 DEFAULT 0 FOR DI028036;
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028037 DEFAULT 0 FOR DI028037;
ALTER TABLE DT866 ADD CONSTRAINT DEFAULTVALUE_DT866_DI028038 DEFAULT 0 FOR DI028038;

CREATE INDEX IDX_UUID_UNIQUE_866 ON DT866 (UUID ASC);

ALTER TABLE DT866 ADD CONSTRAINT UUID_UNIQUE_866 UNIQUE (UUID);

--
-- DT867
-- 

ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034415 DEFAULT 0 FOR DI034415;
ALTER TABLE DT867
ADD UUID uniqueidentifier DEFAULT newid() not null;

ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034449 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034449;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034450 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034450;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034451 DEFAULT 0 FOR DI034451;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034456 DEFAULT 0 FOR DI034456;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034457 DEFAULT 0 FOR DI034457;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034458 DEFAULT 0 FOR DI034458;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034461 DEFAULT 0 FOR DI034461;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034462 DEFAULT 0 FOR DI034462;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034485 DEFAULT 0 FOR DI034485;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034486 DEFAULT 0 FOR DI034486;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034487 DEFAULT 0 FOR DI034487;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034488 DEFAULT 0 FOR DI034488;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034489 DEFAULT 0 FOR DI034489;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034490 DEFAULT 0 FOR DI034490;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034491 DEFAULT 0 FOR DI034491;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034492 DEFAULT 0 FOR DI034492;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034493 DEFAULT 0 FOR DI034493;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034494 DEFAULT 0 FOR DI034494;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034495 DEFAULT 0 FOR DI034495;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034496 DEFAULT 0 FOR DI034496;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034497 DEFAULT 0 FOR DI034497;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034498 DEFAULT 0 FOR DI034498;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034499 DEFAULT 0 FOR DI034499;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034500 DEFAULT 0 FOR DI034500;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034418 DEFAULT 0 FOR DI034418;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034419 DEFAULT 0 FOR DI034419;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034420 DEFAULT 0 FOR DI034420;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034421 DEFAULT 0 FOR DI034421;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034422 DEFAULT 0 FOR DI034422;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034423 DEFAULT 0 FOR DI034423;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034424 DEFAULT 0 FOR DI034424;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034425 DEFAULT 0 FOR DI034425;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034426 DEFAULT 0 FOR DI034426;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034427 DEFAULT 0 FOR DI034427;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034428 DEFAULT 0 FOR DI034428;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034429 DEFAULT 0 FOR DI034429;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034430 DEFAULT 0 FOR DI034430;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034431 DEFAULT 0 FOR DI034431;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034432 DEFAULT 0 FOR DI034432;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034433 DEFAULT 0 FOR DI034433;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034434 DEFAULT 0 FOR DI034434;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034435 DEFAULT 0 FOR DI034435;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034436 DEFAULT 0 FOR DI034436;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034437 DEFAULT 0 FOR DI034437;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034438 DEFAULT 0 FOR DI034438;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034439 DEFAULT 0 FOR DI034439;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034440 DEFAULT 0 FOR DI034440;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034441 DEFAULT 0 FOR DI034441;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034463 DEFAULT 0 FOR DI034463;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034464 DEFAULT 0 FOR DI034464;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034465 DEFAULT 0 FOR DI034465;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034466 DEFAULT 0 FOR DI034466;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034467 DEFAULT 0 FOR DI034467;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI034468 DEFAULT 0 FOR DI034468;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028597 DEFAULT 0 FOR DI028597;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028598 DEFAULT 0 FOR DI028598;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028599 DEFAULT 0 FOR DI028599;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028600 DEFAULT 0 FOR DI028600;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028601 DEFAULT 0 FOR DI028601;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028602 DEFAULT 0 FOR DI028602;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028603 DEFAULT 0 FOR DI028603;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028604 DEFAULT 0 FOR DI028604;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028605 DEFAULT 0 FOR DI028605;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028606 DEFAULT 0 FOR DI028606;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028607 DEFAULT 0 FOR DI028607;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028608 DEFAULT 0 FOR DI028608;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028609 DEFAULT 0 FOR DI028609;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028610 DEFAULT 0 FOR DI028610;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028611 DEFAULT 0 FOR DI028611;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028612 DEFAULT 0 FOR DI028612;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028613 DEFAULT 0 FOR DI028613;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028614 DEFAULT 0 FOR DI028614;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028615 DEFAULT 0 FOR DI028615;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028616 DEFAULT 0 FOR DI028616;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028617 DEFAULT 0 FOR DI028617;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028618 DEFAULT 0 FOR DI028618;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028619 DEFAULT 0 FOR DI028619;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028620 DEFAULT 0 FOR DI028620;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028621 DEFAULT 0 FOR DI028621;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028622 DEFAULT 0 FOR DI028622;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028623 DEFAULT 0 FOR DI028623;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028624 DEFAULT 0 FOR DI028624;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI028625 DEFAULT 0 FOR DI028625;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI040227 DEFAULT 0 FOR DI040227;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI040228 DEFAULT 0 FOR DI040228;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI040229 DEFAULT 0 FOR DI040229;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI040230 DEFAULT 0 FOR DI040230;
ALTER TABLE DT867 ADD CONSTRAINT DEFAULTVALUE_DT867_DI040231 DEFAULT 0 FOR DI040231;

CREATE INDEX IDX_UUID_UNIQUE_867 ON DT867 (UUID ASC);

ALTER TABLE DT867 ADD CONSTRAINT UUID_UNIQUE_867 UNIQUE (UUID);

--
-- DT868
-- 

ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028633 DEFAULT 0 FOR DI028633;
ALTER TABLE DT868
ADD UUID uniqueidentifier DEFAULT newid() not null;

ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028637 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028637;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028638 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028638;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028639 DEFAULT 0 FOR DI028639;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028644 DEFAULT 0 FOR DI028644;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028645 DEFAULT 0 FOR DI028645;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028646 DEFAULT 0 FOR DI028646;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028647 DEFAULT 0 FOR DI028647;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028648 DEFAULT 0 FOR DI028648;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028649 DEFAULT 0 FOR DI028649;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028650 DEFAULT 0 FOR DI028650;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028651 DEFAULT 0 FOR DI028651;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028652 DEFAULT 0 FOR DI028652;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028653 DEFAULT 0 FOR DI028653;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028926 DEFAULT 0 FOR DI028926;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028927 DEFAULT 0 FOR DI028927;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028928 DEFAULT 0 FOR DI028928;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028929 DEFAULT 0 FOR DI028929;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028930 DEFAULT 0 FOR DI028930;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028931 DEFAULT 0 FOR DI028931;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028932 DEFAULT 0 FOR DI028932;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028933 DEFAULT 0 FOR DI028933;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028934 DEFAULT 0 FOR DI028934;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028935 DEFAULT 0 FOR DI028935;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028936 DEFAULT 0 FOR DI028936;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028937 DEFAULT 0 FOR DI028937;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028938 DEFAULT 0 FOR DI028938;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028939 DEFAULT 0 FOR DI028939;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028940 DEFAULT 0 FOR DI028940;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028941 DEFAULT 0 FOR DI028941;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028942 DEFAULT 0 FOR DI028942;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028943 DEFAULT 0 FOR DI028943;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028944 DEFAULT 0 FOR DI028944;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028945 DEFAULT 0 FOR DI028945;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028946 DEFAULT 0 FOR DI028946;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028947 DEFAULT 0 FOR DI028947;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028948 DEFAULT 0 FOR DI028948;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028949 DEFAULT 0 FOR DI028949;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028950 DEFAULT 0 FOR DI028950;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028951 DEFAULT 0 FOR DI028951;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028952 DEFAULT 0 FOR DI028952;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028953 DEFAULT 0 FOR DI028953;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028954 DEFAULT 0 FOR DI028954;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028955 DEFAULT 0 FOR DI028955;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028956 DEFAULT 0 FOR DI028956;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028957 DEFAULT 0 FOR DI028957;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028958 DEFAULT 0 FOR DI028958;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028959 DEFAULT 0 FOR DI028959;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028960 DEFAULT 0 FOR DI028960;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028961 DEFAULT 0 FOR DI028961;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028962 DEFAULT 0 FOR DI028962;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028963 DEFAULT 0 FOR DI028963;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028964 DEFAULT 0 FOR DI028964;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028965 DEFAULT 0 FOR DI028965;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028966 DEFAULT 0 FOR DI028966;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028967 DEFAULT 0 FOR DI028967;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028968 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028968;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028970 DEFAULT 0 FOR DI028970;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028971 DEFAULT 0 FOR DI028971;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028972 DEFAULT 0 FOR DI028972;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028973 DEFAULT 0 FOR DI028973;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028974 DEFAULT 0 FOR DI028974;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028975 DEFAULT 0 FOR DI028975;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028976 DEFAULT 0 FOR DI028976;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028977 DEFAULT 0 FOR DI028977;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028978 DEFAULT 0 FOR DI028978;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028979 DEFAULT 0 FOR DI028979;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028980 DEFAULT 0 FOR DI028980;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028981 DEFAULT 0 FOR DI028981;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028982 DEFAULT 0 FOR DI028982;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028983 DEFAULT 0 FOR DI028983;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028984 DEFAULT 0 FOR DI028984;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028985 DEFAULT 0 FOR DI028985;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028986 DEFAULT 0 FOR DI028986;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028987 DEFAULT 0 FOR DI028987;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028988 DEFAULT 0 FOR DI028988;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028989 DEFAULT 0 FOR DI028989;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028990 DEFAULT 0 FOR DI028990;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028991 DEFAULT 0 FOR DI028991;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028992 DEFAULT 0 FOR DI028992;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028993 DEFAULT 0 FOR DI028993;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028994 DEFAULT 0 FOR DI028994;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028995 DEFAULT 0 FOR DI028995;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028996 DEFAULT 0 FOR DI028996;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028997 DEFAULT 0 FOR DI028997;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028998 DEFAULT 0 FOR DI028998;
ALTER TABLE DT868 ADD CONSTRAINT DEFAULTVALUE_DT868_DI028999 DEFAULT 0 FOR DI028999;

CREATE INDEX IDX_UUID_UNIQUE_868 ON DT868 (UUID ASC);

ALTER TABLE DT868 ADD CONSTRAINT UUID_UNIQUE_868 UNIQUE (UUID);

--
-- DT869
-- 

ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028666 DEFAULT 0 FOR DI028666;

ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028655 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028655;
ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028656 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028656;
ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028657 DEFAULT 0 FOR DI028657;
ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028662 DEFAULT 0 FOR DI028662;
ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028663 DEFAULT 0 FOR DI028663;
ALTER TABLE DT869 ADD CONSTRAINT DEFAULTVALUE_DT869_DI028664 DEFAULT 0 FOR DI028664;
ALTER TABLE DT869
ADD DI063007 numeric(5,0) DEFAULT 0;

ALTER TABLE DT869
ADD DI063110 VARCHAR(10);

CREATE INDEX IDX_UUID_UNIQUE_869 ON DT869 (UUID ASC);

ALTER TABLE DT869 ADD CONSTRAINT UUID_UNIQUE_869 UNIQUE (UUID);

--
-- DT870
-- 

ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028668 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028668;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028669 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028669;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028670 DEFAULT 0 FOR DI028670;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028675 DEFAULT 0 FOR DI028675;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028676 DEFAULT 0 FOR DI028676;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI028677 DEFAULT 0 FOR DI028677;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041783 DEFAULT 0 FOR DI041783;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041784 DEFAULT 0 FOR DI041784;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041785 DEFAULT 0 FOR DI041785;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041786 DEFAULT 0 FOR DI041786;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041787 DEFAULT 0 FOR DI041787;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041788 DEFAULT 0 FOR DI041788;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041789 DEFAULT 0 FOR DI041789;
ALTER TABLE DT870 ADD CONSTRAINT DEFAULTVALUE_DT870_DI041790 DEFAULT 0 FOR DI041790;
ALTER TABLE DT870
ADD DI061395 VARCHAR(20);

ALTER TABLE DT870
ADD PORTFOLIO_TYPE numeric(5,0) DEFAULT 0;

ALTER TABLE DT870
ADD DI062219 VARCHAR(10);

ALTER TABLE DT870
ADD DI062220 VARCHAR(10);

ALTER TABLE DT870
ADD DI062221 VARCHAR(10);

ALTER TABLE DT870
ADD DI062222 VARCHAR(10);

ALTER TABLE DT870
ADD DI062223 VARCHAR(10);

ALTER TABLE DT870
ADD DI062231 VARCHAR(2);

ALTER TABLE DT870
ADD DI062232 VARCHAR(2);

ALTER TABLE DT870
ADD DI062233 DATE DEFAULT CONVERT(datetime2,'01.01.1970',104);

ALTER TABLE DT870
ADD DI062234 DATE DEFAULT CONVERT(datetime2,'01.01.1970',104);

ALTER TABLE DT870
ADD DI062235 varchar(max);

ALTER TABLE DT870
ADD DI062236 varchar(max);

ALTER TABLE DT870
ADD DI062980 VARCHAR(120);

ALTER TABLE DT870
ADD DI062981 numeric(5,0) DEFAULT 0;

ALTER TABLE DT870
ADD DI062992 DATE DEFAULT CONVERT(datetime2,'01.01.1970',104);

CREATE INDEX IDX_UUID_UNIQUE_870 ON DT870 (UUID ASC);

ALTER TABLE DT870 ADD CONSTRAINT UUID_UNIQUE_870 UNIQUE (UUID);

ALTER TABLE DT870 DROP COLUMN DI028680;
ALTER TABLE DT870 DROP COLUMN DI028681;
ALTER TABLE DT870 DROP COLUMN DI028682;
ALTER TABLE DT870 DROP COLUMN DI028683;
ALTER TABLE DT870 DROP COLUMN DI028684;
ALTER TABLE DT870 DROP COLUMN DI028685;
ALTER TABLE DT870 DROP COLUMN DI028687;
ALTER TABLE DT870 DROP COLUMN DI028688;
ALTER TABLE DT870 DROP COLUMN DI028689;
ALTER TABLE DT870 DROP COLUMN DI040204;

--
-- DT871
-- 

ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028692 DEFAULT 0 FOR DI028692;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028835 DEFAULT 0 FOR DI028835;

ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028696 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028696;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028697 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI028697;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028698 DEFAULT 0 FOR DI028698;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028703 DEFAULT 0 FOR DI028703;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028704 DEFAULT 0 FOR DI028704;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028705 DEFAULT 0 FOR DI028705;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028695 DEFAULT 0 FOR DI028695;
ALTER TABLE DT871 ADD CONSTRAINT DEFAULTVALUE_DT871_DI028706 DEFAULT 0 FOR DI028706;

CREATE INDEX IDX_UUID_UNIQUE_871 ON DT871 (UUID ASC);

ALTER TABLE DT871 ADD CONSTRAINT UUID_UNIQUE_871 UNIQUE (UUID);

--
-- DT872
-- 

ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029623 DEFAULT 0 FOR DI029623;

ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029625 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029625;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029626 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029626;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029627 DEFAULT 0 FOR DI029627;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029632 DEFAULT 0 FOR DI029632;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029633 DEFAULT 0 FOR DI029633;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029634 DEFAULT 0 FOR DI029634;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029637 DEFAULT 0 FOR DI029637;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029638 DEFAULT 0 FOR DI029638;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029640 DEFAULT 0 FOR DI029640;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029641 DEFAULT 0 FOR DI029641;
ALTER TABLE DT872 ADD CONSTRAINT DEFAULTVALUE_DT872_DI029646 DEFAULT 0 FOR DI029646;
ALTER TABLE DT872
ADD DI062991 numeric(5,0) DEFAULT 0;

ALTER TABLE DT872
ADD DI062997 numeric(5,0) DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_872 ON DT872 (UUID ASC);

ALTER TABLE DT872 ADD CONSTRAINT UUID_UNIQUE_872 UNIQUE (UUID);

ALTER TABLE DT872 DROP COLUMN DI029648;

--
-- DT873
-- 

ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029650 DEFAULT 0 FOR DI029650;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029651 DEFAULT 0 FOR DI029651;

ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029654 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029654;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029655 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI029655;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029656 DEFAULT 0 FOR DI029656;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029661 DEFAULT 0 FOR DI029661;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029662 DEFAULT 0 FOR DI029662;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029663 DEFAULT 0 FOR DI029663;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029664 DEFAULT 0 FOR DI029664;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029666 DEFAULT 0 FOR DI029666;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029672 DEFAULT 0 FOR DI029672;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029673 DEFAULT 0 FOR DI029673;
ALTER TABLE DT873 ADD CONSTRAINT DEFAULTVALUE_DT873_DI029674 DEFAULT 0 FOR DI029674;

CREATE INDEX IDX_UUID_UNIQUE_873 ON DT873 (UUID ASC);

ALTER TABLE DT873 ADD CONSTRAINT UUID_UNIQUE_873 UNIQUE (UUID);

--
-- DT874
-- 

ALTER TABLE DT874 DROP CONSTRAINT PID874DT874;

ALTER TABLE DT874 ALTER COLUMN DI053227 VARCHAR(8) NOT NULL;

ALTER TABLE DT874 ADD CONSTRAINT PID874DT874 PRIMARY KEY (DI053227);

ALTER TABLE DT874 ADD CONSTRAINT DEFAULTVALUE_DT874_DI053230 DEFAULT 0 FOR DI053230;
ALTER TABLE DT874 ALTER COLUMN DI053231 VARCHAR(20);
ALTER TABLE DT874 ALTER COLUMN DI053232 VARCHAR(20);
ALTER TABLE DT874 ALTER COLUMN DI053233 VARCHAR(4);
ALTER TABLE DT874 ALTER COLUMN DI053234 VARCHAR(8);
ALTER TABLE DT874 ADD CONSTRAINT DEFAULTVALUE_DT874_DI053235 DEFAULT 0 FOR DI053235;
ALTER TABLE DT874 ADD CONSTRAINT DEFAULTVALUE_DT874_DI053236 DEFAULT 0 FOR DI053236;
ALTER TABLE DT874 ADD CONSTRAINT DEFAULTVALUE_DT874_DI053237 DEFAULT 0 FOR DI053237;

CREATE INDEX IDX_ITEXT_DT874DI053238 ON DT874 (DI053238 ASC);

CREATE INDEX IDX_UUID_UNIQUE_874 ON DT874 (UUID ASC);

ALTER TABLE DT874 ADD CONSTRAINT UUID_UNIQUE_874 UNIQUE (UUID);

--
-- DT875
-- 

ALTER TABLE DT875 DROP CONSTRAINT PID875DT875;

ALTER TABLE DT875 ALTER COLUMN DI053239 VARCHAR(8) NOT NULL;

ALTER TABLE DT875 ADD CONSTRAINT PID875DT875 PRIMARY KEY (DI053239);

ALTER TABLE DT875 ADD CONSTRAINT DEFAULTVALUE_DT875_DI053242 DEFAULT 0 FOR DI053242;
ALTER TABLE DT875 ALTER COLUMN DI053243 VARCHAR(20);
ALTER TABLE DT875 ALTER COLUMN DI053244 VARCHAR(20);
ALTER TABLE DT875 ALTER COLUMN DI053245 VARCHAR(4);
ALTER TABLE DT875 ALTER COLUMN DI053246 VARCHAR(8);
ALTER TABLE DT875 ADD CONSTRAINT DEFAULTVALUE_DT875_DI053247 DEFAULT 0 FOR DI053247;
ALTER TABLE DT875 ADD CONSTRAINT DEFAULTVALUE_DT875_DI053248 DEFAULT 0 FOR DI053248;
ALTER TABLE DT875 ADD CONSTRAINT DEFAULTVALUE_DT875_DI053249 DEFAULT 0 FOR DI053249;

CREATE INDEX IDX_ITEXT_DT875DI053250 ON DT875 (DI053250 ASC);

CREATE INDEX IDX_UUID_UNIQUE_875 ON DT875 (UUID ASC);

ALTER TABLE DT875 ADD CONSTRAINT UUID_UNIQUE_875 UNIQUE (UUID);

--
-- DT876
-- 

ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057878 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI057878;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057865 DEFAULT 0 FOR DI057865;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057867 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI057867;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057868 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI057868;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057869 DEFAULT 0 FOR DI057869;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057874 DEFAULT 0 FOR DI057874;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057875 DEFAULT 0 FOR DI057875;
ALTER TABLE DT876 ADD CONSTRAINT DEFAULTVALUE_DT876_DI057876 DEFAULT 0 FOR DI057876;
DROP INDEX DT876.SID876DT876;

CREATE UNIQUE INDEX IDX_PID876DT876 ON DT876 (DI057880 ASC);

CREATE INDEX IDX_UUID_UNIQUE_876 ON DT876 (UUID ASC);

ALTER TABLE DT876 ADD CONSTRAINT PID876DT876 PRIMARY KEY (DI057880);

ALTER TABLE DT876 ADD CONSTRAINT UUID_UNIQUE_876 UNIQUE (UUID);

--
-- DT877
-- 

ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057898 DEFAULT 0 FOR DI057898;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057900 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI057900;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057901 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI057901;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057902 DEFAULT 0 FOR DI057902;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057907 DEFAULT 0 FOR DI057907;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057908 DEFAULT 0 FOR DI057908;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI057909 DEFAULT 0 FOR DI057909;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI059058 DEFAULT 0 FOR DI059058;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI059059 DEFAULT 0 FOR DI059059;
ALTER TABLE DT877 ADD CONSTRAINT DEFAULTVALUE_DT877_DI059255 DEFAULT 0 FOR DI059255;

CREATE INDEX IDX_UUID_UNIQUE_877 ON DT877 (UUID ASC);

ALTER TABLE DT877 ADD CONSTRAINT UUID_UNIQUE_877 UNIQUE (UUID);

--
-- DT880
-- 

DROP TABLE DT880;

--
-- DT881
-- 

DROP TABLE DT881;

--
-- DT882
-- 

DROP TABLE DT882;

--
-- DT884
-- 

ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058005 DEFAULT 0 FOR DI058005;

ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058010 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI058010;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058011 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI058011;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058012 DEFAULT 0 FOR DI058012;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058017 DEFAULT 0 FOR DI058017;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058018 DEFAULT 0 FOR DI058018;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058019 DEFAULT 0 FOR DI058019;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058020 DEFAULT 0 FOR DI058020;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058024 DEFAULT 0 FOR DI058024;
ALTER TABLE DT884 ADD CONSTRAINT DEFAULTVALUE_DT884_DI058035 DEFAULT 0 FOR DI058035;

CREATE INDEX IDX_UUID_UNIQUE_884 ON DT884 (UUID ASC);

ALTER TABLE DT884 ADD CONSTRAINT UUID_UNIQUE_884 UNIQUE (UUID);

--
-- DT885
-- 

ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041326 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI041326;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041327 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI041327;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041328 DEFAULT 0 FOR DI041328;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041333 DEFAULT 0 FOR DI041333;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041334 DEFAULT 0 FOR DI041334;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041335 DEFAULT 0 FOR DI041335;
ALTER TABLE DT885 ALTER COLUMN DI041325 numeric(10) NULL;
ALTER TABLE DT885 ADD CONSTRAINT DEFAULTVALUE_DT885_DI041386 DEFAULT 0 FOR DI041386;

CREATE INDEX IDX_UUID_UNIQUE_885 ON DT885 (UUID ASC);

ALTER TABLE DT885 ADD CONSTRAINT UUID_UNIQUE_885 UNIQUE (UUID);

DROP INDEX DT885.SID461DT885;
ALTER TABLE DT885 DROP COLUMN DI041520;

--
-- DT886
-- 

ALTER TABLE DT886 ALTER COLUMN DI041336 varchar(18) NULL;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041337 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI041337;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041338 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI041338;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041339 DEFAULT 0 FOR DI041339;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041343 DEFAULT 0 FOR DI041343;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041344 DEFAULT 0 FOR DI041344;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041345 DEFAULT 0 FOR DI041345;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI041508 DEFAULT 0 FOR DI041508;
ALTER TABLE DT886 ADD CONSTRAINT DEFAULTVALUE_DT886_DI057784 DEFAULT 0 FOR DI057784;
ALTER TABLE DT886
ADD DI061404 numeric(5,0) DEFAULT 0;

ALTER TABLE DT886
ADD DI062976 numeric(5,0) DEFAULT 0;

CREATE INDEX IDX_UUID_UNIQUE_886 ON DT886 (UUID ASC);

ALTER TABLE DT886 ADD CONSTRAINT UUID_UNIQUE_886 UNIQUE (UUID);

DROP INDEX DT886.DT886_DI041508;
DROP INDEX DT886.SID885DT886;

--
-- DT887
-- 

ALTER TABLE DT887 ALTER COLUMN DI056921 varchar(6) NULL;
ALTER TABLE DT887 ALTER COLUMN DI056936 varchar(8) NULL;
ALTER TABLE DT887 ALTER COLUMN DI056939 numeric(10,0);
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056931 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI056931;
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056930 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI056930;
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056929 DEFAULT 0 FOR DI056929;
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056924 DEFAULT 0 FOR DI056924;
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056923 DEFAULT 0 FOR DI056923;
ALTER TABLE DT887 ADD CONSTRAINT DEFAULTVALUE_DT887_DI056922 DEFAULT 0 FOR DI056922;
DROP INDEX DT887.SID887DT887;

CREATE UNIQUE INDEX PID887DT887 ON DT887 (DI056935 ASC);

CREATE INDEX IDX_UUID_UNIQUE_887 ON DT887 (UUID ASC);

ALTER TABLE DT887 ADD CONSTRAINT UUID_UNIQUE_887 UNIQUE (UUID);

--
-- DT888
-- 

ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034565 DEFAULT 0 FOR DI034565;

ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034567 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034567;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034568 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034568;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034569 DEFAULT 0 FOR DI034569;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034574 DEFAULT 0 FOR DI034574;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034575 DEFAULT 0 FOR DI034575;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034576 DEFAULT 0 FOR DI034576;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034635 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034635;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034636 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034636;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034588 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034588;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034589 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034589;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034590 DEFAULT 0 FOR DI034590;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034613 DEFAULT 0 FOR DI034613;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034638 DEFAULT 0 FOR DI034638;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034637 DEFAULT 0 FOR DI034637;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034625 DEFAULT 0 FOR DI034625;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034626 DEFAULT 0 FOR DI034626;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034627 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034627;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034628 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034628;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034634 DEFAULT 0 FOR DI034634;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034642 DEFAULT 0 FOR DI034642;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034643 DEFAULT 0 FOR DI034643;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034581 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034581;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034582 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034582;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034583 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034583;
ALTER TABLE DT888 ADD CONSTRAINT DEFAULTVALUE_DT888_DI034584 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI034584;

CREATE INDEX IDX_UUID_UNIQUE_888 ON DT888 (UUID ASC);

ALTER TABLE DT888 ADD CONSTRAINT UUID_UNIQUE_888 UNIQUE (UUID);

--
-- DT900
-- 

DROP TABLE DT900;

--
-- DT901
-- 

DROP TABLE DT901;

--
-- DT902
-- 

DROP TABLE DT902;

--
-- DT903
-- 

DROP TABLE DT903;

--
-- DT904
-- 

DROP TABLE DT904;

--
-- DT905
-- 

DROP TABLE DT905;

--
-- DT906
-- 

DROP TABLE DT906;

--
-- DT907
-- 

DROP TABLE DT907;

--
-- DT908
-- 

DROP TABLE DT908;

--
-- DT909
-- 

DROP TABLE DT909;

--
-- DT910
-- 

DROP TABLE DT910;

--
-- DT911
-- 

DROP TABLE DT911;

--
-- DT912
-- 

DROP TABLE DT912;

--
-- DT913
-- 

DROP TABLE DT913;

--
-- DT914
-- 

DROP TABLE DT914;

--
-- DT916
-- 

DROP TABLE DT916;

--
-- DT917
-- 

DROP TABLE DT917;

--
-- DT918
-- 

DROP TABLE DT918;

--
-- DT919
-- 

DROP TABLE DT919;

--
-- DT920
-- 

DROP TABLE DT920;

--
-- DT921
-- 

DROP TABLE DT921;

--
-- DT922
-- 

DROP TABLE DT922;

--
-- DT923
-- 

DROP TABLE DT923;

--
-- DT924
-- 

DROP TABLE DT924;

--
-- DT925
-- 

DROP TABLE DT925;

--
-- DT926
-- 

DROP TABLE DT926;

--
-- DT927
-- 

DROP TABLE DT927;

--
-- DT928
-- 

DROP TABLE DT928;

--
-- DT929
-- 

DROP TABLE DT929;

--
-- DT930
-- 

DROP TABLE DT930;

--
-- DT931
-- 

DROP TABLE DT931;

--
-- DT932
-- 

DROP TABLE DT932;

--
-- DT933
-- 

DROP TABLE DT933;

--
-- DT935
-- 

DROP TABLE DT935;

--
-- DT936
-- 

DROP TABLE DT936;

--
-- DT938
-- 

DROP TABLE DT938;

--
-- DT939
-- 

DROP TABLE DT939;

--
-- DT940
-- 

DROP TABLE DT940;

--
-- DT941
-- 

DROP TABLE DT941;

--
-- DT942
-- 

DROP TABLE DT942;

--
-- DT943
-- 

DROP TABLE DT943;

--
-- DT944
-- 

DROP TABLE DT944;

--
-- DT945
-- 

DROP TABLE DT945;

--
-- DT946
-- 

ALTER TABLE DT946 DROP CONSTRAINT PID946DT946;

ALTER TABLE DT946 ALTER COLUMN DI026798 VARCHAR(8) NOT NULL;
ALTER TABLE DT946 ALTER COLUMN DI025762 varchar(20) NULL;
ALTER TABLE DT946 ALTER COLUMN DI025764 varchar(8) NULL;
ALTER TABLE DT946 ALTER COLUMN DI025765 varchar(4) NULL;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024607 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024607;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024608 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024608;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024609 DEFAULT 0 FOR DI024609;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024614 DEFAULT 0 FOR DI024614;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024615 DEFAULT 0 FOR DI024615;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI024616 DEFAULT 0 FOR DI024616;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025787 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025787;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025788 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025788;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025789 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025789;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025790 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025790;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025791 DEFAULT 0 FOR DI025791;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025795 DEFAULT 0 FOR DI025795;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI025796 DEFAULT 0 FOR DI025796;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040143 DEFAULT 0 FOR DI040143;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040144 DEFAULT 0 FOR DI040144;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040145 DEFAULT 0 FOR DI040145;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040191 DEFAULT 0 FOR DI040191;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040192 DEFAULT 0 FOR DI040192;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040193 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI040193;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040195 DEFAULT 0 FOR DI040195;
ALTER TABLE DT946 ADD CONSTRAINT DEFAULTVALUE_DT946_DI040196 DEFAULT 0 FOR DI040196;

CREATE INDEX IDX_ITEXT_DT946DI025792 ON DT946 (DI025792 ASC);

CREATE INDEX IDX_SIDT504DT946 ON DT946 (DI025762 ASC);

CREATE INDEX IDX_SIDT956DT946 ON DT946 (DI025764 ASC, DI025765 ASC);

CREATE INDEX IDX_SIDT959DT946 ON DT946 (DI026798 ASC);

CREATE INDEX IDX_UUID_UNIQUE_946 ON DT946 (UUID ASC);

ALTER TABLE DT946 ADD CONSTRAINT PID946DT946 PRIMARY KEY (DI026797);
ALTER TABLE DT946 ADD CONSTRAINT UUID_UNIQUE_946 UNIQUE (UUID);

--
-- DT947
-- 

ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024876 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024876;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024877 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024877;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024878 DEFAULT 0 FOR DI024878;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024883 DEFAULT 0 FOR DI024883;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024884 DEFAULT 0 FOR DI024884;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI024885 DEFAULT 0 FOR DI024885;
ALTER TABLE DT947 ADD CONSTRAINT DEFAULTVALUE_DT947_DI027961 DEFAULT 0 FOR DI027961;

CREATE INDEX IDX_ITEXT_DT947DI024886 ON DT947 (DI024886 ASC);

CREATE INDEX IDX_UUID_UNIQUE_947 ON DT947 (UUID ASC);

ALTER TABLE DT947 ADD CONSTRAINT UUID_UNIQUE_947 UNIQUE (UUID);

--
-- DT948
-- 

DROP TABLE DT948;

--
-- DT949
-- 

DROP TABLE DT949;

--
-- DT950
-- 

ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010442 DEFAULT 0 FOR DI010442;

ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010443 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010443;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010444 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010444;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010445 DEFAULT 0 FOR DI010445;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010451 DEFAULT 0 FOR DI010451;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010452 DEFAULT 0 FOR DI010452;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010453 DEFAULT 0 FOR DI010453;
ALTER TABLE DT950 ADD CONSTRAINT DEFAULTVALUE_DT950_DI010447 DEFAULT 0 FOR DI010447;

CREATE INDEX IDX_UUID_UNIQUE_950 ON DT950 (UUID ASC);

ALTER TABLE DT950 ADD CONSTRAINT UUID_UNIQUE_950 UNIQUE (UUID);

--
-- DT951
-- 

ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010455 DEFAULT 0 FOR DI010455;

ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010459 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010459;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010460 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010460;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010461 DEFAULT 0 FOR DI010461;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010466 DEFAULT 0 FOR DI010466;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010467 DEFAULT 0 FOR DI010467;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI010468 DEFAULT 0 FOR DI010468;
ALTER TABLE DT951 ADD CONSTRAINT DEFAULTVALUE_DT951_DI028176 DEFAULT 0 FOR DI028176;

CREATE INDEX IDX_UUID_UNIQUE_951 ON DT951 (UUID ASC);

ALTER TABLE DT951 ADD CONSTRAINT UUID_UNIQUE_951 UNIQUE (UUID);

--
-- DT952
-- 

ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010470 DEFAULT 0 FOR DI010470;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010471 DEFAULT 0 FOR DI010471;

ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010473 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010473;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010474 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010474;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010475 DEFAULT 0 FOR DI010475;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010480 DEFAULT 0 FOR DI010480;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010481 DEFAULT 0 FOR DI010481;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010482 DEFAULT 0 FOR DI010482;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI010483 DEFAULT 0 FOR DI010483;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI024553 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024553;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI024554 DEFAULT 0 FOR DI024554;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI027106 DEFAULT 0 FOR DI027106;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI027107 DEFAULT 0 FOR DI027107;
ALTER TABLE DT952 ADD CONSTRAINT DEFAULTVALUE_DT952_DI059201 DEFAULT 0 FOR DI059201;

CREATE INDEX IDX_UUID_UNIQUE_952 ON DT952 (UUID ASC);

ALTER TABLE DT952 ADD CONSTRAINT UUID_UNIQUE_952 UNIQUE (UUID);

--
-- DT953
-- 

ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010487 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010487;
ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010488 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010488;
ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010489 DEFAULT 0 FOR DI010489;
ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010494 DEFAULT 0 FOR DI010494;
ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010495 DEFAULT 0 FOR DI010495;
ALTER TABLE DT953 ADD CONSTRAINT DEFAULTVALUE_DT953_DI010496 DEFAULT 0 FOR DI010496;

CREATE INDEX IDX_UUID_UNIQUE_953 ON DT953 (UUID ASC);

ALTER TABLE DT953 ADD CONSTRAINT UUID_UNIQUE_953 UNIQUE (UUID);

--
-- DT955
-- 

ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI010519 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010519;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI010520 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010520;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI010521 DEFAULT 0 FOR DI010521;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI022393 DEFAULT 0 FOR DI022393;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI022394 DEFAULT 0 FOR DI022394;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI022395 DEFAULT 0 FOR DI022395;
ALTER TABLE DT955 ALTER COLUMN DI010543 VARCHAR(8);
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI010553 DEFAULT 0 FOR DI010553;
ALTER TABLE DT955 ADD CONSTRAINT DEFAULTVALUE_DT955_DI021947 DEFAULT 0 FOR DI021947;

CREATE INDEX IDX_UUID_UNIQUE_955 ON DT955 (UUID ASC);

ALTER TABLE DT955 ADD CONSTRAINT UUID_UNIQUE_955 UNIQUE (UUID);

--
-- DT956
-- 

ALTER TABLE DT956 ALTER COLUMN DI010516 numeric(10,0) NULL;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010529 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010529;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010530 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI010530;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010531 DEFAULT 0 FOR DI010531;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010536 DEFAULT 0 FOR DI010536;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010537 DEFAULT 0 FOR DI010537;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI010538 DEFAULT 0 FOR DI010538;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI022016 DEFAULT 0 FOR DI022016;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI022110 DEFAULT 0 FOR DI022110;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI022106 DEFAULT 0 FOR DI022106;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI025641 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025641;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI025642 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025642;
ALTER TABLE DT956 ADD CONSTRAINT DEFAULTVALUE_DT956_DI028051 DEFAULT 0 FOR DI028051;

CREATE INDEX IDX_UUID_UNIQUE_956 ON DT956 (UUID ASC);

ALTER TABLE DT956 ADD CONSTRAINT UUID_UNIQUE_956 UNIQUE (UUID);

DROP INDEX DT956.SID987DT956;

--
-- DT957
-- 

DROP TABLE DT957;

--
-- DT958
-- 

DROP TABLE DT958;

--
-- DT959
-- 

ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024584 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024584;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024585 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024585;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024586 DEFAULT 0 FOR DI024586;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024591 DEFAULT 0 FOR DI024591;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024592 DEFAULT 0 FOR DI024592;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024593 DEFAULT 0 FOR DI024593;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024595 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024595;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024596 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024596;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024597 DEFAULT 0 FOR DI024597;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024600 DEFAULT 0 FOR DI024600;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI024601 DEFAULT 0 FOR DI024601;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI026120 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI026120;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI027141 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI027141;
ALTER TABLE DT959 ADD CONSTRAINT DEFAULTVALUE_DT959_DI027142 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI027142;

CREATE INDEX IDX_ITEXT_DT959DI024598 ON DT959 (DI024598 ASC);
CREATE INDEX IDX_ITEXT_DT959DI025949 ON DT959 (DI025949 ASC);
CREATE INDEX IDX_ITEXT_DT959DI025950 ON DT959 (DI025950 ASC);
CREATE INDEX SIDT995DT959 ON DT959 (DI024572 ASC);
CREATE INDEX IDX_UUID_UNIQUE_959 ON DT959 (UUID ASC);

ALTER TABLE DT959 ADD CONSTRAINT UUID_UNIQUE_959 UNIQUE (UUID);

--
-- DT960
-- 

DROP TABLE DT960;

--
-- DT961
-- 

DROP TABLE DT961;

--
-- DT962
-- 

DROP TABLE DT962;

--
-- DT965
-- 

DROP TABLE DT965;

--
-- DT966
-- 

DROP TABLE DT966;

--
-- DT967
-- 

DROP TABLE DT967;

--
-- DT968
-- 

DROP TABLE DT968;

--
-- DT969
-- 

DROP TABLE DT969;

--
-- DT970
-- 

DROP TABLE DT970;

--
-- DT971
-- 

DROP TABLE DT971;

--
-- DT972
-- 

DROP TABLE DT972;

--
-- DT973
-- 

DROP TABLE DT973;

--
-- DT977
-- 

DROP TABLE DT977;

--
-- DT979
-- 

DROP TABLE DT979;

--
-- DT980
-- 

DROP TABLE DT980;

--
-- DT981
-- 

DROP TABLE DT981;

--
-- DT982
-- 

DROP TABLE DT982;

--
-- DT983
-- 

DROP TABLE DT983;

--
-- DT984
-- 

DROP TABLE DT984;

--
-- DT985
-- 

DROP TABLE DT985;

--
-- DT986
-- 

DROP TABLE DT986;

--
-- DT987
-- 

DROP TABLE DT987;

--
-- DT988
-- 

ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021246 DEFAULT 0 FOR DI021246;

ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021230 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021230;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021231 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021231;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021232 DEFAULT 0 FOR DI021232;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021237 DEFAULT 0 FOR DI021237;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021238 DEFAULT 0 FOR DI021238;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021239 DEFAULT 0 FOR DI021239;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021314 DEFAULT 0 FOR DI021314;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI021779 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021779;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI022113 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022113;
ALTER TABLE DT988 ADD CONSTRAINT DEFAULTVALUE_DT988_DI022114 DEFAULT 0 FOR DI022114;

CREATE INDEX IDX_UUID_UNIQUE_988 ON DT988 (UUID ASC);

ALTER TABLE DT988 ADD CONSTRAINT UUID_UNIQUE_988 UNIQUE (UUID);

--
-- DT989
-- 

DROP TABLE DT989;

--
-- DT990
-- 

DROP TABLE DT990;

--
-- DT991
-- 

DROP TABLE DT991;

--
-- DT992
-- 

ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021569 DEFAULT 0 FOR DI021569;

ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021572 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021572;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021573 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021573;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021574 DEFAULT 0 FOR DI021574;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021579 DEFAULT 0 FOR DI021579;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021580 DEFAULT 0 FOR DI021580;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021581 DEFAULT 0 FOR DI021581;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021583 DEFAULT 0 FOR DI021583;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI021788 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI021788;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI022117 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI022117;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI027166 DEFAULT 0 FOR DI027166;
ALTER TABLE DT992 ADD CONSTRAINT DEFAULTVALUE_DT992_DI025889 DEFAULT 0 FOR DI025889;

CREATE INDEX IDX_UUID_UNIQUE_992 ON DT992 (UUID ASC);

ALTER TABLE DT992 ADD CONSTRAINT UUID_UNIQUE_992 UNIQUE (UUID);

--
-- DT993
-- 

DROP TABLE DT993;

--
-- DT994
-- 

DROP TABLE DT994;

--
-- DT995
-- 

ALTER TABLE DT995 ALTER COLUMN DI024573 numeric(10,0) NULL;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024574 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024574;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024575 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI024575;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024576 DEFAULT 0 FOR DI024576;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024581 DEFAULT 0 FOR DI024581;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024582 DEFAULT 0 FOR DI024582;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI024583 DEFAULT 0 FOR DI024583;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI025564 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025564;
ALTER TABLE DT995 ADD CONSTRAINT DEFAULTVALUE_DT995_DI025565 DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR DI025565;

CREATE INDEX IDX_UUID_UNIQUE_995 ON DT995 (UUID ASC);

ALTER TABLE DT995 ADD CONSTRAINT UUID_UNIQUE_995 UNIQUE (UUID);

--
-- DT996
-- 

DROP TABLE DT996;

--
-- DT997
-- 

DROP TABLE DT997;

--
-- DT998
-- 

DROP TABLE DT998;

--
-- DT999
-- 

DROP TABLE DT999;

--
-- INTERFACE_CONFIG
-- 

DECLARE @SQL NVARCHAR(MAX) = N''

SELECT @SQL += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'INTERFACE_CONFIG' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL);


ALTER TABLE INTERFACE_CONFIG ALTER COLUMN COPIED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN OWN_LIC varchar(4) NOT NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN "ANY" numeric(5,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN LOGLEVEL numeric(10,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN FINISHED numeric(5,0) NULL;
ALTER TABLE INTERFACE_CONFIG ALTER COLUMN TEMPLATE numeric(5,0) NULL;

ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_COPIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR COPIED_ON;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_ANY DEFAULT 0 FOR "ANY";
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_LOGLEVEL DEFAULT 0 FOR LOGLEVEL;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_FINISHED DEFAULT 0 FOR FINISHED;
ALTER TABLE INTERFACE_CONFIG ADD CONSTRAINT DEFAULTVALUE_INTERF_CONFIG_TEMPLATE DEFAULT 0 FOR TEMPLATE;

CREATE INDEX SIDT405INTERFACE_CONFIG ON INTERFACE_CONFIG (SOURCE_MODULE ASC);
CREATE INDEX SIDT405INTERFACE_CONFIG_1 ON INTERFACE_CONFIG (TARGET_MODULE ASC);
CREATE INDEX SIDT405INTERFACE_CONFIG_2 ON INTERFACE_CONFIG (POOL_MODULE ASC);

--
-- INTERFACE_LOGGING
-- 

DECLARE @SQL1 NVARCHAR(MAX) = N''

SELECT @SQL1 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'INTERFACE_LOGGING' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL1);

ALTER TABLE INTERFACE_LOGGING ALTER COLUMN CONFIG_ID uniqueidentifier NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN "ANY" numeric(5,0) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN LOGLEVEL numeric(10,0) NULL;
ALTER TABLE INTERFACE_LOGGING ALTER COLUMN "OBJECT" uniqueidentifier NULL;

ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_ANY DEFAULT 0 FOR "ANY";
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_LOGLEVEL DEFAULT 0 FOR LOGLEVEL;
ALTER TABLE INTERFACE_LOGGING ADD CONSTRAINT DEFAULTVALUE_INTERF_LOG_POSITION DEFAULT 0 FOR POSITION;

CREATE INDEX SIINTERFACE_CONFIGINTERFACE_2 ON INTERFACE_LOGGING (CONFIG_ID ASC);

--
-- INTERFACE_MAPPING
-- 

DECLARE @SQL2 NVARCHAR(MAX) = N''

SELECT @SQL2 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'INTERFACE_MAPPING' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL2);

ALTER TABLE INTERFACE_MAPPING ALTER COLUMN CONFIG_ID uniqueidentifier NULL;
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_PARENT_ID DEFAULT NULL FOR PARENT_ID;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN OWN_LIC varchar(4) NOT NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN "ANY" numeric(5,0) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN POSITION numeric(5,0) NULL;
ALTER TABLE INTERFACE_MAPPING ALTER COLUMN "TYPE" numeric(10,0) NULL;

ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_ANY DEFAULT 0 FOR "ANY";
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_POSITION DEFAULT 0 FOR POSITION;
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT DEFAULTVALUE_INTERF_MAPPING_TYPE DEFAULT 0 FOR "TYPE";

CREATE INDEX SIINTERFACE_CONFIGINTERFACE_1 ON INTERFACE_MAPPING (CONFIG_ID ASC);
CREATE INDEX SIINTERFACE_MAPPINGINTERFAC ON INTERFACE_MAPPING (PARENT_ID ASC);

--
-- INTERFACE_PARAMETER
-- 

DECLARE @SQL3 NVARCHAR(MAX) = N''

SELECT @SQL3 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'INTERFACE_PARAMETER' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL3);

ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN CONFIG_ID uniqueidentifier NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN OWN_LIC varchar(4) NOT NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE INTERFACE_PARAMETER ALTER COLUMN "ANY" numeric(5,0) NULL;

ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE INTERFACE_PARAMETER ADD CONSTRAINT DEFAULTVALUE_INTERF_PARAM_ANY DEFAULT 0 FOR "ANY";

CREATE INDEX SIINTERFACE_CONFIGINTERFACE ON INTERFACE_PARAMETER (CONFIG_ID ASC);

--
-- LOG
-- 

DROP TABLE LOG;

--
-- MAPPING_PARAMETER
-- 

DECLARE @SQL4 NVARCHAR(MAX) = N''

SELECT @SQL4 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MAPPING_PARAMETER' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL4);

ALTER TABLE MAPPING_PARAMETER ALTER COLUMN MAPPING_ID uniqueidentifier NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN OWN_LIC varchar(4) NOT NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE MAPPING_PARAMETER ALTER COLUMN "ANY" numeric(5,0) NULL;

ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE MAPPING_PARAMETER ADD CONSTRAINT DEFAULTVALUE_MAPPING_PARAM_ANY DEFAULT 0 FOR "ANY";

CREATE INDEX SIINTERFACE_MAPPINGMAPPING_ ON MAPPING_PARAMETER (MAPPING_ID ASC);

--
-- MIGRATIONHISTORY
-- 

DECLARE @SQL5 NVARCHAR(MAX) = N''

SELECT @SQL5 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MIGRATIONHISTORY' AND (NAME LIKE '%CREAT%' OR NAME LIKE '%MODIF%')

EXECUTE(@SQL5);

ALTER TABLE MIGRATIONHISTORY ALTER COLUMN MIGRATIONRULE uniqueidentifier NULL;
ALTER TABLE MIGRATIONHISTORY ADD CONSTRAINT DEFAULTVALUE_MIGRATIONHISTORY_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MIGRATIONHISTORY ADD CONSTRAINT DEFAULTVALUE_MIGRATIONHISTORY_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MIGRATIONHISTORY ALTER COLUMN "TIMESTAMP" numeric(10,0) NULL;

CREATE INDEX SIMIGRATIONRULEMIGRATIONHIS ON MIGRATIONHISTORY (MIGRATIONRULE ASC);

--
-- MIGRATIONRULE
-- 

DECLARE @SQL6 NVARCHAR(MAX) = N''

SELECT @SQL6 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MIGRATIONRULE' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL6);

ALTER TABLE MIGRATIONRULE ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN "ANY" numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN SYSTEMSTART numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN DONE numeric(5,0) NULL;
ALTER TABLE MIGRATIONRULE ALTER COLUMN DUMMY_NEW numeric(5,0) NULL;

ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_ANY DEFAULT 0 FOR "ANY";
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_VERSION DEFAULT 0 FOR "VERSION";
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_SYSTEMSTART DEFAULT 0 FOR SYSTEMSTART;
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_DONE DEFAULT 0 FOR DONE;
ALTER TABLE MIGRATIONRULE ADD CONSTRAINT DEFAULTVALUE_MIGRATIONRULE_DUMMY DEFAULT 0 FOR DUMMY_NEW;

--
-- MITARBEITER_POOL
-- 

DECLARE @SQL7 NVARCHAR(MAX) = N''

SELECT @SQL7 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MITARBEITER_POOL' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL7);


ALTER TABLE MITARBEITER_POOL ALTER COLUMN CONFIG_ID uniqueidentifier NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN CREATED_ON datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN MODIFIED_ON datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN RWDU numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN "OWNER" numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN "GROUP" numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN "ANY" numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN "STATUS"numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN "START_DATE" datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN END_DATE datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN BIRTHDATE datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN GENDER numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN START_PERIOD datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN END_PERIOD datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN UNITS_DAY float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN FACTOR_AMOUNT float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN LEFT_ON datetime2(7) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN DEF_MIN_LOAD float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN AUT_REP_HRS_WORKED numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN LOAD_LIMIT numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN CALENDAR_IS_ACTIVE numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN SUM_OF_EFFORT numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN SUMMARIZE_PERIODS numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN RES_TO_BE_PLANED numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN DEF_MAX_LOAD float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN WITHOUT_COST_CALC numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN VAC_CREDIT_LAST_YR float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN VAC_CREDIT_CURR_YR float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN FLEXHRS_CRED_PR_YEAR float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN CALC_BASIS_DATE float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN POSITION float NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN RHW_OVERLAP_COMPL_2 numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN REP_TYPE numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN ADJUSTMENT_BY_EFFORT numeric(5,0) NULL;
ALTER TABLE MITARBEITER_POOL ALTER COLUMN CREATE_STAKEHOLDER numeric(5,0) NULL;

ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_RWDU DEFAULT 0 FOR RWDU;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_GROUP DEFAULT 0 FOR "GROUP";
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_ANY DEFAULT 0 FOR "ANY";
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_STATUS DEFAULT 0 FOR "STATUS";
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_START_DATE DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR "START_DATE";
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_END_DATE DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR END_DATE;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_BIRTHDATE DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR BIRTHDATE;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_GENDER DEFAULT 0 FOR GENDER;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_START_PERIOD DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR START_PERIOD;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_END_PERIOD DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR END_PERIOD;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_UNITS_DAY DEFAULT 0 FOR UNITS_DAY;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_FACTOR_AMOUNT DEFAULT 0 FOR FACTOR_AMOUNT;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_LEFT_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR LEFT_ON;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_DEF_MIN_LOAD DEFAULT 0 FOR DEF_MIN_LOAD;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_AUT_REP_HRS_WORK DEFAULT 0 FOR AUT_REP_HRS_WORKED;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_LOAD_LIMIT DEFAULT 0 FOR LOAD_LIMIT;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_CALENDAR_IS_ACTIVE DEFAULT 0 FOR CALENDAR_IS_ACTIVE;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_SUM_OF_EFFORT DEFAULT 0 FOR SUM_OF_EFFORT;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_SUMMARIZE_PERIODS DEFAULT 0 FOR SUMMARIZE_PERIODS;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_RES_TO_BE_PLANED DEFAULT 0 FOR RES_TO_BE_PLANED;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_DEF_MAX_LOAD DEFAULT 0 FOR DEF_MAX_LOAD;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_WITHOUT_COST_CALC DEFAULT 0 FOR WITHOUT_COST_CALC;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_VAC_CREDIT_LAST_YR DEFAULT 0 FOR VAC_CREDIT_LAST_YR;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_VAC_CREDIT_CURR_YR DEFAULT 0 FOR VAC_CREDIT_CURR_YR;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_FLEXHRS_CRED_PR_YR DEFAULT 0 FOR FLEXHRS_CRED_PR_YEAR;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_CALC_BASIS_DATE DEFAULT 0 FOR CALC_BASIS_DATE;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_POSITION DEFAULT 0 FOR POSITION;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_RHW_OVERLAP_COMPL_2 DEFAULT 0 FOR RHW_OVERLAP_COMPL_2;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_REP_TYPE DEFAULT 0 FOR REP_TYPE;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_ADJUSTMENT_BY_EFFORT DEFAULT 0 FOR ADJUSTMENT_BY_EFFORT;
ALTER TABLE MITARBEITER_POOL ADD CONSTRAINT DEFAULTVALUE_MITARBEITER_CREATE_STAKEHOLDER DEFAULT 0 FOR CREATE_STAKEHOLDER;

CREATE INDEX SIINTERFACE_CONFIGMITARBEIT ON MITARBEITER_POOL (CONFIG_ID ASC);

--
-- MSPI_LINK
-- 

DECLARE @SQL8 NVARCHAR(MAX) = N''

SELECT @SQL8 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MSPI_LINK' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL8);

ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_LINK_ID DEFAULT 0 FOR LINK_ID;

ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_PRED_MSP_ID DEFAULT 0 FOR PRED_MSP_ID;
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_SUCC_MSP_ID DEFAULT 0 FOR SUCC_MSP_ID;
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_CRUD DEFAULT 0 FOR CRUD;
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_GROUP_ DEFAULT 0 FOR "GROUP_";
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_ANY_ DEFAULT 0 FOR "ANY_";
ALTER TABLE MSPI_LINK ADD CONSTRAINT DEFAULTVALUE_MSPI_LINK_LINK_TYPE DEFAULT 0 FOR LINK_TYPE;

CREATE INDEX SIMSPI_TASKMSPI_LINK ON MSPI_LINK (PRED_MSP_ID ASC);
CREATE INDEX SIMSPI_TASKMSPI_LINK_1 ON MSPI_LINK (SUCC_MSP_ID ASC);
CREATE INDEX IDX_UUID_UNIQUE_807 ON MSPI_LINK (UUID ASC);

ALTER TABLE MSPI_LINK ADD CONSTRAINT UUID_UNIQUE_807 UNIQUE (UUID);

--
-- MSPI_TASK
-- 

DECLARE @SQL9 NVARCHAR(MAX) = N''

SELECT @SQL9 += N'
ALTER TABLE ' + OBJECT_NAME(PARENT_OBJECT_ID) + ' DROP CONSTRAINT ' + OBJECT_NAME(OBJECT_ID) + ';' 
FROM SYS.OBJECTS
WHERE TYPE_DESC LIKE '%CONSTRAINT' AND OBJECT_NAME(PARENT_OBJECT_ID) = 'MSPI_TASK' AND NAME LIKE 'DF__%' AND NAME NOT LIKE '%UUID%'

EXECUTE(@SQL9);

ALTER TABLE MSPI_TASK ALTER COLUMN PR_ID varchar(18) NULL;

ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_MSP_ID DEFAULT 0 FOR MSP_ID;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_VERSION_ID DEFAULT 0 FOR VERSION_ID;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_CREATED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR CREATED_ON;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_MODIFIED_ON DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR MODIFIED_ON;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_CRUD DEFAULT 0 FOR CRUD;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_OWNER DEFAULT 0 FOR "OWNER";
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_GROUP DEFAULT 0 FOR "GROUP_";
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_ANY DEFAULT 0 FOR "ANY_";
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_START_DATE DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR "START_DATE";
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_FINISH_DATE DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR "FINISH_DATE";
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_DURATION DEFAULT 0 FOR DURATION;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_PERCENT_COMPLETE DEFAULT 0 FOR PERCENT_COMPLETE;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_CHANGE_STATE DEFAULT 0 FOR CHANGE_STATE;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_SUMMARY_TASK DEFAULT 0 FOR SUMMARY_TASK;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_MILESTONE DEFAULT 0 FOR MILESTONE;
ALTER TABLE MSPI_TASK ADD CONSTRAINT DEFAULTVALUE_MSPI_TASK_PARENT_TASK DEFAULT 0 FOR PARENT_TASK;

CREATE INDEX SIDT463MSPI_TASK ON MSPI_TASK (PR_ID ASC, TASK_ID ASC);
CREATE INDEX SIMSPI_TASKMSPI_TASK ON MSPI_TASK (PARENT_TASK ASC);
CREATE INDEX IDX_UUID_UNIQUE_806 ON MSPI_TASK (UUID ASC);

ALTER TABLE MSPI_TASK ADD CONSTRAINT UUID_UNIQUE_806 UNIQUE (UUID);

--
-- TABLE_DEL_LOG
-- 

DROP TABLE TABLE_DEL_LOG;


DROP INDEX [PARENT_PR+PARENT_TASK+PR+TASK] ON DT463 WITH ( ONLINE = OFF );
DROP INDEX [SID463DT463] ON DT463;
DROP INDEX [PK_covering_query] ON DT463;
DROP INDEX [RECURSION_PARENT] ON DT463;
DROP INDEX [IDX_DT467_EVA_RES_Type] ON DT467;
DROP INDEX [SID466DT472] ON DT472;

ALTER TABLE DT463 DROP CONSTRAINT [PK_DT463];
ALTER TABLE DT467 DROP CONSTRAINT [PID467DT467];
ALTER TABLE DT472 DROP CONSTRAINT [PID472DT472];
ALTER TABLE DT818 DROP CONSTRAINT [PID818DT818];

ALTER TABLE DT463 ALTER COLUMN DI001097 VARCHAR(18) NOT NULL;
ALTER TABLE DT463 ALTER COLUMN DI001098 VARCHAR(18) NOT NULL;
ALTER TABLE DT463 ALTER COLUMN DI008851 VARCHAR(18) NULL;
ALTER TABLE DT466 ALTER COLUMN DI001393 VARCHAR(8) NULL;
ALTER TABLE DT467 ALTER COLUMN DI001218 VARCHAR(20) NOT NULL;
ALTER TABLE DT467 ALTER COLUMN DI009753 VARCHAR(20) NULL;
ALTER TABLE DT467 ALTER COLUMN DI000440 VARCHAR(8) NULL;
ALTER TABLE DT472 ALTER COLUMN DI001395 VARCHAR(18) NOT NULL;
ALTER TABLE DT472 ALTER COLUMN DI001516 VARCHAR(18) NULL;
ALTER TABLE DT472 ALTER COLUMN DI001517 VARCHAR(20) NULL;
ALTER TABLE DT472 ALTER COLUMN DI001518 VARCHAR(8) NULL;
ALTER TABLE DT818 ALTER COLUMN DI007935 VARCHAR(8) NOT NULL;
ALTER TABLE DT818 ALTER COLUMN DI007936 VARCHAR(20) NOT NULL;

CREATE UNIQUE CLUSTERED INDEX [PARENT_PR+PARENT_TASK+PR+TASK] ON DT463
(
	[DI008850] ASC,
	[DI008851] ASC,
	[DI001097] ASC,
	[DI001098] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];

CREATE UNIQUE NONCLUSTERED INDEX [PK_covering_query] ON DT463
(
	[DI001097] ASC,
	[DI001098] ASC
)
INCLUDE ( 	[DI008850],
	[DI008851]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];

CREATE NONCLUSTERED INDEX [RECURSION_PARENT] ON DT463
(
	[DI008850] ASC,
	[DI008851] ASC
)
INCLUDE ( 	[DI001097],
	[DI001098]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];
    
ALTER TABLE DT463 ADD CONSTRAINT [PK_DT463] PRIMARY KEY NONCLUSTERED 
(
	[DI001097] ASC,
	[DI001098] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]


CREATE NONCLUSTERED INDEX [IDX_DT467_EVA_RES_Type] ON DT467
(
	[DI001218] ASC,
	[DI003414] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY];


ALTER TABLE DT472 ADD CONSTRAINT [PID472DT472] PRIMARY KEY CLUSTERED 
(
	[DI001395] ASC,
	[DI001400] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];


ALTER TABLE DT467 ADD  CONSTRAINT [PID467DT467] PRIMARY KEY CLUSTERED 
(
	[DI001218] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];


ALTER TABLE DT818 ADD  CONSTRAINT [PID818DT818] PRIMARY KEY CLUSTERED 
(
	[DI007935] ASC,
	[DI007936] ASC,
	[DI007937] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY];


ALTER TABLE DT002 ADD CONSTRAINT SDT002ID441 FOREIGN KEY (DI024783) REFERENCES DT441 (DI000446);
ALTER TABLE DT006 ADD CONSTRAINT SDT006ID014 FOREIGN KEY (DI025227) REFERENCES DT014 (DI025168)
                                             ON DELETE CASCADE;
ALTER TABLE DT006 ADD CONSTRAINT SDT006ID504 FOREIGN KEY (DI026265) REFERENCES DT504 (DI024930)
                                             ON DELETE CASCADE;
ALTER TABLE DT007 ADD CONSTRAINT SDT007ID016 FOREIGN KEY (DI025298) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT007 ADD CONSTRAINT SDT007ID466 FOREIGN KEY (DI025827,DI025828,DI025831) REFERENCES DT466 (DI001390, DI001391, DI001392)
                                             ON DELETE CASCADE;
ALTER TABLE DT007 ADD CONSTRAINT SDT007ID504 FOREIGN KEY (DI026279) REFERENCES DT504 (DI024930)
                                             ON DELETE CASCADE;
ALTER TABLE DT015 ADD CONSTRAINT SDT015ID014 FOREIGN KEY (DI025195) REFERENCES DT014 (DI025168)
                                             ON DELETE CASCADE;
ALTER TABLE DT017 ADD CONSTRAINT SDT017ID016 FOREIGN KEY (DI025262) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT018 ADD CONSTRAINT SDT018ID014 FOREIGN KEY (DI025320) REFERENCES DT014 (DI025168)
                                             ON DELETE CASCADE;
ALTER TABLE DT018 ADD CONSTRAINT SDT018ID016 FOREIGN KEY (DI025349) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT022 ADD CONSTRAINT SDT022ID014 FOREIGN KEY (DI025351) REFERENCES DT014 (DI025168)
                                             ON DELETE CASCADE;
ALTER TABLE DT023 ADD CONSTRAINT SDT023ID016 FOREIGN KEY (DI025365) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT027 ADD CONSTRAINT SDT027ID016 FOREIGN KEY (DI027564) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT027 ADD CONSTRAINT SDT027ID028 FOREIGN KEY (DI027565) REFERENCES DT028 (DI027548)
                                             ON DELETE CASCADE;
ALTER TABLE DT037 ADD CONSTRAINT SDT037ID441 FOREIGN KEY (DI025488) REFERENCES DT441 (DI000446);
ALTER TABLE DT042 ADD CONSTRAINT SDT042ID017 FOREIGN KEY (DI027881,DI027882) REFERENCES DT017 (DI025262, DI025263);
ALTER TABLE DT042 ADD CONSTRAINT SDT042ID027 FOREIGN KEY (DI027880) REFERENCES DT027 (DI027858);
ALTER TABLE DT043 ADD CONSTRAINT SDT043ID016 FOREIGN KEY (DI025843) REFERENCES DT016 (DI025240)
                                             ON DELETE CASCADE;
ALTER TABLE DT043 ADD CONSTRAINT SDT043ID849 FOREIGN KEY (DI025844) REFERENCES DT849 (DI022291)
                                             ON DELETE CASCADE;
ALTER TABLE DT044 ADD CONSTRAINT SDT044ID014 FOREIGN KEY (DI025892) REFERENCES DT014 (DI025168)
                                             ON DELETE CASCADE;
ALTER TABLE DT044 ADD CONSTRAINT SDT044ID028 FOREIGN KEY (DI025893) REFERENCES DT028 (DI027548)
                                             ON DELETE CASCADE;
ALTER TABLE DT055 ADD CONSTRAINT SDT055ID405 FOREIGN KEY (DI025733) REFERENCES DT405 (DI000123);
ALTER TABLE DT055 ADD CONSTRAINT SDT055ID405A FOREIGN KEY (DI025734) REFERENCES DT405 (DI000123)
                                              ON DELETE CASCADE;
ALTER TABLE DT061 ADD CONSTRAINT SDT061ID060 FOREIGN KEY (DI029548) REFERENCES DT060 (DI029535)
                                             ON DELETE CASCADE;
ALTER TABLE DT324 ADD CONSTRAINT SDT324ID443 FOREIGN KEY (DI004367) REFERENCES DT443 (DI001595)
                                             ON DELETE CASCADE;
ALTER TABLE DT343 ADD CONSTRAINT SDT343ID342 FOREIGN KEY (DI024373) REFERENCES DT342 (DI024359)
                                             ON DELETE CASCADE;
ALTER TABLE DT346 ADD CONSTRAINT SDT346ID345 FOREIGN KEY (DI024676) REFERENCES DT345 (DI024408);
ALTER TABLE DT346 ADD CONSTRAINT SDT346ID420 FOREIGN KEY (DI024675) REFERENCES DT420 (DI000289);
ALTER TABLE DT346 ADD CONSTRAINT SDT346ID458 FOREIGN KEY (DI024860) REFERENCES DT458 (DI003190);
ALTER TABLE DT391 ADD CONSTRAINT SDT391ID390 FOREIGN KEY (DI029703) REFERENCES DT390 (DI029692);
ALTER TABLE DT392 ADD CONSTRAINT SDT392ID452 FOREIGN KEY (DI009467) REFERENCES DT452 (DI000859)
                                             ON DELETE CASCADE;
ALTER TABLE DT398 ADD CONSTRAINT SDT398ID399 FOREIGN KEY (DI003644) REFERENCES DT399 (DI003623)
                                             ON DELETE CASCADE;
ALTER TABLE DT398 ADD CONSTRAINT SDT398ID510 FOREIGN KEY (DI003642) REFERENCES DT510 (DI010320);
ALTER TABLE DT401 ADD CONSTRAINT SDT401ID345 FOREIGN KEY (DI000001) REFERENCES DT345 (DI024408)
                                             ON DELETE CASCADE;
ALTER TABLE DT402 ADD CONSTRAINT SDT402ID401 FOREIGN KEY (DI029950,DI029951) REFERENCES DT401 (DI000001, DI026596)
                                             ON DELETE CASCADE;
ALTER TABLE DT404 ADD CONSTRAINT SDT404ID405 FOREIGN KEY (DI028100) REFERENCES DT405 (DI000123);
ALTER TABLE DT404 ADD CONSTRAINT SDT404ID405A FOREIGN KEY (DI028040) REFERENCES DT405 (DI000123);
ALTER TABLE DT405 ADD CONSTRAINT SDT405ID422 FOREIGN KEY (DI000912) REFERENCES DT422 (DI000347);
ALTER TABLE DT406 ADD CONSTRAINT SDT406ID405 FOREIGN KEY (DI000970) REFERENCES DT405 (DI000123)
                                             ON DELETE CASCADE;
ALTER TABLE DT406 ADD CONSTRAINT SDT406ID410 FOREIGN KEY (DI000969) REFERENCES DT410 (DI000198)
                                             ON DELETE CASCADE;
ALTER TABLE DT409 ADD CONSTRAINT SDT409ID408 FOREIGN KEY (DI000235) REFERENCES DT408 (DI000165)
                                             ON DELETE CASCADE;
ALTER TABLE DT409 ADD CONSTRAINT SDT409ID425 FOREIGN KEY (DI000206) REFERENCES DT425 (DI000295);
ALTER TABLE DT411 ADD CONSTRAINT SDT411ID412 FOREIGN KEY (DI000213) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT412 ADD CONSTRAINT SDT412ID407 FOREIGN KEY (DI003141) REFERENCES DT407 (DI003226);
ALTER TABLE DT412 ADD CONSTRAINT SDT412ID415 FOREIGN KEY (DI000239) REFERENCES DT415 (DI000265)
                                             ON DELETE CASCADE;
ALTER TABLE DT412 ADD CONSTRAINT SDT412ID445 FOREIGN KEY (DI000252) REFERENCES DT445 (DI000609);
ALTER TABLE DT414 ADD CONSTRAINT SDT414ID412 FOREIGN KEY (DI000502) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT414 ADD CONSTRAINT SDT414ID441 FOREIGN KEY (DI000503) REFERENCES DT441 (DI000446);
ALTER TABLE DT415 ADD CONSTRAINT SDT415ID420 FOREIGN KEY (DI000266) REFERENCES DT420 (DI000289);
ALTER TABLE DT416 ADD CONSTRAINT SDT416ID415 FOREIGN KEY (DI000389) REFERENCES DT415 (DI000265)
                                             ON DELETE CASCADE;
ALTER TABLE DT416 ADD CONSTRAINT SDT416ID415B FOREIGN KEY (DI000277) REFERENCES DT415 (DI000265)
ALTER TABLE DT417 ADD CONSTRAINT SDT417ID407 FOREIGN KEY (DI003265) REFERENCES DT407 (DI003226);
ALTER TABLE DT417 ADD CONSTRAINT SDT417ID458 FOREIGN KEY (DI003269) REFERENCES DT458 (DI003190);
ALTER TABLE DT423 ADD CONSTRAINT SDT423ID422 FOREIGN KEY (DI000370) REFERENCES DT422 (DI000347)
                                             ON DELETE CASCADE;
ALTER TABLE DT430 ADD CONSTRAINT SDT430ID418 FOREIGN KEY (DI000475) REFERENCES DT418 (DI000305)
                                             ON DELETE CASCADE;
ALTER TABLE DT433 ADD CONSTRAINT SDT433ID405 FOREIGN KEY (DI000750) REFERENCES DT405 (DI000123)
                                             ON DELETE CASCADE;
ALTER TABLE DT435 ADD CONSTRAINT SDT435ID441 FOREIGN KEY (DI001550) REFERENCES DT441 (DI000446);
ALTER TABLE DT439 ADD CONSTRAINT SDT439ID345 FOREIGN KEY (DI000388) REFERENCES DT345 (DI024408)
                                             ON DELETE CASCADE;
ALTER TABLE DT439 ADD CONSTRAINT SDT439ID412 FOREIGN KEY (DI000361) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT440 ADD CONSTRAINT SDT440ID412 FOREIGN KEY (DI000286) REFERENCES DT412 (DI000238);
ALTER TABLE DT440 ADD CONSTRAINT SDT440ID412B FOREIGN KEY (DI000364) REFERENCES DT412 (DI000238);
ALTER TABLE DT445 ADD CONSTRAINT SDT445ID412 FOREIGN KEY (DI001615) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT445 ADD CONSTRAINT SDT445ID412B FOREIGN KEY (DI001616) REFERENCES DT412 (DI000238);
ALTER TABLE DT445 ADD CONSTRAINT SDT445ID415 FOREIGN KEY (DI001614) REFERENCES DT415 (DI000265);
ALTER TABLE DT447 ADD CONSTRAINT SDT447ID453 FOREIGN KEY (DI041284) REFERENCES DT453 (DI000916)
                                             ON DELETE CASCADE;
ALTER TABLE DT454 ADD CONSTRAINT SDT454ID453 FOREIGN KEY (DI001065) REFERENCES DT453 (DI000916)
                                             ON DELETE CASCADE;
ALTER TABLE DT455 ADD CONSTRAINT SDT455ID511 FOREIGN KEY (DI001365) REFERENCES DT511 (DI010323)
                                             ON DELETE CASCADE;
ALTER TABLE DT456 ADD CONSTRAINT SDT456ID412 FOREIGN KEY (DI026896) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT459 ADD CONSTRAINT SDT459ID461 FOREIGN KEY (DI027426) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT459 ADD CONSTRAINT SDT459ID956 FOREIGN KEY (DI027427,DI027428) REFERENCES DT956 (DI010517, DI010515)
                                             ON DELETE CASCADE;
--ALTER TABLE DT461 ADD CONSTRAINT SDT461ID461S FOREIGN KEY (DI001003) REFERENCES DT461 (DI001001)  -- ON DELETE SET NULL??? korrekt hier?
--                                             ON DELETE SET NULL;

ALTER TABLE DT461 ADD CONSTRAINT SDT461ID463 FOREIGN KEY (DI001003,DI001004) REFERENCES DT463 (DI001097, DI001098);
ALTER TABLE DT462 ADD CONSTRAINT SDT462ID441 FOREIGN KEY (DI001092) REFERENCES DT441 (DI000446);
ALTER TABLE DT462 ADD CONSTRAINT SDT462ID461 FOREIGN KEY (DI001079) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT463 ADD CONSTRAINT SDT463ID461 FOREIGN KEY (DI001097) REFERENCES DT461 (DI001001);
ALTER TABLE DT464 ADD CONSTRAINT SDT464ID441 FOREIGN KEY (DI001193) REFERENCES DT441 (DI000446);
ALTER TABLE DT464 ADD CONSTRAINT SDT464ID463 FOREIGN KEY (DI001180,DI001181) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT465 ADD CONSTRAINT SDT465ID463 FOREIGN KEY (DI001202,DI001203) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT465 ADD CONSTRAINT SDT465ID463A FOREIGN KEY (DI001200,DI001201) REFERENCES DT463 (DI001097, DI001098);
ALTER TABLE DT466 ADD CONSTRAINT SDT466ID463 FOREIGN KEY (DI001390,DI001391) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT466 ADD CONSTRAINT SDT466ID467 FOREIGN KEY (DI001392) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
  
ALTER TABLE DT466 ADD CONSTRAINT SDT466ID470 FOREIGN KEY (DI001393) REFERENCES DT470 (DI001366);
ALTER TABLE DT467 ADD CONSTRAINT SDT467ID467S FOREIGN KEY (DI009753) REFERENCES DT467 (DI001218);

ALTER TABLE DT467 ADD CONSTRAINT SDT467ID475 FOREIGN KEY (DI000440) REFERENCES DT475 (DI000294);

ALTER TABLE DT469 ADD CONSTRAINT SDT469ID467 FOREIGN KEY (DI001300) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT469 ADD CONSTRAINT SDT469ID467A FOREIGN KEY (DI001301) REFERENCES DT467 (DI001218);
ALTER TABLE DT470 ADD CONSTRAINT SDT470ID470S FOREIGN KEY (DI001367) REFERENCES DT470 (DI001366);
ALTER TABLE DT470 ADD CONSTRAINT SDT470ID475 FOREIGN KEY (DI000442) REFERENCES DT475 (DI000294);

ALTER TABLE DT472 ADD CONSTRAINT SDT472ID466 FOREIGN KEY (DI001395,DI001516,DI001517) REFERENCES DT466 (DI001390, DI001391, DI001392)
                                             ON DELETE CASCADE;
ALTER TABLE DT472 ADD CONSTRAINT SDT472ID467 FOREIGN KEY (DI001517) REFERENCES DT467 (DI001218);

ALTER TABLE DT472 ADD CONSTRAINT SDT472ID470 FOREIGN KEY (DI001518) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT473 ADD CONSTRAINT SDT473ID461 FOREIGN KEY (DI001071) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT474 ADD CONSTRAINT SDT474ID463 FOREIGN KEY (DI001073,DI001109) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT476 ADD CONSTRAINT SDT476ID475 FOREIGN KEY (DI000341) REFERENCES DT475 (DI000294)
                                             ON DELETE CASCADE;
ALTER TABLE DT478 ADD CONSTRAINT SDT478ID441 FOREIGN KEY (DI000618) REFERENCES DT441 (DI000446);
ALTER TABLE DT480 ADD CONSTRAINT SDT480ID461 FOREIGN KEY (DI029498) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT483 ADD CONSTRAINT SDT483ID006 FOREIGN KEY (DI026781) REFERENCES DT006 (DI026794)
                                             ON DELETE CASCADE;
ALTER TABLE DT483 ADD CONSTRAINT SDT483ID007 FOREIGN KEY (DI026782) REFERENCES DT007 (DI026795);
ALTER TABLE DT483 ADD CONSTRAINT SDT483ID466 FOREIGN KEY (DI002722,DI002724,DI026858) REFERENCES DT466 (DI001390, DI001391, DI001392)
                                             ON DELETE CASCADE;
ALTER TABLE DT483 ADD CONSTRAINT SDT483ID526 FOREIGN KEY (DI026802) REFERENCES DT526 (DI026640)
                                             ON DELETE CASCADE;
ALTER TABLE DT483 ADD CONSTRAINT SDT483ID946 FOREIGN KEY (DI026785) REFERENCES DT946 (DI026797)
                                             ON DELETE CASCADE;
                                             
ALTER TABLE DT485 ADD CONSTRAINT SDT485ID467 FOREIGN KEY (DI002787) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT485 ADD CONSTRAINT SDT485ID484 FOREIGN KEY (DI002799) REFERENCES DT484 (DI002775)
                                             ON DELETE CASCADE;
ALTER TABLE DT487 ADD CONSTRAINT SDT487ID461 FOREIGN KEY (DI002742) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT487 ADD CONSTRAINT SDT487ID487S FOREIGN KEY (DI002741) REFERENCES DT487 (DI002738);
ALTER TABLE DT488 ADD CONSTRAINT SDT488ID467 FOREIGN KEY (DI004291) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT492 ADD CONSTRAINT SDT492ID470 FOREIGN KEY (DI005017) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT492 ADD CONSTRAINT SDT492ID864 FOREIGN KEY (DI007066,DI028472) REFERENCES DT864 (DI023227, DI023228)
                                             ON DELETE CASCADE;
ALTER TABLE DT493 ADD CONSTRAINT SDT493ID461 FOREIGN KEY (DI005033) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT494 ADD CONSTRAINT SDT494ID461 FOREIGN KEY (DI005051) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT494 ADD CONSTRAINT SDT494ID470 FOREIGN KEY (DI005069) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT497 ADD CONSTRAINT SDT497ID496 FOREIGN KEY (DI041109) REFERENCES DT496 (DI041096)
                                             ON DELETE CASCADE;
ALTER TABLE DT498 ADD CONSTRAINT SDT498ID497 FOREIGN KEY (DI041124) REFERENCES DT497 (DI041110)
                                             ON DELETE CASCADE;
ALTER TABLE DT498 ADD CONSTRAINT SDT498ID498S FOREIGN KEY (DI057818) REFERENCES DT498 (DI041123);
ALTER TABLE DT499 ADD CONSTRAINT SDT499ID499S FOREIGN KEY (DI057823) REFERENCES DT499 (DI041138);
ALTER TABLE DT500 ADD CONSTRAINT SDT500ID405 FOREIGN KEY (DI024150) REFERENCES DT405 (DI000123)
                                             ON DELETE CASCADE;
ALTER TABLE DT500 ADD CONSTRAINT SDT500ID511 FOREIGN KEY (DI024149) REFERENCES DT511 (DI010323)
                                             ON DELETE CASCADE;
ALTER TABLE DT501 ADD CONSTRAINT SDT501ID406 FOREIGN KEY (DI024162) REFERENCES DT406 (DI000971)
                                             ON DELETE CASCADE;
ALTER TABLE DT501 ADD CONSTRAINT SDT501ID500 FOREIGN KEY (DI024161) REFERENCES DT500 (DI024148);
ALTER TABLE DT502 ADD CONSTRAINT SDT502ID410 FOREIGN KEY (DI024176) REFERENCES DT410 (DI000198)
                                             ON DELETE CASCADE;
ALTER TABLE DT502 ADD CONSTRAINT SDT502ID500 FOREIGN KEY (DI024175) REFERENCES DT500 (DI024148)
                                             ON DELETE CASCADE;
ALTER TABLE DT503 ADD CONSTRAINT SDT503ID411 FOREIGN KEY (DI024190,DI024191) REFERENCES DT411 (DI000306, DI000307)
                                             ON DELETE CASCADE;
ALTER TABLE DT503 ADD CONSTRAINT SDT503ID500 FOREIGN KEY (DI024189) REFERENCES DT500 (DI024148)
                                             ON DELETE CASCADE;
ALTER TABLE DT504 ADD CONSTRAINT SDT504ID516 FOREIGN KEY (DI024929) REFERENCES DT516 (DI010420)
                                             ON DELETE CASCADE;
ALTER TABLE DT505 ADD CONSTRAINT SDT505ID504 FOREIGN KEY (DI025710) REFERENCES DT504 (DI024930)
                                             ON DELETE CASCADE;
ALTER TABLE DT506 ADD CONSTRAINT SDT506ID516 FOREIGN KEY (DI026937) REFERENCES DT516 (DI010420)
                                             ON DELETE CASCADE;
ALTER TABLE DT507 ADD CONSTRAINT SDT507ID443 FOREIGN KEY (DI026551) REFERENCES DT443 (DI001595)
                                             ON DELETE CASCADE;
ALTER TABLE DT509 ADD CONSTRAINT SDT509ID508 FOREIGN KEY (DI058171) REFERENCES DT508 (DI058158)
                                             ON DELETE CASCADE;
ALTER TABLE DT511 ADD CONSTRAINT SDT511ID030 FOREIGN KEY (DI010662) REFERENCES DT030 (DI025643);
ALTER TABLE DT512 ADD CONSTRAINT SDT512ID510 FOREIGN KEY (DI010333) REFERENCES DT510 (DI010320)
                                             ON DELETE CASCADE;
ALTER TABLE DT512 ADD CONSTRAINT SDT512ID513 FOREIGN KEY (DI010332) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT514 ADD CONSTRAINT SDT514ID513 FOREIGN KEY (DI010338) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT514 ADD CONSTRAINT SDT514ID513A FOREIGN KEY (DI010339) REFERENCES DT513 (DI010324);
ALTER TABLE DT515 ADD CONSTRAINT SDT515ID405 FOREIGN KEY (DI010327) REFERENCES DT405 (DI000123)
                                             ON DELETE CASCADE;
ALTER TABLE DT515 ADD CONSTRAINT SDT515ID500 FOREIGN KEY (DI027460) REFERENCES DT500 (DI024148);
ALTER TABLE DT515 ADD CONSTRAINT SDT515ID513 FOREIGN KEY (DI010325) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT518 ADD CONSTRAINT SDT518ID510 FOREIGN KEY (DI010699) REFERENCES DT510 (DI010320)
                                             ON DELETE CASCADE;
ALTER TABLE DT518 ADD CONSTRAINT SDT518ID511 FOREIGN KEY (DI010697) REFERENCES DT511 (DI010323)
                                             ON DELETE CASCADE;
ALTER TABLE DT519 ADD CONSTRAINT SDT519ID510 FOREIGN KEY (DI010685) REFERENCES DT510 (DI010320)
                                             ON DELETE CASCADE;
ALTER TABLE DT519 ADD CONSTRAINT SDT519ID510A FOREIGN KEY (DI010686) REFERENCES DT510 (DI010320);
ALTER TABLE DT520 ADD CONSTRAINT SDT520ID415 FOREIGN KEY (DI010715) REFERENCES DT415 (DI000265)
                                             ON DELETE CASCADE;
ALTER TABLE DT520 ADD CONSTRAINT SDT520ID513 FOREIGN KEY (DI010714) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT521 ADD CONSTRAINT SDT521ID412 FOREIGN KEY (DI024121) REFERENCES DT412 (DI000238)
                                             ON DELETE CASCADE;
ALTER TABLE DT521 ADD CONSTRAINT SDT521ID513 FOREIGN KEY (DI024120) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT522 ADD CONSTRAINT SDT522ID432 FOREIGN KEY (DI024135) REFERENCES DT432 (DI001686)
                                             ON DELETE CASCADE;
ALTER TABLE DT522 ADD CONSTRAINT SDT522ID513 FOREIGN KEY (DI024134) REFERENCES DT513 (DI010324)
                                             ON DELETE CASCADE;
ALTER TABLE DT524 ADD CONSTRAINT SDT524ID511 FOREIGN KEY (DI024224) REFERENCES DT511 (DI010323)
                                             ON DELETE CASCADE;
ALTER TABLE DT525 ADD CONSTRAINT SDT525ID516 FOREIGN KEY (DI026521) REFERENCES DT516 (DI010420)
                                             ON DELETE CASCADE;
ALTER TABLE DT526 ADD CONSTRAINT SDT526ID516 FOREIGN KEY (DI026653) REFERENCES DT516 (DI010420);
ALTER TABLE DT527 ADD CONSTRAINT SDT527ID461 FOREIGN KEY (DI026561) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT527 ADD CONSTRAINT SDT527ID525 FOREIGN KEY (DI026560) REFERENCES DT525 (DI026520)
                                             ON DELETE CASCADE;
ALTER TABLE DT528 ADD CONSTRAINT SDT528ID526 FOREIGN KEY (DI026660) REFERENCES DT526 (DI026640)
                                             ON DELETE CASCADE;
ALTER TABLE DT531 ADD CONSTRAINT SDT531ID529 FOREIGN KEY (DI053207) REFERENCES DT529 (DI026705);
ALTER TABLE DT531 ADD CONSTRAINT SDT531ID530 FOREIGN KEY (DI053206) REFERENCES DT530 (DI053193);
ALTER TABLE DT545 ADD CONSTRAINT SDT545ID441 FOREIGN KEY (DI010262) REFERENCES DT441 (DI000446);
ALTER TABLE DT549 ADD CONSTRAINT SDT549ID422 FOREIGN KEY (DI024422) REFERENCES DT422 (DI000347)
                                             ON DELETE CASCADE;
ALTER TABLE DT549 ADD CONSTRAINT SDT549ID516 FOREIGN KEY (DI024421) REFERENCES DT516 (DI010420)
                                             ON DELETE CASCADE;
ALTER TABLE DT801 ADD CONSTRAINT SDT801ID466 FOREIGN KEY (DI028209,DI028210,DI028211) REFERENCES DT466 (DI001390, DI001391, DI001392)
                                             ON DELETE CASCADE;
ALTER TABLE DT804 ADD CONSTRAINT SDT804ID461 FOREIGN KEY (DI006841) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT804 ADD CONSTRAINT SDT804ID463 FOREIGN KEY (DI006841,DI006452) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT804 ADD CONSTRAINT SDT804ID467 FOREIGN KEY (DI006453) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT805 ADD CONSTRAINT SDT805ID804 FOREIGN KEY (DI006457,DI006842,DI006455) REFERENCES DT804 (DI006454, DI006840, DI006841)
                                             ON DELETE CASCADE;
ALTER TABLE DT808 ADD CONSTRAINT SDT808ID808S FOREIGN KEY (DI007026) REFERENCES DT808 (DI007025);
ALTER TABLE DT810 ADD CONSTRAINT SDT810ID461 FOREIGN KEY (DI007696) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT811 ADD CONSTRAINT SDT811ID810 FOREIGN KEY (DI007717,DI007718) REFERENCES DT810 (DI007696, DI007697)
                                             ON DELETE CASCADE;
ALTER TABLE DT812 ADD CONSTRAINT SDT812ID461 FOREIGN KEY (DI029557) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT813 ADD CONSTRAINT SDT813ID812 FOREIGN KEY (DI029584,DI029585) REFERENCES DT812 (DI029557, DI029558)
                                             ON DELETE CASCADE;
ALTER TABLE DT815 ADD CONSTRAINT SDT815ID441 FOREIGN KEY (DI007885) REFERENCES DT441 (DI000446)
                                             ON DELETE CASCADE;
ALTER TABLE DT815 ADD CONSTRAINT SDT815ID814 FOREIGN KEY (DI007883) REFERENCES DT814 (DI007868)
                                             ON DELETE CASCADE;
ALTER TABLE DT816 ADD CONSTRAINT SDT816ID461 FOREIGN KEY (DI007854) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT816 ADD CONSTRAINT SDT816ID814 FOREIGN KEY (DI007855) REFERENCES DT814 (DI007868)
                                             ON DELETE CASCADE;
ALTER TABLE DT818 ADD CONSTRAINT SDT818ID511 FOREIGN KEY (DI007936) REFERENCES DT511 (DI010323)
                                             ON DELETE CASCADE;
ALTER TABLE DT818 ADD CONSTRAINT SDT818ID817 FOREIGN KEY (DI007937) REFERENCES DT817 (DI007923);
ALTER TABLE DT819 ADD CONSTRAINT SDT819ID461 FOREIGN KEY (DI008045) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT819 ADD CONSTRAINT SDT819ID808 FOREIGN KEY (DI008046) REFERENCES DT808 (DI007025)
                                             ON DELETE CASCADE;
ALTER TABLE DT821 ADD CONSTRAINT SDT821ID461 FOREIGN KEY (DI008364) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT822 ADD CONSTRAINT SDT822ID821 FOREIGN KEY (DI008380,DI008381) REFERENCES DT821 (DI008364, DI008365)
                                             ON DELETE CASCADE;
ALTER TABLE DT823 ADD CONSTRAINT SDT823ID461 FOREIGN KEY (DI008413) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT824 ADD CONSTRAINT SDT824ID823 FOREIGN KEY (DI008444,DI008474) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT825 ADD CONSTRAINT SDT825ID824 FOREIGN KEY (DI008480,DI008494,DI008481) REFERENCES DT824 (DI008444, DI008474, DI008445)
                                             ON DELETE CASCADE;
ALTER TABLE DT825 ADD CONSTRAINT SDT825ID824A FOREIGN KEY (DI008478,DI008496,DI008479) REFERENCES DT824 (DI008444, DI008474, DI008445);
ALTER TABLE DT826 ADD CONSTRAINT SDT826ID467 FOREIGN KEY (DI008499) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT826 ADD CONSTRAINT SDT826ID470 FOREIGN KEY (DI008503) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT826 ADD CONSTRAINT SDT826ID824 FOREIGN KEY (DI008497,DI008514,DI008498) REFERENCES DT824 (DI008444, DI008474, DI008445)
                                             ON DELETE CASCADE;
ALTER TABLE DT827 ADD CONSTRAINT SDT827ID467 FOREIGN KEY (DI008518) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT827 ADD CONSTRAINT SDT827ID470 FOREIGN KEY (DI008519) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT827 ADD CONSTRAINT SDT827ID823 FOREIGN KEY (DI008516,DI008535) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT827 ADD CONSTRAINT SDT827ID826 FOREIGN KEY (DI008516,DI008535,DI008517,DI008518) REFERENCES DT826 (DI008497, DI008514, DI008498, DI008499);
ALTER TABLE DT828 ADD CONSTRAINT SDT828ID823 FOREIGN KEY (DI008541,DI008555) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT829 ADD CONSTRAINT SDT829ID828 FOREIGN KEY (DI008557,DI008573,DI008558) REFERENCES DT828 (DI008541, DI008555, DI008542)
                                             ON DELETE CASCADE;
ALTER TABLE DT830 ADD CONSTRAINT SDT830ID461 FOREIGN KEY (DI008790) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT830 ADD CONSTRAINT SDT830ID830S FOREIGN KEY (DI008789) REFERENCES DT830 (DI008788);
ALTER TABLE DT831 ADD CONSTRAINT SDT831ID823 FOREIGN KEY (DI008862,DI008883) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT832 ADD CONSTRAINT SDT832ID831 FOREIGN KEY (DI008885,DI008907,DI008886) REFERENCES DT831 (DI008862, DI008883, DI008863)
                                             ON DELETE CASCADE;
ALTER TABLE DT833 ADD CONSTRAINT SDT833ID467 FOREIGN KEY (DI008914) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT833 ADD CONSTRAINT SDT833ID823 FOREIGN KEY (DI008913,DI008937) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT833 ADD CONSTRAINT SDT833ID824 FOREIGN KEY (DI008913,DI008937,DI008910) REFERENCES DT824 (DI008444, DI008474, DI008445);
ALTER TABLE DT834 ADD CONSTRAINT SDT834ID833 FOREIGN KEY (DI008941,DI008942,DI008939,DI008957) REFERENCES DT833 (DI008911, DI008912, DI008913, DI008937)
                                             ON DELETE CASCADE;
ALTER TABLE DT835 ADD CONSTRAINT SDT835ID823 FOREIGN KEY (DI029230,DI029327) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT836 ADD CONSTRAINT SDT836ID835 FOREIGN KEY (DI029330,DI029435,DI029331) REFERENCES DT835 (DI029230, DI029327, DI029231)
                                             ON DELETE CASCADE;
ALTER TABLE DT837 ADD CONSTRAINT SDT837ID461 FOREIGN KEY (DI009072) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT838 ADD CONSTRAINT SDT838ID837 FOREIGN KEY (DI009097,DI009098,DI009100) REFERENCES DT837 (DI009072, DI009073, DI009074)
                                             ON DELETE CASCADE;
ALTER TABLE DT840 ADD CONSTRAINT SDT840ID841 FOREIGN KEY (DI009756,DI009757,DI009758) REFERENCES DT841 (DI009806, DI009807, DI009808)
                                             ON DELETE CASCADE;
ALTER TABLE DT841 ADD CONSTRAINT SDT841ID840 FOREIGN KEY (DI009806,DI009807) REFERENCES DT840 (DI009754, DI009755);
ALTER TABLE DT842 ADD CONSTRAINT SDT842ID841 FOREIGN KEY (DI009847,DI009848,DI009849) REFERENCES DT841 (DI009806, DI009807, DI009808)
                                             ON DELETE CASCADE;
ALTER TABLE DT842 ADD CONSTRAINT SDT842ID841A FOREIGN KEY (DI009851,DI009852,DI009853) REFERENCES DT841 (DI009806, DI009807, DI009808);
ALTER TABLE DT843 ADD CONSTRAINT SDT843ID467 FOREIGN KEY (DI009871) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT843 ADD CONSTRAINT SDT843ID470 FOREIGN KEY (DI009876) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT843 ADD CONSTRAINT SDT843ID841 FOREIGN KEY (DI009868,DI009869,DI009870) REFERENCES DT841 (DI009806, DI009807, DI009808)
                                             ON DELETE CASCADE;
ALTER TABLE DT844 ADD CONSTRAINT SDT844ID467 FOREIGN KEY (DI009910) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT844 ADD CONSTRAINT SDT844ID470 FOREIGN KEY (DI009911) REFERENCES DT470 (DI001366)
                                             ON DELETE CASCADE;
ALTER TABLE DT844 ADD CONSTRAINT SDT844ID843 FOREIGN KEY (DI009904,DI009905,DI009909,DI009910) REFERENCES DT843 (DI009868, DI009869, DI009870, DI009871);
ALTER TABLE DT845 ADD CONSTRAINT SDT845ID467 FOREIGN KEY (DI009938) REFERENCES DT467 (DI001218)
                                             ON DELETE CASCADE;
ALTER TABLE DT845 ADD CONSTRAINT SDT845ID840 FOREIGN KEY (DI009936,DI009937) REFERENCES DT840 (DI009754, DI009755)
                                             ON DELETE CASCADE;
ALTER TABLE DT845 ADD CONSTRAINT SDT845ID841 FOREIGN KEY (DI009936,DI009937,DI009933) REFERENCES DT841 (DI009806, DI009807, DI009808);
ALTER TABLE DT846 ADD CONSTRAINT SDT846ID441 FOREIGN KEY (DI010122) REFERENCES DT441 (DI000446)
                                             ON DELETE CASCADE;
ALTER TABLE DT846 ADD CONSTRAINT SDT846ID841 FOREIGN KEY (DI010119,DI010124,DI010120) REFERENCES DT841 (DI009806, DI009807, DI009808)
                                             ON DELETE CASCADE;
ALTER TABLE DT847 ADD CONSTRAINT SDT847ID845 FOREIGN KEY (DI010161,DI010162,DI010158,DI010159) REFERENCES DT845 (DI009934, DI009935, DI009936, DI009937)
                                             ON DELETE CASCADE;
ALTER TABLE DT848 ADD CONSTRAINT SDT848ID441 FOREIGN KEY (DI022235) REFERENCES DT441 (DI000446)
                                             ON DELETE CASCADE;
ALTER TABLE DT848 ADD CONSTRAINT SDT848ID840 FOREIGN KEY (DI022232,DI022233) REFERENCES DT840 (DI009754, DI009755)
                                             ON DELETE CASCADE;
ALTER TABLE DT849 ADD CONSTRAINT SDT849ID849S FOREIGN KEY (DI022311) REFERENCES DT849 (DI022291);
ALTER TABLE DT850 ADD CONSTRAINT SDT850ID849 FOREIGN KEY (DI022330) REFERENCES DT849 (DI022291)
                                             ON DELETE CASCADE;
ALTER TABLE DT851 ADD CONSTRAINT SDT851ID461 FOREIGN KEY (DI022339) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT851 ADD CONSTRAINT SDT851ID849 FOREIGN KEY (DI022340) REFERENCES DT849 (DI022291)
                                             ON DELETE CASCADE;
ALTER TABLE DT852 ADD CONSTRAINT SDT852ID849 FOREIGN KEY (DI022421) REFERENCES DT849 (DI022291)
                                             ON DELETE CASCADE;
ALTER TABLE DT852 ADD CONSTRAINT SDT852ID852S FOREIGN KEY (DI022422,DI022450) REFERENCES DT852 (DI022421, DI022448);
ALTER TABLE DT853 ADD CONSTRAINT SDT853ID852 FOREIGN KEY (DI022452,DI022471) REFERENCES DT852 (DI022421, DI022448)
                                             ON DELETE CASCADE;
ALTER TABLE DT854 ADD CONSTRAINT SDT854ID461 FOREIGN KEY (DI022473) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT854 ADD CONSTRAINT SDT854ID852 FOREIGN KEY (DI022474,DI022488) REFERENCES DT852 (DI022421, DI022448)
                                             ON DELETE CASCADE;
ALTER TABLE DT855 ADD CONSTRAINT SDT855ID849 FOREIGN KEY (DI022657) REFERENCES DT849 (DI022291)
                                             ON DELETE CASCADE;
ALTER TABLE DT856 ADD CONSTRAINT SDT856ID461 FOREIGN KEY (DI022984) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT858 ADD CONSTRAINT SDT858ID461 FOREIGN KEY (DI023101) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT858 ADD CONSTRAINT SDT858ID870 FOREIGN KEY (DI023102) REFERENCES DT870 (DI028667)
                                             ON DELETE CASCADE;
ALTER TABLE DT859 ADD CONSTRAINT SDT859ID870 FOREIGN KEY (DI023041) REFERENCES DT870 (DI028667)
                                             ON DELETE CASCADE;
ALTER TABLE DT860 ADD CONSTRAINT SDT860ID870 FOREIGN KEY (DI023086) REFERENCES DT870 (DI028667)
                                             ON DELETE CASCADE;
ALTER TABLE DT861 ADD CONSTRAINT SDT861ID461 FOREIGN KEY (DI023119) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT861_MANUAL ADD CONSTRAINT SDT861_MANUALID461 FOREIGN KEY (DI059359) REFERENCES DT461 (DI001001)
                                                           ON DELETE CASCADE;
ALTER TABLE DT862 ADD CONSTRAINT SDT862ID862A FOREIGN KEY (DI023083) REFERENCES DT862 (DI023082);
ALTER TABLE DT863 ADD CONSTRAINT SDT863ID461 FOREIGN KEY (DI023037) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT863 ADD CONSTRAINT SDT863ID862 FOREIGN KEY (DI023038) REFERENCES DT862 (DI023082)
                                             ON DELETE CASCADE;
ALTER TABLE DT864 ADD CONSTRAINT SDT864ID808 FOREIGN KEY (DI023227) REFERENCES DT808 (DI007025)
                                             ON DELETE CASCADE;
ALTER TABLE DT865 ADD CONSTRAINT SDT865ID457 FOREIGN KEY (DI023719) REFERENCES DT457 (DI003043)
                                             ON DELETE CASCADE;
ALTER TABLE DT867 ADD CONSTRAINT SDT867ID461 FOREIGN KEY (DI028833) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT867 ADD CONSTRAINT SDT867ID859 FOREIGN KEY (DI034417,DI034415) REFERENCES DT859 (DI023041, DI023053)
                                             ON DELETE CASCADE;
ALTER TABLE DT868 ADD CONSTRAINT SDT868ID861 FOREIGN KEY (DI028632,DI028633) REFERENCES DT861 (DI023119, DI023062)
                                             ON DELETE CASCADE;
ALTER TABLE DT869 ADD CONSTRAINT SDT869ID461 FOREIGN KEY (DI028654) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT871 ADD CONSTRAINT SDT871ID856 FOREIGN KEY (DI028835,DI028836) REFERENCES DT856 (DI022983, DI022984)
                                             ON DELETE CASCADE;
ALTER TABLE DT872 ADD CONSTRAINT SDT872ID823 FOREIGN KEY (DI029622,DI029683) REFERENCES DT823 (DI008413, DI008416)
                                             ON DELETE CASCADE;
ALTER TABLE DT873 ADD CONSTRAINT SDT873ID872 FOREIGN KEY (DI029649,DI029685,DI029650) REFERENCES DT872 (DI029622, DI029683, DI029623)
                                             ON DELETE CASCADE;
ALTER TABLE DT885 ADD CONSTRAINT SDT885ID461 FOREIGN KEY (DI041321) REFERENCES DT461 (DI001001)
                                             ON DELETE CASCADE;
ALTER TABLE DT886 ADD CONSTRAINT SDT886ID885 FOREIGN KEY (DI041336) REFERENCES DT885 (DI041322)
                                             ON DELETE CASCADE;
ALTER TABLE DT887 ADD CONSTRAINT SDT887ID818 FOREIGN KEY (DI056936,DI056938,DI056939) REFERENCES DT818 (DI007935, DI007936, DI007937)
                                             ON DELETE CASCADE;
ALTER TABLE DT888 ADD CONSTRAINT SDT888ID463 FOREIGN KEY (DI034561,DI034562) REFERENCES DT463 (DI001097, DI001098)
                                             ON DELETE CASCADE;
ALTER TABLE DT888 ADD CONSTRAINT SDT888ID463A FOREIGN KEY (DI034577,DI034578) REFERENCES DT463 (DI001097, DI001098);
ALTER TABLE DT946 ADD CONSTRAINT SDT946ID504 FOREIGN KEY (DI025762) REFERENCES DT504 (DI024930);
ALTER TABLE DT946 ADD CONSTRAINT SDT946ID956 FOREIGN KEY (DI025764,DI025765) REFERENCES DT956 (DI010517, DI010515)
                                             ON DELETE CASCADE;
ALTER TABLE DT946 ADD CONSTRAINT SDT946ID959 FOREIGN KEY (DI026798) REFERENCES DT959 (DI026796)
                                             ON DELETE CASCADE;
ALTER TABLE DT951 ADD CONSTRAINT SDT951ID441 FOREIGN KEY (DI010456) REFERENCES DT441 (DI000446);
ALTER TABLE DT956 ADD CONSTRAINT SDT956ID516 FOREIGN KEY (DI010516) REFERENCES DT516 (DI010420);
ALTER TABLE DT956 ADD CONSTRAINT SDT956ID955 FOREIGN KEY (DI010517) REFERENCES DT955 (DI010514)
                                             ON DELETE CASCADE;
ALTER TABLE DT959 ADD CONSTRAINT SDT959ID995 FOREIGN KEY (DI024572) REFERENCES DT995 (DI024569)
                                             ON DELETE CASCADE;
ALTER TABLE DT988 ADD CONSTRAINT SDT988ID956 FOREIGN KEY (DI021240,DI021244) REFERENCES DT956 (DI010517, DI010515)
                                             ON DELETE CASCADE;
ALTER TABLE DT992 ADD CONSTRAINT SDT992ID955 FOREIGN KEY (DI021567) REFERENCES DT955 (DI010514)
                                             ON DELETE CASCADE;
ALTER TABLE DT995 ADD CONSTRAINT SDT995ID516 FOREIGN KEY (DI024573) REFERENCES DT516 (DI010420);
ALTER TABLE INTERFACE_MAPPING ADD CONSTRAINT SINTERFACE_MAPPINGID562S FOREIGN KEY (PARENT_ID) REFERENCES INTERFACE_MAPPING (UUID);
ALTER TABLE MIGRATIONHISTORY ADD CONSTRAINT SMIGRATIONHISTORYID314 FOREIGN KEY (MIGRATIONRULE) REFERENCES MIGRATIONRULE (UUID)
                                                                   ON DELETE CASCADE;
ALTER TABLE MSPI_LINK ADD CONSTRAINT SMSPI_LINKID806A FOREIGN KEY (PRED_MSP_ID) REFERENCES MSPI_TASK (MSP_ID)
                                                      ON DELETE CASCADE;
ALTER TABLE MSPI_LINK ADD CONSTRAINT SMSPI_LINKID806B FOREIGN KEY (SUCC_MSP_ID) REFERENCES MSPI_TASK (MSP_ID);
ALTER TABLE MSPI_TASK ADD CONSTRAINT SMSPI_TASKID463 FOREIGN KEY (PR_ID,TASK_ID) REFERENCES DT463 (DI001097, DI001098)
                                                    ON DELETE CASCADE;
ALTER TABLE MSPI_TASK ADD CONSTRAINT SMSPI_TASKID806S FOREIGN KEY (PARENT_TASK) REFERENCES MSPI_TASK (MSP_ID);
