-- phpMyAdmin SQL Dump -- version 2.8.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Sep 05, 2006 at 10:13 PM -- Server version: 4.0.27 -- PHP Version: 4.4.2 -- -- Database: `maxim_whmcs` -- -- -------------------------------------------------------- -- -- Table structure for table `tblproducts` -- CREATE TABLE `tblproducts` ( `id` int(10) unsigned zerofill NOT NULL auto_increment, `type` text NOT NULL, `gid` int(10) NOT NULL default '0', `name` text NOT NULL, `description` text NOT NULL, `hidden` text NOT NULL, `showdomainoptions` text NOT NULL, `welcomeemail` int(1) NOT NULL default '0', `stockcontrol` text NOT NULL, `qty` int(1) NOT NULL default '0', `proratabilling` text NOT NULL, `proratadate` int(2) NOT NULL default '0', `proratachargenextmonth` int(2) NOT NULL default '0', `quota` text NOT NULL, `ftpacc` text NOT NULL, `emailacc` text NOT NULL, `emaillists` text NOT NULL, `sqldbs` text NOT NULL, `subdomains` text NOT NULL, `parkdomains` text NOT NULL, `addondomains` text NOT NULL, `bandwidthlimit` text NOT NULL, `fpextensions` text NOT NULL, `shellaccess` text NOT NULL, `cgiaccess` text NOT NULL, `theme` text NOT NULL, `paytype` text NOT NULL, `msetupfee` decimal(10,2) NOT NULL default '0.00', `qsetupfee` decimal(10,2) NOT NULL default '0.00', `ssetupfee` decimal(10,2) NOT NULL default '0.00', `asetupfee` decimal(10,2) NOT NULL default '0.00', `monthly` decimal(10,2) NOT NULL default '0.00', `quarterly` decimal(10,2) NOT NULL default '0.00', `semiannual` decimal(10,2) NOT NULL default '0.00', `annual` decimal(10,2) NOT NULL default '0.00', `subdomain` text NOT NULL, `packagename` text NOT NULL, `autosetup` text NOT NULL, `servertype` text NOT NULL, `defaultserver` int(1) NOT NULL default '0', `freedomain` text NOT NULL, `freedomainpaymentterms` text NOT NULL, `freedomaintlds` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Dumping data for table `tblproducts` -- INSERT INTO `tblproducts` VALUES (0000000001, 'hostingaccount', 1, 'Starter Hosting Package', '', 'on', 'on', 2, '', 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '', 'MAXIM_STARTER', '', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000002, 'hostingaccount', 2, 'Basic Hosting Package', '', '', 'on', 1, '', 0, '', 0, 0, '500', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '6000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 12.50, 0.00, 75.00, 150.00, '', 'MAXIM_BASIC', 'payment', 'cpanel', 3, 'on', 'annually,', '.com,.net,.org,'); INSERT INTO `tblproducts` VALUES (0000000003, 'hostingaccount', 2, 'Advanced Hosting Package', '', '', 'on', 2, '', 0, '', 0, 0, '1200', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '15000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 20.95, 59.70, 113.13, 201.12, '', 'MAXIM_ADVANCED', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000004, 'hostingaccount', 2, 'Professional Hosting Package', '', '', 'on', 2, '', 0, '', 0, 0, '1600', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '25000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 22.95, 65.40, 123.93, 220.32, '', 'MAXIM_SPECIAL', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000005, 'hostingaccount', 2, 'Special Hosting Package', '', 'on', 'on', 2, '', 0, '', 0, 0, '2000', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '36000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 24.95, 71.10, 134.73, 239.52, '', 'MAXIM_PRO', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000006, 'reselleraccount', 3, 'Standard Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '4000', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '40000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 29.95, 85.35, 161.73, 287.52, '', 'MAXIM_RESSTANDARD', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000007, 'reselleraccount', 3, 'Intermediate Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '7500', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '60000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 39.95, 113.85, 215.73, 383.52, '', 'MAXIM_RESINTERMEDIATE', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000008, 'reselleraccount', 3, 'Advanced Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '10000', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '100000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 49.95, 142.35, 269.73, 479.52, '', 'MAXIM_RESADVANCED', 'payment', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000009, 'hostingaccount', 4, 'Server Management', '', '', 'on', 19, '', 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 140.00, 0.00, 0.00, 0.00, '', '', '', 'cpanel', 0, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000010, 'reselleraccount', 5, 'Standard Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '4000', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '40000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 23.00, 0.00, 126.00, 240.00, '', 'MAXIM_RESSTANDARD', 'payment', 'cpanel', 3, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000011, 'reselleraccount', 5, 'Intermediate Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '7500', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '60000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 33.00, 0.00, 188.00, 356.00, '', 'MAXIM_RESINTERMEDIATE', 'payment', 'cpanel', 3, '', '', ''); INSERT INTO `tblproducts` VALUES (0000000012, 'reselleraccount', 5, 'Advanced Reseller Package', '', '', 'on', 5, '', 0, '', 0, 0, '10000', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', 'unlimited', '100000', '', 'on', 'on', '', 'recurring', 0.00, 0.00, 0.00, 0.00, 53.00, 0.00, 302.00, 572.00, '', 'MAXIM_RESADVANCED', 'payment', 'cpanel', 3, '', '', '');