phpMyAdmin SQL Dump
-- version 2.8.0.2
--
phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 13, 2006 at 01:08 AM
-- Server version: 4.1.19
-- PHP Version: 4.4.2
--
-- Database: `vizra_vzr20`
--
-- --------------------------------------------------------
--
-- Table structure for table `cust_tab`
--
DROP TABLE IF EXISTS `cust_tab`;
CREATE TABLE `cust_tab` (
`id` int(11) NOT NULL auto_increment,
`cppassword` varchar(100) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`company` varchar(80) NOT NULL default '',
`address` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`zip` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`phone` varchar(30) NOT NULL default '',
`sign_date` datetime NOT NULL default '0000-00-00 00:00:00',
`sign_ip` varchar(80) NOT NULL default '',
`last_login_date` datetime NOT NULL default '0000-00-00 00:00:00',
`last_login_ip` varchar(80) NOT NULL default '',
`cust_status` varchar(255) NOT NULL default '',
`remote_ip` varchar(250) NOT NULL default '',
`referrer` varchar(80) NOT NULL default '',
`client_notes` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `domains`
--
DROP TABLE IF EXISTS `domains`;
CREATE TABLE `domains` (
`domID` int(11) NOT NULL auto_increment,
`clientID` int(11) NOT NULL default '0',
`domain` varchar(100) NOT NULL default '',
`start` date NOT NULL default '0000-00-00',
`cycle` int(11) NOT NULL default '0',
`status` enum('active','disabled','pending') NOT NULL default 'pending',
UNIQUE KEY `domID` (`domID`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `invs`
--
DROP TABLE IF EXISTS `invs`;
CREATE TABLE `invs` (
`invID` int(11) NOT NULL auto_increment,
`pckID` int(11) NOT NULL default '0',
`clientID` int(11) NOT NULL default '0',
`serverID` int(11) NOT NULL default '0',
`type` enum('hosting','domain','service') NOT NULL default 'hosting',
`payed` date NOT NULL default '0000-00-00',
`due` date NOT NULL default '0000-00-00',
`paymentType` enum('USD','YTL') NOT NULL default 'USD',
`amount` decimal(6,2) NOT NULL default '0.00',
`usd2ytl` decimal(6,2) NOT NULL default '0.00',
`YTL` decimal(6,2) NOT NULL default '0.00',
`cycle` smallint(6) NOT NULL default '0',
`status` enum('0','1') NOT NULL default '0',
`emailsent` tinyint(4) NOT NULL default '0',
`description` varchar(100) NOT NULL default '',
`notes` text NOT NULL,
PRIMARY KEY (`invID`)
) ENGINE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `packages`
--
DROP TABLE IF EXISTS `packages`;
CREATE TABLE `packages` (
`pckID` int(11) NOT NULL auto_increment,
`clientID` int(11) NOT NULL default '0',
`planID` varchar(20) NOT NULL default '',
`serverID` int(11) NOT NULL default '0',
`hostingType` enum('web','radio','dedicated','vps') NOT NULL default 'web',
`username` varchar(16) NOT NULL default '',
`password` varchar(16) NOT NULL default '',
`plan` varchar(255) NOT NULL default '',
`domain` varchar(255) NOT NULL default '',
`serversil` varchar(255) NOT NULL default '',
`os` varchar(50) NOT NULL default '',
`reseller` enum('0','1') NOT NULL default '0',
`webspace` varchar(15) NOT NULL default '',
`traffic` varchar(10) NOT NULL default '',
`mysql` int(11) NOT NULL default '0',
`subdomain` int(11) NOT NULL default '0',
`pop3` int(11) NOT NULL default '0',
`website` int(11) NOT NULL default '0',
`freedomain` int(11) NOT NULL default '0',
`amount` decimal(6,2) NOT NULL default '0.00',
`paymentType` enum('USD','YTL') NOT NULL default 'USD',
`cycle` smallint(6) NOT NULL default '0',
`started` date NOT NULL default '0000-00-00',
`status` varchar(16) NOT NULL default '',
`notes` text NOT NULL,
PRIMARY KEY (`pckID`)
) ENGINE=MyISAM;
-- --------------------------------------------------------