Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Thursday, April 18, 2024
[BACK] [TXT][DIR] Up to [Platon] / scripts / perl / accounting
File: [Platon] / scripts / perl / accounting / db-structure.sql (download)

Revision 1.4, Sun Mar 13 21:49:42 2005 UTC (19 years, 1 month ago) by rajo


Changes since 1.3: +60 -13 lines 

Added configuration table and confgi_id column.

-- 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/
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS 		Go to Top