Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `ins1_labelresults` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `s_machine` varchar(10) NOT NULL,
- `auftragsnummer` varchar(10) NOT NULL,
- `nutzenSN` varchar(20) NOT NULL,
- `position` int(11) NOT NULL DEFAULT 0,
- `status` varchar(5) NOT NULL DEFAULT '',
- `error` varchar(5) DEFAULT '',
- `rawcode` varchar(60) DEFAULT '',
- `seriennummer` varchar(20) DEFAULT '',
- `kundenSN` varchar(20) DEFAULT '',
- `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `nutzenSN_I` (`nutzenSN`),
- KEY `seriennummer_I` (`seriennummer`),
- KEY `kundenSN_I` (`kundenSN`),
- KEY `raw_I` (`rawcode`),
- KEY `Stat-pos-err_I` (`status`,`position`,`error`),
- KEY `position_I` (`position`),
- KEY `Auftrag_I` (`auftragsnummer`) USING BTREE,
- KEY `Auftrag_stat_pos_err` (`auftragsnummer`,`status`,`position`,`error`)
- ) ENGINE=InnoDB AUTO_INCREMENT=76708428 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement