SamnQb7S

1
2CREATE TABLE IF NOT EXISTS `datapoint` (
3  `datapoint_id` int(11) NOT NULL AUTO_INCREMENT,
4  `created` datetime NOT NULL,
5  `updated` datetime DEFAULT NULL,
6  `group_id` int(11) NOT NULL,
7  `filename` varchar(128) NOT NULL,
8  `class` varchar(128) NOT NULL,
9  `status` tinyint(1) NOT NULL DEFAULT '0',
10  PRIMARY KEY (`datapoint_id`)
11) TYPE=InnoDB;
12
13CREATE TABLE IF NOT EXISTS `group` (
14  `group_id` int(11) NOT NULL AUTO_INCREMENT,
15  `created` datetime NOT NULL,
16  `updated` datetime DEFAULT NULL,
17  `name` int(11) NOT NULL,
18  `status` tinyint(1) NOT NULL DEFAULT '0',
19  PRIMARY KEY (`group_id`)
20) TYPE=InnoDB;
21
22CREATE TABLE IF NOT EXISTS `test` (
23  `test_id` int(11) NOT NULL AUTO_INCREMENT,
24  `created` datetime NOT NULL,
25  `updated` datetime DEFAULT NULL,
26  `released` datetime DEFAULT NULL,
27  `user_id` int(11) NOT NULL,
28  `name` varchar(128) NOT NULL,
29  `project` varchar(128) NOT NULL,
30  `description` text NOT NULL,
31  `length` tinyint(4) NOT NULL,
32  `interval` tinyint(4) NOT NULL,
33  `compiled` tinyint(1) NOT NULL DEFAULT '0',
34  `status` tinyint(1) NOT NULL DEFAULT '0',
35  PRIMARY KEY (`test_id`),
36  KEY `user_id` (`user_id`)
37) TYPE=InnoDB;
38
39CREATE TABLE IF NOT EXISTS `test_datapoint` (
40  `test_datapoint_id` int(11) NOT NULL AUTO_INCREMENT,
41  `created` datetime NOT NULL,
42  `updated` datetime DEFAULT NULL,
43  `test_id` int(11) NOT NULL,
44  `datapoint_id` int(11) NOT NULL,
45  `host` mediumtext NOT NULL,
46  `username` mediumtext NOT NULL,
47  `password` mediumtext NOT NULL,
48  `database` mediumtext NOT NULL,
49  `key` varchar(40) NOT NULL,
50  `status` tinyint(1) NOT NULL DEFAULT '0',
51  PRIMARY KEY (`test_datapoint_id`)
52) TYPE=InnoDB;
53
54CREATE TABLE IF NOT EXISTS `test_datapoint_value` (
55  `test_datapoint_value_id` int(11) NOT NULL AUTO_INCREMENT,
56  `created` datetime NOT NULL,
57  `updated` datetime DEFAULT NULL,
58  `compiled` datetime DEFAULT NULL,
59  `test_datapoint_id` int(11) NOT NULL,
60  `key` varchar(24) NOT NULL,
61  `value` varchar(64) DEFAULT NULL,
62  PRIMARY KEY (`test_datapoint_value_id`)
63) TYPE=InnoDB;
64
65CREATE TABLE IF NOT EXISTS `user` (
66  `user_id` int(11) NOT NULL AUTO_INCREMENT,
67  `created` datetime NOT NULL,
68  `updated` datetime DEFAULT NULL,
69  `loggedin` datetime DEFAULT NULL,
70  `group_id` int(11) NOT NULL,
71  `email_address` varchar(255) NOT NULL,
72  `password` varchar(64) NOT NULL,
73  `salt` varchar(64) NOT NULL,
74  `fullname` varchar(128) NOT NULL,
75  `admin` tinyint(1) NOT NULL DEFAULT '0',
76  `status` tinyint(1) NOT NULL DEFAULT '0',
77  PRIMARY KEY (`user_id`),
78  UNIQUE KEY `email_address` (`email_address`)
79) TYPE=InnoDB;