[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]ZeusChicago[/eluser]
here are the tables themselves with populated data
[code]
CREATE TABLE IF NOT EXISTS `subscriptions` (
`ID` int(10) unsigned NOT NULL auto_increment,
`fa_user_id` int(10) unsigned NOT NULL,
`subscriptiontype_id` int(10) unsigned NOT NULL,
`startdatetime` datetime NOT NULL,
`enddatetime` datetime NOT NULL,
`paypaldata` text NOT NULL,
PRIMARY KEY (`ID`)
)

INSERT INTO `subscriptions` (`ID`, `fa_user_id`, `subscriptiontype_id`, `startdatetime`, `enddatetime`, `paypaldata`) VALUES
(32, 1, 2, '2009-08-04 10:59:19', '2009-09-04 10:59:19', 'NA^|^NA'),
(33, 1, 3, '2009-09-11 13:02:40', '2009-10-11 13:02:40', 'mc_gross=4.99^|^protection_eligibility=Eligible^|^address_status=confirmed^|^payer_id=6DQTLABWCDYB4^|^tax=0.00^|^address_street=1 Main St^|^payment_date=11:05:32 Sep 11, 2009 PDT^|^payment_status=Completed^|^charset=windows-1252^|^address_zip=95131^|^first_name=Jim^|^mc_fee=0.44^|^address_country_code=US^|^address_name=Jim Bodine''s Test Store^|^notify_version=2.8^|^custom=sub|1 month|3|4.99|One Time Ad|1|2009-09-11 13:02:40^|^payer_status=verified^|^[email protected]^|^address_country=United States^|^address_city=San Jose^|^quantity=1^|^verify_sign=A1rhWvTWIcaaOUKJK9YefEh4kefhALqdYjIAtCRbM-Wse-HqHsHVOelU^|^[email protected]^|^txn_id=75V94890TT065421G^|^payment_type=instant^|^payer_business_name=Jim Bodine''s Test Store^|^last_name=Bodine^|^address_state=CA^|^[email protected]^|^payment_fee=0.44^|^receiver_id=XZ5KX2Y9VM62A^|^txn_type=web_accept^|^item_name=One Time Ad^|^mc_currency=USD^|^item_number=^|^residence_country=US^|^test_ipn=1^|^handling_amount=0.00^|^transaction_subject=sub|1 month|3|4.99|One Time Ad|1|2009-09-11 13:02:40^|^payment_gross=4.99^|^shipping=0.00^|^cmd=_notify-validate');

CREATE TABLE IF NOT EXISTS `subscriptiontypes` (
`ID` int(10) unsigned NOT NULL auto_increment,
`NAME` varchar(45) NOT NULL,
`PRICE` varchar(1024) NOT NULL,
`displayname` varchar(128) default NULL,
`description` text,
PRIMARY KEY (`ID`)
)

INSERT INTO `subscriptiontypes` (`ID`, `NAME`, `PRICE`, `displayname`, `description`) VALUES
(1, 'NOACCESS', '0|0', NULL, NULL),
(2, 'TRIAL', '30|0|180|0|365|0', '30 Day Free Trial', 'We our offering, for a limited time a 30 day free trial to Find Us A Breeder.com. This will allow you a free 30day standard subscription which will allow you to check out the site and its standard features. Were quite confident that after the first 30 days, you will see a increase in leads and sales from us that you will be back to signup for one of our packages.'),
(3, 'ONETIME', '30|15.99', 'One Time Ad', 'Select this package if you have just one ad you would like to place on our currently avaiable puppy listing. This single ad will be viewable by all our customers. This package does not include the following that our other packages do such as being able to post upcoming litter listings, being able to post multiple ad''s, being able to post featureed ad''s nor does it include a listing in our breeders directory'),
(4, 'STANDARD', '30|9.99|180|49.99|360|95.99', 'Standard Breeder Packages', 'This is our standard breeder package option. You can choose to pay Monthy, Bi-Monthly or Yearly. This packages includes being able to post multiple ad''s in our available puppies section, a listing in our breeder listing, and the ability to post in our breeder services section(stud service listings).'),
(5, 'PREMIUM', '30|19.99|180|99.99|360|191.99', 'Premium Breeder Packages', 'This is our standard breeder package option. You can choose to pay Monthy, Bi-Monthly or Yearly. In addation to the standard options above it also inculdes being able to post multiple ad''s in our upcoming puppies section and the ability to flag one of your ad''s as a featured ad, which will including it on our home page as well as prominant area''s of all pages in teh website. Youre listings and profile will also be displayed as one of our premium breeders calling more attention to it then our standard ads.'),
(6, 'PREMIUM_WEB', '30|29.99|180|149.99|360|287.99', 'Custom Website + Premium Breeder Pack