#
# Table structure for table `CLIENTS`
#

CREATE TABLE `CLIENTS` (
  `ID` int(11) NOT NULL auto_increment,
  `PAYER_EMAIL` varchar(255) NOT NULL default '',
  `PACKAGE` varchar(255) NOT NULL default '',
  `SIGNUPDATE` varchar(50) default NULL,
  `IG` varchar(255) NOT NULL default '',
  `CPW` varchar(50) NOT NULL default '',
  `LASTPAYMENT` varchar(50) default NULL,
  `STATUS` varchar(50) NOT NULL default '',
  `NEXTPAYMENT` varchar(50) NOT NULL default '',
  `USERNAME` varchar(255) NOT NULL default '',
  `DOMAIN` varchar(255) NOT NULL default '',
  `UNI` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;

#
# Dumping data for table `CLIENTS`
#


# --------------------------------------------------------

#
# Table structure for table `FREEHOSTING`
#

CREATE TABLE `FREEHOSTING` (
  `ID` int(11) NOT NULL auto_increment,
  `FREE` varchar(50) NOT NULL default 'NO',
  `SYN` varchar(50) NOT NULL default 'NO',
  `SUB` varchar(255) NOT NULL default 'yourdomain.com',
  `NAME` varchar(255) NOT NULL default '',
  `WHMNAME` varchar(255) NOT NULL default '',
  `FROOM` varchar(255) NOT NULL default '',
  `SUBJECT` varchar(255) NOT NULL default '',
  `MESSAGE` text NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `FREEHOSTING`
#

INSERT INTO `FREEHOSTING` VALUES (1, 'NO', 'NO', 'yourdomain.com', '', '', '', '', '');

# --------------------------------------------------------

#
# Table structure for table `HOSTINGPACKAGES`
#

CREATE TABLE `HOSTINGPACKAGES` (
  `ID` int(11) NOT NULL auto_increment,
  `NAME` varchar(255) NOT NULL default '',
  `WHMNAME` varchar(255) NOT NULL default '',
  `MONTHLY` varchar(50) NOT NULL default '',
  `QUARTERLY` varchar(50) NOT NULL default '',
  `SEMIANNUALLY` varchar(50) NOT NULL default '',
  `ANNUALLY` varchar(50) NOT NULL default '',
  `2YEARS` varchar(50) NOT NULL default '',
  `FREETRIAL` varchar(50) NOT NULL default '',
  `YY` varchar(50) NOT NULL default '',
  `NN` varchar(50) NOT NULL default '',
  `FROOM` varchar(255) NOT NULL default '',
  `SUBJECT` varchar(255) NOT NULL default '',
  `MESSAGE` text NOT NULL,
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `HOSTINGPACKAGES`
#


# --------------------------------------------------------

#
# Table structure for table `MAILINGLIST`
#

CREATE TABLE `MAILINGLIST` (
  `ID` int(11) NOT NULL auto_increment,
  `PAYER_EMAIL` varchar(255) NOT NULL default '',
  `PRODUCT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# Dumping data for table `MAILINGLIST`
#


# --------------------------------------------------------

#
# Table structure for table `SETTINGS`
#

CREATE TABLE `SETTINGS` (
  `USERNAME` varchar(255) NOT NULL default '',
  `PASSWORD` varchar(255) NOT NULL default '',
  `URL` varchar(255) NOT NULL default '',
  `PATH` varchar(255) NOT NULL default '',
  `ADMINIP` varchar(255) NOT NULL default '',
  `ID` int(11) NOT NULL auto_increment,
  `HOST` varchar(255) NOT NULL default 'localhost',
  `RAK` text NOT NULL,
  `USER` varchar(255) NOT NULL default '',
  `RECEIVER_EMAIL` varchar(255) NOT NULL default '',
  `CURRENCY` varchar(255) NOT NULL default '',
  `LOGO_URL` varchar(255) NOT NULL default '',
  `SUCCESS_URL` varchar(255) NOT NULL default '',
  `CANCEL_URL` varchar(255) NOT NULL default '',
  `WSU` varchar(255) NOT NULL default '',
  `SUBDOMAIN` varchar(255) NOT NULL default '',
  `DNR` varchar(255) NOT NULL default '',
  `S_SIGNUP` text NOT NULL,
  `S_CANCEL` text NOT NULL,
  `S_MODIFY` text NOT NULL,
  `S_FAILURE` text NOT NULL,
  `S_PAYMENT` text NOT NULL,
  `S_EOT` text NOT NULL,
  `AUTOTERM` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `SETTINGS`
#

INSERT INTO `SETTINGS` VALUES ('admin', 'admin', 'temp', 'temp', '24.67.253.204', 1, 'localhost', 'temp', 'temp', 'temp', 'USD', 'temp', 'temp', 'temp', 'temp', '', 'http://www.namerocket.net', '$message\r\n<br>\r\n<br>\r\nYour account details are below :\r\n<br>\r\n<br>\r\nDomain : <b>$domain</b>\r\n<br>\r\nUsername : <b>$un</b>\r\n<br>\r\nPassword : <b>$pw</b>\r\n<br>\r\nPackage : <b>$name</b>\r\n<br>\r\n<br>\r\nYou may log into our client control panel at any time to view your account details\r\n<br>\r\n<br>\r\n<a href=\\"$url$members\\">Client Area</a>\r\n<br>\r\n<br>\r\nThankyou\r\n<br>\r\n-Management', 'You have cancelled your subscription to $name. You will still be able to access your account until the end of your subscription term. Please recover any files & backup any databases that you do not wish to lose.\r\n<br>\r\n<br>\r\nThankyou\r\n<br>\r\n-Management', '', 'Your web hosting subscription to $name has failed, billing will be reattempted 3 days after failure date, and then again 5 days later, a third failure will lead to automatic cancellation of your subscription.\r\n<br>\r\n<br>\r\nThankyou\r\n<br>\r\n-Management \r\n\r\n', 'Your payment to $name has been successful!\r\n<br>\r\n<br>\r\nYou may log into our client control panel at any time to view your account details\r\n<br>\r\n<br>\r\n<a href=\\"$url$members\\">Client Area</a>\r\n<br>\r\n<br>\r\nThankyou\r\n<br>\r\n-Management\r\n\r\n', 'You subscription to $name has ended, thankyou for hosting with us.\r\n<br>\r\n<br>\r\n-Management\r\n\r\n', 'NO');
