modules/monitor/monitor.mysql


DROP TABLE IF EXISTS `monitor_graphlines`;
CREATE TABLE `monitor_graphlines` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `colour` varchar(255) default NULL,
  `graph` int(10) unsigned default NULL,
  `mapping` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `monitor_graphs`;
CREATE TABLE `monitor_graphs` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `page` int(10) unsigned default NULL,
  `units` varchar(255) default NULL,
  `stack` int(1) unsigned default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `monitor_mappings`;
CREATE TABLE `monitor_mappings` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `server` int(10) default NULL,
  `monitor` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `monitor_monitors`;
CREATE TABLE `monitor_monitors` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `oid` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `units` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `monitor_pages`;
CREATE TABLE `monitor_pages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `monitor_servers`;
CREATE TABLE `monitor_servers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `hostname` varchar(255) default NULL,
  `colour` varchar(50) default NULL,
  `community` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1
2	DROP TABLE IF EXISTS `monitor_graphlines`;
3	CREATE TABLE `monitor_graphlines` (
4	`id` int(10) unsigned NOT NULL auto_increment,
5	`title` varchar(255) default NULL,
6	`colour` varchar(255) default NULL,
7	`graph` int(10) unsigned default NULL,
8	`mapping` int(10) unsigned default NULL,
9	PRIMARY KEY (`id`)
10	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11
12	DROP TABLE IF EXISTS `monitor_graphs`;
13	CREATE TABLE `monitor_graphs` (
14	`id` int(10) unsigned NOT NULL auto_increment,
15	`title` varchar(255) default NULL,
16	`page` int(10) unsigned default NULL,
17	`units` varchar(255) default NULL,
18	`stack` int(1) unsigned default '0',
19	PRIMARY KEY (`id`)
20	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
21
22	DROP TABLE IF EXISTS `monitor_mappings`;
23	CREATE TABLE `monitor_mappings` (
24	`id` int(10) unsigned NOT NULL auto_increment,
25	`server` int(10) default NULL,
26	`monitor` int(10) default NULL,
27	PRIMARY KEY (`id`)
28	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
29
30	DROP TABLE IF EXISTS `monitor_monitors`;
31	CREATE TABLE `monitor_monitors` (
32	`id` int(10) unsigned NOT NULL auto_increment,
33	`name` varchar(255) default NULL,
34	`oid` varchar(255) default NULL,
35	`type` varchar(255) default NULL,
36	`units` varchar(255) default NULL,
37	PRIMARY KEY (`id`)
38	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
39
40	DROP TABLE IF EXISTS `monitor_pages`;
41	CREATE TABLE `monitor_pages` (
42	`id` int(10) unsigned NOT NULL auto_increment,
43	`name` varchar(255) default NULL,
44	PRIMARY KEY (`id`)
45	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
46
47	DROP TABLE IF EXISTS `monitor_servers`;
48	CREATE TABLE `monitor_servers` (
49	`id` int(10) unsigned NOT NULL auto_increment,
50	`name` varchar(255) default NULL,
51	`hostname` varchar(255) default NULL,
52	`colour` varchar(50) default NULL,
53	`community` varchar(255) default NULL,
54	PRIMARY KEY (`id`)
55	) ENGINE=MyISAM DEFAULT CHARSET=latin1;