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