-- ============================================================
-- Biz2Biz Chamber - Seed Data
-- ============================================================

-- Categories
INSERT INTO categories (name, slug, description, icon) VALUES
('Technology', 'technology', 'Software, hardware, IT services', 'laptop'),
('Healthcare', 'healthcare', 'Medical, dental, wellness providers', 'heart'),
('Finance', 'finance', 'Banking, accounting, insurance, investments', 'dollar-sign'),
('Real Estate', 'real-estate', 'Residential and commercial real estate', 'home'),
('Legal Services', 'legal-services', 'Attorneys, law firms, legal consultants', 'briefcase'),
('Marketing & Advertising', 'marketing-advertising', 'Digital marketing, PR, advertising agencies', 'megaphone'),
('Construction', 'construction', 'Contractors, builders, architects', 'tool'),
('Food & Beverage', 'food-beverage', 'Restaurants, catering, food production', 'coffee'),
('Retail', 'retail', 'Brick and mortar and online retail', 'shopping-bag'),
('Education', 'education', 'Schools, tutoring, professional training', 'book'),
('Manufacturing', 'manufacturing', 'Production, fabrication, assembly', 'settings'),
('Transportation', 'transportation', 'Logistics, trucking, delivery services', 'truck'),
('Non-Profit', 'non-profit', 'Charities, foundations, associations', 'users'),
('Hospitality', 'hospitality', 'Hotels, events, travel, tourism', 'map'),
('Professional Services', 'professional-services', 'Consulting, staffing, business services', 'user-check');

-- Agreement Templates
INSERT INTO agreement_templates (title, template_type, content, is_public) VALUES
('Standard Non-Disclosure Agreement', 'NDA', '# NON-DISCLOSURE AGREEMENT\n\nThis Non-Disclosure Agreement ("Agreement") is entered into as of [DATE] between [PARTY A] and [PARTY B].\n\n## 1. CONFIDENTIAL INFORMATION\nFor purposes of this Agreement, "Confidential Information" means any data or information that is proprietary to the Disclosing Party...\n\n## 2. OBLIGATIONS\nThe Receiving Party agrees to hold the Confidential Information in strict confidence...\n\n## 3. TERM\nThis Agreement shall remain in effect for a period of two (2) years from the date of signing.\n\nIN WITNESS WHEREOF, the parties have executed this Agreement as of the date first written above.\n\n[SIGNATURES]', TRUE),
('Service Agreement', 'service', '# SERVICE AGREEMENT\n\nThis Service Agreement ("Agreement") is entered into as of [DATE] between [CLIENT] ("Client") and [PROVIDER] ("Service Provider").\n\n## 1. SERVICES\nService Provider agrees to perform the following services: [DESCRIPTION OF SERVICES]\n\n## 2. COMPENSATION\nClient agrees to pay Service Provider [AMOUNT] for the services described herein.\n\n## 3. TERM\nThis Agreement shall commence on [START DATE] and continue until [END DATE].\n\n[SIGNATURES]', TRUE),
('Vendor Agreement', 'vendor', '# VENDOR AGREEMENT\n\nThis Vendor Agreement is entered into as of [DATE] between [COMPANY] and [VENDOR].\n\n## 1. PRODUCTS/SERVICES\nVendor agrees to supply the following: [DESCRIPTION]\n\n## 2. PAYMENT TERMS\nPayment terms: [TERMS]\n\n## 3. DELIVERY\nAll deliveries shall be completed by: [DATE]\n\n[SIGNATURES]', TRUE),
('Partnership Agreement', 'partnership', '# PARTNERSHIP AGREEMENT\n\nThis Partnership Agreement is entered into as of [DATE] between [PARTNER 1] and [PARTNER 2].\n\n## 1. PURPOSE\nThe purpose of this partnership is: [PURPOSE]\n\n## 2. PROFIT SHARING\nProfits and losses shall be shared as follows: [TERMS]\n\n## 3. DURATION\nThis partnership shall commence on [DATE] and continue until dissolved.\n\n[SIGNATURES]', TRUE);

-- Testimonials
INSERT INTO testimonials (name, title, company, content, rating, is_featured) VALUES
('Sarah Mitchell', 'CEO', 'TechVision Solutions', 'Joining Biz2Biz Chamber was the best decision for our business growth. We connected with 15 new partners in our first month alone!', 5, TRUE),
('Marcus Thompson', 'Owner', 'Thompson Construction Group', 'The digital directory and networking tools have completely transformed how we find and connect with potential clients. Highly recommend!', 5, TRUE),
('Jennifer Rodriguez', 'Marketing Director', 'Pinnacle Healthcare', 'The press release distribution feature helped us reach thousands of potential patients. Our visibility has increased by 300%!', 5, TRUE),
('David Chen', 'Founder', 'InnovateTech LLC', 'The CRM integration and loyalty program tools are incredible. We managed to retain 40% more customers after joining.', 5, TRUE),
('Angela Williams', 'President', 'Williams Law Group', 'The digital agreements platform alone is worth the membership. We saved thousands in legal paperwork costs.', 5, TRUE),
('Robert Kim', 'Director', 'Summit Financial Services', 'Best investment we made for our business. The event platform helped us host our first webinar with 200+ attendees.', 5, FALSE);
