-- MySQL dump 10.10
--
-- Host: localhost    Database: wwwlog
-- ------------------------------------------------------
-- Server version	5.0.26-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES latin1 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `access_log`
--

DROP TABLE IF EXISTS `access_log`;
CREATE TABLE `access_log` (
  `id` char(19) default NULL,
  `agent` varchar(255) default NULL,
  `bytes_sent` int(10) unsigned default NULL,
  `child_pid` smallint(5) unsigned default NULL,
  `cookie` varchar(255) default NULL,
  `machine_id` varchar(25) default NULL,
  `request_file` varchar(255) default NULL,
  `referer` varchar(255) default NULL,
  `remote_host` varchar(50) default NULL,
  `remote_logname` varchar(50) default NULL,
  `remote_user` varchar(50) default NULL,
  `request_duration` smallint(5) unsigned default NULL,
  `request_line` varchar(255) default NULL,
  `request_method` varchar(10) default NULL,
  `request_protocol` varchar(10) default NULL,
  `request_time` char(28) default NULL,
  `request_uri` varchar(255) default NULL,
  `request_args` varchar(255) default NULL,
  `server_port` smallint(5) unsigned default NULL,
  `ssl_cipher` varchar(25) default NULL,
  `ssl_keysize` smallint(5) unsigned default NULL,
  `ssl_maxkeysize` smallint(5) unsigned default NULL,
  `status` smallint(5) unsigned default NULL,
  `time_stamp` int(10) unsigned default NULL,
  `virtual_host` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

--
-- Table structure for table `cookies`
--

DROP TABLE IF EXISTS `cookies`;
CREATE TABLE `cookies` (
  `id` char(19) default NULL,
  `item` varchar(80) default NULL,
  `val` varchar(80) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

--
-- Table structure for table `headers_in`
--

DROP TABLE IF EXISTS `headers_in`;
CREATE TABLE `headers_in` (
  `id` char(19) default NULL,
  `item` varchar(80) default NULL,
  `val` varchar(80) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

--
-- Table structure for table `headers_out`
--

DROP TABLE IF EXISTS `headers_out`;
CREATE TABLE `headers_out` (
  `id` char(19) default NULL,
  `item` varchar(80) default NULL,
  `val` varchar(80) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
  `id` char(19) default NULL,
  `item` varchar(80) default NULL,
  `val` varchar(80) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;

--
-- Dumping routines for database 'wwwlog'
--
DELIMITER ;;
/*!50003 DROP FUNCTION IF EXISTS `f_AverageBytesPerHost` */;;
/*!50003 SET SESSION SQL_MODE=""*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`evolution`*/ /*!50003 FUNCTION `f_AverageBytesPerHost`() RETURNS decimal(10,0)
    READS SQL DATA
BEGIN
  DECLARE bytes DECIMAL;

  SELECT ROUND((f_TotalOutboundBytes() / f_UniqueHostCount()), 2)
    INTO bytes;

  RETURN bytes;
END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP FUNCTION IF EXISTS `f_FormatBytes` */;;
/*!50003 SET SESSION SQL_MODE=""*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`evolution`*/ /*!50003 FUNCTION `f_FormatBytes`(bytes INT) RETURNS decimal(16,2)
    NO SQL
BEGIN
     DECLARE unit VARCHAR(4);
     DECLARE newBytes DECIMAL(16,2);

     IF bytes < 1024
     THEN
         SET unit = "bytes";
         SET newBytes = bytes;
     ELSEIF bytes < (1024 * 1024)
     THEN
         SET unit = "kB";
         SET newBytes = (bytes / 1024);
     ELSEIF bytes < (1024 * 1024 * 1024)
     THEN
         SET unit = "mB";
         SET newBytes = (bytes / 1024 / 1024);
     ELSEIF bytes < (1024 * 1024 * 1024 * 1024)
     THEN
         SET unit = "gB";
         SET newBytes = (bytes / 1024 / 1024 / 1024);
     ELSE
         SET newBytes = 0;
         SET unit = "unknown";
     END IF;

     RETURN CONCAT(ROUND(newBytes, 2), CONCAT(" ", unit));
END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP FUNCTION IF EXISTS `f_RequestCount` */;;
/*!50003 SET SESSION SQL_MODE=""*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`evolution`*/ /*!50003 FUNCTION `f_RequestCount`() RETURNS int(11)
    READS SQL DATA
BEGIN
  DECLARE cnt INT;


  SELECT
        COUNT(*)
        INTO cnt
  FROM
      access_log;

  RETURN cnt;
END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP FUNCTION IF EXISTS `f_TotalOutboundBytes` */;;
/*!50003 SET SESSION SQL_MODE=""*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`evolution`*/ /*!50003 FUNCTION `f_TotalOutboundBytes`() RETURNS int(11)
    READS SQL DATA
BEGIN
  DECLARE byteCount INT;

  SELECT SUM(bytes_sent) INTO byteCount FROM access_log;

  RETURN byteCount;
END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
/*!50003 DROP FUNCTION IF EXISTS `f_UniqueHostCount` */;;
/*!50003 SET SESSION SQL_MODE=""*/;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`evolution`*/ /*!50003 FUNCTION `f_UniqueHostCount`() RETURNS int(11)
    READS SQL DATA
BEGIN
  DECLARE hostCount INT;

  SELECT COUNT(DISTINCT remote_host) AS "host_count" INTO hostCount FROM access_log;

  RETURN hostCount;
END */;;
/*!50003 SET SESSION SQL_MODE=@OLD_SQL_MODE*/;;
DELIMITER ;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2006-10-23 15:20:02