-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 22, 2008 at 09:42 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `redirect_redir`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Administrative Password' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES(1, 'admin', 'password');

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

--
-- Table structure for table `campaigns`
--

CREATE TABLE `campaigns` (
  `id` int(5) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `destination` varchar(255) NOT NULL default '',
  `cloak` enum('yes','no') NOT NULL default 'yes',
  `clicks` int(5) NOT NULL default '0',
  `squeeze` varchar(250) NOT NULL default 'default',
  PRIMARY KEY  (`id`),
  KEY `squeeze` (`squeeze`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Campaign Table - Interact with Link Tracking & Redir Script' AUTO_INCREMENT=13 ;

--
-- Dumping data for table `campaigns`
--

INSERT INTO `campaigns` VALUES(12, 'testcampaign', 'http://www.yahoo.com', 'no', 1, '');
INSERT INTO `campaigns` VALUES(11, 'yahoo', 'http://yahoo.com', 'no', 1, '');
INSERT INTO `campaigns` VALUES(10, 'tester', 'http://www.4minutemoney.com', 'no', 0, '');
INSERT INTO `campaigns` VALUES(9, '4minutemm', 'http://opoffline.4minutemm.hop.clickbank.net', 'no', 2, '');

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

--
-- Table structure for table `ipaddresses`
--

CREATE TABLE `ipaddresses` (
  `vid` int(11) NOT NULL auto_increment,
  `campaign` varchar(255) NOT NULL default '',
  `ipaddress` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`vid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='IP ADDRESS TABLE FOR UNIQUE IP ID' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `ipaddresses`
--

INSERT INTO `ipaddresses` VALUES(1, '4minutemm', '216.67.6.62');