Advertisement
Guest User

Create statement

a guest
Apr 21st, 2023
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.95 KB | None | 0 0
  1.     CREATE TABLE `ins1_labelresults` (
  2.     `id` int(11) NOT NULL AUTO_INCREMENT,
  3.     `s_machine` varchar(10) NOT NULL,
  4.     `auftragsnummer` varchar(10) NOT NULL,
  5.     `nutzenSN` varchar(20) NOT NULL,
  6.     `position` int(11) NOT NULL DEFAULT 0,
  7.     `status` varchar(5) NOT NULL DEFAULT '',
  8.     `error` varchar(5) DEFAULT '',
  9.     `rawcode` varchar(60) DEFAULT '',
  10.     `seriennummer` varchar(20) DEFAULT '',
  11.     `kundenSN` varchar(20) DEFAULT '',
  12.     `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  13.     PRIMARY KEY (`id`),
  14.     KEY `nutzenSN_I` (`nutzenSN`),
  15.     KEY `seriennummer_I` (`seriennummer`),
  16.     KEY `kundenSN_I` (`kundenSN`),
  17.     KEY `raw_I` (`rawcode`),
  18.     KEY `Stat-pos-err_I` (`status`,`position`,`error`),
  19.     KEY `position_I` (`position`),
  20.     KEY `Auftrag_I` (`auftragsnummer`) USING BTREE,
  21.     KEY `Auftrag_stat_pos_err` (`auftragsnummer`,`status`,`position`,`error`)
  22.     ) ENGINE=InnoDB AUTO_INCREMENT=76708428 DEFAULT CHARSET=latin1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement