1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
| CREATE TABLE `machinedata` (
`dat_id` int(11) NOT NULL AUTO_INCREMENT,
`dat_macid` int(11) NOT NULL,
`dat_datetime` datetime DEFAULT NULL,
`dat_field1` varchar(40) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field2` varchar(40) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field3` date DEFAULT NULL,
`dat_field4` datetime DEFAULT NULL,
`dat_field5` datetime DEFAULT NULL,
`dat_field6` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field7` decimal(12,2) DEFAULT NULL,
`dat_field8` int(11) DEFAULT NULL,
`dat_field9` int(11) DEFAULT NULL,
`dat_field10` int(11) DEFAULT NULL,
`dat_field11` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field12` varchar(17) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field13` int(11) DEFAULT NULL,
`dat_field14` varchar(20) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field15` datetime DEFAULT NULL,
`dat_field16` datetime DEFAULT NULL,
`dat_field17` int(11) DEFAULT NULL,
`dat_field18` int(11) DEFAULT NULL,
`dat_field19` datetime DEFAULT NULL,
`dat_field20` int(11) DEFAULT NULL,
`dat_field21` int(11) DEFAULT NULL,
`dat_field22` int(11) DEFAULT NULL,
`dat_field23` int(11) DEFAULT NULL,
`dat_field24` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field25` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field26` int(11) DEFAULT NULL,
`dat_field27` varchar(35) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field28` int(11) DEFAULT NULL,
`dat_field29` int(11) DEFAULT NULL,
`dat_field30` int(11) DEFAULT NULL,
`dat_field31` int(11) DEFAULT NULL,
`dat_field32` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field33` varchar(35) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field34` int(11) DEFAULT NULL,
`dat_field35` int(11) DEFAULT NULL,
`dat_field36` int(11) DEFAULT NULL,
`dat_field37` int(11) DEFAULT NULL,
`dat_field38` int(11) DEFAULT NULL,
`dat_field39` varchar(15) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field40` int(11) DEFAULT NULL,
`dat_field41` int(11) DEFAULT NULL,
`dat_field42` int(11) DEFAULT NULL,
`dat_field43` int(11) DEFAULT NULL,
`dat_field44` int(11) DEFAULT NULL,
`dat_field45` int(11) DEFAULT NULL,
`dat_field46` int(11) DEFAULT NULL,
`dat_field47` int(11) DEFAULT NULL,
`dat_field48` int(11) DEFAULT NULL,
`dat_field49` decimal(12,2) DEFAULT NULL,
`dat_field50` int(11) DEFAULT NULL,
`dat_field51` int(11) DEFAULT NULL,
`dat_field52` int(11) DEFAULT NULL,
`dat_field53` int(11) DEFAULT NULL,
`dat_field54` int(11) DEFAULT NULL,
`dat_field55` int(11) DEFAULT NULL,
`dat_field56` int(11) DEFAULT NULL,
`dat_field57` int(11) DEFAULT NULL,
`dat_field58` int(11) DEFAULT NULL,
`dat_field59` int(11) DEFAULT NULL,
`dat_field60` int(11) DEFAULT NULL,
`dat_field61` int(11) DEFAULT NULL,
`dat_field62` int(11) DEFAULT NULL,
`dat_field63` int(11) DEFAULT NULL,
`dat_field64` int(11) DEFAULT NULL,
`dat_field65` int(11) DEFAULT NULL,
`dat_field66` int(11) DEFAULT NULL,
`dat_field67` int(11) DEFAULT NULL,
`dat_field68` int(11) DEFAULT NULL,
`dat_field69` int(11) DEFAULT NULL,
`dat_field70` int(11) DEFAULT NULL,
`dat_field71` int(11) DEFAULT NULL,
`dat_field72` int(11) DEFAULT NULL,
`dat_field73` int(11) DEFAULT NULL,
`dat_field74` int(11) DEFAULT NULL,
`dat_field75` int(11) DEFAULT NULL,
`dat_field76` int(11) DEFAULT NULL,
`dat_field77` int(11) DEFAULT NULL,
`dat_field78` int(11) DEFAULT NULL,
`dat_field79` int(11) DEFAULT NULL,
`dat_field80` int(11) DEFAULT NULL,
`dat_field81` int(11) DEFAULT NULL,
`dat_field82` int(11) DEFAULT NULL,
`dat_field83` int(11) DEFAULT NULL,
`dat_field84` int(11) DEFAULT NULL,
`dat_field85` int(11) DEFAULT NULL,
`dat_field86` int(11) DEFAULT NULL,
`dat_field87` int(11) DEFAULT NULL,
`dat_field88` int(11) DEFAULT NULL,
`dat_field89` int(11) DEFAULT NULL,
`dat_field90` int(11) DEFAULT NULL,
`dat_field91` int(11) DEFAULT NULL,
`dat_field92` int(11) DEFAULT NULL,
`dat_field93` int(11) DEFAULT NULL,
`dat_field94` int(11) DEFAULT NULL,
`dat_field95` int(11) DEFAULT NULL,
`dat_field96` int(11) DEFAULT NULL,
`dat_field97` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field98` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field99` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field100` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field101` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field102` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field103` varchar(10) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field104` int(11) DEFAULT NULL,
`dat_field105` int(11) DEFAULT NULL,
`dat_field106` int(11) DEFAULT NULL,
`dat_field107` int(11) DEFAULT NULL,
`dat_field108` int(11) DEFAULT NULL,
`dat_field109` int(11) DEFAULT NULL,
`dat_field110` varchar(155) COLLATE latin1_general_cs DEFAULT NULL,
`dat_field111` datetime DEFAULT NULL,
`dat_field112` int(11) DEFAULT NULL,
`dat_field113` text COLLATE latin1_general_cs,
`dat_field114` int(11) DEFAULT '0',
PRIMARY KEY (`dat_id`),
KEY `fk_machinesv_idx` (`dat_macid`),
KEY `date_datetime` (`dat_datetime`),
CONSTRAINT `fk_machinesv` FOREIGN KEY (`dat_macid`) REFERENCES `machines` (`mac_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=251882 DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs; |
Partager