-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 13, 2005 at 12:04 AM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
-- 
-- Database: `karaokay_zip`
-- 

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

-- 
-- Table structure for table `hsl_article`
-- 

CREATE TABLE `hsl_article` (
  `aid` int(11) unsigned NOT NULL auto_increment,
  `directory` varchar(255) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `short` text NOT NULL,
  `link` varchar(255) NOT NULL default '',
  `postdate` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`aid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `hsl_automatic`
-- 

CREATE TABLE `hsl_automatic` (
  `name` varchar(255) NOT NULL default '',
  `status` int(1) unsigned NOT NULL default '0'
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_category`
-- 

CREATE TABLE `hsl_category` (
  `uin` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  UNIQUE KEY `uin_index` (`uin`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_category_adv`
-- 

CREATE TABLE `hsl_category_adv` (
  `category_adv_id` int(11) unsigned NOT NULL auto_increment,
  `short_text` varchar(255) NOT NULL default '',
  `full_text` text NOT NULL,
  `url` varchar(255) NOT NULL default '',
  `expiry_date` date NOT NULL default '0000-00-00',
  `category` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`category_adv_id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

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

-- 
-- Table structure for table `hsl_config`
-- 

CREATE TABLE `hsl_config` (
  `name` varchar(255) NOT NULL default '',
  `value` varchar(255) NOT NULL default '',
  UNIQUE KEY `name` (`name`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_directory`
-- 

CREATE TABLE `hsl_directory` (
  `uin` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  UNIQUE KEY `uin_index` (`uin`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_host`
-- 

CREATE TABLE `hsl_host` (
  `hid` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `pwd` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state_province` varchar(255) NOT NULL default '',
  `country` varchar(255) NOT NULL default '',
  `zip_postal` varchar(255) NOT NULL default '',
  `phone` varchar(255) NOT NULL default '',
  `company_url` varchar(255) NOT NULL default '',
  `established` date NOT NULL default '0000-00-00',
  `registered` datetime NOT NULL default '0000-00-00 00:00:00',
  `account_type` smallint(1) unsigned NOT NULL default '0',
  `expired` date NOT NULL default '0000-00-00',
  `currencie` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`hid`),
  UNIQUE KEY `company_url` (`company_url`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

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

-- 
-- Table structure for table `hsl_invite`
-- 

CREATE TABLE `hsl_invite` (
  `host` varchar(255) NOT NULL default '',
  UNIQUE KEY `host` (`host`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_order`
-- 

CREATE TABLE `hsl_order` (
  `order_id` int(11) unsigned NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `price_id` int(11) NOT NULL default '0',
  `status` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `gateway` varchar(255) NOT NULL default '',
  `postdate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`order_id`)
) TYPE=MyISAM AUTO_INCREMENT=29 ;

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

-- 
-- Table structure for table `hsl_plan`
-- 

CREATE TABLE `hsl_plan` (
  `pid` int(11) unsigned NOT NULL auto_increment,
  `hid` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `monthly_price` float(5,2) unsigned NOT NULL default '0.00',
  `yearly_price` float(5,2) unsigned NOT NULL default '0.00',
  `two_year_price` float(5,2) unsigned NOT NULL default '0.00',
  `three_year_price` float(5,2) unsigned NOT NULL default '0.00',
  `webspace` int(10) unsigned NOT NULL default '0',
  `datatransfer` int(10) unsigned NOT NULL default '0',
  `os` int(1) unsigned NOT NULL default '0',
  `purchaseurl` varchar(255) NOT NULL default '',
  `service_videostreaming` int(1) unsigned NOT NULL default '0',
  `service_audiostreaming` int(1) unsigned NOT NULL default '0',
  `service_accountcontrolpanel` int(1) unsigned NOT NULL default '0',
  `service_shellaccess` int(1) unsigned NOT NULL default '0',
  `service_adultsitespermitted` int(1) unsigned NOT NULL default '0',
  `service_php` int(1) unsigned NOT NULL default '0',
  `service_cgipermitted` int(1) unsigned NOT NULL default '0',
  `service_unlimitedftp` int(1) unsigned NOT NULL default '0',
  `service_domainregistration` int(1) unsigned NOT NULL default '0',
  `service_asp` int(1) unsigned NOT NULL default '0',
  `service_perl` int(1) unsigned NOT NULL default '0',
  `service_jsp` int(1) unsigned NOT NULL default '0',
  `service_telephonesupport` int(1) unsigned NOT NULL default '0',
  `service_msfrontpage` int(1) unsigned NOT NULL default '0',
  `service_resellerplan` int(1) unsigned NOT NULL default '0',
  `service_webstatistics` int(1) unsigned NOT NULL default '0',
  `service_secureserver` int(1) unsigned NOT NULL default '0',
  `service_ssi` int(1) unsigned NOT NULL default '0',
  `service_msql` int(1) unsigned NOT NULL default '0',
  `service_mssql` int(1) unsigned NOT NULL default '0',
  `service_coldfusion` int(1) unsigned NOT NULL default '0',
  `service_uniqueipaddress` int(1) unsigned NOT NULL default '0',
  `status` int(1) unsigned NOT NULL default '0',
  `category` varchar(255) NOT NULL default '',
  `service_test` int(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`pid`),
  FULLTEXT KEY `name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

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

-- 
-- Table structure for table `hsl_price`
-- 

CREATE TABLE `hsl_price` (
  `price_id` int(11) unsigned NOT NULL auto_increment,
  `account_type` smallint(1) unsigned NOT NULL default '0',
  `account_name` varchar(255) NOT NULL default '',
  `period` int(2) unsigned NOT NULL default '0',
  `price` float(3,2) NOT NULL default '0.00',
  `enabled` smallint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`price_id`),
  UNIQUE KEY `account_type` (`account_type`,`period`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

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

-- 
-- Table structure for table `hsl_review`
-- 

CREATE TABLE `hsl_review` (
  `rid` int(11) unsigned NOT NULL auto_increment,
  `company` varchar(255) NOT NULL default '',
  `domain` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `speed` int(2) unsigned NOT NULL default '0',
  `reliability` int(2) unsigned NOT NULL default '0',
  `support` int(2) unsigned NOT NULL default '0',
  `price` int(2) unsigned NOT NULL default '0',
  `review` text NOT NULL,
  `postdate` date NOT NULL default '0000-00-00',
  `status` int(1) unsigned NOT NULL default '0',
  `ip` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`rid`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

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

-- 
-- Table structure for table `hsl_service`
-- 

CREATE TABLE `hsl_service` (
  `sid` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  UNIQUE KEY `sid` (`sid`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `hsl_special`
-- 

CREATE TABLE `hsl_special` (
  `hid` int(11) unsigned NOT NULL default '0',
  `text` text NOT NULL,
  `expire` date NOT NULL default '0000-00-00',
  UNIQUE KEY `hid` (`hid`)
) TYPE=MyISAM;