use QDAS GO -- ============================================================ --delete from DB_VERSION --GO --Insert INTO DB_VERSION VALUES('8.0') --GO -- ============================================================ -- Stand 2015-02-24 (TC) -- ============================================================ create table LASTIDENT ( LITEIL int, LIDENT int ) GO create unique index LASTIDENT on LASTIDENT(LITEIL) GO create table NENNMASS ( NMARTIKEL int, NMMERKMAL int, NMARBEITSGANG VARCHAR(40), NMNENNMASS FLOAT ) GO drop index NENNMASS.NENNMASS GO create unique index NENNMASS on NENNMASS(NMARTIKEL, NMMERKMAL, NMARBEITSGANG) GO create table ERGEBNIS ( ETEIL int, EMERKMAL int, EMODUL smallint, EAUSGAPUNKT VARCHAR(20), EERGEBNIS FLOAT, EERGEBNISSTR VARCHAR(30), ESTARTDAT datetime, EENDDAT datetime, EPRUEFER int, EPRUEFMIT int, EMASCHINE int, ENEST int, ECHARGE VARCHAR(20), EAUFTRAG VARCHAR(20), EANZWERTE int ) GO create index ERGEBNIS on ERGEBNIS (ETEIL, EMERKMAL, EMODUL) GO create index EAUFTRAG on ERGEBNIS (EAUFTRAG) GO create table BUILDPHASE ( BPKEY int, BPNAME VARCHAR(20) ) GO create unique index BUILDPHASE on BUILDPHASE(BPKEY) GO create table ERGEBZEITRAUM ( EZTEIL int, EZMODUL smallint, EZAUSGAPUNKT VARCHAR(20), EZBAUPHASE VARCHAR(20), MINDAT datetime, MAXDAT datetime ) GO create unique index ERGEBZEITRAUM on ERGEBZEITRAUM(EZTEIL,EZMODUL,EZAUSGAPUNKT,EZBAUPHASE) GO create table PARTCONFIG ( PARTID int, PARTCONFIG VARCHAR(80) ) go create unique index PARTCONFIG on PARTCONFIG(PARTID) go create table MEASVALUES ( MV_PARTID int, MV_INTERNALID int, MV_MEASUREMENTID VARCHAR(50), MV_MEASVALUES TEXT, MV_ATTRIBUTE smallint, MV_INSPECTOR int, MV_MEASSYSTEM int, MV_MACHINE int, MV_NEST int, MV_MEASSTARTDATETIME DATEtime, MV_MEASENDDATETIME DATEtime, MV_SAMPLEFLAG tinyint, MV_BATCHSTART VARCHAR(20), MV_BATCHEND VARCHAR(20), MV_ORDER VARCHAR(20), MV_MEASUREMENTCOUNT int, WV0005 VARCHAR(20) ) go create unique index MEASVALUES on MEASVALUES(MV_PARTID,MV_INTERNALID) go create index MV_INTERNALID on MEASVALUES(MV_INTERNALID) go create index MV_MEASENDDATETIME on MEASVALUES(MV_MEASENDDATETIME) go create index MV_MEASSTARTDATETIME on MEASVALUES(MV_MEASSTARTDATETIME) go create index MV_MEASUREMENTID on MEASVALUES(MV_MEASUREMENTID) go create index MV_ATTRIBUTE on MEASVALUES(MV_ATTRIBUTE) go create index MV_INSPECTOR on MEASVALUES(MV_INSPECTOR) go create index MV_MEASSYSTEM on MEASVALUES(MV_MEASSYSTEM) go create index MV_MACHINE on MEASVALUES(MV_MACHINE) go create index MV_NEST on MEASVALUES(MV_NEST) go create table HIERATEIL ( HITEIL int, HISUBKEY1 int, HISUBKEY2 int, HISTRUKTUR text ) GO create unique index HIERATEIL on HIERATEIL(HITEIL, HISUBKEY1, HISUBKEY2) GO create table LAST_UPLOAD ( MEUPLOADKEY int, METEIL int, MEMERKMAL smallint, FILENAME VARCHAR(255) ) GO create unique index LAST_UPLOAD on LAST_UPLOAD(MEUPLOADKEY, METEIL, MEMERKMAL) GO create index LAST_UPLOAD_TEIL on LAST_UPLOAD(METEIL) GO alter table LAST_UPLOAD add MEWERT int go alter table LAST_UPLOAD add K0006 VARCHAR(20) go alter table LAST_UPLOAD add K0007 int go alter table LAST_UPLOAD add K0008 int go alter table LAST_UPLOAD add K0010 int go alter table LAST_UPLOAD add K0012 int go alter table LAST_UPLOAD add K0053 VARCHAR(20) go alter table LAST_UPLOAD add STATION_NO VARCHAR(50) go create index LAST_UPLOAD_STATION_NO on LAST_UPLOAD(STATION_NO) GO create table MERKMAL_REPORT ( METEIL int, MEMERKMAL smallint, MEREPORT VARCHAR(255), MODUL smallint, EMAIL VARCHAR(255), PRINTER VARCHAR(255) ) GO drop index MERKMAL_REPORT.MERKMAL_REPORT GO create index MERKMAL_REPORT_TEIL on MERKMAL_REPORT(METEIL) GO alter table MERKMAL_REPORT add CONFNAME VARCHAR(50) GO alter table MERKMAL_REPORT add GRUPPE int GO alter table MERKMAL_REPORT add TEMPLATE VARCHAR(255) GO alter table MERKMAL_REPORT add MEREPORTALARM VARCHAR(50) GO alter table MERKMAL_REPORT add PDFPATH VARCHAR(255) GO alter table MERKMAL_REPORT add WITHOUT_AL_TXT VARCHAR(255) GO alter table MERKMAL_REPORT add PDF_URL VARCHAR(255) GO alter table MERKMAL_REPORT add ALTPDFDNERZ VARCHAR(255) GO ALTER TABLE MERKMAL_REPORT ALTER COLUMN GRUPPE INT GO create table REPORTS ( REPORTNO smallint, REPORTNAME VARCHAR(255), REPORTTYPE smallint, MODUL smallint ) GO ALTER TABLE REPORTS ADD CONFNAME VARCHAR(50) GO create table ALARM_FILES ( ALARM_ID int, ENTRY_TYPE int, ENTRY image, UPLOAD_DIR VARCHAR(255), REPORTNAME VARCHAR(255) ) GO create unique index ALARM_FILES on ALARM_FILES(ALARM_ID, ENTRY_TYPE) GO create table ALARMS ( ALARM_ID int, ALARM_COUNT int, ALARM_TYPE int, ALARM_STATUS int, ALARM_DATETIME datetime, ALARM_EVENT VARCHAR(255) ) GO create unique index ALARMS on ALARMS(ALARM_ID) GO CREATE TABLE ALARM_VALUES ( ALARM_ID INT , ALARM_VALUE_ID INT , ALARM_STATUS INT , ALARM_DATETIME DATETIME , CONFIRM_DATETIME DATETIME , CLOSE_DATETIME DATETIME , CONFIRM_USER VARCHAR(50) , CLOSE_USER VARCHAR(50) , ALARM_EW INT , ALARM_QRK_L INT , ALARM_QRK_S INT , ALARM_CP INT , ALARM_EVENT VARCHAR(255) , K0006 VARCHAR(20) , K0007 INT , K0008 INT , K0010 INT , K0012 INT , K0053 VARCHAR(20) , K1000 INT , K2000 INT , K0000 INT ) GO create unique index ALARM_VALUES on ALARM_VALUES(ALARM_ID,ALARM_VALUE_ID) GO CREATE TABLE EMPB_3000 ( K3000 int, K3001 varchar(20), K3002 varchar(30), K3003 varchar(20), K3004 varchar(20), K3005 varchar(20), K3006 varchar(20), K3010 int, K3011 varchar(20), K3020 smallint, K3021 smallint, K3022 smallint, K3023 varchar(40), K3025 varchar(20), K3030 varchar(120), K3031 varchar(40), K3035 varchar(50), K3036 varchar(50), K3037 smallint, K3040 smallint, K3050 varchar(30), K3052 varchar(50), K3055 varchar(30), K3056 varchar(20), K3057 datetime, K3058 varchar(20), K3070 varchar(30), K3071 varchar(30), K3077 datetime, K3078 datetime, K3080 varchar(30), K3087 datetime, K3100 varchar(30), K3101 varchar(20), K3102 varchar(20), K3103 varchar(20), K3105 varchar(20), K3106 varchar(20), K3107 varchar(20), K3108 smallint, K3109 smallint, K3110 varchar(20), K3112 varchar(30), K3113 varchar(30), K3115 smallint, K3117 varchar(20), K3118 varchar(20), K3119 datetime, K3150 int, K3160 varchar(30), K3167 datetime, -- K3180 K3187 varchar(20), K3188 varchar(20), -- K3190 K3200 varchar(30), K3210 varchar(30), K3301 varchar(20), K3302 varchar(30), K3303 varchar(20), K3304 varchar(20), K3306 varchar(20), K3310 int, K3350 varchar(30), K3352 varchar(50), K3355 varchar(30), K3356 varchar(30), K3357 datetime, K3358 varchar(20), K3372 varchar(30), K3379 datetime, K3380 varchar(20), K3387 datetime, K3390 varchar(30), K3404 varchar(30), K3410 varchar(20), K3420 smallint, K3421 smallint, K3422 smallint, K3423 smallint, K3424 smallint, K3425 smallint, K3433 smallint, K3438 smallint, K3439 varchar(20), K3440 varchar(20), K3442 smallint, K3445 varchar(50), K3447 datetime, K3450 varchar(50), K3451 varchar(20), K3460 varchar(20), K3467 datetime, K3470 int, -- K3481 -- K3490 K3560 varchar(30), K3561 varchar(30), K3562 varchar(30), K3563 varchar(30), K3564 varchar(30), K3565 varchar(30), K3566 varchar(30), K3569 varchar(30), K3600 smallint, K3601 varchar(30), K3602 varchar(60), K3610 varchar(50), K3617 datetime, K3701 smallint, K3702 smallint, K3703 smallint, K3704 smallint, K3705 smallint, K3706 smallint, K3707 smallint, K3708 smallint, K3709 smallint, K3710 smallint, K3711 smallint, K3712 smallint, K3713 smallint, K3714 smallint, K3750 smallint, K3752 smallint, K3754 smallint, K3756 smallint, K3757 varchar(20), K3758 varchar(20), K3760 smallint, K3761 varchar(50), K3763 smallint, K3764 varchar(20) ) GO create unique index EMPB_3000 on EMPB_3000(K3000) GO ALTER TABLE EMPB_3000 ALTER COLUMN K3010 int GO ALTER TABLE EMPB_3000 ALTER COLUMN K3150 int GO ALTER TABLE EMPB_3000 ALTER COLUMN K3310 int GO ALTER TABLE EMPB_3000 ALTER COLUMN K3470 int GO Create table MEMO_FIELDS( MM_PART int, MM_CHARACT smallint, MM_MEASVALUE int, MM_K_R_KEY smallint, MM_K_FIELD smallint, MM_CONTENTS text ) GO create unique index MEMO_FIELDS on MEMO_FIELDS(MM_PART, MM_CHARACT, MM_MEASVALUE, MM_K_R_KEY, MM_K_FIELD) GO ALTER TABLE ERGEBNIS ADD EZUSDATLIST varchar(50) GO ALTER TABLE ERGEBNIS ADD ESTRATEGY int GO ALTER TABLE PRUEFER ADD PRFAX VARCHAR(50) GO ALTER TABLE PRUEFER ADD PREMAIL VARCHAR(50) GO ALTER TABLE PRUEFER ADD PRPOS VARCHAR(30) GO ALTER TABLE PRUEFER ADD PRANREDE VARCHAR(15) GO create table MITARB ( MIMITARB int, MINAME1 VARCHAR(50), MINAME2 VARCHAR(50), MIABT VARCHAR(50), MITELEFON VARCHAR(50), MIFAX VARCHAR(50), MIEMAIL VARCHAR(50), MIPOS VARCHAR(30), MIANREDE VARCHAR(15) ) GO create unique index MITARB on MITARB (MIMITARB) GO ALTER TABLE PARTCONFIG ADD PARTWINDOWLIST text go create table SIGNATUR ( SIGNATUR_ID int, SIGNATUR_COUNTER smallint, SIGNATUR_MODUL smallint, SIGNATUR_USER VARCHAR(50), SIGNATUR_USERDATE datetime, SIGNATUR_COMMENT VARCHAR(255), SIGNATUR_REASON smallint ) GO create unique index SIGNATUR on SIGNATUR (SIGNATUR_ID,SIGNATUR_COUNTER) GO create table SIGNATUR_FILES ( SIGNATUR_ID int, SIGNATUR_COUNTER int, SIGNATUR_TYPE int, SIGNATUR_ENTRY image, SIGNATUR_DESC VARCHAR(255), SIGNATUR_SIZE VARCHAR(20) ) GO ALTER TABLE SIGNATUR_FILES ALTER COLUMN SIGNATUR_COUNTER INT GO create unique index SIGNATUR_FILES on SIGNATUR_FILES (SIGNATUR_ID,SIGNATUR_COUNTER,SIGNATUR_TYPE) GO create table SIGNATUR_MASTER ( SIGNATUR_ID int, SIGNATUR_MODUL smallint, SIGNATUR_MASTERKEY VARCHAR(255), SIGNATUR_DATE datetime, SIGNATUR_EVALSTRAT int, SIGNATUR_EVALNAME VARCHAR(50) ) GO ALTER TABLE SIGNATUR_MASTER ADD SIGNATUR_COMMENT1 VARCHAR(255) GO ALTER TABLE SIGNATUR_MASTER ADD SIGNATUR_COMMENT2 VARCHAR(255) GO ALTER TABLE SIGNATUR_MASTER ADD SIGNATUR_COMMENT3 VARCHAR(255) GO create unique index SIGNATUR_MASTER on SIGNATUR_MASTER (SIGNATUR_ID) GO delete from SIGNATUR_REASON WHERE SIGNATUR_REASON <= 6 GO create table SIGNATUR_REASON ( SIGNATUR_REASON smallint, SIGNATUR_MODUL smallint, SIGNATUR_REASON_DESC VARCHAR(50), SIGNATUR_MUSTFILL smallint ) GO drop index SIGNATUR_REASON.SIGNATUR_REASON GO create unique index SIGNATUR_REASON on SIGNATUR_REASON (SIGNATUR_REASON,SIGNATUR_MODUL) GO Insert INTO SIGNATUR_REASON VALUES(1,1,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,1,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,10,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,10,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,20,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,20,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,26,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,26,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,30,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,30,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,60,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,60,'Approval',2) GO ALTER TABLE LAST_UPLOAD ADD K0006 VARCHAR(20) GO ALTER TABLE LAST_UPLOAD ADD K0007 int GO ALTER TABLE LAST_UPLOAD ADD K0008 int GO ALTER TABLE LAST_UPLOAD ADD K0010 int GO ALTER TABLE LAST_UPLOAD ADD K0012 int GO ALTER TABLE LAST_UPLOAD ADD K0053 VARCHAR(20) GO ALTER TABLE EMPB_3000 ALTER COLUMN K3355 VARCHAR(30) GO ALTER TABLE EMPB_3000 ALTER COLUMN K3356 VARCHAR(30) GO CREATE TABLE ARCHIVES ( ARARCHIVENO int, ARSTARTDATE datetime, ARENDDATE datetime, ARDATABASE VARCHAR(150), ARDBTYPE int, ARTABLESUFFIX VARCHAR(20), ARACTIVATED tinyint, ARARCHIVATED tinyint, ARVALUESDELETED tinyint ) GO CREATE UNIQUE INDEX ARCHIVES ON ARCHIVES(ARARCHIVENO) GO CREATE TABLE ARCHIVEACTIONS ( AAARCHIVENO int, AAACTIONNO int, AADATE datetime, AAUSER VARCHAR(50), AAACTION int ) GO CREATE UNIQUE INDEX ARCHIVEACTIONS ON ARCHIVEACTIONS(AAARCHIVENO, AAACTIONNO) GO -- Falls die Tabelle Results schon existiert... ALTER TABLE RESULTS ADD RID int GO ALTER TABLE RESULTS ADD RAUSWSTATUS int GO ALTER TABLE RESULTS ADD RCWERTEART int GO ALTER TABLE RESULTS ADD RCWERTEQUALITAET int GO ALTER TABLE RESULTS ADD RMFA VARCHAR(4000) GO ALTER TABLE RESULTS ADD R1000_0 FLOAT GO ALTER TABLE RESULTS ADD R1000_0_T FLOAT GO ALTER TABLE RESULTS ADD R1100_0 FLOAT GO ALTER TABLE RESULTS ADD R1100_0_T FLOAT GO ALTER TABLE RESULTS ADD R1200_0 FLOAT GO ALTER TABLE RESULTS ADD R1200_0_T FLOAT GO ALTER TABLE RESULTS ADD R1300_0 FLOAT GO ALTER TABLE RESULTS ADD R1300_0_T FLOAT GO ALTER TABLE RESULTS ADD R2000_0 FLOAT GO ALTER TABLE RESULTS ADD R2000_0_T FLOAT GO ALTER TABLE RESULTS ADD R2100_0 FLOAT GO ALTER TABLE RESULTS ADD R2100_0_T FLOAT GO ALTER TABLE RESULTS ADD R2300_0 FLOAT GO ALTER TABLE RESULTS ADD R2300_0_T FLOAT GO ALTER TABLE RESULTS ADD R4180_1 FLOAT GO ALTER TABLE RESULTS ADD R4180_1_T FLOAT GO ALTER TABLE RESULTS ADD R4190_1 FLOAT GO ALTER TABLE RESULTS ADD R4190_1_T FLOAT GO ALTER TABLE RESULTS ADD R4180_2 FLOAT GO ALTER TABLE RESULTS ADD R4180_2_T FLOAT GO ALTER TABLE RESULTS ADD R4190_2 FLOAT GO ALTER TABLE RESULTS ADD R4190_2_T FLOAT GO ALTER TABLE RESULTS ADD R4180_3 FLOAT GO ALTER TABLE RESULTS ADD R4180_3_T FLOAT GO ALTER TABLE RESULTS ADD R4190_3 FLOAT GO ALTER TABLE RESULTS ADD R4190_3_T FLOAT GO ALTER TABLE RESULTS ADD R4180_4 FLOAT GO ALTER TABLE RESULTS ADD R4180_4_T FLOAT GO ALTER TABLE RESULTS ADD R4190_4 FLOAT GO ALTER TABLE RESULTS ADD R4190_4_T FLOAT GO ALTER TABLE RESULTS ADD R4180_5 FLOAT GO ALTER TABLE RESULTS ADD R4180_5_T FLOAT GO ALTER TABLE RESULTS ADD R4190_5 FLOAT GO ALTER TABLE RESULTS ADD R4190_5_T FLOAT GO ALTER TABLE RESULTS ADD R4180_6 FLOAT GO ALTER TABLE RESULTS ADD R4180_6_T FLOAT GO ALTER TABLE RESULTS ADD R4190_6 FLOAT GO ALTER TABLE RESULTS ADD R4190_6_T FLOAT GO ALTER TABLE RESULTS ADD R4180_7 FLOAT GO ALTER TABLE RESULTS ADD R4180_7_T FLOAT GO ALTER TABLE RESULTS ADD R4190_7 FLOAT GO ALTER TABLE RESULTS ADD R4190_7_T FLOAT GO ALTER TABLE RESULTS ADD R4210_25 FLOAT GO ALTER TABLE RESULTS ADD R4210_25_T FLOAT GO ALTER TABLE RESULTS ADD R4210_75 FLOAT GO ALTER TABLE RESULTS ADD R4210_75_T FLOAT GO ALTER TABLE RESULTS ADD R5210_0 FLOAT GO ALTER TABLE RESULTS ADD R5210_0_T FLOAT GO ALTER TABLE RESULTS ADD R5220_0 FLOAT GO ALTER TABLE RESULTS ADD R5220_0_T FLOAT GO ALTER TABLE RESULTS ADD R5210_10 FLOAT GO ALTER TABLE RESULTS ADD R5210_10_T FLOAT GO ALTER TABLE RESULTS ADD R5220_10 FLOAT GO ALTER TABLE RESULTS ADD R5220_10_T FLOAT GO ALTER TABLE RESULTS ADD R6000_0 FLOAT GO ALTER TABLE RESULTS ADD R6000_0_T FLOAT GO ALTER TABLE RESULTS ADD R6100_0 FLOAT GO ALTER TABLE RESULTS ADD R6101_0 FLOAT GO ALTER TABLE RESULTS ADD R6102_0 FLOAT GO ALTER TABLE RESULTS ADD R6103_0 FLOAT GO ALTER TABLE RESULTS ADD R6104_0 FLOAT GO ALTER TABLE RESULTS ADD R6301_0 FLOAT GO ALTER TABLE RESULTS ADD R6302_0 FLOAT GO ALTER TABLE RESULTS ADD R8910_0 FLOAT GO ALTER TABLE RESULTS ADD R10500_0 FLOAT GO ALTER TABLE RESULTS ADD R10501_0 FLOAT GO ALTER TABLE RESULTS ADD R5240_0 FLOAT GO ALTER TABLE RESULTS ADD R5240_0_T FLOAT GO ALTER TABLE RESULTS ADD R5240_10 FLOAT GO ALTER TABLE RESULTS ADD R5240_10_T FLOAT GO ALTER TABLE RESULTS ADD REVENTS VARCHAR(100) GO ALTER TABLE RESULTS ADD R5500_0 FLOAT GO ALTER TABLE RESULTS ADD R5500_0_T FLOAT GO ALTER TABLE RESULTS ADD R5510_0 FLOAT GO ALTER TABLE RESULTS ADD R5510_0_T FLOAT GO ALTER TABLE RESULTS ADD R5520_0 FLOAT GO ALTER TABLE RESULTS ADD R5520_0_T FLOAT GO ALTER TABLE RESULTS ADD R5530_0 FLOAT GO ALTER TABLE RESULTS ADD R5530_0_T FLOAT GO CREATE TABLE RESULTS( RPART int, RCHARACTERISTIC int, RMODULE int, RFIRSTDATE datetime, RLASTDATE datetime, ROPERATOR int, RGAGE int, RMACHINE int, RNEST int, RBATCHNO VARCHAR(20), RORDERNO VARCHAR(20), RSEPERFIELDS VARCHAR(50), RSTRATEGY int, RID int, RAUSWSTATUS int, RCWERTEART int, RCWERTEQUALITAET int, RMFA VARCHAR(4000), R1000_0 FLOAT, R1000_0_T FLOAT, R1100_0 FLOAT, R1100_0_T FLOAT, R1200_0 FLOAT, R1200_0_T FLOAT, R1300_0 FLOAT, R1300_0_T FLOAT, R2000_0 FLOAT, R2000_0_T FLOAT, R2100_0 FLOAT, R2100_0_T FLOAT, R2300_0 FLOAT, R2300_0_T FLOAT, R4180_1 FLOAT, R4180_1_T FLOAT, R4190_1 FLOAT, R4190_1_T FLOAT, R4180_2 FLOAT, R4180_2_T FLOAT, R4190_2 FLOAT, R4190_2_T FLOAT, R4180_3 FLOAT, R4180_3_T FLOAT, R4190_3 FLOAT, R4190_3_T FLOAT, R4180_4 FLOAT, R4180_4_T FLOAT, R4190_4 FLOAT, R4190_4_T FLOAT, R4180_5 FLOAT, R4180_5_T FLOAT, R4190_5 FLOAT, R4190_5_T FLOAT, R4180_6 FLOAT, R4180_6_T FLOAT, R4190_6 FLOAT, R4190_6_T FLOAT, R4180_7 FLOAT, R4180_7_T FLOAT, R4190_7 FLOAT, R4190_7_T FLOAT, R4210_25 FLOAT, R4210_25_T FLOAT, R4210_75 FLOAT, R4210_75_T FLOAT, R5210_0 FLOAT, R5210_0_T FLOAT, R5220_0 FLOAT, R5220_0_T FLOAT, R5210_10 FLOAT, R5210_10_T FLOAT, R5220_10 FLOAT, R5220_10_T FLOAT, R6000_0 FLOAT, R6000_0_T FLOAT, R6100_0 FLOAT, R6101_0 FLOAT, R6102_0 FLOAT, R6103_0 FLOAT, R6104_0 FLOAT, R6301_0 FLOAT, R6302_0 FLOAT, R8910_0 FLOAT, R10500_0 FLOAT, R10501_0 FLOAT, R15000_0 FLOAT, R5240_0 FLOAT, R5240_0_T FLOAT, R5240_10 FLOAT, R5240_10_T FLOAT, REVENTS VARCHAR(100) ) GO CREATE INDEX RESULTS ON RESULTS(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY) GO CREATE TABLE RESULTS_FILES( RPART int, RCHARACTERISTIC int, RMODULE int, RFIRSTDATE datetime, RLASTDATE datetime, ROPERATOR int, RGAGE int, RMACHINE int, RNEST int, RBATCHNO VARCHAR(20), RORDERNO VARCHAR(20), RSEPERFIELDS VARCHAR(50), RSTRATEGY int, RID int, RREPORT_NUM smallint, RENTRY_TYPE int, RENTRY image, REPORTNAME VARCHAR(255) ) GO CREATE INDEX RESULTS_FILES ON RESULTS_FILES(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY) GO CREATE VIEW V_WERKZEUGNEST AS SELECT NEST.NENEST, WERKZEUG.WENR, NEST.NEBESCH FROM NEST LEFT JOIN WERKZEUG ON NEST.NEWERKZ = WERKZEUG.WEWERKZ GO ALTER TABLE EMPB_3000 ADD K3650 smallint GO -- ab VDA2, 4. Aufl. ALTER TABLE EMPB_3000 ADD K3015 tinyint GO ALTER TABLE EMPB_3000 ADD K3016 tinyint GO ALTER TABLE EMPB_3000 ADD K3017 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3019 tinyint GO ALTER TABLE EMPB_3000 ADD K3426 smallint GO ALTER TABLE EMPB_3000 ADD K3427 smallint GO ALTER TABLE EMPB_3000 ADD K3428 smallint GO ALTER TABLE EMPB_3000 ADD K3429 smallint GO ALTER TABLE EMPB_3000 ADD K3430 smallint GO ALTER TABLE EMPB_3000 ADD K3431 smallint GO ALTER TABLE EMPB_3000 ADD K3432 smallint GO ALTER TABLE EMPB_3000 ADD K3434 smallint GO ALTER TABLE EMPB_3000 ADD K3435 smallint GO ALTER TABLE EMPB_3000 ADD K3437 smallint GO ALTER TABLE EMPB_3000 ADD K3446 datetime GO ALTER TABLE EMPB_3000 ADD K3448 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3449 datetime GO ALTER TABLE EMPB_3000 ADD K3840 smallint GO ALTER TABLE EMPB_3000 ADD K3841 smallint GO ALTER TABLE EMPB_3000 ADD K3843 smallint GO ALTER TABLE EMPB_3000 ADD K3844 smallint GO ALTER TABLE EMPB_3000 ADD K3845 smallint GO ALTER TABLE EMPB_3000 ADD K3846 smallint GO ALTER TABLE EMPB_3000 ADD K3847 smallint GO ALTER TABLE EMPB_3000 ADD K3901 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3902 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3903 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3904 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3905 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3906 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3907 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3908 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3909 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3910 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3911 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3912 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3913 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3914 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3915 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3916 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3917 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3920 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3921 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3923 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3924 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3925 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3926 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3927 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3931 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3932 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3933 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3934 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3935 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3936 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3937 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3938 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3939 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3940 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3941 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3942 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3943 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3944 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3945 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3946 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3947 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3950 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3951 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3953 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3954 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3955 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3956 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3957 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3961 smallint GO ALTER TABLE EMPB_3000 ADD K3962 smallint GO ALTER TABLE EMPB_3000 ADD K3963 smallint GO ALTER TABLE EMPB_3000 ADD K3964 smallint GO ALTER TABLE EMPB_3000 ADD K3965 smallint GO ALTER TABLE EMPB_3000 ADD K3966 smallint GO ALTER TABLE EMPB_3000 ADD K3967 smallint GO ALTER TABLE EMPB_3000 ADD K3968 smallint GO ALTER TABLE EMPB_3000 ADD K3969 smallint GO ALTER TABLE EMPB_3000 ADD K3970 smallint GO ALTER TABLE EMPB_3000 ADD K3971 smallint GO ALTER TABLE EMPB_3000 ADD K3972 smallint GO ALTER TABLE EMPB_3000 ADD K3973 smallint GO ALTER TABLE EMPB_3000 ADD K3974 smallint GO ALTER TABLE EMPB_3000 ADD K3975 smallint GO ALTER TABLE EMPB_3000 ADD K3976 smallint GO ALTER TABLE EMPB_3000 ADD K3977 smallint GO ALTER TABLE EMPB_3000 ADD K3980 smallint GO ALTER TABLE EMPB_3000 ADD K3981 smallint GO ALTER TABLE EMPB_3000 ADD K3983 smallint GO ALTER TABLE EMPB_3000 ADD K3984 smallint GO ALTER TABLE EMPB_3000 ADD K3985 smallint GO ALTER TABLE EMPB_3000 ADD K3986 smallint GO ALTER TABLE EMPB_3000 ADD K3987 smallint GO ALTER TABLE EMPB_3000 ADD K3371 VARCHAR(30) GO ALTER TABLE EMPB_3000 ADD K3377 DATETIME GO ALTER TABLE EMPB_3000 ALTER COLUMN K3427 INT GO -- Prozedur WVINSERT zum Anlegen von Meßwerten CREATE PROCEDURE WVINSERT @PARA1 int, @PARA2 smallint, @PARA3 smallint, @PARA4 int, @PARA5 FLOAT, @PARA6 smallint, @PARA7 int, @PARA8 int, @PARA9 int, @PARA10 int, @PARA11 DATEtime, @PARA12 tinyint, @PARA13 VARCHAR(30), @PARA14 VARCHAR(20) AS BEGIN INSERT INTO WERTEVAR ( WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT,WVPRUEFER,WVPRUEFMIT,WVMASCHINE,WVNEST,WVDATZEIT, WVSTIANF,WVCHARGE,WVAUFTRAG ) VALUES (@PARA1, @PARA2, @PARA3, @PARA4, @PARA5, @PARA6, @PARA7, @PARA8, @PARA9, @PARA10, @PARA11, @PARA12, @PARA13, @PARA14); END GO create table MERKMAL_ZUS ( METEIL int , MEMERKMAL smallint , ME_2601 tinyint , ME_2605 varchar(255) , ME_2610 int , ME_2611 FLOAT , ME_2612 FLOAT , ME_2613 FLOAT , ME_2615 float, ME_2617 FLOAT , ME_2618 FLOAT , ME_2619 FLOAT , ME_2630 FLOAT , ME_2631 FLOAT , ME_2640 FLOAT , ME_2641 FLOAT , ME_2642 FLOAT , ME_2643 FLOAT , ME_2644 int , ME_2645 int , ME_2646 int , ME_2647 int , ME_2648 varchar(255) , ME_2700 tinyint , ME_2711 FLOAT , ME_2712 FLOAT , ME_2713 FLOAT , ME_2714 FLOAT , ME_2174 int , ME_2505 VARCHAR(20) , ME_2506 int , ME_2507 VARCHAR(2) , ME_2508 int , ME_2509 VARCHAR(40) , ME_2511 VARCHAR(20) , ME_2512 VARCHAR(20) , ME_2513 VARCHAR(20) , ME_2514 VARCHAR(20) , ME_2515 VARCHAR(20) , ME_2516 VARCHAR(20) , ME_2517 VARCHAR(20) , ME_2518 VARCHAR(20) , ME_2519 VARCHAR(20) , ME_2520 VARCHAR(20) , ME_2521 FLOAT , ME_2522 FLOAT , ME_2523 FLOAT , ME_2524 VARCHAR(20) , ME_2175 tinyint , ME_2176 tinyint , ME_2177 FLOAT , ME_2178 FLOAT , ME_2180 FLOAT , ME_2181 FLOAT , ME_2182 FLOAT , ME_2183 FLOAT , ME_2185 int , ME_2186 FLOAT , ME_2720 tinyint , ME_2723 tinyint , ME_2724 FLOAT , ME_2725 FLOAT , ME_2733 tinyint , ME_2734 FLOAT , ME_2735 FLOAT , ME_2736 FLOAT , ME_2737 FLOAT , ME_2738 FLOAT , ME_2740 FLOAT , ME_2741 int , ME_2743 tinyint , ME_2744 FLOAT , ME_2745 FLOAT , ME_2746 FLOAT , ME_2525 VARCHAR(255) , ME_2526 VARCHAR(255) ) GO ALTER TABLE MERKMAL_ZUS ADD ME_2175 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2176 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2177 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2178 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2180 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2181 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2182 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2183 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2185 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2186 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2720 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2723 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2724 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2725 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2733 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2734 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2735 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2736 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2737 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2738 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2740 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2741 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2743 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2744 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2745 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2746 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2525 VARCHAR(255) GO ALTER TABLE MERKMAL_ZUS ADD ME_2526 VARCHAR(255) GO create unique index MERKMAL_ZUS on MERKMAL_ZUS(METEIL, MEMERKMAL) GO drop index MERKMAL.METEIL GO drop index MERKMAL.MEMERKMAL GO create table TRANSMIT_HEADER ( STATIONGUID UNIQUEIDENTIFIER, TEILGUID UNIQUEIDENTIFIER, MERKMALGUID UNIQUEIDENTIFIER, KFELD smallint, INHALT TEXT, AENDDAT DATETIME, AENDUSER VARCHAR(50), STATUS int ) GO CREATE INDEX TH_AENDDAT ON TRANSMIT_HEADER(AENDDAT) GO CREATE INDEX TH_MERKMAL ON TRANSMIT_HEADER(MERKMALGUID) GO CREATE INDEX TH_TEIL ON TRANSMIT_HEADER(TEILGUID) GO create table TRANSMIT_WERTEVAR ( WVTEILGUID UNIQUEIDENTIFIER, WVMERKMALGUID UNIQUEIDENTIFIER, WVUNTERS smallint, WVWERTNR int, WVWERT FLOAT, WVATTRIBUT smallint, WVPRUEFER smallint, WVPRUEFMIT smallint, WVMASCHINE smallint, WVNEST smallint, WVDATZEIT DATETIME, WVSTIANF tinyint, WVCHARGE VARCHAR(20), WVAUFTRAG VARCHAR(20), WVSTATUS int, WVAENDDAT DATETIME, WVAENDUSER VARCHAR(20) ) GO CREATE INDEX TW_WVATTRIBUT ON TRANSMIT_WERTEVAR(WVATTRIBUT) GO CREATE INDEX TW_WVTEILGUID ON TRANSMIT_WERTEVAR(WVTEILGUID) GO CREATE INDEX TW_WVMERKMALGUID ON TRANSMIT_WERTEVAR(WVMERKMALGUID) GO CREATE INDEX TW_WVDATZEIT ON TRANSMIT_WERTEVAR(WVDATZEIT) GO CREATE INDEX TW_WVMASCHINE ON TRANSMIT_WERTEVAR(WVMASCHINE) GO CREATE INDEX TW_WVNEST ON TRANSMIT_WERTEVAR(WVNEST) GO CREATE INDEX TW_WVPRUEFER ON TRANSMIT_WERTEVAR(WVPRUEFER) GO CREATE INDEX TW_WVPRUEFMIT ON TRANSMIT_WERTEVAR(WVPRUEFMIT) GO create table STATION ( STATION_KEY UNIQUEIDENTIFIER, STATION_NO VARCHAR(50), STATION_DESC VARCHAR(50), STATION_IP VARCHAR(50), LASTSUCCESSFULL_SYNCH_END DATETIME, STATION_SYNCH_DATE_SERVER DATETIME, SYNCHRONIZE_START DATETIME, SYNCHRONIZE_END DATETIME, SYNCHRONIZE_INTERVAL DATETIME, SYNCHRONIZE_OFFSET DATETIME, LAST_SYNCH_START DATETIME, NEXT_SYNCH_EVENT DATETIME, DB_COMPRESS_INTERVAL DATETIME, LAST_DB_COMPRESSION DATETIME, MAX_VALUES int, MAX_LOGFILES_SIZE int, WITHOUT_REQUEST smallint, INFO VARCHAR(255) ) GO ALTER TABLE STATION ADD WITHOUT_REQUEST smallint GO ALTER TABLE STATION ADD INFO VARCHAR(255) GO ALTER TABLE STATION ADD STATION_PATH VARCHAR(255) GO CREATE UNIQUE INDEX STATION ON STATION(STATION_KEY) GO create table STATIONS_PART ( STATION UNIQUEIDENTIFIER, PART int, LASTERROR VARCHAR(255), CHANGEDATETIME DATETIME, TODELETE tinyint ) GO CREATE UNIQUE INDEX STATIONS_PART ON STATIONS_PART(STATION,PART) GO CREATE TABLE ORDKLASS ( OKKEY int, OKNR VARCHAR(40), OKBEZ VARCHAR(100), OKKURZBEZ VARCHAR(20) ) GO CREATE UNIQUE INDEX ORDKLASS ON ORDKLASS(OKKEY) GO CREATE TABLE ORDKLASSKAT ( OKKKEY int, OKKBEZ VARCHAR(100) ) GO CREATE UNIQUE INDEX ORDKLASSKAT ON ORDKLASSKAT(OKKKEY) GO CREATE TABLE ZU_OK_OKK ( OKKEY int, OKKKEY int ) GO CREATE UNIQUE INDEX ZU_OK_OKK ON ZU_OK_OKK(OKKEY, OKKKEY) GO CREATE TABLE FORMS ( FO_GUID UNIQUEIDENTIFIER, FO_PARTGUID UNIQUEIDENTIFIER, FO_CHARGUID UNIQUEIDENTIFIER, FO_USAGE tinyint, FO_MODULES VARCHAR(50), FO_GC_TYPES VARCHAR(50), FO_INTKEY1 int, FO_INTKEY2 int, FO_STRINGKEY1 VARCHAR(50), FO_STRINGKEY2 VARCHAR(50), FO_NAME VARCHAR(50), FO_CONTENTS text , FO_ALLPARTGUIDS VARCHAR(50) ) GO ALTER TABLE FORMS ADD FO_ALLPARTGUIDS VARCHAR(50) GO CREATE UNIQUE INDEX FORMS ON FORMS(FO_GUID) GO CREATE TABLE FORMS_PARTS ( FO_GUID UNIQUEIDENTIFIER, FO_ALL_PART_GUIDS text ) GO CREATE UNIQUE INDEX FORMS_PARTS ON FORMS_PARTS(FO_GUID) GO CREATE TABLE PSTEPS ( PV_VORGANGGUID UNIQUEIDENTIFIER, PV_STEP int, PV_STEPNAME VARCHAR(50), PV_START DATETIME, PV_END DATETIME, PV_USER smallint, PV_COMMENT text ) GO CREATE UNIQUE INDEX PSTEPS ON PSTEPS(PV_VORGANGGUID,PV_STEP) GO CREATE TABLE PVERSUCH ( PVPLAN int, PVAUFTRAG int, PVVORGANG smallint, PVVERSUCH smallint, PVVERSUCHNR VARCHAR(40), PVBEZEICH VARCHAR(80), PVBEMERK text, PVDATZEIT DATETIME, PVANMDAT DATETIME, PVANMBEN smallint, PVAENDDAT DATETIME, PVAENDBEN smallint, PVBEGINN DATETIME, PVENDE DATETIME, PV_VORGANGGUID UNIQUEIDENTIFIER, PV_0031 UNIQUEIDENTIFIER, PV_STATUS smallint, PV_SIGNATUR_ID int ) GO CREATE UNIQUE INDEX PVERSUCH ON PVERSUCH(PVPLAN,PVAUFTRAG,PVVORGANG,PVVERSUCH) GO CREATE INDEX PVERSUCH_VORG ON PVERSUCH(PV_VORGANGGUID) GO CREATE INDEX PVERSUCH_SIGID ON PVERSUCH(PV_SIGNATUR_ID) GO CREATE TABLE REDUCED_FIELDS ( FIELDLISTID int, FIELDLISTNAME VARCHAR(50), FIELDREDUCED smallint, FIELDMERKMAL_ZUS smallint, FIELDLIST text ) GO ALTER TABLE PAUFTRAG ADD PAGUID UNIQUEIDENTIFIER GO ALTER TABLE PPLAN ADD PPGUID UNIQUEIDENTIFIER GO ALTER TABLE PVORGANG ADD PV_PAGUID UNIQUEIDENTIFIER GO ALTER TABLE PVORGANG ADD PV_GUID UNIQUEIDENTIFIER GO ALTER TABLE PVORGANG ADD PV_MODUL smallint GO ALTER TABLE PVORGANG ADD PV_SUBTYPE smallint GO ALTER TABLE PVORGANG ADD PV_STATUS smallint GO ALTER TABLE PVORGANG ADD PV_BUTTONLEISTE VARCHAR(255) GO ALTER TABLE TEIL ADD TE_1344 varchar(50) GO ALTER TABLE TEIL ADD TE_1015 smallint GO ALTER TABLE TEIL ADD TE_1017 tinyint GO ALTER TABLE TEIL ADD TE_1087 VARCHAR(40) GO ALTER TABLE TEIL ADD TE_1018 int GO ALTER TABLE TEIL ADD TE_1401 int GO ALTER TABLE TEIL ADD TE_1402 int GO ALTER TABLE TEIL ADD TE_1403 int GO ALTER TABLE TEIL ADD TE_1404 int GO ALTER TABLE TEIL ADD TE_1405 int GO ALTER TABLE TEIL ADD TE_1407 int GO ALTER TABLE TEIL ADD TE_1408 int GO ALTER TABLE TEIL ADD TE_1410 varchar(255) GO ALTER TABLE TEIL ADD TE_1411 int GO ALTER TABLE TEIL ALTER COLUMN TE_1344 VARCHAR(50) GO ALTER TABLE TEIL ADD TE_1091 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1092 VARCHAR(40) GO ALTER TABLE TEIL ADD TE_1105 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1106 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1107 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1108 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1304 VARCHAR(20) GO ALTER TABLE TEIL ADD TE_1048 VARCHAR(80) GO ALTER TABLE MERKMAL ADD ME_2016 tinyint GO ALTER TABLE MERKMAL ADD MEMASTERGUID UNIQUEIDENTIFIER GO --ALTER TABLE WERTEVAR ADD -- WV0031 UNIQUEIDENTIFIER --GO ALTER TABLE TEIL ALTER COLUMN TEMASCHINENR VARCHAR(24) GO ALTER TABLE TEIL ALTER COLUMN TEPREINRNR VARCHAR(24) GO ALTER TABLE MERKMAL ALTER COLUMN MEMASCHNR VARCHAR(24) GO DROP INDEX WERTEVAR.WVTEIL GO DROP INDEX WERTEVAR.WVMERKMAL GO -- ab PPAP 4. Aufl. ALTER TABLE EMPB_3000 ADD K3186 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3186 varchar(20) GO ALTER TABLE EMPB_3000 ADD K3192 tinyint GO ALTER TABLE EMPB_3000 ADD K3250 varchar(50) GO ALTER TABLE EMPB_3000 ADD K3251 varchar(30) GO ALTER TABLE EMPB_3000 ADD K3770 tinyint GO ALTER TABLE EMPB_3000 ADD K3771 varchar(80) GO CREATE TABLE LAST_UPLOAD_KEYS ( NEXTVAL int IDENTITY (1, 1) NOT NULL , DUMMY_I VARCHAR(50) NULL ) GO create table SERIAL_NUMBERS ( SERIAL_ID int, SERIAL_NO VARCHAR(50), CUST_SERIAL_NO VARCHAR(50), CUSTOMER_ID int, PRODUCTION_DATE DATETIME ) GO ALTER TABLE SERIAL_NUMBERS ADD ORDER_NO VARCHAR(50) GO ALTER TABLE SERIAL_NUMBERS ADD PALLET_NO VARCHAR(50) GO ALTER TABLE SERIAL_NUMBERS ADD BATCH_NO VARCHAR(50) GO ALTER TABLE SERIAL_NUMBERS ADD CUST_DESCR VARCHAR(40) GO ALTER TABLE SERIAL_NUMBERS ADD PROJECT_NO VARCHAR(20) GO ALTER TABLE SERIAL_NUMBERS ADD ADDITIONAL_DATE DATETIME GO ALTER TABLE SERIAL_NUMBERS ADD K0005 VARCHAR(40) GO ALTER TABLE SERIAL_NUMBERS ADD K0007 int GO ALTER TABLE SERIAL_NUMBERS ADD K0008 int GO ALTER TABLE SERIAL_NUMBERS ADD K0009 VARCHAR(100) GO ALTER TABLE SERIAL_NUMBERS ADD K0010 int GO ALTER TABLE SERIAL_NUMBERS ADD K0011 VARCHAR(40) GO ALTER TABLE SERIAL_NUMBERS ADD K0012 int GO ALTER TABLE SERIAL_NUMBERS ADD K0014 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0015 int GO ALTER TABLE SERIAL_NUMBERS ADD K0016 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0017 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0054 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0055 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0056 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0057 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0058 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0059 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0060 VARCHAR(32) GO ALTER TABLE SERIAL_NUMBERS ADD K0061 int GO ALTER TABLE SERIAL_NUMBERS ADD K0062 int GO ALTER TABLE SERIAL_NUMBERS ADD K0063 int GO create unique index SERIAL_NUMBERS_ID on SERIAL_NUMBERS (SERIAL_ID) GO create index SERIAL_NUMBERS_NO on SERIAL_NUMBERS (SERIAL_NO) GO create index SERIAL_NUMBERS_CUNO on SERIAL_NUMBERS (CUST_SERIAL_NO) GO create index SERIAL_NUMBERS_DATE on SERIAL_NUMBERS (PRODUCTION_DATE) GO create table SERIAL_KEYS ( SERIAL_ID INT, STATION INT, SERIAL_NO VARCHAR(50), SERIAL_DATE DATETIME ) GO ALTER TABLE SERIAL_KEYS ADD READING_QLTY_ALL VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD READING_QLTY_1 VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD READING_QLTY_2 VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD READING_QLTY_3 VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD READING_QLTY_4 VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD ORDER_NO VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD PALLET_NO VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD GREENBODY_NO VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD DRAWING_NO VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD DRAWIND_IDX VARCHAR(30) GO ALTER TABLE SERIAL_KEYS ADD MATERIAL_NO VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD PLANT VARCHAR(50) GO ALTER TABLE SERIAL_KEYS ADD MATERIAL_TEXT VARCHAR(80) GO ALTER TABLE SERIAL_KEYS ADD DIMENSION VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD INSPECTIONLOT VARCHAR(20) GO ALTER TABLE SERIAL_KEYS ADD ADDITIONAL_DATE DATETIME GO ALTER TABLE SERIAL_KEYS ADD K0005 VARCHAR(40) GO ALTER TABLE SERIAL_KEYS ADD K0007 int GO ALTER TABLE SERIAL_KEYS ADD K0008 int GO ALTER TABLE SERIAL_KEYS ADD K0009 VARCHAR(100) GO ALTER TABLE SERIAL_KEYS ADD K0010 int GO ALTER TABLE SERIAL_KEYS ADD K0011 VARCHAR(40) GO ALTER TABLE SERIAL_KEYS ADD K0012 int GO ALTER TABLE SERIAL_KEYS ADD K0014 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0015 int GO ALTER TABLE SERIAL_KEYS ADD K0016 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0017 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0054 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0055 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0056 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0057 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0058 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0059 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0060 VARCHAR(32) GO ALTER TABLE SERIAL_KEYS ADD K0061 int GO ALTER TABLE SERIAL_KEYS ADD K0062 int GO ALTER TABLE SERIAL_KEYS ADD K0063 int GO ALTER TABLE SERIAL_KEYS ADD BATCH_NO VARCHAR(50) GO create unique index SERIAL_KEYS on SERIAL_KEYS (SERIAL_ID, STATION) GO create table EQUIPMENT ( EQ_KEY int, EQ_NUMBER VARCHAR(30), EQ_DESC VARCHAR(50) ) GO create unique index EQUIPMENT on EQUIPMENT(EQ_KEY) GO create table SERIAL_EQUIPMENT ( SERIAL_ID int, STATION int, EQUIPMENT_KEY int, EQUIPMENT_BATCHNO VARCHAR(50) ) GO create unique index SERIAL_EQUIPMENT on SERIAL_EQUIPMENT(SERIAL_ID, STATION, EQUIPMENT_KEY) GO create index SERIAL_ID on SERIAL_EQUIPMENT(SERIAL_ID) GO create table KUNDEKAT ( KUKNR int, KUKBEZ varchar(100) ) GO create unique index KUNDEKAT on KUNDEKAT(KUKNR) GO create table ZU_KU_KUK ( KUKEY int, KUKNR int ) GO create unique index ZU_KU_KUK on ZU_KU_KUK(KUKEY, KUKNR) GO create table HERSTELLKAT ( HEKNR int, HEKBEZ varchar(100) ) GO create unique index HERSTELLKAT on HERSTELLKAT(HEKNR) GO create table ZU_HE_HEK ( HEKEY int, HEKNR int ) GO create unique index ZU_HE_HEK on ZU_HE_HEK(HEKEY, HEKNR) GO create table LIEFKAT ( LIKNR int, LIKBEZ varchar(100) ) GO create unique index LIEFKAT on LIEFKAT(LIKNR) GO create table ZU_LI_LIK ( LIKEY int, LIKNR int ) GO create unique index ZU_LI_LIK on ZU_LI_LIK(LIKEY, LIKNR) GO create table PAUFTKAT ( PAKNR int, PAKBEZ varchar(100) ) GO create unique index PAUFTKAT on PAUFTKAT(PAKNR) GO create table ZU_PA_PAK ( PAKEY int, PAKNR int ) GO create unique index ZU_PA_PAK on ZU_PA_PAK(PAKEY, PAKNR) GO create table WERKSTOFFKAT ( WSKNR int, WSKBEZ varchar(100) ) GO create unique index WERKSTOFFKAT on WERKSTOFFKAT(WSKNR) GO create table ZU_WS_WSK ( WSKEY int, WSKNR int ) GO create unique index ZU_WS_WSK on ZU_WS_WSK(WSKEY, WSKNR) GO create table ZEICHNKAT ( ZNKNR int, ZNKBEZ varchar(100) ) GO create unique index ZEICHNKAT on ZEICHNKAT(ZNKNR) GO create table ZU_ZN_ZNK ( ZNKEY int, ZNKNR int ) GO create unique index ZU_ZN_ZNK on ZU_ZN_ZNK(ZNKEY, ZNKNR) GO create table MASCHINKAT ( MAKNR int, MAKBEZ varchar(100) ) GO create unique index MASCHINKAT on MASCHINKAT(MAKNR) GO create table ZU_MA_MAK ( MAKEY int, MAKNR int ) GO create unique index ZU_MA_MAK on ZU_MA_MAK(MAKEY, MAKNR) GO create table PRUEFMITKAT ( PMKNR int, PMKBEZ varchar(100) ) GO create unique index PRUEFMITKAT on PRUEFMITKAT(PMKNR) GO create table ZU_PM_PMK ( PMKEY int, PMKNR int ) GO create unique index ZU_PM_PMK on ZU_PM_PMK(PMKEY, PMKNR) GO create table EINHEITKAT ( EIKNR int, EIKBEZ varchar(100) ) GO create unique index EINHEITKAT on EINHEITKAT(EIKNR) GO create table ZU_EI_EIK ( EIKEY int, EIKNR int ) GO create unique index ZU_EI_EIK on ZU_EI_EIK(EIKEY, EIKNR) GO create table PRUEFERKAT ( PRKNR int, PRKBEZ varchar(100) ) GO create unique index PRUEFERKAT on PRUEFERKAT(PRKNR) GO create table ZU_PR_PRK ( PRKEY int, PRKNR int ) GO create unique index ZU_PR_PRK on ZU_PR_PRK(PRKEY, PRKNR) GO create table AUFTRGEBKAT ( AUGKNR int, AUGKBEZ varchar(100) ) GO create unique index AUFTRGEBKAT on AUFTRGEBKAT(AUGKNR) GO create table ZU_AUG_AUGK ( AUGKEY int, AUGKNR int ) GO create unique index ZU_AUG_AUGK on ZU_AUG_AUGK(AUGKEY, AUGKNR) GO create table ERZEUGNISKAT ( EZKNR int, EZKBEZ varchar(100) ) GO create unique index ERZEUGNISKAT on ERZEUGNISKAT(EZKNR) GO create table ZU_EZ_EZK ( EZKEY int, EZKNR int ) GO create unique index ZU_EZ_EZK on ZU_EZ_EZK(EZKEY, EZKNR) GO create table MITARBKAT ( MIKNR int, MIKBEZ varchar(100) ) GO create unique index MITARBKAT on MITARBKAT(MIKNR) GO create table ZU_MI_MIK ( MIKEY int, MIKNR int ) GO create unique index ZU_MI_MIK on ZU_MI_MIK(MIKEY, MIKNR) GO create table NESTKAT ( NEKNR int, NEKBEZ varchar(100) ) GO create unique index NESTKAT on NESTKAT(NEKNR) GO create table ZU_NE_NEK ( NEKEY int, NEKNR int ) GO create unique index ZU_NE_NEK on ZU_NE_NEK(NEKEY, NEKNR) GO -- Statusflags bei allen Katalogen alter table KUNDE add KUSTATE int default 0 go update KUNDE set KUSTATE = 0 where KUSTATE is NULL go alter table HERSTELL add HESTATE int default 0 go update HERSTELL set HESTATE = 0 where HESTATE is NULL go alter table LIEFERAN add LISTATE int default 0 go update LIEFERAN set LISTATE = 0 where LISTATE is NULL go alter table PAUFTRAG add PASTATE int default 0 go update PAUFTRAG set PASTATE = 0 where PASTATE is NULL go alter table PAUFTRAG add PAFAELLIGMINUTEN int default 0 go update PAUFTRAG set PAFAELLIGMINUTEN = 0 where PAFAELLIGMINUTEN is NULL go alter table PAUFTRAG add PAFAELLIGSTUECK int default 0 go update PAUFTRAG set PAFAELLIGSTUECK = 0 where PAFAELLIGSTUECK is NULL go alter table PAUFTRAG add PASTUECK int default 0 go update PAUFTRAG set PASTUECK = 0 where PASTUECK is NULL go alter table PAUFTRAG add PAFAELLIGJETZT int default 0 go update PAUFTRAG set PAFAELLIGJETZT = 0 where PAFAELLIGJETZT is NULL go alter table PAUFTRAG add PAALARMMINUTEN int default 0 go update PAUFTRAG set PAALARMMINUTEN = 0 where PAALARMMINUTEN is NULL go ALTER TABLE PAUFTRAG ADD PACHARGENR VARCHAR(40) GO ALTER TABLE PAUFTRAG ADD PAMASCHINE VARCHAR(50) GO ALTER TABLE PAUFTRAG ADD PAWERKZEUG VARCHAR(50) GO ALTER TABLE PAUFTRAG ADD PAWERKSTATT VARCHAR(50) GO alter table WERKSTOF add WSSTATE int default 0 go update WERKSTOF set WSSTATE = 0 where WSSTATE is NULL go alter table ZEICHN add ZNSTATE int default 0 go update ZEICHN set ZNSTATE = 0 where ZNSTATE is NULL go alter table MASCHINE add MASTATE int default 0 go update MASCHINE set MASTATE = 0 where MASTATE is NULL go alter table PRUEFMIT add PMSTATE int default 0 go update PRUEFMIT set PMSTATE = 0 where PMSTATE is NULL go alter table EINHEIT add EISTATE int default 0 go update EINHEIT set EISTATE = 0 where EISTATE is NULL go alter table PRUEFER add PRSTATE int default 0 go update PRUEFER set PRSTATE = 0 where PRSTATE is NULL go alter table AUFTRGEB add AUGSTATE int default 0 go update AUFTRGEB set AUGSTATE = 0 where AUGSTATE is NULL go alter table ERZEUGNIS add EZSTATE int default 0 go update ERZEUGNIS set EZSTATE = 0 where EZSTATE is NULL go alter table MITARB add MISTATE int default 0 go update MITARB set MISTATE = 0 where MISTATE is NULL go alter table EREIGTXT add ETSTATE int default 0 go update EREIGTXT set ETSTATE = 0 where ETSTATE is NULL go alter table ORDKLASS add OKBEWERT smallint default 0 go update ORDKLASS set OKBEWERT = 0 where OKBEWERT is NULL go alter table ORDKLASS add OKSTATE int default 0 go update ORDKLASS set OKSTATE = 0 where OKSTATE is NULL go alter table PROZPARAMTXT add PPSTATE int default 0 go update PROZPARAMTXT set PPSTATE = 0 where PPSTATE is NULL go alter table NEST add NESTATE int default 0 go update NEST set NESTATE = 0 where NESTATE is NULL go ALTER TABLE EG_AEND ALTER COLUMN EGMASCHINE INT GO ALTER TABLE EG_AEND ALTER COLUMN EGNEST INT GO CREATE TABLE MERKMAL_REPORT_NO_SELECT ( METEIL INT , MEMERKMAL SMALLINT , MEREPORT VARCHAR(255) , MODUL SMALLINT , CONFNAME VARCHAR(50) ) GO create index MERKMAL_REPORT_NST on MERKMAL_REPORT_NO_SELECT(METEIL) GO ALTER TABLE ALARMS ADD ALARM_EW INT GO ALTER TABLE ALARMS ADD ALARM_QRK_L INT GO ALTER TABLE ALARMS ADD ALARM_QRK_S INT GO ALTER TABLE ALARMS ADD ALARM_CP INT GO ALTER TABLE ALARMS ADD K0006 VARCHAR(20) GO ALTER TABLE ALARMS ADD K0007 INT GO ALTER TABLE ALARMS ADD K0008 INT GO ALTER TABLE ALARMS ADD K0010 INT GO ALTER TABLE ALARMS ADD K0012 INT GO ALTER TABLE ALARMS ADD K0053 VARCHAR(20) GO ALTER TABLE ALARMS ADD K1000 INT GO ALTER TABLE ALARMS ADD K0000 INT GO ALTER TABLE ALARMS ADD SUMMARY_NR INT GO ALTER TABLE ALARMS ADD STATUS_PRINTED INT GO ALTER TABLE ALARMS ADD POINTS INT GO ALTER TABLE ALARMS ADD STATION_NO VARCHAR(50) GO ALTER TABLE ALARM_VALUES ADD POINTS INT GO ALTER TABLE LAST_UPLOAD ADD MMNRINTERN SMALLINT GO ALTER TABLE LAST_UPLOAD ADD TIDNR VARCHAR(20) GO ALTER TABLE LAST_UPLOAD ADD K1001 VARCHAR(40) GO ALTER TABLE LAST_UPLOAD ADD K1002 VARCHAR(80) GO ALTER TABLE MERKMAL ALTER COLUMN MEPRUEFMIT INT GO ALTER TABLE MERKMAL ALTER COLUMN MEMASCHINE INT GO ALTER TABLE MERKMAL ALTER COLUMN MEPRUEFER INT GO ALTER TABLE MERKMAL ALTER COLUMN MEWERKSTCK INT GO ALTER TABLE MERKMAL_REPORT ALTER COLUMN MEREPORTALARM VARCHAR(255) GO ALTER TABLE ORDKLASS ADD OKRANG INT GO ALTER TABLE RESULTS ADD K2005_0 SMALLINT GO ALTER TABLE RESULTS ADD R5210_20 FLOAT GO ALTER TABLE RESULTS ADD R5210_20_T FLOAT GO ALTER TABLE RESULTS ADD R5220_20 FLOAT GO ALTER TABLE RESULTS ADD R5220_20_T FLOAT GO CREATE TABLE SIGNATURE_KEYS ( NEXTVAL int IDENTITY (1, 1) NOT NULL , DUMMY_I VARCHAR(50) NULL ) GO ALTER TABLE MITARB ALTER COLUMN MIABT VARCHAR(50) GO ALTER TABLE ORDKLASS ALTER COLUMN OKNR VARCHAR(40) GO ALTER TABLE ORDKLASS ALTER COLUMN OKBEZ VARCHAR(100) GO ALTER TABLE ORDKLASSKAT ALTER COLUMN OKKBEZ VARCHAR(100) GO --CREATE TABLE SIGNATURE_KEYS ( -- NEXTVAL int IDENTITY((SELECT ISNULL(MAX(SIGNATUR_ID), 0) + 1 FROM SIGNATUR_MASTER), 1) NOT NULL , -- DUMMY_I VARCHAR(50) NULL --) --GO create table MERKMAL_MASTER ( METEIL int , MEMERKMAL smallint , MEMERKNR varchar(20) , MEMERKBEZ varchar(80) , MENENNMAS float , MEARTUGW smallint , MEARTOGW smallint , MEARTPLAUSIUNT smallint , MEARTPLAUSIOB smallint , MEUGW float , MEOGW float , MEFSK smallint , MEFEHLART tinyint , MEFEHLKOST float , MEDPFLICHT smallint , MEEINHEIT smallint , MEAUFLOES smallint , MEKLASSENW float , MEFERTARTNR varchar(20) , MEPMGRUPPE smallint , MEPRUEFMIT int , MEPRUEFMITNR smallint , MEERFART smallint , MEMASCHINE int , MEBEMERK text , MESTIFREQ smallint , MEUMFSTICH smallint , MEANZSTICH int , MEANZMESSGC int , MEANZPRUEF int , MEUMFPROZ smallint , MEANZWIED smallint , MEANZTEILE int , METOLERANZ smallint , METRANSART tinyint , METRANSPA float , METRANSPB float , METRANSPC float , METRANSPD float , MEGLMITT smallint , MEAUSWART smallint , MEAUSWTYP smallint , MEMERKART smallint , MEVERTFORM smallint , MEPLAUSIOB float , MEPLAUSIUN float , MEPROSTREUSTR varchar(40) , MEPROSTREU float , MENORMISTSTR varchar(80) , MENORMIST float , -- MENORMNR varchar(20) , MENORMNR varchar(40) , MENORMBEZ varchar(40) , MENORMTEMP varchar(40) , MEKLASSUNT float , MEKLASSOB float , MEKLASSNR float , MEVORGCP float , MEVORGCPK float , MESTEUERB tinyint , MEZYKLUS smallint , MEPRUEFZST smallint , MEPRUEFORT smallint , MEMASSN smallint , MEPRFSPEC smallint , MEAUTOAKT smallint , MEMERKKLASSE smallint , MEUNTERSART smallint , MEANZORDKLASSE smallint , MEGLEITSTUMF smallint , MEPUFFERSIZE smallint , MEAUTOERKENNUNG smallint , MEATTR smallint , METRANSFEING smallint , METRANSFEINGA float , METRANSFEINGB float , MENLINKSMA smallint , MEERFKANAL varchar(20) , MEERFSUBKANAL varchar(20) , MENACHARBEIT smallint , MEZIELWERT float , MEZIELWERTT float , MEPMAX float , MELOSUMFANG int , MEKOSTENNACHARBEIT float , MEKOSTENAUSSCHUSS float , MEMASCHNR varchar(24) , MEABT varchar(40) , MEAUFTRAGGEBNR smallint , MEAUFTRAGGEBNRT varchar(20) , MEPRUEFER int , MEPRUEFERNR varchar(20) , MEAUGROUP smallint , MEUPPERMERKMAL smallint , MEWERKSTCK int , MEPMAUFLOES float , MEPRUEFBEGINND datetime , MEPRUEFENDED datetime , MENORMAL smallint , MENORMALTEMP float , MEWERKSTCKNR varchar(20), MEKURZBEZ varchar(20), MEUGSCHROTT FLOAT, MEOGSCHROTT FLOAT, MECG FLOAT, MECGK FLOAT, MEABWGC FLOAT, MEFERTARTKEY smallint, MEPMHERST varchar(40), MEKORRSTRAT smallint, MEUKG FLOAT, MEOKG FLOAT, MEKORRZIEL FLOAT, MEERFNR smallint, MEERFNAME varchar(40), MEERFINDEX smallint, MEANFINDEX smallint, MEINTERFACE smallint, MEBAUD int, MEIRQ smallint, MEPARITY smallint, MEDATA smallint, MESTOP smallint, MEPZPKAT smallint, METOLERANZCALC FLOAT, MEBEREICH varchar(40), MEPTM varchar(40), MEPPLANNRT varchar(20), MEPPLAN varchar(40), MEPPLANDAT varchar(20), MEPPLANERST varchar(40), MESPCNR varchar(20), MESPCHERST varchar(40), MESPCTYP varchar(20), MECP FLOAT, MECPK FLOAT, MECPFIX FLOAT, MECPKFIX FLOAT, MEGAGE25 VARCHAR(110) , MEEINHREL VARCHAR(20) , MEADDFAKREL FLOAT , MEMULFAKREL FLOAT , MENORMISTUN FLOAT , MENORMISTOB FLOAT , MEFERTART varchar(80) , MEPMGRUPPET varchar(80) , MEPRUEFMITT varchar(80) , MEPRUEFMITNRT varchar(80) , MEEINHEITTEXT varchar(80) , MEMASCHBEZ varchar(80) , MESTANDORT varchar(80) , MEAUFTRNR varchar(80) , MEAUFTRAGGEB varchar(80) , MEPRUEFORTT varchar(80) , MEPRUEFBEGINN varchar(80) , MEPRUEFENDE varchar(80) , MEPRUEFERNAME varchar(80) , METOLERANZTEXT varchar(80) , MEWERKSTCKTEXT varchar(80) , MEANZSPTEXT varchar(80) , MESTIFREQT varchar(80) , MEZEICHN varchar(80) , MENENNMAST varchar(50) , MEUGWT varchar(50) , MEOGWT varchar(50) , MEPLAUSIUT varchar(50) , MEPLAUSIOT varchar(50) , MEFORMEL varchar(255) , MEKONFIG varchar(1000) , MEEREIGKAT varchar(50) , MENENNMASSP varchar(50) , MEPRUEFBEDING varchar(255) , MENORMALSERNR VARCHAR(20), MEPRUEFMITSERNR VARCHAR(20), MEANZGERAET VARCHAR(40), MEREFTEILNRSTR VARCHAR(20), MEREFTEILBEZ VARCHAR(40), MEREFTEILIST FLOAT, MEREFTEILTEMP FLOAT, MEREFTEILNR smallint, MEREFTEILSERNR VARCHAR(20), MEKALTEILUNRSTR VARCHAR(20), MEKALTEILUBEZ VARCHAR(40), MEKALTEILUIST FLOAT, MEKALTEILUTEMP FLOAT, MEKALTEILUNR smallint, MEKALTEILUSERNR VARCHAR(20), MEKALTEILMNRSTR VARCHAR(20), MEKALTEILMBEZ VARCHAR(40), MEKALTEILMIST FLOAT, MEKALTEILMTEMP FLOAT, MEKALTEILMNR smallint, MEKALTEILMSERNR VARCHAR(20), MEKALTEILONRSTR VARCHAR(20), MEKALTEILOBEZ VARCHAR(40), MEKALTEILOIST FLOAT, MEKALTEILOTEMP FLOAT, MEKALTEILONR smallint, MEKALTEILOSERNR VARCHAR(20), MEUEBERKAN smallint, MEMERKCODE VARCHAR(40), MEMERKINDEX VARCHAR(20), MEMERKTEXT VARCHAR(50), MEBEARBZUST VARCHAR(80), MEELEMCODE VARCHAR(40), MEELEMINDEX VARCHAR(20), MEELEMTEXT VARCHAR(50), MEELEMADR VARCHAR(20), MEFREIFELD tinyint, MECALIBADD FLOAT, MECALIBMULT FLOAT, MEANZNIAUSGEF int, MEGCKONVART tinyint, MEANZREF smallint, MEREFPKTX smallint, MEREFPKTY smallint, MEREFPKTZ smallint, -- neu für EMPB ME_2430 smallint, ME_2432 smallint, ME_2434 smallint, ME_2436 varchar(10), ME_2438 varchar(10), ME_2440 varchar(40), ME_2442 varchar(15), ME_2444 varchar(40), ME_2446 varchar(40), ME_2448 varchar(40), ME_8530 smallint, ME_8531 float, ME_8532 float, ME_8540 smallint, -- ME_2073 float, ME_2107 float, ME_2170 float, ME_2171 float, ME_2172 float, ME_2173 float, ME_2228 float, ME_2229 float, ME_2230 float, ME_2231 float, ME_2232 float, ME_2233 float, ME_2235 float, ME_2236 float, ME_2016 tinyint, MEMASTERGUID UNIQUEIDENTIFIER ) GO create unique index MERKMAL_MASTER on MERKMAL_MASTER(MEMASTERGUID) GO create table PART_CHAR_OPER_LINK ( OPERATION_GUID UNIQUEIDENTIFIER, PART_KEY int, CHAR_KEY int, CHAR_GUID UNIQUEIDENTIFIER, SAMPLE_SIZE int, SAMPLE_FREQ varchar(50), RECORD_TYPE varchar(50), GAGE varchar(50) ) GO create unique index PART_CHAR_OPER_LINK on PART_CHAR_OPER_LINK(OPERATION_GUID, PART_KEY, CHAR_KEY) GO create table PLANT_LEVEL ( LEVEL_ID int, LEVEL_NO varchar(50), LEVEL_DESC varchar(255), LEVEL_SOURCE int, LEVEL_DESC_NO varchar(255), LEVEL_TYPE_FIELD_NO varchar(50), LEVEL_DESC_DESC varchar(255), LEVEL_TYPE_FIELD_DESC varchar(50), LEVEL_IMAGE image, LEVEL_NEW_TEXT varchar(50), LEVEL_DESC_FIELD_01 varchar(255), LEVEL_TYPE_FIELD_01 varchar(50), LEVEL_DESC_FIELD_02 varchar(255), LEVEL_TYPE_FIELD_02 varchar(50), LEVEL_DESC_FIELD_03 varchar(255), LEVEL_TYPE_FIELD_03 varchar(50), LEVEL_DESC_FIELD_04 varchar(255), LEVEL_TYPE_FIELD_04 varchar(50), LEVEL_DESC_FIELD_05 varchar(255), LEVEL_TYPE_FIELD_05 varchar(50), LEVEL_DESC_FIELD_06 varchar(255), LEVEL_TYPE_FIELD_06 varchar(50), LEVEL_DESC_FIELD_07 varchar(255), LEVEL_TYPE_FIELD_07 varchar(50), LEVEL_DESC_FIELD_08 varchar(255), LEVEL_TYPE_FIELD_08 varchar(50), LEVEL_DESC_FIELD_09 varchar(255), LEVEL_TYPE_FIELD_09 varchar(50), LEVEL_DESC_FIELD_10 varchar(255), LEVEL_TYPE_FIELD_10 varchar(50) ) GO create unique index PLANT_LEVEL on PLANT_LEVEL(LEVEL_ID) GO create table PLANT_STRUCT ( NODE_ID UNIQUEIDENTIFIER, PARENT_ID UNIQUEIDENTIFIER, NODE_LEVEL int, NODE_LOCALPOS int, NODE_SOURCE_KEY int, NODE_SOURCE_GUID UNIQUEIDENTIFIER, NODE_NO varchar(50), NODE_DESC varchar(255), NODE_IMAGE image, NODE_FIELD_01 varchar(255), NODE_FIELD_02 varchar(255), NODE_FIELD_03 varchar(255), NODE_FIELD_04 varchar(255), NODE_FIELD_05 varchar(255), NODE_FIELD_06 varchar(255), NODE_FIELD_07 varchar(255), NODE_FIELD_08 varchar(255), NODE_FIELD_09 varchar(255), NODE_FIELD_10 varchar(255) ) GO create unique index PLANT_STRUCT on PLANT_STRUCT(NODE_ID) GO CREATE INDEX PLANT_STRUCT2 ON PLANT_STRUCT(NODE_LEVEL, NODE_LOCALPOS) GO CREATE TABLE PLANT_DISTR_NUMS ( MACHINE_NODE_ID UNIQUEIDENTIFIER, CHAR_MASTER_GUID UNIQUEIDENTIFIER, DISTR_NUMBER VARCHAR(40) ) GO create unique index PLANT_DISTR_NUMS on PLANT_DISTR_NUMS(MACHINE_NODE_ID, CHAR_MASTER_GUID) GO CREATE TABLE LINE_ALERT_DISTRIB ( LINE_ID UNIQUEIDENTIFIER, OPERATION_ID UNIQUEIDENTIFIER, RECIPIENT_KEY INT, EMAIL TINYINT, SMS TINYINT ) GO create unique index LINE_ALERT_DISTRIB on LINE_ALERT_DISTRIB(LINE_ID, OPERATION_ID, RECIPIENT_KEY) GO create table PRODUCT_LEVEL ( LEVEL_ID int, LEVEL_NO varchar(50), LEVEL_DESC varchar(255), LEVEL_SOURCE int, LEVEL_DESC_NO varchar(255), LEVEL_TYPE_FIELD_NO varchar(50), LEVEL_DESC_DESC varchar(255), LEVEL_TYPE_FIELD_DESC varchar(50), LEVEL_IMAGE image, LEVEL_NEW_TEXT varchar(50), LEVEL_DESC_FIELD_01 varchar(255), LEVEL_TYPE_FIELD_01 varchar(50), LEVEL_DESC_FIELD_02 varchar(255), LEVEL_TYPE_FIELD_02 varchar(50), LEVEL_DESC_FIELD_03 varchar(255), LEVEL_TYPE_FIELD_03 varchar(50), LEVEL_DESC_FIELD_04 varchar(255), LEVEL_TYPE_FIELD_04 varchar(50), LEVEL_DESC_FIELD_05 varchar(255), LEVEL_TYPE_FIELD_05 varchar(50), LEVEL_DESC_FIELD_06 varchar(255), LEVEL_TYPE_FIELD_06 varchar(50), LEVEL_DESC_FIELD_07 varchar(255), LEVEL_TYPE_FIELD_07 varchar(50), LEVEL_DESC_FIELD_08 varchar(255), LEVEL_TYPE_FIELD_08 varchar(50), LEVEL_DESC_FIELD_09 varchar(255), LEVEL_TYPE_FIELD_09 varchar(50), LEVEL_DESC_FIELD_10 varchar(255), LEVEL_TYPE_FIELD_10 varchar(50) ) GO create unique index PRODUCT_LEVEL on PRODUCT_LEVEL(LEVEL_ID) GO create table PRODUCT_STRUCT ( NODE_ID UNIQUEIDENTIFIER, PARENT_ID UNIQUEIDENTIFIER, NODE_LEVEL int, NODE_LOCALPOS int, NODE_SOURCE_KEY int, NODE_SOURCE_GUID UNIQUEIDENTIFIER, NODE_NO varchar(50), NODE_DESC varchar(255), NODE_IMAGE image, NODE_FIELD_01 varchar(255), NODE_FIELD_02 varchar(255), NODE_FIELD_03 varchar(255), NODE_FIELD_04 varchar(255), NODE_FIELD_05 varchar(255), NODE_FIELD_06 varchar(255), NODE_FIELD_07 varchar(255), NODE_FIELD_08 varchar(255), NODE_FIELD_09 varchar(255), NODE_FIELD_10 varchar(255) ) GO create unique index PRODUCT_STRUCT on PRODUCT_STRUCT(NODE_ID) GO CREATE INDEX PRODUCT_STRUCT2 ON PRODUCT_STRUCT(NODE_LEVEL, NODE_LOCALPOS) GO create table MEASUREMENT_DOKUMENTS ( MD_ID int, MD_TEIL int, MD_MEASUREMENT_IDENT varchar(50), MD_DOCDESCR varchar(50), MD_DOCPATH varchar(60) ) GO create unique index MEASUREMENT_DOKUMENTS on MEASUREMENT_DOKUMENTS(MD_ID) GO create index TEIL_VALUE on MEASUREMENT_DOKUMENTS(MD_TEIL, MD_MEASUREMENT_IDENT) GO ALTER TABLE MEASUREMENT_DOKUMENTS ALTER COLUMN MD_DOCPATH VARCHAR(255) GO create table KAT_4270 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT ) GO create unique index KAT_4270 on KAT_4270(KATKEY) GO create table KAT_4270KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4270KAT on KAT_4270KAT(SUBKATKEY) GO create table ZU_4270KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4270KAT on ZU_4270KAT(KATKEY, SUBKATKEY) GO create table KAT_4280 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT ) GO create unique index KAT_4280 on KAT_4280(KATKEY) GO create table KAT_4280KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4280KAT on KAT_4280KAT(SUBKATKEY) GO create table ZU_4280KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4280KAT on ZU_4280KAT(KATKEY, SUBKATKEY) GO create table KAT_4290 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT ) GO create unique index KAT_4290 on KAT_4290(KATKEY) GO create table KAT_4290KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4290KAT on KAT_4290KAT(SUBKATKEY) GO create table ZU_4290KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4290KAT on ZU_4290KAT(KATKEY, SUBKATKEY) GO ALTER TABLE TEIL ALTER COLUMN TEKONFIG VARCHAR(1000) GO ALTER TABLE MERKMAL ALTER COLUMN MEKONFIG VARCHAR(1000) GO ALTER TABLE MERKMAL_MASTER ALTER COLUMN MEKONFIG VARCHAR(1000) GO CREATE TABLE MANUAL_QCC_PRINT ( BORDEREAU_ID INT NOT NULL, DG_BORDEREAU_ID INT, STATUS TINYINT NOT NULL, WORKSTATION_ID VARCHAR(100), PRINTER_ID VARCHAR(100), BORDEREAU_TYPE TINYINT, YEAR_NO SMALLINT, WEEK_NO TINYINT, DAY_NO TINYINT, CLASSIFICATION VARCHAR(50), EVENT_01_ID INT, EVENT_02_ID INT, EVENT_03_ID INT, EVENT_04_ID INT, EVENT_05_ID INT, EVENT_06_ID INT, EVENT_07_ID INT, EVENT_08_ID INT, EVENT_09_ID INT, EVENT_10_ID INT, DIV_01_ID VARCHAR(50), DIV_01_REVISION VARCHAR(20), DIV_02_ID VARCHAR(50), DIV_02_REVISION VARCHAR(20), DIV_03_ID VARCHAR(50), DIV_03_REVISION VARCHAR(20), DIV_04_ID VARCHAR(50), DIV_04_REVISION VARCHAR(20), DIV_05_ID VARCHAR(50), DIV_05_REVISION VARCHAR(20), CONTROL_PLAN_ID VARCHAR(50), ATELIER_NO VARCHAR(50), LINE_NO VARCHAR(50), LINE_DESC VARCHAR(50), OPERATION_NO VARCHAR(50), OPERATION_DESC VARCHAR(50), MACHINE_NO VARCHAR(50), MACHINE_DESC VARCHAR(50), CHAR_NO VARCHAR(20), CHAR_DESC VARCHAR(80), GAGE_ID VARCHAR(50), GAGE_DESC VARCHAR(50), SAMPLE_FREQ VARCHAR(80), SAMPLE_SIZE SMALLINT, LSL FLOAT, USL FLOAT, NOMINAL FLOAT, LLIMITTYPE TINYINT, ULIMITTYPE TINYINT, LCL FLOAT, UCL FLOAT, UNIT VARCHAR(20), PRECISION_SIZE TINYINT, PAGENO TINYINT, MAXPAGE TINYINT, LOI TINYINT, DISTRIBUTIONNO VARCHAR(20), EVENT_01_TEXT VARCHAR(40), EVENT_02_TEXT VARCHAR(40), EVENT_03_TEXT VARCHAR(40), EVENT_04_TEXT VARCHAR(40), EVENT_05_TEXT VARCHAR(40), EVENT_06_TEXT VARCHAR(40), EVENT_07_TEXT VARCHAR(40), EVENT_08_TEXT VARCHAR(40), EVENT_09_TEXT VARCHAR(40), EVENT_10_TEXT VARCHAR(40), CHAR_REMARK VARCHAR(255) ) GO CREATE TABLE MANUAL_QCC_PRINT_HISTORY ( BORDEREAU_ID INT NOT NULL, STATUS_HISTORY TINYINT NOT NULL, STATUS_TIME DATETIME NOT NULL ) GO ALTER TABLE EG_AEND ADD EG_LEXL float GO ALTER TABLE EG_AEND ADD EG_UEXL float GO ALTER TABLE EG_AEND ADD EG_EXSTART datetime GO ALTER TABLE EG_AEND ADD EG_EXEND datetime GO ALTER TABLE EG_AEND ADD EG_EXVALID tinyint GO create table PLANT_JOBS ( TREE_TYPE tinyint, NODE_ID UNIQUEIDENTIFIER, JOB_NO int, JOB_NAME VARCHAR(80), JOB_KIND tinyint, JOB_ACTIVE tinyint, PLAN_KIND tinyint, PLAN_TIME FLOAT, NODE_LEVEL tinyint, NODE_SUBLEVEL tinyint, JOB_REPORT VARCHAR(255), VALUE_FILTER int ) GO create unique index PLANT_JOBS on PLANT_JOBS(TREE_TYPE, NODE_ID, JOB_NO) GO create index JOB_ACTIVE on PLANT_JOBS(JOB_ACTIVE) GO create index JOB_KIND on PLANT_JOBS(JOB_KIND) GO alter table PLANT_JOBS add OFFSET smallint GO alter table PLANT_JOBS add NODE_SUBSUBLEVEL tinyint GO alter table PLANT_JOBS add LT_DIVISION VARCHAR(100) GO alter table PLANT_JOBS add PDF_OUTPUT_DIR VARCHAR(255) GO create table JOB_FILTERS ( FILTER_ID int, FILTER_LEVEL tinyint, FILTER_NAME VARCHAR(50), FILTER text ) GO create unique index JOB_FILTERS on JOB_FILTERS(FILTER_ID) GO create index FILTER_LEVEL on JOB_FILTERS(FILTER_LEVEL) GO create index FILTER_NAME on JOB_FILTERS(FILTER_NAME) GO ALTER TABLE TEIL ALTER COLUMN TEHERSTELLERKEY int GO ALTER TABLE TEIL ALTER COLUMN TEWERKSTOFFKEY int GO ALTER TABLE TEIL ALTER COLUMN TEZEICHNUNGKEY int GO ALTER TABLE TEIL ALTER COLUMN TEAUFTRAGGBKEY int GO ALTER TABLE TEIL ALTER COLUMN TEKUNDEKEY int GO ALTER TABLE TEIL ALTER COLUMN TELIEFERANTKEY int GO ALTER TABLE TEIL ALTER COLUMN TEMASCHINEKEY int GO ALTER TABLE TEIL ALTER COLUMN TEPREINRKEY int GO create table NODELOCK ( NLNODEGUID UNIQUEIDENTIFIER, NLNODETYPE int, NLNODESUBTYPE int, NLUSERNAME VARCHAR(90) ) GO create unique index NODELOCK on NODELOCK(NLNODEGUID) GO create table NODERIGHTS ( NRNODEGUID UNIQUEIDENTIFIER, NRUSERKEY int, NRCREATECHILD VARCHAR(1), NREDITNODE VARCHAR(1), NRDELETENODE VARCHAR(1), NRGRANTRIGHTS VARCHAR(1) ) GO create unique index NODERIGHTS on NODERIGHTS(NRNODEGUID, NRUSERKEY) GO alter table PLANT_JOBS add LANGUAGE int GO alter table PLANT_JOBS add MODULE int GO alter table PLANT_JOBS add STRATEGY int GO alter table PLANT_JOBS add PART_FILTER int GO alter table PLANT_JOBS add CHAR_FILTER int GO alter table PLANT_JOBS add REPORT_LEVEL tinyint GO create table PLANT_REPORT_MAIL_LIST ( NODE_ID UNIQUEIDENTIFIER, JOB_NO int, RECIPIENT_KEY int ) GO create unique index PLANT_REPORT_MAIL_LIST on PLANT_REPORT_MAIL_LIST(NODE_ID, JOB_NO, RECIPIENT_KEY) GO create index MEMASTERGUID on MERKMAL(MEMASTERGUID) GO alter table PLANT_REPORT_MAIL_LIST add ATTACH_REPORTS tinyint GO alter table PLANT_JOBS add MAXNODESPERPAGE tinyint GO alter table PLANT_JOBS add DIVIDE_GRAPHICS tinyint GO alter table PLANT_JOBS add GRAPH_ROWS tinyint GO create table PART_CHAR_MACHINE ( PARTNO_1001 VARCHAR(30), CHARNO_2001 VARCHAR(30), MACHINEKEY int, CHAR_MASTERGUID UNIQUEIDENTIFIER ) GO create unique index PART_CHAR_MACHINE on PART_CHAR_MACHINE(PARTNO_1001, CHARNO_2001, MACHINEKEY) GO alter table AUFTRGEB ALTER COLUMN AUNAME1 VARCHAR ( 100 ) GO alter table EINHEIT ALTER COLUMN EIEINHTEXT VARCHAR ( 100 ) GO alter table EMPB_3000 ALTER COLUMN K3427 int GO alter table EREIGKAT ALTER COLUMN EKTEXT VARCHAR ( 100 ) GO alter table EREIGTXT ALTER COLUMN ETTEXT VARCHAR ( 100 ) GO alter table EREIGTXT ALTER COLUMN ETCODE VARCHAR ( 40 ) GO alter table MASCHINE ALTER COLUMN MABEZ VARCHAR ( 100 ) GO alter table MERKMAL ALTER COLUMN MEEINHEIT int GO alter table MERKMAL ALTER COLUMN MEPMGRUPPE int GO alter table MERKMAL ALTER COLUMN MEPRUEFMITNR int GO alter table MERKMAL ALTER COLUMN MEAUFTRAGGEBNR int GO alter table MERKMAL ALTER COLUMN MEFERTARTKEY int GO alter table MITARB ALTER COLUMN MIABT VARCHAR ( 50 ) GO alter table PAUFTRAG ALTER COLUMN PABEZEICH VARCHAR ( 100 ) GO alter table PROZPARAMKAT ALTER COLUMN PPKTEXT VARCHAR ( 100 ) GO alter table PROZPARAMTXT ALTER COLUMN PPNRTEXT VARCHAR ( 40 ) GO alter table PROZPARAMTXT ALTER COLUMN PPLANGTEXT VARCHAR ( 100 ) GO alter table PROZPARAMWERT ALTER COLUMN PPWNRTEXT VARCHAR ( 40 ) GO alter table PRUEFER ALTER COLUMN PRABT VARCHAR ( 50 ) GO alter table TEIL ALTER COLUMN TEPRUEFERKEY int GO alter table WERKSTOF ALTER COLUMN WSBEZEICH VARCHAR ( 100 ) GO alter table WERKZEUG ALTER COLUMN WENR VARCHAR ( 100 ) GO alter table ZEICHN ALTER COLUMN ZNZNR VARCHAR ( 40 ) GO alter table ZEICHN ALTER COLUMN ZNZNRindex VARCHAR ( 100 ) GO ALTER TABLE MERKMAL_ZUS ADD ME_2650 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2651 FLOAT GO ALTER TABLE MERKMAL_ZUS ADD ME_2652 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2654 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2655 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2656 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2657 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2658 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2660 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2062 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2063 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2064 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2065 int GO ALTER TABLE MERKMAL_ZUS ADD MEANZMESSV int GO ALTER TABLE MERKMAL_ZUS ADD MEANZSTAB int GO ALTER TABLE MERKMAL_ZUS ADD ME_2190 VARCHAR(10) GO ALTER TABLE MERKMAL_ZUS ADD ME_2066 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2067 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2068 int GO ALTER TABLE MEASVALUES ADD WV0005 VARCHAR(20) GO ALTER TABLE EMPB_3000 ADD K3436 smallint GO ALTER TABLE USERLOCK ALTER COLUMN LCUSER varchar(90) GO ALTER TABLE NODELOCK ALTER COLUMN NLUSERNAME VARCHAR(90) GO create table UNCONFORMITY_REPORTS ( UR_ID int, UR_USERID int, UR_USERNAME varchar(50), UR_CREATIONDATE datetime, UR_TEIL int, UR_MERKMAL int, UR_WERTNR int, UR_STATUS tinyint, UR_IMAGE image, UR_MODIFDATE datetime, UR_CLOSE_USERID int, UR_CLOSE_USERNAME varchar(50), UR_CLOSE_COMMENT varchar(255) ) GO create unique index UNCONFORMITY_REPORTS on UNCONFORMITY_REPORTS(UR_ID) GO create index UR_CLOSE_USERID on UNCONFORMITY_REPORTS(UR_CLOSE_USERID) GO create index UR_USERID on UNCONFORMITY_REPORTS(UR_USERID) GO create table UNCONF_DIAGN ( UR_ID int, UD_ID int, UD_ANALYSIS varchar(255), UD_CAUSE varchar(255) ) GO create unique index UNCONF_DIAGN on UNCONF_DIAGN(UR_ID, UD_ID) GO create table UNCONF_ACTION ( UR_ID int, UA_ID int, UA_NOTE varchar(100), UA_ACTION varchar(255), UA_RESPONS varchar(50), UA_DATE varchar(20), UA_EFFECT varchar(100) ) GO create unique index UNCONF_ACTION on UNCONF_ACTION(UR_ID, UA_ID) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_TYPE tinyint GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_SUPPLIER varchar(50) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_PRIO_ACTION int GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_ALLOC_USERS varchar(25) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_2ND_IMAGE image GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_2ND_IMAGETYPE varchar(10) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_PH_RECT varchar(30) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_USER_TEXT varchar(80) GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_GROUPING_ID UNIQUEIDENTIFIER GO ALTER TABLE UNCONFORMITY_REPORTS ADD UR_LAYOUT tinyint GO alter table SERIAL_EQUIPMENT add EQUIPMENT_PARTNO VARCHAR(50) GO alter table SERIAL_EQUIPMENT add EQUIPMENT_DMC VARCHAR(50) GO alter table SERIAL_EQUIPMENT add EQUIPMENT_ORDERNO VARCHAR(50) GO ALTER TABLE MERKMAL ALTER COLUMN MESPCHERST varchar(40) GO ALTER TABLE MERKMAL_MASTER ALTER COLUMN MESPCHERST varchar(40) GO alter table EREIGTXT add ETCAQKENNUNG varchar(10) GO alter table STATION add PP_DESELECT tinyint GO ALTER TABLE MERKMAL_ZUS ALTER COLUMN ME_2615 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2620 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2621 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2622 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2623 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2624 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2625 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2626 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2627 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2628 float GO CREATE TABLE NODERESULTS ( NRNODEID UNIQUEIDENTIFIER, NRMODULE int, NRFIRSTDATE datetime, NRLASTDATE datetime, NROPERATOR int, NRGAGE int, NRMACHINE int, NRNEST int, NRBATCHNO varchar(30), NRORDERNO varchar(30), NRSEPFIELDS varchar(50), NRSTRATEGY int, NRPS15210_00000033 float, NRPS15210_00330067 float, NRPS15210_00670100 float, NRPS15210_01000133 float, NRPS15210_01330167 float, NRPS15210_01670200 float, NRPS15210_02000233 float, NRPS15210_02330267 float, NRPS15210_02679999 float, NRPS15220_M9990000 float, NRPS15220_00000033 float, NRPS15220_00330067 float, NRPS15220_00670100 float, NRPS15220_01000133 float, NRPS15220_01330167 float, NRPS15220_01670200 float, NRPS15220_02000233 float, NRPS15220_02330267 float, NRPS15220_02679999 float, NR_OEE float, NR_OEE_V float, NR_OEE_P float, NR_OEE_N float, NR_OEE_F float ) GO ALTER TABLE NODERESULTS ADD NRPS15000_00000001 float GO ALTER TABLE NODERESULTS ADD NRPS15000_00000016 float GO ALTER TABLE NODERESULTS ADD NRPS15000_00000032 float GO ALTER TABLE NODERESULTS ADD NRPS15000_00004096 float GO CREATE TABLE NODEREPORTFILES ( NRF_NODEID UNIQUEIDENTIFIER, NRF_MODULE int, NRF_FIRSTDATE datetime, NRF_LASTDATE datetime, NRF_OPERATOR int, NRF_GAGE int, NRF_MACHINE int, NRF_NEST int, NRF_BATCHNO varchar(30), NRF_ORDERNO varchar(30), NRF_SEPFIELDS varchar(50), NRF_STRATEGY int, NRF_REPORT_NUM int, NRF_ENTRY_TYPE int, NRF_ENTRY image, NRF_REPORTNAME varchar(255) ) GO ALTER TABLE MERKMAL_ZUS ADD ME_2028 tinyint GO ALTER TABLE MERKMAL_ZUS ADD ME_2614 int GO ALTER TABLE MERKMAL_ZUS ADD ME_2632 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2633 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2739 float GO ALTER TABLE MERKMAL_ZUS ADD ME_8524 float GO ALTER TABLE MERKMAL_ZUS ADD ME_8525 float GO ALTER TABLE MERKMAL_ZUS ADD ME_2417 int GO ALTER TABLE TEIL ADD TE_1412 int GO ALTER TABLE TEIL ADD TE_1413 float GO ALTER TABLE TEIL ADD TE_1414 int GO ALTER TABLE TEIL ADD TE_1415 tinyint GO ALTER TABLE EMPB_3000 ADD K3780 varchar(120) GO ALTER TABLE EMPB_3000 ADD K3781 varchar(120) GO ALTER TABLE EMPB_3000 ADD K3782 varchar(120) GO ALTER TABLE WERKZEUG ALTER COLUMN WEWERKZ int GO CREATE TABLE EMPB_3000_ZUS ( K3000 int, K3418 smallint, K3419 smallint, K3500 smallint, K3501 smallint, K3502 smallint, K3503 smallint, K3504 smallint, K3505 smallint, K3506 smallint, K3507 smallint, K3508 smallint, K3509 smallint, K3510 smallint, K3660 VARCHAR(20), K3661 VARCHAR(20), K3662 VARCHAR(20), K3663 VARCHAR(20), K3664 VARCHAR(20), K3665 VARCHAR(20), K3666 VARCHAR(20), K3667 VARCHAR(20), K3668 VARCHAR(20), K3669 VARCHAR(20), K3670 VARCHAR(20), K3673 VARCHAR(50), K3674 VARCHAR(50), K3675 VARCHAR(50), K3676 VARCHAR(50), K3677 VARCHAR(50), K3678 VARCHAR(50), K3679 VARCHAR(50), K3680 VARCHAR(50), K3681 VARCHAR(50), K3682 VARCHAR(50), K3683 VARCHAR(50), K3686 smallint, K3687 smallint, K3688 smallint, K3689 smallint, K3690 smallint, K3691 smallint, K3692 smallint, K3693 smallint, K3694 smallint, K3695 smallint, K3696 smallint ) GO create unique index EMPB_3000_ZUS on EMPB_3000_ZUS(K3000) GO ALTER TABLE EMPB_3000 ALTER COLUMN K3030 varchar(120) GO ALTER TABLE MASCHINE ADD MABEREICH VARCHAR(50) GO ALTER TABLE MASCHINE ADD MAABT VARCHAR(50) GO ALTER TABLE MASCHINE ADD MAOPNR VARCHAR(50) GO ALTER TABLE MASCHINE ADD MAEXTREFNR VARCHAR(50) GO ALTER TABLE PRUEFMIT ALTER COLUMN PMEINSORT VARCHAR(50) GO ALTER TABLE PRUEFMIT ADD PMIPADDR VARCHAR(30) GO ALTER TABLE PRUEFMIT ADD PMCOMP VARCHAR(50) GO ALTER TABLE PRUEFMIT ADD PMQVERS VARCHAR(30) GO ALTER TABLE PRUEFMIT ADD PMSOFTW VARCHAR(50) GO ALTER TABLE WERKSTOF ADD WSBEMERK VARCHAR(200) GO ALTER TABLE ZEICHN ADD ZNBEMERK VARCHAR(200) GO ALTER TABLE EINHEIT ADD EIBEMERK VARCHAR(200) GO ALTER TABLE PRUEFER ADD PRBEMERK VARCHAR(200) GO ALTER TABLE MITARB ADD MIBEMERK VARCHAR(200) GO ALTER TABLE ERZEUGNIS ADD EZBEMERK VARCHAR(200) GO ALTER TABLE EREIGTXT ADD ETBEMERK VARCHAR(200) GO ALTER TABLE ORDKLASS ADD OKBEMERK VARCHAR(200) GO ALTER TABLE PROZPARAMTXT ADD PPBEMERK VARCHAR(200) GO ALTER TABLE NEST ADD NEBEMERK VARCHAR(200) GO ALTER TABLE KAT_4270 ADD BEMERK VARCHAR(200) GO ALTER TABLE KAT_4280 ADD BEMERK VARCHAR(200) GO ALTER TABLE KAT_4290 ADD BEMERK VARCHAR(200) GO --ALTER TABLE TEIL RENAME COLUMN TEZSB_1015 TO TEZSB_1016 EXEC sp_rename 'TEIL.TEZSB_1015', 'TEZSB_1016', 'COLUMN' GO CREATE INDEX TW_WV0005 ON TRANSMIT_WERTEVAR(WV0005) GO ALTER TABLE MEASUREMENT_DOKUMENTS ADD MD_MERKMAL int GO ALTER TABLE MEASUREMENT_DOKUMENTS ADD MD_WERTNR int GO CREATE TABLE CAQ_EREIGNIS ( CE_ID int, CE_TEIL int, CE_MERKMAL int, CE_EREIGNISID VARCHAR(255) ) GO CREATE TABLE CAQ_URSACHE ( CU_ID int, CU_EREIGNISID VARCHAR(255), CU_URSACHEID VARCHAR(255) ) GO CREATE TABLE CAQ_MASSNAHME ( CM_ID int, CM_URSACHENID VARCHAR(255), CM_MASSNAHMEID VARCHAR(255) ) GO CREATE TABLE IQS_QDAS_MAPPING ( IQS_CLASS VARCHAR(20), IQS_FIELD VARCHAR(30), IQS_SUBFIELD VARCHAR(20), QDAS_TABLE VARCHAR(30), QDAS_FIELD VARCHAR(20), QDAS_FIELD_SUBKEY VARCHAR(20), QDAS_PARTKEY VARCHAR(20), QDAS_CHARKEY VARCHAR(20), QDAS_TAKEOVER VARCHAR(20), QDAS_TRIGGER VARCHAR(20) ) GO ALTER TABLE IQS_QDAS_MAPPING ALTER COLUMN IQS_CLASS varchar(30) GO ALTER TABLE IQS_QDAS_MAPPING ALTER COLUMN IQS_FIELD varchar(40) GO ALTER TABLE IQS_QDAS_MAPPING ADD QDAS_PPLANKEY VARCHAR(30) GO ALTER TABLE IQS_QDAS_MAPPING ADD QDAS_PAUFTRAGKEY VARCHAR(30) GO ALTER TABLE IQS_QDAS_MAPPING ADD QDAS_UNTERSKEY VARCHAR(30) GO CREATE TABLE IQS_QDAS_CONTENT_MAPPING ( IQS_CLASS VARCHAR(20), IQS_FIELD VARCHAR(30), IQS_FIELD_SUBKEY VARCHAR(3), IQS_CONTENT VARCHAR(20), QDAS_FIELD VARCHAR(20), QDAS_FIELD_SUBKEY VARCHAR(20), QDAS_CONTENT VARCHAR(20) ) GO ALTER TABLE IQS_QDAS_CONTENT_MAPPING ALTER COLUMN IQS_CLASS varchar(30) GO ALTER TABLE IQS_QDAS_CONTENT_MAPPING ALTER COLUMN IQS_FIELD varchar(40) GO CREATE TABLE IQS_FIELD_TO_FIELD_MAPPING ( IQS_CLASS_SOURCE VARCHAR(30), IQS_FIELD_SOURCE VARCHAR(40), IQS_CLASS_DEST VARCHAR(30), IQS_FIELD_DEST VARCHAR(40) ) GO ALTER TABLE TEIL ADD TE_1094 varchar(24) GO ALTER TABLE TEIL ADD TE_1095 varchar(40) GO ALTER TABLE TEIL ADD TE_1096 int GO ALTER TABLE TEIL ADD TE_1019 int GO ALTER TABLE TEIL ADD TE_1798 int GO ALTER TABLE TEIL ADD TE_1799 text GO ALTER TABLE UNTERS ADD USCODE int GO ALTER TABLE UNTERS ADD USPRUEFORTNR int GO ALTER TABLE UNTERS ADD USNSTMAX int GO ALTER TABLE UNTERS ADD USFAELLIGMINUTEN int GO ALTER TABLE UNTERS ADD USFAELLIGSTUECK int GO alter table PLANT_STRUCT add NODE_FILTER_PART varchar(255) GO alter table PLANT_STRUCT add NODE_FILTER_CHAR varchar(255) GO alter table PLANT_STRUCT add NODE_FILTER_VALUE varchar(255) GO alter table PRODUCT_STRUCT add NODE_FILTER_PART varchar(255) GO alter table PRODUCT_STRUCT add NODE_FILTER_CHAR varchar(255) GO alter table PRODUCT_STRUCT add NODE_FILTER_VALUE varchar(255) GO ALTER TABLE LAST_UPLOAD ADD SPU INT GO CREATE TABLE ALARMHIST ( TNR INT, MMNR INT, MWNR INT, IDENT VARCHAR(255) ) GO create unique index ALARMHIST on ALARMHIST(TNR, MMNR, IDENT) GO CREATE TABLE DATA_IMAGES ( IM_ID UNIQUEIDENTIFIER, IM_PARENT UNIQUEIDENTIFIER, IM_PATH VARCHAR(80), IM_TYPE TINYINT, IM_TREEDEPTH TINYINT, IM_IMAGE IMAGE ) GO CREATE UNIQUE INDEX DATA_IMAGES ON DATA_IMAGES(IM_ID) GO ALTER TABLE TEIL ALTER COLUMN TEMESSPROGNR VARCHAR(80) GO create unique index WVTMW on WERTEVAR (WVTEIL, WVMERKMAL, WVWERTNR) GO ALTER TABLE WERKSTOF ADD WSALPHA float GO ALTER TABLE WERKSTOF ADD WSUALPHA float GO ALTER TABLE EMPB_3000_ZUS ADD K3220 varchar(40) GO ALTER TABLE EMPB_3000_ZUS ADD K3221 datetime GO ALTER TABLE TEIL ADD TEGUID UNIQUEIDENTIFIER GO ALTER TABLE MERKMAL ADD MEGUID UNIQUEIDENTIFIER GO ALTER TABLE MERKMAL_MASTER ADD MEGUID UNIQUEIDENTIFIER GO create table EG_AEND_ZD ( EGTEIL int , EGMERKMAL smallint , EGUNTERS smallint , EGWERTNR int , EG_FIELDS VARCHAR(20), EG_K0006 VARCHAR(50), EG_K0007 int, EG_K0008 int, EG_K0010 int, EG_K0012 int, EG_K0014 VARCHAR(50), EG_K0016 VARCHAR(50), EG_K0017 VARCHAR(50), EG_K0053 VARCHAR(50), EG_K0054 VARCHAR(50), EG_K0055 VARCHAR(50), EG_K0056 VARCHAR(50), EG_K0057 VARCHAR(50), EG_K0058 VARCHAR(50), EG_K0059 VARCHAR(50), EG_K0060 VARCHAR(50), EG_K0061 int, EG_K0062 int, EG_K0063 int, EGCP float , EGCPK float , EGLAGART tinyint , EGLAGSTREU tinyint , EGLAGGRART tinyint , EGPEARSON tinyint , EGMINMAX float , EGMITTELW tinyint , EGCWERTGUE smallint , EGCAUSGZUL tinyint , EGCUN float , EGCUN_UN float , EGCUN_OB float , EGCOB float , EGCOB_UN float , EGCOB_OB float , EGC float , EGC_UN float , EGC_OB float , EGCUNATR tinyint , EGCUNVBATR tinyint , EGCOBATR tinyint , EGCOBVBATR tinyint , EGCATR tinyint , EGCVBATR tinyint , EGCKATR tinyint , EGLAGEMIN float , EGLAGEMAX float , EGLAGUEG float , EGLAGMITTE float , EGLAGOEG float , EGLAGUWG float , EGLAGOWG float , EGLAGUUNT float , EGLAGUOB float , EGP_F float , EGEW_F float , EGGS_F float , EGSAQRKGSF float , EGSTRART tinyint , EGSTRSTREU tinyint , EGSTRBER tinyint , EGSTRUEG float , EGSTRMITTE float , EGSTROEG float , EGSTRUWG float , EGSTROWG float , EGSTRPQFSK float , EGSTRNQFSK float , EGDAT datetime , EGMASCHINE int , EGNEST int , EGUGW float , EGOGW float , EGNENNMASS float , EGLAGUIG FLOAT , EGLAGOIG FLOAT , EGSTRUIG FLOAT , EGSTROIG FLOAT, EG_LEXL float, EG_UEXL float, EG_EXSTART datetime, EG_EXEND datetime, EG_EXVALID tinyint ) GO create unique index EGZ_TM on EG_AEND_ZD (EGTEIL, EGMERKMAL) GO