1
2DROP TABLE IF EXISTS `metrics_assigned`;
3CREATE TABLE IF NOT EXISTS `metrics_assigned` (
4	`assigned_id` int(11) NOT NULL AUTO_INCREMENT,
5	`metric_id` int(11) NOT NULL,
6	`tab_id` int(11) NOT NULL,
7	PRIMARY KEY (`assigned_id`),
8	KEY `metric_id` (`metric_id`),
9	KEY `tab_id` (`tab_id`)
10) ENGINE=MyISAM;
11
12DROP TABLE IF EXISTS `metrics_metric`;
13CREATE TABLE IF NOT EXISTS `metrics_metric` (
14	`metric_id` int(11) NOT NULL AUTO_INCREMENT,
15	`metric_name` varchar(255) NOT NULL,
16	`metric_range` varchar(1) NOT NULL DEFAULT '+' COMMENT 'values: + (daily), @ (monthly&weekly), - (weekly)',
17	`metric_datatype` varchar(1) NOT NULL DEFAULT 'i' COMMENT 'values: i(nteger), %(percentage), f(loat), L(ist)',
18	`metric_lastupdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
19	`metric_query` text,
20	PRIMARY KEY (`metric_id`),
21	UNIQUE KEY `metric_name` (`metric_name`)
22) ENGINE=MyISAM;
23
24DROP TABLE IF EXISTS `metrics_tab`;
25CREATE TABLE IF NOT EXISTS `metrics_tab` (
26	`tab_id` int(11) NOT NULL AUTO_INCREMENT,
27	`tab_name` varchar(255) NOT NULL,
28	`tab_order` int(11) NOT NULL DEFAULT '0',
29	`tab_content` longtext NOT NULL,
30	PRIMARY KEY (`tab_id`),
31	UNIQUE KEY `tab_name` (`tab_name`)
32) ENGINE=MyISAM;
33
34