-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 22, 2009 at 06:18 AM
-- Server version: 5.0.81
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `rmrs_rmrs_emp`
--

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

--
-- Table structure for table `tblaffiliatepayments`
--

DROP TABLE IF EXISTS `tblaffiliatepayments`;
CREATE TABLE IF NOT EXISTS `tblaffiliatepayments` (
  `nAffiliatePayment_ID` int(5) unsigned NOT NULL auto_increment,
  `nCommission` float NOT NULL default '0',
  `nDate` int(10) NOT NULL default '0',
  `nDatePaid` int(10) NOT NULL default '0',
  `sPaymentStatus` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `nAffiliate_ID` int(5) unsigned NOT NULL default '0',
  `sUserForename` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `sUserSurname` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `sUserEmail` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `nMemberJoinDate` int(10) NOT NULL default '0',
  `sItemName` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sTransactionNumber` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sFileName` varchar(32) collate utf8_unicode_ci NOT NULL,
  `nTimeStamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`nAffiliatePayment_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblaffiliatesettings`
--

DROP TABLE IF EXISTS `tblaffiliatesettings`;
CREATE TABLE IF NOT EXISTS `tblaffiliatesettings` (
  `nAffiliateSetting_ID` int(5) unsigned NOT NULL auto_increment,
  `sCommissionType` varchar(15) collate utf8_unicode_ci default NULL,
  `nPercentage` int(11) NOT NULL,
  `nPaypal` tinyint(1) default '0',
  `nCheck` tinyint(1) default '0',
  `nHideAffiliateProgram` int(11) NOT NULL default '0',
  `nHideCustomerData` tinyint(1) NOT NULL default '0', 
  PRIMARY KEY  (`nAffiliateSetting_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
-- --------------------------------------------------------

--
-- Table structure for table `tblautoresponders`
--

DROP TABLE IF EXISTS `tblautoresponders`;
CREATE TABLE IF NOT EXISTS `tblautoresponders` (
  `nAutoresponder_ID` int(11) NOT NULL auto_increment,
  `sAutoresponderName` varchar(50) NOT NULL,
  `sAutoresponderURL` varchar(100) NOT NULL,
  `sHiddenFields` text NOT NULL,
  `sFormName` varchar(50) NOT NULL,
  `sFormEmail` varchar(50) NOT NULL,
  `nActive` int(1) NOT NULL default '0',
  PRIMARY KEY  (`nAutoresponder_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `tblcustomfieldsettings`
-- 

DROP TABLE IF EXISTS `tblcustomfieldsettings`;
CREATE TABLE `tblcustomfieldsettings` (
  `nCustomFieldSetting_ID` int(11) NOT NULL auto_increment,
  `sCustomFieldName` varchar(50) NOT NULL,
  `nSortOrder` int(2) NOT NULL default '0',
  `nDisplay` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`nCustomFieldSetting_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- --------------------------------------------------------
--
-- Table structure for table `tbldirectories`
--

DROP TABLE IF EXISTS `tbldirectories`;
CREATE TABLE IF NOT EXISTS `tbldirectories` (
  `nDirectory_ID` int(5) unsigned NOT NULL auto_increment,
  `sDirectoryName` varchar(255) collate utf8_unicode_ci default NULL,
  `sDirectoryPath` varchar(255) collate utf8_unicode_ci default NULL,
  `nLevel_ID` int(11) NOT NULL default '0',
  `bDisplay` tinyint(1) NOT NULL default '1',
  `nSortOrder` int(5) unsigned default '0',
  `nParent_ID` int(11) NOT NULL,
  PRIMARY KEY  (`nDirectory_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblemailtemplates`
--

DROP TABLE IF EXISTS `tblemailtemplates`;
CREATE TABLE IF NOT EXISTS `tblemailtemplates` (
  `nEmail_ID` int(11) NOT NULL auto_increment,
  `sSubject` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sBody` text collate utf8_unicode_ci NOT NULL,
  `sType` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `sTitle` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `dEventDate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`nEmail_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblfiles`
--

DROP TABLE IF EXISTS `tblfiles`;
CREATE TABLE IF NOT EXISTS `tblfiles` (
  `nFile_ID` int(10) unsigned NOT NULL auto_increment,
  `nCategory_ID` int(11) NOT NULL default '0',
  `sTitle` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sDescription` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sFilename` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sPath` varchar(128) collate utf8_unicode_ci NOT NULL default '/',
  `sType` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `nSize` int(11) NOT NULL default '0',
  `sSecure_Link` varchar(128) collate utf8_unicode_ci NOT NULL,
  `nDownloads` int(10) NOT NULL default '0',
  `sURL` varchar(255) NULL,
  `nMemberOnly` int(1) NOT NULL default '0',
  PRIMARY KEY  (`nFile_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblmembershiplevels`
--

DROP TABLE IF EXISTS `tblmembershiplevels`;
CREATE TABLE IF NOT EXISTS `tblmembershiplevels` (
  `nLevel_ID` int(10) unsigned NOT NULL auto_increment,
  `nOrder` int(11) NOT NULL,
  `sLevel` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nActive` varchar(1) collate utf8_unicode_ci NOT NULL default '0',
  `nDisplayFront` varchar(1) collate utf8_unicode_ci NOT NULL default '0',
  PRIMARY KEY  (`nLevel_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpagelevels`
--

DROP TABLE IF EXISTS `tblpagelevels`;
CREATE TABLE IF NOT EXISTS `tblpagelevels` (
  `nPageLevel_ID` int(11) NOT NULL auto_increment,
  `nPage_ID` int(11) NOT NULL,
  `nLevel_ID` int(11) NOT NULL,
  PRIMARY KEY  (`nPageLevel_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpages`
--

DROP TABLE IF EXISTS `tblpages`;
CREATE TABLE IF NOT EXISTS `tblpages` (
  `nPage_ID` int(5) NOT NULL auto_increment,
  `sPageName` varchar(255) collate utf8_unicode_ci default NULL,
  `sPageTitle` varchar(100) collate utf8_unicode_ci NOT NULL,
  `sFileName` varchar(255) collate utf8_unicode_ci default NULL,
  `nDirectory_ID` int(5) unsigned default NULL,
  `nDisplay` tinyint(1) unsigned default '0',
  `nSortOrder` int(5) unsigned default '0',
  `sNavBarLocation` varchar(10) collate utf8_unicode_ci default 'top',
  `sItemName` varchar(50) collate utf8_unicode_ci default '',
  `nPrice` float default '0',
  `nDownloadPage` tinyint(1) default '0',
  `s2COProductID` varchar(50) collate utf8_unicode_ci default NULL,
  `s1ShoppingCartPID` varchar(255) collate utf8_unicode_ci default NULL,
  `sClickBankItem` varchar(255) collate utf8_unicode_ci default NULL,
  `sMonth` varchar(10) collate utf8_unicode_ci default NULL,
  `sYear` varchar(4) collate utf8_unicode_ci default NULL,
  `cre` tinyint(1) unsigned default '0',
  `sContent` longtext collate utf8_unicode_ci NOT NULL,
  `nAccessDays` int(11) NOT NULL default '0',
  `nConfEmail` tinyint(1) unsigned default '0',
  `sConfEmailContent` text collate utf8_unicode_ci default NULL,
  `nDynamicPage` tinyint(1) default '0',
  `nUnavailableForJoinedAfter` date default NULL,
  PRIMARY KEY  (`nPage_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpaymentplans`
--

DROP TABLE IF EXISTS `tblpaymentplans`;
CREATE TABLE IF NOT EXISTS `tblpaymentplans` (
  `nPaymentPlan_ID` int(5) unsigned NOT NULL auto_increment,
  `nPaymentProcessor_ID` int(11) NOT NULL,
  `sPlanName` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nRegularAmount` float NOT NULL default '0',
  `nTrialAmount1` float NOT NULL default '0',
  `nTrialAmount2` float NOT NULL default '0',
  `nRegularPeriod` int(11) NOT NULL default '0',
  `sRegularPeriod` enum('Days','Weeks','Months','Year') collate utf8_unicode_ci NOT NULL,
  `nTrial1Period` int(11) NOT NULL default '0',
  `sTrial1Period` enum('Days','Weeks','Months','Year') collate utf8_unicode_ci NOT NULL,
  `nTrial2Period` int(11) NOT NULL default '0',
  `sTrial2Period` enum('Days','Weeks','Months','Year') collate utf8_unicode_ci NOT NULL,
  `nOneTimePayment` int(11) NOT NULL default '0',
  `sItemNumber` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nRecurTimes` int(11) NOT NULL default '0',
  `nActive` tinyint(1) NOT NULL default '1',
  `nMembershipLevel_ID` int(11) NOT NULL,
  `nCoupon_ID` int(11) NULL,
  PRIMARY KEY  (`nPaymentPlan_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpaymentprocessors`
--

DROP TABLE IF EXISTS `tblpaymentprocessors`;
CREATE TABLE IF NOT EXISTS `tblpaymentprocessors` (
  `nPaymentProcessor_ID` int(11) NOT NULL auto_increment,
  `sProcessorName` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sProcessorDetails` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nActive` int(11) NOT NULL,
  `sParam1` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sParam2` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sParam3` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sParam4` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nAllowTrial` int(11) NOT NULL,
  `nTrialPeriods` int(11) NOT NULL,
  PRIMARY KEY  (`nPaymentProcessor_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `tblsitesettings`
--

DROP TABLE IF EXISTS `tblsitesettings`;
CREATE TABLE IF NOT EXISTS `tblsitesettings` (
  `nSiteSetting_ID` int(5) unsigned NOT NULL auto_increment,
  `sSiteName` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `sSiteURL` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `nDateFormat` int(5) NOT NULL default '0',
  `sCurrencyFormat` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `nCookieExpiry` int(11) NOT NULL default '90',
  `nCookieNeverExpires` int(1) NOT NULL default '0',
  `sSiteOwner` varchar(150) collate utf8_unicode_ci NOT NULL default '',
  `sAdminEmail` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `sSupportEmail` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `nOneTimeOffer` tinyint(1) NOT NULL default '0',
  `nDailyBackup` tinyint(1) NOT NULL default '0',
  `nFreeMembership` int(1) NOT NULL default '0',
  `nFreeOnlyMembership` int(1) NOT NULL default '0',
  `sForumLink` varchar(255) collate utf8_unicode_ci default NULL,
  `nTOS` tinyint(1) NOT NULL default '0',
  `sTOS` text collate utf8_unicode_ci NOT NULL,
  `nLogQueries` int(11) NOT NULL,
  `sEmailFooter` text collate utf8_unicode_ci NOT NULL,
  `sEMPAffiliateLink` varchar(100) collate utf8_unicode_ci default NULL,
  `sMetaTags` text collate utf8_unicode_ci,
  `sJavascript` text collate utf8_unicode_ci,
  `HTTPPostURL` varchar(250) collate utf8_unicode_ci NOT NULL,
  `nDisplayAddressField` tinyint(1) NOT NULL default '1',
  `nDisplayTelephoneField` tinyint(1) NOT NULL default '1',
  `nDisplayMobileField` tinyint(1) NOT NULL default '1',
  `nDisplayCouponField` tinyint(1) NOT NULL default '1',
  `nDisplaySupportForm` tinyint(1) NOT NULL default '0',
  `sKey` varchar(32) collate utf8_unicode_ci NOT NULL, 
  `nScriptVersion` double(5,2) NOT NULL,  
  `sGoogleAnalytics` varchar(500) NULL,
  `sGoogleWebmaster` varchar(255) NULL,
  PRIMARY KEY  (`nSiteSetting_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
-- --------------------------------------------------------

--
-- Table structure for table `tblpromoemails`
--

DROP TABLE IF EXISTS `tblpromoemails`;
CREATE TABLE IF NOT EXISTS `tblpromoemails` (
  `nPromoEmail_ID` int(5) unsigned NOT NULL auto_increment,
  `sTitle` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nSortOrder` int(11) NOT NULL,
  `sEmailText` text collate utf8_unicode_ci,
  `nActive` tinyint(1) unsigned default '0',
  PRIMARY KEY  (`nPromoEmail_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpromoemailsubject`
--

DROP TABLE IF EXISTS `tblpromoemailsubject`;
CREATE TABLE IF NOT EXISTS `tblpromoemailsubject` (
  `nPromoEmailSubject_ID` int(5) unsigned NOT NULL auto_increment,
  `nPromoEmail_ID` int(11) NOT NULL,
  `sSubject` varchar(255) collate utf8_unicode_ci default NULL,
  `nDisplay` tinyint(1) unsigned default '0',
  PRIMARY KEY  (`nPromoEmailSubject_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblpromographics`
--

DROP TABLE IF EXISTS `tblpromographics`;
CREATE TABLE IF NOT EXISTS `tblpromographics` (
  `nPromoGraphic_ID` int(5) unsigned NOT NULL auto_increment,
  `nActive` tinyint(1) unsigned default '0',
  `sDescription` varchar(15) collate utf8_unicode_ci default NULL,
  `nSortOrder` int(5) NOT NULL default '0',
  PRIMARY KEY  (`nPromoGraphic_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblquerylog`
--

DROP TABLE IF EXISTS `tblquerylog`;
CREATE TABLE IF NOT EXISTS `tblquerylog` (
  `id` bigint(20) NOT NULL auto_increment,
  `query` text collate utf8_unicode_ci NOT NULL,
  `errnb` int(11) NOT NULL,
  `errtxt` varchar(255) collate utf8_unicode_ci NOT NULL,
  `qtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `qtype` varchar(255) collate utf8_unicode_ci NOT NULL,
  `url` varchar(255) collate utf8_unicode_ci NOT NULL,
  `ip` varchar(19) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

--
-- Table structure for table `tbltemplatesettings`
--

DROP TABLE IF EXISTS `tbltemplatesettings`;
CREATE TABLE IF NOT EXISTS `tbltemplatesettings` (
  `nTemplateSetting_ID` int(11) NOT NULL auto_increment,
  `nHeaderTextBold` tinyint(1) NOT NULL default '0',
  `nFooterTextBold` tinyint(1) NOT NULL default '0',
  `sHeaderNavAlign` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sFooterNavAlign` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nHideHeaderNav` tinyint(1) NOT NULL default '0',
  `nHideFooterNav` tinyint(1) NOT NULL default '0',
  `nHideFooterGraphic` tinyint(1) NOT NULL default '0',
  `nHidePoweredByLink` tinyint(1) NOT NULL default '0',
  `nHideBorder` tinyint(4) NOT NULL default '0',
  `btmcolor1` varchar(10) collate utf8_unicode_ci default NULL,
  `bodybackground` varchar(10) collate utf8_unicode_ci default NULL,
  `headerpath` varchar(50) collate utf8_unicode_ci default NULL,
  `footerpath` varchar(50) collate utf8_unicode_ci default NULL,
  `mheaderpath` varchar(50) collate utf8_unicode_ci default NULL,
  `mfooterpath` varchar(50) collate utf8_unicode_ci default NULL,
  `headimgwidth` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `mheadimgwidth` varchar(25) collate utf8_unicode_ci NOT NULL default '',
  `mbackcolor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `mhovercolor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `mtextcolor` varchar(10) collate utf8_unicode_ci NOT NULL default '',
  `sFrontEndTemplateFile` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sMemberTemplateFile` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sLanguageFile` varchar(50) NOT NULL,
  PRIMARY KEY  (`nTemplateSetting_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tbltransactions`
--

DROP TABLE IF EXISTS `tbltransactions`;
CREATE TABLE IF NOT EXISTS `tbltransactions` (
  `nTransaction_ID` int(10) unsigned NOT NULL auto_increment,
  `nTransactionType_ID` int(10) unsigned NOT NULL,
  `sUserEmail` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sUserForename` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sUserSurname` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sAffEmail` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sAffForename` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sAffSurname` varchar(50) collate utf8_unicode_ci NOT NULL,
  `sProcessor` varchar(50) collate utf8_unicode_ci NOT NULL,
  `nSaleAmount` float NOT NULL,
  `nCommissionAmount` float NOT NULL,
  `dDateTime` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `sTransactionNumber` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`nTransaction_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tbltransactiontypes`
--

DROP TABLE IF EXISTS `tbltransactiontypes`;
CREATE TABLE IF NOT EXISTS `tbltransactiontypes` (
  `nTransactionType_ID` int(10) unsigned NOT NULL auto_increment,
  `sType` varchar(50) collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`nTransactionType_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tbluserlevels`
--

DROP TABLE IF EXISTS `tbluserlevels`;
CREATE TABLE IF NOT EXISTS `tbluserlevels` (
  `nUserLevel_ID` int(11) NOT NULL auto_increment,
  `nUser_ID` int(11) NOT NULL,
  `nLevel_ID` int(11) NOT NULL,
  `nPaymentPlan_ID` int(11) NOT NULL default '0',
  `sTransactionNumber` varchar(50) collate utf8_unicode_ci default NULL,
  `nDateExpires` int(11) NOT NULL default '0',
  `nDateCancelled` int(11) NOT NULL default '0',
  `nPaymentCounter` int(11) NOT NULL default '0',
  `nActive` int(11) NOT NULL default '1',
  `nDateActive` int(11) NOT NULL default '0',
  `nCoupon_ID` int(11) NULL,
  PRIMARY KEY  (`nUserLevel_ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblusers`
--

DROP TABLE IF EXISTS `tblusers`;
CREATE TABLE IF NOT EXISTS `tblusers` (
  `nUser_ID` int(5) unsigned NOT NULL auto_increment,
  `sForename` varchar(100) collate utf8_unicode_ci default NULL,
  `sSurname` varchar(100) collate utf8_unicode_ci default NULL,
  `sAddr1` varchar(100) collate utf8_unicode_ci default NULL,
  `sAddr2` varchar(100) collate utf8_unicode_ci default NULL,
  `sAddr3` varchar(100) collate utf8_unicode_ci default NULL,
  `sTown` varchar(50) collate utf8_unicode_ci default NULL,
  `sCounty` varchar(50) collate utf8_unicode_ci default NULL,
  `sPostcode` varchar(50) collate utf8_unicode_ci default NULL,
  `sCountry` varchar(50) collate utf8_unicode_ci default NULL,
  `sEmail` varchar(50) collate utf8_unicode_ci default NULL,
  `sTelephone` varchar(25) collate utf8_unicode_ci default NULL,
  `sMobile` varchar(25) collate utf8_unicode_ci default NULL,
  `nJoinDate` int(10) default NULL,
  `sJoinTime` varchar(15) collate utf8_unicode_ci default NULL,
  `sPassword` varchar(50) collate utf8_unicode_ci default NULL,
  `nAdmin` tinyint(1) unsigned default '0',
  `nAffiliate` tinyint(1) unsigned default '0',
  `nAffiliate_ID` int(5) unsigned default '0',
  `nActive` tinyint(1) unsigned default '0',
  `nCustomCommission` int(5) unsigned default '0',
  `sPaypalEmail` varchar(50) collate utf8_unicode_ci default NULL,
  `nDateCancelled` int(11) NOT NULL default '0',
  `sPaymentStatus` varchar(50) collate utf8_unicode_ci NOT NULL default 'free',
  `nReminderEmailSent` tinyint(1) NOT NULL default '0',
  `sComments` text collate utf8_unicode_ci NOT NULL,
  `bAddedToAutoresponder` int(1) NOT NULL default '0',
  `bViewedOneTimeOffer` tinyint(1) NOT NULL default '0',
  `nUnsubscribe` int(1) NOT NULL default '0',
  `timestamp_join` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `sCustomField1` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField2` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField3` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField4` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField5` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField6` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField7` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField8` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField9` varchar(100) collate utf8_unicode_ci default NULL,
  `sCustomField10` varchar(100) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`nUser_ID`),
  UNIQUE KEY `sEmail` (`sEmail`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblcoupons`
--

DROP TABLE IF EXISTS `tblcoupons`;
CREATE TABLE `tblcoupons` (
`nCoupon_ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`sCouponCode` VARCHAR( 10 ) NOT NULL ,
`nExpiryDate` INT( 8 ) NOT NULL ,
`nQtyAvailable` INT( 4 ) NOT NULL ,
`bActive` TINYINT( 1 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Table structure for table `tblvideos`
--

DROP TABLE IF EXISTS `tblvideos`;
CREATE TABLE `tblvideos` (
`nVideo_ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`sFileName` VARCHAR(50) NOT NULL, 
`sURL` VARCHAR(255) NULL, 
`sPath` VARCHAR(255) NOT NULL, 
`sType` VARCHAR(50) NOT NULL, 
`nViews` INT NOT NULL DEFAULT '0',
`nMemberOnly` INT(1) NOT NULL DEFAULT '0'
) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;