update APPLIC set DATA_SG=dateadd(day,-36161,DATA_SG);');
update APPLIC set DATA_RG=dateadd(day,-36161,DATA_RG);');
update APPLIC set DATA_R=dateadd(day,-36161,DATA_R);');
update APPLIC set DATA_C=dateadd(day,-36161,DATA_C);');
update APPLIC set DATA_S=dateadd(day,-36161,DATA_S);');
update APPLIC set DATA_E=dateadd(day,-36161,DATA_E);');
update APPLIC set DATA_X=dateadd(day,-36161,DATA_X);');
update APPLIC set DATA_Y=dateadd(day,-36161,DATA_Y);');
update applic set data_sg=null where data_sg<cast('01.01.1950' as DATE);');
update applic set data_rg=null where data_rg<cast('01.01.1950' as DATE);');
update applic set data_r=null where data_r<cast('01.01.1950' as DATE);');
update applic set data_c=null where data_c<cast('01.01.1950' as DATE);');
update applic set data_s=null where data_s<cast('01.01.1950' as DATE);');
update applic set data_e=null where data_e<cast('01.01.1950' as DATE);');
update applic set data_x=null where data_x<cast('01.01.1950' as DATE);');
update applic set data_y=null where data_y<cast('01.01.1950' as DATE);');
update APPLIC set SURN1='' where SURN1 is null;');
update APPLIC set SURN2='' where SURN2 is null;');
update APPLIC set F_NAM='' where F_NAM is null;');
update APPLIC set M_NAM='' where M_NAM is null;');
update APPLIC set INDX='' where INDX is null;');
update APPLIC set BLD_NUM='' where BLD_NUM is null;');
update APPLIC set CORP_NUM='' where CORP_NUM is null;');
update APPLIC set FLAT='' where FLAT is null;');
update APPLIC set PHONE='' where PHONE is null;');
update APPLIC set PLACE='' where PLACE is null;');
update APPLIC set RIZNE='' where RIZNE is null;');
update APPLIC set SUR_NAM=SURN1||SURN2;');
commit;

CREATE TABLE APPLIC (
APP_NUM BIGINT,
CAL_NUM SMALLINT,
CAL_LAST SMALLINT,
US_ID SMALLINT,
SUR_NAM VARCHAR(30),
SURN1 VARCHAR(7),
SURN2 VARCHAR(23),
F_NAM VARCHAR(25),
M_NAM VARCHAR(20),
INDX VARCHAR(6),
VUL_COD INTEGER,
BLD_NUM VARCHAR(7),
CORP_NUM VARCHAR(2),
FLAT VARCHAR(9),
PHONE VARCHAR(7),
PLACE VARCHAR(1),
RIZNE VARCHAR(10),
NUMB SMALLINT,
INCOM DECIMAL(9,2),
OWN_FRM SMALLINT,
HOSTEL SMALLINT,
CM_AREA DECIMAL(6,2),
NM_AREA DECIMAL(6,2),
BALC DECIMAL(5,2),
AD_AREA DECIMAL(5,2),
FROG DECIMAL(5,2),
FRUG DECIMAL(5,2),
FL_PAY DECIMAL(9,2),
NM_PAY DECIMAL(9,2),
NM_PAY1 DECIMAL(9,2),
CFG_JKP SMALLINT,
CFG_SGTP SMALLINT,
DEBT SMALLINT,
RES1 SMALLINT,
RES2 INTEGER,
RES3 INTEGER,
RES4 SMALLINT,
SUBSID DECIMAL(9,2),
SUBSUD DECIMAL(9,2),
SUBSID1 DECIMAL(9,2),
RITE1 INTEGER,
RITE2 INTEGER,
RITE3 INTEGER,
RITE4 INTEGER,
RITE5 INTEGER,
REEK BIGINT,
DATA_SG DATE,
DATA_RG DATE,
DATA_R DATE,
DATA_C DATE,
DATA_S DATE,
DATA_E DATE,
DATA_X DATE,
DATA_Y DATE,
MARK SMALLINT,
STOP SMALLINT
);