1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| CREATE TABLE `printers` (
`ID` int(11) NOT NULL auto_increment,
`HARDWARE_ID` int(11) NOT NULL,
`NAME` varchar(255) collate latin1_general_ci default NULL,
`DRIVER` varchar(255) collate latin1_general_ci default NULL,
`PORT` varchar(255) collate latin1_general_ci default NULL,
PRIMARY KEY (`HARDWARE_ID`,`ID`),
KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=76 ;
INSERT INTO `printers` VALUES (1, 1, 'Phaser 8500DN PS', 'Xerox Phaser 8500DN PS', 'X_test-2819');
INSERT INTO `printers` VALUES (2, 1, 'Microsoft Office Document Image Writer', 'Microsoft Office Document Image Writer Driver', 'Microsoft Document Imaging Writer Port:');
INSERT INTO `printers` VALUES (3, 1, 'Kyocera Mita FS-3830N KX N&B', 'Kyocera Mita FS-3830N KX', 'IP_192.168.2.15');
INSERT INTO `printers` VALUES (4, 1, 'Dell Photo AIO Printer 922', 'Dell Photo AIO Printer 922', 'USB001');
INSERT INTO `printers` VALUES (5, 1, 'Adobe PDF', 'Adobe PDF Converter', 'Bureau/*.pdf');
INSERT INTO `printers` VALUES (6, 2, 'SnagIt 7', 'SnagIt 7 Printer', 'SNAGIT7');
INSERT INTO `printers` VALUES (7, 2, 'Phaser 8500DN PS', 'Xerox Phaser 8500DN PS', 'X_test-2819');
INSERT INTO `printers` VALUES (8, 2, 'Microsoft Office Document Image Writer', 'Microsoft Office Document Image Writer Driver', 'Microsoft Document Imaging Writer Port:');
INSERT INTO `printers` VALUES (9, 2, 'Lexmark Z65', 'Lexmark Z65', 'USB001'); |
Partager