CREATE TABLE partner_benefits (benefit_id INT(25) AUTO_INCREMENT, group_id INT(10), title VARCHAR(100), subtitle VARCHAR(100), bulletpoint VARCHAR(2500), date_created TIMESTAMP, PRIMARY KEY(benefit_id));

ALTER TABLE `partner_benefits` ADD CONSTRAINT fk_rpt_id FOREIGN KEY (rpt_id) REFERENCES report_params(rpt_id);

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint) VALUES (1, 73, "1. Cooperative Buying", "By definition, is a model that allows a group of buyers with
	a common interest to pool their buying power in order to negotiate more favorable pricing and better service. SPC' model allows
	you to pick your preferred vendor!",  "SPC' pricing is so strong we pay for our own fee by acquiring prices lower than what you 	can do on your own.");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint) VALUES (1, 73, "1. Cooperative Buying", "By definition, is a model that allows a group of buyers with
	a common interest to pool their buying power in order to negotiate more favorable pricing and better service. SPC' model allows
	you to pick your preferred vendor!",  "We will save you time by preparing your bid, negotiating with vendors/manufacturers, presenting a total bid analysis, and managing the implementation.");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint) VALUES (1, 73, "1. Cooperative Buying", "By definition, is a model that allows a group of buyers with
	a common interest to pool their buying power in order to negotiate more favorable pricing and better service. SPC' model allows
	you to pick your preferred vendor!",  "We will save you frustration. We manage your contracts for up to five years from the date of installation.");
	
	
INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (1, 76, "WHY IS IT NEEDED?", "With the recent pandemic, schools and businesses shut down. We are now seeing massive credits overall owed in the vicinity of $389,820.78!* However, your contracts stipulate that any unused service and supplies are to be refunded. While this may seem like good news to our clients, what if the vendor is unable or unwilling to repay those funds?  
Many companies outside of the copier industry are already filing for bankruptcy. SPC’s legitimate concern is, what if this hits the Copier Industry and we can no longer access
the funds owed to the client?", "");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (2, 76, "OTHER CONCERNS:", "",  "Vendor refuses to honor a Warranty");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (2, 76, "OTHER CONCERNS:", "",  "Equipment is no longer under a vendor Warranty ");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (2, 76, "OTHER CONCERNS:", "",  "Vendor refuses to honor a Service-and-Supply Contract at the agreed-upon pricing.");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (2, 76, "OTHER CONCERNS:", "",  "Vendor gets sold to a venture capitalist entity or to a risky new owner with limited cash reserves");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (3, 76, "PURPOSE:", "Since 1989, SPC’s goal is to shelter our clients from Industry upheavals. This fund is to set aside monies that can be used by any client, if a need arises.
<br>Funding Source: Initially, $200,000 no-interest personal loan. To be paid back from two sources…", "Wholesale Trades… For over 10 years these funds have been set aside for warranty replacement
units since the industry would provide the same cash price with or without the trade.");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (3, 76, "PURPOSE:", "Since 1989, SPC’s goal is to shelter our clients from Industry upheavals. This fund is to set aside monies that can be used by any client, if a need arises.
<br>Funding Source: Initially, $200,000 no-interest personal loan. To be paid back from two sources…", "Equipment Purchases… 2% of the gross will be set aside with each upgrade.");

INSERT INTO partner_benefits
(group_id, rpt_id, title, subtitle, bulletpoint)
VALUES (4, 76, "WHO BENEFITS:", "All SPC clients…like any insurance fund, by pooling funds from SPC’s entire client base, any losses are eliminated.",  "");













With the recent pandemic, schools and businesses shut down. We are now seeing massive credits overall owed in the vicinity of $389,820.78!<span style="color:red;">*</span> However, your contracts stipulate that any unused service and supplies are to be refunded. While this may seem like good news to our clients, what if the vendor is unable or unwilling to repay those funds?<br><br>  
Many companies outside of the copier industry are already filing for bankruptcy. SPC&apos; legitimate concern is, what if this hits the Copier Industry and we can no longer access
the funds owed to the client?