-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 21, 2008 at 01:35 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `proxy`
--

-- --------------------------------------------------------

--
-- Table structure for table `proxy`
--

CREATE TABLE IF NOT EXISTS `proxy` (
  `id` bigint(20) NOT NULL auto_increment,
  `ip` varchar(35) NOT NULL,
  `port` int(11) NOT NULL,
  `out_ip` varchar(20) NOT NULL,
  `entry_time` bigint(20) NOT NULL,
  `last_found` bigint(20) NOT NULL,
  `source` varchar(20) NOT NULL,
  `last_check` bigint(20) default NULL,
  `last_up` bigint(20) default NULL,
  `lock` bigint(20) default NULL,
  `alive` tinyint(1) default NULL,
  `type` set('anonym','transparent','elite') default NULL,
  `response_time` float default NULL,
  `total_response_time` double NOT NULL,
  `country` varchar(3) default NULL,
  `irc` bigint(20) NOT NULL,
  `good_tests` int(11) NOT NULL,
  `bad_tests` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `unq_proxy` (`ip`,`port`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;