CREATE TABLE TMSYSTEM.ASWBKLDNL ( DNLTRM VARCHAR(255) BINARY ,DNLASW VARCHAR(13) BINARY ,DNLBKL VARCHAR(3) BINARY  ,PRIMARY KEY(DNLTRM,DNLASW,DNLBKL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2004TYPTASTEN ( TTNTTY VARCHAR(10) BINARY ,TTNTAS DECIMAL(5,0) DEFAULT 0,TTNSTA DECIMAL(5,0) DEFAULT 1,TTNDAT DATETIME ,TTNERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TTNTTY,TTNTAS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2005ZEITPUNKT ( TZUZPL VARCHAR(10) BINARY ,TZUUHR DATETIME ,TZUSTA DECIMAL(5,0) DEFAULT 1,TZUDAT DATETIME ,TZUERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TZUZPL,TZUUHR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2006DATDNLLST ( DDLLIZ VARCHAR(5) BINARY ,DDLMND VARCHAR(5) BINARY ,DDLNAM VARCHAR(50) BINARY ,DDLTYP DECIMAL(5,0) DEFAULT 0,DDLDNM VARCHAR(200) BINARY ,DDLDTV DATETIME ,DDLDTB DATETIME ,DDLUZV DATETIME ,DDLUZB DATETIME ,DDLSTA DECIMAL(1,0) DEFAULT 1,DDLDAT DATETIME ,DDLERF VARCHAR(50) BINARY DEFAULT 'Timesys',DDLZAG DECIMAL(1,0) DEFAULT 1,DDLTRM VARCHAR(255) BINARY ,DDLDLA DECIMAL(1,0)  ,PRIMARY KEY(DDLLIZ,DDLMND,DDLNAM,DDLTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2006TXTDNLLST ( TXTLIZ VARCHAR(5) BINARY ,TXTMND VARCHAR(5) BINARY ,TXTNAM VARCHAR(50) BINARY ,TXTTYP DECIMAL(5,0) DEFAULT 0,TXTLFD DECIMAL(5,0) ,TXTTXT VARCHAR(4000) BINARY ,TXTAUS VARCHAR(50) BINARY  ,PRIMARY KEY(TXTLIZ,TXTMND,TXTNAM,TXTTYP,TXTLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2100TASLST ( TTANUM VARCHAR(10) BINARY ,TTATYP VARCHAR(10) BINARY ,TTATAS DECIMAL(5,0) DEFAULT 0,TTABCH VARCHAR(3) BINARY ,TTATTX DECIMAL(5,0) DEFAULT 0,TTASTA DECIMAL(5,0) DEFAULT 1,TTADAT DATETIME ,TTAERF VARCHAR(50) BINARY DEFAULT 'Timesys',TTADNC DECIMAL(5,0) ,TTAFTP DECIMAL(5,0) DEFAULT 0,TTAZUT DECIMAL(5,0) DEFAULT 0,TTARAS DECIMAL(5,0) DEFAULT 0,TTAMSG DECIMAL(5,0) DEFAULT 0,TTAPOS DECIMAL(2,0)  ,PRIMARY KEY(TTANUM,TTATYP,TTATAS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2101SALLST ( TSASAL VARCHAR(10) BINARY ,TSALFD DECIMAL(5,0) DEFAULT 0,TSAANZ DECIMAL(5,0) DEFAULT 0,TSAAUS DECIMAL(5,0) DEFAULT 0,TSASTA DECIMAL(5,0) DEFAULT 1,TSADAT DATETIME ,TSAERF VARCHAR(50) BINARY DEFAULT 'Timesys',TSASPL DECIMAL(2,0)  ,PRIMARY KEY(TSASAL,TSALFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2102UPLLST ( TUWUPL VARCHAR(10) BINARY ,TUWDTN VARCHAR(200) BINARY ,TUWLFD DECIMAL(5,0) DEFAULT 1,TUWZPL VARCHAR(10) BINARY ,TUWSTA DECIMAL(5,0) DEFAULT 1,TUWDAT DATETIME ,TUWERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TUWUPL,TUWDTN,TUWLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.G2103DNLLST ( DLLNAM VARCHAR(10) BINARY ,DLLDTN VARCHAR(200) BINARY ,DLLLFN DECIMAL(5,0) DEFAULT 1,DLLZPL VARCHAR(10) BINARY ,DLLSTA DECIMAL(5,0) DEFAULT 1,DLLDAT DATETIME ,DLLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(DLLNAM,DLLDTN,DLLLFN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSSTFCD ( FCDLIZ VARCHAR(5) BINARY ,FCDMND VARCHAR(5) BINARY ,FCDNUM VARCHAR(3) BINARY ,FCDKRT VARCHAR(2) BINARY ,FCDTXT VARCHAR(50) BINARY ,FCDDAT DATETIME ,FCDTYP DECIMAL(5,0) ,FCDFCD DECIMAL(5,0)  ,PRIMARY KEY(FCDLIZ,FCDMND,FCDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSSTFTG ( FTGTRM VARCHAR(255) BINARY ,FTGLIZ VARCHAR(5) BINARY ,FTGMND VARCHAR(5) BINARY ,FTGJHR VARCHAR(4) BINARY ,FTGDTM VARCHAR(8) BINARY ,FTGTXT VARCHAR(20) BINARY ,FTGKRT VARCHAR(1) BINARY ,FTGDAT DATETIME ,FTGKAL VARCHAR(3) BINARY DEFAULT ' ' ,PRIMARY KEY(FTGTRM,FTGLIZ,FTGMND,FTGDTM,FTGKAL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSSTMDT ( MDTLIZ VARCHAR(5) BINARY ,MDTMND VARCHAR(5) BINARY ,MDTASW VARCHAR(13) BINARY ,MDTDTM VARCHAR(10) BINARY ,MDTABE VARCHAR(33) BINARY ,MDTSBE VARCHAR(33) BINARY ,MDTSTS VARCHAR(1) BINARY ,MDTKRT VARCHAR(1) BINARY ,MDTDAT DATETIME ,MDTFCD VARCHAR(3) BINARY  ,PRIMARY KEY(MDTLIZ,MDTMND,MDTASW,MDTDTM,MDTSTS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSSTMST ( MSTLIZ VARCHAR(5) BINARY ,MSTMND VARCHAR(5) BINARY ,MSTASW VARCHAR(13) BINARY ,MSTSTS VARCHAR(1) BINARY ,MSTVBI VARCHAR(23) BINARY ,MSTABE VARCHAR(33) BINARY ,MSTSBE VARCHAR(33) BINARY ,MSTKRT VARCHAR(1) BINARY ,MSTKST VARCHAR(50) BINARY ,MSTDAT DATETIME ,MSTVON VARCHAR(8) BINARY ,MSTABT VARCHAR(30) BINARY ,MSTUH1 VARCHAR(4) BINARY ,MSTFCD VARCHAR(3) BINARY  ,PRIMARY KEY(MSTLIZ,MSTMND,MSTASW,MSTSTS,MSTVBI,MSTVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSST20P ( M20TRM VARCHAR(255) BINARY ,M20SCH VARCHAR(2) BINARY ,M20TG1 VARCHAR(1) BINARY ,M20ZZ2 VARCHAR(5) BINARY ,M20OFV VARCHAR(4) BINARY ,M20OFB VARCHAR(4) BINARY ,M20DAT DATETIME  ,PRIMARY KEY(M20TRM,M20SCH,M20TG1,M20ZZ2,M20OFV)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSST35P ( M35TRM VARCHAR(255) BINARY ,M35FIR VARCHAR(3) BINARY ,M35BKL VARCHAR(5) BINARY ,M35LES VARCHAR(2) BINARY ,M35WLE VARCHAR(2) BINARY ,M35WPL VARCHAR(3) BINARY ,M35ZKO VARCHAR(5) BINARY ,M35ZZO VARCHAR(5) BINARY ,M35BCH VARCHAR(1) BINARY ,M35DAT DATETIME  ,PRIMARY KEY(M35TRM,M35FIR,M35BKL,M35LES,M35WLE,M35WPL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.MGSST41P ( M41TRM VARCHAR(255) BINARY ,M41FIR VARCHAR(3) BINARY ,M41ZPL VARCHAR(3) BINARY ,M41WNR VARCHAR(2) BINARY ,M41ZZO VARCHAR(3) BINARY ,M41TNR VARCHAR(1) BINARY ,M41VON VARCHAR(4) BINARY ,M41BIS VARCHAR(4) BINARY ,M41DAT DATETIME  ,PRIMARY KEY(M41TRM,M41FIR,M41ZPL,M41WNR,M41ZZO,M41TNR,M41VON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O1201FORMULAR ( FMRNUM VARCHAR(20) BINARY ,FMRART DECIMAL(5,0) DEFAULT 0,FMRLNK VARCHAR(50) BINARY ,FMRFLD DECIMAL(11,0) DEFAULT 120101,FMRWHL DECIMAL(5,0) DEFAULT 0,FMRTXT VARCHAR(50) BINARY ,FMRSTA DECIMAL(5,0) DEFAULT 1,FMRDAT DATETIME ,FMRERF VARCHAR(50) BINARY DEFAULT 'Timesys',FMRMOD DECIMAL(5,0) ,FMRFRM DECIMAL(1,0) DEFAULT 1,FMRRTE DECIMAL(5,0) DEFAULT 0,FMRMNU DECIMAL(5,0) DEFAULT 0,FMRMDL DECIMAL(5,0)  ,PRIMARY KEY(FMRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O1201SPRACHE ( SPRNUM DECIMAL(5,0) DEFAULT 0,SPRTXT VARCHAR(50) BINARY ,SPRSTA DECIMAL(5,0) DEFAULT 1,SPRDAT DATETIME ,SPRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SPRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O1801SCHALT ( SFLNUM VARCHAR(15) BINARY ,SFLTXT VARCHAR(50) BINARY ,SFLKTX VARCHAR(10) BINARY ,SFLFLD DECIMAL(11,0) DEFAULT 2,SFLWHL DECIMAL(5,0) DEFAULT 1,SFLLNK VARCHAR(50) BINARY ,SFLBEF VARCHAR(100) BINARY ,SFLHOE DECIMAL(5,0) DEFAULT 0,SFLBRE DECIMAL(5,0) DEFAULT 0,SFLSTA DECIMAL(5,0) DEFAULT 1,SFLDAT DATETIME ,SFLERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SFLNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O1803FRMSCHALTLST ( FRMSFLFRM VARCHAR(20) BINARY ,FRMSFLSCH VARCHAR(15) BINARY ,FRMSFLFUN VARCHAR(100) BINARY ,FRMSFLSTA DECIMAL(1,0) DEFAULT 1,FRMSFLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',FRMSFLDAT DATETIME  ,PRIMARY KEY(FRMSFLFRM,FRMSFLSCH)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2000TASTTEXTE ( TAZNUM DECIMAL(5,0) DEFAULT 0,TAZTXT VARCHAR(50) BINARY ,TAZSTA DECIMAL(5,0) DEFAULT 1,TAZDAT DATETIME ,TAZERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TAZNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2001SALTEXTE ( STXNAM VARCHAR(50) BINARY ,STXSPR DECIMAL(5,0) ,STXNUM DECIMAL(5,0) DEFAULT 0,STXTXT VARCHAR(200) BINARY ,STXSTA DECIMAL(5,0) DEFAULT 1,STXDAT DATETIME ,STXERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(STXNAM,STXSPR,STXNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2002SALWERTE ( SWTNUM DECIMAL(5,0) DEFAULT 0,SWTTXT VARCHAR(50) BINARY ,SWTSTA DECIMAL(5,0) DEFAULT 1,SWTDAT DATETIME ,SWTERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(SWTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2002TSW ( TSWIDN VARCHAR(50) BINARY ,TSWSTO VARCHAR(8) BINARY ,TSWLIZ VARCHAR(5) BINARY ,TSWMND VARCHAR(5) BINARY ,TSWW01 VARCHAR(8) BINARY ,TSWW02 VARCHAR(10) BINARY ,TSWW03 VARCHAR(10) BINARY ,TSWW04 VARCHAR(10) BINARY ,TSWW05 VARCHAR(10) BINARY ,TSWW06 VARCHAR(10) BINARY ,TSWW07 VARCHAR(10) BINARY ,TSWW08 VARCHAR(10) BINARY ,TSWW09 VARCHAR(10) BINARY ,TSWW10 VARCHAR(10) BINARY ,TSWW11 VARCHAR(10) BINARY ,TSWW12 VARCHAR(10) BINARY ,TSWW13 VARCHAR(10) BINARY ,TSWW14 VARCHAR(10) BINARY ,TSWW15 VARCHAR(10) BINARY ,TSWW16 VARCHAR(10) BINARY ,TSWF01 VARCHAR(20) BINARY ,TSWF02 VARCHAR(20) BINARY ,TSWF03 VARCHAR(20) BINARY ,TSWF04 VARCHAR(20) BINARY ,TSWF05 VARCHAR(20) BINARY ,TSWF06 VARCHAR(20) BINARY ,TSWF07 VARCHAR(20) BINARY ,TSWF08 VARCHAR(20) BINARY ,TSWF09 VARCHAR(20) BINARY ,TSWF10 VARCHAR(20) BINARY ,TSWAMP VARCHAR(5) BINARY  ,PRIMARY KEY(TSWIDN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2003BUCHCODE ( TBCCOD VARCHAR(3) BINARY ,TBCTXT VARCHAR(50) BINARY ,TBCSTA DECIMAL(5,0) DEFAULT 1,TBCDAT DATETIME ,TBCERF VARCHAR(50) BINARY DEFAULT 'Timesys',TBCFCD VARCHAR(3) BINARY  ,PRIMARY KEY(TBCCOD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2004TASTTYP ( TTYNAM VARCHAR(10) BINARY ,TTYTXT VARCHAR(50) BINARY ,TTYSTA DECIMAL(5,0) DEFAULT 1,TTYDAT DATETIME ,TTYERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TTYNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2005ZEITMODELL ( TZMNAM VARCHAR(10) BINARY ,TZMTXT VARCHAR(50) BINARY ,TZMSTA DECIMAL(5,0) DEFAULT 1,TZMDAT DATETIME ,TZMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TZMNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2006TRMDATEI ( TRDNAM VARCHAR(200) BINARY ,TRDTXT VARCHAR(200) BINARY ,TRDART DECIMAL(5,0) DEFAULT 1,TRDTYP DECIMAL(5,0) DEFAULT 0,TRDVER VARCHAR(10) BINARY ,TRDSTA DECIMAL(5,0) DEFAULT 1,TRDDAT DATETIME ,TRDERF VARCHAR(50) BINARY DEFAULT 'Timesys',TRDTCN VARCHAR(32) BINARY ,TRDLIZ VARCHAR(5) BINARY ,TRDMND VARCHAR(5) BINARY  ,PRIMARY KEY(TRDNAM,TRDTYP,TRDLIZ,TRDMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2007TRMTYP ( TMTNAM VARCHAR(10) BINARY ,TMTTXT VARCHAR(50) BINARY ,TMTCMD VARCHAR(64) BINARY ,TMTSTA DECIMAL(5,0) DEFAULT 1,TMTDAT DATETIME ,TMTERF VARCHAR(50) BINARY DEFAULT 'Timesys',TMTTYP VARCHAR(10) BINARY  ,PRIMARY KEY(TMTNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2008TRANSPROT ( TRSDAT DATETIME ,TRSUSR VARCHAR(50) BINARY ,TRSTYP VARCHAR(50) BINARY ,TRSFILE VARCHAR(255) BINARY ,TRSTRM VARCHAR(255) BINARY ,TRSSTA VARCHAR(200) BINARY  ,PRIMARY KEY(TRSDAT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2009BUCHPROT ( BPRTRM VARCHAR(255) BINARY ,BPRZLS DECIMAL(5,0) ,BPRAWV VARCHAR(50) BINARY ,BPRDAT DATETIME ,BPRDTE DATETIME ,BPRFCD VARCHAR(5) BINARY ,BPRERG DECIMAL(3,0) ,BPRVAR VARCHAR(200) BINARY  ,PRIMARY KEY(BPRTRM,BPRZLS,BPRDTE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2100TASTTAB ( TTTNAM VARCHAR(10) BINARY ,TTTTXT VARCHAR(50) BINARY ,TTTKTX VARCHAR(10) BINARY ,TTTSTA DECIMAL(5,0) DEFAULT 1,TTTDAT DATETIME ,TTTERF VARCHAR(50) BINARY DEFAULT 'Timesys',TTTART DECIMAL(2,0) ,TTTTAS DECIMAL(1,0) ,TTTTTP VARCHAR(10) BINARY ,TTTFST DECIMAL(1,0)  ,PRIMARY KEY(TTTNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2101SALTAB ( TSLNAM VARCHAR(10) BINARY ,TSLDAU DECIMAL(5,0) DEFAULT 0,TSLTXT VARCHAR(50) BINARY ,TSLKTX VARCHAR(10) BINARY ,TSLSTA DECIMAL(5,0) DEFAULT 1,TSLDAT DATETIME ,TSLERF VARCHAR(50) BINARY DEFAULT 'Timesys',TSLART DECIMAL(1,0) DEFAULT 1 ,PRIMARY KEY(TSLNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2102UPLTAB ( TUMNAM VARCHAR(10) BINARY ,TUMDLY DECIMAL(11,0) DEFAULT 0,TUMTXT VARCHAR(50) BINARY ,TUMKTX VARCHAR(10) BINARY ,TUMSTA DECIMAL(5,0) DEFAULT 1,TUMDAT DATETIME ,TUMERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TUMNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2103DNLTAB ( TDNNAM VARCHAR(10) BINARY ,TDNTXT VARCHAR(50) BINARY ,TDNKTX VARCHAR(10) BINARY ,TDNSTA DECIMAL(5,0) DEFAULT 1,TDNDAT DATETIME ,TDNERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TDNNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2106MIN ( MINMIN DECIMAL(5,0) ,STDMIN VARCHAR(4) BINARY  ,PRIMARY KEY(MINMIN)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2106TFK ( TFKTTT VARCHAR(10) BINARY ,TFKTNM DECIMAL(5,0) ,TFKWTG DECIMAL(1,0) ,TFKV01 DECIMAL(4,0) ,TFKB01 DECIMAL(4,0) ,TFKV02 DECIMAL(4,0) ,TFKB02 DECIMAL(4,0) ,TFKV03 DECIMAL(4,0) ,TFKB03 DECIMAL(4,0) ,TFKV04 DECIMAL(4,0) ,TFKB04 DECIMAL(4,0) ,TFKV05 DECIMAL(4,0) ,TFKB05 DECIMAL(4,0) ,TFKV06 DECIMAL(4,0) ,TFKB06 DECIMAL(4,0) ,TFKV07 DECIMAL(4,0) ,TFKB07 DECIMAL(4,0) ,TFKV08 DECIMAL(4,0) ,TFKB08 DECIMAL(4,0) ,TFKV09 DECIMAL(4,0) ,TFKB09 DECIMAL(4,0) ,TFKV10 DECIMAL(4,0) ,TFKB10 DECIMAL(4,0) ,TFKV11 DECIMAL(4,0) ,TFKB11 DECIMAL(4,0) ,TFKV12 DECIMAL(4,0) ,TFKB12 DECIMAL(4,0) ,TFKERF VARCHAR(50) BINARY ,TFKDAT VARCHAR(14) BINARY  ,PRIMARY KEY(TFKTTT,TFKTNM,TFKWTG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2107TTF ( TTFTTT VARCHAR(10) BINARY ,TTFTNM DECIMAL(5,0) ,TTFF01 DECIMAL(1,0) DEFAULT 0,TTFF02 DECIMAL(1,0) DEFAULT 0,TTFF03 DECIMAL(1,0) DEFAULT 0,TTFF04 DECIMAL(1,0) DEFAULT 0,TTFF05 DECIMAL(1,0) DEFAULT 0,TTFF06 DECIMAL(1,0) DEFAULT 0,TTFF07 DECIMAL(1,0) DEFAULT 0,TTFF08 DECIMAL(1,0) DEFAULT 0,TTFF09 DECIMAL(1,0) DEFAULT 0,TTFF10 DECIMAL(1,0) DEFAULT 0,TTFF11 DECIMAL(1,0) DEFAULT 0,TTFF12 DECIMAL(1,0) DEFAULT 0,TTFDAT DATETIME ,TTFFCD VARCHAR(3) BINARY ,TTFMNU DECIMAL(1,0) ,TTFFTP DECIMAL(5,0) ,TTFTAV DECIMAL(1,0)  ,PRIMARY KEY(TTFTTT,TTFTNM,TTFMNU)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2108TTA ( TTANUM VARCHAR(10) BINARY ,TTATYP VARCHAR(10) BINARY ,TTAMNU DECIMAL(1,0) ,TTATAS DECIMAL(5,0) ,TTABCH VARCHAR(3) BINARY ,TTAPOS DECIMAL(2,0) ,TTATXT VARCHAR(30) BINARY ,TTADNC DECIMAL(5,0) ,TTAFTP DECIMAL(5,0) ,TTADAT DATETIME ,TTAERF VARCHAR(50) BINARY DEFAULT 'Timesys',TTAF01 DECIMAL(1,0) ,TTAF02 DECIMAL(1,0) ,TTAF03 DECIMAL(1,0) ,TTAF04 DECIMAL(1,0) ,TTAF05 DECIMAL(1,0) ,TTAF06 DECIMAL(1,0) ,TTAF07 DECIMAL(1,0) ,TTAF08 DECIMAL(1,0) ,TTAF09 DECIMAL(1,0) ,TTAF10 DECIMAL(1,0) ,TTAF11 DECIMAL(1,0) ,TTAF12 DECIMAL(1,0) ,TTAFCD VARCHAR(3) BINARY ,TTAAPS DECIMAL(2,0) ,TTATAV DECIMAL(1,0)  ,PRIMARY KEY(TTANUM,TTATYP,TTAMNU,TTATAS,TTAPOS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.O2200SZL ( SZLTXT DECIMAL(5,0) ,SZLWRT DECIMAL(5,0) ,SZLTX1 VARCHAR(50) BINARY ,SZLFRM DECIMAL(5,0) ,SZLSTA DECIMAL(1,0) DEFAULT 0,SZLDAT DATETIME ,SZLERF VARCHAR(50) BINARY ,SZLEIN DECIMAL(5,0)  ,PRIMARY KEY(SZLTXT,SZLWRT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.SALASWDNL ( DNLSAL VARCHAR(10) BINARY ,DNLLIZ VARCHAR(5) BINARY ,DNLMND VARCHAR(5) BINARY ,DNLSPR DECIMAL(1,0) ,DNLASW VARCHAR(13) BINARY ,DNLSA1 VARCHAR(20) BINARY ,DNLSA2 VARCHAR(20) BINARY ,DNLSA3 VARCHAR(20) BINARY ,DNLSA4 VARCHAR(20) BINARY ,DNLSA5 VARCHAR(20) BINARY ,DNLSA6 VARCHAR(20) BINARY ,DNLSA7 VARCHAR(20) BINARY ,DNLSA8 VARCHAR(20) BINARY ,DNLWR1 VARCHAR(20) BINARY ,DNLWR2 VARCHAR(20) BINARY ,DNLWR3 VARCHAR(20) BINARY ,DNLWR4 VARCHAR(20) BINARY ,DNLWR5 VARCHAR(20) BINARY ,DNLWR6 VARCHAR(20) BINARY ,DNLWR7 VARCHAR(20) BINARY ,DNLWR8 VARCHAR(20) BINARY  ,PRIMARY KEY(DNLSAL,DNLLIZ,DNLMND,DNLSPR,DNLASW)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.SALASWDNL2 ( DNLSAL VARCHAR(10) BINARY ,DNLLIZ VARCHAR(5) BINARY ,DNLMND VARCHAR(5) BINARY ,DNLSPR DECIMAL(1,0) ,DNLASW VARCHAR(13) BINARY ,DNLWRT DECIMAL(3,0) ,DNLVAL VARCHAR(20) BINARY  ,PRIMARY KEY(DNLSAL,DNLLIZ,DNLMND,DNLSPR,DNLASW,DNLWRT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMSASWDNL ( DNLKEY VARCHAR(14) BINARY ,DNLLFD DECIMAL(5,0) ,DNLMND VARCHAR(5) BINARY ,DNLLIZ VARCHAR(5) BINARY ,DNLASW VARCHAR(50) BINARY ,DNLKZE DECIMAL(1,0) ,DNLKZU DECIMAL(1,0) ,DNLKMP DECIMAL(1,0) ,DNLBKL VARCHAR(6) BINARY ,DNLSTA DECIMAL(3,0) ,DNLERF VARCHAR(50) BINARY ,DNLDAT DATETIME  ,PRIMARY KEY(DNLKEY,DNLLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMSAUTODNL ( DNLKEY VARCHAR(14) BINARY ,DNLUSR VARCHAR(50) BINARY ,DNLTRM VARCHAR(50) BINARY ,DNLSTA DECIMAL(3,0) ,DNLERR DECIMAL(3,0) ,DNLMND VARCHAR(5) BINARY ,DNLLIZ VARCHAR(5) BINARY ,DNLDAT DATETIME  ,PRIMARY KEY(DNLKEY,DNLUSR,DNLTRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMSJOBS ( JOBUSR CHAR(10) ,JOBNUM CHAR(6) ,JOBDAT DATETIME  ,PRIMARY KEY(JOBUSR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS000CHK ( CHKPRG VARCHAR(512) BINARY ,CHKSTA DECIMAL(2,0) DEFAULT 0,CHKDAT DATETIME ,CHKERF VARCHAR(50) BINARY ,CHKCHK VARCHAR(32) BINARY  ,PRIMARY KEY(CHKPRG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS000LOG ( LOGIDE VARCHAR(5) BINARY ,LOGPRG VARCHAR(512) BINARY ,LOGDAT DATETIME ,LOGACT DECIMAL(2,0)  ,PRIMARY KEY(LOGIDE,LOGPRG,LOGDAT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS000USR ( USRIDE VARCHAR(5) BINARY ,USRNAM VARCHAR(50) BINARY ,USRPWD VARCHAR(32) BINARY  ,PRIMARY KEY(USRIDE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS001ERR ( ERRPRM DECIMAL(10,0) ,ERRLFD DECIMAL(5,0) ,ERRDAT DATETIME ,ERRPNR VARCHAR(8) BINARY ,ERRKEY DECIMAL(8,0)  ,PRIMARY KEY(ERRPRM,ERRLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS001LNK ( LNKSBE VARCHAR(8) BINARY ,LNKNUM VARCHAR(10) BINARY ,LNKMOD VARCHAR(3) BINARY ,LNKMND VARCHAR(2) BINARY ,LNKLIZ VARCHAR(5) BINARY ,LNKFRM VARCHAR(50) BINARY ,LNKDTL VARCHAR(50) BINARY ,LNKKEY VARCHAR(200) BINARY ,LNKRE1 VARCHAR(100) BINARY ,LNKRE2 VARCHAR(100) BINARY ,LNKVKZ VARCHAR(1) BINARY ,LNKRDT VARCHAR(8) BINARY ,LNKDAT VARCHAR(14) BINARY ,LNKART VARCHAR(1) BINARY ,LNKFLG DECIMAL(3,0) ,LNKPNR VARCHAR(8) BINARY ,LNKANM VARCHAR(50) BINARY ,LNKGVO VARCHAR(8) BINARY DEFAULT '20100101',LNKGBI VARCHAR(8) BINARY DEFAULT '20301231',LNKVSB VARCHAR(8) BINARY  ,PRIMARY KEY(LNKSBE,LNKNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS001LOG ( LOGPRG VARCHAR(30) BINARY ,LOGSTZ VARCHAR(14) BINARY ,LOGPRM VARCHAR(150) BINARY ,LOGSCH VARCHAR(20) BINARY ,LOGMOD VARCHAR(10) BINARY ,LOGPNR VARCHAR(8) BINARY ,LOGDTM DATETIME ,LOGFKT VARCHAR(50) BINARY ,LOGTERR DECIMAL(5,0) DEFAULT 0,LOGTTXT VARCHAR(256) BINARY ,LOGSERR DECIMAL(5,0) DEFAULT 0,LOGSTXT VARCHAR(256) BINARY ,LOGMSG VARCHAR(256) BINARY ,LOGTYP DECIMAL(1,0) DEFAULT 0,LOGDAT DATETIME      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS001PRM ( PRMNUM DECIMAL(10,0) ,PRMLFD DECIMAL(5,0) ,PRMSCH VARCHAR(50) BINARY ,PRMPNR VARCHAR(8) BINARY ,PRMDVO DATETIME ,PRMDBI DATETIME ,PRMADT DATETIME ,PRMUSR VARCHAR(50) BINARY ,PRMDAT VARCHAR(14) BINARY ,PRMINH VARCHAR(8) BINARY  ,PRIMARY KEY(PRMNUM,PRMLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS002ERR ( ERRPRM DECIMAL(10,0) ,ERRLFD DECIMAL(5,0) ,ERRTYP DECIMAL(5,0) DEFAULT 1,ERRPNR VARCHAR(8) BINARY ,ERRFCD VARCHAR(8) BINARY ,ERRDAT DATETIME ,ERRUHR DATETIME ,ERRKEY DECIMAL(8,0) ,ERRTIS TIMESTAMP,ERRNUM DECIMAL(11,0)  ,PRIMARY KEY(ERRPRM,ERRLFD,ERRPNR,ERRKEY,ERRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS002PRM ( PRMNUM DECIMAL(10,0) ,PRMLFD DECIMAL(5,0) ,PRMTYP DECIMAL(5,0) DEFAULT 1,PRMSCH VARCHAR(20) BINARY ,PRMUSR VARCHAR(50) BINARY ,PRMMAP DECIMAL(1,0) ,PRMPNR VARCHAR(8) BINARY ,PRMDTM DATETIME ,PRMDBI DATETIME ,PRMUHR DATETIME ,PRMFCD VARCHAR(3) BINARY ,PRMABT VARCHAR(15) BINARY ,PRMKST VARCHAR(30) BINARY ,PRMKTR VARCHAR(6) BINARY ,PRMKRT VARCHAR(4) BINARY ,PRMVRA VARCHAR(5) BINARY ,PRMAZT VARCHAR(6) BINARY ,PRMTXT DECIMAL(11,0) ,PRMLOE DECIMAL(1,0) ,PRMBUC DECIMAL(1,0) ,PRMVKD DECIMAL(2,0) ,PRMSTS DECIMAL(2,0) ,PRMERF VARCHAR(50) BINARY ,PRMDAT DATETIME ,PRMTRM DECIMAL(1,0) DEFAULT NULL ,PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS003ERR ( ERRPRM DECIMAL(10,0) ,ERRLFD DECIMAL(5,0) ,ERRTYP DECIMAL(5,0) ,ERRPNR VARCHAR(8) BINARY ,ERRFCD VARCHAR(8) BINARY ,ERRDAT DATETIME ,ERRUHR DATETIME ,ERRKEY DECIMAL(8,0) ,ERRTIS TIMESTAMP,ERRNUM DECIMAL(11,0)  ,PRIMARY KEY(ERRPRM,ERRLFD,ERRTYP,ERRPNR,ERRKEY,ERRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS003PRM ( PRMNUM DECIMAL(10,0) ,PRMLFD DECIMAL(5,0) ,PRMTYP DECIMAL(5,0) DEFAULT 1,PRMSCH VARCHAR(20) BINARY ,PRMUSR VARCHAR(50) BINARY ,PRMMAP DECIMAL(1,0) ,PRMPNR VARCHAR(8) BINARY ,PRMDTM DATETIME ,PRMDBI DATETIME ,PRMUHR DATETIME ,PRMFCD VARCHAR(3) BINARY ,PRMABT VARCHAR(15) BINARY ,PRMKST VARCHAR(30) BINARY ,PRMKTR VARCHAR(6) BINARY ,PRMKRT VARCHAR(4) BINARY ,PRMVRA VARCHAR(5) BINARY ,PRMAZT VARCHAR(6) BINARY ,PRMTXT DECIMAL(11,0) ,PRMLOE DECIMAL(1,0) ,PRMBUC DECIMAL(1,0) ,PRMVKD DECIMAL(2,0) ,PRMSTS DECIMAL(2,0) ,PRMERF VARCHAR(50) BINARY ,PRMDAT DATETIME ,PRMTRM DECIMAL(1,0) ,PRMADT DATETIME ,PRMINH VARCHAR(8) BINARY  ,PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS004PRM ( PRMNUM DECIMAL(10,0) ,PRMLFD DECIMAL(5,0) ,PRMTYP DECIMAL(5,0) DEFAULT 1,PRMSCH VARCHAR(20) BINARY ,PRMUSR VARCHAR(50) BINARY ,PRMMAP DECIMAL(1,0) ,PRMPNR VARCHAR(8) BINARY ,PRMDTM DATETIME ,PRMDBI DATETIME ,PRMUHR DATETIME ,PRMFCD VARCHAR(3) BINARY ,PRMABT VARCHAR(15) BINARY ,PRMKST VARCHAR(30) BINARY ,PRMKTR VARCHAR(6) BINARY ,PRMKRT VARCHAR(4) BINARY ,PRMVRA VARCHAR(5) BINARY ,PRMAZT VARCHAR(6) BINARY ,PRMTXT DECIMAL(11,0) ,PRMLOE DECIMAL(1,0) ,PRMBUC DECIMAL(1,0) ,PRMVKD DECIMAL(2,0) ,PRMSTS DECIMAL(2,0) ,PRMERF VARCHAR(50) BINARY ,PRMDAT DATETIME ,PRMTRM DECIMAL(1,0) ,PRMADT DATETIME ,PRMINH VARCHAR(8) BINARY  ,PRIMARY KEY(PRMNUM,PRMLFD,PRMTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS010HIS ( HISTNR DECIMAL(7,0) ,HISLFD DECIMAL(2,0) ,HISDEF VARCHAR(15) BINARY ,HISUSR VARCHAR(50) BINARY ,HISFLD VARCHAR(9) BINARY ,HISOVL VARCHAR(255) BINARY ,HISNVL VARCHAR(255) BINARY ,HISKEY VARCHAR(255) BINARY ,HISOUS VARCHAR(50) BINARY ,HISIP VARCHAR(15) BINARY ,HISDST VARCHAR(50) BINARY ,HISDAT DATETIME ,HISNUM DECIMAL(11,0) ,HISWHL DECIMAL(5,0)  ,PRIMARY KEY(HISTNR,HISLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS010TAZ ( TAZDEF VARCHAR(15) BINARY ,TAZMSK VARCHAR(15) BINARY ,TAZDAT DATETIME  ,PRIMARY KEY(TAZDEF,TAZMSK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS100DBFLD ( TBSTNA VARCHAR(25) BINARY ,TBSLFD DECIMAL(5,0) ,TBSFNA VARCHAR(11) BINARY ,TBSFNR DECIMAL(11,0) ,TBSDAT DATETIME ,TBSERF VARCHAR(50) BINARY ,TBSTYP VARCHAR(50) BINARY ,TBSLEN DECIMAL(5,0) ,TBSPRE DECIMAL(5,0) ,TBSTMS DECIMAL(1,0)  ,PRIMARY KEY(TBSTNA,TBSLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS100TBS ( TBSTNA VARCHAR(15) BINARY ,TBSLFD DECIMAL(5,0) DEFAULT 0,TBSFNA VARCHAR(9) BINARY ,TBSFNR DECIMAL(11,0) DEFAULT 0,TBSAUS DECIMAL(11,0) DEFAULT 0,TBSINI VARCHAR(50) BINARY ,TBSFNU VARCHAR(9) BINARY ,TBSBZG DECIMAL(5,0) DEFAULT 1,TBSKEY DECIMAL(5,0) DEFAULT 0,TBSIND DECIMAL(5,0) DEFAULT 1,TBSMUS DECIMAL(1,0) DEFAULT 0,TBSSTA DECIMAL(5,0) DEFAULT 1,TBSDAT DATETIME ,TBSERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TBSTNA,TBSLFD) ,CONSTRAINT TMS100TBS_UK UNIQUE(TBSFNA) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS102FTX ( FTXNUM DECIMAL(11,0) DEFAULT 0,FTXTYP DECIMAL(5,0) DEFAULT 1,FTXLAN DECIMAL(5,0) DEFAULT 0,FTXDEZ DECIMAL(5,0) DEFAULT 0,FTXSTA DECIMAL(5,0) DEFAULT 1,FTXDAT DATETIME ,FTXERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FTXNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS102TXT ( TEXNUMSPR DECIMAL(11,0) ,TEXWHL DECIMAL(5,0) ,TEXTXT DECIMAL(1,0) DEFAULT 2,TEXDAT DATETIME ,TEXERF VARCHAR(50) BINARY DEFAULT 'Timesys',TEXSP2 DECIMAL(1,0) DEFAULT 2,TEXSP3 DECIMAL(1,0) DEFAULT 2,TEXSP4 DECIMAL(1,0) DEFAULT 2,TEXSP5 DECIMAL(1,0) DEFAULT 2,TEXSP6 DECIMAL(1,0) DEFAULT 2,TEXSP7 DECIMAL(1,0) DEFAULT 2,TEXSPR DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(TEXNUMSPR,TEXWHL,TEXSPR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS102WHL ( FTXNUMSPR DECIMAL(11,0) DEFAULT 0,FTXWHL DECIMAL(5,0) DEFAULT 0,FTXSPR DECIMAL(5,0) DEFAULT 1,FTXT50 VARCHAR(120) BINARY ,FTXT30 VARCHAR(120) BINARY ,FTXT10 VARCHAR(10) BINARY ,FTXT05 VARCHAR(5) BINARY ,FTXMSK DECIMAL(5,0) DEFAULT 1,FTXDOK TEXT ,FTXPRG TEXT ,FTXCLS VARCHAR(20) BINARY ,FTXSTASPR DECIMAL(5,0) DEFAULT 1,FTXDATSPR DATETIME ,FTXERFSPR VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(FTXNUMSPR,FTXWHL,FTXSPR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS103DMYANM ( DMYANM VARCHAR(50) BINARY ,DMYFRM VARCHAR(20) BINARY ,DMYFLD VARCHAR(9) BINARY ,DMYPOS DECIMAL(5,0) DEFAULT 1,DMYSRT DECIMAL(5,0) DEFAULT 0,DMYRIC VARCHAR(10) BINARY  ,PRIMARY KEY(DMYANM,DMYFRM,DMYFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS103FRM ( FRMNAM VARCHAR(20) BINARY ,FRMLFD DECIMAL(5,0) DEFAULT 0,FRMFLD VARCHAR(9) BINARY ,FRMBEA DECIMAL(5,0) DEFAULT 5,FRMTXT DECIMAL(5,0) DEFAULT 1,FRMBBR DECIMAL(11,0) DEFAULT 5,FRMBXP DECIMAL(11,0) DEFAULT 1,FRMBYP DECIMAL(11,0) DEFAULT 1,FRMWBR DECIMAL(11,0) DEFAULT 5,FRMWXP DECIMAL(11,0) DEFAULT 1,FRMWYP DECIMAL(11,0) DEFAULT 1,FRMAUF DECIMAL(5,0) DEFAULT 1,FRMABF VARCHAR(15) BINARY ,FRMPOS DECIMAL(5,0) DEFAULT 1,FRMCLS VARCHAR(20) BINARY ,FRMZRR DECIMAL(5,0) DEFAULT 1,FRMFFO VARCHAR(15) BINARY ,FRMPRF DECIMAL(1,0) DEFAULT 0,FRMBOX DECIMAL(5,0) DEFAULT 0,FRMSTA DECIMAL(5,0) DEFAULT 1,FRMDAT DATETIME ,FRMERF VARCHAR(50) BINARY DEFAULT 'Timesys',FRMIDX DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(FRMNAM,FRMLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS103FRMANM ( PFRANM VARCHAR(50) BINARY ,PFRFRM VARCHAR(20) BINARY ,PFRFLD VARCHAR(9) BINARY ,PFRPOS DECIMAL(5,0) DEFAULT 1,PFRSTA DECIMAL(5,0) DEFAULT 1,PFRDAT DATETIME ,PFRERF VARCHAR(50) BINARY DEFAULT 'Timesys',PFRSRT DECIMAL(5,0) DEFAULT 0,PFRRIC VARCHAR(10) BINARY ,PFROST DECIMAL(5,0) ,PFRORI VARCHAR(5) BINARY  ,PRIMARY KEY(PFRANM,PFRFRM,PFRFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS103FRMRTR ( RTRNUM VARCHAR(20) BINARY ,RTRLFD DECIMAL(5,0) DEFAULT 1,RTRFRM VARCHAR(20) BINARY ,RTRINC VARCHAR(60) BINARY ,RTRSTA DECIMAL(5,0) DEFAULT 1,RTRDAT DATETIME ,RTRERF VARCHAR(50) BINARY DEFAULT 'Timesys',RTRFNK VARCHAR(50) BINARY ,RTRMOD DECIMAL(5,0)  ,PRIMARY KEY(RTRNUM,RTRLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS103FRMTXT ( FRMTXTFRM VARCHAR(20) BINARY ,FRMTXTBLK VARCHAR(50) BINARY ,FRMTXTFTX DECIMAL(11,0) ,FRMTXTWHL DECIMAL(9,0) ,FRMTXTLFD DECIMAL(5,0) ,FRMTXTART DECIMAL(1,0)  ,PRIMARY KEY(FRMTXTFRM,FRMTXTBLK,FRMTXTFTX,FRMTXTWHL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS104WEB ( WEBANM VARCHAR(50) BINARY ,WEBLIZ VARCHAR(5) BINARY ,WEBMND VARCHAR(5) BINARY ,WEBPNR VARCHAR(8) BINARY ,WEBMRT VARCHAR(15) BINARY ,WEBMEN VARCHAR(15) BINARY ,WEBPRT VARCHAR(15) BINARY ,WEBZUG DECIMAL(5,0) DEFAULT 1,WEBSRT VARCHAR(15) BINARY ,WEBDYN DECIMAL(1,0) ,WEBFRT VARCHAR(15) BINARY ,WEBBEA DECIMAL(11,0) DEFAULT 1,WEBPIN DECIMAL(1,0) ,WEBFRM VARCHAR(20) BINARY ,WEBZRR DECIMAL(5,0) DEFAULT 1,WEBSPR DECIMAL(5,0) DEFAULT 1,WEBPGR DECIMAL(5,0) DEFAULT 1,WEBVGR VARCHAR(15) BINARY ,WEBGRV VARCHAR(15) BINARY ,WEBGRB VARCHAR(15) BINARY ,WEBZTR DECIMAL(11,0) DEFAULT 1,WEBKPR DECIMAL(5,0) DEFAULT 1,WEBBAS DECIMAL(11,0) DEFAULT 1,WEBVON DATETIME ,WEBBIS DATETIME ,WEBUIP VARCHAR(40) BINARY ,WEBDSU DECIMAL(5,0) DEFAULT 1,WEBDSS DECIMAL(5,0) DEFAULT 1,WEBSTA DECIMAL(5,0) DEFAULT 1,WEBDAT DATETIME ,WEBERF VARCHAR(50) BINARY DEFAULT 'Timesys',WEBTMP VARCHAR(10) BINARY ,WEBFRE VARCHAR(15) BINARY  ,PRIMARY KEY(WEBANM,WEBLIZ,WEBMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS106TYP ( TYPTYP VARCHAR(5) BINARY ,TYPBES VARCHAR(20) BINARY ,TYPSTA DECIMAL(5,0) DEFAULT 1,TYPDAT DATETIME ,TYPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TYPTYP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS107KKR ( KKRNUM VARCHAR(50) BINARY ,KKRBEZ VARCHAR(50) BINARY ,KKRSTA DECIMAL(5,0) DEFAULT 1,KKRDAT DATETIME ,KKRERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KKRNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS107KKZ ( KKZKKR VARCHAR(50) BINARY ,KKZMND VARCHAR(5) BINARY ,KKZLIZ VARCHAR(5) BINARY ,KKZSTA DECIMAL(5,0) DEFAULT 1,KKZDAT DATETIME ,KKZERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(KKZKKR,KKZMND,KKZLIZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS107KSB ( KSBLIZ VARCHAR(5) BINARY ,KSBMND VARCHAR(5) BINARY ,KSBNAM VARCHAR(50) BINARY ,KSBSTA DECIMAL(5,0) ,KSBDAT DATETIME ,KSBERF VARCHAR(50) BINARY ,KSBHOM DECIMAL(1,0) ,KSBNA2 VARCHAR(70) BINARY ,KSBKON DECIMAL(1,0)  ,PRIMARY KEY(KSBLIZ,KSBMND,KSBNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS107MAW ( MAWANM VARCHAR(50) BINARY ,MAWMND VARCHAR(5) BINARY ,MAWLIZ VARCHAR(5) BINARY ,MAWFLD VARCHAR(9) BINARY ,MAWKEY VARCHAR(50) BINARY      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS108PWA ( PWANUM VARCHAR(10) BINARY ,PWAAZT DECIMAL(1,0) ,PWALKW DECIMAL(1,0) ,PWADTA DECIMAL(3,0) ,PWADAZ DECIMAL(3,0) ,PWASTA DECIMAL(5,0) DEFAULT 1,PWADAT DATETIME ,PWAERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PWANUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS108PWC ( PWCANM VARCHAR(50) BINARY ,PWCLIZ VARCHAR(5) BINARY ,PWCMND VARCHAR(5) BINARY ,PWCNUM DECIMAL(5,0) ,PWCPSW VARCHAR(60) BINARY ,PWCSTA DECIMAL(11,0) DEFAULT 1,PWCDAT DATETIME ,PWCERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(PWCANM,PWCLIZ,PWCMND,PWCNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS109INS ( INSPRD VARCHAR(10) BINARY ,INSLIZ DECIMAL(5,0) ,INSSTO DECIMAL(5,0) ,INSIDT DATETIME ,INSADT DATETIME ,INSMDT DATETIME ,INSCSM VARCHAR(32) BINARY ,INSDAT DATETIME  ,PRIMARY KEY(INSPRD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS110LIZ ( LIZLIZ VARCHAR(5) BINARY ,LIZMND VARCHAR(5) BINARY ,LIZPRD VARCHAR(50) BINARY ,LIZVER VARCHAR(10) BINARY ,LIZPNR DECIMAL(11,0) DEFAULT 0,LIZIBG DATETIME ,LIZWBG DATETIME ,LIZEND DATETIME ,LIZDAT DATETIME ,LIZERF VARCHAR(50) BINARY DEFAULT 'Timesys',LIZVVU VARCHAR(5) BINARY  ,PRIMARY KEY(LIZLIZ,LIZMND,LIZPRD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS110TTB ( TTBNAM VARCHAR(10) BINARY ,TTBTXT VARCHAR(30) BINARY ,TTBKTX VARCHAR(10) BINARY ,TTBSTA DECIMAL(5,0) DEFAULT 1,TTBERF VARCHAR(50) BINARY DEFAULT 'Timesys',TTBART DECIMAL(2,0) ,TTBTAS DECIMAL(1,0) ,TTBTTP VARCHAR(10) BINARY ,TTBFST DECIMAL(1,0) ,TTBONM VARCHAR(10) BINARY ,TTBOTX VARCHAR(30) BINARY ,TTBDAT DATETIME ,TTBTXN DECIMAL(3,0) DEFAULT 0,TTBLIZ VARCHAR(5) BINARY ,TTBMND VARCHAR(5) BINARY ,TTBDIM VARCHAR(10) BINARY  ,PRIMARY KEY(TTBNAM,TTBLIZ,TTBMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS111ANM ( ANMANM VARCHAR(50) BINARY DEFAULT 'Timesys',ANMLIZ VARCHAR(5) BINARY ,ANMMND VARCHAR(5) BINARY DEFAULT '0',ANMPSW VARCHAR(60) BINARY ,ANMVON DATETIME ,ANMDLA DATETIME ,ANMPNR VARCHAR(8) BINARY DEFAULT 'Timesys',ANMAGB DATETIME ,ANMATG DECIMAL(5,0) DEFAULT 60,ANMWAR DECIMAL(5,0) DEFAULT 14,ANMNUM DECIMAL(5,0) DEFAULT 0,ANMMIN DECIMAL(5,0) DEFAULT 5,ANMANZ DECIMAL(5,0) DEFAULT 1,ANMAUT DECIMAL(1,0) ,ANMSTA DECIMAL(11,0) DEFAULT 1,ANMDAT DATETIME ,ANMERF VARCHAR(50) BINARY DEFAULT 'Timesys',ANMMSG VARCHAR(20) BINARY  ,PRIMARY KEY(ANMANM,ANMLIZ,ANMMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS111TFK ( TFKTTT VARCHAR(10) BINARY ,TFKTNM DECIMAL(5,0) ,TFKWTG DECIMAL(1,0) ,TFKV01 DECIMAL(4,0) ,TFKB01 DECIMAL(4,0) ,TFKV02 DECIMAL(4,0) ,TFKB02 DECIMAL(4,0) ,TFKV03 DECIMAL(4,0) ,TFKB03 DECIMAL(4,0) ,TFKV04 DECIMAL(4,0) ,TFKB04 DECIMAL(4,0) ,TFKV05 DECIMAL(4,0) ,TFKB05 DECIMAL(4,0) ,TFKV06 DECIMAL(4,0) ,TFKB06 DECIMAL(4,0) ,TFKV07 DECIMAL(4,0) ,TFKB07 DECIMAL(4,0) ,TFKV08 DECIMAL(4,0) ,TFKB08 DECIMAL(4,0) ,TFKV09 DECIMAL(4,0) ,TFKB09 DECIMAL(4,0) ,TFKV10 DECIMAL(4,0) ,TFKB10 DECIMAL(4,0) ,TFKV11 DECIMAL(4,0) ,TFKB11 DECIMAL(4,0) ,TFKV12 DECIMAL(4,0) ,TFKB12 DECIMAL(4,0) ,TFKERF VARCHAR(50) BINARY ,TFKDAT VARCHAR(14) BINARY ,TFKLIZ VARCHAR(5) BINARY ,TFKMND VARCHAR(5) BINARY  ,PRIMARY KEY(TFKTTT,TFKTNM,TFKWTG,TFKLIZ,TFKMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS112MND ( MNDLIZ VARCHAR(5) BINARY ,MNDNUM VARCHAR(5) BINARY ,MNDSTO VARCHAR(5) BINARY ,MNDVWS VARCHAR(5) BINARY ,MNDNA1 VARCHAR(50) BINARY ,MNDNA2 VARCHAR(50) BINARY ,MNDSTR VARCHAR(50) BINARY ,MNDPLZ VARCHAR(10) BINARY ,MNDORT VARCHAR(50) BINARY ,MNDEML VARCHAR(50) BINARY ,MNDHMD VARCHAR(5) BINARY ,MNDKAL DECIMAL(1,0) ,MNDFCD DECIMAL(1,0) ,MNDTRM DECIMAL(1,0) ,MNDORG DECIMAL(1,0) ,MNDVON DATETIME ,MNDBIS DATETIME ,MNDSTA DECIMAL(5,0) DEFAULT 1,MNDDAT DATETIME ,MNDERF VARCHAR(50) BINARY DEFAULT 'Timesys',MNDSCH VARCHAR(20) BINARY ,MNDKON DECIMAL(1,0) DEFAULT 0,MNDZKT DECIMAL(1,0) ,MNDBIV DECIMAL(1,0) DEFAULT 0,MNDSOZ DECIMAL(1,0) ,MNDSRE DECIMAL(1,0) ,MNDAPZ DATETIME ,MNDAZU DATETIME ,MNDAMP DATETIME ,MNDLKZ DECIMAL(2,0) ,MNDLDA DECIMAL(1,0) DEFAULT 0,MNDGMV DECIMAL(2,0) ,MNDGMB DECIMAL(2,0) ,MNDKND VARCHAR(200) BINARY ,MNDDIC DECIMAL(1,0) ,MNDBNR DECIMAL(8,0) ,MNDMAB DECIMAL(1,0) ,MNDMAD DATETIME ,MNDST2 VARCHAR(5) BINARY ,MNDABS DECIMAL(1,0) DEFAULT 1,MNDMAP DECIMAL(1,0) ,MNDTGB DECIMAL(5,0) ,MNDT01 DECIMAL(5,0) ,MNDT02 DECIMAL(5,0) ,MNDT03 DECIMAL(5,0) ,MNDT04 DECIMAL(5,0) ,MNDT05 DECIMAL(5,0) ,MNDT06 DECIMAL(5,0) ,MNDT07 DECIMAL(5,0) ,MNDT08 DECIMAL(5,0) ,MNDT09 DECIMAL(5,0) ,MNDT10 DECIMAL(5,0) ,MNDT11 DECIMAL(5,0) ,MNDT12 DECIMAL(5,0) ,MNDDWN DECIMAL(5,0) ,MNDD01 DECIMAL(5,0) ,MNDD02 DECIMAL(5,0) ,MNDD03 DECIMAL(5,0) ,MNDD04 DECIMAL(5,0) ,MNDD05 DECIMAL(5,0) ,MNDD06 DECIMAL(5,0) ,MNDD07 DECIMAL(5,0) ,MNDD08 DECIMAL(5,0) ,MNDD09 DECIMAL(5,0) ,MNDD10 DECIMAL(5,0) ,MNDD11 DECIMAL(5,0) ,MNDD12 DECIMAL(5,0) ,MNDATG DECIMAL(11,0) ,MNDAAN DECIMAL(2,0) ,MNDZZO DECIMAL(4,0) DEFAULT 0,MNDPWG DECIMAL(3,0) ,MNDZUK VARCHAR(8) BINARY ,MNDFAR DECIMAL(3,0) DEFAULT 1,MNDIAG DECIMAL(3,0) DEFAULT 14,MNDAVZ DECIMAL(3,0) DEFAULT 1 ,PRIMARY KEY(MNDLIZ,MNDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS112TMD ( TMDLIZ VARCHAR(5) BINARY ,TMDNUM VARCHAR(5) BINARY ,TMDNAM VARCHAR(50) BINARY ,TMDSTA DECIMAL(5,0) DEFAULT 1,TMDDAT DATETIME ,TMDERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TMDLIZ,TMDNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS112TTA ( TTANUM VARCHAR(10) BINARY ,TTATYP VARCHAR(10) BINARY ,TTAMNU DECIMAL(1,0) ,TTATAS DECIMAL(5,0) ,TTABCH VARCHAR(3) BINARY ,TTAPOS DECIMAL(2,0) ,TTATXT VARCHAR(30) BINARY ,TTADNC DECIMAL(5,0) ,TTAFTP DECIMAL(5,0) ,TTADAT VARCHAR(14) BINARY ,TTAERF VARCHAR(50) BINARY DEFAULT 'Timesys',TTAF01 DECIMAL(1,0) ,TTAF02 DECIMAL(1,0) ,TTAF03 DECIMAL(1,0) ,TTAF04 DECIMAL(1,0) ,TTAF05 DECIMAL(1,0) ,TTAF06 DECIMAL(1,0) ,TTAF07 DECIMAL(1,0) ,TTAF08 DECIMAL(1,0) ,TTAF09 DECIMAL(1,0) ,TTAF10 DECIMAL(1,0) ,TTAF11 DECIMAL(1,0) ,TTAF12 DECIMAL(1,0) ,TTAFCD VARCHAR(3) BINARY ,TTAAPS DECIMAL(2,0) ,TTATAV DECIMAL(1,0) ,TTALIZ VARCHAR(5) BINARY ,TTAMND VARCHAR(5) BINARY ,TTAIMG VARCHAR(50) BINARY ,TTABEZ VARCHAR(30) BINARY  ,PRIMARY KEY(TTANUM,TTATYP,TTAMNU,TTATAS,TTAPOS,TTALIZ,TTAMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS113AWV ( AWVNUM VARCHAR(50) BINARY ,AWVCOD DECIMAL(5,0) DEFAULT 0,AWVSTO VARCHAR(8) BINARY ,AWVSTA DECIMAL(5,0) DEFAULT 1,AWVDAT DATETIME ,AWVERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(AWVNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS113STO ( STONUM VARCHAR(8) BINARY ,STOSCH VARCHAR(16) BINARY ,STOTXT VARCHAR(50) BINARY ,STOKTX VARCHAR(10) BINARY ,STOSTA DECIMAL(5,0) DEFAULT 1,STODAT DATETIME ,STOERF VARCHAR(50) BINARY DEFAULT 'Timesys',STOMND VARCHAR(5) BINARY  ,PRIMARY KEY(STONUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS114TKD ( TKDNAM VARCHAR(255) BINARY ,TKDTST VARCHAR(15) BINARY ,TKDHER VARCHAR(30) BINARY ,TKDART VARCHAR(30) BINARY ,TKDSNR VARCHAR(10) BINARY ,TKDINT DECIMAL(2,0) ,TKDLDT DATETIME ,TKDGAR DATETIME ,TKDWAR VARCHAR(30) BINARY ,TKDEND DATETIME ,TKDSTO VARCHAR(50) BINARY ,TKDINV VARCHAR(6) BINARY ,TKDKST VARCHAR(10) BINARY ,TKDLIE VARCHAR(30) BINARY ,TKDLNR VARCHAR(10) BINARY ,TKDKAN VARCHAR(30) BINARY ,TKDKTL VARCHAR(15) BINARY ,TKDTAN VARCHAR(30) BINARY ,TKDTTL VARCHAR(15) BINARY ,TKDTYP DECIMAL(5,0) DEFAULT 0,TKDEML VARCHAR(50) BINARY ,TKDSTA DECIMAL(5,0) DEFAULT 1,TKDDAT DATETIME ,TKDERF VARCHAR(50) BINARY DEFAULT 'Timesys',TKDLIZ VARCHAR(5) BINARY ,TKDMND VARCHAR(5) BINARY  ,PRIMARY KEY(TKDNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS114TSM ( TSMNAM VARCHAR(255) BINARY ,TSMACS DECIMAL(1,0) DEFAULT 0,TSMTYP VARCHAR(10) BINARY ,TSMTAS VARCHAR(10) BINARY ,TSMSAL VARCHAR(10) BINARY ,TSMUPL VARCHAR(10) BINARY ,TSMDNL VARCHAR(10) BINARY ,TSMSTO VARCHAR(30) BINARY ,TSMTXT VARCHAR(50) BINARY ,TSMKTX VARCHAR(10) BINARY ,TSMSTA DECIMAL(5,0) DEFAULT 1,TSMDAT DATETIME ,TSMERF VARCHAR(50) BINARY DEFAULT 'Timesys',TSMKSW DECIMAL(1,0) DEFAULT 0,TSMSPR DECIMAL(1,0) DEFAULT 1,TSMMMD DECIMAL(1,0) DEFAULT 1,TSMCTP DECIMAL(2,0)  ,PRIMARY KEY(TSMNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS1140COM ( COMNAM VARCHAR(255) BINARY ,COMIPA VARCHAR(15) BINARY ,COMGAT VARCHAR(15) BINARY ,COMSHS VARCHAR(15) BINARY ,COMEHS VARCHAR(15) BINARY ,COMGHS VARCHAR(15) BINARY ,COMSTP VARCHAR(4) BINARY ,COMEVP VARCHAR(4) BINARY ,COMTMP VARCHAR(4) BINARY ,COMSUB VARCHAR(15) BINARY ,COMTWX VARCHAR(10) BINARY ,COMPOR VARCHAR(1) BINARY ,COMSCH VARCHAR(1) BINARY ,COMSTO VARCHAR(2) BINARY ,COMTER DECIMAL(1,0) DEFAULT 0,COMPRO VARCHAR(5) BINARY ,COMLKN VARCHAR(5) BINARY ,COMVOR VARCHAR(10) BINARY ,COMTEL VARCHAR(20) BINARY ,COMDWL VARCHAR(10) BINARY ,COMGID VARCHAR(10) BINARY ,COMPRT VARCHAR(4) BINARY ,COMLER DECIMAL(5,0) DEFAULT 0,COMWIE DECIMAL(5,0) DEFAULT 0,COMANZ DECIMAL(5,0) DEFAULT 0,COMSTA DECIMAL(5,0) DEFAULT 8,COMDAT DATETIME ,COMERF VARCHAR(50) BINARY DEFAULT 'Timesys',COMAMT VARCHAR(5) BINARY ,COMEAT VARCHAR(5) BINARY ,COMLIZ VARCHAR(5) BINARY ,COMMND VARCHAR(5) BINARY  ,PRIMARY KEY(COMNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS1140SLT ( SLTTRM VARCHAR(255) BINARY ,SLTNUM DECIMAL(3,0) ,SLTTYP DECIMAL(2,0) ,SLTDAT DATETIME ,SLTERF VARCHAR(50) BINARY DEFAULT 'Timesys',SLTTXT VARCHAR(50) BINARY ,SLTSTA DECIMAL(1,0) DEFAULT 1,SLTKTX VARCHAR(11) BINARY ,SLTTXL VARCHAR(255) BINARY ,SLTLIZ VARCHAR(5) BINARY ,SLTMND VARCHAR(5) BINARY  ,PRIMARY KEY(SLTTRM,SLTNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS1140STS ( STSNAM VARCHAR(10) BINARY ,STSKOM VARCHAR(50) BINARY ,STSSTS VARCHAR(50) BINARY ,STSDAT DATETIME  ,PRIMARY KEY(STSNAM,STSKOM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS1140TRM ( TRMNAM VARCHAR(255) BINARY ,TRMTAS VARCHAR(10) BINARY ,TRMSAL VARCHAR(10) BINARY ,TRMUPL VARCHAR(10) BINARY ,TRMDNL VARCHAR(10) BINARY ,TRMSPR DECIMAL(5,0) DEFAULT 0,TRMDTM DECIMAL(5,0) DEFAULT 0,TRMAPP VARCHAR(200) BINARY ,TRMLOG VARCHAR(200) BINARY ,TRMPRA VARCHAR(200) BINARY ,TRMSYN DECIMAL(1,0) ,TRMTON DECIMAL(5,0) DEFAULT 0,TRMDAU DECIMAL(5,0) DEFAULT 0,TRMLST DECIMAL(5,0) DEFAULT 50,TRMHST DECIMAL(5,0) DEFAULT 0,TRMALF DECIMAL(5,0) DEFAULT 0,TRMSTO VARCHAR(30) BINARY ,TRMTXT VARCHAR(50) BINARY ,TRMKTX VARCHAR(10) BINARY ,TRMSTA DECIMAL(5,0) DEFAULT 1,TRMDAT DATETIME ,TRMERF VARCHAR(50) BINARY DEFAULT 'Timesys',TRMINT DECIMAL(5,0) DEFAULT 1,TRMMOD VARCHAR(8) BINARY DEFAULT NULL,TRMFNK DECIMAL(1,0) ,TRMDIS DECIMAL(1,0) ,TRMQTP DECIMAL(5,0) ,TRMWTG DECIMAL(1,0) DEFAULT 1,TRMPRO DECIMAL(2,0) DEFAULT 99,TRMDAC DECIMAL(1,0) ,TRMDTP DECIMAL(2,0) ,TRMDNM VARCHAR(255) BINARY ,TRMDPG DECIMAL(3,0) ,TRMDST DECIMAL(10,0) ,TRMANZ DECIMAL(1,0) ,TRMSEI DECIMAL(2,0) ,TRMSPA DECIMAL(2,0) ,TRMZEI DECIMAL(2,0) ,TRMPLA VARCHAR(25) BINARY ,TRMKSW DECIMAL(1,0) ,TRMTWC VARCHAR(10) BINARY ,TRMTWP VARCHAR(6) BINARY ,TRMTWA VARCHAR(6) BINARY ,TRMTWL VARCHAR(6) BINARY ,TRMIPA VARCHAR(15) BINARY ,TRMIPS VARCHAR(15) BINARY ,TRMIPG VARCHAR(15) BINARY ,TRMIPH VARCHAR(15) BINARY ,TRMIPK VARCHAR(15) BINARY ,TRMIPT DECIMAL(5,0) ,TRMIPE DECIMAL(5,0) ,TRMISA VARCHAR(5) BINARY ,TRMISQ DECIMAL(5,0) ,TRMISR VARCHAR(30) BINARY ,TRMISL DECIMAL(3,0) ,TRMIST VARCHAR(32) BINARY ,TRMISM VARCHAR(5) BINARY ,TRMTST DECIMAL(1,0) ,TRMDTO VARCHAR(14) BINARY ,TRMDTD VARCHAR(14) BINARY ,TRMDBE VARCHAR(50) BINARY ,TRMDTU VARCHAR(14) BINARY ,TRMCTP VARCHAR(10) BINARY ,TRMUBE VARCHAR(50) BINARY ,TRMINC VARCHAR(5) BINARY ,TRMLIZ VARCHAR(5) BINARY ,TRMMND VARCHAR(5) BINARY ,TRMDPL VARCHAR(10) BINARY ,TRMEFB VARCHAR(10) BINARY  ,PRIMARY KEY(TRMNAM,TRMLIZ,TRMMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS115TFZ ( TFZTRM VARCHAR(255) BINARY ,TFZLIZ VARCHAR(5) BINARY ,TFZMND VARCHAR(5) BINARY ,TFZSTA DECIMAL(1,0) DEFAULT 1,TFZDAT DATETIME ,TFZERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(TFZTRM,TFZLIZ,TFZMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS116MSG ( MSGLFD DECIMAL(10,0) ,MSGLIZ VARCHAR(5) BINARY ,MSGMND VARCHAR(2) BINARY ,MSGUSR VARCHAR(50) BINARY ,MSGHDR VARCHAR(160) BINARY ,MSGMOD VARCHAR(3) BINARY ,MSGBDY VARCHAR(500) BINARY ,MSGSDT DATETIME ,MSGSTM DATETIME ,MSGFRM VARCHAR(50) BINARY ,MSGEML VARCHAR(75) BINARY ,MSGSMS DECIMAL(15,0) ,MSGKEM DECIMAL(1,0) DEFAULT 0,MSGKSM DECIMAL(1,0) DEFAULT 0,MSGKTB DECIMAL(1,0) DEFAULT 1,MSGLNK VARCHAR(255) BINARY ,MSGNEW DECIMAL(1,0) DEFAULT 1,MSGNTY DATETIME  ,PRIMARY KEY(MSGLFD,MSGLIZ,MSGMND,MSGUSR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS119MSD ( MSDSAL VARCHAR(10) BINARY ,MSDLFD DECIMAL(5,0) DEFAULT 0,MSDANZ DECIMAL(5,0) DEFAULT 0,MSDWRT DECIMAL(5,0) DEFAULT 0,MSDSTA DECIMAL(5,0) DEFAULT 1,MSDDAT DATETIME ,MSDERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',MSDSPL DECIMAL(2,0) DEFAULT 1,MSDTXT VARCHAR(30) BINARY ,MSDUVW DECIMAL(3,0) ,MSDLIZ VARCHAR(5) BINARY ,MSDMND VARCHAR(5) BINARY  ,PRIMARY KEY(MSDSAL,MSDLFD,MSDLIZ,MSDMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS119MST ( MSTNAM VARCHAR(10) BINARY ,MSTTTP VARCHAR(10) BINARY ,MSTDAU DECIMAL(5,0) DEFAULT 0,MSTTXT VARCHAR(30) BINARY ,MSTSTA DECIMAL(5,0) DEFAULT 1,MSTDAT DATETIME ,MSTERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',MSTTXN DECIMAL(3,0) DEFAULT 0,MSTLIZ VARCHAR(5) BINARY ,MSTMND VARCHAR(5) BINARY  ,PRIMARY KEY(MSTNAM,MSTLIZ,MSTMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS120KID ( KIDKST VARCHAR(30) BINARY ,KIDMND VARCHAR(5) BINARY ,KIDLIZ VARCHAR(5) BINARY ,KIDNUM DECIMAL(7,0) ,KIDSYS VARCHAR(7) BINARY ,KIDTXT VARCHAR(30) BINARY ,KIDFNM VARCHAR(50) BINARY ,KIDSTA DECIMAL(5,0) ,KIDERF VARCHAR(50) BINARY ,KIDDAT DATETIME  ,PRIMARY KEY(KIDKST,KIDMND,KIDLIZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS121QUA ( QUAQUA VARCHAR(30) BINARY ,QUAMND VARCHAR(5) BINARY ,QUALIZ VARCHAR(5) BINARY ,QUANUM DECIMAL(3,0) ,QUASYS VARCHAR(7) BINARY ,QUATXT VARCHAR(30) BINARY ,QUASTA DECIMAL(5,0) ,QUAERF VARCHAR(50) BINARY ,QUADAT DATETIME  ,PRIMARY KEY(QUAQUA,QUAMND,QUALIZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS122DIC ( DICKEY VARCHAR(64) BINARY ,DICFNA VARCHAR(9) BINARY ,DICTNA VARCHAR(20) BINARY ,DICFNK VARCHAR(50) BINARY ,DICFNR DECIMAL(11,0) ,DICWHL DECIMAL(5,0) ,DICSTS DECIMAL(5,0) DEFAULT 1,DICDAT DATETIME ,DICERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(DICKEY,DICFNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS122DI2 ( DI2KEY VARCHAR(64) BINARY ,DI2FNA VARCHAR(9) BINARY ,DI2SPR DECIMAL(5,0) ,DI2TXT VARCHAR(120) BINARY ,DI2STS DECIMAL(5,0) DEFAULT 1,DI2DAT DATETIME ,DI2ERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(DI2KEY,DI2FNA,DI2SPR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS132TTP ( TTPNUM VARCHAR(3) BINARY ,TTPKRT VARCHAR(2) BINARY ,TTPTXT VARCHAR(50) BINARY ,TTPKTX VARCHAR(10) BINARY ,TTPSTA DECIMAL(11,0) DEFAULT 1,TTPDAT DATETIME ,TTPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(TTPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS133BAK ( BAKDTM DATETIME ,BAKJHR DECIMAL(5,0) DEFAULT 0,BAKMON DECIMAL(5,0) DEFAULT 0,BAKTAG DECIMAL(5,0) DEFAULT 0,BAKWCH DECIMAL(5,0) DEFAULT 0,BAKWTG DECIMAL(5,0) DEFAULT 0,BAKJTG DECIMAL(5,0) DEFAULT 0,BAKDAT DATETIME ,BAKERF VARCHAR(50) BINARY DEFAULT 'Timesys',BAKYOW DECIMAL(4,0) ,BAKCSM VARCHAR(32) BINARY ,BAKSTA DECIMAL(5,0) DEFAULT 1,BAKQUA DECIMAL(1,0) ,BAKHJH DECIMAL(1,0)  ,PRIMARY KEY(BAKDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS133KAL ( KALNUM VARCHAR(3) BINARY ,KALDTM DATETIME ,KALTTP VARCHAR(3) BINARY ,KALTXT VARCHAR(50) BINARY ,KALDAT DATETIME ,KALERF VARCHAR(50) BINARY DEFAULT 'Timesys',KALPTP VARCHAR(3) BINARY ,KALGWT DECIMAL(3,0) ,KALBTP VARCHAR(3) BINARY ,KALCSM VARCHAR(32) BINARY ,KALSTA DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(KALNUM,KALDTM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS133PKZ ( PKZLKZ DECIMAL(2,0) ,PKZPLZ VARCHAR(10) BINARY ,PKZORT VARCHAR(50) BINARY ,PKZBLD VARCHAR(50) BINARY ,PKZKAL VARCHAR(3) BINARY  ,PRIMARY KEY(PKZLKZ,PKZPLZ,PKZORT)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS135MUW ( MUWKAL VARCHAR(3) BINARY ,MUWTXT VARCHAR(50) BINARY ,MUWKTX VARCHAR(10) BINARY ,MUWSTA DECIMAL(5,0) DEFAULT 1,MUWDAT DATETIME ,MUWERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(MUWKAL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS137WC2 ( WC2KAL VARCHAR(3) BINARY ,WC2TAG DECIMAL(5,0) DEFAULT 0,WC2TTP VARCHAR(3) BINARY DEFAULT '01',WC2STA DECIMAL(5,0) DEFAULT 1,WC2DAT DATETIME ,WC2ERF VARCHAR(50) BINARY DEFAULT 'Timesys',WC2PTP VARCHAR(3) BINARY  ,PRIMARY KEY(WC2KAL,WC2TAG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS138ZPL ( ZPLNUM VARCHAR(10) BINARY ,ZPLTXT VARCHAR(50) BINARY ,ZPLMND VARCHAR(5) BINARY ,ZPLLIZ VARCHAR(5) BINARY ,ZPLMON DECIMAL(5,0) ,ZPLDIN DECIMAL(5,0) ,ZPLMIT DECIMAL(5,0) ,ZPLDON DECIMAL(5,0) ,ZPLFRE DECIMAL(5,0) ,ZPLSAM DECIMAL(5,0) ,ZPLSON DECIMAL(5,0) ,ZPLWOC VARCHAR(30) BINARY ,ZPLSTA DECIMAL(5,0) ,ZPLERF VARCHAR(50) BINARY ,ZPLDAT DATETIME  ,PRIMARY KEY(ZPLNUM,ZPLMND,ZPLLIZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS139TPL ( TPLZPL VARCHAR(10) BINARY ,TPLNUM VARCHAR(10) BINARY ,TPLWTG DECIMAL(3,0) ,TPLTXT VARCHAR(50) BINARY ,TPLVON DECIMAL(5,0) ,TPLBIS DECIMAL(5,0) ,TPLVRZ DECIMAL(5,0) ,TPLRE1 DECIMAL(5,0) ,TPLRE2 DECIMAL(5,0) ,TPLRE3 DECIMAL(5,0) ,TPLSTA DECIMAL(5,0) ,TPLERF VARCHAR(50) BINARY ,TPLDAT DATETIME ,TPLLIZ VARCHAR(5) BINARY ,TPLMND VARCHAR(5) BINARY  ,PRIMARY KEY(TPLZPL,TPLNUM,TPLWTG,TPLVON,TPLLIZ,TPLMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS140DPL ( DPLLIZ VARCHAR(5) BINARY ,DPLMND VARCHAR(5) BINARY ,DPLNUM VARCHAR(10) BINARY ,DPLTXT VARCHAR(50) BINARY ,DPLMON DECIMAL(5,0) ,DPLDIN DECIMAL(5,0) ,DPLMIT DECIMAL(5,0) ,DPLDON DECIMAL(5,0) ,DPLFRE DECIMAL(5,0) ,DPLSAM DECIMAL(5,0) ,DPLSON DECIMAL(5,0) ,DPLWOC VARCHAR(30) BINARY ,DPLSTA DECIMAL(5,0) ,DPLERF VARCHAR(50) BINARY ,DPLDAT DATETIME  ,PRIMARY KEY(DPLLIZ,DPLMND,DPLNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS141DZT ( DZTLIZ VARCHAR(5) BINARY ,DZTMND VARCHAR(5) BINARY ,DZTZPL VARCHAR(10) BINARY ,DZTNUM VARCHAR(10) BINARY ,DZTWTG DECIMAL(3,0) ,DZTTXT VARCHAR(50) BINARY ,DZTVON DECIMAL(5,0) ,DZTBIS DECIMAL(5,0) ,DZTVRZ DECIMAL(5,0) ,DZTRE1 DECIMAL(5,0) ,DZTRE2 DECIMAL(5,0) ,DZTRE3 DECIMAL(5,0) ,DZTSTA DECIMAL(5,0) ,DZTERF VARCHAR(50) BINARY ,DZTDAT DATETIME  ,PRIMARY KEY(DZTLIZ,DZTMND,DZTZPL,DZTNUM,DZTWTG,DZTVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS200ACK ( ACKMSG VARCHAR(50) BINARY ,ACKANM VARCHAR(50) BINARY ,ACKMND VARCHAR(5) BINARY ,ACKLIZ VARCHAR(5) BINARY ,ACKACK VARCHAR(20) BINARY ,ACKDSP VARCHAR(20) BINARY ,ACKDAT TIMESTAMP ,PRIMARY KEY(ACKMSG,ACKANM,ACKMND,ACKLIZ)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS200MSG ( MSGUID VARCHAR(50) BINARY ,MSGTNR DECIMAL(5,0) ,MSGTXT VARCHAR(250) BINARY ,MSGLNK VARCHAR(250) BINARY ,MSGMOD VARCHAR(50) BINARY ,MSGSRC VARCHAR(50) BINARY ,MSGSCH VARCHAR(20) BINARY ,MSGCAT VARCHAR(25) BINARY ,MSGADR VARCHAR(10) BINARY ,MSGBER VARCHAR(10) BINARY ,MSGPRI DECIMAL(5,0) ,MSGTYP VARCHAR(5) BINARY ,MSGBRK VARCHAR(5) BINARY ,MSGVAL DECIMAL(5,0) ,MSGDBG VARCHAR(1024) BINARY ,MSGMND VARCHAR(5) BINARY ,MSGLIZ VARCHAR(5) BINARY ,MSGTIN VARCHAR(20) BINARY ,MSGSTS DECIMAL(5,0) ,MSGERF VARCHAR(50) BINARY ,MSGUSR VARCHAR(50) BINARY ,MSGDAT TIMESTAMP ,PRIMARY KEY(MSGUID)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS230RMA ( RMAANM VARCHAR(50) BINARY ,RMANUM DECIMAL(11,0) DEFAULT 0,RMAWHL DECIMAL(5,0) DEFAULT 0,RMAMSK VARCHAR(20) BINARY ,RMADAT VARCHAR(8) BINARY ,RMAANZ DECIMAL(5,0) ,RMAABA DECIMAL(5,0) ,RMASCN DECIMAL(3,0) ,RMAICN DECIMAL(6,0) ,RMASEI VARCHAR(8) BINARY ,RMAEDT VARCHAR(8) BINARY ,RMAAGR VARCHAR(8) BINARY ,RMAPDF VARCHAR(8) BINARY ,RMAEML VARCHAR(8) BINARY ,RMABEM VARCHAR(1024) BINARY ,RMAVRS VARCHAR(10) BINARY  ,PRIMARY KEY(RMAANM,RMANUM,RMAWHL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS230RML ( RMLNUM DECIMAL(11,0) DEFAULT 0,RMLWHL DECIMAL(5,0) DEFAULT 0,RMLTXT VARCHAR(50) BINARY ,RMLMSK VARCHAR(20) BINARY ,RMLBAB VARCHAR(8) BINARY ,RMLBBI VARCHAR(8) BINARY ,RMLWTG VARCHAR(30) BINARY ,RMLINT VARCHAR(100) BINARY ,RMLTOU DECIMAL(3,0) DEFAULT 0,RMLGRP VARCHAR(50) BINARY ,RMLERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',RMLDAT DATETIME ,RMLSTA DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(RMLNUM,RMLWHL,RMLMSK,RMLBAB)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS230RMP ( RMPANM VARCHAR(50) BINARY ,RMPNUM DECIMAL(11,0) DEFAULT 0,RMPWHL DECIMAL(5,0) DEFAULT 0,RMPMSK VARCHAR(20) BINARY ,RMPFNA VARCHAR(16) BINARY ,RMPVAL VARCHAR(2048) BINARY ,RMPERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',RMPDAT DATETIME ,RMPSTA DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(RMPANM,RMPNUM,RMPWHL,RMPFNA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS300LPR ( LPRTYP DECIMAL(2,0) ,LPRLIZ VARCHAR(5) BINARY ,LPRMND VARCHAR(5) BINARY ,LPRPZM DECIMAL(6,0) ,LPRBCH DECIMAL(6,0) ,LPRBC2 DECIMAL(6,0) ,LPRZTG DECIMAL(6,0) ,LPRPDT DECIMAL(8,0) ,LPRCHK VARCHAR(32) BINARY ,LPRDAT DATETIME  ,PRIMARY KEY(LPRTYP,LPRLIZ,LPRMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS301ASW ( ASWNUM VARCHAR(50) BINARY ,ASWGVO DATETIME ,ASWGBI DATETIME ,ASWPNR VARCHAR(8) BINARY ,ASWBKL VARCHAR(5) BINARY DEFAULT '0',ASWPIN VARCHAR(32) BINARY ,ASWCOD DECIMAL(5,0) DEFAULT 0,ASWGRP VARCHAR(5) BINARY ,ASWSTA DECIMAL(5,0) DEFAULT 1,ASWDAT DATETIME ,ASWERF VARCHAR(50) BINARY DEFAULT 'Timesys',ASWLIZ VARCHAR(5) BINARY DEFAULT '01000',ASWMND VARCHAR(5) BINARY DEFAULT '0',ASWATP DECIMAL(2,0) DEFAULT 0,ASWAAN VARCHAR(50) BINARY DEFAULT NULL,ASWMTA DECIMAL(2,0) ,ASWSTO VARCHAR(8) BINARY ,ASWSPR DECIMAL(5,0) ,ASWSAL VARCHAR(10) BINARY ,ASWBK2 VARCHAR(5) BINARY ,ASWNAM VARCHAR(50) BINARY ,ASWMAP DECIMAL(1,0) ,ASWKST VARCHAR(30) BINARY ,ASWKAL VARCHAR(3) BINARY  ,PRIMARY KEY(ASWNUM,ASWGVO,ASWBKL)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS301AWB ( AWBASW VARCHAR(50) BINARY ,AWBBKL VARCHAR(5) BINARY ,AWBLIZ VARCHAR(5) BINARY ,AWBMND VARCHAR(5) BINARY ,AWBZUV DECIMAL(1,0) ,AWBDAT DATETIME ,AWBSTA DECIMAL(1,0)  ,PRIMARY KEY(AWBASW,AWBBKL,AWBLIZ,AWBMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS301BKL ( BKLASW VARCHAR(50) BINARY ,BKLGVO DATETIME ,BKLGBI DATETIME ,BKLBKL VARCHAR(5) BINARY ,BKLART DECIMAL(1,0) ,BKLLIZ VARCHAR(5) BINARY ,BKLMND VARCHAR(5) BINARY ,BKLOLI VARCHAR(5) BINARY ,BKLOMN VARCHAR(5) BINARY ,BKLPNR VARCHAR(8) BINARY ,BKLSTM DECIMAL(1,0) ,BKLSKY VARCHAR(30) BINARY ,BKLSTA DECIMAL(1,0) ,BKLDAT DATETIME ,BKLERF VARCHAR(50) BINARY  ,PRIMARY KEY(BKLASW,BKLGVO,BKLBKL,BKLART,BKLLIZ,BKLMND)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS321BEW ( BEWSCH VARCHAR(20) BINARY ,BEWPNR VARCHAR(8) BINARY ,BEWTID VARCHAR(255) BINARY ,BEWLID VARCHAR(5) BINARY ,BEWIDN VARCHAR(50) BINARY ,BEWSTO VARCHAR(8) BINARY ,BEWDTM DATETIME ,BEWUHR DATETIME ,BEWLFN VARCHAR(3) BINARY ,BEWART VARCHAR(3) BINARY ,BEWTAS VARCHAR(2) BINARY ,BEWERA VARCHAR(3) BINARY ,BEWKZE CHAR(1) ,BEWBER CHAR(1) ,BEWERQ VARCHAR(10) BINARY ,BEWSTA DECIMAL(5,0) ,BEWKST VARCHAR(30) BINARY ,BEWQUA VARCHAR(5) BINARY ,BEWRES VARCHAR(30) BINARY ,BEWDAT TIMESTAMP,BEWERF VARCHAR(50) BINARY DEFAULT 'Timesys',BEWUKZ DECIMAL(1,0) ,BEWUDT TIMESTAMP,BEWSRC VARCHAR(3) BINARY  ,PRIMARY KEY(BEWTID,BEWIDN,BEWSTO,BEWDTM,BEWUHR,BEWLFN,BEWSRC)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS401ZAU ( ZAUGRP VARCHAR(5) BINARY ,ZAUTGE DECIMAL(5,0) DEFAULT 0,ZAUTXT VARCHAR(50) BINARY ,ZAUKTX VARCHAR(10) BINARY ,ZAUSTA DECIMAL(5,0) DEFAULT 1,ZAUDAT DATETIME ,ZAUERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZAUGRP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS401ZLK ( ZLKTRM VARCHAR(255) BINARY ,ZLKLES DECIMAL(5,0) DEFAULT 0,ZLKTRK VARCHAR(10) BINARY ,ZLKLEK DECIMAL(5,0) DEFAULT 0,ZLKAKT DECIMAL(5,0) DEFAULT 0,ZLKDAU DECIMAL(5,0) DEFAULT 0,ZLKSTA DECIMAL(5,0) DEFAULT 1,ZLKDAT DATETIME ,ZLKERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZLKMTO DECIMAL(5,0) DEFAULT 0,ZLKLIZ VARCHAR(5) BINARY ,ZLKMND VARCHAR(5) BINARY  ,PRIMARY KEY(ZLKTRM,ZLKLES,ZLKTRK,ZLKLEK)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS401ZLS ( ZLSTRM VARCHAR(255) BINARY ,ZLSLES DECIMAL(5,0) DEFAULT 0,ZLSZKO VARCHAR(5) BINARY ,ZLSAUS VARCHAR(5) BINARY ,ZLSTFR VARCHAR(5) BINARY ,ZLSTVR VARCHAR(5) BINARY ,ZLSEIN DECIMAL(5,0) DEFAULT 1,ZLSADR DECIMAL(5,0) DEFAULT 1,ZLSTXT VARCHAR(50) BINARY ,ZLSKTX VARCHAR(10) BINARY ,ZLSSTA DECIMAL(5,0) DEFAULT 1,ZLSDAT DATETIME ,ZLSERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZLSEKO VARCHAR(5) BINARY ,ZLSFCD VARCHAR(3) BINARY ,ZLSKST VARCHAR(30) BINARY ,ZLSMSN VARCHAR(50) BINARY ,ZLSFTP DECIMAL(5,0) ,ZLSPRO DECIMAL(2,0) ,ZLSSST DECIMAL(2,0) ,ZLSIPA VARCHAR(15) BINARY ,ZLSANZ DECIMAL(1,0) ,ZLSSEI DECIMAL(2,0) ,ZLSSPA DECIMAL(2,0) ,ZLSZEI DECIMAL(2,0) ,ZLSFIW DECIMAL(1,0) ,ZLSTON DECIMAL(2,0) ,ZLSLST DECIMAL(1,0) ,ZLSDTO VARCHAR(14) BINARY ,ZLSMOD VARCHAR(8) BINARY ,ZLSMKO VARCHAR(1) BINARY ,ZLSR01 VARCHAR(10) BINARY ,ZLSR02 VARCHAR(10) BINARY ,ZLSR03 VARCHAR(50) BINARY ,ZLSR04 VARCHAR(50) BINARY ,ZLSPIN DECIMAL(1,0) DEFAULT 0,ZLSBVW DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(ZLSTRM,ZLSLES)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS402ZKO ( ZKONUM VARCHAR(5) BINARY ,ZKOPRT VARCHAR(5) BINARY ,ZKOABL VARCHAR(5) BINARY ,ZKOZAP VARCHAR(5) BINARY ,ZKOAUT DECIMAL(1,0) ,ZKOTFS VARCHAR(5) BINARY ,ZKOKAL VARCHAR(3) BINARY ,ZKOAUG DECIMAL(1,0) ,ZKOMAX DECIMAL(5,0) DEFAULT 0,ZKOTVR VARCHAR(5) BINARY ,ZKOAUF DECIMAL(5,0) DEFAULT 0,ZKOTXT VARCHAR(50) BINARY ,ZKOKTX VARCHAR(10) BINARY ,ZKOSTA DECIMAL(5,0) DEFAULT 1,ZKODAT DATETIME ,ZKOERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZKOSPA DECIMAL(2,0) ,ZKOZEI DECIMAL(2,0)  ,PRIMARY KEY(ZKONUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS402ZPK ( ZPKTRM VARCHAR(255) BINARY ,ZPKLES DECIMAL(5,0) DEFAULT 0,ZPKDTM DATETIME ,ZPKUHR DATETIME ,ZPKASW VARCHAR(13) BINARY ,ZPKZUS DECIMAL(5,0) DEFAULT 0,ZPKFCD VARCHAR(3) BINARY ,ZPKMLD VARCHAR(50) BINARY ,ZPKDAT DATETIME ,ZPKLFD VARCHAR(3) BINARY DEFAULT '001',ZPKZKO VARCHAR(5) BINARY  ,PRIMARY KEY(ZPKTRM,ZPKLES,ZPKDTM,ZPKUHR,ZPKLFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS402ZUZ ( ZUZNUM VARCHAR(5) BINARY ,ZUZVON DECIMAL(5,0) ,ZUZBIS DECIMAL(5,0) ,ZUZSTA DECIMAL(5,0) DEFAULT 1,ZUZDAT DATETIME ,ZUZERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZUZART VARCHAR(1) BINARY ,ZUZVRW DECIMAL(5,0) ,ZUZTTP VARCHAR(3) BINARY ,ZUZDAU DECIMAL(1,0)  ,PRIMARY KEY(ZUZNUM,ZUZVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS402ZZZ ( ZZZNUM VARCHAR(5) BINARY ,ZZZTXT VARCHAR(50) BINARY ,ZZZKTX VARCHAR(10) BINARY ,ZZZSTA DECIMAL(5,0) DEFAULT 1,ZZZDAT DATETIME ,ZZZERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZZZTTP VARCHAR(3) BINARY  ,PRIMARY KEY(ZZZNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS403ZBK ( ZBKNUM VARCHAR(5) BINARY ,ZBKTXT VARCHAR(50) BINARY ,ZBKKTX VARCHAR(10) BINARY ,ZBKSTA DECIMAL(5,0) DEFAULT 1,ZBKDAT DATETIME ,ZBKERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZBKART DECIMAL(1,0) ,ZBKLIZ VARCHAR(5) BINARY ,ZBKMND VARCHAR(5) BINARY  ,PRIMARY KEY(ZBKNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS404ZBR ( ZBRZBK VARCHAR(5) BINARY ,ZBRTTP VARCHAR(3) BINARY DEFAULT '0',ZBRZKO VARCHAR(5) BINARY ,ZBRZZZ VARCHAR(5) BINARY ,ZBRSTA DECIMAL(5,0) DEFAULT 1,ZBRDAT DATETIME ,ZBRERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZBRZTB DECIMAL(2,0) ,ZBRSPA DECIMAL(2,0) ,ZBRZEI DECIMAL(2,0) ,ZBRZUT DECIMAL(1,0)  ,PRIMARY KEY(ZBRZBK,ZBRTTP,ZBRZKO)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS405ZUG ( ZUGGRP VARCHAR(5) BINARY ,ZUGTXT VARCHAR(50) BINARY ,ZUGKTX VARCHAR(10) BINARY ,ZUGSTA DECIMAL(5,0) DEFAULT 1,ZUGDAT DATETIME ,ZUGERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZUGGRP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS405ZU1 ( ZU1GRP VARCHAR(5) BINARY ,ZU1ZZS DECIMAL(5,0) DEFAULT 1,ZU1STA DECIMAL(5,0) DEFAULT 1,ZU1DAT DATETIME ,ZU1ERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZU1GRP,ZU1ZZS)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS405ZZS ( ZZSNUM DECIMAL(5,0) DEFAULT 0,ZZSTXT VARCHAR(128) BINARY ,ZZSKTX VARCHAR(10) BINARY ,ZZSART DECIMAL(5,0) DEFAULT 1,ZZSSTA DECIMAL(5,0) DEFAULT 1,ZZSDAT DATETIME ,ZZSERF VARCHAR(50) BINARY DEFAULT 'Timesys',ZZSPRI DECIMAL(5,0) DEFAULT 10,ZZSTCD VARCHAR(3) BINARY  ,PRIMARY KEY(ZZSNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS406ZAA ( ZAANUM VARCHAR(8) BINARY ,ZAAISY VARCHAR(2) BINARY ,ZAAEMP VARCHAR(50) BINARY ,ZAAETX VARCHAR(50) BINARY ,ZAASMS VARCHAR(50) BINARY ,ZAASTX VARCHAR(100) BINARY ,ZAASTA DECIMAL(5,0) DEFAULT 1,ZAADAT DATETIME ,ZAAERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZAANUM,ZAAISY,ZAAEMP)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS406ZAK ( ZAKZAP VARCHAR(5) BINARY ,ZAKTXT VARCHAR(50) BINARY ,ZAKTTP VARCHAR(3) BINARY ,ZAKZZZ VARCHAR(5) BINARY ,ZAKZUG VARCHAR(5) BINARY ,ZAKZAA VARCHAR(8) BINARY ,ZAKMIN DECIMAL(11,0) DEFAULT 0,ZAKSTA DECIMAL(5,0) DEFAULT 1,ZAKDAT DATETIME ,ZAKERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZAKZAP,ZAKTTP,ZAKZZZ,ZAKZUG,ZAKZAA)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS406ZAP ( ZAPNUM VARCHAR(5) BINARY ,ZAPTXT VARCHAR(50) BINARY ,ZAPKTX VARCHAR(10) BINARY ,ZAPSTA DECIMAL(5,0) DEFAULT 1,ZAPDAT DATETIME ,ZAPERF VARCHAR(50) BINARY DEFAULT 'Timesys' ,PRIMARY KEY(ZAPNUM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS421KSTS ( KSTSTID VARCHAR(255) BINARY ,KSTSSLOT1 VARCHAR(24) BINARY ,KSTSSLOT2 VARCHAR(24) BINARY ,KSTSSLOT3 VARCHAR(24) BINARY ,KSTSSLOT4 VARCHAR(24) BINARY ,KSTSDTM DATETIME ,KSTSUHR DATETIME  ,PRIMARY KEY(KSTSTID)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS500JOB ( JOBDA1 VARCHAR(14) BINARY ,JOBKE2 VARCHAR(32) BINARY ,JOBURV VARCHAR(256) BINARY ,JOBCMD VARCHAR(256) BINARY ,JOBCDI VARCHAR(256) BINARY ,JOBPRM VARCHAR(512) BINARY ,JOBRUS VARCHAR(128) BINARY ,JOBMRT DECIMAL(5,0) ,JOBRTY VARCHAR(2) BINARY ,JOBPRI DECIMAL(5,0) ,JOBDLS DECIMAL(5,0) ,JOBDLT VARCHAR(14) BINARY ,JOBBEM VARCHAR(256) BINARY ,JOBSCD VARCHAR(10) BINARY ,JOBSTS VARCHAR(2) BINARY ,JOBNAM VARCHAR(64) BINARY ,JOBUSR VARCHAR(128) BINARY ,JOBNUM VARCHAR(8) BINARY ,JOBSDA VARCHAR(14) BINARY ,JOBEDA VARCHAR(14) BINARY ,JOBNRT VARCHAR(14) BINARY ,JOBSTV DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(JOBDA1,JOBKE2)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS510ZSP ( ZSPLIZ VARCHAR(5) BINARY ,ZSPMND VARCHAR(5) BINARY ,ZSPUSR VARCHAR(50) BINARY ,ZSPFRM VARCHAR(25) BINARY ,ZSPKEY VARCHAR(50) BINARY ,ZSPDAT VARCHAR(14) BINARY ,ZSPGBI VARCHAR(14) BINARY ,ZSPZSP TEXT  ,PRIMARY KEY(ZSPLIZ,ZSPMND,ZSPUSR,ZSPFRM,ZSPKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS511STK ( STKDAT VARCHAR(14) BINARY ,STKSEK DECIMAL(12,0) ,STKUSE DECIMAL(12,8) ,STKLIZ VARCHAR(5) BINARY ,STKMND VARCHAR(5) BINARY ,STKUSR VARCHAR(50) BINARY ,STKFRM VARCHAR(25) BINARY ,STKPRM VARCHAR(2048) BINARY ,STKDAU DECIMAL(12,8) DEFAULT 0,STKMEM DECIMAL(9,0) DEFAULT 0,STKSZE DECIMAL(9,0) DEFAULT 0,STKUZ1 DECIMAL(9,0) DEFAULT 0,STKUM1 DECIMAL(9,0) DEFAULT 0,STKUZ2 DECIMAL(9,0) DEFAULT 0,STKUM2 DECIMAL(9,0) DEFAULT 0 ,PRIMARY KEY(STKDAT,STKSEK,STKUSE,STKLIZ,STKMND,STKUSR,STKFRM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS512DBG ( DBGDATTIM VARCHAR(14) BINARY ,DBGDATSEK DECIMAL(12,0) ,DBGDATUSE DECIMAL(12,8) ,DBGSRVIPA VARCHAR(50) BINARY ,DBGSRVHST VARCHAR(256) BINARY ,DBGSRVUAG VARCHAR(512) BINARY ,DBGSESIDN VARCHAR(50) BINARY ,DBGSESNAM VARCHAR(50) BINARY ,DBGSESUSR VARCHAR(50) BINARY ,DBGSESLIZ VARCHAR(5) BINARY ,DBGSESMND VARCHAR(5) BINARY ,DBGSESSCH VARCHAR(20) BINARY ,DBGSESASC VARCHAR(40) BINARY ,DBGREQFRM VARCHAR(20) BINARY ,DBGWEBANM VARCHAR(50) BINARY ,DBGWEBLIZ VARCHAR(5) BINARY ,DBGWEBMND VARCHAR(5) BINARY ,DBGWEBPNR VARCHAR(8) BINARY ,DBGWEBUIP VARCHAR(15) BINARY ,DBGPRMVAL VARCHAR(2048) BINARY  ,PRIMARY KEY(DBGDATTIM,DBGDATSEK,DBGDATUSE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS650ART ( ARTVON DATETIME ,ARTBIS DATETIME ,ARTART DECIMAL(5,0) ,ARTMWS DECIMAL(4,2) ,ARTBLG DECIMAL(2,0) ,ARTPSL DECIMAL(2,0) ,ARTUST DECIMAL(2,0) ,ARTKMT DECIMAL(2,0) ,ARTBTR DECIMAL(6,2) ,ARTCSM VARCHAR(32) BINARY DEFAULT NULL,ARTPRZ DECIMAL(6,2) ,ARTABZ DECIMAL(2,0) ,ARTGRP DECIMAL(2,0)  ,PRIMARY KEY(ARTVON,ARTART)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS651LVP ( LVPLND VARCHAR(10) BINARY ,LVPVON DATETIME ,LVPBIS DATETIME ,LVPTXT DECIMAL(5,0) ,LVPVP1 DECIMAL(6,2) ,LVPVP2 DECIMAL(6,2) ,LVPVP3 DECIMAL(6,2) ,LVPUPS DECIMAL(6,2) ,LVPCSM VARCHAR(32) BINARY DEFAULT NULL ,PRIMARY KEY(LVPLND,LVPVON)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS680IAS ( IASNAM VARCHAR(250) BINARY ,IASLNK VARCHAR(250) BINARY ,IASSRC VARCHAR(250) BINARY ,IASDA2 VARCHAR(25) BINARY ,IASTYP DECIMAL(5,0) ,IASFIR VARCHAR(50) BINARY ,IASMND VARCHAR(5) BINARY ,IASLIZ VARCHAR(5) BINARY ,IASSTA DECIMAL(5,0) DEFAULT 0,IASDAT DATETIME ,IASERF VARCHAR(50) BINARY DEFAULT 'TIMESYS' ,PRIMARY KEY(IASNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS800DWH ( DWHLIZ VARCHAR(5) BINARY ,DWHMND VARCHAR(5) BINARY ,DWHSCH VARCHAR(20) BINARY ,DWHFIR VARCHAR(50) BINARY ,DWHNAM VARCHAR(50) BINARY ,DWHTXT VARCHAR(100) BINARY ,DWHSTS DECIMAL(5,0) ,DWHZTR DECIMAL(5,0) ,DWHVON VARCHAR(8) BINARY ,DWHBIS VARCHAR(8) BINARY ,DWHDAR DECIMAL(5,0) ,DWHANB DECIMAL(5,0) ,DWHANK DECIMAL(5,0) ,DWHANT DECIMAL(5,0) ,DWHAUS DECIMAL(5,0) ,DWHGRP DECIMAL(5,0) ,DWHSOR DECIMAL(5,0) ,DWHOWN VARCHAR(50) BINARY DEFAULT 'TIMESYS',DWHSTA DECIMAL(5,0) DEFAULT 1,DWHDAT DATETIME ,DWHERF VARCHAR(50) BINARY DEFAULT 'TIMESYS',DWHSQL VARCHAR(500) BINARY ,DWHSTT VARCHAR(5) BINARY DEFAULT 'A',DWHLNU DECIMAL(5,0) DEFAULT 99,DWHPFR DECIMAL(2,0) ,DWHGRW VARCHAR(3) BINARY ,DWHGRT VARCHAR(25) BINARY ,DWHKLI DECIMAL(2,0) ,DWHKLT VARCHAR(50) BINARY ,DWHKMI DECIMAL(2,0) ,DWHKMT VARCHAR(50) BINARY ,DWHKRI DECIMAL(2,0) ,DWHKRT VARCHAR(50) BINARY ,DWHFLI DECIMAL(2,0) ,DWHFLT VARCHAR(50) BINARY ,DWHFMI DECIMAL(2,0) ,DWHFMT VARCHAR(50) BINARY ,DWHFRI DECIMAL(2,0) ,DWHFRT VARCHAR(50) BINARY ,DWHGRI DECIMAL(2,0) ,DWHGPI DECIMAL(2,0) ,DWHGPW VARCHAR(3) BINARY ,DWHGPT VARCHAR(25) BINARY ,DWHMAB DECIMAL(2,0) DEFAULT 1,DWHKAT DECIMAL(3,0) DEFAULT 1,DWHSBE VARCHAR(8) BINARY DEFAULT '99999999',DWHSNM VARCHAR(50) BINARY ,DWHBER DECIMAL(1,0) DEFAULT 0,DWHCPY VARCHAR(4) BINARY DEFAULT NULL ,PRIMARY KEY(DWHLIZ,DWHMND,DWHNAM,DWHSTT,DWHSBE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS800PRTREP ( PRTBER DECIMAL(1,0) ,PRTNAM VARCHAR(50) BINARY ,PRTTAB VARCHAR(100) BINARY ,PRTFLD VARCHAR(200) BINARY ,PRTFLT VARCHAR(300) BINARY ,PRTFNA VARCHAR(500) BINARY ,PRTSAN DECIMAL(1,0) ,PRTSDA DECIMAL(1,0) ,PRTSFR DECIMAL(1,0) ,PRTGNU DECIMAL(1,0) ,PRTGNA VARCHAR(20) BINARY ,PRTDAV VARCHAR(10) BINARY ,PRTDAB VARCHAR(10) BINARY ,PRTVON VARCHAR(50) BINARY ,PRTVNU DECIMAL(2,0) ,PRTBIS VARCHAR(50) BINARY ,PRTBNU DECIMAL(2,0) ,PRTFIL VARCHAR(300) BINARY ,PRTSUM VARCHAR(300) BINARY ,PRTGRP DECIMAL(1,0) ,PRTAKT DECIMAL(1,0) ,PRTAUS DECIMAL(1,0) ,PRTART DECIMAL(1,0) DEFAULT 1,PRTFIR VARCHAR(100) BINARY  ,PRIMARY KEY(PRTBER,PRTNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS800REP ( REPNAM VARCHAR(50) BINARY ,REPTXT VARCHAR(50) BINARY ,REPLDT DATETIME ,REPLBE VARCHAR(8) BINARY ,REPSTA DECIMAL(5,0) DEFAULT 0,REPERF VARCHAR(50) BINARY ,REPDAT DATETIME ,REPKOM VARCHAR(150) BINARY ,REPSNU DECIMAL(1,0) DEFAULT 0,REPSDA DECIMAL(1,0) DEFAULT 0,REPSFR DECIMAL(5,0) DEFAULT 0,REPGNU DECIMAL(1,0) DEFAULT 0,REPGNA VARCHAR(50) BINARY ,REPDVN DATETIME ,REPDBS DATETIME ,REPSVN VARCHAR(50) BINARY ,REPSBS VARCHAR(50) BINARY ,REPBER DECIMAL(1,0) ,REPSAS DECIMAL(1,0) DEFAULT 0 ,PRIMARY KEY(REPNAM,REPBER)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS800SCD ( SCDNAM VARCHAR(50) BINARY ,SCDLIZ VARCHAR(5) BINARY ,SCDMND VARCHAR(5) BINARY ,SCDSBE VARCHAR(8) BINARY ,SCDTXT VARCHAR(100) BINARY ,SCDART DECIMAL(5,0) DEFAULT 0,SCDTYP DECIMAL(5,0) DEFAULT 0,SCDTAG VARCHAR(7) BINARY ,SCDDTM DATETIME ,SCDUHR DATETIME ,SCDDWH VARCHAR(50) BINARY ,SCDDWN VARCHAR(100) BINARY ,SCDSTA DECIMAL(5,0) DEFAULT 1,SCDDAT DATETIME ,SCDERF VARCHAR(50) BINARY ,SCDBIS DATETIME ,SCDEMS DECIMAL(5,0)  ,PRIMARY KEY(SCDNAM,SCDLIZ,SCDMND,SCDSBE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS800ZUO ( ZUOTAB VARCHAR(15) BINARY ,ZUOLFD DECIMAL(5,0) ,ZUOTXT VARCHAR(50) BINARY ,ZUOFLD VARCHAR(12) BINARY ,ZUONUM DECIMAL(11,0) ,ZUOWHL DECIMAL(5,0) ,ZUOFTX VARCHAR(50) BINARY ,ZUOIDX DECIMAL(5,0) ,ZUOSTA DECIMAL(5,0) DEFAULT 1,ZUOLAN DECIMAL(5,0) DEFAULT 10,ZUOTYP VARCHAR(20) BINARY ,ZUOPRI DECIMAL(5,0) DEFAULT 1 ,PRIMARY KEY(ZUOTAB,ZUOLFD,ZUOFLD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS801EMA ( EMASCD VARCHAR(50) BINARY ,EMALIZ VARCHAR(5) BINARY ,EMAMND VARCHAR(5) BINARY ,EMASBE VARCHAR(8) BINARY ,EMALFD DECIMAL(5,0) ,EMAILA VARCHAR(50) BINARY ,EMASTA DECIMAL(5,0) DEFAULT 1,EMADAT DATETIME ,EMAERF VARCHAR(50) BINARY  ,PRIMARY KEY(EMASCD,EMALIZ,EMAMND,EMASBE,EMALFD)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS801GRP ( GRPLIZ VARCHAR(5) BINARY ,GRPMND VARCHAR(5) BINARY ,GRPSCH VARCHAR(20) BINARY ,GRPFIR VARCHAR(50) BINARY ,GRPDWH VARCHAR(50) BINARY ,GRPTYP VARCHAR(3) BINARY ,GRPKEY VARCHAR(30) BINARY ,GRPGPO DECIMAL(5,0) ,GRPPOS DECIMAL(5,0) ,GRPTAB VARCHAR(15) BINARY ,GRPFLD VARCHAR(10) BINARY ,GRPSTT VARCHAR(5) BINARY DEFAULT 'A',GRPSBE VARCHAR(8) BINARY DEFAULT '99999999',GRPCPY VARCHAR(4) BINARY DEFAULT NULL,GRPAOR DECIMAL(5,0) DEFAULT 0,GRPKLA DECIMAL(1,0) DEFAULT 0,GRPKLZ DECIMAL(1,0) DEFAULT 0,GRPFLC DECIMAL(5,0) DEFAULT 0 ,PRIMARY KEY(GRPLIZ,GRPMND,GRPDWH,GRPTYP,GRPKEY,GRPGPO,GRPPOS,GRPSTT,GRPSBE,GRPFLC)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS801ZUO ( ZUOTAB VARCHAR(15) BINARY ,ZUOFLD VARCHAR(9) BINARY ,ZUOSUM DECIMAL(1,0) DEFAULT 0,ZUOST1 DECIMAL(1,0) DEFAULT 0,ZUOBER DECIMAL(1,0) DEFAULT NULL,ZUOART DECIMAL(1,0) DEFAULT 0,ZUOVWS VARCHAR(15) BINARY ,ZUOBEW VARCHAR(15) BINARY  ,PRIMARY KEY(ZUOTAB,ZUOFLD,ZUOBER)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS802FLD ( FLDLIZ VARCHAR(5) BINARY ,FLDMND VARCHAR(5) BINARY ,FLDSCH VARCHAR(20) BINARY ,FLDFIR VARCHAR(50) BINARY ,FLDDWH VARCHAR(50) BINARY ,FLDTYP VARCHAR(3) BINARY ,FLDKEY VARCHAR(30) BINARY ,FLDTXT VARCHAR(120) BINARY ,FLDGPO DECIMAL(5,0) ,FLDPOS DECIMAL(5,0) ,FLDTAB VARCHAR(15) BINARY ,FLDFLD VARCHAR(10) BINARY ,FLDSTT VARCHAR(5) BINARY DEFAULT 'A',FLDTY2 VARCHAR(3) BINARY ,FLDPO2 DECIMAL(5,0) ,FLDLAN DECIMAL(5,0) DEFAULT 10,FLDSUM DECIMAL(5,0) DEFAULT 0,FLDNUM DECIMAL(11,0) DEFAULT 0,FLDWHL DECIMAL(5,0) ,FLDSPR DECIMAL(5,0) DEFAULT 1,FLDSBE VARCHAR(8) BINARY DEFAULT '99999999',FLDCPY VARCHAR(4) BINARY DEFAULT NULL ,PRIMARY KEY(FLDLIZ,FLDMND,FLDDWH,FLDTYP,FLDKEY,FLDSTT,FLDSPR,FLDSBE)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS803OPT ( OPTLIZ VARCHAR(5) BINARY ,OPTMND VARCHAR(5) BINARY ,OPTDWH VARCHAR(50) BINARY ,OPTSTT VARCHAR(5) BINARY DEFAULT 'A',OPTSBE VARCHAR(8) BINARY DEFAULT '99999999',OPTKEY VARCHAR(10) BINARY ,OPTVA1 DECIMAL(5,0) DEFAULT 0,OPTTX1 VARCHAR(100) BINARY ,OPTVA2 DECIMAL(5,0) DEFAULT 0,OPTTX2 VARCHAR(100) BINARY ,OPTF01 VARCHAR(10) BINARY ,OPTF02 VARCHAR(10) BINARY ,OPTF03 VARCHAR(12) BINARY ,OPTF04 VARCHAR(10) BINARY ,OPTF05 VARCHAR(10) BINARY ,OPTF06 VARCHAR(10) BINARY ,OPTCPY VARCHAR(4) BINARY DEFAULT NULL ,PRIMARY KEY(OPTLIZ,OPTMND,OPTDWH,OPTSTT,OPTSBE,OPTKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS899TXT ( TXTLIZ VARCHAR(5) BINARY ,TXTMND VARCHAR(5) BINARY ,TXTTYP VARCHAR(15) BINARY ,TXTKEY VARCHAR(30) BINARY ,TXTTXT VARCHAR(100) BINARY  ,PRIMARY KEY(TXTLIZ,TXTMND,TXTTYP,TXTKEY)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS900ENT ( ENTKEY VARCHAR(14) BINARY ,ENTPNR VARCHAR(8) BINARY ,ENTUSR VARCHAR(50) BINARY ,ENTSCH VARCHAR(50) BINARY ,ENTANT DECIMAL(5,0) ,ENTFRG VARCHAR(250) BINARY ,ENTSTA DECIMAL(5,0)  ,PRIMARY KEY(ENTKEY,ENTPNR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS900PRT ( PRTKEY TIMESTAMP,PRTPRG VARCHAR(20) BINARY ,PRTTXT VARCHAR(250) BINARY ,PRTDAT VARCHAR(20) BINARY ,PRTERF VARCHAR(50) BINARY ,PRTCHK VARCHAR(32) BINARY  ,PRIMARY KEY(PRTKEY,PRTPRG)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS901TABELLEN ( TABNAM VARCHAR(15) BINARY ,TABPS1 VARCHAR(4) BINARY ,TABPOS VARCHAR(10) BINARY ,TABFLD DECIMAL(11,0) DEFAULT 0,TABTXT VARCHAR(50) BINARY ,TABFRM VARCHAR(50) BINARY ,TABSTA DECIMAL(5,0) DEFAULT 1,TABDAT DATETIME ,TABERF VARCHAR(50) BINARY DEFAULT 'Timesys',TABREP VARCHAR(10) BINARY  ,PRIMARY KEY(TABNAM)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TMS999TMP ( TMPUSR VARCHAR(100) BINARY ,TMPSTR VARCHAR(512) BINARY ,TMPDAT DATETIME  ,PRIMARY KEY(TMPUSR,TMPSTR)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.TRMASWDNL ( DNLTRM VARCHAR(255) BINARY ,DNLASW VARCHAR(13) BINARY ,DNLGVO VARCHAR(8) BINARY ,DNLGBI VARCHAR(8) BINARY ,DNLSTB VARCHAR(3) BINARY ,DNLSTO VARCHAR(8) BINARY ,DNLKZE DECIMAL(1,0) ,DNLKZU DECIMAL(1,0) ,DNLSAL VARCHAR(10) BINARY ,DNLSPR DECIMAL(1,0) ,DNLLIZ VARCHAR(5) BINARY ,DNLMND VARCHAR(5) BINARY ,DNLSA1 VARCHAR(7) BINARY ,DNLATP DECIMAL(2,0) ,DNLAAN VARCHAR(50) BINARY ,DNLL01 VARCHAR(2) BINARY ,DNLB01 VARCHAR(3) BINARY ,DNLL02 VARCHAR(2) BINARY ,DNLB02 VARCHAR(3) BINARY ,DNLL03 VARCHAR(2) BINARY ,DNLB03 VARCHAR(3) BINARY ,DNLL04 VARCHAR(2) BINARY ,DNLB04 VARCHAR(3) BINARY ,DNLL05 VARCHAR(2) BINARY ,DNLB05 VARCHAR(3) BINARY ,DNLL06 VARCHAR(2) BINARY ,DNLB06 VARCHAR(3) BINARY ,DNLL07 VARCHAR(2) BINARY ,DNLB07 VARCHAR(3) BINARY ,DNLL08 VARCHAR(2) BINARY ,DNLB08 VARCHAR(3) BINARY ,DNLL09 VARCHAR(2) BINARY ,DNLB09 VARCHAR(3) BINARY ,DNLL10 VARCHAR(2) BINARY ,DNLB10 VARCHAR(3) BINARY ,DNLL11 VARCHAR(2) BINARY ,DNLB11 VARCHAR(3) BINARY ,DNLPIN VARCHAR(32) BINARY ,DNLPNR VARCHAR(8) BINARY ,DNLNAM VARCHAR(50) BINARY  ,PRIMARY KEY(DNLTRM,DNLASW)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
CREATE TABLE TMSYSTEM.VERSIONSHISTORIE ( VERSION VARCHAR(5) BINARY ,MODUL DECIMAL(2,0) ,FORMULAR VARCHAR(30) BINARY ,TEXT DECIMAL(11,0) ,GRAFIK VARCHAR(255) BINARY ,HANDBUCH VARCHAR(255) BINARY ,AUFTRAG DECIMAL(8,0) ,ERFASSER VARCHAR(50) BINARY ,STAMP DATETIME ,REITER VARCHAR(30) BINARY ,ZUSATZ VARCHAR(255) BINARY ,PRODUKT VARCHAR(100) BINARY  ,PRIMARY KEY(VERSION,MODUL,FORMULAR,AUFTRAG,REITER)   ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='TIMENSION';
