-- ============================================================ -- Use-Anweisung wird für MS SQL Server 7.0 und höher benötigt use QDAS GO -- ============================================================ -- Stand 2015-02-24 (TC) -- ============================================================ create table AG ( AGPLANNR float , AGNR smallint , AGAG varchar(20) , AGVERS varchar(10) , AGBEZ varchar(50) , AGMAT smallint , AGKOST smallint , AGMASCH smallint , AGMASSN varchar(50) , AGERST smallint , AGERSTDAT datetime , AGAENDER smallint , AGAENDERDAT datetime ) GO create table AUFTRGEB ( AULFDNR int , AUNR varchar(50) , AUNAME1 varchar(100) , AUNAME2 varchar(80) , AULAND varchar(50) , AUPLZ varchar(10) , AUORT varchar(50) , AUSTRASSE varchar(50) , AUPOSTFACH varchar(20) , AUWERK varchar(50) , AUWERKSSCHL varchar(50) , AUMEMO text , AUGSTATE int default 0 ) GO create table AUSPRAEG ( AUGROUP smallint , AUKEY smallint , AUTEXT varchar(50) ) GO create unique index AUSPRAEG on AUSPRAEG (AUGROUP, AUKEY) GO create table AUSPRAEGGRP ( AUGROUP smallint , AUGRPTEXT varchar(50) ) GO create unique index AUSPRAEGGRP on AUSPRAEGGRP (AUGROUP) GO create table BERART ( BEBERART smallint , BETEXT varchar(80) ) GO create table CHARGE ( CHTEIL int , CHMERKMAL smallint , CHUNTERS smallint , CHWERTVON int , CHWERTBIS int , CHCHARGENR varchar(30) ) GO create table CNF_PART ( CNNO smallint , CNNAME varchar(255) , CNPOS tinyint ) GO create unique index CNF_PART on CNF_PART (CNNO) GO create table EG_AEND ( EGTEIL int , EGMERKMAL smallint , EGUNTERS smallint , EGWERTNR int , EGCP float , EGCPK float , EGLAGART tinyint , EGLAGSTREU tinyint , EGLAGGRART tinyint , EGPEARSON tinyint , EGMINMAX float , EGMITTELW tinyint , EGCWERTGUE smallint , EGCAUSGZUL tinyint , EGCUN float , EGCUN_UN float , EGCUN_OB float , EGCOB float , EGCOB_UN float , EGCOB_OB float , EGC float , EGC_UN float , EGC_OB float , EGCUNATR tinyint , EGCUNVBATR tinyint , EGCOBATR tinyint , EGCOBVBATR tinyint , EGCATR tinyint , EGCVBATR tinyint , EGCKATR tinyint , EGLAGEMIN float , EGLAGEMAX float , EGLAGUEG float , EGLAGMITTE float , EGLAGOEG float , EGLAGUWG float , EGLAGOWG float , EGLAGUUNT float , EGLAGUOB float , EGP_F float , EGEW_F float , EGGS_F float , EGSAQRKGSF float , EGSTRART tinyint , EGSTRSTREU tinyint , EGSTRBER tinyint , EGSTRUEG float , EGSTRMITTE float , EGSTROEG float , EGSTRUWG float , EGSTROWG float , EGSTRPQFSK float , EGSTRNQFSK float , EGDAT datetime , EGMASCHINE int , EGNEST int , EGUGW float , EGOGW float , EGNENNMASS float , EGLAGUIG FLOAT , EGLAGOIG FLOAT , EGSTRUIG FLOAT , EGSTROIG FLOAT, EG_LEXL float, EG_UEXL float, EG_EXSTART datetime, EG_EXEND datetime, EG_EXVALID tinyint ) GO create unique index EG_AEND on EG_AEND (EGTEIL, EGMERKMAL, EGUNTERS, EGWERTNR) GO create table EINHEIT ( EIEINHEIT smallint , EIEINHTEXT varchar(100) , EISTATE int default 0, EIBEMERK VARCHAR(200) ) GO create table EREIG ( ERTEIL int , ERMERKMAL smallint , ERUNTERS smallint , ERWERTNR int , ERLFDNR tinyint , ERTEXTNR smallint , EREINFLUSS varchar(50) ) GO create unique index EREIG on EREIG (ERTEIL, ERMERKMAL, ERUNTERS, ERWERTNR, ERLFDNR) GO create index ERTEXTNR on EREIG (ERTEXTNR) GO create table EREIGTXT ( ETTEXTNR smallint , ETTEXT varchar(100) , ETCODE varchar(40) , ETSTATE int default 0, ETCAQKENNUNG varchar(10), ETBEMERK VARCHAR(200) ) GO create unique index EREIGTXT on EREIGTXT (ETTEXTNR) GO create index ETTEXT on EREIGTXT (ETTEXT) GO create table ERFART ( EAERFART tinyint , EAERFNAME varchar(80) , EAPORTNR smallint , EAPORTADDR smallint , EAIRQ smallint , EABAUD smallint , EAPARITY smallint , EADATABITS smallint , EASTOPBITS smallint ) GO create table ERFMASCH ( EMERFID smallint , EMERFTEXT varchar(80) ) GO create table FEHLKLAS ( FKFEHLART tinyint , FKBESCHR varchar(80) ) GO create table FERTART ( FTFERTART smallint , FTNR varchar(20) , FTBESCHR varchar(80) ) GO create table FSK ( FSTEIL int , FSLFDNR smallint , FSBEZEICH varchar(80) , FSUMFSTI tinyint , FSANZTEIL smallint , FSBEM text ) GO create table HERSTELL ( HELFDNR int , HENR varchar(50) , HENAME1 varchar(80) , HENAME2 varchar(80) , HELAND varchar(50) , HEPLZ varchar(10) , HEORT varchar(50) , HESTRASSE varchar(50) , HEPOSTFACH varchar(20) , HEWERK varchar(50) , HEWERKSSCHL varchar(50) , HEMEMO text , HESTATE int default 0 ) GO create table KUNDE ( KULFDNR int , KUNR varchar(50) , KUNAME1 varchar(80) , KUNAME2 varchar(80) , KULAND varchar(50) , KUPLZ varchar(10) , KUORT varchar(50) , KUSTRASSE varchar(50) , KUPOSTFACH varchar(20) , KUWERK varchar(50) , KUWERKSSCHL varchar(50) , KUMEMO text , KUSTATE int default 0 ) GO create table LIEFERAN ( LILFDNR int , LINR varchar(50) , LINAME1 varchar(80) , LINAME2 varchar(80) , LILAND varchar(50) , LIPLZ varchar(10) , LIORT varchar(50) , LISTRASSE varchar(50) , LIPOSTFACH varchar(20) , LIWERK varchar(50) , LIWERKSSCHL varchar(50) , LIMEMO text , LISTATE int default 0 ) GO create table MASCHINE ( MAMASCHINE int , MANR varchar(40) , MABEZ varchar(100) , MATYP smallint , MAHERST int , MABESCH text , MASTATE int default 0, MABEREICH VARCHAR(50), MAABT VARCHAR(50), MAOPNR VARCHAR(50), MAEXTREFNR VARCHAR(50) ) GO create unique index MASCHINE on MASCHINE (MAMASCHINE) GO create table MERKART ( MAMERKART tinyint , MAMERKTXT varchar(50) ) GO create unique index MERKART on MERKART (MAMERKART) GO create table MERKKLASS ( KLDPFLICHT tinyint , KLNR varchar(20) , KLBESCH varchar(80) ) GO create table NEST ( NENEST int , NEWERKZ float , NEBESCH varchar(80) , NESTATE int default 0, NEBEMERK VARCHAR(200) ) GO create unique index NEST on NEST (NENEST) GO create table PAUFTRAG ( PAPLAN int , PAAUFTRAG int , PAAUFTRAGNR varchar(40) , PAPAVERS varchar(20) , PABEZEICH varchar(100) , PAGRUND varchar(80) , PABEMERK text , PASTATUS tinyint , PAANMDAT datetime , PAANMBEN smallint , PAAENDDAT int , PAAENDBEN smallint , PABEGINN datetime , PAENDE datetime , PAABMDAT datetime , PAABMBEN smallint , PAPRUEFER smallint , PAPRUEFORT varchar(50) , PAPRUEFART varchar(50) , PAGUID UNIQUEIDENTIFIER , PASTATE int default 0, PAFAELLIGMINUTEN int default 0, PAFAELLIGSTUECK int default 0, PASTUECK int default 0, PAFAELLIGJETZT int default 0, PAALARMMINUTEN int default 0, PACHARGENR varchar(40), PAMASCHINE varchar(50), PAWERKZEUG varchar(50), PAWERKSTATT varchar(50) ) GO create unique index PAUFTRAG on PAUFTRAG (PAPLAN, PAAUFTRAG) GO create table PBENTSCH ( PENR smallint , PETEXT varchar(80) ) GO create table PMGRUPPE ( PGGRUPPE smallint , PGNR varchar(40) , PGBEZ varchar(80) ) GO create table PPLAN ( PPPLAN int , PPPLANNR varchar(40) , PPPPVERS varchar(20) , PPBEZEICH varchar(80) , PPTEIL int , PPKUNDE smallint , PPAUFTRAG smallint , PPGRUND varchar(80) , PPBEMERK text , PPERSTDAT int , PPERSTBEN varchar(20) , PPAENDDAT int , PPAENDBEN varchar(20) , PPSPEZ smallint , PPFERTORT smallint , PPGUID UNIQUEIDENTIFIER ) GO create unique index PPLAN on PPLAN (PPPLAN) GO create table PRODGRUP ( PGGRUPPE smallint , PGGRUPPENR varchar(40) , PGBEZ varchar(80) , PGBESCH text ) GO create table PRODUKT ( PRPROD int , PRPRODNR varchar(40) , PRBEZ varchar(80) , PRBESCH text ) GO create table PRUEFART ( PAART smallint , PATEXT varchar(80) ) GO create table PRUEFBER ( PBPRUEFBER int , PBNR varchar(20) , PBVERSION varchar(20) , PBART smallint , PBERSDATUM datetime , PBERSTELLE varchar(50) , PBAENDATUM datetime , PBAENDERER varchar(50) , PBABTEILUNG varchar(50) , PBLIEFERNR int , PBABNEHMNR int ) GO create table PRUEFER ( PRPRUEFER int , PRNAME varchar(50) , PRVORNAME varchar(50) , PRABT varchar(50) , PRTELEFON varchar(50) , PRFAX VARCHAR(50), PREMAIL VARCHAR(50), PRPOS VARCHAR(30), PRANREDE VARCHAR(15), PRSTATE int default 0, PRBEMERK VARCHAR(200) ) GO create unique index PRUEFER on PRUEFER (PRPRUEFER) GO create table PRUEFMIT ( PMPRUEFMIT int , PMNR varchar(40) , PMBEZ varchar(80) , PMGRUPPE smallint , PMPRUEFNAME varchar(20) , PMLETZTDAT datetime , PMNAECHDAT datetime , PMLAGERORT varchar(40) , PMEINSORT varchar(50) , PMBESITZER varchar(50) , PMINTERVAL tinyint , PMZEITRAUM smallint , PMLIEFERAN int , PMHERSTELL int , PM_BEST_NR varchar(20) , PM_GARANTI smallint , PM_PREIS float , PM_BESCH text , PMSTATE int default 0, PMIPADDR VARCHAR(30), PMCOMP VARCHAR(50), PMQVERS VARCHAR(30), PMSOFTW VARCHAR(50) ) GO create unique index PRUEFMIT on PRUEFMIT (PMPRUEFMIT) GO create table PVORGANG ( PVPLAN int , PVAUFTRAG int , PVVORGANG smallint , PVVORGANGNR varchar(40) , PVBEZEICH varchar(80) , PVBEMERK text , PVDATZEIT datetime , PVANMDAT datetime , PVANMBEN smallint , PVAENDDAT datetime , PVAENDBEN smallint , PVBEGINN datetime , PVENDE datetime , PV_PAGUID UNIQUEIDENTIFIER, PV_GUID UNIQUEIDENTIFIER, PV_MODUL smallint , PV_SUBTYPE smallint , PV_STATUS smallint, PV_BUTTONLEISTE VARCHAR(255) ) GO create unique index PVORGANG on PVORGANG (PVPLAN, PVAUFTRAG, PVVORGANG) GO create table SCHICHT ( SCSCHICHT smallint , SCNR varchar(20) , SCBESCHR varchar(80) , SCSTART varchar(8) , SCENDE varchar(8) ) GO create table STATUS ( STATUSNR smallint , STATUSTEXT varchar(50) ) GO create unique index STATUS on STATUS (STATUSNR) GO create table STEUCODE ( ACSTCODE int , ACBESCHR varchar(255) ) GO create table TEIL ( TETEIL int , TETEILNR varchar(30) , TEBEZEICH varchar(80) , TEDPFLICHT smallint , TEBEM text , TEHERSTELLERNR varchar(20) , TEHERSTELLERBEZ varchar(80) , TEWERKSTOFFNR varchar(20) , TEWERKSTOFFBEZ varchar(80) , TEZEICHNUNGNR varchar(30) , TEZEICHNUNGAEND varchar(20) , TEZEICHNUNGINDEX varchar(80) , TEAUFTRAGSTR varchar(40) , TEAUFTRAGGBNR varchar(20) , TEAUFTRAGGBBEZ varchar(80) , TEKUNDENR varchar(20) , TEKUNDEBEZ varchar(80) , TELIEFERANTNR varchar(20) , TELIEFERANTBEZ varchar(80) , TEPREINRNR varchar(24) , TEPREINRBEZ varchar(80) , TEPRGRUNDBEZ varchar(80) , TEPRBEGINNSTR varchar(40) , TEPRENDESTR varchar(40) , TEKURZBEZEICH varchar(20) , TEAENDSTAND varchar(20) , TEERZEUGNIS varchar(40) , TEMASCHINENR varchar(24) , TEMASCHINEBEZ varchar(40) , TEMASCHINEORT varchar(40) , TEARBEITSGANG varchar(40) , TEBEREICH varchar(40) , TEABT varchar(40) , TEPRPLATZ varchar(40) , TEPPLANERST varchar(40) , TEHERSTELLERKEY int , TEWERKSTOFFKEY int , TEZEICHNUNGKEY int , TEAUFTRAGGBKEY int , TEKUNDEKEY int , TELIEFERANTKEY int , TEMASCHINEKEY int , TEPREINRKEY int , TEKONFIG varchar(1000) , TENRKURZ varchar(20) , TEWERKSTATT VARCHAR(40), TEREFTEIL VARCHAR(10), TENORMNR VARCHAR(40) , TENORMBEZ VARCHAR(40) , TENORMAL smallint, TEERZEUGNISKEY int, TETYP VARCHAR(20), TECODE VARCHAR(20), TEVARIANTE VARCHAR(20), TESACHNRZUS VARCHAR(20), TESACHNRIDX VARCHAR(20), TETEILIDENT VARCHAR(20), TEKOSTST VARCHAR(40), TESCHICHT VARCHAR(20), TEBESTNR VARCHAR(20), TEWARENEINNR VARCHAR(20), TEWUERFEL VARCHAR(20), TEPOSITION VARCHAR(20), TEVORRICHT VARCHAR(40), TEFERTDAT VARCHAR(40), TEPRUEFART VARCHAR(20), TEMESSRAUM VARCHAR(40), TEMESSPROGNR VARCHAR(80), TEMESSPROGVER VARCHAR(20), TEPRUEFERKEY int, TEPRUEFERNR VARCHAR(20), TEPRUEFERNAME VARCHAR(40), TEFREIFELD tinyint, -- neu für EMPB TEZSB_1016 varchar(30), TEREPORTFILE_1350 varchar(60), -- TE_1045 varchar(20), TE_1046 varchar(80), TE_1047 varchar(20), TE_1300 int, TE_1301 smallint, TE_1302 varchar(40), TE_1311 varchar(40), TE_1341 varchar(20), TE_1342 varchar(40), TE_1343 varchar(20), TEWERK varchar(40), TEMESSTYP int, TE_1344 varchar(50), TE_1015 smallint, TE_1017 tinyint, TE_1087 VARCHAR(40), TE_1018 int, TE_1401 int, TE_1402 int, TE_1403 int, TE_1404 int, TE_1405 int, TE_1407 int, TE_1408 int, TE_1410 varchar(255), TE_1411 int, TE_1091 VARCHAR(20), TE_1092 VARCHAR(40), TE_1105 VARCHAR(20), TE_1106 VARCHAR(20), TE_1107 VARCHAR(20), TE_1108 VARCHAR(20), TE_1304 VARCHAR(20), TE_1048 VARCHAR(80), TE_1412 int, TE_1413 float, TE_1414 int, TE_1415 tinyint, TE_1094 varchar(24), TE_1095 varchar(40), TE_1096 int, TE_1019 int, TE_1798 int, TE_1799 text, TEGUID UNIQUEIDENTIFIER ) GO create unique index TEIL on TEIL (TETEIL) GO create table TEILKETT ( TKTEIL int , TKFOLGTEIL int , TKBESCHR varchar(80) ) GO create unique index TEILKETT on TEILKETT (TKTEIL, TKFOLGTEIL) GO create table TMFREIFELD ( TMTEIL int , TMMERKMAL smallint, TMKEY smallint, TMBEZ VARCHAR(50) , TMTYP VARCHAR(1) , TMINHALT VARCHAR(255) ) GO create unique index TMFREIFELD on TMFREIFELD (TMTEIL,TMMERKMAL,TMKEY) GO create table TMP_DAT ( MINDAT datetime , MAXDAT datetime ) GO create table TMP_WERTNR ( TEILNR int , MERKMALNR smallint , WERTNR int ) GO create table UAUSWERT ( AWTEIL int , AWMERKMAL smallint , AWUNTERS smallint , AWNR int , AWSTCODE int , AWWERT float , AWTEXT varchar(80) ) GO create table UNTERS ( USTEIL int, USMERKMAL smallint, USUNTERS smallint, USPLAN int, USAUFTRAG int, USVORGANG smallint, USUNTERSNR varchar(20), USBEZEICHN varchar(80), USART smallint, USVERDICHT smallint, USURWERT smallint, USERFASS tinyint, USCODE int, USPRUEFORTNR int, USNSTMAX int, USFAELLIGMINUTEN int, USFAELLIGSTUECK int ) GO create unique index UNTERS on UNTERS (USTEIL, USMERKMAL, USUNTERS) GO create table USERINI ( USERNAME varchar(50) , USERSECTION varchar(255) , USERENTRY varchar(255) , USERVALUE varchar(255) ) GO create unique index USERINI on USERINI (USERNAME, USERSECTION, USERENTRY) GO create index SectionKey on USERINI (USERNAME, USERSECTION) GO create table UVERDICH ( UVTEIL int , UVMERKMAL smallint , UVUNTERS smallint , UVVERDICHT int , UVWERTVON int , UVWERTBIS int , UVZEITVON varchar(12) , UVZEITBIS varchar(12) , UVPRDATVON varchar(12) , UVPRDATBIS varchar(12) , UVSTPRUMF int , UVANZSTPR int , UVWERTINT int , UVZEITEINH varchar(50) ) GO create table VERTFORM ( VFNR smallint , VFTVERT varchar(80) ) GO create unique index VERTFORM on VERTFORM (VFNR) GO create table WECHSWIR ( WWTEIL int , WWMERKMAL smallint , WWZUORD varchar(80) ) GO create table WERKSTOF ( WSLFDNR int , WSNR varchar(50) , WSBEZEICH varchar(100) , WSSTATE int default 0, WSBEMERK VARCHAR(200), WSALPHA float, WSUALPHA float ) GO create table WERKZEUG ( WEWERKZ int , WENR varchar(100) ) GO create unique index WERKZEUG on WERKZEUG (WEWERKZ) GO create table WERTEATT ( WATEIL int , WAMERKMAL smallint , WAUNTERS smallint , WAWERTNR int , WAUMFANG int , WAKLUGW int , WAGROGW int , WAATTRIBUT smallint , WAPRUEFER smallint , WAPRUEFMIT smallint , WAMASCHINE smallint , WANEST smallint , WADATZEIT datetime , WASTIANF tinyint , WACHARGE varchar(30) , WAAUFTRAG VARCHAR(20) ) GO create unique index WERTEATT on WERTEATT (WATEIL, WAMERKMAL, WAUNTERS, WAWERTNR) GO create index WAATTRIBUT on WERTEATT (WAATTRIBUT) GO create index WACHARGE on WERTEATT (WACHARGE) GO create index WADATZEIT on WERTEATT (WADATZEIT) GO create index WAMASCHINE on WERTEATT (WAMASCHINE) GO create index WAMERKMAL on WERTEATT (WAMERKMAL) GO create index WANEST on WERTEATT (WANEST) GO create index WAPRUEFER on WERTEATT (WAPRUEFER) GO create index WAPRUEFMIT on WERTEATT (WAPRUEFMIT) GO create index WAAUFTRAG on WERTEATT (WAAUFTRAG) GO create index WATEIL on WERTEATT (WATEIL) GO create table WERTEVAR ( WVTEIL int , WVMERKMAL smallint , WVUNTERS smallint , WVWERTNR int , WVWERT float , WVATTRIBUT smallint , WVPRUEFER int , WVPRUEFMIT int , WVMASCHINE int , WVNEST int , WVDATZEIT datetime , WVSTIANF tinyint , WVCHARGE varchar(30) , WVAUFTRAG VARCHAR(20), WV0005 VARCHAR(35) -- ,WV0031 UNIQUEIDENTIFIER ) GO create unique index WERTEVAR on WERTEVAR (WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR) GO create unique index WVTMW on WERTEVAR (WVTEIL, WVMERKMAL, WVWERTNR) GO create index WVATTRIBUT on WERTEVAR (WVATTRIBUT) GO create index WVCHARGE on WERTEVAR (WVCHARGE) GO create index WVDATZEIT on WERTEVAR (WVDATZEIT) GO create index WVMASCHINE on WERTEVAR (WVMASCHINE) GO -- create index WVMERKMAL on WERTEVAR (WVMERKMAL) -- GO create index WVNEST on WERTEVAR (WVNEST) GO create index WVPRUEFER on WERTEVAR (WVPRUEFER) GO create index WVPRUEFMIT on WERTEVAR (WVPRUEFMIT) GO -- create index WVTEIL on WERTEVAR (WVTEIL) -- GO create index WVAUFTRAG on WERTEVAR (WVAUFTRAG) GO create index WV0005 on WERTEVAR (WV0005) GO create table WERTTXT ( WTTEIL int , WTMERKMAL smallint , WTUNTERS float , WTWERTNR int , WTTEXT text ) GO create unique index WERTTXT on WERTTXT (WTTEIL, WTMERKMAL, WTUNTERS, WTWERTNR) GO create table ZEICHN ( ZNTEIL int , ZNZNR varchar(40) , ZNZNRindex varchar(100) , ZNDATEI varchar(50) , ZNSTATE int default 0, ZNBEMERK VARCHAR(200) ) GO create table ZU_AG_ME ( ZUPPLANNR float , ZUAGNR smallint , ZUTEIL smallint , ZUMERKMAL smallint ) GO create table ZU_ME_PA ( MATEIL int , MAMERKMAL smallint , MAPPLAN varchar(20) , MAPPVERS varchar(40) , MAPAUFTRAG varchar(20) , MAPAVERS varchar(40) , MAPRUEFMIT smallint , MABEZEICHN varchar(50) , MABEMERK text ) GO create table ZU_ME_PP ( MPTEIL int , MPMERKMAL smallint , MPPPLAN varchar(20) , MPPPVERS varchar(40) , MPGRUPPE smallint , MPSTPLAN tinyint , MPWICHTUNG tinyint , MPBEZEICHN varchar(50) , MPBEMERK text ) GO create table ZU_PA_MA ( PMPLAN int , PMAUFTRAG int , PMMASCHINE smallint ) GO create unique index ZU_PA_MA on ZU_PA_MA (PMPLAN, PMAUFTRAG, PMMASCHINE) GO create table ZU_PR_PG ( PPGRUPPE int , PPPROD int ) GO create table ZU_PV_ME ( MVPLAN int , MVAUFTRAG int , MVVORGANG smallint , MVTEIL int , MVMERKMAL smallint ) GO create unique index ZU_PV_ME on ZU_PV_ME (MVPLAN, MVAUFTRAG, MVVORGANG, MVTEIL, MVMERKMAL) GO create table ZU_TE_AU ( TATEIL smallint , TAAUFTRAG int , TAAUFTRNR varchar(50) , TAAUFTRDAT datetime , TATEILNR varchar(40) , TATEILBEZ varchar(80) ) GO create table ZU_TE_HE ( THTEIL smallint , THHERST int , THTEILNR varchar(40) , THTEILBEZ varchar(80) ) GO create table ZU_TE_KU ( TKTEIL smallint , TKKUNDE int , TKBESTNR varchar(50) , TKBESTDAT datetime , TKBESTNAME varchar(50) , TKTEILNR varchar(40) , TKTEILBEZ varchar(80) ) GO create table ZU_TE_LI ( TLTEIL smallint , TLLIEF int , TKBESTNR varchar(50) , TKBESTDAT datetime , TKBESTNAME varchar(50) , TKTEILNR varchar(40) , TKTEILBEZ varchar(80) ) GO create table ZU_TE_MA ( TMTEIL int , TMMASCHINE smallint ) GO create unique index ZU_TE_MA on ZU_TE_MA (TMTEIL, TMMASCHINE) GO create table ZU_TE_PP ( TPTEIL int , TPPLAN int ) GO create unique index ZU_TE_PP on ZU_TE_PP (TPTEIL, TPPLAN) GO create table ZU_TE_PR ( TPTEIL int , TPPROD int ) GO create table ZU_TE_WE ( TWTEIL int , TWSTOFF int ) GO create table ZU_US_PB ( UBTEIL int , UBMERKMAL smallint , UBUNTERS smallint , UBPRUEFBER int , UBENTSCH smallint , UBMEMO text ) GO create table ZU_US_SELECT ( USERNO smallint , CNNO smallint ) GO create unique index ZU_US_SELECT on ZU_US_SELECT (USERNO, CNNO) GO create table ZU_W_T_L ( WTLTEIL int , WTLSTOFF int , WTLLIEFER int ) GO create table ZUSTAEND ( ZUSTNR smallint , ZUSTTEXT varchar(80) ) GO create unique index ZUSTAEND on ZUSTAEND (ZUSTNR) GO create table ZYKLUS ( ZYNR smallint , ZYTXT varchar(50) ) GO create unique index ZYKLUS on ZYKLUS (ZYNR) GO create table USERLOCK ( LCTEIL int , LCUSER varchar(90) ) GO create unique index USERLOCK on USERLOCK (LCTEIL) GO create table DB_VERSION ( VERSION VARCHAR(10) ) GO Insert INTO DB_VERSION VALUES('8.0') GO create table ABT ( ABTKEY Smallint , ABTNR VARCHAR(40) , ABTNAME VARCHAR(80) ) GO create unique index ABT on ABT (ABTKEY) GO create table BEREICH ( BEKEY Smallint , BEREICHNR VARCHAR(40) , BEREICHNAME VARCHAR(80) ) GO create unique index BEREICH on BEREICH (BEKEY) GO create table KOSTST ( KOKEY Smallint , KONR VARCHAR(40) , KONAME VARCHAR(80) ) GO create unique index KOSTST on KOSTST(KOKEY) GO create table ZU_BE_TE ( TEBER Smallint , TEABT Smallint , TEKOSTST Smallint , TETEIL int , TEMASCHINE Smallint ) GO create unique index ZU_BE_TE on ZU_BE_TE(TEBER,TEABT,TEKOSTST) GO create table ZU_UR_ERG ( URTEIL VARCHAR(10) , URMERKMAL VARCHAR(10) , URUNTERS VARCHAR(50) , URERGEBNIS VARCHAR(20) , ZIELTEIL VARCHAR(10) , ZIELMERKMAL VARCHAR(10) , ZIELUNTERS VARCHAR(20) ) GO create unique index ZU_UR_ERG on ZU_UR_ERG(URTEIL,URMERKMAL,URUNTERS,URERGEBNIS) GO create table EREIGKAT ( EKNR int , EKTEXT VARCHAR(100) ) GO create unique index EREIGKAT on EREIGKAT(EKNR) GO create table ZU_ET_EK ( ETTEXTNR int , EKNR int ) GO create unique index ZU_ET_EK on ZU_ET_EK(ETTEXTNR,EKNR) GO create table PROZPARAM ( PPTEIL int , PPMERKMAL int , PPUNTERS int , PPWERTNR int , PPLFDNR int , PPTEXTNR int , PPPPWERTNR int , PPEINFLUSS VARCHAR(50) ) GO create unique index PROZPARAM on PROZPARAM(PPTEIL,PPMERKMAL,PPUNTERS,PPWERTNR,PPLFDNR) GO create table PROZPARAMTXT ( PPNR int , PPNRTEXT VARCHAR(40) , PPKURZTEXT VARCHAR(20) , PPLANGTEXT VARCHAR(100) , PPSTATE int default 0, PPBEMERK VARCHAR(200) ) GO create unique index PROZPARAMTXT on PROZPARAMTXT(PPNR) GO create table PROZPARAMKAT ( PPKNR int , PPKTEXT VARCHAR(100) ) GO create unique index PROZPARAMKAT on PROZPARAMKAT(PPKNR) GO create table ZU_PP_PPK ( PPNR int , PPKATNR int ) GO create unique index ZU_PP_PPK on ZU_PP_PPK(PPNR,PPKATNR) GO create table PROZPARAMWERT ( PPWNR int , PPWPPNR int , PPWNRTEXT VARCHAR(40) , PPWERTTEXT VARCHAR(100) ) GO create unique index PROZPARAMWERT on PROZPARAMWERT(PPWNR) GO create table USER1 ( USERNO smallint , USERGROUP smallint , USERNAME varchar(50) , PASSWORD varchar(20) , USINIDAT varchar(50) , USHIERA smallint , USBEREICH int , USABT int , USWERKSTATT int , USNAME varchar(50) , USFIRMA varchar(50) , USABTNAME varchar(50) , USFON varchar(50) , USFAX varchar(50) , USMAIL varchar(50) , USZUS int ) GO create unique index USER1 on USER1(USERNO) GO create table USERGROUP ( GROUPNO smallint , GROUPNAME varchar(50) ) GO create unique index USERGROUP on USERGROUP(GROUPNO) GO create table ZUGRECHTE ( ZRUSERGROUP int , ZRMESSWEIN varchar(50) , ZRMESSWAEND varchar(50) , ZRPRPLEIN varchar(50) , ZRPRPLAEND varchar(50) , ZRAUSWLES varchar(50) , ZRSYSKONF varchar(50) , ZROPTIONAL varchar(250) ) GO create unique index ZUGRECHTE on ZUGRECHTE(ZRUSERGROUP) GO create table HIERARCHIE ( HINR smallint , HIBEZ varchar(50) ) GO Insert INTO HIERARCHIE VALUES(1,'bereichsübergreifend') GO Insert INTO HIERARCHIE VALUES(2,'Bereichsleiter') GO Insert INTO HIERARCHIE VALUES(3,'Abteilungsleiter') GO Insert INTO HIERARCHIE VALUES(4,'Werkstattleiter') GO Insert INTO HIERARCHIE VALUES(5,'Bediener vor Ort') GO create table ERZEUGNIS ( EZERZEUGNIS int, EZNUMMER VARCHAR(20) , EZBEZ VARCHAR(80) , EZKUNDE int, EZSTATE int default 0, EZBEMERK VARCHAR(200) ) GO create unique index ERZEUGNIS on ERZEUGNIS (EZERZEUGNIS) GO create table MERKMAL ( METEIL int , MEMERKMAL smallint , MEMERKNR varchar(20) , MEMERKBEZ varchar(80) , MENENNMAS float , MEARTUGW smallint , MEARTOGW smallint , MEARTPLAUSIUNT smallint , MEARTPLAUSIOB smallint , MEUGW float , MEOGW float , MEFSK smallint , MEFEHLART tinyint , MEFEHLKOST float , MEDPFLICHT smallint , MEEINHEIT int , MEAUFLOES smallint , MEKLASSENW float , MEFERTARTNR varchar(20) , MEPMGRUPPE int , MEPRUEFMIT int , MEPRUEFMITNR int , MEERFART smallint , MEMASCHINE int , MEBEMERK text , MESTIFREQ smallint , MEUMFSTICH smallint , MEANZSTICH int , MEANZMESSGC int , MEANZPRUEF int , MEUMFPROZ smallint , MEANZWIED smallint , MEANZTEILE int , METOLERANZ smallint , METRANSART tinyint , METRANSPA float , METRANSPB float , METRANSPC float , METRANSPD float , MEGLMITT smallint , MEAUSWART smallint , MEAUSWTYP smallint , MEMERKART smallint , MEVERTFORM smallint , MEPLAUSIOB float , MEPLAUSIUN float , MEPROSTREUSTR varchar(40) , MEPROSTREU float , MENORMISTSTR varchar(80) , MENORMIST float , -- MENORMNR varchar(20) , MENORMNR varchar(40) , MENORMBEZ varchar(40) , MENORMTEMP varchar(40) , MEKLASSUNT float , MEKLASSOB float , MEKLASSNR float , MEVORGCP float , MEVORGCPK float , MESTEUERB tinyint , MEZYKLUS smallint , MEPRUEFZST smallint , MEPRUEFORT smallint , MEMASSN smallint , MEPRFSPEC smallint , MEAUTOAKT smallint , MEMERKKLASSE smallint , MEUNTERSART smallint , MEANZORDKLASSE smallint , MEGLEITSTUMF smallint , MEPUFFERSIZE smallint , MEAUTOERKENNUNG smallint , MEATTR smallint , METRANSFEING smallint , METRANSFEINGA float , METRANSFEINGB float , MENLINKSMA smallint , MEERFKANAL varchar(20) , MEERFSUBKANAL varchar(20) , MENACHARBEIT smallint , MEZIELWERT float , MEZIELWERTT float , MEPMAX float , MELOSUMFANG int , MEKOSTENNACHARBEIT float , MEKOSTENAUSSCHUSS float , MEMASCHNR varchar(24) , MEABT varchar(40) , MEAUFTRAGGEBNR int , MEAUFTRAGGEBNRT varchar(20) , MEPRUEFER int , MEPRUEFERNR varchar(20) , MEAUGROUP smallint , MEUPPERMERKMAL smallint , MEWERKSTCK int , MEPMAUFLOES float , MEPRUEFBEGINND datetime , MEPRUEFENDED datetime , MENORMAL smallint , MENORMALTEMP float , MEWERKSTCKNR varchar(20), MEKURZBEZ varchar(20), MEUGSCHROTT FLOAT, MEOGSCHROTT FLOAT, MECG FLOAT, MECGK FLOAT, MEABWGC FLOAT, MEFERTARTKEY int, MEPMHERST varchar(40), MEKORRSTRAT smallint, MEUKG FLOAT, MEOKG FLOAT, MEKORRZIEL FLOAT, MEERFNR smallint, MEERFNAME varchar(40), MEERFINDEX smallint, MEANFINDEX smallint, MEINTERFACE smallint, MEBAUD int, MEIRQ smallint, MEPARITY smallint, MEDATA smallint, MESTOP smallint, MEPZPKAT smallint, METOLERANZCALC FLOAT, MEBEREICH varchar(40), MEPTM varchar(40), MEPPLANNRT varchar(20), MEPPLAN varchar(40), MEPPLANDAT varchar(20), MEPPLANERST varchar(40), MESPCNR varchar(20), MESPCHERST varchar(40), MESPCTYP varchar(20), MECP FLOAT, MECPK FLOAT, MECPFIX FLOAT, MECPKFIX FLOAT, MEGAGE25 VARCHAR(110) , MEEINHREL VARCHAR(20) , MEADDFAKREL FLOAT , MEMULFAKREL FLOAT , MENORMISTUN FLOAT , MENORMISTOB FLOAT , MEFERTART varchar(80) , MEPMGRUPPET varchar(80) , MEPRUEFMITT varchar(80) , MEPRUEFMITNRT varchar(80) , MEEINHEITTEXT varchar(80) , MEMASCHBEZ varchar(80) , MESTANDORT varchar(80) , MEAUFTRNR varchar(80) , MEAUFTRAGGEB varchar(80) , MEPRUEFORTT varchar(80) , MEPRUEFBEGINN varchar(80) , MEPRUEFENDE varchar(80) , MEPRUEFERNAME varchar(80) , METOLERANZTEXT varchar(80) , MEWERKSTCKTEXT varchar(80) , MEANZSPTEXT varchar(80) , MESTIFREQT varchar(80) , MEZEICHN varchar(80) , MENENNMAST varchar(50) , MEUGWT varchar(50) , MEOGWT varchar(50) , MEPLAUSIUT varchar(50) , MEPLAUSIOT varchar(50) , MEFORMEL varchar(255) , MEKONFIG varchar(1000) , MEEREIGKAT varchar(50) , MENENNMASSP varchar(50) , MEPRUEFBEDING varchar(255) , -- ) -- GO -- -- create table MERKMAL_AD -- ( -- METEIL int , -- MEMERKMAL smallint , MENORMALSERNR VARCHAR(20), MEPRUEFMITSERNR VARCHAR(20), MEANZGERAET VARCHAR(40), MEREFTEILNRSTR VARCHAR(20), MEREFTEILBEZ VARCHAR(40), MEREFTEILIST FLOAT, MEREFTEILTEMP FLOAT, MEREFTEILNR smallint, MEREFTEILSERNR VARCHAR(20), MEKALTEILUNRSTR VARCHAR(20), MEKALTEILUBEZ VARCHAR(40), MEKALTEILUIST FLOAT, MEKALTEILUTEMP FLOAT, MEKALTEILUNR smallint, MEKALTEILUSERNR VARCHAR(20), MEKALTEILMNRSTR VARCHAR(20), MEKALTEILMBEZ VARCHAR(40), MEKALTEILMIST FLOAT, MEKALTEILMTEMP FLOAT, MEKALTEILMNR smallint, MEKALTEILMSERNR VARCHAR(20), MEKALTEILONRSTR VARCHAR(20), MEKALTEILOBEZ VARCHAR(40), MEKALTEILOIST FLOAT, MEKALTEILOTEMP FLOAT, MEKALTEILONR smallint, MEKALTEILOSERNR VARCHAR(20), MEUEBERKAN smallint, MEMERKCODE VARCHAR(40), MEMERKINDEX VARCHAR(20), MEMERKTEXT VARCHAR(50), MEBEARBZUST VARCHAR(80), MEELEMCODE VARCHAR(40), MEELEMINDEX VARCHAR(20), MEELEMTEXT VARCHAR(50), MEELEMADR VARCHAR(20), MEFREIFELD tinyint, MECALIBADD FLOAT, MECALIBMULT FLOAT, MEANZNIAUSGEF int, MEGCKONVART tinyint, MEANZREF smallint, MEREFPKTX smallint, MEREFPKTY smallint, MEREFPKTZ smallint, -- neu für EMPB ME_2430 smallint, ME_2432 smallint, ME_2434 smallint, ME_2436 varchar(10), ME_2438 varchar(10), ME_2440 varchar(40), ME_2442 varchar(15), ME_2444 varchar(40), ME_2446 varchar(40), ME_2448 varchar(40), ME_8530 smallint, ME_8531 float, ME_8532 float, ME_8540 smallint, -- ME_2073 float, ME_2107 float, ME_2170 float, ME_2171 float, ME_2172 float, ME_2173 float, ME_2228 float, ME_2229 float, ME_2230 float, ME_2231 float, ME_2232 float, ME_2233 float, ME_2235 float, ME_2236 float, ME_2016 tinyint, MEMASTERGUID UNIQUEIDENTIFIER, MEGUID UNIQUEIDENTIFIER ) GO create unique index MERKMAL on MERKMAL (METEIL, MEMERKMAL) GO create table MERKMAL_ZUS ( METEIL int , MEMERKMAL smallint , ME_2601 tinyint , ME_2605 varchar(255) , ME_2610 int , ME_2611 FLOAT , ME_2612 FLOAT , ME_2613 FLOAT , ME_2615 float, ME_2617 FLOAT , ME_2618 FLOAT , ME_2619 FLOAT , ME_2630 FLOAT , ME_2631 FLOAT , ME_2640 FLOAT , ME_2641 FLOAT , ME_2642 FLOAT , ME_2643 FLOAT , ME_2644 int , ME_2645 int , ME_2646 int , ME_2647 int , ME_2648 varchar(255) , ME_2700 tinyint , ME_2711 FLOAT , ME_2712 FLOAT , ME_2713 FLOAT , ME_2714 FLOAT , ME_2174 int , ME_2505 VARCHAR(20) , ME_2506 int , ME_2507 VARCHAR(2) , ME_2508 int , ME_2509 VARCHAR(40) , ME_2511 VARCHAR(20) , ME_2512 VARCHAR(20) , ME_2513 VARCHAR(20) , ME_2514 VARCHAR(20) , ME_2515 VARCHAR(20) , ME_2516 VARCHAR(20) , ME_2517 VARCHAR(20) , ME_2518 VARCHAR(20) , ME_2519 VARCHAR(20) , ME_2520 VARCHAR(20) , ME_2521 FLOAT , ME_2522 FLOAT , ME_2523 FLOAT , ME_2524 VARCHAR(20) , ME_2175 tinyint , ME_2176 tinyint , ME_2177 FLOAT , ME_2178 FLOAT , ME_2180 FLOAT , ME_2181 FLOAT , ME_2182 FLOAT , ME_2183 FLOAT , ME_2185 int , ME_2186 FLOAT , ME_2720 tinyint , ME_2723 tinyint , ME_2724 FLOAT , ME_2725 FLOAT , ME_2733 tinyint , ME_2734 FLOAT , ME_2735 FLOAT , ME_2736 FLOAT , ME_2737 FLOAT , ME_2738 FLOAT , ME_2740 FLOAT , ME_2741 int , ME_2743 tinyint , ME_2744 FLOAT , ME_2745 FLOAT , ME_2746 FLOAT , ME_2525 VARCHAR(255) , ME_2526 VARCHAR(255) , ME_2650 tinyint, ME_2651 FLOAT, ME_2652 tinyint, ME_2654 tinyint, ME_2655 tinyint, ME_2656 int, ME_2657 int, ME_2658 int, ME_2660 tinyint, ME_2062 int, ME_2063 int, ME_2064 int, ME_2065 int, MEANZMESSV int, MEANZSTAB int, ME_2190 VARCHAR(10), ME_2066 int, ME_2067 int, ME_2068 int, 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, ME_2028 tinyint, ME_2614 int, ME_2632 float, ME_2633 float, ME_2739 float, ME_8524 float, ME_8525 float, ME_2417 int ) GO create unique index MERKMAL_ZUS on MERKMAL_ZUS(METEIL, MEMERKMAL) GO -- create unique index MERKMAL_AD on MERKMAL_AD (METEIL, MEMERKMAL) -- GO -- create index METEIL1 on MERKMAL1 (METEIL) -- GO -- create index METEIL2 on MERKMAL2 (METEIL) -- GO -- create index METEIL3 on MERKMAL3 (METEIL) -- GO -- create index METEIL_AD on MERKMAL_AD (METEIL) -- GO create table NIO ( NIOTEIL int, NIOCHARGE VARCHAR(20), NIOAUFTRAG VARCHAR(30) ) GO create unique index NIO on NIO(NIOTEIL,NIOCHARGE,NIOAUFTRAG) GO -- Neue Tabellen create table LASTIDENT ( LITEIL int, LIDENT int ) GO create unique index LASTIDENT on LASTIDENT(LITEIL) GO create table NENNMASS ( NMARTIKEL int, NMMERKMAL int, NMARBEITSGANG VARCHAR(40), NMNENNMASS FLOAT ) GO create unique index NENNMASS on NENNMASS(NMARTIKEL, NMMERKMAL, NMARBEITSGANG) GO create table ERGEBNIS ( ETEIL int, EMERKMAL int, EMODUL smallint, EAUSGAPUNKT VARCHAR(20), EERGEBNIS FLOAT, EERGEBNISSTR VARCHAR(30), ESTARTDAT datetime, EENDDAT datetime, EPRUEFER int, EPRUEFMIT int, EMASCHINE int, ENEST int, ECHARGE VARCHAR(20), EAUFTRAG VARCHAR(20), EANZWERTE int, EZUSDATLIST VARCHAR(50), ESTRATEGY int ) GO create index ERGEBNIS on ERGEBNIS (ETEIL, EMERKMAL, EMODUL) GO create index EAUFTRAG on ERGEBNIS (EAUFTRAG) GO create table BUILDPHASE ( BPKEY int, BPNAME VARCHAR(20) ) GO create unique index BUILDPHASE on BUILDPHASE(BPKEY) GO create table ERGEBZEITRAUM ( EZTEIL int, EZMODUL smallint, EZAUSGAPUNKT VARCHAR(20), EZBAUPHASE VARCHAR(20), MINDAT datetime, MAXDAT datetime ) GO create unique index ERGEBZEITRAUM on ERGEBZEITRAUM(EZTEIL,EZMODUL,EZAUSGAPUNKT,EZBAUPHASE) GO create table PARTCONFIG ( PARTID int, PARTCONFIG VARCHAR(80), PARTWINDOWLIST text ) GO create unique index PARTCONFIG on PARTCONFIG(PARTID) GO create table MEASVALUES ( MV_PARTID int, MV_INTERNALID int, MV_MEASUREMENTID VARCHAR(50), MV_MEASVALUES text, MV_ATTRIBUTE smallint, MV_INSPECTOR int, MV_MEASSYSTEM int, MV_MACHINE int, MV_NEST int, MV_MEASSTARTDATETIME datetime, MV_MEASENDDATETIME datetime, MV_SAMPLEFLAG tinyint, MV_BATCHSTART VARCHAR(20), MV_BATCHEND VARCHAR(20), MV_ORDER VARCHAR(20), MV_MEASUREMENTCOUNT int, WV0005 VARCHAR(20) ) GO create unique index MEASVALUES on MEASVALUES(MV_PARTID,MV_INTERNALID) GO create index MV_INTERNALID on MEASVALUES(MV_INTERNALID) GO create index MV_MEASENDDATETIME on MEASVALUES(MV_MEASENDDATETIME) GO create index MV_MEASSTARTDATETIME on MEASVALUES(MV_MEASSTARTDATETIME) GO create index MV_MEASUREMENTID on MEASVALUES(MV_MEASUREMENTID) GO create index MV_ATTRIBUTE on MEASVALUES(MV_ATTRIBUTE) GO create index MV_INSPECTOR on MEASVALUES(MV_INSPECTOR) GO create index MV_MEASSYSTEM on MEASVALUES(MV_MEASSYSTEM) GO create index MV_MACHINE on MEASVALUES(MV_MACHINE) GO create index MV_NEST on MEASVALUES(MV_NEST) GO create table HIERATEIL ( HITEIL int, HISUBKEY1 int, HISUBKEY2 int, HISTRUKTUR text ) GO create unique index HIERATEIL on HIERATEIL(HITEIL, HISUBKEY1, HISUBKEY2) GO create table LAST_UPLOAD ( MEUPLOADKEY int, METEIL int, MEMERKMAL smallint, FILENAME VARCHAR(255), MEWERT int, K0006 VARCHAR(20), K0007 int, K0008 int, K0010 int, K0012 int, K0053 VARCHAR(20), STATION_NO VARCHAR(50), MMNRINTERN SMALLINT, TIDNR VARCHAR(20), K1001 VARCHAR(40), K1002 VARCHAR(80), SPU INT ) GO create unique index LAST_UPLOAD on LAST_UPLOAD(MEUPLOADKEY, METEIL, MEMERKMAL) GO create index LAST_UPLOAD_TEIL on LAST_UPLOAD(METEIL) GO create index LAST_UPLOAD_STATION_NO on LAST_UPLOAD(STATION_NO) GO create table MERKMAL_REPORT ( METEIL int, MEMERKMAL smallint, MEREPORT VARCHAR(255), MODUL smallint, EMAIL VARCHAR(255), PRINTER VARCHAR(255), CONFNAME VARCHAR(50), GRUPPE int, TEMPLATE VARCHAR(255), MEREPORTALARM VARCHAR(255), PDFPATH VARCHAR(255), WITHOUT_AL_TXT VARCHAR(255), PDF_URL VARCHAR(255), ALTPDFDNERZ VARCHAR(255) ) GO create index MERKMAL_REPORT_TEIL on MERKMAL_REPORT(METEIL) GO CREATE TABLE MERKMAL_REPORT_NO_SELECT ( METEIL INT , MEMERKMAL SMALLINT , MEREPORT VARCHAR(255) , MODUL SMALLINT , CONFNAME VARCHAR(50) ) GO create index MERKMAL_REPORT_NST on MERKMAL_REPORT_NO_SELECT(METEIL) GO create table REPORTS ( REPORTNO smallint, REPORTNAME VARCHAR(255), REPORTTYPE smallint, MODUL smallint, CONFNAME VARCHAR(50) ) GO create table ALARM_FILES ( ALARM_ID int, ENTRY_TYPE int, ENTRY image, UPLOAD_DIR VARCHAR(255), REPORTNAME VARCHAR(255) ) GO create unique index ALARM_FILES on ALARM_FILES(ALARM_ID, ENTRY_TYPE) GO create table ALARMS ( ALARM_ID int, ALARM_COUNT int, ALARM_TYPE int, ALARM_STATUS int, ALARM_DATETIME datetime, ALARM_EVENT VARCHAR(255), ALARM_EW INT, ALARM_QRK_L INT, ALARM_QRK_S INT, ALARM_CP INT, K0006 VARCHAR(20), K0007 INT, K0008 INT, K0010 INT, K0012 INT, K0053 VARCHAR(20), K1000 INT, K0000 INT, SUMMARY_NR INT, STATUS_PRINTED INT, POINTS INT, STATION_NO VARCHAR(50) ) GO create unique index ALARMS on ALARMS(ALARM_ID) GO CREATE TABLE ALARM_VALUES ( ALARM_ID INT , ALARM_VALUE_ID INT , ALARM_STATUS INT , ALARM_DATETIME DATETIME , CONFIRM_DATETIME DATETIME , CLOSE_DATETIME DATETIME , CONFIRM_USER VARCHAR(50) , CLOSE_USER VARCHAR(50) , ALARM_EW INT , ALARM_QRK_L INT , ALARM_QRK_S INT , ALARM_CP INT , ALARM_EVENT VARCHAR(255) , K0006 VARCHAR(20) , K0007 INT , K0008 INT , K0010 INT , K0012 INT , K0053 VARCHAR(20) , K1000 INT , K2000 INT , K0000 INT , POINTS INT ) GO create unique index ALARM_VALUES on ALARM_VALUES(ALARM_ID,ALARM_VALUE_ID) GO CREATE TABLE EMPB_3000 ( K3000 int, K3001 varchar(20), K3002 varchar(30), K3003 varchar(20), K3004 varchar(20), K3005 varchar(20), K3006 varchar(20), K3010 int, K3011 varchar(20), K3020 smallint, K3021 smallint, K3022 smallint, K3023 varchar(40), K3025 varchar(20), K3030 varchar(120), K3031 varchar(40), K3035 varchar(50), K3036 varchar(50), K3037 smallint, K3040 smallint, K3050 varchar(30), K3052 varchar(50), K3055 varchar(30), K3056 varchar(20), K3057 datetime, K3058 varchar(20), K3070 varchar(30), K3071 varchar(30), K3077 datetime, K3078 datetime, K3080 varchar(30), K3087 datetime, K3100 varchar(30), K3101 varchar(20), K3102 varchar(20), K3103 varchar(20), K3105 varchar(20), K3106 varchar(20), K3107 varchar(20), K3108 smallint, K3109 smallint, K3110 varchar(20), K3112 varchar(30), K3113 varchar(30), K3115 smallint, K3117 varchar(20), K3118 varchar(20), K3119 datetime, K3150 int, K3160 varchar(30), K3167 datetime, -- K3180 K3187 varchar(20), K3188 varchar(20), -- K3190 K3200 varchar(30), K3210 varchar(30), K3301 varchar(20), K3302 varchar(30), K3303 varchar(20), K3304 varchar(20), K3306 varchar(20), K3310 int, K3350 varchar(30), K3352 varchar(50), K3355 varchar(30), K3356 varchar(30), K3357 datetime, K3358 varchar(20), K3372 varchar(30), K3379 datetime, K3380 varchar(20), K3387 datetime, K3390 varchar(30), K3404 varchar(30), K3410 varchar(20), K3420 smallint, K3421 smallint, K3422 smallint, K3423 smallint, K3424 smallint, K3425 smallint, K3433 smallint, K3438 smallint, K3439 varchar(20), K3440 varchar(20), K3442 smallint, K3445 varchar(50), K3447 datetime, K3450 varchar(50), K3451 varchar(20), K3460 varchar(20), K3467 datetime, K3470 int, -- K3481 -- K3490 K3560 varchar(30), K3561 varchar(30), K3562 varchar(30), K3563 varchar(30), K3564 varchar(30), K3565 varchar(30), K3566 varchar(30), K3569 varchar(30), K3600 smallint, K3601 varchar(30), K3602 varchar(60), K3610 varchar(50), K3617 datetime, K3650 smallint, K3701 smallint, K3702 smallint, K3703 smallint, K3704 smallint, K3705 smallint, K3706 smallint, K3707 smallint, K3708 smallint, K3709 smallint, K3710 smallint, K3711 smallint, K3712 smallint, K3713 smallint, K3714 smallint, K3750 smallint, K3752 smallint, K3754 smallint, K3756 smallint, K3757 varchar(20), K3758 varchar(20), K3760 smallint, K3761 varchar(50), K3763 smallint, K3764 varchar(20), -- ab VDA2, 4. Aufl. K3015 tinyint, K3016 tinyint, K3017 varchar(20), K3019 tinyint, K3426 smallint, K3427 int, K3428 smallint, K3429 smallint, K3430 smallint, K3431 smallint, K3432 smallint, K3434 smallint, K3435 smallint, K3437 smallint, K3446 datetime, K3448 varchar(20), K3449 datetime, K3840 smallint, K3841 smallint, K3843 smallint, K3844 smallint, K3845 smallint, K3846 smallint, K3847 smallint, K3901 varchar(20), K3902 varchar(20), K3903 varchar(20), K3904 varchar(20), K3905 varchar(20), K3906 varchar(20), K3907 varchar(20), K3908 varchar(20), K3909 varchar(20), K3910 varchar(20), K3911 varchar(20), K3912 varchar(20), K3913 varchar(20), K3914 varchar(20), K3915 varchar(20), K3916 varchar(20), K3917 varchar(20), K3920 varchar(20), K3921 varchar(20), K3923 varchar(20), K3924 varchar(20), K3925 varchar(20), K3926 varchar(20), K3927 varchar(20), K3931 varchar(50), K3932 varchar(50), K3933 varchar(50), K3934 varchar(50), K3935 varchar(50), K3936 varchar(50), K3937 varchar(50), K3938 varchar(50), K3939 varchar(50), K3940 varchar(50), K3941 varchar(50), K3942 varchar(50), K3943 varchar(50), K3944 varchar(50), K3945 varchar(50), K3946 varchar(50), K3947 varchar(50), K3950 varchar(50), K3951 varchar(50), K3953 varchar(50), K3954 varchar(50), K3955 varchar(50), K3956 varchar(50), K3957 varchar(50), K3961 smallint, K3962 smallint, K3963 smallint, K3964 smallint, K3965 smallint, K3966 smallint, K3967 smallint, K3968 smallint, K3969 smallint, K3970 smallint, K3971 smallint, K3972 smallint, K3973 smallint, K3974 smallint, K3975 smallint, K3976 smallint, K3977 smallint, K3980 smallint, K3981 smallint, K3983 smallint, K3984 smallint, K3985 smallint, K3986 smallint, K3987 smallint, -- ab PPAP 4. Aufl. K3186 varchar(20), K3192 tinyint, K3250 varchar(50), K3251 varchar(30), K3770 tinyint, K3771 varchar(80), K3371 VARCHAR(30), K3377 DATETIME, K3436 smallint, K3780 varchar(120), K3781 varchar(120), K3782 varchar(120) ) GO create unique index EMPB_3000 on EMPB_3000(K3000) GO CREATE TABLE EMPB_3000_ZUS ( K3000 int, K3418 smallint, K3419 smallint, K3500 smallint, K3501 smallint, K3502 smallint, K3503 smallint, K3504 smallint, K3505 smallint, K3506 smallint, K3507 smallint, K3508 smallint, K3509 smallint, K3510 smallint, K3660 VARCHAR(20), K3661 VARCHAR(20), K3662 VARCHAR(20), K3663 VARCHAR(20), K3664 VARCHAR(20), K3665 VARCHAR(20), K3666 VARCHAR(20), K3667 VARCHAR(20), K3668 VARCHAR(20), K3669 VARCHAR(20), K3670 VARCHAR(20), K3673 VARCHAR(50), K3674 VARCHAR(50), K3675 VARCHAR(50), K3676 VARCHAR(50), K3677 VARCHAR(50), K3678 VARCHAR(50), K3679 VARCHAR(50), K3680 VARCHAR(50), K3681 VARCHAR(50), K3682 VARCHAR(50), K3683 VARCHAR(50), K3686 smallint, K3687 smallint, K3688 smallint, K3689 smallint, K3690 smallint, K3691 smallint, K3692 smallint, K3693 smallint, K3694 smallint, K3695 smallint, K3696 smallint, K3220 varchar(40), K3221 datetime ) GO create unique index EMPB_3000_ZUS on EMPB_3000_ZUS(K3000) GO Create table MEMO_FIELDS( MM_PART int, MM_CHARACT smallint, MM_MEASVALUE int, MM_K_R_KEY smallint, MM_K_FIELD smallint, MM_CONTENTS text ) GO create unique index MEMO_FIELDS on MEMO_FIELDS(MM_PART, MM_CHARACT, MM_MEASVALUE, MM_K_R_KEY, MM_K_FIELD) GO create table MITARB ( MIMITARB int, MINAME1 VARCHAR(50), MINAME2 VARCHAR(50), MIABT VARCHAR(50), MITELEFON VARCHAR(50), MIFAX VARCHAR(50), MIEMAIL VARCHAR(50), MIPOS VARCHAR(30), MIANREDE VARCHAR(15), MISTATE int default 0, MIBEMERK VARCHAR(200) ) GO create unique index MITARB on MITARB (MIMITARB) GO create table SIGNATUR ( SIGNATUR_ID int, SIGNATUR_COUNTER smallint, SIGNATUR_MODUL smallint, SIGNATUR_USER VARCHAR(50), SIGNATUR_USERDATE datetime, SIGNATUR_COMMENT VARCHAR(255), SIGNATUR_REASON smallint ) GO create unique index SIGNATUR on SIGNATUR (SIGNATUR_ID,SIGNATUR_COUNTER) GO create table SIGNATUR_FILES ( SIGNATUR_ID int, SIGNATUR_COUNTER int, SIGNATUR_TYPE int, SIGNATUR_ENTRY image, SIGNATUR_DESC VARCHAR(255), SIGNATUR_SIZE VARCHAR(20) ) GO create unique index SIGNATUR_FILES on SIGNATUR_FILES (SIGNATUR_ID,SIGNATUR_COUNTER,SIGNATUR_TYPE) GO create table SIGNATUR_MASTER ( SIGNATUR_ID int, SIGNATUR_MODUL smallint, SIGNATUR_MASTERKEY VARCHAR(255), SIGNATUR_DATE datetime, SIGNATUR_EVALSTRAT int, SIGNATUR_EVALNAME VARCHAR(50), SIGNATUR_COMMENT1 VARCHAR(255), SIGNATUR_COMMENT2 VARCHAR(255), SIGNATUR_COMMENT3 VARCHAR(255) ) GO create unique index SIGNATUR_MASTER on SIGNATUR_MASTER (SIGNATUR_ID) GO create table SIGNATUR_REASON ( SIGNATUR_REASON smallint, SIGNATUR_MODUL smallint, SIGNATUR_REASON_DESC VARCHAR(50), SIGNATUR_MUSTFILL smallint ) GO create unique index SIGNATUR_REASON on SIGNATUR_REASON (SIGNATUR_REASON,SIGNATUR_MODUL) GO Insert INTO SIGNATUR_REASON VALUES(1,1,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,1,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,10,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,10,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,20,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,20,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,26,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,26,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,30,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,30,'Approval',2) GO Insert INTO SIGNATUR_REASON VALUES(1,60,'Review',1) GO Insert INTO SIGNATUR_REASON VALUES(2,60,'Approval',2) GO CREATE TABLE ARCHIVES ( ARARCHIVENO int, ARSTARTDATE datetime, ARENDDATE datetime, ARDATABASE VARCHAR(150), ARDBTYPE int, ARTABLESUFFIX VARCHAR(20), ARACTIVATED tinyint, ARARCHIVATED tinyint, ARVALUESDELETED tinyint ) GO CREATE UNIQUE INDEX ARCHIVES ON ARCHIVES(ARARCHIVENO) GO CREATE TABLE ARCHIVEACTIONS ( AAARCHIVENO int, AAACTIONNO int, AADATE datetime, AAUSER VARCHAR(50), AAACTION int ) GO CREATE UNIQUE INDEX ARCHIVEACTIONS ON ARCHIVEACTIONS(AAARCHIVENO, AAACTIONNO) GO CREATE TABLE RESULTS( RPART int, RCHARACTERISTIC int, RMODULE int, RFIRSTDATE datetime, RLASTDATE datetime, ROPERATOR int, RGAGE int, RMACHINE int, RNEST int, RBATCHNO VARCHAR(20), RORDERNO VARCHAR(20), RSEPERFIELDS VARCHAR(50), RSTRATEGY int, RID int, RAUSWSTATUS int, RCWERTEART int, RCWERTEQUALITAET int, RMFA VARCHAR(4000), R1000_0 FLOAT, R1000_0_T FLOAT, R1100_0 FLOAT, R1100_0_T FLOAT, R1200_0 FLOAT, R1200_0_T FLOAT, R1300_0 FLOAT, R1300_0_T FLOAT, R2000_0 FLOAT, R2000_0_T FLOAT, R2100_0 FLOAT, R2100_0_T FLOAT, R2300_0 FLOAT, R2300_0_T FLOAT, R4180_1 FLOAT, R4180_1_T FLOAT, R4190_1 FLOAT, R4190_1_T FLOAT, R4180_2 FLOAT, R4180_2_T FLOAT, R4190_2 FLOAT, R4190_2_T FLOAT, R4180_3 FLOAT, R4180_3_T FLOAT, R4190_3 FLOAT, R4190_3_T FLOAT, R4180_4 FLOAT, R4180_4_T FLOAT, R4190_4 FLOAT, R4190_4_T FLOAT, R4180_5 FLOAT, R4180_5_T FLOAT, R4190_5 FLOAT, R4190_5_T FLOAT, R4180_6 FLOAT, R4180_6_T FLOAT, R4190_6 FLOAT, R4190_6_T FLOAT, R4180_7 FLOAT, R4180_7_T FLOAT, R4190_7 FLOAT, R4190_7_T FLOAT, R4210_25 FLOAT, R4210_25_T FLOAT, R4210_75 FLOAT, R4210_75_T FLOAT, R5210_0 FLOAT, R5210_0_T FLOAT, R5220_0 FLOAT, R5220_0_T FLOAT, R5210_10 FLOAT, R5210_10_T FLOAT, R5220_10 FLOAT, R5220_10_T FLOAT, R6000_0 FLOAT, R6000_0_T FLOAT, R6100_0 FLOAT, R6101_0 FLOAT, R6102_0 FLOAT, R6103_0 FLOAT, R6104_0 FLOAT, R6301_0 FLOAT, R6302_0 FLOAT, R8910_0 FLOAT, R10500_0 FLOAT, R10501_0 FLOAT, R15000_0 FLOAT, R5240_0 FLOAT, R5240_0_T FLOAT, R5240_10 FLOAT, R5240_10_T FLOAT, K2005_0 SMALLINT, R5210_20 FLOAT, R5210_20_T FLOAT, R5220_20 FLOAT, R5220_20_T FLOAT, REVENTS VARCHAR(100), R5500_0 FLOAT, R5500_0_T FLOAT, R5510_0 FLOAT, R5510_0_T FLOAT, R5520_0 FLOAT, R5520_0_T FLOAT, R5530_0 FLOAT, R5530_0_T FLOAT ) GO CREATE INDEX RESULTS ON RESULTS(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY) GO CREATE TABLE RESULTS_FILES( RPART int, RCHARACTERISTIC int, RMODULE int, RFIRSTDATE datetime, RLASTDATE datetime, ROPERATOR int, RGAGE int, RMACHINE int, RNEST int, RBATCHNO VARCHAR(20), RORDERNO VARCHAR(20), RSEPERFIELDS VARCHAR(50), RSTRATEGY int, RID int, RREPORT_NUM smallint, RENTRY_TYPE int, RENTRY image, REPORTNAME VARCHAR(255) ) GO CREATE INDEX RESULTS_FILES ON RESULTS_FILES(RPART, RCHARACTERISTIC, RMODULE, RSTRATEGY) GO create table TRANSMIT_HEADER ( STATIONGUID UNIQUEIDENTIFIER, TEILGUID UNIQUEIDENTIFIER, MERKMALGUID UNIQUEIDENTIFIER, KFELD smallint, INHALT TEXT, AENDDAT DATETIME, AENDUSER VARCHAR(50), STATUS int ) GO CREATE INDEX TH_AENDDAT ON TRANSMIT_HEADER(AENDDAT) GO CREATE INDEX TH_MERKMAL ON TRANSMIT_HEADER(MERKMALGUID) GO CREATE INDEX TH_TEIL ON TRANSMIT_HEADER(TEILGUID) GO create table TRANSMIT_WERTEVAR ( WVTEILGUID UNIQUEIDENTIFIER, WVMERKMALGUID UNIQUEIDENTIFIER, WVUNTERS smallint, WVWERTNR int, WVWERT FLOAT, WVATTRIBUT smallint, WVPRUEFER int, WVPRUEFMIT int, WVMASCHINE int, WVNEST int, WVDATZEIT DATETIME, WVSTIANF tinyint, WVCHARGE VARCHAR(20), WVAUFTRAG VARCHAR(20), WVSTATUS int, WVAENDDAT DATETIME, WVAENDUSER VARCHAR(20), WV0005 VARCHAR(35) ) GO CREATE INDEX TW_WVATTRIBUT ON TRANSMIT_WERTEVAR(WVATTRIBUT) GO CREATE INDEX TW_WVTEILGUID ON TRANSMIT_WERTEVAR(WVTEILGUID) GO CREATE INDEX TW_WVMERKMALGUID ON TRANSMIT_WERTEVAR(WVMERKMALGUID) GO CREATE INDEX TW_WVDATZEIT ON TRANSMIT_WERTEVAR(WVDATZEIT) GO CREATE INDEX TW_WVMASCHINE ON TRANSMIT_WERTEVAR(WVMASCHINE) GO CREATE INDEX TW_WVNEST ON TRANSMIT_WERTEVAR(WVNEST) GO CREATE INDEX TW_WVPRUEFER ON TRANSMIT_WERTEVAR(WVPRUEFER) GO CREATE INDEX TW_WVPRUEFMIT ON TRANSMIT_WERTEVAR(WVPRUEFMIT) GO CREATE INDEX TW_WV0005 ON TRANSMIT_WERTEVAR(WV0005) GO create table STATION ( STATION_KEY UNIQUEIDENTIFIER, STATION_NO VARCHAR(50), STATION_DESC VARCHAR(50), STATION_IP VARCHAR(50), LASTSUCCESSFULL_SYNCH_END DATETIME, STATION_SYNCH_DATE_SERVER DATETIME, SYNCHRONIZE_START DATETIME, SYNCHRONIZE_END DATETIME, SYNCHRONIZE_INTERVAL DATETIME, SYNCHRONIZE_OFFSET DATETIME, LAST_SYNCH_START DATETIME, NEXT_SYNCH_EVENT DATETIME, DB_COMPRESS_INTERVAL DATETIME, LAST_DB_COMPRESSION DATETIME, MAX_VALUES int, MAX_LOGFILES_SIZE int, WITHOUT_REQUEST smallint , INFO VARCHAR(255), STATION_PATH VARCHAR(255), PP_DESELECT tinyint ) GO CREATE UNIQUE INDEX STATION ON STATION(STATION_KEY) GO create table STATIONS_PART ( STATION UNIQUEIDENTIFIER, PART int, LASTERROR VARCHAR(255), CHANGEDATETIME DATETIME, TODELETE tinyint ) GO CREATE UNIQUE INDEX STATIONS_PART ON STATIONS_PART(STATION,PART) GO CREATE TABLE ORDKLASS ( OKKEY int, OKNR VARCHAR(40), OKBEZ VARCHAR(100), OKKURZBEZ VARCHAR(20), OKBEWERT smallint default 0, OKSTATE int default 0, OKRANG INT, OKBEMERK VARCHAR(200) ) GO CREATE UNIQUE INDEX ORDKLASS ON ORDKLASS(OKKEY) GO CREATE TABLE ORDKLASSKAT ( OKKKEY int, OKKBEZ VARCHAR(100) ) GO CREATE UNIQUE INDEX ORDKLASSKAT ON ORDKLASSKAT(OKKKEY) GO CREATE TABLE ZU_OK_OKK ( OKKEY int, OKKKEY int ) GO CREATE UNIQUE INDEX ZU_OK_OKK ON ZU_OK_OKK(OKKEY, OKKKEY) GO CREATE TABLE FORMS ( FO_GUID UNIQUEIDENTIFIER, FO_PARTGUID UNIQUEIDENTIFIER, FO_CHARGUID UNIQUEIDENTIFIER, FO_USAGE tinyint, FO_MODULES VARCHAR(50), FO_GC_TYPES VARCHAR(50), FO_INTKEY1 int, FO_INTKEY2 int, FO_STRINGKEY1 VARCHAR(50), FO_STRINGKEY2 VARCHAR(50), FO_NAME VARCHAR(50), FO_CONTENTS text, FO_ALLPARTGUIDS VARCHAR(50) ) GO CREATE UNIQUE INDEX FORMS ON FORMS(FO_GUID) GO CREATE TABLE FORMS_PARTS ( FO_GUID UNIQUEIDENTIFIER, FO_ALL_PART_GUIDS text ) GO CREATE UNIQUE INDEX FORMS_PARTS ON FORMS_PARTS(FO_GUID) GO CREATE TABLE PSTEPS ( PV_VORGANGGUID UNIQUEIDENTIFIER, PV_STEP int, PV_STEPNAME VARCHAR(50), PV_START DATETIME, PV_END DATETIME, PV_USER smallint, PV_COMMENT text ) GO CREATE UNIQUE INDEX PSTEPS ON PSTEPS(PV_VORGANGGUID,PV_STEP) GO CREATE TABLE PVERSUCH ( PVPLAN int, PVAUFTRAG int, PVVORGANG smallint, PVVERSUCH smallint, PVVERSUCHNR VARCHAR(40), PVBEZEICH VARCHAR(80), PVBEMERK text, PVDATZEIT DATETIME, PVANMDAT DATETIME, PVANMBEN smallint, PVAENDDAT DATETIME, PVAENDBEN smallint, PVBEGINN DATETIME, PVENDE DATETIME, PV_VORGANGGUID UNIQUEIDENTIFIER, PV_0031 UNIQUEIDENTIFIER, PV_STATUS smallint, PV_SIGNATUR_ID int ) GO CREATE UNIQUE INDEX PVERSUCH ON PVERSUCH(PVPLAN,PVAUFTRAG,PVVORGANG,PVVERSUCH) GO CREATE INDEX PVERSUCH_VORG ON PVERSUCH(PV_VORGANGGUID) GO CREATE INDEX PVERSUCH_SIGID ON PVERSUCH(PV_SIGNATUR_ID) GO CREATE TABLE REDUCED_FIELDS ( FIELDLISTID int, FIELDLISTNAME VARCHAR(50), FIELDREDUCED smallint, FIELDMERKMAL_ZUS smallint, FIELDLIST text ) GO CREATE UNIQUE INDEX REDUCED_FIELDS ON REDUCED_FIELDS(FIELDLISTID) GO CREATE TABLE LAST_UPLOAD_KEYS ( NEXTVAL int IDENTITY (1, 1) NOT NULL , DUMMY_I VARCHAR(50) NULL ) GO create table SERIAL_NUMBERS ( SERIAL_ID int, SERIAL_NO VARCHAR(50), CUST_SERIAL_NO VARCHAR(50), CUSTOMER_ID int, PRODUCTION_DATE DATETIME, ORDER_NO VARCHAR(50), PALLET_NO VARCHAR(50), BATCH_NO VARCHAR(50), CUST_DESCR VARCHAR(40), PROJECT_NO VARCHAR(20), ADDITIONAL_DATE DATETIME, K0005 VARCHAR(40), K0007 int, K0008 int, K0009 VARCHAR(100), K0010 int, K0011 VARCHAR(40), K0012 int, K0014 VARCHAR(32), K0015 int, K0016 VARCHAR(32), K0017 VARCHAR(32), K0054 VARCHAR(32), K0055 VARCHAR(32), K0056 VARCHAR(32), K0057 VARCHAR(32), K0058 VARCHAR(32), K0059 VARCHAR(32), K0060 VARCHAR(32), K0061 int, K0062 int, K0063 int ) GO create unique index SERIAL_NUMBERS_ID on SERIAL_NUMBERS (SERIAL_ID) GO create index SERIAL_NUMBERS_NO on SERIAL_NUMBERS (SERIAL_NO) GO create index SERIAL_NUMBERS_CUNO on SERIAL_NUMBERS (CUST_SERIAL_NO) GO create index SERIAL_NUMBERS_DATE on SERIAL_NUMBERS (PRODUCTION_DATE) GO create table SERIAL_KEYS ( SERIAL_ID INT, STATION INT, SERIAL_NO VARCHAR(50), SERIAL_DATE DATETIME, READING_QLTY_ALL VARCHAR(20), READING_QLTY_1 VARCHAR(20), READING_QLTY_2 VARCHAR(20), READING_QLTY_3 VARCHAR(20), READING_QLTY_4 VARCHAR(20), ORDER_NO VARCHAR(50), PALLET_NO VARCHAR(50), GREENBODY_NO VARCHAR(50), DRAWING_NO VARCHAR(50), DRAWIND_IDX VARCHAR(30), MATERIAL_NO VARCHAR(50), PLANT VARCHAR(50), MATERIAL_TEXT VARCHAR(80), DIMENSION VARCHAR(20), INSPECTIONLOT VARCHAR(20), ADDITIONAL_DATE DATETIME, K0005 VARCHAR(40), K0007 int, K0008 int, K0009 VARCHAR(100), K0010 int, K0011 VARCHAR(40), K0012 int, K0014 VARCHAR(32), K0015 int, K0016 VARCHAR(32), K0017 VARCHAR(32), K0054 VARCHAR(32), K0055 VARCHAR(32), K0056 VARCHAR(32), K0057 VARCHAR(32), K0058 VARCHAR(32), K0059 VARCHAR(32), K0060 VARCHAR(32), K0061 int, K0062 int, K0063 int, BATCH_NO VARCHAR(50) ) GO create unique index SERIAL_KEYS on SERIAL_KEYS (SERIAL_ID, STATION) GO create table EQUIPMENT ( EQ_KEY int, EQ_NUMBER VARCHAR(30), EQ_DESC VARCHAR(50) ) GO create unique index EQUIPMENT on EQUIPMENT(EQ_KEY) GO create table SERIAL_EQUIPMENT ( SERIAL_ID int, STATION int, EQUIPMENT_KEY int, EQUIPMENT_BATCHNO VARCHAR(50), EQUIPMENT_PARTNO VARCHAR(50), EQUIPMENT_DMC VARCHAR(50), EQUIPMENT_ORDERNO VARCHAR(50) ) GO create unique index SERIAL_EQUIPMENT on SERIAL_EQUIPMENT(SERIAL_ID, STATION, EQUIPMENT_KEY) GO create index SERIAL_ID on SERIAL_EQUIPMENT(SERIAL_ID) GO create table KUNDEKAT ( KUKNR int, KUKBEZ varchar(100) ) GO create unique index KUNDEKAT on KUNDEKAT(KUKNR) GO create table ZU_KU_KUK ( KUKEY int, KUKNR int ) GO create unique index ZU_KU_KUK on ZU_KU_KUK(KUKEY, KUKNR) GO create table HERSTELLKAT ( HEKNR int, HEKBEZ varchar(100) ) GO create unique index HERSTELLKAT on HERSTELLKAT(HEKNR) GO create table ZU_HE_HEK ( HEKEY int, HEKNR int ) GO create unique index ZU_HE_HEK on ZU_HE_HEK(HEKEY, HEKNR) GO create table LIEFKAT ( LIKNR int, LIKBEZ varchar(100) ) GO create unique index LIEFKAT on LIEFKAT(LIKNR) GO create table ZU_LI_LIK ( LIKEY int, LIKNR int ) GO create unique index ZU_LI_LIK on ZU_LI_LIK(LIKEY, LIKNR) GO create table PAUFTKAT ( PAKNR int, PAKBEZ varchar(100) ) GO create unique index PAUFTKAT on PAUFTKAT(PAKNR) GO create table ZU_PA_PAK ( PAKEY int, PAKNR int ) GO create unique index ZU_PA_PAK on ZU_PA_PAK(PAKEY, PAKNR) GO create table WERKSTOFFKAT ( WSKNR int, WSKBEZ varchar(100) ) GO create unique index WERKSTOFFKAT on WERKSTOFFKAT(WSKNR) GO create table ZU_WS_WSK ( WSKEY int, WSKNR int ) GO create unique index ZU_WS_WSK on ZU_WS_WSK(WSKEY, WSKNR) GO create table ZEICHNKAT ( ZNKNR int, ZNKBEZ varchar(100) ) GO create unique index ZEICHNKAT on ZEICHNKAT(ZNKNR) GO create table ZU_ZN_ZNK ( ZNKEY int, ZNKNR int ) GO create unique index ZU_ZN_ZNK on ZU_ZN_ZNK(ZNKEY, ZNKNR) GO create table MASCHINKAT ( MAKNR int, MAKBEZ varchar(100) ) GO create unique index MASCHINKAT on MASCHINKAT(MAKNR) GO create table ZU_MA_MAK ( MAKEY int, MAKNR int ) GO create unique index ZU_MA_MAK on ZU_MA_MAK(MAKEY, MAKNR) GO create table PRUEFMITKAT ( PMKNR int, PMKBEZ varchar(100) ) GO create unique index PRUEFMITKAT on PRUEFMITKAT(PMKNR) GO create table ZU_PM_PMK ( PMKEY int, PMKNR int ) GO create unique index ZU_PM_PMK on ZU_PM_PMK(PMKEY, PMKNR) GO create table EINHEITKAT ( EIKNR int, EIKBEZ varchar(100) ) GO create unique index EINHEITKAT on EINHEITKAT(EIKNR) GO create table ZU_EI_EIK ( EIKEY int, EIKNR int ) GO create unique index ZU_EI_EIK on ZU_EI_EIK(EIKEY, EIKNR) GO create table PRUEFERKAT ( PRKNR int, PRKBEZ varchar(100) ) GO create unique index PRUEFERKAT on PRUEFERKAT(PRKNR) GO create table ZU_PR_PRK ( PRKEY int, PRKNR int ) GO create unique index ZU_PR_PRK on ZU_PR_PRK(PRKEY, PRKNR) GO create table AUFTRGEBKAT ( AUGKNR int, AUGKBEZ varchar(100) ) GO create unique index AUFTRGEBKAT on AUFTRGEBKAT(AUGKNR) GO create table ZU_AUG_AUGK ( AUGKEY int, AUGKNR int ) GO create unique index ZU_AUG_AUGK on ZU_AUG_AUGK(AUGKEY, AUGKNR) GO create table ERZEUGNISKAT ( EZKNR int, EZKBEZ varchar(100) ) GO create unique index ERZEUGNISKAT on ERZEUGNISKAT(EZKNR) GO create table ZU_EZ_EZK ( EZKEY int, EZKNR int ) GO create unique index ZU_EZ_EZK on ZU_EZ_EZK(EZKEY, EZKNR) GO create table MITARBKAT ( MIKNR int, MIKBEZ varchar(100) ) GO create unique index MITARBKAT on MITARBKAT(MIKNR) GO create table ZU_MI_MIK ( MIKEY int, MIKNR int ) GO create unique index ZU_MI_MIK on ZU_MI_MIK(MIKEY, MIKNR) GO create table NESTKAT ( NEKNR int, NEKBEZ varchar(100) ) GO create unique index NESTKAT on NESTKAT(NEKNR) GO create table ZU_NE_NEK ( NEKEY int, NEKNR int ) GO create unique index ZU_NE_NEK on ZU_NE_NEK(NEKEY, NEKNR) GO CREATE TABLE SIGNATURE_KEYS ( NEXTVAL int IDENTITY (1, 1) NOT NULL , DUMMY_I VARCHAR(50) NULL ) GO create table MERKMAL_MASTER ( METEIL int , MEMERKMAL smallint , MEMERKNR varchar(20) , MEMERKBEZ varchar(80) , MENENNMAS float , MEARTUGW smallint , MEARTOGW smallint , MEARTPLAUSIUNT smallint , MEARTPLAUSIOB smallint , MEUGW float , MEOGW float , MEFSK smallint , MEFEHLART tinyint , MEFEHLKOST float , MEDPFLICHT smallint , MEEINHEIT smallint , MEAUFLOES smallint , MEKLASSENW float , MEFERTARTNR varchar(20) , MEPMGRUPPE smallint , MEPRUEFMIT int , MEPRUEFMITNR smallint , MEERFART smallint , MEMASCHINE int , MEBEMERK text , MESTIFREQ smallint , MEUMFSTICH smallint , MEANZSTICH int , MEANZMESSGC int , MEANZPRUEF int , MEUMFPROZ smallint , MEANZWIED smallint , MEANZTEILE int , METOLERANZ smallint , METRANSART tinyint , METRANSPA float , METRANSPB float , METRANSPC float , METRANSPD float , MEGLMITT smallint , MEAUSWART smallint , MEAUSWTYP smallint , MEMERKART smallint , MEVERTFORM smallint , MEPLAUSIOB float , MEPLAUSIUN float , MEPROSTREUSTR varchar(40) , MEPROSTREU float , MENORMISTSTR varchar(80) , MENORMIST float , -- MENORMNR varchar(20) , MENORMNR varchar(40) , MENORMBEZ varchar(40) , MENORMTEMP varchar(40) , MEKLASSUNT float , MEKLASSOB float , MEKLASSNR float , MEVORGCP float , MEVORGCPK float , MESTEUERB tinyint , MEZYKLUS smallint , MEPRUEFZST smallint , MEPRUEFORT smallint , MEMASSN smallint , MEPRFSPEC smallint , MEAUTOAKT smallint , MEMERKKLASSE smallint , MEUNTERSART smallint , MEANZORDKLASSE smallint , MEGLEITSTUMF smallint , MEPUFFERSIZE smallint , MEAUTOERKENNUNG smallint , MEATTR smallint , METRANSFEING smallint , METRANSFEINGA float , METRANSFEINGB float , MENLINKSMA smallint , MEERFKANAL varchar(20) , MEERFSUBKANAL varchar(20) , MENACHARBEIT smallint , MEZIELWERT float , MEZIELWERTT float , MEPMAX float , MELOSUMFANG int , MEKOSTENNACHARBEIT float , MEKOSTENAUSSCHUSS float , MEMASCHNR varchar(24) , MEABT varchar(40) , MEAUFTRAGGEBNR smallint , MEAUFTRAGGEBNRT varchar(20) , MEPRUEFER int , MEPRUEFERNR varchar(20) , MEAUGROUP smallint , MEUPPERMERKMAL smallint , MEWERKSTCK int , MEPMAUFLOES float , MEPRUEFBEGINND datetime , MEPRUEFENDED datetime , MENORMAL smallint , MENORMALTEMP float , MEWERKSTCKNR varchar(20), MEKURZBEZ varchar(20), MEUGSCHROTT FLOAT, MEOGSCHROTT FLOAT, MECG FLOAT, MECGK FLOAT, MEABWGC FLOAT, MEFERTARTKEY smallint, MEPMHERST varchar(40), MEKORRSTRAT smallint, MEUKG FLOAT, MEOKG FLOAT, MEKORRZIEL FLOAT, MEERFNR smallint, MEERFNAME varchar(40), MEERFINDEX smallint, MEANFINDEX smallint, MEINTERFACE smallint, MEBAUD int, MEIRQ smallint, MEPARITY smallint, MEDATA smallint, MESTOP smallint, MEPZPKAT smallint, METOLERANZCALC FLOAT, MEBEREICH varchar(40), MEPTM varchar(40), MEPPLANNRT varchar(20), MEPPLAN varchar(40), MEPPLANDAT varchar(20), MEPPLANERST varchar(40), MESPCNR varchar(20), MESPCHERST varchar(40), MESPCTYP varchar(20), MECP FLOAT, MECPK FLOAT, MECPFIX FLOAT, MECPKFIX FLOAT, MEGAGE25 VARCHAR(110) , MEEINHREL VARCHAR(20) , MEADDFAKREL FLOAT , MEMULFAKREL FLOAT , MENORMISTUN FLOAT , MENORMISTOB FLOAT , MEFERTART varchar(80) , MEPMGRUPPET varchar(80) , MEPRUEFMITT varchar(80) , MEPRUEFMITNRT varchar(80) , MEEINHEITTEXT varchar(80) , MEMASCHBEZ varchar(80) , MESTANDORT varchar(80) , MEAUFTRNR varchar(80) , MEAUFTRAGGEB varchar(80) , MEPRUEFORTT varchar(80) , MEPRUEFBEGINN varchar(80) , MEPRUEFENDE varchar(80) , MEPRUEFERNAME varchar(80) , METOLERANZTEXT varchar(80) , MEWERKSTCKTEXT varchar(80) , MEANZSPTEXT varchar(80) , MESTIFREQT varchar(80) , MEZEICHN varchar(80) , MENENNMAST varchar(50) , MEUGWT varchar(50) , MEOGWT varchar(50) , MEPLAUSIUT varchar(50) , MEPLAUSIOT varchar(50) , MEFORMEL varchar(255) , MEKONFIG varchar(1000) , MEEREIGKAT varchar(50) , MENENNMASSP varchar(50) , MEPRUEFBEDING varchar(255) , MENORMALSERNR VARCHAR(20), MEPRUEFMITSERNR VARCHAR(20), MEANZGERAET VARCHAR(40), MEREFTEILNRSTR VARCHAR(20), MEREFTEILBEZ VARCHAR(40), MEREFTEILIST FLOAT, MEREFTEILTEMP FLOAT, MEREFTEILNR smallint, MEREFTEILSERNR VARCHAR(20), MEKALTEILUNRSTR VARCHAR(20), MEKALTEILUBEZ VARCHAR(40), MEKALTEILUIST FLOAT, MEKALTEILUTEMP FLOAT, MEKALTEILUNR smallint, MEKALTEILUSERNR VARCHAR(20), MEKALTEILMNRSTR VARCHAR(20), MEKALTEILMBEZ VARCHAR(40), MEKALTEILMIST FLOAT, MEKALTEILMTEMP FLOAT, MEKALTEILMNR smallint, MEKALTEILMSERNR VARCHAR(20), MEKALTEILONRSTR VARCHAR(20), MEKALTEILOBEZ VARCHAR(40), MEKALTEILOIST FLOAT, MEKALTEILOTEMP FLOAT, MEKALTEILONR smallint, MEKALTEILOSERNR VARCHAR(20), MEUEBERKAN smallint, MEMERKCODE VARCHAR(40), MEMERKINDEX VARCHAR(20), MEMERKTEXT VARCHAR(50), MEBEARBZUST VARCHAR(80), MEELEMCODE VARCHAR(40), MEELEMINDEX VARCHAR(20), MEELEMTEXT VARCHAR(50), MEELEMADR VARCHAR(20), MEFREIFELD tinyint, MECALIBADD FLOAT, MECALIBMULT FLOAT, MEANZNIAUSGEF int, MEGCKONVART tinyint, MEANZREF smallint, MEREFPKTX smallint, MEREFPKTY smallint, MEREFPKTZ smallint, -- neu für EMPB ME_2430 smallint, ME_2432 smallint, ME_2434 smallint, ME_2436 varchar(10), ME_2438 varchar(10), ME_2440 varchar(40), ME_2442 varchar(15), ME_2444 varchar(40), ME_2446 varchar(40), ME_2448 varchar(40), ME_8530 smallint, ME_8531 float, ME_8532 float, ME_8540 smallint, -- ME_2073 float, ME_2107 float, ME_2170 float, ME_2171 float, ME_2172 float, ME_2173 float, ME_2228 float, ME_2229 float, ME_2230 float, ME_2231 float, ME_2232 float, ME_2233 float, ME_2235 float, ME_2236 float, ME_2016 tinyint, MEMASTERGUID UNIQUEIDENTIFIER, MEGUID UNIQUEIDENTIFIER ) GO create unique index MERKMAL_MASTER on MERKMAL_MASTER(MEMASTERGUID) GO create table PART_CHAR_OPER_LINK ( OPERATION_GUID UNIQUEIDENTIFIER, PART_KEY int, CHAR_KEY int, CHAR_GUID UNIQUEIDENTIFIER, SAMPLE_SIZE int, SAMPLE_FREQ varchar(50), RECORD_TYPE varchar(50), GAGE varchar(50) ) GO create unique index PART_CHAR_OPER_LINK on PART_CHAR_OPER_LINK(OPERATION_GUID, PART_KEY, CHAR_KEY) GO create table PLANT_LEVEL ( LEVEL_ID int, LEVEL_NO varchar(50), LEVEL_DESC varchar(255), LEVEL_SOURCE int, LEVEL_DESC_NO varchar(255), LEVEL_TYPE_FIELD_NO varchar(50), LEVEL_DESC_DESC varchar(255), LEVEL_TYPE_FIELD_DESC varchar(50), LEVEL_IMAGE image, LEVEL_NEW_TEXT varchar(50), LEVEL_DESC_FIELD_01 varchar(255), LEVEL_TYPE_FIELD_01 varchar(50), LEVEL_DESC_FIELD_02 varchar(255), LEVEL_TYPE_FIELD_02 varchar(50), LEVEL_DESC_FIELD_03 varchar(255), LEVEL_TYPE_FIELD_03 varchar(50), LEVEL_DESC_FIELD_04 varchar(255), LEVEL_TYPE_FIELD_04 varchar(50), LEVEL_DESC_FIELD_05 varchar(255), LEVEL_TYPE_FIELD_05 varchar(50), LEVEL_DESC_FIELD_06 varchar(255), LEVEL_TYPE_FIELD_06 varchar(50), LEVEL_DESC_FIELD_07 varchar(255), LEVEL_TYPE_FIELD_07 varchar(50), LEVEL_DESC_FIELD_08 varchar(255), LEVEL_TYPE_FIELD_08 varchar(50), LEVEL_DESC_FIELD_09 varchar(255), LEVEL_TYPE_FIELD_09 varchar(50), LEVEL_DESC_FIELD_10 varchar(255), LEVEL_TYPE_FIELD_10 varchar(50) ) GO create unique index PLANT_LEVEL on PLANT_LEVEL(LEVEL_ID) GO create table PLANT_STRUCT ( NODE_ID UNIQUEIDENTIFIER, PARENT_ID UNIQUEIDENTIFIER, NODE_LEVEL int, NODE_LOCALPOS int, NODE_SOURCE_KEY int, NODE_SOURCE_GUID UNIQUEIDENTIFIER, NODE_NO varchar(50), NODE_DESC varchar(255), NODE_IMAGE image, NODE_FIELD_01 varchar(255), NODE_FIELD_02 varchar(255), NODE_FIELD_03 varchar(255), NODE_FIELD_04 varchar(255), NODE_FIELD_05 varchar(255), NODE_FIELD_06 varchar(255), NODE_FIELD_07 varchar(255), NODE_FIELD_08 varchar(255), NODE_FIELD_09 varchar(255), NODE_FIELD_10 varchar(255), NODE_FILTER_PART varchar(255), NODE_FILTER_CHAR varchar(255), NODE_FILTER_VALUE varchar(255) ) GO create unique index PLANT_STRUCT on PLANT_STRUCT(NODE_ID) GO CREATE INDEX PLANT_STRUCT2 ON PLANT_STRUCT(NODE_LEVEL, NODE_LOCALPOS) GO CREATE TABLE PLANT_DISTR_NUMS ( MACHINE_NODE_ID UNIQUEIDENTIFIER, CHAR_MASTER_GUID UNIQUEIDENTIFIER, DISTR_NUMBER VARCHAR(40) ) GO create unique index PLANT_DISTR_NUMS on PLANT_DISTR_NUMS(MACHINE_NODE_ID,CHAR_MASTER_GUID) GO CREATE TABLE LINE_ALERT_DISTRIB ( LINE_ID UNIQUEIDENTIFIER, OPERATION_ID UNIQUEIDENTIFIER, RECIPIENT_KEY INT, EMAIL TINYINT, SMS TINYINT ) GO create unique index LINE_ALERT_DISTRIB on LINE_ALERT_DISTRIB(LINE_ID, OPERATION_ID, RECIPIENT_KEY) GO create table PRODUCT_LEVEL ( LEVEL_ID int, LEVEL_NO varchar(50), LEVEL_DESC varchar(255), LEVEL_SOURCE int, LEVEL_DESC_NO varchar(255), LEVEL_TYPE_FIELD_NO varchar(50), LEVEL_DESC_DESC varchar(255), LEVEL_TYPE_FIELD_DESC varchar(50), LEVEL_IMAGE image, LEVEL_NEW_TEXT varchar(50), LEVEL_DESC_FIELD_01 varchar(255), LEVEL_TYPE_FIELD_01 varchar(50), LEVEL_DESC_FIELD_02 varchar(255), LEVEL_TYPE_FIELD_02 varchar(50), LEVEL_DESC_FIELD_03 varchar(255), LEVEL_TYPE_FIELD_03 varchar(50), LEVEL_DESC_FIELD_04 varchar(255), LEVEL_TYPE_FIELD_04 varchar(50), LEVEL_DESC_FIELD_05 varchar(255), LEVEL_TYPE_FIELD_05 varchar(50), LEVEL_DESC_FIELD_06 varchar(255), LEVEL_TYPE_FIELD_06 varchar(50), LEVEL_DESC_FIELD_07 varchar(255), LEVEL_TYPE_FIELD_07 varchar(50), LEVEL_DESC_FIELD_08 varchar(255), LEVEL_TYPE_FIELD_08 varchar(50), LEVEL_DESC_FIELD_09 varchar(255), LEVEL_TYPE_FIELD_09 varchar(50), LEVEL_DESC_FIELD_10 varchar(255), LEVEL_TYPE_FIELD_10 varchar(50) ) GO create unique index PRODUCT_LEVEL on PRODUCT_LEVEL(LEVEL_ID) GO create table PRODUCT_STRUCT ( NODE_ID UNIQUEIDENTIFIER, PARENT_ID UNIQUEIDENTIFIER, NODE_LEVEL int, NODE_LOCALPOS int, NODE_SOURCE_KEY int, NODE_SOURCE_GUID UNIQUEIDENTIFIER, NODE_NO varchar(50), NODE_DESC varchar(255), NODE_IMAGE image, NODE_FIELD_01 varchar(255), NODE_FIELD_02 varchar(255), NODE_FIELD_03 varchar(255), NODE_FIELD_04 varchar(255), NODE_FIELD_05 varchar(255), NODE_FIELD_06 varchar(255), NODE_FIELD_07 varchar(255), NODE_FIELD_08 varchar(255), NODE_FIELD_09 varchar(255), NODE_FIELD_10 varchar(255), NODE_FILTER_PART varchar(255), NODE_FILTER_CHAR varchar(255), NODE_FILTER_VALUE varchar(255) ) GO create unique index PRODUCT_STRUCT on PRODUCT_STRUCT(NODE_ID) GO CREATE INDEX PRODUCT_STRUCT2 ON PRODUCT_STRUCT(NODE_LEVEL, NODE_LOCALPOS) GO CREATE TABLE MANUAL_QCC_PRINT ( BORDEREAU_ID INT NOT NULL, DG_BORDEREAU_ID INT, STATUS TINYINT NOT NULL, WORKSTATION_ID VARCHAR(100), PRINTER_ID VARCHAR(100), BORDEREAU_TYPE TINYINT, YEAR_NO SMALLINT, WEEK_NO TINYINT, DAY_NO TINYINT, CLASSIFICATION VARCHAR(50), EVENT_01_ID INT, EVENT_02_ID INT, EVENT_03_ID INT, EVENT_04_ID INT, EVENT_05_ID INT, EVENT_06_ID INT, EVENT_07_ID INT, EVENT_08_ID INT, EVENT_09_ID INT, EVENT_10_ID INT, DIV_01_ID VARCHAR(50), DIV_01_REVISION VARCHAR(20), DIV_02_ID VARCHAR(50), DIV_02_REVISION VARCHAR(20), DIV_03_ID VARCHAR(50), DIV_03_REVISION VARCHAR(20), DIV_04_ID VARCHAR(50), DIV_04_REVISION VARCHAR(20), DIV_05_ID VARCHAR(50), DIV_05_REVISION VARCHAR(20), CONTROL_PLAN_ID VARCHAR(50), ATELIER_NO VARCHAR(50), LINE_NO VARCHAR(50), LINE_DESC VARCHAR(50), OPERATION_NO VARCHAR(50), OPERATION_DESC VARCHAR(50), MACHINE_NO VARCHAR(50), MACHINE_DESC VARCHAR(50), CHAR_NO VARCHAR(20), CHAR_DESC VARCHAR(80), GAGE_ID VARCHAR(50), GAGE_DESC VARCHAR(50), SAMPLE_FREQ VARCHAR(80), SAMPLE_SIZE SMALLINT, LSL FLOAT, USL FLOAT, NOMINAL FLOAT, LLIMITTYPE TINYINT, ULIMITTYPE TINYINT, LCL FLOAT, UCL FLOAT, UNIT VARCHAR(20), PRECISION_SIZE TINYINT, PAGENO TINYINT, MAXPAGE TINYINT, LOI TINYINT, DISTRIBUTIONNO VARCHAR(20), EVENT_01_TEXT VARCHAR(40), EVENT_02_TEXT VARCHAR(40), EVENT_03_TEXT VARCHAR(40), EVENT_04_TEXT VARCHAR(40), EVENT_05_TEXT VARCHAR(40), EVENT_06_TEXT VARCHAR(40), EVENT_07_TEXT VARCHAR(40), EVENT_08_TEXT VARCHAR(40), EVENT_09_TEXT VARCHAR(40), EVENT_10_TEXT VARCHAR(40), CHAR_REMARK VARCHAR(255) ) GO CREATE TABLE MANUAL_QCC_PRINT_HISTORY ( BORDEREAU_ID INT NOT NULL, STATUS_HISTORY TINYINT NOT NULL, STATUS_TIME DATETIME NOT NULL ) GO create table MEASUREMENT_DOKUMENTS ( MD_ID int, MD_TEIL int, MD_MEASUREMENT_IDENT varchar(50), MD_DOCDESCR varchar(50), MD_DOCPATH varchar(255), MD_MERKMAL int, MD_WERTNR int ) GO create unique index MEASUREMENT_DOKUMENTS on MEASUREMENT_DOKUMENTS(MD_ID) GO create index TEIL_VALUE on MEASUREMENT_DOKUMENTS(MD_TEIL, MD_MEASUREMENT_IDENT) GO CREATE VIEW V_WERKZEUGNEST AS SELECT NEST.NENEST, WERKZEUG.WENR, NEST.NEBESCH FROM NEST LEFT JOIN WERKZEUG ON NEST.NEWERKZ = WERKZEUG.WEWERKZ GO create table KAT_4270 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT, BEMERK VARCHAR(200) ) GO create unique index KAT_4270 on KAT_4270(KATKEY) GO create table KAT_4270KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4270KAT on KAT_4270KAT(SUBKATKEY) GO create table ZU_4270KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4270KAT on ZU_4270KAT(KATKEY, SUBKATKEY) GO create table KAT_4280 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT, BEMERK VARCHAR(200) ) GO create unique index KAT_4280 on KAT_4280(KATKEY) GO create table KAT_4280KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4280KAT on KAT_4280KAT(SUBKATKEY) GO create table ZU_4280KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4280KAT on ZU_4280KAT(KATKEY, SUBKATKEY) GO create table KAT_4290 ( KATKEY INT, NR VARCHAR(20), BEZ VARCHAR(100), STATE INT, BEMERK VARCHAR(200) ) GO create unique index KAT_4290 on KAT_4290(KATKEY) GO create table KAT_4290KAT ( SUBKATKEY INT, SUBKATNAME VARCHAR(100) ) GO create unique index KAT_4290KAT on KAT_4290KAT(SUBKATKEY) GO create table ZU_4290KAT ( KATKEY INT, SUBKATKEY INT ) GO create unique index ZU_4290KAT on ZU_4290KAT(KATKEY, SUBKATKEY) GO create table PLANT_JOBS ( TREE_TYPE tinyint, NODE_ID UNIQUEIDENTIFIER, JOB_NO int, JOB_NAME VARCHAR(80), JOB_KIND tinyint, JOB_ACTIVE tinyint, PLAN_KIND tinyint, PLAN_TIME FLOAT, NODE_LEVEL tinyint, NODE_SUBLEVEL tinyint, JOB_REPORT VARCHAR(255), VALUE_FILTER int, OFFSET smallint, NODE_SUBSUBLEVEL tinyint, LT_DIVISION VARCHAR(100), PDF_OUTPUT_DIR VARCHAR(255), LANGUAGE int, MODULE int, STRATEGY int, PART_FILTER int, CHAR_FILTER int, REPORT_LEVEL tinyint, MAXNODESPERPAGE tinyint, DIVIDE_GRAPHICS tinyint, GRAPH_ROWS tinyint ) GO create unique index PLANT_JOBS on PLANT_JOBS(TREE_TYPE, NODE_ID, JOB_NO) GO create index JOB_ACTIVE on PLANT_JOBS(JOB_ACTIVE) GO create index JOB_KIND on PLANT_JOBS(JOB_KIND) GO create table JOB_FILTERS ( FILTER_ID int, FILTER_LEVEL tinyint, FILTER_NAME VARCHAR(50), FILTER text ) GO create unique index JOB_FILTERS on JOB_FILTERS(FILTER_ID) GO create index FILTER_LEVEL on JOB_FILTERS(FILTER_LEVEL) GO create index FILTER_NAME on JOB_FILTERS(FILTER_NAME) GO create table NODELOCK ( NLNODEGUID UNIQUEIDENTIFIER, NLNODETYPE int, NLNODESUBTYPE int, NLUSERNAME VARCHAR(90) ) GO create unique index NODELOCK on NODELOCK(NLNODEGUID) GO create table NODERIGHTS ( NRNODEGUID UNIQUEIDENTIFIER, NRUSERKEY int, NRCREATECHILD VARCHAR(1), NREDITNODE VARCHAR(1), NRDELETENODE VARCHAR(1), NRGRANTRIGHTS VARCHAR(1) ) GO create unique index NODERIGHTS on NODERIGHTS(NRNODEGUID, NRUSERKEY) GO create table PLANT_REPORT_MAIL_LIST ( NODE_ID UNIQUEIDENTIFIER, JOB_NO int, RECIPIENT_KEY int, ATTACH_REPORTS tinyint ) GO create unique index PLANT_REPORT_MAIL_LIST on PLANT_REPORT_MAIL_LIST(NODE_ID, JOB_NO, RECIPIENT_KEY) GO create table PART_CHAR_MACHINE ( PARTNO_1001 VARCHAR(30), CHARNO_2001 VARCHAR(30), MACHINEKEY int, CHAR_MASTERGUID UNIQUEIDENTIFIER ) GO create unique index PART_CHAR_MACHINE on PART_CHAR_MACHINE(PARTNO_1001, CHARNO_2001, MACHINEKEY) GO create table UNCONFORMITY_REPORTS ( UR_ID int, UR_USERID int, UR_USERNAME varchar(50), UR_CREATIONDATE datetime, UR_TEIL int, UR_MERKMAL int, UR_WERTNR int, UR_STATUS tinyint, UR_IMAGE image, UR_MODIFDATE datetime, UR_CLOSE_USERID int, UR_CLOSE_USERNAME varchar(50), UR_CLOSE_COMMENT varchar(255), UR_TYPE tinyint, UR_SUPPLIER varchar(50), UR_PRIO_ACTION int, UR_ALLOC_USERS varchar(25), UR_2ND_IMAGE image, UR_2ND_IMAGETYPE varchar(10), UR_PH_RECT varchar(30), UR_USER_TEXT varchar(80), UR_GROUPING_ID UNIQUEIDENTIFIER, UR_LAYOUT tinyint ) GO create unique index UNCONFORMITY_REPORTS on UNCONFORMITY_REPORTS(UR_ID) GO create index UR_CLOSE_USERID on UNCONFORMITY_REPORTS(UR_CLOSE_USERID) GO create index UR_USERID on UNCONFORMITY_REPORTS(UR_USERID) GO create table UNCONF_DIAGN ( UR_ID int, UD_ID int, UD_ANALYSIS varchar(255), UD_CAUSE varchar(255) ) GO create unique index UNCONF_DIAGN on UNCONF_DIAGN(UR_ID, UD_ID) GO create table UNCONF_ACTION ( UR_ID int, UA_ID int, UA_NOTE varchar(100), UA_ACTION varchar(255), UA_RESPONS varchar(50), UA_DATE varchar(20), UA_EFFECT varchar(100) ) GO create unique index UNCONF_ACTION on UNCONF_ACTION(UR_ID, UA_ID) GO CREATE TABLE NODERESULTS ( NRNODEID UNIQUEIDENTIFIER, NRMODULE int, NRFIRSTDATE datetime, NRLASTDATE datetime, NROPERATOR int, NRGAGE int, NRMACHINE int, NRNEST int, NRBATCHNO varchar(30), NRORDERNO varchar(30), NRSEPFIELDS varchar(50), NRSTRATEGY int, NRPS15210_00000033 float, NRPS15210_00330067 float, NRPS15210_00670100 float, NRPS15210_01000133 float, NRPS15210_01330167 float, NRPS15210_01670200 float, NRPS15210_02000233 float, NRPS15210_02330267 float, NRPS15210_02679999 float, NRPS15220_M9990000 float, NRPS15220_00000033 float, NRPS15220_00330067 float, NRPS15220_00670100 float, NRPS15220_01000133 float, NRPS15220_01330167 float, NRPS15220_01670200 float, NRPS15220_02000233 float, NRPS15220_02330267 float, NRPS15220_02679999 float, NR_OEE float, NR_OEE_V float, NR_OEE_P float, NR_OEE_N float, NR_OEE_F float, NRPS15000_00000001 float, NRPS15000_00000016 float, NRPS15000_00000032 float, NRPS15000_00004096 float ) GO CREATE TABLE NODEREPORTFILES ( NRF_NODEID UNIQUEIDENTIFIER, NRF_MODULE int, NRF_FIRSTDATE datetime, NRF_LASTDATE datetime, NRF_OPERATOR int, NRF_GAGE int, NRF_MACHINE int, NRF_NEST int, NRF_BATCHNO varchar(30), NRF_ORDERNO varchar(30), NRF_SEPFIELDS varchar(50), NRF_STRATEGY int, NRF_REPORT_NUM int, NRF_ENTRY_TYPE int, NRF_ENTRY image, NRF_REPORTNAME varchar(255) ) GO CREATE TABLE CAQ_EREIGNIS ( CE_ID int, CE_TEIL int, CE_MERKMAL int, CE_EREIGNISID VARCHAR(255) ) GO CREATE TABLE CAQ_URSACHE ( CU_ID int, CU_EREIGNISID VARCHAR(255), CU_URSACHEID VARCHAR(255) ) GO CREATE TABLE CAQ_MASSNAHME ( CM_ID int, CM_URSACHENID VARCHAR(255), CM_MASSNAHMEID VARCHAR(255) ) GO CREATE TABLE IQS_QDAS_MAPPING ( IQS_CLASS VARCHAR(30), IQS_FIELD VARCHAR(40), IQS_SUBFIELD VARCHAR(20), QDAS_TABLE VARCHAR(30), QDAS_FIELD VARCHAR(20), QDAS_FIELD_SUBKEY VARCHAR(20), QDAS_PARTKEY VARCHAR(20), QDAS_CHARKEY VARCHAR(20), QDAS_TAKEOVER VARCHAR(20), QDAS_TRIGGER VARCHAR(20), QDAS_PPLANKEY VARCHAR(30), QDAS_PAUFTRAGKEY VARCHAR(30), QDAS_UNTERSKEY VARCHAR(30) ) GO CREATE TABLE IQS_QDAS_CONTENT_MAPPING ( IQS_CLASS VARCHAR(30), IQS_FIELD VARCHAR(40), IQS_FIELD_SUBKEY VARCHAR(3), IQS_CONTENT VARCHAR(20), QDAS_FIELD VARCHAR(20), QDAS_FIELD_SUBKEY VARCHAR(20), QDAS_CONTENT VARCHAR(20) ) GO CREATE TABLE IQS_FIELD_TO_FIELD_MAPPING ( IQS_CLASS_SOURCE VARCHAR(30), IQS_FIELD_SOURCE VARCHAR(40), IQS_CLASS_DEST VARCHAR(30), IQS_FIELD_DEST VARCHAR(40) ) GO -- Prozedur WVINSERT zum Anlegen von Meßwerten CREATE PROCEDURE WVINSERT ( @PARA1 int, @PARA2 smallint, @PARA3 smallint, @PARA4 int, @PARA5 FLOAT, @PARA6 smallint, @PARA7 int, @PARA8 int, @PARA9 int, @PARA10 int, @PARA11 DATEtime, @PARA12 tinyint, @PARA13 VARCHAR(30), @PARA14 VARCHAR(20) ) AS BEGIN INSERT INTO WERTEVAR ( WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT,WVPRUEFER,WVPRUEFMIT,WVMASCHINE,WVNEST,WVDATZEIT, WVSTIANF,WVCHARGE,WVAUFTRAG ) VALUES (@PARA1, @PARA2, @PARA3, @PARA4, @PARA5, @PARA6, @PARA7, @PARA8, @PARA9, @PARA10, @PARA11, @PARA12, @PARA13, @PARA14); END GO CREATE PROCEDURE WVINSERT05 ( @PARA1 int, @PARA2 smallint, @PARA3 smallint, @PARA4 int, @PARA5 FLOAT, @PARA6 smallint, @PARA7 int, @PARA8 int, @PARA9 int, @PARA10 int, @PARA11 DATEtime, @PARA12 tinyint, @PARA13 VARCHAR(30), @PARA14 VARCHAR(20), @PARA_WV0005 VARCHAR(35) ) AS BEGIN INSERT INTO WERTEVAR ( WVTEIL, WVMERKMAL, WVUNTERS, WVWERTNR, WVWERT, WVATTRIBUT, WVPRUEFER, WVPRUEFMIT, WVMASCHINE, WVNEST, WVDATZEIT, WVSTIANF, WVCHARGE, WVAUFTRAG, WV0005 ) VALUES (@PARA1, @PARA2, @PARA3, @PARA4, @PARA5, @PARA6, @PARA7, @PARA8, @PARA9, @PARA10, @PARA11, @PARA12, @PARA13, @PARA14, @PARA_WV0005); END GO create index MEMASTERGUID on MERKMAL(MEMASTERGUID) GO CREATE TABLE ALARMHIST ( TNR INT, MMNR INT, MWNR INT, IDENT VARCHAR(255) ) GO create unique index ALARMHIST on ALARMHIST(TNR, MMNR, IDENT) GO CREATE TABLE DATA_IMAGES ( IM_ID UNIQUEIDENTIFIER, IM_PARENT UNIQUEIDENTIFIER, IM_PATH VARCHAR(80), IM_TYPE TINYINT, IM_TREEDEPTH TINYINT, IM_IMAGE IMAGE ) GO CREATE UNIQUE INDEX DATA_IMAGES ON DATA_IMAGES(IM_ID) GO create table EG_AEND_ZD ( EGTEIL int , EGMERKMAL smallint , EGUNTERS smallint , EGWERTNR int , EG_FIELDS VARCHAR(20), EG_K0006 VARCHAR(50), EG_K0007 int, EG_K0008 int, EG_K0010 int, EG_K0012 int, EG_K0014 VARCHAR(50), EG_K0016 VARCHAR(50), EG_K0017 VARCHAR(50), EG_K0053 VARCHAR(50), EG_K0054 VARCHAR(50), EG_K0055 VARCHAR(50), EG_K0056 VARCHAR(50), EG_K0057 VARCHAR(50), EG_K0058 VARCHAR(50), EG_K0059 VARCHAR(50), EG_K0060 VARCHAR(50), EG_K0061 int, EG_K0062 int, EG_K0063 int, EGCP float , EGCPK float , EGLAGART tinyint , EGLAGSTREU tinyint , EGLAGGRART tinyint , EGPEARSON tinyint , EGMINMAX float , EGMITTELW tinyint , EGCWERTGUE smallint , EGCAUSGZUL tinyint , EGCUN float , EGCUN_UN float , EGCUN_OB float , EGCOB float , EGCOB_UN float , EGCOB_OB float , EGC float , EGC_UN float , EGC_OB float , EGCUNATR tinyint , EGCUNVBATR tinyint , EGCOBATR tinyint , EGCOBVBATR tinyint , EGCATR tinyint , EGCVBATR tinyint , EGCKATR tinyint , EGLAGEMIN float , EGLAGEMAX float , EGLAGUEG float , EGLAGMITTE float , EGLAGOEG float , EGLAGUWG float , EGLAGOWG float , EGLAGUUNT float , EGLAGUOB float , EGP_F float , EGEW_F float , EGGS_F float , EGSAQRKGSF float , EGSTRART tinyint , EGSTRSTREU tinyint , EGSTRBER tinyint , EGSTRUEG float , EGSTRMITTE float , EGSTROEG float , EGSTRUWG float , EGSTROWG float , EGSTRPQFSK float , EGSTRNQFSK float , EGDAT datetime , EGMASCHINE int , EGNEST int , EGUGW float , EGOGW float , EGNENNMASS float , EGLAGUIG FLOAT , EGLAGOIG FLOAT , EGSTRUIG FLOAT , EGSTROIG FLOAT, EG_LEXL float, EG_UEXL float, EG_EXSTART datetime, EG_EXEND datetime, EG_EXVALID tinyint ) GO create unique index EGZ_TM on EG_AEND_ZD (EGTEIL, EGMERKMAL) GO