-- phpMyAdmin SQL Dump
-- version 3.3.7deb5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 12, 2011 at 07:29 PM
-- Server version: 5.1.49
-- PHP Version: 5.3.3-7+squeeze1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `records`
--

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

--
-- Table structure for table `active_records`
--

CREATE TABLE IF NOT EXISTS `active_records` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `owner` CHAR(16) NOT NULL COMMENT 'Panel username for the owner panel.',
  `owner_password` text NOT NULL,
  `port` int(11) NOT NULL,
  `address` CHAR(50) NOT NULL,
  `extention` text NOT NULL,
  `users` int(11) NOT NULL,
  `SPACE` int(11) NOT NULL,
  `email` text NOT NULL,
  `contact` text,
  `contact_type` text,
  `order_id` text,
  `signup_date` DATE NOT NULL,
  `last_payment_date` DATE NOT NULL,
  `payment_method` text NOT NULL,
  `payment_contact` text NOT NULL,
  `months_left` int(11) NOT NULL,
  `months_bought` int(11) NOT NULL,
  `months_reward_left` int(11) NOT NULL,
  `months_rewarded` int(11) NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `owner` (`owner`),
  UNIQUE KEY `address` (`address`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `inactive_records`
--

CREATE TABLE IF NOT EXISTS `inactive_records` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `owner` text NOT NULL,
  `owner_password` text NOT NULL,
  `port` int(11) NOT NULL,
  `address` text NOT NULL,
  `extention` text NOT NULL,
  `users` int(11) NOT NULL,
  `SPACE` int(11) NOT NULL,
  `email` text NOT NULL,
  `contact` text,
  `contact_type` text,
  `order_id` text,
  `signup_date` DATE NOT NULL,
  `payment_method` text NOT NULL,
  `payment_contact` text NOT NULL,
  `months_left` int(11) NOT NULL,
  `months_bought` int(11) NOT NULL,
  `months_reward_left` int(11) NOT NULL,
  `months_rewarded` int(11) NOT NULL,
  `ip` text NOT NULL,
  `suspension_date` DATE NOT NULL,
  `reasoning` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `ips`
--

CREATE TABLE IF NOT EXISTS `ips` (
  `IP` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `order_attempts`
--

CREATE TABLE IF NOT EXISTS `order_attempts` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `owner` text NOT NULL,
  `owner_password` text NOT NULL,
  `port` int(11) NOT NULL,
  `address` text NOT NULL,
  `extention` text NOT NULL,
  `users` int(11) NOT NULL,
  `SPACE` int(11) NOT NULL,
  `email` text NOT NULL,
  `contact` text,
  `contact_type` text,
  `order_id` text,
  `signup_date` DATE NOT NULL,
  `payment_method` text NOT NULL,
  `months_left` int(11) NOT NULL,
  `months_bought` int(11) NOT NULL,
  `referral` text NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `username` CHAR(16) NOT NULL,
  `password` text NOT NULL,
  `address` CHAR(50) NOT NULL,
  `TYPE` text NOT NULL,
  PRIMARY KEY (`username`),
  KEY `address` (`address`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;