# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Sep 26, 2004 at 03:34 PM
# Server version: 4.0.15
# PHP Version: 4.2.2
# 
# Database : `phpMyAdmin`
# 

# --------------------------------------------------------

#
# Table structure for table `bookmark`
#

CREATE TABLE `bookmark` (
  `id` int(11) NOT NULL auto_increment,
  `dbase` varchar(255) NOT NULL default '',
  `user` varchar(255) NOT NULL default '',
  `label` varchar(255) NOT NULL default '',
  `query` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM COMMENT='Bookmarks' AUTO_INCREMENT=1 ;

#
# Dumping data for table `bookmark`
#


# --------------------------------------------------------

#
# Table structure for table `column_comments`
#

CREATE TABLE `column_comments` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `column_name` varchar(64) NOT NULL default '',
  `comment` varchar(255) NOT NULL default '',
  `mimetype` varchar(255) NOT NULL default '',
  `transformation` varchar(255) NOT NULL default '',
  `transformation_options` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=1 ;

#
# Dumping data for table `column_comments`
#


# --------------------------------------------------------

#
# Table structure for table `column_info`
#

CREATE TABLE `column_info` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `column_name` varchar(64) NOT NULL default '',
  `comment` varchar(255) NOT NULL default '',
  `mimetype` varchar(255) NOT NULL default '',
  `transformation` varchar(255) NOT NULL default '',
  `transformation_options` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
) TYPE=MyISAM COMMENT='Comments for Columns' AUTO_INCREMENT=1 ;

#
# Dumping data for table `column_info`
#


# --------------------------------------------------------

#
# Table structure for table `history`
#

CREATE TABLE `history` (
  `id` bigint(20) unsigned NOT NULL auto_increment,
  `username` varchar(64) NOT NULL default '',
  `db` varchar(64) NOT NULL default '',
  `table` varchar(64) NOT NULL default '',
  `timevalue` timestamp(14) NOT NULL,
  `sqlquery` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `username` (`username`,`db`,`table`,`timevalue`)
) TYPE=MyISAM COMMENT='SQL history' AUTO_INCREMENT=1 ;

#
# Dumping data for table `history`
#


# --------------------------------------------------------

#
# Table structure for table `pdf_pages`
#

CREATE TABLE `pdf_pages` (
  `db_name` varchar(64) NOT NULL default '',
  `page_nr` int(10) unsigned NOT NULL auto_increment,
  `page_descr` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`page_nr`),
  KEY `db_name` (`db_name`)
) TYPE=MyISAM COMMENT='PDF Relationpages for PMA' AUTO_INCREMENT=4 ;

#
# Dumping data for table `pdf_pages`
#

INSERT INTO `pdf_pages` VALUES ('dev_cacti_2', 3, 'Cacti Database Schema (0.8.6)');

# --------------------------------------------------------

#
# Table structure for table `relation`
#

