-- MySQL dump 9.11
--
-- Host: localhost Database: system
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-1-log
--
-- Table structure for table `log_accounting_process`
--
DROP TABLE IF EXISTS `log_accounting_process`;
CREATE TABLE `log_accounting_process` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`command` char(17) NOT NULL default '',
`user_time` float NOT NULL default '0',
`system_time` float NOT NULL default '0',
`effective_time` float NOT NULL default '0',
`uid` smallint(5) unsigned NOT NULL default '0',
`gid` smallint(5) unsigned NOT NULL default '0',
`memory` float NOT NULL default '0',
`io` float NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `command_key` (`command`),
KEY `user_time_key` (`user_time`),
KEY `system_time_key` (`system_time`),
KEY `effective_time_key` (`effective_time`),
KEY `uid_key` (`uid`),
KEY `gid_key` (`gid`),
KEY `memory_key` (`memory`),
KEY `io_key` (`io`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct`
--
DROP TABLE IF EXISTS `net_acct`;
CREATE TABLE `net_acct` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_01`
--
DROP TABLE IF EXISTS `net_acct_2005_01`;
CREATE TABLE `net_acct_2005_01` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `ppp_user_key` (`ppp_user`),
KEY `source_port_key` (`source_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_02`
--
DROP TABLE IF EXISTS `net_acct_2005_02`;
CREATE TABLE `net_acct_2005_02` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_03`
--
DROP TABLE IF EXISTS `net_acct_2005_03`;
CREATE TABLE `net_acct_2005_03` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_04`
--
DROP TABLE IF EXISTS `net_acct_2005_04`;
CREATE TABLE `net_acct_2005_04` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `interface_key` (`interface`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_05`
--
DROP TABLE IF EXISTS `net_acct_2005_05`;
CREATE TABLE `net_acct_2005_05` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `packet_count_key` (`packet_count`),
KEY `interface_key` (`interface`),
KEY `data_size_key` (`data_size`),
KEY `ppp_user_key` (`ppp_user`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_06`
--
DROP TABLE IF EXISTS `net_acct_2005_06`;
CREATE TABLE `net_acct_2005_06` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `interface_key` (`interface`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_07`
--
DROP TABLE IF EXISTS `net_acct_2005_07`;
CREATE TABLE `net_acct_2005_07` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `dest_port_key` (`dest_port`),
KEY `data_size_key` (`data_size`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `packet_count_key` (`packet_count`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_08`
--
DROP TABLE IF EXISTS `net_acct_2005_08`;
CREATE TABLE `net_acct_2005_08` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `ip_proto_key` (`ip_proto`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_09`
--
DROP TABLE IF EXISTS `net_acct_2005_09`;
CREATE TABLE `net_acct_2005_09` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_10`
--
DROP TABLE IF EXISTS `net_acct_2005_10`;
CREATE TABLE `net_acct_2005_10` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_11`
--
DROP TABLE IF EXISTS `net_acct_2005_11`;
CREATE TABLE `net_acct_2005_11` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_2005_12`
--
DROP TABLE IF EXISTS `net_acct_2005_12`;
CREATE TABLE `net_acct_2005_12` (
`id` int(11) NOT NULL auto_increment,
`created` datetime default NULL,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` char(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` char(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` char(5) default NULL,
`ppp_user` char(12) default NULL,
`config_id` int(11) default NULL,
PRIMARY KEY (`id`),
KEY `created_key` (`created`),
KEY `ip_proto_key` (`ip_proto`),
KEY `source_ip_key` (`source_ip`),
KEY `source_port_key` (`source_port`),
KEY `dest_ip_key` (`dest_ip`),
KEY `dest_port_key` (`dest_port`),
KEY `packet_count_key` (`packet_count`),
KEY `data_size_key` (`data_size`),
KEY `interface_key` (`interface`),
KEY `ppp_user_key` (`ppp_user`),
KEY `config_id_key` (`config_id`)
) TYPE=MyISAM;
--
-- Table structure for table `net_acct_config`
--
DROP TABLE IF EXISTS `net_acct_config`;
CREATE TABLE `net_acct_config` (
`config_id` int(11) NOT NULL auto_increment,
`config_order` int(10) unsigned NOT NULL default '0',
`config_description` text,
`ip_proto` smallint(5) unsigned NOT NULL default '0',
`source_ip` varchar(15) default NULL,
`source_port` smallint(5) unsigned NOT NULL default '0',
`dest_ip` varchar(15) default NULL,
`dest_port` smallint(5) unsigned NOT NULL default '0',
`packet_count` int(10) unsigned NOT NULL default '0',
`data_size` bigint(20) unsigned NOT NULL default '0',
`interface` varchar(5) default NULL,
`ppp_user` varchar(12) default NULL,
PRIMARY KEY (`config_id`)
) TYPE=MyISAM;
Platon Group <platon@platon.org> http://platon.org/
|