# phpMyAdmin MySQL-Dump
# version 2.2.3
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Mar 19, 2002 at 02:40 PM
# Server version: 3.23.41
# PHP Version: 4.0.6
# Database : `network`
# --------------------------------------------------------

#
# Table structure for table `cisco_products`
#

DROP TABLE IF EXISTS `cisco_products`;
CREATE TABLE `cisco_products` (
  `snmp_oid` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `device_type` int(11) NOT NULL default '0',
  UNIQUE KEY `cisco_products_snmp_oid_key` (`snmp_oid`)
) TYPE=MyISAM;

#
# Table structure for table `config`
#

DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY `config_pkey` (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `config`
#

INSERT INTO `config` (`name`, `value`) VALUES ('username', '');
INSERT INTO `config` (`name`, `value`) VALUES ('passwd', '');
INSERT INTO `config` (`name`, `value`) VALUES ('snmp_ro_string', '');
INSERT INTO `config` (`name`, `value`) VALUES ('enable_passwd', '');
INSERT INTO `config` (`name`, `value`) VALUES ('console_passwd', '');
INSERT INTO `config` (`name`, `value`) VALUES ('arp_collector_threads', '');
INSERT INTO `config` (`name`, `value`) VALUES ('switch_collector_threads', '');
INSERT INTO `config` (`name`, `value`) VALUES ('snmp_collector_threads', '');
# --------------------------------------------------------

#
# Table structure for table `device_states`
#

DROP TABLE IF EXISTS `device_states`;
CREATE TABLE `device_states` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY `device_states_pkey` (`id`),
  UNIQUE KEY `device_states_name_key` (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `device_states`
#

INSERT INTO `device_states` (`id`, `name`) VALUES (1, 'active');
INSERT INTO `device_states` (`id`, `name`) VALUES (2, 'discovered');
INSERT INTO `device_states` (`id`, `name`) VALUES (3, 'ignored');
INSERT INTO `device_states` (`id`, `name`) VALUES (4, 'inactive');
# --------------------------------------------------------

#
# Table structure for table `device_types`
#

DROP TABLE IF EXISTS `device_types`;
CREATE TABLE `device_types` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY `device_types_pkey` (`id`),
  UNIQUE KEY `device_types_name_key` (`name`)
) TYPE=MyISAM;

#
# Dumping data for table `device_types`
#

INSERT INTO `device_types` (`id`, `name`) VALUES (0, 'unknown');
INSERT INTO `device_types` (`id`, `name`) VALUES (1, 'router');
INSERT INTO `device_types` (`id`, `name`) VALUES (2, 'switch');
INSERT INTO `device_types` (`id`, `name`) VALUES (3, 'ATM switch');
# --------------------------------------------------------

#
# Table structure for table `devices`
#

DROP TABLE IF EXISTS `devices`;
CREATE TABLE `devices` (
  `name` varchar(255) NOT NULL default '',
  `type` tinyint(4) default NULL,
  `username` varchar(255) default NULL,
  `passwd` varchar(255) default NULL,
  `console_passwd` varchar(255) default NULL,
  `enable_passwd` varchar(255) default NULL,
  `snmp_ro_string` varchar(255) default NULL,
  `snmp_rw_string` varchar(255) default NULL,
  `last_contacted` datetime default NULL,
  `object_id` varchar(255) default NULL,
  `cdp_id` varchar(255) default NULL,
  `status` tinyint(4) default NULL,
  `ignore_ports` varchar(255) default NULL,
  PRIMARY KEY `devices_pkey` (`name`)
) TYPE=MyISAM;

#
# Table structure for table `log`
#

DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `time` datetime default NULL,
  `message` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Table structure for table `nodes`
#

DROP TABLE IF EXISTS `nodes`;
CREATE TABLE `nodes` (
  `mac_addr` varchar(17) NOT NULL default '',
  `switch` varchar(255) NOT NULL default '',
  `vlan` varchar(255) NOT NULL default '',
  `module` int(11) NOT NULL default '0',
  `port` int(11) NOT NULL default '0',
  `ip_addr` varchar(255) NOT NULL default '',
  `last_updated` datetime default NULL,
  PRIMARY KEY `nodes_pkey` (`mac_addr`)
) TYPE=MyISAM;

#
# Table structure for table `ports`
#

DROP TABLE IF EXISTS `ports`;
CREATE TABLE `ports` (
  `switch` varchar(255) NOT NULL default '',
  `module` varchar(255) NOT NULL default '',
  `port` varchar(255) NOT NULL default '',
  `vlan` varchar(255) NOT NULL default '',
  `enabled` tinyint(1) NOT NULL default '0',
  `speed` int(11) NOT NULL default '0',
  `duplex` int(11) NOT NULL default '0',
  `rcv_frame` bigint(20) NOT NULL default '0',
  `last_rc_frame` datetime default NULL
) TYPE=MyISAM;

#
# Table structure for table `switch_ports`
#

DROP TABLE IF EXISTS `switch_ports`;
CREATE TABLE `switch_ports` (
  `switch` varchar(255) NOT NULL default '',
  `module` tinyint(4) NOT NULL default '0',
  `port` tinyint(4) NOT NULL default '0',
  `inOctets` bigint(20) default NULL,
  `adminStatus` tinyint(4) default NULL,
  `adminSpeed` tinyint(4) default NULL,
  `adminDuplex` tinyint(4) default NULL,
  `vlan` tinyint(4) default NULL,
  `phyType` tinyint(4) default NULL,
  `last_input_increment` datetime default NULL,
  PRIMARY KEY `uniq_ports` (`switch`,`module`,`port`)
) TYPE=MyISAM;