CREATE TABLE `affiliate_client` (
  `affiliateid` int(100) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `clicks` varchar(100) NOT NULL default '0',
  `commission` varchar(100) NOT NULL default '0',
  `checkout` varchar(100) NOT NULL default '0',
  `amount` varchar(100) NOT NULL default '0',
  `total` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`affiliateid`)
) ENGINE=MyISAM;

CREATE TABLE `commission` (
  `comid` int(100) NOT NULL auto_increment,
  `ratio` varchar(100) NOT NULL default '0',
  PRIMARY KEY  (`comid`)
) ENGINE=MyISAM;
INSERT INTO `commission` VALUES (1, '12');

CREATE TABLE `config` (
  `name` varchar(255) NOT NULL default '',
  `value` text NOT NULL
) ENGINE=MyISAM;
INSERT INTO `config` VALUES ('contactemail', 'admin@YourDomain.com');
INSERT INTO `config` VALUES ('siteurl', 'http://www.YourDomain.com/amm');
INSERT INTO `config` VALUES ('adminemail', 'YourDomain.com');
INSERT INTO `config` VALUES ('websitename', 'Automated Membership Manager');
INSERT INTO `config` VALUES ('websiteintro', 'desc - Sample Automated Membership Manager - desc');
INSERT INTO `config` VALUES ('currency_code', 'USD');
INSERT INTO `config` VALUES ('domain', 'YourDomain.com');
INSERT INTO `config` VALUES ('membership_status', 'on');
INSERT INTO `config` VALUES ('module_affiliate', 'off');
INSERT INTO `config` VALUES ('table_width', '750');
INSERT INTO `config` VALUES ('contact_form', 'off');

