-- Generation Time: Dec 31, 2007 at 03:52 PM
-- Server version: 5.0.27
-- PHP Version: 5.1.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Table structure for table `accounts`
--

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL auto_increment,
  `advertiser` tinyint(1) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `homedir` varchar(255) NOT NULL default '',
  `firstname` varchar(100) NOT NULL default '',
  `lastname` varchar(100) NOT NULL default '',
  `gender` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `userlevel` varchar(100) NOT NULL default '',
  `address` varchar(100) NOT NULL default '',
  `address2` varchar(100) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `state` varchar(100) NOT NULL default '',
  `country` varchar(100) NOT NULL default '',
  `zip` varchar(100) NOT NULL default '',
  `phone` varchar(100) NOT NULL default '',
  `status` int(2) default '1',
  `notes` blob NOT NULL,
  `secret_question` varchar(100) NOT NULL default '',
  `secret_answer` varchar(100) NOT NULL default '',
  `reset` tinyint(1) NOT NULL default '0',
  `last_ip` varchar(100) NOT NULL default '',
  `last_datetime` varchar(100) NOT NULL default '',
  `active_ip` varchar(100) NOT NULL default '',
  `active_datetime` varchar(100) NOT NULL default '',
  `custom_package` tinyint(1) NOT NULL default '0',
  `package` int(11) NOT NULL default '0',
  `theme` varchar(100) default '',
  `date_format` varchar(10) NOT NULL default '',
  `time_format` varchar(10) NOT NULL default '',
  `language` varchar(100) default '',
  `usefirst` tinyint(1) NOT NULL default '0',
  `personality` varchar(100) NOT NULL default '',
  `paypal` varchar(200) NOT NULL default '',
  `logintries` tinyint(2) NOT NULL default '0',
  `totalfiles` int(11) NOT NULL default '0',
  `totaldirs` int(11) NOT NULL default '0',
  `diskusage` varchar(11) NOT NULL default '0',
  `webaddy` text NOT NULL,
  `addtoapache` varchar(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `Unique` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `accounts`
--

INSERT INTO `accounts` (`id`, `advertiser`, `username`, `password`, `homedir`, `firstname`, `lastname`, `gender`, `email`, `userlevel`, `address`, `address2`, `city`, `state`, `country`, `zip`, `phone`, `status`, `notes`, `secret_question`, `secret_answer`, `reset`, `last_ip`, `last_datetime`, `active_ip`, `active_datetime`, `custom_package`, `package`, `theme`, `date_format`, `time_format`, `language`, `usefirst`, `personality`, `paypal`, `logintries`, `totalfiles`, `totaldirs`, `diskusage`, `webaddy`, `addtoapache`) VALUES
(1, 0, 'demo', 'fe01ce2a7fbac8fafaed7c982a04e229', '/dev/null', 'Demo', 'User', 'M', 'demo@rapidcp.com', 'User', '123 Demo Stret', '', 'Someville', 'CA', 'United States', '12345', '555-555-5555', 1, '', '', 'd41d8cd98f00b204e9800998ecf8427e', 0, '24.222.205.80', '08/05/06 04:46 AM', '24.222.205.80', '08/05/06 03:08 PM', 0, 1, '', 'dd-mm-yyyy', '63', '', 0, '', '', 0, 2, 2, '0.00', 'http://demo.thezpanel.com', ''),
(2, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '/home', 'Meisam', 'Mulla', 'M', 'admin@yourcompany.com', 'Admin', '123 Your Street', '', 'Richmond', '', 'Canada', 'V7A 4', '1-555-861-7869', 1, '', 'you', 'ea3a1c0bae0f46511a587b192489088e', 0, '::ffff:71.115.84.100', '09/27/06 02:13 PM', '::ffff:71.115.84.100', '09/29/06 03:59 PM', 0, 1, '', '', '', '', 0, '', '', 0, 0, 0, '0', '', ''),

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

--
-- Table structure for table `accounts_ftp`
--

CREATE TABLE IF NOT EXISTS `accounts_ftp` (
  `login` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `path` varchar(255) NOT NULL,
  `owner` varchar(100) NOT NULL,
  `activated` tinyint(1) NOT NULL default '0',
  `fail_reason` varchar(200) default NULL,
  PRIMARY KEY  (`login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `apacheconf`
--

CREATE TABLE IF NOT EXISTS `apacheconf` (
  `key` varchar(100) NOT NULL default '',
  `value` varchar(100) NOT NULL default '',
  `conf` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apacheconf`
--

INSERT INTO `apacheconf` (`key`, `value`, `conf`) VALUES
('ServerTokens', 'OS', 'main.conf'),
('ServerRoot', '"/etc/httpd"', 'main.conf'),
('TimeOut', '300', 'main.conf'),
('KeepAlive', 'on', 'main.conf'),
('MaxKeepAliveRequests', '100', 'main.conf'),
('KeepAliveTimeout', '15', 'main.conf'),
('Listen', '*:80', 'main.conf'),
('ExtendedStatus', 'off', 'main.conf'),
('User', 'apache', 'main.conf'),
('Group', 'apache', 'main.conf'),
('ServerAdmin', 'support@zee-way.com', 'main.conf'),
('ServerName', 'zee-way.com', 'main.conf'),
('UseCanonicalName', 'on', 'main.conf'),
('DocumentRoot', '"/var/www/html"', 'main.conf'),
('DirectoryIndex', 'index.php index.html index.htm', 'main.conf'),
('AccessFileName', '.htaccess', 'main.conf'),
('TypesConfig', '"/var/www/html/zpanel/conf/conf.d/mime.types"', 'main.conf'),
('DefaultType', 'text/plain', 'main.conf'),
('HostNameLookups', 'off', 'main.conf'),
('EnableMMAP', 'off', 'main.conf'),
('EnableSendfile', 'off', 'main.conf'),
('ErrorLog', '"/var/www/html/zpanel/log/main.error.log"', 'main.conf'),
('LogLevel', 'warn', 'main.conf'),
('CustomLog', '/var/www/html/zpanel/log/main.access.log combined', 'main.conf'),
('ServerSignature', 'on', 'main.conf'),
('IndexOptions', 'FancyIndexing VersionSort NameWidth=*', 'main.conf'),
('DefaultLanguage', 'en', 'main.conf'),
('AddDefaultCharset', 'ISO-8859-1', 'main.conf'),
('NameVirtualHost', '*:80', 'main.conf'),
('CoreDumpDirectory', '"/etc/httpd"', 'main.conf');

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

--
-- Table structure for table `audits`
--

CREATE TABLE IF NOT EXISTS `audits` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `function` varchar(255) NOT NULL default '',
  `time` varchar(255) NOT NULL default '',
  `details` text NOT NULL,
  `optionj` int(1) NOT NULL default '2',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=472 ;


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

--
-- Table structure for table `billing`
--

CREATE TABLE IF NOT EXISTS `billing` (
  `id` int(11) NOT NULL auto_increment,
  `reseller` int(11) NOT NULL default '0',
  `customer` int(11) NOT NULL default '0',
  `date` date NOT NULL default '0000-00-00',
  `amount` mediumint(9) NOT NULL default '0',
  `method` varchar(100) NOT NULL default '',
  `debit` int(1) NOT NULL default '0',
  `package` int(11) NOT NULL default '0',
  `txn_id` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `billing`
--


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

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `reseller` int(11) NOT NULL default '0',
  `server_pop` varchar(100) default '',
  `server_smtp` varchar(100) default '',
  `admin` int(11) default '0',
  `company` varchar(100) default '',
  `motto` varchar(100) NOT NULL default 'Taking your hosting to the next level!',
  `support_link` varchar(100) default '',
  `support_email` varchar(100) default '',
  `email_admin` varchar(100) default '',
  `email_webmail` varchar(100) default '',
  `rootdir` varchar(100) default '',
  `broadcast` text,
  `domain` varchar(100) default '',
  `language` varchar(100) default 'english.php',
  `ftpserver` varchar(100) default 'ftp.zee-way.com',
  `template` varchar(100) default 'ZPanelV2',
  `date_format` varchar(10) NOT NULL default 'm-d-Y',
  `time_format` varchar(10) NOT NULL default 'h:i A',
  `paypalemail` varchar(100) default '',
  `webaddress` varchar(100) default '',
  `version` varchar(100) default '2.5',
  `ftpserver_type` varchar(100) NOT NULL default 'bpftp',
  `autoban` tinyint(1) NOT NULL default '0',
  `banthreshold` tinyint(2) NOT NULL default '10',
  `user_autoban` tinyint(1) NOT NULL default '1',
  `user_banthreshold` tinyint(2) NOT NULL default '3',
  `security` tinyint(1) NOT NULL default '2',
  `address1` varchar(255) NOT NULL default '',
  `address2` varchar(255) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(255) NOT NULL default '',
  `zipcode` varchar(255) NOT NULL default '',
  `country` varchar(255) NOT NULL default '',
  `support_phone` varchar(255) NOT NULL default '',
  `support_subject` varchar(255) NOT NULL default '',
  `loginimage` varchar(255) NOT NULL default '',
  `welcomeemail` text NOT NULL,
  `allowupgrade_downgrade` tinyint(1) NOT NULL default '0',
  `forgot_password` int(1) NOT NULL default '1',
  `forgot_password_txt` text NOT NULL,
  `enable_signups` int(1) NOT NULL default '1',
  `signup_notification` int(1) NOT NULL default '1',
  `signup_moderation` int(1) NOT NULL default '1',
  `moderation_email` int(2) NOT NULL default '1',
  `moderation_admin` int(2) NOT NULL default '1',
  `moderation_payment` int(2) NOT NULL default '1',
  `logdir` varchar(255) NOT NULL,
  PRIMARY KEY  (`reseller`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`reseller`, `server_pop`, `server_smtp`, `admin`, `company`, `motto`, `support_link`, `support_email`, `email_admin`, `email_webmail`, `rootdir`, `broadcast`, `domain`, `language`, `ftpserver`, `template`, `date_format`, `time_format`, `paypalemail`, `webaddress`, `version`, `ftpserver_type`, `autoban`, `banthreshold`, `user_autoban`, `user_banthreshold`, `security`, `address1`, `address2`, `city`, `state`, `zipcode`, `country`, `support_phone`, `support_subject`, `loginimage`, `welcomeemail`, `allowupgrade_downgrade`, `forgot_password`, `forgot_password_txt`, `enable_signups`, `signup_notification`, `signup_moderation`, `moderation_email`, `moderation_admin`, `moderation_payment`, `logdir`) VALUES
(0, 'mail.rapidcp.com', 'mail.rapidcp.com', 0, 'RapidCP', 'Taking your hosting to the next level!', 'mailto:support@rapidcp.com?subject=Online%20Help&body=Description%20here...', 'support@rapidcp.com', 'http://webmail.rapidcp.com', 'http://webmail.rapidcp.com', '/var/www/html/hosted', 'beta tack time!', 'rapidcp.com', 'english.php', 'ftp.rapidcp.com', 'zpanelv3', 'm-d-Y', 'h:i A', 'billing@rapidcp.com', 'http://demo.rapidcp.com:1818/', 'v3.0.0.23', 'bpftp', 0, 10, 1, 3, 2, '1313 Mocking Bird Lane', 'Suite 313', 'Vancouver', 'British Columbia', 'V7A 4V5', 'Canada', '410-555-5555', 'Support Request: %username%', 'Linux', 'Dear {firstname} {lastname},\r\n\r\nThank you for choosing {companyname} for your web hosting needs. We look forward to working with you to make sure you get the most of your account, and we wish you success with your online venture.\r\n\r\nYour account has been created. Below are the details of this creation:\r\n\r\nUsername: {username}\r\nPassword: {password}\r\n\r\nOur control panel is located at {rapidcpurl}. If you have any questions regarding your hosting account with us feel free to create a support ticket by clicking "New Ticket" under the Support section.\r\n\r\nThanks,\r\n{companyname}', 0, 1, '', 1, 1, 0, 0, 0, 0, '/var/www/RapidCP/logs');

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

--
-- Table structure for table `cron`
--

CREATE TABLE IF NOT EXISTS `cron` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `command` varchar(250) NOT NULL default '',
  `schedule` set('hourly','daily','monthly') NOT NULL default '',
  `lastran` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cron`
--


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

--
-- Table structure for table `domains`
--

CREATE TABLE IF NOT EXISTS `domains` (
  `domain` varchar(100) NOT NULL default '',
  `masterdomain` varchar(100) NOT NULL default '',
  `user` varchar(100) NOT NULL default '',
  `date` varchar(100) NOT NULL default '',
  `path` varchar(255) NOT NULL default '',
  `parked` int(1) NOT NULL default '0',
  `reseller` int(11) NOT NULL default '0',
  PRIMARY KEY  (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `domains`
--

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

--
-- Table structure for table `faqs`
--

CREATE TABLE IF NOT EXISTS `faqs` (
  `id` int(6) NOT NULL auto_increment,
  `question` varchar(50) NOT NULL default '',
  `answer` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=125 ;

--
-- Dumping data for table `faqs`
--

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

--
-- Table structure for table `ipban`
--

CREATE TABLE IF NOT EXISTS `ipban` (
  `id` int(11) NOT NULL auto_increment,
  `who` varchar(100) NOT NULL default '',
  `ip` varchar(255) NOT NULL default '',
  `reseller` int(11) NOT NULL default '0',
  `bywho` varchar(255) NOT NULL default '',
  `reason` varchar(100) default '',
  `date` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `ipban`
--


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

--
-- Table structure for table `logs`
--

CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(11) NOT NULL auto_increment,
  `type` set('Info','Warning','Error') NOT NULL default 'Info',
  `timestamp` varchar(100) NOT NULL,
  `summary` varchar(255) NOT NULL,
  `details` text NOT NULL,
  `user` varchar(100) NOT NULL,
  `ip` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3545 ;

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

--
-- Table structure for table `mailboxes`
--

CREATE TABLE IF NOT EXISTS `mailboxes` (
  `user` varchar(100) NOT NULL default '',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `maildir` varchar(255) NOT NULL default '',
  `quota` int(10) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `created` varchar(100) NOT NULL default '',
  `modified` varchar(100) NOT NULL default '',
  `status` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Mailboxes';

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

--
-- Table structure for table `mail_aliases`
--

CREATE TABLE IF NOT EXISTS `mail_aliases` (
  `user` varchar(100) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `goto` text NOT NULL,
  `domain` varchar(255) NOT NULL default '',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `active` tinyint(1) NOT NULL default '1',
  KEY `address` (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Email Aliases';

--
-- Dumping data for table `mail_aliases`
--


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

--
-- Table structure for table `modules`
--

CREATE TABLE IF NOT EXISTS `modules` (
  `name` varchar(100) NOT NULL default '',
  `active` varchar(100) default '',
  `permissions` varchar(100) default '',
  `category` int(11) NOT NULL default '0',
  `title` varchar(100) default '',
  `icon` varchar(100) default '',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `modules`
--

INSERT INTO `modules` (`name`, `active`, `permissions`, `category`, `title`, `icon`) VALUES
('my_account', '1', '5', 1, 'My Account', 'my_account.gif'),
('change_password', '1', '5', 1, 'Change Password', 'change_password.gif'),
('mailboxes', '1', '5', 2, 'Mailboxes', 'mailboxes.gif'),
('new_mailbox', '1', '5', 2, 'New Mailbox', 'mailboxes.gif');

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

--
-- Table structure for table `mod_counter`
--

CREATE TABLE IF NOT EXISTS `mod_counter` (
  `id` varchar(100) NOT NULL default '',
  `today` int(11) NOT NULL default '0',
  `overall` int(11) NOT NULL default '0',
  `date` varchar(100) NOT NULL default '',
  `user` varchar(255) NOT NULL default '0',
  `pagename` varchar(100) NOT NULL default '',
  `style` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `packages`
--

CREATE TABLE IF NOT EXISTS `packages` (
  `id` int(11) NOT NULL auto_increment,
  `reseller_package` tinyint(1) NOT NULL default '0',
  `reseller` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `quota` varchar(100) NOT NULL default '',
  `mo_price` varchar(100) NOT NULL default '',
  `allowresell` tinyint(1) NOT NULL default '0',
  `maxftp` tinyint(11) NOT NULL default '0',
  `maxmail` tinyint(11) NOT NULL default '0',
  `maxaliases` tinyint(11) NOT NULL default '0',
  `maxmailsize` tinyint(11) NOT NULL default '0',
  `maxsql` tinyint(11) NOT NULL default '0',
  `maxparked` tinyint(11) NOT NULL default '0',
  `maxdomains` tinyint(11) NOT NULL default '0',
  `maxsubs` tinyint(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `reseller_package`, `reseller`, `name`, `quota`, `mo_price`, `allowresell`, `maxftp`, `maxmail`, `maxaliases`, `maxmailsize`, `maxsql`, `maxparked`, `maxdomains`, `maxsubs`) VALUES
(1, 0, 0, 'Basic', '10', '5.50', 0, 3, 3, 3, 0, 2, 1, 1, 3);

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

--
-- Table structure for table `packages_custom`
--

CREATE TABLE IF NOT EXISTS `packages_custom` (
  `id` int(11) NOT NULL auto_increment,
  `reseller_package` tinyint(1) NOT NULL default '0',
  `reseller` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `quota` varchar(100) NOT NULL default '',
  `mo_price` varchar(100) NOT NULL default '',
  `allowresell` tinyint(1) NOT NULL default '0',
  `maxftp` tinyint(11) NOT NULL default '0',
  `maxmail` tinyint(11) NOT NULL default '0',
  `maxaliases` tinyint(11) NOT NULL default '0',
  `maxmailsize` tinyint(11) NOT NULL default '0',
  `maxsql` tinyint(11) NOT NULL default '0',
  `maxparked` tinyint(11) NOT NULL default '0',
  `maxdomains` tinyint(11) NOT NULL default '0',
  `maxsubs` tinyint(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;


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

--
-- Table structure for table `service_config`
--

CREATE TABLE IF NOT EXISTS `service_config` (
  `id` int(6) NOT NULL auto_increment,
  `name` varchar(15) NOT NULL default '',
  `sb` varchar(255) NOT NULL default '',
  `cmd` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `service_config`
--

INSERT INTO `service_config` (`id`, `name`, `sb`, `cmd`) VALUES
(1, 'HTTP Server', 'httpd', '-k graceful'),
(2, 'MySQL', '/etc/init.d/mysqld', 'restart'),
(3, 'FTP Server', '/etc/init.d/proftpd', 'restart'),
(4, 'Mail Server', 'service exim', 'restart');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE IF NOT EXISTS `sessions` (
  `sessionid` varchar(100) NOT NULL default '',
  `username` varchar(100) default '',
  `browser` varchar(100) default '',
  `hostname` varchar(100) default '',
  `os` varchar(100) default '',
  `viewing` varchar(100) default '',
  `client` varchar(100) default '',
  `lastaccess` varchar(100) default '',
  `ip` varchar(100) default '',
  PRIMARY KEY  (`sessionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`sessionid`, `username`, `browser`, `hostname`, `os`, `viewing`, `client`, `lastaccess`, `ip`) VALUES
('1', 'jason', 'Gecko/20060426 Firefox/1.5.0.3', 'router.unlimitednet.us', 'Windows NT 5.1', 'Online Users', '', '', '69.222.16.166');

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

--
-- Table structure for table `tickets`
--

CREATE TABLE IF NOT EXISTS `tickets` (
  `id` varchar(100) NOT NULL default '',
  `reseller` int(11) NOT NULL default '0',
  `os` varchar(200) NOT NULL default '',
  `browser` varchar(200) NOT NULL,
  `status` tinyint(2) NOT NULL default '0',
  `seen` varchar(3) NOT NULL,
  `summary` varchar(100) NOT NULL default '',
  `date` varchar(100) NOT NULL default '0000-00-00',
  `resolution` varchar(255) NOT NULL default '',
  `origagent` varchar(255) NOT NULL default '',
  `assignedto` varchar(255) NOT NULL default '',
  `customer` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `tickets_history`
--

CREATE TABLE IF NOT EXISTS `tickets_history` (
  `id` int(11) NOT NULL auto_increment,
  `ticket` varchar(50) NOT NULL default '0',
  `user` varchar(255) NOT NULL default '0',
  `date` varchar(100) NOT NULL default '0000-00-00',
  `message` blob NOT NULL,
  `techonly` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;


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

--
-- Table structure for table `unsuccessful_logins`
--

CREATE TABLE IF NOT EXISTS `unsuccessful_logins` (
  `id` int(11) NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL default '',
  `user` varchar(50) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `unsuccessful_logins`
--


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

--
-- Table structure for table `updates`
--

CREATE TABLE IF NOT EXISTS `updates` (
  `id` int(11) NOT NULL default '0',
  `description` blob NOT NULL,
  `date` varchar(100) NOT NULL default '',
  `admin` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `updates`
--

INSERT INTO `updates` (`id`, `description`, `date`, `admin`) VALUES
(2, '', '2006-08-28', 0),
(6, '', '2006-08-28', 0),
(1, '', '2006-08-29', 0);

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

--
-- Table structure for table `zantastico`
--

CREATE TABLE IF NOT EXISTS `zantastico` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `version` varchar(100) NOT NULL default '',
  `website` varchar(100) NOT NULL default '',
  `welcome` varchar(100) NOT NULL default '',
  `instructions` text NOT NULL,
  `finalmessage` text NOT NULL,
  `exampledir` varchar(100) NOT NULL default '',
  `catid` int(11) NOT NULL default '0',
  `zip` varchar(100) NOT NULL default '',
  `sql` text NOT NULL,
  `uniquekey` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `uniquekey` (`uniquekey`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;

--
-- Dumping data for table `zantastico`
--

INSERT INTO `zantastico` (`id`, `name`, `version`, `website`, `welcome`, `instructions`, `finalmessage`, `exampledir`, `catid`, `zip`, `sql`, `uniquekey`) VALUES
(48, 'Nucleus', '3.2', 'http://nucleuscms.org', '', '', '', 'Nucleus', 5, 'Nucleus32.zip', '', '9bf31c7ff062936a96d3c8bd1f8f2ff3'),
(46, 'MyBB', '1.1.3', 'http://www.mybboard.com', '', '', '', 'MyBB', 1, 'MyBB113.zip', '', 'c81e728d9d4c2f636f067f89cc14862c'),
(47, 'MyLittle Forum', '1.6.2', 'http://mylittlehomepage.net', '', '', '', 'MLF', 1, 'MyLittleForum162.zip', '', 'e4da3b7fbbce2345d7772b0674a318d5'),
(65, '4images', '1.7.2', 'http://4homepages.de', '', '', '', '4images', 7, '4images172.zip', '', 'b6d767d2f8ed5d21a44b0e5886680cb9'),
(39, 'bBlog', '0.7.6', 'http://bblog.com', '', '', '', 'bBlog', 2, 'bBlog076.zip', '', '1679091c5a880faf6fb5e6087eb1b2dc'),
(43, 'Joomla!', '1.0.9', 'http://joomla.org', '', '', '', 'joomla', 5, 'Joomla109.zip', '', 'c20ad4d76fe97759aa27a0c99bff6710'),
(64, 'osCommerce', '2.2', 'http://oscommerce.com', '', '', '', 'osCommerce', 4, 'osCommerce22.zip', '', 'd3d9446802a44259755d38e6d163e820'),
(50, 'phpBB', '2.0.21', 'http://phpbb.com', '', '', '', 'phpBB2', 1, 'phpBB2021.zip', '', 'c4ca4238a0b923820dcc509a6f75849b'),
(51, 'sBlog', '0.7.3b', 'http://servous.se', '', '', '', 'sBlog', 2, 'sBlog073b.zip', '', '8f14e45fceea167a5a36dedd4bea2543'),
(66, 'Mambo', '4.5.3', 'http://mamboserver.com', '', '', '', 'mambo', 5, 'Mambo453.zip', '', 'c51ce410c124a10e0db5e4b97fc2af39'),
(54, 'UseBB', '1.0 RC3', 'http://usebb.net', '', '', '', 'UseBB', 1, 'UseBB1rc3.zip', '', 'a87ff679a2f3e71d9181a67b7542122c'),
(63, 'CopperMine', '1.4.8', 'http://coppermine-gallery.net', '', '', '', 'coppermine', 7, 'coppermine148.zip', '', '1f0e3dad99908345f7439f8ffabdffc4'),
(57, 'XOOPS', '2.0.13', 'http://xoops.org', '', '', '', 'xoops', 5, 'Xoops2013.zip', '', 'aab3238922bcc25a6f606eb525ffdc56'),
(67, 'WikiWig', '4.1.0', 'http://wikiwig.sourceforge.net', '', '', '', 'wikiwig', 6, 'wikiwig410.zip', '', '70efdf2ec9b086079795c442636b55fb'),
(68, 'Zen-Cart', '1.3.0', 'http://zen-cart.com', '', '', '', 'ZenCart', 4, 'ZenCart130.zip', '', '6512bd43d9caa6e02c990b0a82652dca'),
(45, 'Advanced Electron Forum', '1.0.3', 'http://www.anelectron.com/', '', '', '', 'AEF', 1, 'AEF103.zip', '', '2c5fc4ce9dc91c2492f20663eb4d16f0');

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

--
-- Table structure for table `zantastico_categories`
--

CREATE TABLE IF NOT EXISTS `zantastico_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `zantastico_categories`
--

INSERT INTO `zantastico_categories` (`id`, `name`) VALUES
(5, 'Content Management (CMS)'),
(1, 'Forums'),
(7, 'Image Galleries'),
(2, 'Blogs'),
(3, 'News Scripts'),
(4, 'E-Commerce'),
(6, 'Wiki''s');