CREATE TABLE `relation` (
  `master_db` varchar(64) NOT NULL default '',
  `master_table` varchar(64) NOT NULL default '',
  `master_field` varchar(64) NOT NULL default '',
  `foreign_db` varchar(64) NOT NULL default '',
  `foreign_table` varchar(64) NOT NULL default '',
  `foreign_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`master_db`,`master_table`,`master_field`),
  KEY `foreign_field` (`foreign_db`,`foreign_table`)
) TYPE=MyISAM COMMENT='Relation table';

#
# Dumping data for table `relation`
#

INSERT INTO `relation` VALUES ('dev_cacti_2', 'cdef_items', 'cdef_id', 'dev_cacti_2', 'cdef', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_input_data', 'data_input_field_id', 'dev_cacti_2', 'data_input_fields', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_input_data', 'data_template_data_id', 'dev_cacti_2', 'data_template_data', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_item', 'host_id', 'dev_cacti_2', 'host', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_item', 'poller_id', 'dev_cacti_2', 'poller', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_input_fields', 'data_input_id', 'dev_cacti_2', 'data_input', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data', 'local_data_template_data_id', 'dev_cacti_2', 'data_template_data', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data', 'local_data_id', 'dev_cacti_2', 'data_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data', 'data_template_id', 'dev_cacti_2', 'data_template_data', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data', 'data_input_id', 'dev_cacti_2', 'data_input', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data_rra', 'data_template_data_id', 'dev_cacti_2', 'data_template_data', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_data_rra', 'rra_id', 'dev_cacti_2', 'rra', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_rrd', 'local_data_template_rrd_id', 'dev_cacti_2', 'data_template_rrd', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_rrd', 'local_data_id', 'dev_cacti_2', 'data_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'data_template_rrd', 'data_template_id', 'dev_cacti_2', 'data_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_template_input', 'graph_template_id', 'dev_cacti_2', 'data_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_template_input_defs', 'graph_template_input_id', 'dev_cacti_2', 'graph_template_input', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_template_input_defs', 'graph_template_item_id', 'dev_cacti_2', 'graph_templates_item', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_graph', 'local_graph_template_graph_id', 'dev_cacti_2', 'graph_templates_graph', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_graph', 'local_graph_id', 'dev_cacti_2', 'graph_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_graph', 'graph_template_id', 'dev_cacti_2', 'graph_templates', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'local_graph_template_item_id', 'dev_cacti_2', 'graph_templates_item', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'local_graph_id', 'dev_cacti_2', 'graph_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'graph_template_id', 'dev_cacti_2', 'graph_templates', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'task_item_id', 'dev_cacti_2', 'data_template_rrd', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'color_id', 'dev_cacti_2', 'colors', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_templates_item', 'cdef_id', 'dev_cacti_2', 'cdef', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_snmp_cache', 'host_id', 'dev_cacti_2', 'host', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_tree_items', 'graph_tree_id', 'dev_cacti_2', 'graph_tree', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_tree_items', 'local_graph_id', 'dev_cacti_2', 'graph_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_tree_items', 'rra_id', 'dev_cacti_2', 'rra', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'rra_cf', 'rra_id', 'dev_cacti_2', 'rra', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'settings_graphs', 'user_id', 'dev_cacti_2', 'user_auth', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'settings_tree', 'user_id', 'dev_cacti_2', 'user_auth', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'settings_tree', 'graph_tree_item_id', 'dev_cacti_2', 'graph_tree_items', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query', 'graph_template_id', 'dev_cacti_2', 'graph_templates', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query', 'data_input_id', 'dev_cacti_2', 'data_input', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_item', 'local_data_id', 'dev_cacti_2', 'data_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_command', 'poller_id', 'dev_cacti_2', 'poller', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph', 'snmp_query_id', 'dev_cacti_2', 'snmp_query', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph', 'graph_template_id', 'dev_cacti_2', 'graph_templates', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd', 'snmp_query_graph_id', 'dev_cacti_2', 'snmp_query_graph', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd', 'data_template_id', 'dev_cacti_2', 'data_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd', 'data_template_rrd_id', 'dev_cacti_2', 'data_template_rrd', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd_sv', 'snmp_query_graph_id', 'dev_cacti_2', 'snmp_query_graph', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd_sv', 'data_template_id', 'dev_cacti_2', 'data_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'snmp_query_graph_sv', 'snmp_query_graph_id', 'dev_cacti_2', 'snmp_query_graph', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'user_auth_realm', 'user_id', 'dev_cacti_2', 'user_auth', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_time', 'poller_id', 'dev_cacti_2', 'poller', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_snmp_cache', 'snmp_query_id', 'dev_cacti_2', 'snmp_query', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_snmp_query', 'host_id', 'dev_cacti_2', 'host', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_snmp_query', 'snmp_query_id', 'dev_cacti_2', 'snmp_query', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'graph_tree_items', 'host_id', 'dev_cacti_2', 'host', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'user_auth_perms', 'user_id', 'dev_cacti_2', 'user_auth', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_output', 'local_data_id', 'dev_cacti_2', 'data_local', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_template_graph', 'host_template_id', 'dev_cacti_2', 'host_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_template_graph', 'graph_template_id', 'dev_cacti_2', 'graph_templates', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_reindex', 'host_id', 'dev_cacti_2', 'host', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'poller_reindex', 'data_query_id', 'dev_cacti_2', 'snmp_query', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_template_snmp_query', 'host_template_id', 'dev_cacti_2', 'host_template', 'id');
INSERT INTO `relation` VALUES ('dev_cacti_2', 'host_template_snmp_query', 'snmp_query_id', 'dev_cacti_2', 'snmp_query', 'id');

# --------------------------------------------------------

#
# Table structure for table `table_coords`
#

CREATE TABLE `table_coords` (
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `pdf_page_number` int(11) NOT NULL default '0',
  `x` float unsigned NOT NULL default '0',
  `y` float unsigned NOT NULL default '0',
  PRIMARY KEY  (`db_name`,`table_name`,`pdf_page_number`)
) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';

#
# Dumping data for table `table_coords`
#

INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_template_input_defs', 3, '9', '358');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd_sv', 3, '215', '13');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'snmp_query', 3, '20', '13');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'snmp_query_graph_rrd', 3, '214', '112');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_tree_items', 3, '11', '488');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_templates_graph', 3, '134', '191');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_template_rrd', 3, '440', '305');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_template_data', 3, '435', '187');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_templates_item', 3, '136', '459');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'cdef_items', 3, '309', '518');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_input_fields', 3, '650', '182');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'rra_cf', 3, '773', '99');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'host_template', 3, '381', '53');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller_output', 3, '761', '518');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'host', 3, '677', '14');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller', 3, '762', '449');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller_command', 3, '681', '518');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_template_data_rra', 3, '310', '305');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'settings_tree', 3, '310', '431');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'host_snmp_cache', 3, '676', '95');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'host_snmp_query', 3, '462', '88');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'snmp_query_graph', 3, '97', '50');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_input_data', 3, '747', '182');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'user_auth_realm', 3, '731', '344');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'snmp_query_graph_sv', 3, '213', '57');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'settings_graphs', 3, '310', '375');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_tree', 3, '9', '427');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_template_input', 3, '8', '306');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'cdef', 3, '310', '477');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'colors', 3, '469', '13');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_templates', 3, '12', '191');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'graph_local', 3, '10', '248');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_input', 3, '582', '182');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_local', 3, '311', '238');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'data_template', 3, '311', '186');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'rra', 3, '774', '45');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller_reindex', 3, '599', '490');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'user_auth', 3, '444', '465');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'host_template_graph', 3, '462', '53');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'user_auth_perms', 3, '730', '385');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller_item', 3, '585', '349');
INSERT INTO `table_coords` VALUES ('dev_cacti_2', 'poller_time', 3, '681', '447');

# --------------------------------------------------------

#
# Table structure for table `table_info`
#

CREATE TABLE `table_info` (
  `db_name` varchar(64) NOT NULL default '',
  `table_name` varchar(64) NOT NULL default '',
  `display_field` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`db_name`,`table_name`)
) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';

#
# Dumping data for table `table_info`
#

INSERT INTO `table_info` VALUES ('dev_cacti_2', 'data_template_rrd', 'id');