CREATE TABLE `ipn_paypal` (
  `id` int(11) NOT NULL auto_increment,
  `invoice` varchar(255) NOT NULL default '',
  `randomnumber` varchar(255) NOT NULL default '',
  `item_name` varchar(255) NOT NULL default '',
  `item_number` varchar(255) NOT NULL default '',
  `payment_status` varchar(255) NOT NULL default '',
  `mc_gross` varchar(255) NOT NULL default '',
  `mc_currency` varchar(255) NOT NULL default '',
  `txn_id` varchar(255) NOT NULL default '',
  `receiver_email` varchar(255) NOT NULL default '',
  `payer_email` varchar(255) NOT NULL default '',
  `order_number` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

CREATE TABLE `memberpages` (
  `id` int(11) NOT NULL auto_increment,
  `order` varchar(10) NOT NULL default '10',
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `metatitle` varchar(255) NOT NULL default '',
  `metadesc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

INSERT INTO `memberpages` VALUES (1, '1', 'News', '\r\n\r\n<h2>Mmeber News</h2>\r\n\r\n<pre><font><font><font><font size="3">This could be a welcome or news page for all your memebrs. Keep<br>them updated and let them know what is new and where to find it.<br><br></font></font></font></font><font><font><font><font><font><font><font><font size="3">This week we have tons more content for everyone! So jump to the<br>weekly picks page and get all the fresh stuff now.<br></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font size="3">This week we have tons more content for everyone! So jump to the<br>weekly picks page and get all the fresh stuff now.<br></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font size="3">This week we have tons more content for everyone! So jump to the<br>weekly picks page and get all the fresh stuff now.<br></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font size="3">This week we have tons more content for everyone! So jump to the<br>weekly picks page and get all the fresh stuff now.<br></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font size="3">This week we have tons more content for everyone! So jump to the<br>weekly picks page and get all the fresh stuff now.</font></font></font></font></font></font></font></font><br></pre>', 'member News', '');
INSERT INTO `memberpages` VALUES (2, '2', 'Weekly Picks', '\r\n\r\n<h2>Weekly Stock Picks<br></h2>\r\n\r\n\r\n<pre><font><font><font><font><font><font><font><font size="3">This could be where you tell them the new info or such.<br>example, a stock website would give fresh stock picks weekly. so you<br>could tellt hem what to buy and what to sell.</font></font></font></font></font></font></font></font><br><font><font><font><font><font><font><font><font size="3">This could be where you tell them the new info or such.<br>example, a stock website would give fresh stock picks weekly. so you<br>could tellt hem what to buy and what to sell.</font></font></font></font></font></font></font></font>\r\n<br><font><font><font><font><font><font><font><font size="3">This could be where you tell them the new info or such.<br>example, a stock website would give fresh stock picks weekly. so you<br>could tellt hem what to buy and what to sell.</font></font></font></font></font></font></font></font>\r\n<font><font><font><font><font><font><font><font size="3">This could be where you tell them the new info or such.<br>example, a stock website would give fresh stock picks weekly. so you<br>could tellt hem what to buy and what to sell.</font></font></font></font></font></font></font></font><br><br><font><font><font></font></font></font></pre>', 'weekly stock picks', '');
INSERT INTO `memberpages` VALUES (5, '10', 'Tools', '\r\n\r\n<h2>Trading Tools<br></h2>\r\n\r\n\r\n<pre><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>\r\n<font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>\r\n<font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font>\r\n<br><br><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><br><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.<br></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font><font size="3">If you have a stock pick website. HEre you could list all the websites<br>and which are good or bad. maybe the tools you use and other great info.</font></font></font></font></font></font></font></font></font></font></font></font></font></font></font></font><br><br></pre>', 'Trading tools', '');

CREATE TABLE `membership` (
  `id` int(11) NOT NULL auto_increment,
  `active` int(11) NOT NULL default '1',
  `fname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `joindate` varchar(255) NOT NULL default '',
  `lastpaymentdate` varchar(255) NOT NULL default '',
  `expiredate` varchar(255) NOT NULL default '',
  `term` int(11) NOT NULL default '0',
  `type` char(2) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM;
INSERT INTO `membership` VALUES (1, 1, 'test', 'test', 'test', '1175247103', '1175247103', '1490607103', 10, 'Y');

CREATE TABLE `membership_cfg` (
  `name` text NOT NULL,
  `value` text NOT NULL
) ENGINE=MyISAM;
INSERT INTO `membership_cfg` VALUES ('subscr_message', '\r\n<table height="214" width="518">\r\n<tbody><tr><td>\r\n\r\n<div align="center"><hr size="2" width="100%"><strong>Signup Today !</strong><br></div>\r\n<br>This could be a short over view of what they get as members. Just Becomming a membe has its perks. You get access to all of our files for a low monhtly price. Becomming a membem has its perks. <br><ul><li>Full access for 1 month</li><li>Daily/weekly updates</li><li>Only $19.99 per month</li></ul>\r\n\r\n</td></tr>\r\n</tbody></table>');
INSERT INTO `membership_cfg` VALUES ('subscr_price', '19.99');
INSERT INTO `membership_cfg` VALUES ('subscr_term', '1');
INSERT INTO `membership_cfg` VALUES ('subscr_duration', 'M');
INSERT INTO `membership_cfg` VALUES ('subscr_item_name', 'Sample membership');
INSERT INTO `membership_cfg` VALUES ('subscr_news', '\r\n					\r\n					\r\n					\r\n					\r\n<p align="center"><strong><u><font size="5">2 Welcome Members fffff<br></font></u></strong></p>\r\n<p align="left"><font size="3">Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new.... Today we have added some exciting new files. WE have added the new....</font> </p>');

CREATE TABLE `merchant` (
  `name` varchar(255) NOT NULL default '',
  `value` text NOT NULL
) ENGINE=MyISAM;
INSERT INTO `merchant` VALUES ('paypal_merchant', '1');
INSERT INTO `merchant` VALUES ('paypal_email', 'adrian@akwebsolutions.com');

CREATE TABLE `pages` (
  `id` int(11) NOT NULL auto_increment,
  `order` int(10) NOT NULL default '10',
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `metatitle` varchar(255) NOT NULL default '',
  `metadesc` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

INSERT INTO `pages` VALUES (5, 1, 'Home', '\r\n\r\n<h2>Automated Membership Manager</h2>\r\n\r\n<pre><font><font size="3">This is a simple script to let you start your very own membership websites.<br>Members will pay regularly for access to your knowledge &amp; information.<br>The whole system is fully automated and will process everything for you.<br><br></font></font><font><font size="3">This is a simple script to let you start your very own membership websites.<br>Members will pay regularly for access to your knowledge &amp; information.<br>The whole system is fully automated and will process everything for you.<br><br></font></font><font><font size="3">This is a simple script to let you start your very own membership websites.<br>Members will pay regularly for access to your knowledge &amp; information.<br>The whole system is fully automated and will process everything for you.</font></font><br><font size="3"><br></font></pre>', 'welcome to our home page', '');
INSERT INTO `pages` VALUES (6, 5, 'FAQ', '\r\n\r\n<h2>Membership FAQ</h2>\r\n\r\n<pre><font><font size="3">Here you could answer common questions that people might have. <br>Maybe a short Q&amp;A to help people understand more and buy faster.<br><br></font></font><font><font><font><font size="3">Q. <strong>Do I get instant access?</strong><br>A. Yes, you can have access instantly as soon as you make payment.</font></font></font></font><br><br><font><font><font><font size="3">Q. <strong>Can I pay with paypal?</strong><br>A. Yes, we accept paypal from all our members.</font></font></font></font><br><br><font><font><font><font size="3">Q. <strong>How do I renew my membership?</strong><br>A. Don''t worry! Your membership is fully automated, it will <br>automatically renew at the end of the term, there is no maitnence required.<br><br></font></font></font></font><font><font><font><font size="3">Q. <strong>Do I get instant access?</strong><br>A. Yes, you can have access instantly as soon as you make payment.</font></font></font></font><br><br><font><font><font><font size="3">Q. <strong>Can I pay with paypal?</strong><br>A. Yes, we accept paypal from all our members.</font></font></font></font><br><br><font><font><font><font size="3">Q. <strong>How do I renew my membership?</strong><br>A. Don''t worry! Your membership is fully automated, it will automatically <br>renew at the end of the term, there is no maitnence required.<br><br></font></font></font></font><br><font><font><font><font size="3"><br><br></font></font></font></font><font><font size="3"><br><br></font></font></pre>', 'Membership FAQ', '');
INSERT INTO `pages` VALUES (21, 4, 'Features', '\r\n\r\n<h2>Membership Features<br></h2>\r\n\r\n<pre><font><font><font><font size="3">This page could list out everything they get when they are a member.<br>You have tons of space to make a big sales ad, that will really get <br>them excitied.<br></font></font></font></font><font><font><font><font size="3">This page could list out everything they get when they are a member.<br>You have tons of space to make a big sales ad, that will really get <br>them excitied.</font></font></font></font><br><font><font><font><font size="3">This page could list out everything they get when they are a member.<br>You have tons of space to make a big sales ad, that will really get <br>them excitied.<br></font></font></font></font><font><font><font><font size="3">This page could list out everything they get when they are a member.<br>You have tons of space to make a big sales ad, that will really get <br>them excitied.<br></font></font></font></font><font><font><font><font size="3">This page could list out everything they get when they are a member.<br>You have tons of space to make a big sales ad, that will really get <br>them excitied.<br></font></font></font></font><br><br></pre>', 'Membership Features', '');
