--delete from DB_VERSION;
--Insert INTO DB_VERSION(VERSION) VALUES('8.0');
-- ============================================================
-- Stand 2015-02-24 (TC)
-- ============================================================

create table LASTIDENT
(
	LITEIL		NUMBER(10,0),
	LIDENT		NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;

create unique index LASTIDENT on LASTIDENT(LITEIL);

create table NENNMASS
(
	NMARTIKEL	NUMBER(10,0),
	NMMERKMAL	NUMBER(10,0),
	NMARBEITSGANG	VARCHAR2(40),
	NMNENNMASS	FLOAT
)
TABLESPACE QDAS_DEFAULT;
drop index NENNMASS;
create unique index NENNMASS on NENNMASS(NMARTIKEL, NMMERKMAL, NMARBEITSGANG);

create table ERGEBNIS
(
    ETEIL                           NUMBER(10,0),
    EMERKMAL                        NUMBER(10,0),
    EMODUL                          NUMBER(5,0),
    EAUSGAPUNKT 		    VARCHAR2(20),
    EERGEBNIS	                    FLOAT,
    EERGEBNISSTR 		    VARCHAR2(30),
    ESTARTDAT                       DATE,
    EENDDAT                         DATE,
    EPRUEFER                        NUMBER(10,0),
    EPRUEFMIT                       NUMBER(10,0),
    EMASCHINE                       NUMBER(10,0),
    ENEST                           NUMBER(10,0),
    ECHARGE                         VARCHAR2(20),
    EAUFTRAG	 		    VARCHAR2(20),
    EANZWERTE			    NUMBER(10,0)	
)
  TABLESPACE qmerk_table
  PCTFREE 20
  PCTUSED 80
  --PARALLEL (DEGREE DEFAULT)
;

create index ERGEBNIS on ERGEBNIS (ETEIL, EMERKMAL, EMODUL)
  TABLESPACE qmerk_index
  --PARALLEL (DEGREE DEFAULT)
;

create index EAUFTRAG on ERGEBNIS (EAUFTRAG)
  TABLESPACE qmerk_index
  --PARALLEL (DEGREE DEFAULT)
;

create table BUILDPHASE
(
	BPKEY		NUMBER(10,0),
	BPNAME		VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;

create unique index BUILDPHASE on BUILDPHASE(BPKEY);

create table ERGEBZEITRAUM
(
    EZTEIL 			NUMBER(10,0),
    EZMODUL   			NUMBER(5,0),
    EZAUSGAPUNKT 		VARCHAR2(20),
    EZBAUPHASE	 		VARCHAR2(20),
    MINDAT  			DATE,
    MAXDAT 			DATE
)
TABLESPACE QDAS_DEFAULT;

create unique index ERGEBZEITRAUM on ERGEBZEITRAUM(EZTEIL,EZMODUL,EZAUSGAPUNKT,EZBAUPHASE);

create table PARTCONFIG
(
 PARTID                                   NUMBER(10,0),
 PARTCONFIG                               VARCHAR2(80)
)
TABLESPACE QDAS_DEFAULT;

create unique index PARTCONFIG on PARTCONFIG(PARTID);

create table MEASVALUES
(
MV_PARTID                                   NUMBER(10,0),
MV_INTERNALID                               NUMBER(10,0),
MV_MEASUREMENTID                            VARCHAR2(50),
MV_MEASVALUES                               LONG,
MV_ATTRIBUTE                                NUMBER(5,0),
MV_INSPECTOR                                NUMBER(5,0),
MV_MEASSYSTEM                               NUMBER(5,0),
MV_MACHINE                                  NUMBER(5,0),
MV_NEST                                     NUMBER(5,0),
MV_MEASSTARTDATETIME                        DATE,
MV_MEASENDDATETIME                          DATE,
MV_SAMPLEFLAG                               NUMBER(3,0),
MV_BATCHSTART                               VARCHAR2(20),
MV_BATCHEND                                 VARCHAR2(20),
MV_ORDER                                    VARCHAR2(20),
MV_MEASUREMENTCOUNT                         NUMBER(10,0),
WV0005                          			VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;

create unique index MEASVALUES on MEASVALUES(MV_PARTID,MV_INTERNALID);

create index MV_INTERNALID on MEASVALUES(MV_INTERNALID);
create index MV_MEASENDDATETIME on MEASVALUES(MV_MEASENDDATETIME);
create index MV_MEASSTARTDATETIME on MEASVALUES(MV_MEASSTARTDATETIME);
create index MV_MEASUREMENTID on MEASVALUES(MV_MEASUREMENTID);
create index MV_ATTRIBUTE on MEASVALUES(MV_ATTRIBUTE);
create index MV_INSPECTOR on MEASVALUES(MV_INSPECTOR);
create index MV_MEASSYSTEM on MEASVALUES(MV_MEASSYSTEM);
create index MV_MACHINE on MEASVALUES(MV_MACHINE);
create index MV_NEST on MEASVALUES(MV_NEST);


create table HIERATEIL
(
	HITEIL		NUMBER(10,0),
	HISUBKEY1	NUMBER(10,0),
	HISUBKEY2	NUMBER(10,0),
	HISTRUKTUR	LONG
)
TABLESPACE QDAS_DEFAULT;

create unique index HIERATEIL on HIERATEIL(HITEIL, HISUBKEY1, HISUBKEY2);


create table LAST_UPLOAD
(
	MEUPLOADKEY	NUMBER(10,0),
	METEIL		NUMBER(10,0),
	MEMERKMAL	NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;

alter table LAST_UPLOAD add
(
	FILENAME	VARCHAR2(255)
);


create unique index LAST_UPLOAD on LAST_UPLOAD(MEUPLOADKEY, METEIL, MEMERKMAL);
create index LAST_UPLOAD_TEIL on LAST_UPLOAD(METEIL);

alter table LAST_UPLOAD add
(
	MEWERT		NUMBER(10,0)
);


create table MERKMAL_REPORT
(
	METEIL		NUMBER(10,0),
	MEMERKMAL	NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;
ALTER TABLE MERKMAL_REPORT ADD 
(
	MEREPORT	VARCHAR2(255)
);	
ALTER TABLE MERKMAL_REPORT MODIFY
(
	MEREPORT	VARCHAR2(255)
);	

ALTER TABLE MERKMAL_REPORT ADD 
(
	MODUL		NUMBER(5,0)
);	
ALTER TABLE MERKMAL_REPORT ADD 
(
	EMAIL		VARCHAR2(255)
);
ALTER TABLE MERKMAL_REPORT ADD 
(
	PRINTER		VARCHAR2(255)
);
drop index MERKMAL_REPORT;

create index MERKMAL_REPORT_TEIL on MERKMAL_REPORT(METEIL);

alter table MERKMAL_REPORT add
(
	CONFNAME	VARCHAR2(50)
);
alter table MERKMAL_REPORT add
(
	GRUPPE		NUMBER(5,0)
);

alter table MERKMAL_REPORT add
(
	TEMPLATE	VARCHAR2(255)
);

alter table MERKMAL_REPORT add
(
	MEREPORTALARM	VARCHAR2(50)
);

alter table MERKMAL_REPORT add
(
	PDFPATH		VARCHAR2(255)
);

alter table MERKMAL_REPORT add
(
	WITHOUT_AL_TXT	VARCHAR2(255)
);

alter table MERKMAL_REPORT add
(
	ALTPDFDNERZ		VARCHAR2(255)
);

ALTER TABLE MERKMAL_REPORT MODIFY 
(
	GRUPPE                        	NUMBER(10, 0)
)
;

ALTER TABLE MERKMAL_REPORT ADD 
(
	PDF_URL		VARCHAR2(255)
);	


create table REPORTS
(
	REPORTNO	NUMBER(5,0),
	REPORTNAME	VARCHAR2(255),
	REPORTTYPE	NUMBER(5,0),
	MODUL		NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;
ALTER TABLE REPORTS ADD
(
	CONFNAME	VARCHAR2(50)
);

create table ALARM_FILES
(
	ALARM_ID	NUMBER(10,0),
	ENTRY_TYPE	NUMBER(10,0),
	ENTRY		LONG RAW,
	UPLOAD_DIR	VARCHAR2(255),
	REPORTNAME	VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index ALARM_FILES on ALARM_FILES(ALARM_ID, ENTRY_TYPE);

create table ALARMS
(
	ALARM_ID	NUMBER(10,0),
	ALARM_COUNT	NUMBER(10,0),
	ALARM_TYPE	NUMBER(10,0),
	ALARM_STATUS	NUMBER(10,0),
	ALARM_DATETIME	DATE,
	ALARM_EVENT	VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index ALARMS on ALARMS(ALARM_ID);

CREATE TABLE ALARM_VALUES
(
	ALARM_ID                      	NUMBER(10, 0) ,
	ALARM_VALUE_ID                	NUMBER(10, 0) ,
	ALARM_STATUS                  	NUMBER(10, 0) ,
	ALARM_DATETIME                	DATE ,
	CONFIRM_DATETIME              	DATE ,
	CLOSE_DATETIME                	DATE ,
	CONFIRM_USER                  	VARCHAR2(50) ,
	CLOSE_USER                    	VARCHAR2(50) ,
	ALARM_EW                      	NUMBER(10, 0) ,
	ALARM_QRK_L                   	NUMBER(10, 0) ,
	ALARM_QRK_S                   	NUMBER(10, 0) ,
	ALARM_CP                      	NUMBER(10, 0) ,
	ALARM_EVENT                   	VARCHAR2(255) ,
	K0006                         	VARCHAR2(20) ,
	K0007                         	NUMBER(10, 0) ,
	K0008                         	NUMBER(10, 0) ,
	K0010                         	NUMBER(10, 0) ,
	K0012                         	NUMBER(10, 0) ,
	K0053                         	VARCHAR2(20) ,
	K1000                         	NUMBER(10, 0) ,
	K2000                         	NUMBER(10, 0) ,
	K0000                         	NUMBER(10, 0) 
)
TABLESPACE QDAS_DEFAULT;
create unique index ALARM_ID on ALARM_VALUES(ALARM_ID,ALARM_VALUE_ID);

CREATE TABLE EMPB_3000 (
	K3000   NUMBER(10,0),
	K3001   VARCHAR2(20),
	K3002   VARCHAR2(30),
	K3003   VARCHAR2(20),
	K3004   VARCHAR2(20),
	K3005   VARCHAR2(20),
	K3006   VARCHAR2(20),
	K3010   NUMBER(10,0),
	K3011   VARCHAR2(20),
	K3020   NUMBER(5,0),
	K3021   NUMBER(5,0),
	K3022   NUMBER(5,0),
	K3023   VARCHAR2(40),
	K3025   VARCHAR2(20),
	K3030   VARCHAR2(120),
	K3031   VARCHAR2(40),
	K3035   VARCHAR2(50),
	K3036   VARCHAR2(50),
	K3037   NUMBER(5,0),
	K3040   NUMBER(5,0),
	K3050   VARCHAR2(30),
	K3052   VARCHAR2(50),
	K3055   VARCHAR2(30),
	K3056   VARCHAR2(20),
	K3057   DATE,
	K3058   VARCHAR2(20),
	K3070   VARCHAR2(30),
	K3071   VARCHAR2(30),
	K3077   DATE,
	K3078   DATE,
	K3080   VARCHAR2(30),
	K3087   DATE,
	K3100   VARCHAR2(30),
	K3101   VARCHAR2(20),
	K3102   VARCHAR2(20),
	K3103   VARCHAR2(20),
	K3105   VARCHAR2(20),
	K3106   VARCHAR2(20),
	K3107   VARCHAR2(20),
	K3108   NUMBER(5,0),
	K3109   NUMBER(5,0),
	K3110   VARCHAR2(20),
	K3112   VARCHAR2(30),
	K3113   VARCHAR2(30),
	K3115   NUMBER(5,0),
	K3117   VARCHAR2(20),
	K3118   VARCHAR2(20),
	K3119   DATE,
	K3150   NUMBER(10,0),
	K3160   VARCHAR2(30),
	K3167   DATE,
	--  K3180   
	K3187   VARCHAR2(20),
	K3188   VARCHAR2(20),
	--  K3190   
	K3200   VARCHAR2(30),
	K3210   VARCHAR2(30),
	K3301   VARCHAR2(20),
	K3302   VARCHAR2(30),
	K3303   VARCHAR2(20),
	K3304   VARCHAR2(20),
	K3306   VARCHAR2(20),
	K3310   NUMBER(10,0),
	K3350   VARCHAR2(30),
	K3352   VARCHAR2(50),
	K3355   VARCHAR2(30),
	K3356   VARCHAR2(30),
	K3357   DATE,
	K3358   VARCHAR2(20),
	K3372   VARCHAR2(30),
	K3379   DATE,
	K3380   VARCHAR2(20),
	K3387   DATE,
	K3390   VARCHAR2(30),
	K3404   VARCHAR2(30),
	K3410   VARCHAR2(20),
	K3420   NUMBER(5,0),
	K3421   NUMBER(5,0),
	K3422   NUMBER(5,0),
	K3423   NUMBER(5,0),
	K3424   NUMBER(5,0),
	K3425   NUMBER(5,0),
	K3433   NUMBER(5,0),
	K3438   NUMBER(5,0),
	K3439   VARCHAR2(20),
	K3440   VARCHAR2(20),
	K3442   NUMBER(5,0),
	K3445   VARCHAR2(50),
	K3447   DATE,
	K3450   VARCHAR2(50),
	K3451   VARCHAR2(20),
	K3460   VARCHAR2(20),
	K3467   DATE,
	K3470   NUMBER(10,0),
	--  K3481   
	--  K3490   
	K3560   VARCHAR2(30),
	K3561   VARCHAR2(30),
	K3562   VARCHAR2(30),
	K3563   VARCHAR2(30),
	K3564   VARCHAR2(30),
	K3565   VARCHAR2(30),
	K3566   VARCHAR2(30),
	K3569   VARCHAR2(30),
	K3600   NUMBER(5,0),
	K3601   VARCHAR2(30),
	K3602   VARCHAR2(60),
	K3610   VARCHAR2(50),
	K3617   DATE,
	K3701   NUMBER(5,0),
	K3702   NUMBER(5,0),
	K3703   NUMBER(5,0),
	K3704   NUMBER(5,0),
	K3705   NUMBER(5,0),
	K3706   NUMBER(5,0),
	K3707   NUMBER(5,0),
	K3708   NUMBER(5,0),
	K3709   NUMBER(5,0),
	K3710   NUMBER(5,0),
	K3711   NUMBER(5,0),
	K3712   NUMBER(5,0),
	K3713   NUMBER(5,0),
	K3714   NUMBER(5,0),
	K3750   NUMBER(5,0),
	K3752   NUMBER(5,0),
	K3754   NUMBER(5,0),
	K3756   NUMBER(5,0),
	K3757   VARCHAR2(20),
	K3758   VARCHAR2(20),
	K3760   NUMBER(5,0),
	K3761   VARCHAR2(50),
	K3763   NUMBER(5,0),
	K3764   VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;


create unique index EMPB_3000 on EMPB_3000(K3000);

ALTER TABLE EMPB_3000 MODIFY (
	K3010	NUMBER(10,0)
);
ALTER TABLE EMPB_3000 MODIFY(
	K3150	NUMBER(10,0)
);
ALTER TABLE EMPB_3000 MODIFY(
	K3310	NUMBER(10,0)
);
ALTER TABLE EMPB_3000 MODIFY(
	K3470	NUMBER(10,0)
);

Create table MEMO_FIELDS(
	MM_PART		NUMBER(10,0),
	MM_CHARACT	NUMBER(5,0),
	MM_MEASVALUE	NUMBER(10,0),
	MM_K_R_KEY	NUMBER(5,0),
	MM_K_FIELD	NUMBER(5,0),
	MM_CONTENTS	LONG
)
TABLESPACE QDAS_DEFAULT;
create unique index MEMO_FIELDS on MEMO_FIELDS(MM_PART, MM_CHARACT, MM_MEASVALUE, MM_K_R_KEY, MM_K_FIELD);


ALTER TABLE ERGEBNIS ADD(
	EZUSDATLIST	VARCHAR2(50)
);

ALTER TABLE PRUEFER ADD
(
	PRFAX				VARCHAR2(50),
	PREMAIL				VARCHAR2(50),
	PRPOS				VARCHAR2(30),
	PRANREDE			VARCHAR2(15)
);

create table MITARB
(
	MIMITARB			NUMBER(10,0),
	MINAME1				VARCHAR2(50),
	MINAME2				VARCHAR2(50),
	MIABT				VARCHAR2(50),
	MITELEFON			VARCHAR2(50),
	MIFAX				VARCHAR2(50),
	MIEMAIL				VARCHAR2(50),
	MIPOS				VARCHAR2(30),
	MIANREDE			VARCHAR2(15)
)
TABLESPACE QDAS_DEFAULT;

create unique index MITARB on MITARB (MIMITARB);

ALTER TABLE PARTCONFIG ADD
(
 PARTWINDOWLIST                        LONG
);

create table SIGNATUR
(
	SIGNATUR_ID				NUMBER(10,0),
	SIGNATUR_COUNTER		NUMBER(5,0),	
	SIGNATUR_MODUL			NUMBER(5,0),
	SIGNATUR_USER			VARCHAR2(50),
	SIGNATUR_USERDATE		DATE,
	SIGNATUR_COMMENT		VARCHAR2(255),
	SIGNATUR_REASON			NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;
create unique index SIGNATUR on SIGNATUR (SIGNATUR_ID,SIGNATUR_COUNTER);

create table SIGNATUR_FILES
(
	SIGNATUR_ID				NUMBER(10,0),
	SIGNATUR_COUNTER		NUMBER(5,0),	
	SIGNATUR_TYPE			NUMBER(10,0),
	SIGNATUR_ENTRY			LONG RAW,
	SIGNATUR_DESC			VARCHAR2(255),
	SIGNATUR_SIZE			VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;
create unique index SIGNATUR_FILES on SIGNATUR_FILES (SIGNATUR_ID,SIGNATUR_COUNTER,SIGNATUR_TYPE);

ALTER TABLE SIGNATUR_FILES MODIFY 
(
	SIGNATUR_COUNTER              	NUMBER(10, 0)
)
;

create table SIGNATUR_MASTER
(
	SIGNATUR_ID				NUMBER(10,0),
	SIGNATUR_MODUL			NUMBER(5,0),
	SIGNATUR_MASTERKEY		VARCHAR2(255),	
	SIGNATUR_DATE			DATE,
	SIGNATUR_EVALSTRAT		NUMBER(10,0),
	SIGNATUR_EVALNAME		VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;
create unique index SIGNATUR_MASTER on SIGNATUR_MASTER (SIGNATUR_ID);

ALTER TABLE SIGNATUR_MASTER ADD
(
	SIGNATUR_COMMENT1		VARCHAR2(255),	
	SIGNATUR_COMMENT2		VARCHAR2(255),	
	SIGNATUR_COMMENT3		VARCHAR2(255)
);		
delete from SIGNATUR_REASON where SIGNATUR_REASON <= 6;
create table SIGNATUR_REASON
(
	SIGNATUR_REASON			NUMBER(5,0),
	SIGNATUR_MODUL			NUMBER(5,0),
	SIGNATUR_REASON_DESC	VARCHAR2(50),	
	SIGNATUR_MUSTFILL		NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;
drop index SIGNATUR_REASON;

create unique index SIGNATUR_REASON on SIGNATUR_REASON (SIGNATUR_REASON,SIGNATUR_MODUL);

Insert INTO SIGNATUR_REASON VALUES(1,1,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,1,'Approval',2);
Insert INTO SIGNATUR_REASON VALUES(1,10,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,10,'Approval',2);
Insert INTO SIGNATUR_REASON VALUES(1,20,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,20,'Approval',2);
Insert INTO SIGNATUR_REASON VALUES(1,26,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,26,'Approval',2);
Insert INTO SIGNATUR_REASON VALUES(1,30,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,30,'Approval',2);
Insert INTO SIGNATUR_REASON VALUES(1,60,'Review',1);
Insert INTO SIGNATUR_REASON VALUES(2,60,'Approval',2);


ALTER TABLE LAST_UPLOAD ADD
(
	K0006		VARCHAR2(20),
	K0007		NUMBER(10,0),
	K0008		NUMBER(10,0),
	K0010		NUMBER(10,0),
	K0012		NUMBER(10,0),
	K0053		VARCHAR2(20)
);

ALTER TABLE LAST_UPLOAD ADD
(
	STATION_NO           VARCHAR2(50)
);
create index LAST_UPLOAD_STATION_NO on LAST_UPLOAD(STATION_NO);


ALTER TABLE EMPB_3000 MODIFY (K3355 VARCHAR2(30));
ALTER TABLE EMPB_3000 MODIFY (K3356 VARCHAR2(30));

CREATE TABLE ARCHIVES(
	ARARCHIVENO		NUMBER(10,0),
	ARSTARTDATE		DATE,
	ARENDDATE		DATE,
	ARDATABASE		VARCHAR2(150),
	ARDBTYPE		NUMBER(10,0),
	ARTABLESUFFIX		VARCHAR2(20),
	ARACTIVATED		NUMBER(3,0),
	ARARCHIVATED		NUMBER(3,0),
	ARVALUESDELETED		NUMBER(3,0)
)
TABLESPACE QDAS_DEFAULT;
CREATE UNIQUE INDEX ARCHIVES ON ARCHIVES(ARARCHIVENO);


CREATE TABLE ARCHIVEACTIONS(
	AAARCHIVENO		NUMBER(10,0),
	AAACTIONNO		NUMBER(10,0),
	AADATE			DATE,
	AAUSER			VARCHAR2(50),
	AAACTION		NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;
CREATE UNIQUE INDEX ARCHIVEACTIONS ON ARCHIVEACTIONS(AAARCHIVENO, AAACTIONNO);


-- Einer der beiden folgenden Befehle muß schiefgehen, je nachdem, ob RESULTS schon da ist oder nicht.
ALTER TABLE RESULTS ADD
(
	RID			NUMBER(10,0),
	RAUSWSTATUS		NUMBER(10,0),
	RCWERTEART		NUMBER(10,0),
	RCWERTEQUALITAET	NUMBER(10,0),
	RMFA			VARCHAR2(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
);
ALTER TABLE RESULTS ADD
(
	R5240_0			FLOAT,
	R5240_0_T		FLOAT,
	R5240_10		FLOAT,
	R5240_10_T		FLOAT
);
CREATE TABLE RESULTS(
	RPART			NUMBER(10,0),
	RCHARACTERISTIC		NUMBER(10,0),
	RMODULE			NUMBER(10,0),
	RFIRSTDATE		DATE,
	RLASTDATE		DATE,
	ROPERATOR		NUMBER(10,0),
	RGAGE			NUMBER(10,0),
	RMACHINE		NUMBER(10,0),
	RNEST			NUMBER(10,0),
	RBATCHNO		VARCHAR2(20),
	RORDERNO		VARCHAR2(20),
	RSEPERFIELDS		VARCHAR2(50),
	RSTRATEGY		NUMBER(10,0),
	RID			NUMBER(10,0),
	RAUSWSTATUS		NUMBER(10,0),
	RCWERTEART		NUMBER(10,0),
	RCWERTEQUALITAET	NUMBER(10,0),
	RMFA			VARCHAR2(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
)
TABLESPACE QDAS_DEFAULT;
CREATE INDEX RESULTS ON RESULTS(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY);

ALTER TABLE RESULTS ADD
(
	REVENTS			VARCHAR2(100)
);
ALTER TABLE RESULTS ADD
(
	R5500_0		FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5500_0_T	FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5510_0		FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5510_0_T	FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5520_0		FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5520_0_T	FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5530_0		FLOAT
);

ALTER TABLE RESULTS ADD
(
	R5530_0_T	FLOAT
);

CREATE TABLE RESULTS_FILES(
	RPART			NUMBER(10,0),
	RCHARACTERISTIC		NUMBER(10,0),
	RMODULE			NUMBER(10,0),
	RFIRSTDATE		DATE,
	RLASTDATE		DATE,
	ROPERATOR		NUMBER(10,0),
	RGAGE			NUMBER(10,0),
	RMACHINE		NUMBER(10,0),
	RNEST			NUMBER(10,0),
	RBATCHNO		VARCHAR2(20),
	RORDERNO		VARCHAR2(20),
	RSEPERFIELDS		VARCHAR2(50),
	RSTRATEGY		NUMBER(10,0),
	RID			NUMBER(10,0),
	RREPORT_NUM		NUMBER(5,0),
	RENTRY_TYPE		NUMBER(10,0),
	RENTRY			LONG RAW,
	REPORTNAME		VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
CREATE INDEX RESULTS_FILES ON RESULTS_FILES(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY);

ALTER TABLE EMPB_3000 ADD
(
	K3650   NUMBER(5,0)
);

create table TRANSMIT_HEADER
(
 STATIONGUID                                        RAW(16),
 TEILGUID                                           RAW(16),
 MERKMALGUID                                        RAW(16),
 KFELD                                              NUMBER(5),
 INHALT                                             LONG,
 AENDDAT                                            DATE,
 AENDUSER                                           VARCHAR2(50),
 STATUS                                             NUMBER(10)
)
TABLESPACE QWERT_TABLE
;
CREATE INDEX TH_AENDDAT ON TRANSMIT_HEADER(AENDDAT);
CREATE INDEX TH_MERKMAL ON TRANSMIT_HEADER(MERKMALGUID);
CREATE INDEX TH_TEIL ON TRANSMIT_HEADER(TEILGUID);

create table TRANSMIT_WERTEVAR
(
 WVTEILGUID                                         RAW(16),
 WVMERKMALGUID                                      RAW(16),
 WVUNTERS                                           NUMBER(5),
 WVWERTNR                                           NUMBER(10),
 WVWERT                                             FLOAT(126),
 WVATTRIBUT                                         NUMBER(5),
 WVPRUEFER                                          NUMBER(5),
 WVPRUEFMIT                                         NUMBER(5),
 WVMASCHINE                                         NUMBER(5),
 WVNEST                                             NUMBER(5),
 WVDATZEIT                                          DATE,
 WVSTIANF                                           NUMBER(3),
 WVCHARGE                                           VARCHAR2(20),
 WVAUFTRAG                                          VARCHAR2(20),
 WVSTATUS                                           NUMBER(10),
 WVAENDDAT                                          DATE,
 WVAENDUSER                                         VARCHAR2(20)
)
TABLESPACE QWERT_TABLE
;
CREATE INDEX TW_WVATTRIBUT ON TRANSMIT_WERTEVAR(WVATTRIBUT);
CREATE INDEX TW_WVTEILGUID ON TRANSMIT_WERTEVAR(WVTEILGUID);
CREATE INDEX TW_WVMERKMALGUID ON TRANSMIT_WERTEVAR(WVMERKMALGUID);
CREATE INDEX TW_WVDATZEIT ON TRANSMIT_WERTEVAR(WVDATZEIT);
CREATE INDEX TW_WVMASCHINE ON TRANSMIT_WERTEVAR(WVMASCHINE);
CREATE INDEX TW_WVNEST ON TRANSMIT_WERTEVAR(WVNEST);
CREATE INDEX TW_WVPRUEFER ON TRANSMIT_WERTEVAR(WVPRUEFER);
CREATE INDEX TW_WVPRUEFMIT ON TRANSMIT_WERTEVAR(WVPRUEFMIT);

create table STATION
(
 STATION_KEY                                        RAW(16),
 STATION_NO                                         VARCHAR2(50),
 STATION_DESC                                       VARCHAR2(50),
 STATION_IP                                         VARCHAR2(50),
 LASTSUCCESSFULL_SYNCH_END                          DATE,
 STATION_SYNCH_DATE_SERVER                          DATE,
 SYNCHRONIZE_START                                  DATE,
 SYNCHRONIZE_END                                    DATE,
 SYNCHRONIZE_INTERVAL                               DATE,
 SYNCHRONIZE_OFFSET                                 DATE,
 LAST_SYNCH_START                                   DATE,
 NEXT_SYNCH_EVENT                                   DATE,
 DB_COMPRESS_INTERVAL                               DATE,
 LAST_DB_COMPRESSION                                DATE,
 MAX_VALUES                                         NUMBER(10),
 MAX_LOGFILES_SIZE                                  NUMBER(10),
 WITHOUT_REQUEST				    NUMBER(3,0),	
 INFO				VARCHAR2(255)	
)
TABLESPACE QDAS_DEFAULT;
ALTER table STATION ADD
(
  WITHOUT_REQUEST				    NUMBER(3,0)	
);

ALTER table STATION ADD
(
   INFO				VARCHAR2(255)	
);
CREATE UNIQUE INDEX STATION ON STATION(STATION_KEY);

ALTER table STATION ADD
(
    STATION_PATH				VARCHAR2(255)
);

create table STATIONS_PART
(
 STATION                                        RAW(16),
 PART                                              NUMBER(10),
 LASTERROR                                  VARCHAR2(255),
 CHANGEDATETIME                        DATE,
 TODELETE		        NUMBER(3,0)
)
TABLESPACE QDAS_DEFAULT;
CREATE UNIQUE INDEX STATIONS_PART ON STATIONS_PART(STATION,PART);


-- Korrektur der Felder K2048 und K2049
update merkmal set 
		mefehlart = floor(meanfindex / 256), 
		meanfindex = mod(meanfindex, 256) 
	where (meanfindex > 255) and ((mefehlart is NULL) or (mefehlart = 0));

-- Stored Procedures zum Abspeichern in WERTEVAR

CREATE OR REPLACE PROCEDURE WVINSERT( 	
				PARA1 IN NUMBER,
			   	PARA2 IN NUMBER,
				PARA3 IN NUMBER,
				PARA4 IN NUMBER,
				PARA5 IN FLOAT,
			   	PARA6 IN NUMBER,
				PARA7 IN NUMBER,
				PARA8 IN NUMBER,
			   	PARA9 IN NUMBER,
				PARA10 IN NUMBER,
				PARA11 IN DATE,
			   	PARA12 IN NUMBER,
				PARA13 IN VARCHAR,
				PARA14 IN VARCHAR
) 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;
/



create table MERKMAL_ZUS
(
    METEIL                          NUMBER(10,0)                          ,
    MEMERKMAL                       NUMBER(5,0)							  ,
	ME_2601							NUMBER(3,0)						   	  ,
	ME_2605							VARCHAR2(255)					   	  ,
	ME_2610							NUMBER(10,0)					   	  ,
	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							NUMBER(10,0)					   	  ,
	ME_2645							NUMBER(10,0)					   	  ,
	ME_2646							NUMBER(10,0)					   	  ,
	ME_2647							NUMBER(10,0)					   	  ,
	ME_2648							VARCHAR2(255)					   	  ,
	ME_2700							NUMBER(3,0)						   	  ,
	ME_2711							FLOAT							   	  ,
	ME_2712							FLOAT							   	  ,
	ME_2713							FLOAT							   	  ,
	ME_2714							FLOAT							   	  ,
	ME_2174							NUMBER(10,0)					   	  ,
	ME_2505							VARCHAR2(20)					   	  ,
	ME_2506							NUMBER(10,0)					   	  ,
	ME_2507							VARCHAR2(2)					   	      ,
	ME_2508							NUMBER(10,0)					   	  ,
	ME_2509							VARCHAR2(40)					   	  ,
	ME_2511							VARCHAR2(20)					   	  ,
	ME_2512							VARCHAR2(20)					   	  ,
	ME_2513							VARCHAR2(20)					   	  ,
	ME_2514							VARCHAR2(20)					   	  ,
	ME_2515							VARCHAR2(20)					   	  ,
	ME_2516							VARCHAR2(20)					   	  ,
	ME_2517							VARCHAR2(20)					   	  ,
	ME_2518							VARCHAR2(20)					   	  ,
	ME_2519							VARCHAR2(20)					   	  ,
	ME_2520							VARCHAR2(20)					   	  ,
	ME_2521							FLOAT							   	  ,
	ME_2522							FLOAT							   	  ,
	ME_2523							FLOAT							   	  ,
	ME_2524							VARCHAR2(20)					   	  ,
	ME_2175							NUMBER(3,0)						   	  ,
	ME_2176							NUMBER(3,0)						   	  ,
	ME_2177							FLOAT						   		  ,
	ME_2178							FLOAT						   		  ,
	ME_2180							FLOAT						   		  ,
	ME_2181							FLOAT						   		  ,
	ME_2182							FLOAT						   		  ,
	ME_2183							FLOAT						   		  ,
	ME_2185							NUMBER(10,0)					   	  ,
	ME_2186							FLOAT						   		  ,
	ME_2720							NUMBER(3,0)					   		  ,
	ME_2723							NUMBER(3,0)					   		  ,
	ME_2724							FLOAT					   			  ,
	ME_2725							FLOAT					   			  ,
	ME_2733							NUMBER(3,0)					   		  ,
	ME_2734							FLOAT					   			  ,
	ME_2735							FLOAT					   			  ,
	ME_2736							FLOAT					   			  ,
	ME_2737							FLOAT					   			  ,
	ME_2738							FLOAT					   			  ,
	ME_2740							FLOAT					   			  ,
	ME_2741							NUMBER(10,0)						  ,
	ME_2743							NUMBER(3,0)					   		  ,
	ME_2744							FLOAT					   			  ,
	ME_2745							FLOAT					   			  ,
	ME_2746							FLOAT					   			  ,
	ME_2525							VARCHAR2(255)					   	  ,
	ME_2526							VARCHAR2(255)					   	  ,
	MEANZMESSV						NUMBER(10,0),
	MEANZSTAB						NUMBER(10,0),
	ME_2190			    VARCHAR2(10)
)
  TABLESPACE qmerk_table
  PCTFREE 20
  PCTUSED 80
  --PARALLEL (DEGREE DEFAULT)
;

create unique index MERKMAL_ZUS on MERKMAL_ZUS (METEIL, MEMERKMAL)
TABLESPACE qmerk_index;


ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2720							NUMBER(3,0)
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2723							NUMBER(3,0)
);						   		
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2724							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2725							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2733							NUMBER(3,0)
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2734							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2735							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2736							FLOAT
);						
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2737							FLOAT					   			
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2738							FLOAT					   			  
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2740							FLOAT					   			  
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2741							NUMBER(10,0)
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2743							NUMBER(3,0)
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2744							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2745							FLOAT
);	
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2746							FLOAT
);						

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2525							VARCHAR2(255)
);						
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2526							VARCHAR2(255)
);						
ALTER TABLE MERKMAL_ZUS ADD
(
	MEANZMESSV						NUMBER(10,0)
);						
ALTER TABLE MERKMAL_ZUS ADD
(
	MEANZSTAB						NUMBER(10,0)
);						
ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2190			    VARCHAR2(10)
);						

drop index METEIL;
drop index MEMERKMAL;

CREATE TABLE ORDKLASS
(
	OKKEY		NUMBER(10,0),
	OKNR		VARCHAR2(40),
	OKBEZ		VARCHAR2(100),
	OKKURZBEZ	VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX ORDKLASS ON ORDKLASS(OKKEY);

CREATE TABLE ORDKLASSKAT
(
	OKKKEY		NUMBER(10,0),
	OKKBEZ		VARCHAR2(100)
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX ORDKLASSKAT ON ORDKLASSKAT(OKKKEY);

CREATE TABLE ZU_OK_OKK
(
	OKKEY		NUMBER(10,0),
	OKKKEY		NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX ZU_OK_OKK ON ZU_OK_OKK(OKKEY, OKKKEY);

CREATE TABLE FORMS
(
	FO_GUID		RAW(16),
	FO_PARTGUID	RAW(16),
	FO_CHARGUID	RAW(16),
	FO_USAGE	NUMBER(3,0),
	FO_MODULES	VARCHAR2(50),
	FO_GC_TYPES	VARCHAR2(50),
	FO_INTKEY1	NUMBER(10,0),
	FO_INTKEY2	NUMBER(10,0),
	FO_STRINGKEY1	VARCHAR2(50),
	FO_STRINGKEY2	VARCHAR2(50),
	FO_NAME		VARCHAR2(50),
	FO_CONTENTS	LONG,
	FO_ALLPARTGUIDS               	VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX FORMS ON FORMS(FO_GUID);

ALTER TABLE FORMS ADD 
(
	FO_ALLPARTGUIDS               	VARCHAR2(50)
)
;

CREATE TABLE FORMS_PARTS
(
	FO_GUID		RAW(16),
	FO_ALL_PART_GUIDS LONG
)
TABLESPACE QDAS_DEFAULT;
CREATE UNIQUE INDEX FORMS_PARTS ON FORMS_PARTS(FO_GUID);

CREATE TABLE PSTEPS
(
	PV_VORGANGGUID	RAW(16),
	PV_STEP		NUMBER(10,0),
	PV_STEPNAME	VARCHAR2(50),
	PV_START	DATE,
	PV_END		DATE,
	PV_USER		NUMBER(5,0),
	PV_COMMENT	LONG
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX PSTEPS ON PSTEPS(PV_VORGANGGUID,PV_STEP);

CREATE TABLE PVERSUCH
(
	PVPLAN		NUMBER(10,0),
	PVAUFTRAG	NUMBER(10,0),
	PVVORGANG	NUMBER(5,0),
	PVVERSUCH	NUMBER(5,0),
	PVVERSUCHNR	VARCHAR2(40),
	PVBEZEICH	VARCHAR2(80),
	PVBEMERK	LONG,
	PVDATZEIT	DATE,
	PVANMDAT	DATE,
	PVANMBEN	NUMBER(5,0),
	PVAENDDAT	DATE,
	PVAENDBEN	NUMBER(5,0),
	PVBEGINN	DATE,
	PVENDE		DATE,
	PV_VORGANGGUID	RAW(16),
	PV_0031		RAW(16),
	PV_STATUS	NUMBER(5,0),
	PV_SIGNATUR_ID	NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX PVERSUCH ON PVERSUCH(PVPLAN,PVAUFTRAG,PVVORGANG,PVVERSUCH);
CREATE  INDEX PVERSUCH_VORG  ON PVERSUCH(PV_VORGANGGUID);
CREATE  INDEX PVERSUCH_SIGID ON PVERSUCH(PV_SIGNATUR_ID);

CREATE TABLE REDUCED_FIELDS
(
	FIELDLISTID		NUMBER(10,0),
	FIELDLISTNAME   VARCHAR2(50),
	FIELDREDUCED    NUMBER(5,0),
	FIELDMERKMAL_ZUS NUMBER(5,0),
	FIELDLIST        LONG
)
TABLESPACE QDAS_DEFAULT;

CREATE UNIQUE INDEX REDUCED_FIELDS ON REDUCED_FIELDS(FIELDLISTID);

ALTER TABLE PAUFTRAG ADD
(
	PAGUID   RAW(16)
);

ALTER TABLE PPLAN ADD
(
	PPGUID   RAW(16)
);

ALTER TABLE PVORGANG ADD
(
    PV_PAGUID			    RAW(16), 	
    PV_GUID			    RAW(16), 	
    PV_MODUL                        NUMBER(5,0)                         ,
    PV_SUBTYPE                      NUMBER(5,0)                         ,
    PV_STATUS                       NUMBER(5,0)                         ,
    PV_BUTTONLEISTE                 VARCHAR2(255)                         
);

ALTER TABLE TEIL ADD
(
	TE_1344		VARCHAR2(40)
);
ALTER TABLE TEIL ADD
(
	TE_1015		NUMBER(5,0)
);
ALTER TABLE TEIL ADD
(
	TE_1017		NUMBER(3,0)
);
ALTER TABLE TEIL ADD
(
	TE_1087		VARCHAR2(40)
);

ALTER TABLE TEIL ADD
(
	TE_1018		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1401		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1402		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1403		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1404		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1405		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1407		NUMBER(10,0)
);
ALTER TABLE TEIL ADD
(
	TE_1408		NUMBER(10,0)
);

ALTER TABLE TEIL ADD
(
	TE_1410		VARCHAR2(255)
);
ALTER TABLE TEIL ADD
(
	TE_1411		NUMBER(10,0)
);
ALTER TABLE TEIL MODIFY 
(
	TE_1344                       	VARCHAR2(50)
)
;

ALTER TABLE TEIL ADD
(
	TE_1091		VARCHAR2(20),
	TE_1092		VARCHAR2(40),
	TE_1105		VARCHAR2(20),
	TE_1106		VARCHAR2(20),
	TE_1107		VARCHAR2(20),
	TE_1108		VARCHAR2(20),
	TE_1304		VARCHAR2(20)
);

ALTER TABLE TEIL ADD
(
	TE_1048		VARCHAR2(80)
);

ALTER TABLE MERKMAL ADD
(
	ME_2016		NUMBER(3,0)
);

ALTER TABLE MERKMAL_MASTER ADD
(
	MEMASTERGUID	RAW(16)
);

--ALTER TABLE WERTEVAR ADD
--(
--    WV0031			    RAW(16)	
--);

-- ab VDA2, 4. Aufl.
ALTER TABLE EMPB_3000 ADD
(
	K3015	NUMBER(3,0),
	K3016	NUMBER(3,0),
	K3017	VARCHAR2(20),
	K3019	NUMBER(3,0),
	K3426	NUMBER(5,0),
	K3427	NUMBER(10,0),
	K3428	NUMBER(5,0),
	K3429	NUMBER(5,0),
	K3430	NUMBER(5,0),
	K3431	NUMBER(5,0),
	K3432	NUMBER(5,0),
	K3434	NUMBER(5,0),
	K3435	NUMBER(5,0),
	K3437	NUMBER(5,0),
	K3446	DATE,
	K3448	VARCHAR2(20),
	K3449	DATE,
	K3840	NUMBER(5,0),
	K3841	NUMBER(5,0),
	K3843	NUMBER(5,0),
	K3844	NUMBER(5,0),
	K3845	NUMBER(5,0),
	K3846	NUMBER(5,0),
	K3847	NUMBER(5,0),
	K3901	VARCHAR2(20),
	K3902	VARCHAR2(20),
	K3903	VARCHAR2(20),
	K3904	VARCHAR2(20),
	K3905	VARCHAR2(20),
	K3906	VARCHAR2(20),
	K3907	VARCHAR2(20),
	K3908	VARCHAR2(20),
	K3909	VARCHAR2(20),
	K3910	VARCHAR2(20),
	K3911	VARCHAR2(20),
	K3912	VARCHAR2(20),
	K3913	VARCHAR2(20),
	K3914	VARCHAR2(20),
	K3915	VARCHAR2(20),
	K3916	VARCHAR2(20),
	K3917	VARCHAR2(20),
	K3920	VARCHAR2(20),
	K3921	VARCHAR2(20),
	K3923	VARCHAR2(20),
	K3924	VARCHAR2(20),
	K3925	VARCHAR2(20),
	K3926	VARCHAR2(20),
	K3927	VARCHAR2(20),
	K3931	VARCHAR2(50),
	K3932	VARCHAR2(50),
	K3933	VARCHAR2(50),
	K3934	VARCHAR2(50),
	K3935	VARCHAR2(50),
	K3936	VARCHAR2(50),
	K3937	VARCHAR2(50),
	K3938	VARCHAR2(50),
	K3939	VARCHAR2(50),
	K3940	VARCHAR2(50),
	K3941	VARCHAR2(50),
	K3942	VARCHAR2(50),
	K3943	VARCHAR2(50),
	K3944	VARCHAR2(50),
	K3945	VARCHAR2(50),
	K3946	VARCHAR2(50),
	K3947	VARCHAR2(50),
	K3950	VARCHAR2(50),
	K3951	VARCHAR2(50),
	K3953	VARCHAR2(50),
	K3954	VARCHAR2(50),
	K3955	VARCHAR2(50),
	K3956	VARCHAR2(50),
	K3957	VARCHAR2(50),
	K3961	NUMBER(5,0),
	K3962	NUMBER(5,0),
	K3963	NUMBER(5,0),
	K3964	NUMBER(5,0),
	K3965	NUMBER(5,0),
	K3966	NUMBER(5,0),
	K3967	NUMBER(5,0),
	K3968	NUMBER(5,0),
	K3969	NUMBER(5,0),
	K3970	NUMBER(5,0),
	K3971	NUMBER(5,0),
	K3972	NUMBER(5,0),
	K3973	NUMBER(5,0),
	K3974	NUMBER(5,0),
	K3975	NUMBER(5,0),
	K3976	NUMBER(5,0),
	K3977	NUMBER(5,0),
	K3980	NUMBER(5,0),
	K3981	NUMBER(5,0),
	K3983	NUMBER(5,0),
	K3984	NUMBER(5,0),
	K3985	NUMBER(5,0),
	K3986	NUMBER(5,0),
	K3987	NUMBER(5,0)
);

DROP INDEX WVTEIL;

DROP INDEX WVMERKMAL;

ALTER TABLE TEIL MODIFY
(
	TEMASCHINENR		VARCHAR2(24)
);

ALTER TABLE TEIL MODIFY
(
	TEPREINRNR		VARCHAR2(24)
);

ALTER TABLE MERKMAL MODIFY
(
	MEMASCHNR		VARCHAR2(24)
);

-- ab PPAP 4. Aufl.
ALTER TABLE EMPB_3000 ADD
(
	K3186	VARCHAR2(20),
	K3192	NUMBER(3,0),
	K3250	VARCHAR2(50),
	K3251	VARCHAR2(30),
	K3770	NUMBER(3,0),
	K3771	VARCHAR2(80)
);

ALTER TABLE EMPB_3000 ADD 
(
	K3371                         	VARCHAR2(30)
)
;

ALTER TABLE EMPB_3000 ADD 
(
	K3377                         	DATE
)
;

ALTER TABLE EMPB_3000 MODIFY 
(
	K3427                         	NUMBER(10, 0)
)
;

CREATE SEQUENCE LAST_UPLOAD_KEYS MINVALUE 1 MAXVALUE 2000000000 CYCLE NOCACHE ORDER;


create table SERIAL_NUMBERS
(
    SERIAL_ID                       NUMBER(10,0),
    SERIAL_NO                       VARCHAR2(50),
    CUST_SERIAL_NO                  VARCHAR2(50),
    CUSTOMER_ID                     NUMBER(10,0),
    PRODUCTION_DATE                 DATE
)
  TABLESPACE qwert_table
  PCTFREE 20
  PCTUSED 80
  --PARALLEL (DEGREE DEFAULT)
;

create unique index SERIAL_NUMBERS_ID on SERIAL_NUMBERS (SERIAL_ID)
  TABLESPACE qwert_index
  --PARALLEL (DEGREE DEFAULT)
;

create index SERIAL_NUMBERS_NO on SERIAL_NUMBERS (SERIAL_NO)
  TABLESPACE qwert_index
  --PARALLEL (DEGREE DEFAULT)
;

create index SERIAL_NUMBERS_CUNO on SERIAL_NUMBERS (CUST_SERIAL_NO)
  TABLESPACE qwert_index
  --PARALLEL (DEGREE DEFAULT)
;

create index SERIAL_NUMBERS_DATE on SERIAL_NUMBERS (PRODUCTION_DATE)
  TABLESPACE qwert_index
  --PARALLEL (DEGREE DEFAULT)
;

alter table SERIAL_NUMBERS add
(
    ORDER_NO                        VARCHAR2(50),
    PALLET_NO                       VARCHAR2(50),
    BATCH_NO                        VARCHAR2(50)
);

alter table SERIAL_NUMBERS add
(
	CUST_DESCR			VARCHAR2(40),
	PROJECT_NO			VARCHAR2(20),
	ADDITIONAL_DATE			DATE,
	K0005				VARCHAR2(40),
	K0007				NUMBER(10,0),
	K0008				NUMBER(10,0),
	K0009				VARCHAR2(100),
	K0010				NUMBER(10,0),
	K0011				VARCHAR2(40),
	K0012				NUMBER(10,0),
	K0014				VARCHAR2(32),
	K0015				NUMBER(10,0),
	K0016				VARCHAR2(32),
	K0017				VARCHAR2(32),
	K0054				VARCHAR2(32),
	K0055				VARCHAR2(32),
	K0056				VARCHAR2(32),
	K0057				VARCHAR2(32),
	K0058				VARCHAR2(32),
	K0059				VARCHAR2(32),
	K0060				VARCHAR2(32),
	K0061				NUMBER(10,0),
	K0062				NUMBER(10,0),
	K0063				NUMBER(10,0)
);

create table SERIAL_KEYS
(
    SERIAL_ID                       NUMBER(10,0),
    STATION                         NUMBER(10,0),
    SERIAL_NO                       VARCHAR2(50),
    SERIAL_DATE                     DATE
)
  TABLESPACE qwert_table
  PCTFREE 20
  PCTUSED 80
  --PARALLEL (DEGREE DEFAULT)
;

create unique index SERIAL_KEYS on SERIAL_KEYS (SERIAL_ID, STATION)
  TABLESPACE qwert_index
  --PARALLEL (DEGREE DEFAULT)
;

alter table SERIAL_KEYS add
(
    READING_QLTY_ALL                VARCHAR2(20),
    READING_QLTY_1                  VARCHAR2(20),
    READING_QLTY_2                  VARCHAR2(20),
    READING_QLTY_3                  VARCHAR2(20),
    READING_QLTY_4                  VARCHAR2(20)
);

alter table SERIAL_KEYS add
(
    ORDER_NO                        VARCHAR2(50),
    PALLET_NO                       VARCHAR2(50),
    GREENBODY_NO                    VARCHAR2(50),
    DRAWING_NO                      VARCHAR2(50),
    DRAWIND_IDX                     VARCHAR2(30),
    MATERIAL_NO                     VARCHAR2(50),
    PLANT                           VARCHAR2(50)
);

alter table SERIAL_KEYS add
(
    MATERIAL_TEXT		VARCHAR2(80),
    DIMENSION		VARCHAR2(20),
    INSPECTIONLOT		VARCHAR2(20)
);

alter table SERIAL_KEYS add
(
	ADDITIONAL_DATE			DATE,
	K0005				VARCHAR2(40),
	K0007				NUMBER(10,0),
	K0008				NUMBER(10,0),
	K0009				VARCHAR2(100),
	K0010				NUMBER(10,0),
	K0011				VARCHAR2(40),
	K0012				NUMBER(10,0),
	K0014				VARCHAR2(32),
	K0015				NUMBER(10,0),
	K0016				VARCHAR2(32),
	K0017				VARCHAR2(32),
	K0054				VARCHAR2(32),
	K0055				VARCHAR2(32),
	K0056				VARCHAR2(32),
	K0057				VARCHAR2(32),
	K0058				VARCHAR2(32),
	K0059				VARCHAR2(32),
	K0060				VARCHAR2(32),
	K0061				NUMBER(10,0),
	K0062				NUMBER(10,0),
	K0063				NUMBER(10,0)
);

alter table SERIAL_KEYS add
(
	BATCH_NO                        VARCHAR2(50)
);

create table EQUIPMENT
(
    EQ_KEY                          NUMBER(10,0),
    EQ_NUMBER                       VARCHAR2(30),
    EQ_DESC                         VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;

create unique index EQUIPMENT on EQUIPMENT(EQ_KEY);

create table SERIAL_EQUIPMENT
(
    SERIAL_ID                       NUMBER(10,0),
    STATION                         NUMBER(10,0),
    EQUIPMENT_KEY                   NUMBER(10,0),
    EQUIPMENT_BATCHNO               VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;

create unique index SERIAL_EQUIPMENT on SERIAL_EQUIPMENT(SERIAL_ID, STATION, EQUIPMENT_KEY);
create index SERIAL_ID on SERIAL_EQUIPMENT(SERIAL_ID);

create table KUNDEKAT
(
	KUKNR			NUMBER(10,0),
	KUKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index KUNDEKAT on KUNDEKAT(KUKNR);

create table ZU_KU_KUK
(
	KUKEY			NUMBER(10,0),
	KUKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_KU_KUK on ZU_KU_KUK(KUKEY, KUKNR);

create table HERSTELLKAT
(
	HEKNR			NUMBER(10,0),
	HEKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index HERSTELLKAT on HERSTELLKAT(HEKNR);

create table ZU_HE_HEK
(
	HEKEY			NUMBER(10,0),
	HEKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_HE_HEK on ZU_HE_HEK(HEKEY, HEKNR);

create table LIEFKAT
(
	LIKNR			NUMBER(10,0),
	LIKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index LIEFKAT on LIEFKAT(LIKNR);

create table ZU_LI_LIK
(
	LIKEY			NUMBER(10,0),
	LIKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_LI_LIK on ZU_LI_LIK(LIKEY, LIKNR);

create table PAUFTKAT
(
	PAKNR			NUMBER(10,0),
	PAKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index PAUFTKAT on PAUFTKAT(PAKNR);

create table ZU_PA_PAK
(
	PAKEY			NUMBER(10,0),
	PAKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_PA_PAK on ZU_PA_PAK(PAKEY, PAKNR);

create table WERKSTOFFKAT
(
	WSKNR			NUMBER(10,0),
	WSKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index WERKSTOFFKAT on WERKSTOFFKAT(WSKNR);

create table ZU_WS_WSK
(
	WSKEY			NUMBER(10,0),
	WSKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_WS_WSK on ZU_WS_WSK(WSKEY, WSKNR);

create table ZEICHNKAT
(
	ZNKNR			NUMBER(10,0),
	ZNKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index ZEICHNKAT on ZEICHNKAT(ZNKNR);

create table ZU_ZN_ZNK
(
	ZNKEY			NUMBER(10,0),
	ZNKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_ZN_ZNK on ZU_ZN_ZNK(ZNKEY, ZNKNR);

create table MASCHINKAT
(
	MAKNR			NUMBER(10,0),
	MAKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index MASCHINKAT on MASCHINKAT(MAKNR);

create table ZU_MA_MAK
(
	MAKEY			NUMBER(10,0),
	MAKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_MA_MAK on ZU_MA_MAK(MAKEY, MAKNR);

create table PRUEFMITKAT
(
	PMKNR			NUMBER(10,0),
	PMKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index PRUEFMITKAT on PRUEFMITKAT(PMKNR);

create table ZU_PM_PMK
(
	PMKEY			NUMBER(10,0),
	PMKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_PM_PMK on ZU_PM_PMK(PMKEY, PMKNR);

create table EINHEITKAT
(
	EIKNR			NUMBER(10,0),
	EIKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index EINHEITKAT on EINHEITKAT(EIKNR);

create table ZU_EI_EIK
(
	EIKEY			NUMBER(10,0),
	EIKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_EI_EIK on ZU_EI_EIK(EIKEY, EIKNR);

create table PRUEFERKAT
(
	PRKNR			NUMBER(10,0),
	PRKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index PRUEFERKAT on PRUEFERKAT(PRKNR);

create table ZU_PR_PRK
(
	PRKEY			NUMBER(10,0),
	PRKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_PR_PRK on ZU_PR_PRK(PRKEY, PRKNR);

create table AUFTRGEBKAT
(
	AUGKNR			NUMBER(10,0),
	AUGKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index AUFTRGEBKAT on AUFTRGEBKAT(AUGKNR);

create table ZU_AUG_AUGK
(
	AUGKEY			NUMBER(10,0),
	AUGKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_AUG_AUGK on ZU_AUG_AUGK(AUGKEY, AUGKNR);

create table ERZEUGNISKAT
(
	EZKNR			NUMBER(10,0),
	EZKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index ERZEUGNISKAT on ERZEUGNISKAT(EZKNR);

create table ZU_EZ_EZK
(
	EZKEY			NUMBER(10,0),
	EZKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_EZ_EZK on ZU_EZ_EZK(EZKEY, EZKNR);

create table MITARBKAT
(
	MIKNR			NUMBER(10,0),
	MIKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index MITARBKAT on MITARBKAT(MIKNR);

create table ZU_MI_MIK
(
	MIKEY			NUMBER(10,0),
	MIKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_MI_MIK on ZU_MI_MIK(MIKEY, MIKNR);

create table NESTKAT
(
	NEKNR			NUMBER(10,0),
	NEKBEZ			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index NESTKAT on NESTKAT(NEKNR);

create table ZU_NE_NEK
(
	NEKEY			NUMBER(10,0),
	NEKNR 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_NE_NEK on ZU_NE_NEK(NEKEY, NEKNR);

-- Statusflags bei allen Katalogen

alter table KUNDE add
(
	KUSTATE			NUMBER(10,0)	default 0
);
update KUNDE set KUSTATE = 0 where KUSTATE is null;

alter table HERSTELL add
(
	HESTATE			NUMBER(10,0)	default 0
);
update HERSTELL set HESTATE = 0 where HESTATE is null;

alter table LIEFERAN add
(
	LISTATE			NUMBER(10,0)	default 0
);
update LIEFERAN set LISTATE = 0 where LISTATE is null;

alter table PAUFTRAG add
(
	PASTATE			NUMBER(10,0)	default 0
);
update PAUFTRAG set PASTATE = 0 where PASTATE is null;

alter table PAUFTRAG add
(
	PAFAELLIGMINUTEN			NUMBER(10,0)	default 0
);
update PAUFTRAG set PAFAELLIGMINUTEN = 0 where PAFAELLIGMINUTEN is null;

alter table PAUFTRAG add
(
	PASTUECK			NUMBER(10,0)	default 0
);
update PAUFTRAG set PASTUECK = 0 where PASTUECK is null;

alter table PAUFTRAG add
(
	PAFAELLIGSTUECK			NUMBER(10,0)	default 0
);
update PAUFTRAG set PAFAELLIGSTUECK = 0 where PAFAELLIGSTUECK is null;

alter table PAUFTRAG add
(
	PAFAELLIGJETZT			NUMBER(10,0)	default 0
);
update PAUFTRAG set PAFAELLIGJETZT = 0 where PAFAELLIGJETZT is null;

alter table PAUFTRAG add
(
	PAALARMMINUTEN			NUMBER(10,0)	default 0
);
update PAUFTRAG set PAALARMMINUTEN = 0 where PAALARMMINUTEN is null;

alter table PAUFTRAG add
(
	PACHARGENR			VARCHAR2(40)
);

alter table PAUFTRAG add
(
	PAMASCHINE			VARCHAR2(50)
);

alter table PAUFTRAG add
(
	PAWERKZEUG			VARCHAR2(50)
);

alter table PAUFTRAG add
(
	PAWERKSTATT			VARCHAR2(50)
);

alter table WERKSTOF add
(
	WSSTATE			NUMBER(10,0)	default 0
);
update WERKSTOF set WSSTATE = 0 where WSSTATE is null;

alter table ZEICHN add
(
	ZNSTATE			NUMBER(10,0)	default 0
);
update ZEICHN set ZNSTATE = 0 where ZNSTATE is null;

alter table MASCHINE add
(
	MASTATE			NUMBER(10,0)	default 0
);
update MASCHINE set MASTATE = 0 where MASTATE is null;

alter table PRUEFMIT add
(
	PMSTATE			NUMBER(10,0)	default 0
);
update PRUEFMIT set PMSTATE = 0 where PMSTATE is null;

alter table EINHEIT add
(
	EISTATE			NUMBER(10,0)	default 0
);
update EINHEIT set EISTATE = 0 where EISTATE is null;

alter table PRUEFER add
(
	PRSTATE			NUMBER(10,0)	default 0
);
update PRUEFER set PRSTATE = 0 where PRSTATE is null;

alter table AUFTRGEB add
(
	AUGSTATE			NUMBER(10,0)	default 0
);
update AUFTRGEB set AUGSTATE = 0 where AUGSTATE is null;

alter table ERZEUGNIS add
(
	EZSTATE			NUMBER(10,0)	default 0
);
update ERZEUGNIS set EZSTATE = 0 where EZSTATE is null;

alter table MITARB add
(
	MISTATE			NUMBER(10,0)	default 0
);
update MITARB set MISTATE = 0 where MISTATE is null;

alter table EREIGTXT add
(
	ETSTATE			NUMBER(10,0)	default 0
);
update EREIGTXT set ETSTATE = 0 where ETSTATE is null;

alter table ORDKLASS add
(
	OKBEWERT		NUMBER(5,0)	default 0
);
update ORDKLASS set OKBEWERT = 0 where OKBEWERT is null;

alter table ORDKLASS add
(
	OKSTATE			NUMBER(10,0)	default 0
);
update ORDKLASS set OKSTATE = 0 where OKSTATE is null;

alter table PROZPARAMTXT add
(
	PPSTATE			NUMBER(10,0)	default 0
);
update PROZPARAMTXT set PPSTATE = 0 where PPSTATE is null;

alter table NEST add
(
	NESTATE			NUMBER(10,0)	default 0
);
update NEST set NESTATE = 0 where NESTATE is null;

CREATE TABLE MERKMAL_REPORT_NO_SELECT
(
	METEIL                        	NUMBER(10, 0) ,
	MEMERKMAL                     	NUMBER(5, 0) ,
	MEREPORT                      	VARCHAR2(255) ,
	MODUL                         	NUMBER(5, 0) ,
	CONFNAME                      	VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;
create index MERKMAL_REPORT_NST on MERKMAL_REPORT_NO_SELECT(METEIL);

ALTER TABLE ALARMS ADD 
(
	ALARM_EW                      	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	ALARM_QRK_L                   	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	ALARM_QRK_S                   	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	ALARM_CP                      	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0006                         	VARCHAR2(20)
)
;

ALTER TABLE ALARMS ADD 
(
	K0007                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0008                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0010                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0012                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0053                         	VARCHAR2(20)
)
;

ALTER TABLE ALARMS ADD 
(
	K1000                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	K0000                         	NUMBER(10, 0)
)
;

ALTER TABLE ALARMS ADD 
(
	SUMMARY_NR			          	NUMBER(10, 0) 
)
;
ALTER TABLE ALARMS ADD 
(
	STATUS_PRINTED          		NUMBER(10, 0) 
)
;
ALTER TABLE ALARMS ADD 
(
	POINTS                          NUMBER(10,0)
);
ALTER TABLE ALARMS ADD 
(
	STATION_NO                      VARCHAR2(50)
);

ALTER TABLE ALARM_VALUES ADD 
(
	POINTS                          NUMBER(10,0)
);

ALTER TABLE LAST_UPLOAD ADD 
(
	MMNRINTERN                    	NUMBER(5, 0)
)
;


ALTER TABLE LAST_UPLOAD ADD 
(
	TIDNR VARCHAR2(20)
)
;
ALTER TABLE LAST_UPLOAD ADD 
(
	K1001		VARCHAR2(40)
)
;

ALTER TABLE LAST_UPLOAD ADD 
(
	K1002		VARCHAR2(80)
)
;

ALTER TABLE MERKMAL MODIFY 
(
	MEPRUEFMIT                    	NUMBER(10, 0)
)
;

ALTER TABLE MERKMAL MODIFY 
(
	MEMASCHINE                    	NUMBER(10, 0)
)
;

ALTER TABLE MERKMAL MODIFY 
(
	MEPRUEFER                     	NUMBER(10, 0)
)
;

ALTER TABLE MERKMAL MODIFY 
(
	MEWERKSTCK                    	NUMBER(10, 0)
)
;

ALTER TABLE MERKMAL_REPORT MODIFY 
(
	MEREPORTALARM                 	VARCHAR2(255)
)
;

ALTER TABLE ORDKLASS ADD 
(
	OKRANG                        	NUMBER(10, 0)
)
;

ALTER TABLE RESULTS ADD 
(
	K2005_0                       	NUMBER(5, 0)
)
;

ALTER TABLE RESULTS ADD 
(
	R5210_20                      	FLOAT
)
;

ALTER TABLE RESULTS ADD 
(
	R5210_20_T                    	FLOAT
)
;

ALTER TABLE RESULTS ADD 
(
	R5220_20                      	FLOAT
)
;

ALTER TABLE RESULTS ADD 
(
	R5220_20_T                    	FLOAT
)
;

ALTER TABLE MITARB MODIFY
(
     MIABT          VARCHAR2(50)
);

ALTER TABLE ORDKLASS MODIFY
(
     OKNR           VARCHAR2(40)
);

ALTER TABLE ORDKLASS MODIFY
(
     OKBEZ           VARCHAR2(100)
);

ALTER TABLE ORDKLASSKAT MODIFY
(
     OKKBEZ           VARCHAR2(100)
);




--CREATE SEQUENCE SIGNATURE_KEYS 
--  MINVALUE 1 
--  INCREMENT BY 1 START WITH ???
--  NOCACHE ORDER;

DECLARE
  C              INTEGER := dbms_sql.open_cursor;
  FDBK           INTEGER;
  STATEMENT      VARCHAR2(2000);
  MAXSIG         INTEGER;
BEGIN
  SELECT NVL(MAX(SIGNATUR_ID), 0) + 1 INTO MAXSIG FROM SIGNATUR_MASTER;
  STATEMENT := 'CREATE SEQUENCE SIGNATURE_KEYS MINVALUE 1 INCREMENT BY 1 START WITH ' ||
      TO_CHAR(MAXSIG) || 'NOCACHE ORDER';
  dbms_sql.parse(C, STATEMENT, dbms_sql.native);
  FDBK := dbms_sql.execute(C);
  dbms_sql.close_cursor(C);
END;
/

create table MERKMAL_MASTER
(
    METEIL                          NUMBER(10,0)                          ,
    MEMERKMAL                       NUMBER(5,0)                         ,
    MEMERKNR                        VARCHAR2(20)                      ,
    MEMERKBEZ                       VARCHAR2(80)                      ,
    MENENNMAS                       FLOAT                        ,
    MEARTUGW                        NUMBER(5,0)                         ,
    MEARTOGW                        NUMBER(5,0)                         ,
    MEARTPLAUSIUNT                  NUMBER(5,0)                         ,
    MEARTPLAUSIOB                   NUMBER(5,0)                         ,
    MEUGW                           FLOAT                        ,
    MEOGW                           FLOAT                        ,
    MEFSK                           NUMBER(5,0)                         ,
    MEFEHLART                       NUMBER(3,0)                          ,
    MEFEHLKOST                      FLOAT                        ,
    MEDPFLICHT                      NUMBER(5,0)                         ,
    MEEINHEIT                       NUMBER(5,0)                         ,
    MEAUFLOES                       NUMBER(5,0)                         ,
    MEKLASSENW                      FLOAT                        ,
    MEFERTARTNR                     VARCHAR2(20)                      ,
    MEFERTART                       VARCHAR2(80)                      ,
    MEPMGRUPPE                      NUMBER(5,0)                         ,
    MEPRUEFMIT                      NUMBER(10,0)                         ,
    MEPRUEFMITNR                    NUMBER(5,0)                         ,
    MEPMGRUPPET                     VARCHAR2(80)                      ,
    MEPRUEFMITT                     VARCHAR2(80)                      ,
    MEPRUEFMITNRT                   VARCHAR2(80)                      ,
    MEERFART                        NUMBER(5,0)                         ,
    MEMASCHINE                      NUMBER(10,0)                         ,
    MEBEMERK                        LONG                      ,
    MESTIFREQ                       NUMBER(5,0)                         ,
    MEUMFSTICH                      NUMBER(5,0)                         ,
    MEANZSTICH                      NUMBER(10,0)                          ,
    MEANZMESSGC                     NUMBER(10,0)                          ,
    MEANZPRUEF                      NUMBER(10,0)                          ,
    MEUMFPROZ                       NUMBER(5,0)                         ,
    MEANZWIED                       NUMBER(5,0)                         ,
    MEANZTEILE                      NUMBER(10,0)                          ,
    MENENNMAST                      VARCHAR2(50)                      ,
    MEUGWT                          VARCHAR2(50)                      ,
    MEOGWT                          VARCHAR2(50)                      ,
    MEPLAUSIUT                      VARCHAR2(50)                      ,
    MEPLAUSIOT                      VARCHAR2(50)                      ,
    METOLERANZ                      NUMBER(5,0)                         ,
    MEFORMEL                        VARCHAR2(255)                     ,
    METRANSART                      NUMBER(3,0)                          ,
    METRANSPA                       FLOAT                        ,
    METRANSPB                       FLOAT                        ,
    METRANSPC                       FLOAT                        ,
    METRANSPD                       FLOAT                        ,
    MEGLMITT                        NUMBER(5,0)                         ,
    MEAUSWART                       NUMBER(5,0)                         ,
    MEAUSWTYP                       NUMBER(5,0)                         ,
    MEMERKART                       NUMBER(5,0)                         ,
    MEVERTFORM                      NUMBER(5,0)                         ,
    MEPLAUSIOB                      FLOAT                        ,
    MEPLAUSIUN                      FLOAT                        ,
    MEPROSTREUSTR                   VARCHAR2(40)                      ,
    MEPROSTREU                      FLOAT                        ,
    MENORMISTSTR                    VARCHAR2(80)                      ,
    MENORMIST                       FLOAT                        ,
--    MENORMNR                        VARCHAR2(20) , korrigiert 12.11.99
    MENORMNR                        VARCHAR2(40)                      ,
    MENORMBEZ                       VARCHAR2(40)                      ,
    MENORMTEMP                      VARCHAR2(40)                      ,
    MEKONFIG                        VARCHAR2(1000)                     ,
    MEKLASSUNT                      FLOAT                        ,
    MEKLASSOB                       FLOAT                        ,
    MEKLASSNR                       FLOAT                        ,
    MEVORGCP                        FLOAT                        ,
    MEVORGCPK                       FLOAT                        ,
    MESTEUERB                       NUMBER(3,0)                          ,
    MEEREIGKAT                      VARCHAR2(50)                      ,
    MEZYKLUS                        NUMBER(5,0)                         ,
    MEPRUEFZST                      NUMBER(5,0)                         ,
    MEPRUEFORT                      NUMBER(5,0)                         ,
    MEMASSN                         NUMBER(5,0)                         ,
    MENENNMASSP                     VARCHAR2(50)                      ,
    MEPRFSPEC                       NUMBER(5,0)                         ,
    MEAUTOAKT                       NUMBER(5,0)                         ,
    MEMERKKLASSE                    NUMBER(5,0)                         ,
    MEUNTERSART                     NUMBER(5,0)                         ,
    MEANZORDKLASSE                  NUMBER(5,0)                         ,
    MEGLEITSTUMF                    NUMBER(5,0)                         ,
    MEPUFFERSIZE                    NUMBER(5,0)                         ,
    MEAUTOERKENNUNG                 NUMBER(5,0)                         ,
    MEATTR                          NUMBER(5,0)                         ,
    METRANSFEING                    NUMBER(5,0)                         ,
    METRANSFEINGA                   FLOAT                        ,
    METRANSFEINGB                   FLOAT                        ,
    MENLINKSMA                      NUMBER(5,0)                         ,
    MEERFKANAL                      VARCHAR2(20)                      ,
    MEERFSUBKANAL                   VARCHAR2(20)                      ,
    MENACHARBEIT                    NUMBER(5,0)                         ,
    MEZIELWERT                      FLOAT                        ,
    MEZIELWERTT                     FLOAT                        ,
    MEPMAX                          FLOAT                        ,
    MEEINHEITTEXT                   VARCHAR2(80)                      ,
    MELOSUMFANG                     NUMBER(10,0)                          ,
    MEKOSTENNACHARBEIT              FLOAT                        ,
    MEKOSTENAUSSCHUSS               FLOAT                        ,
    MEMASCHNR                       VARCHAR2(24)                      ,
    MEMASCHBEZ                      VARCHAR2(80)                      ,
    MEABT                           VARCHAR2(40)                      ,
    MESTANDORT                      VARCHAR2(80)                      ,
    MEAUFTRNR                       VARCHAR2(80)                      ,
    MEAUFTRAGGEBNR                  NUMBER(5,0)                         ,
    MEAUFTRAGGEBNRT                 VARCHAR2(20)                      ,
    MEAUFTRAGGEB                    VARCHAR2(80)                      ,
    MEPRUEFORTT                     VARCHAR2(80)                      ,
    MEPRUEFBEGINN                   VARCHAR2(80)                      ,
    MEPRUEFENDE                     VARCHAR2(80)                      ,
    MEPRUEFER                       NUMBER(10,0)                         ,
    MEPRUEFERNR                     VARCHAR2(20)                      ,
    MEPRUEFERNAME                   VARCHAR2(80)                      ,
    MEPRUEFBEDING                   VARCHAR2(255)                     ,
    MEAUGROUP                       NUMBER(5,0)                         ,
    MEUPPERMERKMAL                  NUMBER(5,0)                         ,
    METOLERANZTEXT                  VARCHAR2(80)                      ,
    MEWERKSTCK                      NUMBER(10,0)                         ,
    MEWERKSTCKTEXT                  VARCHAR2(80)                      ,
    MEANZSPTEXT                     VARCHAR2(80)                      ,
    MEPMAUFLOES                     FLOAT                        ,
    MEPRUEFBEGINND                  DATE                      ,
    MEPRUEFENDED                    DATE                      ,
    MENORMAL                        NUMBER(5,0)                         ,
    MENORMALTEMP                    FLOAT                        ,
    MESTIFREQT                      VARCHAR2(80)                 ,
    MEWERKSTCKNR                    VARCHAR2(20)		 ,
	MEKURZBEZ	VARCHAR2(20)	,
	MEUGSCHROTT	FLOAT		,
	MEOGSCHROTT	FLOAT		,
	MECG		FLOAT		,
	MECGK		FLOAT		,
	MEABWGC		FLOAT		,
	MEZEICHN	VARCHAR2(80)	,
	MEFERTARTKEY	NUMBER(5,0)	,
	MEPMHERST	VARCHAR2(40)	,
	MEKORRSTRAT	NUMBER(5,0)	,
	MEUKG		FLOAT		,
	MEOKG		FLOAT		,
	MEKORRZIEL	FLOAT		,
	MEERFNR		NUMBER(5,0)	,
	MEERFNAME	VARCHAR2(40)	,
	MEERFINDEX	NUMBER(5,0)	,
	MEANFINDEX	NUMBER(5,0)	,
	MEINTERFACE	NUMBER(5,0)	,
	MEBAUD		NUMBER(10,0)	,
	MEIRQ		NUMBER(5,0)	,
	MEPARITY	NUMBER(5,0)	,
	MEDATA		NUMBER(5,0)	,
	MESTOP		NUMBER(5,0)	,
	MEPZPKAT	NUMBER(5,0)	,
	METOLERANZCALC	FLOAT		,
	MEBEREICH	VARCHAR2(40)	,
	MEPTM		VARCHAR2(40)	,
	MEPPLANNRT	VARCHAR2(20)	,
	MEPPLAN		VARCHAR2(40)	,
	MEPPLANDAT	VARCHAR2(20)	,
	MEPPLANERST	VARCHAR2(40)	,
	MESPCNR		VARCHAR2(20)	,
	MESPCHERST	VARCHAR2(40)	,
	MESPCTYP	VARCHAR2(20)	,
	MECP		FLOAT		,
	MECPK		FLOAT		,
	MECPFIX		FLOAT		,
	MECPKFIX	FLOAT		,
	MEGAGE25	VARCHAR2(110)	,	
	MEEINHREL	VARCHAR2(20)	,	
	MEADDFAKREL	FLOAT		,
	MEMULFAKREL	FLOAT		,
	MENORMISTUN	FLOAT		,
	MENORMISTOB	FLOAT		,
--
-- aus MERKMAL_AD
	MENORMALSERNR	VARCHAR2(20),
	MEPRUEFMITSERNR	VARCHAR2(20),
	MEANZGERAET	VARCHAR2(40),
	MEREFTEILNRSTR	VARCHAR2(20),
	MEREFTEILBEZ	VARCHAR2(40),
	MEREFTEILIST	FLOAT,
	MEREFTEILTEMP	FLOAT,
	MEREFTEILNR	NUMBER(5,0),
	MEREFTEILSERNR	VARCHAR2(20),
	MEKALTEILUNRSTR	VARCHAR2(20),
	MEKALTEILUBEZ	VARCHAR2(40),
	MEKALTEILUIST	FLOAT,
	MEKALTEILUTEMP	FLOAT,
	MEKALTEILUNR	NUMBER(5,0),
	MEKALTEILUSERNR	VARCHAR2(20),
	MEKALTEILMNRSTR	VARCHAR2(20),
	MEKALTEILMBEZ	VARCHAR2(40),
	MEKALTEILMIST	FLOAT,
	MEKALTEILMTEMP	FLOAT,
	MEKALTEILMNR	NUMBER(5,0),
	MEKALTEILMSERNR	VARCHAR2(20),
	MEKALTEILONRSTR	VARCHAR2(20),
	MEKALTEILOBEZ	VARCHAR2(40),
	MEKALTEILOIST	FLOAT,
	MEKALTEILOTEMP	FLOAT,
	MEKALTEILONR	NUMBER(5,0),
	MEKALTEILOSERNR	VARCHAR2(20),
	MEUEBERKAN	NUMBER(5,0),
	MEMERKCODE	VARCHAR2(40),
	MEMERKINDEX	VARCHAR2(20),
	MEMERKTEXT	VARCHAR2(50),
	MEBEARBZUST	VARCHAR2(80),
	MEELEMCODE	VARCHAR2(40),
	MEELEMINDEX	VARCHAR2(20),
	MEELEMTEXT	VARCHAR2(50),
	MEELEMADR	VARCHAR2(20),
	MEFREIFELD	NUMBER(3,0),
	MECALIBADD	FLOAT,
	MECALIBMULT	FLOAT,
	MEANZNIAUSGEF	NUMBER(10,0),
	MEGCKONVART	NUMBER(3,0),
	MEANZREF	NUMBER(5,0),
	MEREFPKTX	NUMBER(5,0),
	MEREFPKTY	NUMBER(5,0),
	MEREFPKTZ	NUMBER(5,0),
	ME_2430		NUMBER(5,0),
	ME_2432		NUMBER(5,0),
	ME_2434		NUMBER(5,0),
	ME_2436		VARCHAR2(10),
	ME_2438		VARCHAR2(10),
	ME_2440		VARCHAR2(40),
	ME_2442		VARCHAR2(15),
	ME_2444		VARCHAR2(40),
	ME_2446		VARCHAR2(40),
	ME_2448		VARCHAR2(40),
	ME_8530		NUMBER(5,0),
	ME_8531		FLOAT,
	ME_8532		FLOAT,
	ME_8540		NUMBER(5,0),
	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		NUMBER(3,0),
	MEMASTERGUID	RAW(16)
)
  TABLESPACE qmerk_table
  PCTFREE 20
  PCTUSED 80
  --PARALLEL (DEGREE DEFAULT)
;

create unique index MERKMAL_MASTER on MERKMAL_MASTER (MEMASTERGUID)
TABLESPACE qmerk_index;

create table PART_CHAR_OPER_LINK
(
	OPERATION_GUID		RAW(16),
	PART_KEY		NUMBER(10,0),
	CHAR_KEY		NUMBER(10,0),
	CHAR_GUID		RAW(16),
	SAMPLE_SIZE		NUMBER(10,0),
	SAMPLE_FREQ		VARCHAR2(50),
	RECORD_TYPE		VARCHAR2(50),
	GAGE			VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;
create unique index PART_CHAR_OPER_LINK on PART_CHAR_OPER_LINK(OPERATION_GUID, PART_KEY, CHAR_KEY);

create table PLANT_LEVEL
(
	LEVEL_ID		NUMBER(10,0),
	LEVEL_NO		VARCHAR2(50),
	LEVEL_DESC		VARCHAR2(255),
	LEVEL_SOURCE		NUMBER(10,0),
	LEVEL_DESC_NO		VARCHAR2(255),
	LEVEL_TYPE_FIELD_NO	VARCHAR2(50),
	LEVEL_DESC_DESC		VARCHAR2(255),
	LEVEL_TYPE_FIELD_DESC	VARCHAR2(50),
	LEVEL_IMAGE		LONG RAW,
	LEVEL_NEW_TEXT		VARCHAR2(50),
	LEVEL_DESC_FIELD_01	VARCHAR2(255),
	LEVEL_TYPE_FIELD_01	VARCHAR2(50),
	LEVEL_DESC_FIELD_02	VARCHAR2(255),
	LEVEL_TYPE_FIELD_02	VARCHAR2(50),
	LEVEL_DESC_FIELD_03	VARCHAR2(255),
	LEVEL_TYPE_FIELD_03	VARCHAR2(50),
	LEVEL_DESC_FIELD_04	VARCHAR2(255),
	LEVEL_TYPE_FIELD_04	VARCHAR2(50),
	LEVEL_DESC_FIELD_05	VARCHAR2(255),
	LEVEL_TYPE_FIELD_05	VARCHAR2(50),
	LEVEL_DESC_FIELD_06	VARCHAR2(255),
	LEVEL_TYPE_FIELD_06	VARCHAR2(50),
	LEVEL_DESC_FIELD_07	VARCHAR2(255),
	LEVEL_TYPE_FIELD_07	VARCHAR2(50),
	LEVEL_DESC_FIELD_08	VARCHAR2(255),
	LEVEL_TYPE_FIELD_08	VARCHAR2(50),
	LEVEL_DESC_FIELD_09	VARCHAR2(255),
	LEVEL_TYPE_FIELD_09	VARCHAR2(50),
	LEVEL_DESC_FIELD_10	VARCHAR2(255),
	LEVEL_TYPE_FIELD_10	VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;
create unique index PLANT_LEVEL on PLANT_LEVEL(LEVEL_ID);


create table PLANT_STRUCT
(
	NODE_ID			RAW(16),
	PARENT_ID		RAW(16),
	NODE_LEVEL		NUMBER(10,0),
	NODE_LOCALPOS		NUMBER(10,0),
	NODE_SOURCE_KEY		NUMBER(10,0),
	NODE_SOURCE_GUID	RAW(16),
	NODE_NO			VARCHAR2(50),
	NODE_DESC		VARCHAR2(255),
	NODE_IMAGE		LONG RAW,
	NODE_FIELD_01		VARCHAR2(255),
	NODE_FIELD_02		VARCHAR2(255),
	NODE_FIELD_03		VARCHAR2(255),
	NODE_FIELD_04		VARCHAR2(255),
	NODE_FIELD_05		VARCHAR2(255),
	NODE_FIELD_06		VARCHAR2(255),
	NODE_FIELD_07		VARCHAR2(255),
	NODE_FIELD_08		VARCHAR2(255),
	NODE_FIELD_09		VARCHAR2(255),
	NODE_FIELD_10		VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index PLANT_STRUCT on PLANT_STRUCT(NODE_ID);
CREATE INDEX PLANT_STRUCT2 ON PLANT_STRUCT(NODE_LEVEL, NODE_LOCALPOS);

CREATE TABLE PLANT_DISTR_NUMS
(
	MACHINE_NODE_ID		RAW(16),
	CHAR_MASTER_GUID	RAW(16),
	MACHINE_CATALOGKEY	NUMBER(10,0),
	DISTR_NUMBER		VARCHAR2(40)
)
TABLESPACE QDAS_DEFAULT;
create unique index PLANT_DISTR_NUMS on PLANT_DISTR_NUMS(MACHINE_NODE_ID, CHAR_MASTER_GUID);
create index PDN_MACHINE_CATALOGKEY on PLANT_DISTR_NUMS(MACHINE_CATALOGKEY);

CREATE TABLE LINE_ALERT_DISTRIB
(
	LINE_ID			RAW(16),
	OPERATION_ID			RAW(16),
	RECIPIENT_KEY		NUMBER(10,0),
	EMAIL			NUMBER(1,0),
	SMS			NUMBER(1,0)
)
TABLESPACE QDAS_DEFAULT;
create unique index LINE_ALERT_DISTRIB on LINE_ALERT_DISTRIB(LINE_ID, OPERATION_ID, RECIPIENT_KEY);


create table PRODUCT_LEVEL
(
	LEVEL_ID		NUMBER(10,0),
	LEVEL_NO		VARCHAR2(50),
	LEVEL_DESC		VARCHAR2(255),
	LEVEL_SOURCE		NUMBER(10,0),
	LEVEL_DESC_NO		VARCHAR2(255),
	LEVEL_TYPE_FIELD_NO	VARCHAR2(50),
	LEVEL_DESC_DESC		VARCHAR2(255),
	LEVEL_TYPE_FIELD_DESC	VARCHAR2(50),
	LEVEL_IMAGE		LONG RAW,
	LEVEL_NEW_TEXT		VARCHAR2(50),
	LEVEL_DESC_FIELD_01	VARCHAR2(255),
	LEVEL_TYPE_FIELD_01	VARCHAR2(50),
	LEVEL_DESC_FIELD_02	VARCHAR2(255),
	LEVEL_TYPE_FIELD_02	VARCHAR2(50),
	LEVEL_DESC_FIELD_03	VARCHAR2(255),
	LEVEL_TYPE_FIELD_03	VARCHAR2(50),
	LEVEL_DESC_FIELD_04	VARCHAR2(255),
	LEVEL_TYPE_FIELD_04	VARCHAR2(50),
	LEVEL_DESC_FIELD_05	VARCHAR2(255),
	LEVEL_TYPE_FIELD_05	VARCHAR2(50),
	LEVEL_DESC_FIELD_06	VARCHAR2(255),
	LEVEL_TYPE_FIELD_06	VARCHAR2(50),
	LEVEL_DESC_FIELD_07	VARCHAR2(255),
	LEVEL_TYPE_FIELD_07	VARCHAR2(50),
	LEVEL_DESC_FIELD_08	VARCHAR2(255),
	LEVEL_TYPE_FIELD_08	VARCHAR2(50),
	LEVEL_DESC_FIELD_09	VARCHAR2(255),
	LEVEL_TYPE_FIELD_09	VARCHAR2(50),
	LEVEL_DESC_FIELD_10	VARCHAR2(255),
	LEVEL_TYPE_FIELD_10	VARCHAR2(50)
)
TABLESPACE QDAS_DEFAULT;
create unique index PRODUCT_LEVEL on PRODUCT_LEVEL(LEVEL_ID);


create table PRODUCT_STRUCT
(
	NODE_ID			RAW(16),
	PARENT_ID		RAW(16),
	NODE_LEVEL		NUMBER(10,0),
	NODE_LOCALPOS		NUMBER(10,0),
	NODE_SOURCE_KEY		NUMBER(10,0),
	NODE_SOURCE_GUID	RAW(16),
	NODE_NO			VARCHAR2(50),
	NODE_DESC		VARCHAR2(255),
	NODE_IMAGE		LONG RAW,
	NODE_FIELD_01		VARCHAR2(255),
	NODE_FIELD_02		VARCHAR2(255),
	NODE_FIELD_03		VARCHAR2(255),
	NODE_FIELD_04		VARCHAR2(255),
	NODE_FIELD_05		VARCHAR2(255),
	NODE_FIELD_06		VARCHAR2(255),
	NODE_FIELD_07		VARCHAR2(255),
	NODE_FIELD_08		VARCHAR2(255),
	NODE_FIELD_09		VARCHAR2(255),
	NODE_FIELD_10		VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index PRODUCT_STRUCT on PRODUCT_STRUCT(NODE_ID);
CREATE INDEX PRODUCT_STRUCT2 ON PRODUCT_STRUCT(NODE_LEVEL, NODE_LOCALPOS);


create table MEASUREMENT_DOKUMENTS
(
    MD_ID                           NUMBER(10,0),
    MD_TEIL                         NUMBER(10,0),
    MD_MEASUREMENT_IDENT            VARCHAR2(50),
    MD_DOCDESCR                     VARCHAR2(50),
    MD_DOCPATH                      VARCHAR2(60)
)
TABLESPACE QDAS_DEFAULT;
create unique index MEASUREMENT_DOKUMENTS on MEASUREMENT_DOKUMENTS(MD_ID);
create index TEIL_VALUE on MEASUREMENT_DOKUMENTS(MD_TEIL, MD_MEASUREMENT_IDENT);
ALTER TABLE MEASUREMENT_DOKUMENTS MODIFY 
(
	MD_DOCPATH                      VARCHAR2(255)
);

create table KAT_4270
(
	KATKEY			NUMBER(10,0),
	NR			VARCHAR2(20),
	BEZ			VARCHAR2(100),
	STATE			NUMBER(10,0)			
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4270 on KAT_4270(KATKEY);

create table KAT_4270KAT
(
	SUBKATKEY			NUMBER(10,0),
	SUBKATNAME			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4270KAT on KAT_4270KAT(SUBKATKEY);

create table ZU_4270KAT
(
	KATKEY			NUMBER(10,0),
	SUBKATKEY 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_4270KAT on ZU_4270KAT(KATKEY, SUBKATKEY);

create table KAT_4280
(
	KATKEY			NUMBER(10,0),
	NR			VARCHAR2(20),
	BEZ			VARCHAR2(100),
	STATE			NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4280 on KAT_4280(KATKEY);

create table KAT_4280KAT
(
	SUBKATKEY			NUMBER(10,0),
	SUBKATNAME			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4280KAT on KAT_4280KAT(SUBKATKEY);

create table ZU_4280KAT
(
	KATKEY			NUMBER(10,0),
	SUBKATKEY 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_4280KAT on ZU_4280KAT(KATKEY, SUBKATKEY);

create table KAT_4290
(
	KATKEY			NUMBER(10,0),
	NR			VARCHAR2(20),
	BEZ			VARCHAR2(100),
	STATE			NUMBER(10,0)		
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4290 on KAT_4290(KATKEY);

create table KAT_4290KAT
(
	SUBKATKEY			NUMBER(10,0),
	SUBKATNAME			VARCHAR2(100)			
)
TABLESPACE QDAS_DEFAULT;
create unique index KAT_4290KAT on KAT_4290KAT(SUBKATKEY);

create table ZU_4290KAT
(
	KATKEY			NUMBER(10,0),
	SUBKATKEY 			NUMBER(10,0)                     
)
TABLESPACE QDAS_DEFAULT;
create unique index ZU_4290KAT on ZU_4290KAT(KATKEY, SUBKATKEY);

ALTER TABLE TEIL MODIFY
(
	TEKONFIG	VARCHAR2(1000)
);
	
ALTER TABLE MERKMAL MODIFY
(
	MEKONFIG	VARCHAR2(1000)
);	

ALTER TABLE MERKMAL_MASTER MODIFY
(
	MEKONFIG	VARCHAR2(1000)
);	

  CREATE TABLE MANUAL_QCC_PRINT 
   (	BORDEREAU_ID NUMBER(10,0) NOT NULL ENABLE, 
	DG_BORDEREAU_ID NUMBER(10,0), 
	STATUS NUMBER(2,0) NOT NULL ENABLE, 
	WORKSTATION_ID VARCHAR2(100 BYTE), 
	PRINTER_ID VARCHAR2(100 BYTE), 
	BORDEREAU_TYPE NUMBER(2,0), 
	YEAR_NO NUMBER(4,0), 
	WEEK_NO NUMBER(2,0), 
	DAY_NO NUMBER(1,0), 
	CLASSIFICATION VARCHAR2(50 BYTE), 
	EVENT_01_ID NUMBER(10,0), 
	EVENT_02_ID NUMBER(10,0), 
	EVENT_03_ID NUMBER(10,0), 
	EVENT_04_ID NUMBER(10,0), 
	EVENT_05_ID NUMBER(10,0), 
	EVENT_06_ID NUMBER(10,0), 
	EVENT_07_ID NUMBER(10,0), 
	EVENT_08_ID NUMBER(10,0), 
	EVENT_09_ID NUMBER(10,0), 
	EVENT_10_ID NUMBER(10,0), 
	DIV_01_ID VARCHAR2(50 BYTE), 
	DIV_01_REVISION VARCHAR2(20 BYTE), 
	DIV_02_ID VARCHAR2(50 BYTE), 
	DIV_02_REVISION VARCHAR2(20 BYTE), 
	DIV_03_ID VARCHAR2(50 BYTE), 
	DIV_03_REVISION VARCHAR2(20 BYTE), 
	DIV_04_ID VARCHAR2(50 BYTE), 
	DIV_04_REVISION VARCHAR2(20 BYTE), 
	DIV_05_ID VARCHAR2(50 BYTE), 
	DIV_05_REVISION VARCHAR2(20 BYTE), 
	CONTROL_PLAN_ID VARCHAR2(50 BYTE), 
	ATELIER_NO VARCHAR2(50 BYTE), 
	LINE_NO VARCHAR2(50 BYTE), 
	LINE_DESC VARCHAR2(50 BYTE), 
	OPERATION_NO VARCHAR2(50 BYTE), 
	OPERATION_DESC VARCHAR2(50 BYTE), 
	MACHINE_NO VARCHAR2(50 BYTE), 
	MACHINE_DESC VARCHAR2(50 BYTE), 
	CHAR_NO VARCHAR2(20 BYTE), 
	CHAR_DESC VARCHAR2(80 BYTE), 
	GAGE_ID VARCHAR2(50 BYTE), 
	GAGE_DESC VARCHAR2(50 BYTE), 
	SAMPLE_FREQ VARCHAR2(80 BYTE), 
	SAMPLE_SIZE NUMBER(5,0), 
	LSL FLOAT(126), 
	USL FLOAT(126), 
	NOMINAL FLOAT(126), 
	LLIMITTYPE NUMBER(2,0), 
	ULIMITTYPE NUMBER(2,0), 
	LCL FLOAT(126), 
	UCL FLOAT(126), 
	UNIT VARCHAR2(20 BYTE), 
	PRECISION_SIZE NUMBER(2,0), 
	PAGENO NUMBER(2,0), 
	MAXPAGE NUMBER(2,0), 
	LOI NUMBER(2,0), 
	DISTRIBUTIONNO VARCHAR2(20 BYTE), 
	EVENT_01_TEXT VARCHAR2(40 BYTE), 
	EVENT_02_TEXT VARCHAR2(40 BYTE), 
	EVENT_03_TEXT VARCHAR2(40 BYTE), 
	EVENT_04_TEXT VARCHAR2(40 BYTE), 
	EVENT_05_TEXT VARCHAR2(40 BYTE), 
	EVENT_06_TEXT VARCHAR2(40 BYTE), 
	EVENT_07_TEXT VARCHAR2(40 BYTE), 
	EVENT_08_TEXT VARCHAR2(40 BYTE), 
	EVENT_09_TEXT VARCHAR2(40 BYTE), 
	EVENT_10_TEXT VARCHAR2(40 BYTE), 
	 CONSTRAINT PKMANUAL_QCC_PRINT PRIMARY KEY (BORDEREAU_ID) ENABLE
   ) ;
 
  CREATE TABLE MANUAL_QCC_PRINT_HISTORY 
   (	BORDEREAU_ID NUMBER(10,0) NOT NULL ENABLE, 
	STATUS_HISTORY NUMBER(2,0) NOT NULL ENABLE, 
	STATUS_TIME DATE NOT NULL ENABLE, 
	 CONSTRAINT FK_MANUAL_QCC_PRINT_HISTORY FOREIGN KEY (BORDEREAU_ID)
	  REFERENCES MANUAL_QCC_PRINT (BORDEREAU_ID) ON DELETE CASCADE ENABLE
   ) ;

ALTER TABLE MANUAL_QCC_PRINT ADD 
(
	CHAR_REMARK VARCHAR2(255 BYTE) 
);

ALTER TABLE EG_AEND ADD 
(
	EG_LEXL			FLOAT,
	EG_UEXL			FLOAT,
	EG_EXSTART		DATE,
	EG_EXEND		DATE,
	EG_EXVALID		NUMBER(3,0)
);
 
 
create table PLANT_JOBS
(
	TREE_TYPE		NUMBER(3,0),
	NODE_ID			RAW(16),
	JOB_NO			NUMBER(10,0),
	JOB_NAME		VARCHAR2(80),
	JOB_KIND		NUMBER(3,0),
	JOB_ACTIVE		NUMBER(3,0),
	PLAN_KIND		NUMBER(3,0),
	PLAN_TIME		FLOAT,
	NODE_LEVEL		NUMBER(3,0),
	NODE_SUBLEVEL		NUMBER(3,0),
	JOB_REPORT		VARCHAR2(255),
	VALUE_FILTER		NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;
create unique index PLANT_JOBS on PLANT_JOBS(TREE_TYPE, NODE_ID, JOB_NO);
create index JOB_ACTIVE on PLANT_JOBS(JOB_ACTIVE);
create index JOB_KIND on PLANT_JOBS(JOB_KIND);

alter table PLANT_JOBS add
(
	OFFSET			NUMBER(5,0)
);

alter table PLANT_JOBS add
(
	NODE_SUBSUBLEVEL	NUMBER(3,0),
	LT_DIVISION		VARCHAR2(100)
);

alter table PLANT_JOBS add
(
	PDF_OUTPUT_DIR		VARCHAR2(255)
);

create table JOB_FILTERS
(
	FILTER_ID		NUMBER(10,0),
	FILTER_LEVEL		NUMBER(3,0),
	FILTER_NAME		VARCHAR2(50),
	FILTER			LONG
)
TABLESPACE QDAS_DEFAULT;
create unique index JOB_FILTERS on JOB_FILTERS(FILTER_ID);
create index FILTER_LEVEL on JOB_FILTERS(FILTER_LEVEL);
create index FILTER_NAME on JOB_FILTERS(FILTER_NAME);

ALTER TABLE TEIL MODIFY
(
	TEHERSTELLERKEY					NUMBER(10,0),
	TEWERKSTOFFKEY					NUMBER(10,0),
	TEZEICHNUNGKEY					NUMBER(10,0),
	TEAUFTRAGGBKEY					NUMBER(10,0),
	TEKUNDEKEY					NUMBER(10,0),
	TELIEFERANTKEY					NUMBER(10,0),
	TEMASCHINEKEY					NUMBER(10,0),
	TEPREINRKEY					NUMBER(10,0)
);

create table NODELOCK
(
	NLNODEGUID		RAW(16),
	NLNODETYPE		NUMBER(10,0),
	NLNODESUBTYPE		NUMBER(10,0),
	NLUSERNAME		VARCHAR2(90)
)
TABLESPACE QDAS_DEFAULT;
create unique index NODELOCK on NODELOCK(NLNODEGUID);

create table NODERIGHTS
(
	NRNODEGUID		RAW(16),
	NRUSERKEY		NUMBER(10,0),
	NRCREATECHILD		VARCHAR2(1),
	NREDITNODE		VARCHAR2(1),
	NRDELETENODE		VARCHAR2(1),
	NRGRANTRIGHTS		VARCHAR2(1)
)
TABLESPACE QDAS_DEFAULT;
create unique index NODERIGHTS on NODERIGHTS(NRNODEGUID, NRUSERKEY);


alter table PLANT_JOBS add
(
	LANGUAGE		NUMBER(10,0),
	MODULE			NUMBER(10,0),
	STRATEGY		NUMBER(10,0)
);

alter table PLANT_JOBS add
(
	PART_FILTER		NUMBER(10,0),
	CHAR_FILTER		NUMBER(10,0),
	REPORT_LEVEL		NUMBER(3,0)
);

create table PLANT_REPORT_MAIL_LIST
(
	NODE_ID			RAW(16),
	JOB_NO			NUMBER(10,0),
	RECIPIENT_KEY		NUMBER(10,0)
)
TABLESPACE QDAS_DEFAULT;
create unique index PLANT_REPORT_MAIL_LIST on PLANT_REPORT_MAIL_LIST(NODE_ID, JOB_NO, RECIPIENT_KEY);

create index MEMASTERGUID on MERKMAL(MEMASTERGUID)
TABLESPACE qmerk_index;

alter table PLANT_REPORT_MAIL_LIST add
(
	ATTACH_REPORTS		NUMBER(3,0)
);

alter table PLANT_JOBS modify JOB_NAME varchar2(80);

alter table PLANT_JOBS add
(
	MAXNODESPERPAGE		NUMBER(3,0),
	DIVIDE_GRAPHICS		NUMBER(3,0)
);

alter table PLANT_JOBS add
(
	GRAPH_ROWS		NUMBER(3,0)
);

create table PART_CHAR_MACHINE
(
	PARTNO_1001		VARCHAR2(30),
	CHARNO_2001		VARCHAR2(30),
	MACHINEKEY		NUMBER(10,0),
	CHAR_MASTERGUID		RAW(16)
)
TABLESPACE QDAS_DEFAULT;
create unique index PART_CHAR_MACHINE on PART_CHAR_MACHINE(PARTNO_1001, CHARNO_2001, MACHINEKEY);

alter table 	AUFTRGEB	modify (	AUNAME1                     	VARCHAR2	(	100	)	  );
alter table 	EINHEIT	modify (	EIEINHTEXT                     	VARCHAR2	(	100	)	  );
alter table 	EMPB_3000	modify (	K3427	NUMBER	(	10,0	)	  );
alter table 	EREIGKAT	modify (	EKTEXT	VARCHAR2	(	100	)	  );
alter table 	EREIGTXT	modify (	ETTEXT	VARCHAR2	(	100	)	  );
alter table 	EREIGTXT	modify (	ETCODE	VARCHAR2	(	40	)	  );
alter table 	MASCHINE	modify (	MABEZ	VARCHAR2	(	100	)	  );
alter table 	MERKMAL	modify (	MEEINHEIT	NUMBER	(	10,0	)	  );
alter table 	MERKMAL	modify (	MEPMGRUPPE	NUMBER	(	10,0	)	  );
alter table 	MERKMAL	modify (	MEPRUEFMITNR	NUMBER	(	10,0	)	  );
alter table 	MERKMAL	modify (	MEAUFTRAGGEBNR	NUMBER	(	10,0	)	  );
alter table 	MERKMAL	modify (	MEFERTARTKEY	NUMBER	(	10,0	)	  );
alter table 	MITARB	modify (	MIABT	VARCHAR2	(	50	)	  );
alter table 	PAUFTRAG	modify (	PABEZEICH                                    	VARCHAR2	(	100	)	  );
alter table 	PROZPARAMKAT	modify (	PPKTEXT	VARCHAR2	(	100	)	  );
alter table 	PROZPARAMTXT	modify (	PPNRTEXT	VARCHAR2	(	40	)	  );
alter table 	PROZPARAMTXT	modify (	PPLANGTEXT	VARCHAR2	(	100	)	  );
alter table 	PROZPARAMWERT	modify (	PPWNRTEXT	VARCHAR2	(	40	)	  );
alter table 	PRUEFER	modify (	PRABT                                         	VARCHAR2	(	50	)	  );
alter table 	TEIL	modify (	TEPRUEFERKEY	NUMBER	(	10,0	)	  );
alter table 	WERKSTOF	modify (	WSBEZEICH	VARCHAR2	(	100	)	  );
alter table 	WERKZEUG	modify (	WENR	VARCHAR2	(	100	)	  );
alter table 	ZEICHN	modify (	ZNZNR	VARCHAR2	(	40	)	  );
alter table 	ZEICHN	modify (	ZNZNRindex	VARCHAR2	(	100	)	  );


ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2650							NUMBER(3,0),
	ME_2651							FLOAT,
	ME_2652							NUMBER(3,0),
	ME_2654							NUMBER(3,0),
	ME_2655							NUMBER(3,0),
	ME_2656							NUMBER(10,0),
	ME_2657							NUMBER(10,0),
	ME_2658							NUMBER(10,0),
	ME_2660							NUMBER(3,0)
);						

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2062							NUMBER(10,0),
	ME_2063							NUMBER(10,0),
	ME_2064							NUMBER(10,0),
	ME_2065							NUMBER(10,0)
);						

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2066							NUMBER(10,0),
	ME_2067							NUMBER(10,0),
	ME_2068							NUMBER(10,0)
);						

ALTER TABLE MEASVALUES ADD
(
WV0005                          			VARCHAR2(20)
);						

ALTER TABLE EMPB_3000 ADD
(
	K3436	NUMBER(5,0)
);

ALTER TABLE USERLOCK MODIFY
(
    LCUSER                          VARCHAR2(90)
);

ALTER TABLE NODELOCK MODIFY
(
	NLUSERNAME		VARCHAR2(90)
);

create table UNCONFORMITY_REPORTS
(
	UR_ID			NUMBER(10,0),
	UR_USERID		NUMBER(10,0),
	UR_USERNAME		varchar2(50),
	UR_CREATIONDATE		DATE,
	UR_TEIL			NUMBER(10,0),
	UR_MERKMAL		NUMBER(10,0),
	UR_WERTNR		NUMBER(10,0),
	UR_STATUS		NUMBER(3,0),
	UR_IMAGE		LONG RAW,
	UR_MODIFDATE		DATE,
	UR_CLOSE_USERID		NUMBER(10,0),
	UR_CLOSE_USERNAME	varchar2(50),
	UR_CLOSE_COMMENT	varchar2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index UNCONFORMITY_REPORTS on UNCONFORMITY_REPORTS(UR_ID);

create index UR_CLOSE_USERID on UNCONFORMITY_REPORTS(UR_CLOSE_USERID);

create index UR_USERID on UNCONFORMITY_REPORTS(UR_USERID);

create table UNCONF_DIAGN
(
	UR_ID			NUMBER(10,0),
	UD_ID			NUMBER(10,0),
	UD_ANALYSIS		varchar2(255),
	UD_CAUSE		varchar2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index UNCONF_DIAGN on UNCONF_DIAGN(UR_ID, UD_ID);

create table UNCONF_ACTION
(
	UR_ID			NUMBER(10,0),
	UA_ID			NUMBER(10,0),
	UA_NOTE			varchar2(100),
	UA_ACTION		varchar2(255),
	UA_RESPONS		varchar2(50),
	UA_DATE			varchar2(20),
	UA_EFFECT		varchar2(100)
)
TABLESPACE QDAS_DEFAULT;
create unique index UNCONF_ACTION on UNCONF_ACTION(UR_ID, UA_ID);

ALTER TABLE UNCONFORMITY_REPORTS ADD
(
	UR_TYPE		NUMBER(3,0),
	UR_SUPPLIER	varchar2(50)
);


ALTER TABLE UNCONFORMITY_REPORTS ADD
(
	UR_PRIO_ACTION		NUMBER(10,0),
	UR_ALLOC_USERS		varchar2(25)
);

ALTER TABLE UNCONFORMITY_REPORTS ADD
(
	UR_PH_RECT		varchar2(30),
	UR_USER_TEXT		varchar2(80)
);

create table UNCONFORMITY_REPORTS2
(
	UR_ID			NUMBER(10,0),
	UR_2ND_IMAGE		LONG RAW,
	UR_2ND_IMAGETYPE	varchar2(10)
)
TABLESPACE QDAS_DEFAULT;
create unique index UNCONFORMITY_REPORTS2 on UNCONFORMITY_REPORTS2(UR_ID);

ALTER TABLE UNCONFORMITY_REPORTS ADD
(
	UR_GROUPING_ID		RAW(16),
	UR_LAYOUT		NUMBER(3,0)
);

alter table SERIAL_EQUIPMENT add
(
    EQUIPMENT_PARTNO                VARCHAR2(50),
    EQUIPMENT_DMC                   VARCHAR2(50)
);

alter table SERIAL_EQUIPMENT add
(
    EQUIPMENT_ORDERNO               VARCHAR2(50)
);

ALTER TABLE MERKMAL MODIFY 
(
	MESPCHERST	varchar2(40)
)
;

ALTER TABLE MERKMAL_MASTER MODIFY 
(
	MESPCHERST	varchar2(40)
)
;


alter table EREIGTXT add
(
    ETCAQKENNUNG                    VARCHAR2(10)
);

alter table sTATION add
(
 PP_DESELECT					    NUMBER(3,0)
);

ALTER TABLE MERKMAL_ZUS MODIFY 
(
	ME_2615							FLOAT
);						

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2620							float,
	ME_2621							float,
	ME_2622							float,
	ME_2623							float,
	ME_2624							float,
	ME_2625							float,
	ME_2626							float,
	ME_2627							float,
	ME_2628							float
);						

CREATE TABLE NODERESULTS
(
	NRNODEID		RAW(16),
	NRMODULE		NUMBER(10,0),
	NRFIRSTDATE		DATE,
	NRLASTDATE		DATE,
	NROPERATOR		NUMBER(10,0),
	NRGAGE			NUMBER(10,0),
	NRMACHINE		NUMBER(10,0),
	NRNEST			NUMBER(10,0),
	NRBATCHNO		VARCHAR2(30),
	NRORDERNO		VARCHAR2(30),
	NRSEPFIELDS		VARCHAR2(50),
	NRSTRATEGY		NUMBER(10,0),
	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
)
TABLESPACE QDAS_DEFAULT;

alter table NODERESULTS add
(
	NRPS15000_00000001	FLOAT,
	NRPS15000_00000016	FLOAT,
	NRPS15000_00000032	FLOAT,
	NRPS15000_00004096	FLOAT
);						

CREATE TABLE NODEREPORTFILES
(
	NRF_NODEID		RAW(16),
	NRF_MODULE		NUMBER(10,0),
	NRF_FIRSTDATE		DATE,
	NRF_LASTDATE		DATE,
	NRF_OPERATOR		NUMBER(10,0),
	NRF_GAGE		NUMBER(10,0),
	NRF_MACHINE		NUMBER(10,0),
	NRF_NEST		NUMBER(10,0),
	NRF_BATCHNO		VARCHAR2(30),
	NRF_ORDERNO		VARCHAR2(30),
	NRF_SEPFIELDS		VARCHAR2(50),
	NRF_STRATEGY		NUMBER(10,0),
	NRF_REPORT_NUM		NUMBER(10,0),
	NRF_ENTRY_TYPE		NUMBER(10,0),
	NRF_ENTRY		LONG RAW,
	NRF_REPORTNAME		VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2028							NUMBER(3,0),
	ME_2614							NUMBER(10,0),
	ME_2632							FLOAT,
	ME_2633							FLOAT,
	ME_2739							FLOAT,
	ME_8524							FLOAT,
	ME_8525							FLOAT
);

ALTER TABLE MERKMAL_ZUS ADD
(
	ME_2417		NUMBER(10,0)
);

ALTER TABLE TEIL ADD
(
	TE_1412		NUMBER(10,0),
	TE_1413		FLOAT,
	TE_1414		NUMBER(10,0),
	TE_1415		NUMBER(3,0)
);

ALTER TABLE EMPB_3000 ADD
(
	K3780	VARCHAR2(120),
	K3781	VARCHAR2(120),
	K3782	VARCHAR2(120)
);

ALTER TABLE WERKZEUG MODIFY
(
    WEWERKZ NUMBER(10,0)
)
;

CREATE TABLE EMPB_3000_ZUS (
	K3000   NUMBER(10,0),
	K3418   NUMBER(5,0),
	K3419   NUMBER(5,0),
	K3500   NUMBER(5,0),
	K3501   NUMBER(5,0),
	K3502   NUMBER(5,0),
	K3503   NUMBER(5,0),
	K3504   NUMBER(5,0),
	K3505   NUMBER(5,0),
	K3506   NUMBER(5,0),
	K3507   NUMBER(5,0),
	K3508   NUMBER(5,0),
	K3509   NUMBER(5,0),
	K3510   NUMBER(5,0),
	K3660	VARCHAR2(20),
	K3661	VARCHAR2(20),
	K3662	VARCHAR2(20),
	K3663	VARCHAR2(20),
	K3664	VARCHAR2(20),
	K3665	VARCHAR2(20),
	K3666	VARCHAR2(20),
	K3667	VARCHAR2(20),
	K3668	VARCHAR2(20),
	K3669	VARCHAR2(20),
	K3670	VARCHAR2(20),
	K3673	VARCHAR2(50),
	K3674	VARCHAR2(50),
	K3675	VARCHAR2(50),
	K3676	VARCHAR2(50),
	K3677	VARCHAR2(50),
	K3678	VARCHAR2(50),
	K3679	VARCHAR2(50),
	K3680	VARCHAR2(50),
	K3681	VARCHAR2(50),
	K3682	VARCHAR2(50),
	K3683	VARCHAR2(50),
	K3686   NUMBER(5,0),
	K3687   NUMBER(5,0),
	K3688   NUMBER(5,0),
	K3689   NUMBER(5,0),
	K3690   NUMBER(5,0),
	K3691   NUMBER(5,0),
	K3692   NUMBER(5,0),
	K3693   NUMBER(5,0),
	K3694   NUMBER(5,0),
	K3695   NUMBER(5,0),
	K3696   NUMBER(5,0)
)
TABLESPACE QDAS_DEFAULT;

create unique index EMPB_3000_ZUS on EMPB_3000_ZUS(K3000);


ALTER TABLE EMPB_3000 MODIFY (
	K3030   VARCHAR2(120)
);

ALTER TABLE MASCHINE ADD
(
	MABEREICH	VARCHAR2(50),
	MAABT		VARCHAR2(50)
);						

ALTER TABLE MASCHINE ADD
(
	MAOPNR		VARCHAR2(50),
	MAEXTREFNR	VARCHAR2(50)
);						

ALTER TABLE PRUEFMIT MODIFY
(
	PMEINSORT	VARCHAR2(50)
);						

ALTER TABLE PRUEFMIT ADD
(
	PMIPADDR	VARCHAR2(30),
	PMCOMP		VARCHAR2(50),
	PMQVERS		VARCHAR2(30),
	PMSOFTW		VARCHAR2(50)
);						

ALTER TABLE WERKSTOF ADD
(
	WSBEMERK	VARCHAR2(200)
);						

ALTER TABLE ZEICHN ADD
(
	ZNBEMERK	VARCHAR2(200)
);						

ALTER TABLE EINHEIT ADD
(
	EIBEMERK	VARCHAR2(200)
);						

ALTER TABLE PRUEFER ADD
(
	PRBEMERK	VARCHAR2(200)
);						

ALTER TABLE MITARB ADD
(
	MIBEMERK	VARCHAR2(200)
);						

ALTER TABLE ERZEUGNIS ADD
(
	EZBEMERK	VARCHAR2(200)
);						

ALTER TABLE EREIGTXT ADD
(
	ETBEMERK	VARCHAR2(200)
);						

ALTER TABLE ORDKLASS ADD
(
	OKBEMERK	VARCHAR2(200)
);						

ALTER TABLE PROZPARAMTXT ADD
(
	PPBEMERK	VARCHAR2(200)
);						

ALTER TABLE NEST ADD
(
	NEBEMERK	VARCHAR2(200)
);						

ALTER TABLE KAT_4270 ADD
(
	BEMERK		VARCHAR2(200)
);						

ALTER TABLE KAT_4280 ADD
(
	BEMERK		VARCHAR2(200)
);						

ALTER TABLE KAT_4290 ADD
(
	BEMERK		VARCHAR2(200)
);

ALTER TABLE TEIL RENAME COLUMN TEZSB_1015 TO TEZSB_1016;

CREATE INDEX TW_WV0005 ON TRANSMIT_WERTEVAR(WV0005);


ALTER TABLE MEASUREMENT_DOKUMENTS ADD
(
	MD_MERKMAL    NUMBER(10,0)
);

ALTER TABLE MEASUREMENT_DOKUMENTS ADD
(
	MD_WERTNR    NUMBER(10,0)
);

CREATE TABLE CAQ_EREIGNIS
(
           CE_ID NUMBER(10,0),
           CE_TEIL NUMBER(10,0),
           CE_MERKMAL NUMBER(10,0),
           CE_EREIGNISID VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;

CREATE TABLE CAQ_URSACHE
(
           CU_ID NUMBER(10,0),
           CU_EREIGNISID VARCHAR2(255),
           CU_URSACHEID VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;

CREATE TABLE CAQ_MASSNAHME
(
           CM_ID NUMBER(10,0),
           CM_URSACHENID VARCHAR2(255),
           CM_MASSNAHMEID VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;

CREATE TABLE IQS_QDAS_MAPPING
(
           IQS_CLASS VARCHAR2(20),
           IQS_FIELD VARCHAR2(30),
           IQS_SUBFIELD VARCHAR2(20),
           QDAS_TABLE VARCHAR2(30),
           QDAS_FIELD VARCHAR2(20),
           QDAS_FIELD_SUBKEY VARCHAR2(20),
           QDAS_PARTKEY VARCHAR2(20),
           QDAS_CHARKEY VARCHAR2(20),
           QDAS_TAKEOVER VARCHAR2(20),
           QDAS_TRIGGER VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;

ALTER TABLE IQS_QDAS_MAPPING ADD
(
	QDAS_PPLANKEY VARCHAR2(20)
);

ALTER TABLE IQS_QDAS_MAPPING ADD
(
	QDAS_PAUFTRAGKEY VARCHAR2(20)
);

ALTER TABLE IQS_QDAS_MAPPING ADD
(
	QDAS_UNTERSKEY VARCHAR2(20)
);

ALTER TABLE IQS_QDAS_MAPPING MODIFY
(
	IQS_CLASS VARCHAR2(30)
);

ALTER TABLE IQS_QDAS_MAPPING MODIFY
(
	IQS_FIELD VARCHAR2(40)
);

CREATE TABLE IQS_QDAS_CONTENT_MAPPING
(
           IQS_CLASS VARCHAR2(20),
           IQS_FIELD VARCHAR2(30),
           IQS_FIELD_SUBKEY VARCHAR2(3),
           QDAS_FIELD VARCHAR2(20),
           QDAS_FIELD_SUBKEY VARCHAR2(20),
           IQS_CONTENT VARCHAR2(20),
           QDAS_CONTENT VARCHAR2(20)
)
TABLESPACE QDAS_DEFAULT;

ALTER TABLE IQS_QDAS_CONTENT_MAPPING MODIFY
(
	IQS_CLASS VARCHAR2(30)
);

ALTER TABLE IQS_QDAS_CONTENT_MAPPING MODIFY
(
	IQS_FIELD VARCHAR2(40)
);

CREATE TABLE IQS_FIELD_TO_FIELD_MAPPING
(
           IQS_CLASS_SOURCE VARCHAR2(30),
           IQS_FIELD_SOURCE VARCHAR2(40),
           IQS_CLASS_DEST VARCHAR2(30),
           IQS_FIELD_DEST VARCHAR2(40)
)
TABLESPACE QDAS_DEFAULT;

ALTER TABLE TEIL ADD
(
	TE_1094		VARCHAR2(24)
);
ALTER TABLE TEIL ADD
(
	TE_1095		VARCHAR2(40)
);
ALTER TABLE TEIL ADD
(
	TE_1096		NUMBER(10,0)
);


ALTER TABLE TEIL ADD
(
	TE_1019		NUMBER(10,0)
);

ALTER TABLE TEIL ADD
(
	TE_1798		NUMBER(10,0)
);

ALTER TABLE TEIL ADD
(
	TE_1799		VARCHAR2(3999)                      
);

ALTER TABLE UNTERS ADD
(
	USCODE		NUMBER(10,0)
);

ALTER TABLE UNTERS ADD
(
	USPRUEFORTNR		NUMBER(10,0)
);

ALTER TABLE UNTERS ADD
(
	USNSTMAX			NUMBER(10,0)
);

ALTER TABLE UNTERS ADD
(
    USFAELLIGMINUTEN                NUMBER(10,0)
);

ALTER TABLE UNTERS ADD
(
    USFAELLIGSTUECK                 NUMBER(10,0)
);


ALTER TABLE PLANT_STRUCT ADD
(
	NODE_FILTER_PART	VARCHAR2(255),
	NODE_FILTER_CHAR	VARCHAR2(255),
	NODE_FILTER_VALUE	VARCHAR2(255)
);

ALTER TABLE PRODUCT_STRUCT ADD
(
	NODE_FILTER_PART	VARCHAR2(255),
	NODE_FILTER_CHAR	VARCHAR2(255),
	NODE_FILTER_VALUE	VARCHAR2(255)
);

ALTER TABLE LAST_UPLOAD ADD
(
	SPU		NUMBER(10,0)
);

CREATE TABLE ALARMHIST
(
           TNR NUMBER(10,0),
           MMNR NUMBER(10,0),
           MWNR NUMBER(10,0),
           IDENT VARCHAR2(255)
)
TABLESPACE QDAS_DEFAULT;
create unique index ALARMHIST on ALARMHIST(TNR, MMNR, IDENT);

CREATE TABLE DATA_IMAGES
(
	IM_ID		RAW(16),
	IM_PARENT 	RAW(16),
	IM_PATH		VARCHAR2(80),
	IM_TYPE		NUMBER(3,0),
	IM_TREEDEPTH	NUMBER(3,0),
	IM_IMAGE	LONG RAW
)
TABLESPACE QDAS_DEFAULT;
CREATE UNIQUE INDEX DATA_IMAGES ON DATA_IMAGES(IM_ID);

ALTER TABLE TEIL MODIFY 
(
	TEMESSPROGNR	VARCHAR2(80)
);


ALTER TABLE WERKSTOF ADD
(
    WSALPHA				FLOAT,
    WSUALPHA				FLOAT
);


ALTER TABLE EMPB_3000_ZUS ADD (
	K3220	VARCHAR2(40),
	K3221	DATE
);

ALTER TABLE TEIL ADD
(
	TEGUID	RAW(16)
);

ALTER TABLE MERKMAL ADD
(
	MEGUID	RAW(16)
);

ALTER TABLE MERKMAL_MASTER ADD
(
	MEGUID	RAW(16)
);


create table EG_AEND_ZD
(
    EGTEIL                          NUMBER(10,0)                          ,
    EGMERKMAL                       NUMBER(5,0)                         ,
    EGUNTERS                        NUMBER(5,0)                         ,
    EGWERTNR                        NUMBER(10,0)                          ,
    EG_FIELDS                       VARCHAR2(20),
    EG_K0006                        VARCHAR2(50),
    EG_K0007                        NUMBER(10,0),
    EG_K0008                        NUMBER(10,0),
    EG_K0010                        NUMBER(10,0),
    EG_K0012                        NUMBER(10,0),
    EG_K0014                        VARCHAR2(50),
    EG_K0016                        VARCHAR2(50),
    EG_K0017                        VARCHAR2(50),
    EG_K0053                        VARCHAR2(50),
    EG_K0054                        VARCHAR2(50),
    EG_K0055                        VARCHAR2(50),
    EG_K0056                        VARCHAR2(50),
    EG_K0057                        VARCHAR2(50),
    EG_K0058                        VARCHAR2(50),
    EG_K0059                        VARCHAR2(50),
    EG_K0060                        VARCHAR2(50),
    EG_K0061                        NUMBER(10,0),
    EG_K0062                        NUMBER(10,0),
    EG_K0063                        NUMBER(10,0),
    EGCP                            FLOAT                        ,
    EGCPK                           FLOAT                        ,
    EGLAGART                        NUMBER(3,0)                          ,
    EGLAGSTREU                      NUMBER(3,0)                          ,
    EGLAGGRART                      NUMBER(3,0)                          ,
    EGPEARSON                       NUMBER(3,0)                          ,
    EGMINMAX                        FLOAT                        ,
    EGMITTELW                       NUMBER(3,0)                          ,
    EGCWERTGUE                      NUMBER(5,0)                         ,
    EGCAUSGZUL                      NUMBER(3,0)                          ,
    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                        NUMBER(3,0)                          ,
    EGCUNVBATR                      NUMBER(3,0)                          ,
    EGCOBATR                        NUMBER(3,0)                          ,
    EGCOBVBATR                      NUMBER(3,0)                          ,
    EGCATR                          NUMBER(3,0)                          ,
    EGCVBATR                        NUMBER(3,0)                          ,
    EGCKATR                         NUMBER(3,0)                          ,
    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                        NUMBER(3,0)                          ,
    EGSTRSTREU                      NUMBER(3,0)                          ,
    EGSTRBER                        NUMBER(3,0)                          ,
    EGSTRUEG                        FLOAT                        ,
    EGSTRMITTE                      FLOAT                        ,
    EGSTROEG                        FLOAT                        ,
    EGSTRUWG                        FLOAT                        ,
    EGSTROWG                        FLOAT                        ,
    EGSTRPQFSK                      FLOAT                        ,
    EGSTRNQFSK                      FLOAT                        ,
    EGDAT                           DATE                      ,
    EGMASCHINE                      NUMBER(10,0)                         ,
    EGNEST                          NUMBER(10,0)                         ,
    EGUGW                           FLOAT                        ,
    EGOGW                           FLOAT                        ,
    EGNENNMASS                      FLOAT                        ,
	EGLAGUIG		FLOAT	,
	EGLAGOIG		FLOAT	,
	EGSTRUIG		FLOAT	,
	EGSTROIG		FLOAT,
	EG_LEXL			FLOAT,
	EG_UEXL			FLOAT,
	EG_EXSTART		DATE,
	EG_EXEND		DATE,
	EG_EXVALID		NUMBER(3,0)
)
TABLESPACE QDAS_DEFAULT;

create index EGZ_TM
  on EG_AEND_ZD (EGTEIL, EGMERKMAL);


commit;