2
-- Host: localhost Database: test
3
-- ------------------------------------------------------
4
-- Server version 5.1.53-log
6
DROP TABLE IF EXISTS `data_report`;
7
CREATE TABLE `data_report` (
8
`id` int(11) NOT NULL AUTO_INCREMENT,
9
`date` date DEFAULT NULL,
10
`posted` datetime DEFAULT NULL,
11
`acquired` datetime DEFAULT NULL,
13
UNIQUE KEY `date` (`date`,`posted`,`acquired`)
14
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
DROP TABLE IF EXISTS `entity`;
17
CREATE TABLE `entity` (
18
`id` int(11) NOT NULL AUTO_INCREMENT,
19
`entity_property_1` varchar(16) DEFAULT NULL,
20
`entity_property_2` varchar(16) DEFAULT NULL,
22
UNIQUE KEY `entity_property_1` (`entity_property_1`,`entity_property_2`)
23
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
DROP TABLE IF EXISTS `data`;
27
`data_report` int(11) NOT NULL DEFAULT '0',
28
`hour` tinyint(4) NOT NULL DEFAULT '0',
29
`entity` int(11) NOT NULL DEFAULT '0',
30
`data_1` varchar(16) DEFAULT NULL,
31
`data_2` varchar(16) DEFAULT NULL,
32
PRIMARY KEY (`data_report`,`hour`,`entity`),
33
KEY `entity` (`entity`),
34
CONSTRAINT `data_ibfk_1` FOREIGN KEY (`data_report`) REFERENCES `data_report` (`id`),
35
CONSTRAINT `data_ibfk_2` FOREIGN KEY (`entity`) REFERENCES `entity` (`id`)
36
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
DROP TABLE IF EXISTS `raw_data`;
39
CREATE TABLE `raw_data` (
40
`date` date NOT NULL DEFAULT '0000-00-00',
41
`hour` tinyint(4) NOT NULL DEFAULT '0',
42
`entity_property_1` varchar(16) NOT NULL DEFAULT '',
43
`entity_property_2` varchar(16) NOT NULL DEFAULT '',
44
`data_1` varchar(16) DEFAULT NULL,
45
`data_2` varchar(16) DEFAULT NULL,
46
PRIMARY KEY (`date`,`hour`,`entity_property_1`,`entity_property_2`)
47
) ENGINE=InnoDB DEFAULT CHARSET=latin1;