...und hier endlich die Tabellenstrukturen.
Code:
SHOW CREATE TABLE tbl
+---------------+------------------------------------------------------------------------------+
| Table | Create Table |
+---------------+------------------------------------------------------------------------------+
| articles | CREATE TABLE `articles` (
| | `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `subsid` tinyint(4) NOT NULL,
| | `locked` tinyint(4) NOT NULL,
| | `deleted` tinyint(4) NOT NULL,
| | `artiklenbr` varchar(20) NOT NULL,
| | `cml` decimal(6,2) NOT NULL,
| | `cmw` decimal(6,2) NOT NULL,
| | `cmh` decimal(6,2) NOT NULL,
| | `kg` decimal(7,3) NOT NULL,
| | `size` int(5) NOT NULL,
| | `unit` varchar(10) NOT NULL,
| | `warnqty` int(5) NOT NULL,
| | `density` decimal(5,4) NOT NULL,
| | `eshop` tinyint(1) NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `locked` (`locked`),
| | KEY `deleted` (`deleted`)
| | ) ENGINE=MyISAM AUTO_INCREMENT=61370 DEFAULT CHARSET=utf8
+---------------+------------------------------------------------------------------------------+
| labels | CREATE TABLE `labels` (
| | `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `deleted` tinyint(1) NOT NULL,
| | `artikleid` int(10) NOT NULL,
| | `lang` varchar(12) NOT NULL,
| | `label1` text NOT NULL,
| | `label2` text NOT NULL,
| | `description` text NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `deleted` (`deleted`),
| | KEY `artikleid` (`artikleid`),
| | KEY `lang` (`lang`)
| | ) ENGINE=MyISAM AUTO_INCREMENT=132173 DEFAULT CHARSET=utf8
+---------------+------------------------------------------------------------------------------+
| suppliers | CREATE TABLE `suppliers` (
| | `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `deleted` tinyint(1) NOT NULL,
| | `artikleid` int(10) NOT NULL,
| | `supplierid` int(10) NOT NULL,
| | `artiklenbr` varchar(20) NOT NULL,
| | `vatid` int(10) NOT NULL,
| | `currid` int(10) NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `deleted` (`deleted`),
| | KEY `artikleid` (`artikleid`),
| | KEY `supplierid` (`supplierid`)
| | ENGINE=MyISAM AUTO_INCREMENT=61371 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
+---------------+------------------------------------------------------------------------------+
| suppliernames | CREATE TABLE `suppliernames` (
| | `id` int(8) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `locked` int(1) NOT NULL,
| | `deleted` int(1) NOT NULL,
| | `ourcustnbr` varchar(12) NOT NULL,
| | `title` varchar(8) NOT NULL,
| | `name` varchar(60) NOT NULL,
| | `name2` varchar(60) NOT NULL,
| | `street` varchar(30) NOT NULL,
| | `street2` varchar(30) NOT NULL,
| | `zip` varchar(6) NOT NULL,
| | `town` varchar(30) NOT NULL,
| | `ctry` varchar(30) NOT NULL,
| | `website` varchar(60) NOT NULL,
| | `currid` int(10) NOT NULL,
| | `vatid` int(10) NOT NULL,
| | `note` text NOT NULL,
| | `cat` varchar(20) NOT NULL,
| | `payments` varchar(20) NOT NULL,
| | `duedate` tinyint(2) NOT NULL,
| | `accnbr` varchar(30) NOT NULL,
| | `bankname` varchar(60) NOT NULL,
| | `bankaddress` varchar(100) NOT NULL,
| | `ddb` tinyint(1) NOT NULL,
| | `epay` tinyint(1) NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `locked` (`locked`),
| | KEY `deleted` (`deleted`)
| | ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8
+---------------+------------------------------------------------------------------------------+
| purchprices | CREATE TABLE `purchprices` (
| | `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `deleted` tinyint(1) NOT NULL,
| | `artikleid` int(10) NOT NULL,
| | `supplierid` int(10) NOT NULL,
| | `listprice` float(6,2) NOT NULL,
| | `validfrom` int(10) NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `deleted` (`deleted`),
| | KEY `artikleid` (`artikleid`),
| | KEY `supplierid` (`supplierid`),
| | KEY `validfrom` (`validfrom`)
| | ) ENGINE=MyISAM AUTO_INCREMENT=61372 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
+---------------+------------------------------------------------------------------------------+
| salesprices | CREATE TABLE `salesprices` (
| | `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
| | `cdate` int(10) NOT NULL,
| | `udate` int(10) NOT NULL,
| | `userid` int(10) NOT NULL,
| | `deleted` tinyint(1) NOT NULL,
| | `artikleid` int(10) NOT NULL,
| | `currid` int(10) NOT NULL,
| | `listpreis` float(6,2) NOT NULL,
| | `inclplus` tinyint(1) NOT NULL,
| | `vatid` int(10) NOT NULL,
| | `validfrom` int(10) NOT NULL,
| | PRIMARY KEY (`id`),
| | KEY `deleted` (`deleted`),
| | KEY `artikleid` (`artikleid`),
| | KEY `validfrom` (`validfrom`)
| | ) ENGINE=MyISAM AUTO_INCREMENT=61371 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
+---------------+------------------------------------------------------------------------------+