-- phpMyAdmin SQL Dump -- version 2.6.1-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 08, 2005 at 12:27 PM -- Server version: 4.1.10 -- PHP Version: 5.0.4 -- -- Database: `host` -- -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_article` -- -- -------------------------------------------------------- -- -- Table structure for table `hsl_automatic` -- CREATE TABLE `hsl_automatic` ( `name` varchar(255) NOT NULL default '', `status` int(1) unsigned NOT NULL default '0' ); -- -- Dumping data for table `hsl_automatic` -- INSERT INTO `hsl_automatic` VALUES ('plan', 1); INSERT INTO `hsl_automatic` VALUES ('review', 0); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_category` -- INSERT INTO `hsl_category` VALUES ('unix-linux', 'Unix / Linux'); INSERT INTO `hsl_category` VALUES ('budget', 'Budget'); INSERT INTO `hsl_category` VALUES ('windows', 'Windows'); INSERT INTO `hsl_category` VALUES ('asp-hosting', 'ASP Hosting'); INSERT INTO `hsl_category` VALUES ('php-hosting', 'PHP Hosting'); INSERT INTO `hsl_category` VALUES ('managed-servers', 'Managed Servers'); INSERT INTO `hsl_category` VALUES ('ecommerce', 'eCommerce'); INSERT INTO `hsl_category` VALUES ('reseller', 'Reseller'); INSERT INTO `hsl_category` VALUES ('dedicated-servers', 'Dedicated Servers'); INSERT INTO `hsl_category` VALUES ('colocation', 'Colocation'); INSERT INTO `hsl_category` VALUES ('coldfusion', 'ColdFusion'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_category_adv` -- INSERT INTO `hsl_category_adv` VALUES (2, 'tgneikfe kerngreg rewgjreg jerg rjgjreig reigrjeig jrig jreg je', 'jgirw gfrei reg rjg regeigreiwgregrpeg epw ipg heig repogro', 'http://www.jfiorgfreigfor.com', '2005-12-30', 'unix-linux'); INSERT INTO `hsl_category_adv` VALUES (3, 'fewfnjew jf nwefjew hjfiewjf nfowjeif', 'jfiwejfw jfoeiw iofjewf jeiw jwfi jfeif jeiwf jwiefwe', 'http://www.jfiewfew.com', '2005-10-01', 'asp-hosting'); INSERT INTO `hsl_category_adv` VALUES (4, 'fewfnjew jf nwefjew hjfiewjf nfowjeif', 'jfiwejfw jfoeiw iofjewf jeiw jwfi jfeif jeiwf jwiefwe', 'http://www.jfiewfew.com', '2005-10-01', 'managed-servers'); INSERT INTO `hsl_category_adv` VALUES (5, 'fewfnjew jf nwefjew hjfiewjf nfowjeif', 'jfiwejfw jfoeiw iofjewf jeiw jwfi jfeif jeiwf jwiefwe', 'http://www.jfiewfew.com', '2005-10-01', 'php-hosting'); INSERT INTO `hsl_category_adv` VALUES (6, 'ngrjegjre oigr igjrei jreg jreigjer', 'gpoetrewf jer grjg reg jrgregjjergporekg troper', 'http://www.jfiewfew.com', '2005-10-01', 'php-hosting'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_config` -- INSERT INTO `hsl_config` VALUES ('WebInterfacePassword', 'test'); INSERT INTO `hsl_config` VALUES ('ReceiveAuthorize', '0'); INSERT INTO `hsl_config` VALUES ('AuthorizeLogin', 'ucc621'); INSERT INTO `hsl_config` VALUES ('AuthorizeTransactionKey', 't2uIUg5pF0siHGag'); INSERT INTO `hsl_config` VALUES ('ReceiveIntGold', '0'); INSERT INTO `hsl_config` VALUES ('IntGoldAccount', '206149'); INSERT INTO `hsl_config` VALUES ('ReceiveStormPay', '0'); INSERT INTO `hsl_config` VALUES ('StormPayAccount', 'physician@bigmir.net'); INSERT INTO `hsl_config` VALUES ('ReceivePayPal', '1'); INSERT INTO `hsl_config` VALUES ('PayPalAccount', 'payments@dailyhosting.net'); INSERT INTO `hsl_config` VALUES ('TestMode', '1'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_directory` -- INSERT INTO `hsl_directory` VALUES ('test1', 'Articles 1'); INSERT INTO `hsl_directory` VALUES ('test2', 'Articles 2'); INSERT INTO `hsl_directory` VALUES ('test32', 'Articles 33'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_host` -- INSERT INTO `hsl_host` VALUES (1, 'test', '123456', 'mezil@movi.com.ar', 'TEST', 'TEST 2011', 'BS AS', 'CAPITAL', 'Argentina', '1254', '11111111', 'www.test.com', '1999-01-01', '0000-00-00 00:00:00', 0, '0000-00-00', 0); INSERT INTO `hsl_host` VALUES (2, 'test2', 'test', 'test@test.com', 'Test', 'ertsertse', 'hljkhljkh', 'ljkhljhl', 'Albania', '1233', '123123123123', 'e-land.com.ua', '1993-01-01', '0000-00-00 00:00:00', 0, '0000-00-00', 0); INSERT INTO `hsl_host` VALUES (3, 'mezil', '12345678', 'info@mezil.com', 'test1', 'test 5241', 'test', 'testa', 'Argentina', '5241', '52122555', 'www.test1.com', '2005-02-01', '0000-00-00 00:00:00', 0, '0000-00-00', 0); INSERT INTO `hsl_host` VALUES (4, 'hosting', 'hostingsite', 'xeo.interactive@gmail.com', 'hosting', 'hosting', 'hosting', 'hosting', 'Malaysia', '0000', '000000000', 'wewaew.com', '2005-06-01', '0000-00-00 00:00:00', 2, '2005-12-30', 0); -- -------------------------------------------------------- -- -- Table structure for table `hsl_invite` -- CREATE TABLE `hsl_invite` ( `host` varchar(255) NOT NULL default '', UNIQUE KEY `host` (`host`) ); -- -- Dumping data for table `hsl_invite` -- -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_order` -- INSERT INTO `hsl_order` VALUES (2, 'hosting', 6, 'Processing', 'Not finished by user', 'intgold', '2005-02-28 13:38:45'); -- -------------------------------------------------------- -- -- 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', `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`) ); -- -- Dumping data for table `hsl_plan` -- INSERT INTO `hsl_plan` VALUES (1, 1, 'Plan START', 2.00, 10.00, 50, 1000, 0, 'http://www.test.com', 1, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 1, 'unix-linux', 0); INSERT INTO `hsl_plan` VALUES (2, 1, 'Plan PLUS', 5.00, 25.00, 100, 2000, 1, 'http://www.test.com', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'unix-linux', 1); INSERT INTO `hsl_plan` VALUES (3, 1, 'Plan ADVANCED', 5.00, 35.00, 200, 5000, 1, 'http://www.test.com', 1, 1, 1, 1, 1, 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 'windows', 1); INSERT INTO `hsl_plan` VALUES (4, 4, 'hostingsite', 10.00, 120.00, 1000, 10000, 0, 'http://www.hostingsite.com', 0, 0, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 'unix-linux', 1); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_price` -- INSERT INTO `hsl_price` VALUES (1, 1, 'Premium', 1, 5.00, 1); INSERT INTO `hsl_price` VALUES (2, 1, 'Premium', 3, 15.00, 1); INSERT INTO `hsl_price` VALUES (3, 1, 'Premium', 12, 30.00, 1); INSERT INTO `hsl_price` VALUES (4, 2, 'Executive', 1, 10.00, 1); INSERT INTO `hsl_price` VALUES (5, 2, 'Executive', 3, 20.00, 1); INSERT INTO `hsl_price` VALUES (6, 2, 'Executive', 12, 30.00, 1); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_review` -- INSERT INTO `hsl_review` VALUES (1, 'TEST', 'http://www.', '', '', 10, 10, 6, 1, 'great service', '2005-01-08', 1, '200.55.110.32'); INSERT INTO `hsl_review` VALUES (2, 'hosting', 'http://www.dwdaw.com', 'fwaefads', 'hfifd@jifpodaf.jpoarjfa', 10, 10, 10, 10, 'gjuirwjroeigfr', '2005-02-28', 1, '219.92.240.60'); INSERT INTO `hsl_review` VALUES (3, 'TEST', 'http://www.lawg.com', 'Christopher Collings', 'webmaster@dailyhosting.net', 10, 10, 10, 10, 'Excellent Host', '2005-03-05', 1, '217.43.160.151'); INSERT INTO `hsl_review` VALUES (4, 'hosting', 'http://www.akiwgakiw.com', 'Chris Collings', 'webmaster@dailyhosting.net', 10, 9, 8, 7, 'awirgaeoIEUAWIE', '2005-03-05', 1, '217.43.160.151'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_service` -- INSERT INTO `hsl_service` VALUES ('videostreaming', 'Video Streaming'); INSERT INTO `hsl_service` VALUES ('audiostreaming', 'Audio Streaming'); INSERT INTO `hsl_service` VALUES ('accountcontrolpanel', 'Control Panel'); INSERT INTO `hsl_service` VALUES ('shellaccess', 'Shell Access'); INSERT INTO `hsl_service` VALUES ('adultsitespermitted', 'Adult Sites Permitted'); INSERT INTO `hsl_service` VALUES ('php', 'PHP'); INSERT INTO `hsl_service` VALUES ('cgipermitted', 'CGI Permitted'); INSERT INTO `hsl_service` VALUES ('unlimitedftp', 'Unlimited FTP Access'); INSERT INTO `hsl_service` VALUES ('domainregistration', 'Domain Registration'); INSERT INTO `hsl_service` VALUES ('asp', 'Active Server Pages'); INSERT INTO `hsl_service` VALUES ('perl', 'Perl'); INSERT INTO `hsl_service` VALUES ('jsp', 'Java Server Pages'); INSERT INTO `hsl_service` VALUES ('telephonesupport', 'Telephone Support'); INSERT INTO `hsl_service` VALUES ('msfrontpage', 'MS FrontPage Support'); INSERT INTO `hsl_service` VALUES ('resellerplan', 'Reseller Plan(s) Available'); INSERT INTO `hsl_service` VALUES ('webstatistics', 'Web Usage Statistics'); INSERT INTO `hsl_service` VALUES ('secureserver', 'Secure Server Available'); INSERT INTO `hsl_service` VALUES ('ssi', 'Server Side Includes'); INSERT INTO `hsl_service` VALUES ('msql', 'MySQL'); INSERT INTO `hsl_service` VALUES ('mssql', 'Microsoft SQL'); INSERT INTO `hsl_service` VALUES ('coldfusion', 'ColdFusion'); INSERT INTO `hsl_service` VALUES ('test', 'Testing'); INSERT INTO `hsl_service` VALUES ('uniqueipaddress', 'Unique IP Address'); -- -------------------------------------------------------- -- -- 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`) ); -- -- Dumping data for table `hsl_special` -- INSERT INTO `hsl_special` VALUES (5, '50% off plans', '2005-03-15');