# MySQL-Front Dump 2.4 # # Host: db.w-sys.de Database: is_test #-------------------------------------------------------- # Server version 4.0.12-log USE is_test; # # Table structure for table 't_westfalia_artikel_import' # DROP TABLE IF EXISTS t_westfalia_artikel_import; CREATE TABLE `t_westfalia_artikel_import` ( `aiber` char(2) NOT NULL default '', `aiarnr` int(10) NOT NULL default '0', `aiers` int(9) default NULL, `aityp` int(1) default NULL, `aibez1` char(34) default NULL, `aibez2` char(34) default NULL, `aiwhgr` int(10) NOT NULL default '0', `aiwgr` int(10) NOT NULL default '0', `aifanr` int(10) NOT NULL default '0', `aigew` char(7) default NULL, `aiinkz` char(1) default NULL, `aialt` char(1) default NULL, `aibdan` char(7) default NULL, `aigrv` char(1) default NULL, `aigrzm` char(2) default NULL, `aigrbu` char(2) default NULL, `aibekz` int(1) default NULL, `aibstt` char(2) default NULL, `aibsmm` char(2) default NULL, `aibsjj` char(4) default NULL, `aibest` char(7) default NULL, `aiwkz` int(1) default NULL, `aiprei` decimal(9,2) default NULL, `aispr1` decimal(9,2) default NULL, `aispr2` decimal(9,2) default NULL, `aispr3` decimal(9,2) default NULL, `aisme1` char(7) default NULL, `aisme2` char(7) default NULL, `aisme3` char(7) default NULL, `aiknr1` char(5) default NULL, `aisei1` char(4) default NULL, `aiknr2` char(5) default NULL, `aisei2` char(4) default NULL, `aiknr3` char(5) default NULL, `aisei3` char(4) default NULL, `aiknr4` char(5) default NULL, `aisei4` char(4) default NULL, `aiknr5` char(5) default NULL, `aisei5` char(4) default NULL, `aiknr6` char(5) default NULL, `aisei6` char(4) default NULL, `aistat` char(1) default NULL, `aigara` decimal(3,1) default NULL, `aifatxt` char(120) default NULL, `afill1` char(6) default NULL, `afgrat` char(1) default NULL, `afill3` char(6) default NULL, `afill4` char(1) default NULL, `afill5` char(20) default NULL, `aiarnr_str` char(20) default NULL, `status` tinyint(1) default NULL, `fehler` tinyint(1) default NULL, `bearbdatum` datetime default NULL, UNIQUE KEY `airn` (`aiarnr`), KEY `aiber` (`aiber`), KEY `aiers` (`aiers`), KEY `aityp` (`aityp`), KEY `aiwhgr` (`aiwhgr`), KEY `aiwgr` (`aiwgr`), KEY `aifanr` (`aifanr`), KEY `bearbdatum` (`bearbdatum`), KEY `aifatxt` (`aifatxt`), KEY `aiarnr_str` (`aiarnr_str`) ) TYPE=InnoDB;