Skip to main content

Generate SQL Insert statements

User

generate sql insert statements for the tables, for dummy or synthetic data 5-10 records

Cursor

I'll generate SQL INSERT statements with dummy/synthetic data for each table. Let me create a new file with realistic test data for 5-10 records per table.

/* Sample INSERT statements for SuiteCRM tables with dummy/synthetic data */

-- Insert sample data for accounts table
INSERT INTO accounts (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, account_type, industry, annual_revenue, phone_fax, billing_address_street, billing_address_city, billing_address_state, billing_address_postalcode, billing_address_country, rating, phone_office, phone_alternate, website, ownership, employees, ticker_symbol, shipping_address_street, shipping_address_city, shipping_address_state, shipping_address_postalcode, shipping_address_country, parent_id, sic_code, campaign_id) VALUES
('550e8400-e29b-41d4-a716-446655440001', 'Acme Corporation', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Leading technology solutions provider', '0', 'user001', 'Customer', 'Technology', '10000000', '555-0101', '123 Business Ave', 'San Francisco', 'CA', '94105', 'United States', 'Hot', '555-0100', '555-0102', 'https://acme.com', 'Private', '500', 'ACME', '123 Business Ave', 'San Francisco', 'CA', '94105', 'United States', NULL, '7372', 'camp001'),
('550e8400-e29b-41d4-a716-446655440002', 'Global Industries Ltd', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'International manufacturing company', '0', 'user002', 'Customer', 'Manufacturing', '50000000', '555-0201', '456 Industrial Blvd', 'Chicago', 'IL', '60601', 'United States', 'Warm', '555-0200', '555-0202', 'https://globalind.com', 'Public', '2000', 'GLBL', '456 Industrial Blvd', 'Chicago', 'IL', '60601', 'United States', NULL, '3089', 'camp002'),
('550e8400-e29b-41d4-a716-446655440003', 'TechStart Inc', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Startup software development company', '0', 'user003', 'Prospect', 'Software', '2000000', '555-0301', '789 Innovation St', 'Austin', 'TX', '73301', 'United States', 'Cold', '555-0300', '555-0302', 'https://techstart.io', 'Private', '25', 'TECH', '789 Innovation St', 'Austin', 'TX', '73301', 'United States', NULL, '7372', 'camp003'),
('550e8400-e29b-41d4-a716-446655440004', 'Healthcare Partners', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Medical services and equipment provider', '0', 'user001', 'Customer', 'Healthcare', '25000000', '555-0401', '321 Medical Plaza', 'Boston', 'MA', '02101', 'United States', 'Hot', '555-0400', '555-0402', 'https://healthpartners.com', 'Private', '1200', 'HLTH', '321 Medical Plaza', 'Boston', 'MA', '02101', 'United States', NULL, '8011', 'camp001'),
('550e8400-e29b-41d4-a716-446655440005', 'Financial Services Group', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'Investment and banking services', '0', 'user002', 'Customer', 'Financial Services', '100000000', '555-0501', '654 Wall Street', 'New York', 'NY', '10005', 'United States', 'Warm', '555-0500', '555-0502', 'https://fsgroup.com', 'Public', '5000', 'FSGR', '654 Wall Street', 'New York', 'NY', '10005', 'United States', NULL, '6021', 'camp002');

-- Insert sample data for contacts table
INSERT INTO contacts (id, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, salutation, first_name, last_name, title, photo, department, do_not_call, phone_home, phone_mobile, phone_work, phone_other, phone_fax, lawful_basis, date_reviewed, lawful_basis_source, primary_address_street, primary_address_city, primary_address_state, primary_address_postalcode, primary_address_country, alt_address_street, alt_address_city, alt_address_state, alt_address_postalcode, alt_address_country, assistant, assistant_phone, lead_source, reports_to_id, birthdate, campaign_id, joomla_account_id) VALUES
('550e8400-e29b-41d4-a716-446655440101', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Primary contact for Acme Corporation', '0', 'user001', 'Mr.', 'John', 'Smith', 'CEO', NULL, 'Executive', '0', '555-1001', '555-1002', '555-1000', '555-1003', '555-1004', 'Consent', '2024-01-15 09:30:00', 'Website', '123 Business Ave', 'San Francisco', 'CA', '94105', 'United States', '456 Home St', 'San Francisco', 'CA', '94102', 'United States', 'Sarah Johnson', '555-1005', 'Website', NULL, '1980-05-15 00:00:00', 'camp001', NULL),
('550e8400-e29b-41d4-a716-446655440102', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'CTO at Global Industries', '0', 'user002', 'Dr.', 'Maria', 'Garcia', 'CTO', NULL, 'Technology', '0', '555-2001', '555-2002', '555-2000', '555-2003', '555-2004', 'Legitimate Interest', '2024-01-16 10:15:00', 'Trade Show', '456 Industrial Blvd', 'Chicago', 'IL', '60601', 'United States', '789 Residential Ave', 'Chicago', 'IL', '60602', 'United States', 'Mike Wilson', '555-2005', 'Trade Show', NULL, '1975-08-22 00:00:00', 'camp002', NULL),
('550e8400-e29b-41d4-a716-446655440103', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Founder of TechStart Inc', '0', 'user003', 'Ms.', 'Emily', 'Chen', 'Founder', NULL, 'Executive', '0', '555-3001', '555-3002', '555-3000', '555-3003', '555-3004', 'Consent', '2024-01-17 11:00:00', 'Email', '789 Innovation St', 'Austin', 'TX', '73301', 'United States', '321 Startup Blvd', 'Austin', 'TX', '73302', 'United States', 'Alex Rodriguez', '555-3005', 'Email', NULL, '1985-12-10 00:00:00', 'camp003', NULL),
('550e8400-e29b-41d4-a716-446655440104', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Medical Director at Healthcare Partners', '0', 'user001', 'Dr.', 'Robert', 'Johnson', 'Medical Director', NULL, 'Medical', '0', '555-4001', '555-4002', '555-4000', '555-4003', '555-4004', 'Consent', '2024-01-18 14:30:00', 'Referral', '321 Medical Plaza', 'Boston', 'MA', '02101', 'United States', '654 Health St', 'Boston', 'MA', '02102', 'United States', 'Lisa Brown', '555-4005', 'Referral', NULL, '1970-03-18 00:00:00', 'camp001', NULL),
('550e8400-e29b-41d4-a716-446655440105', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'CFO at Financial Services Group', '0', 'user002', 'Mr.', 'David', 'Williams', 'CFO', NULL, 'Finance', '0', '555-5001', '555-5002', '555-5000', '555-5003', '555-5004', 'Legitimate Interest', '2024-01-19 16:45:00', 'Cold Call', '654 Wall Street', 'New York', 'NY', '10005', 'United States', '987 Finance Ave', 'New York', 'NY', '10006', 'United States', 'Jennifer Davis', '555-5005', 'Cold Call', NULL, '1968-11-25 00:00:00', 'camp002', NULL);

-- Insert sample data for opportunities table
INSERT INTO opportunities (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, opportunity_type, campaign_id, lead_source, amount, amount_usdollar, currency_id, date_closed, next_step, sales_stage, probability) VALUES
('550e8400-e29b-41d4-a716-446655440201', 'Enterprise Software License', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Annual software license renewal for Acme Corp', '0', 'user001', 'New Business', 'camp001', 'Website', 50000.00, 50000.00, 'USD', '2024-03-31 00:00:00', 'Send proposal', 'Proposal/Price Quote', 75.00),
('550e8400-e29b-41d4-a716-446655440202', 'Manufacturing System Upgrade', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'Complete system upgrade for Global Industries', '0', 'user002', 'Existing Business', 'camp002', 'Trade Show', 150000.00, 150000.00, 'USD', '2024-04-30 00:00:00', 'Technical evaluation', 'Qualification', 60.00),
('550e8400-e29b-41d4-a716-446655440203', 'Startup Software Package', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Basic software package for TechStart Inc', '0', 'user003', 'New Business', 'camp003', 'Email', 15000.00, 15000.00, 'USD', '2024-02-28 00:00:00', 'Demo scheduled', 'Needs Analysis', 40.00),
('550e8400-e29b-41d4-a716-446655440204', 'Medical Equipment Contract', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Medical equipment supply contract', '0', 'user001', 'New Business', 'camp001', 'Referral', 75000.00, 75000.00, 'USD', '2024-05-15 00:00:00', 'Contract review', 'Proposal/Price Quote', 80.00),
('550e8400-e29b-41d4-a716-446655440205', 'Financial Services Platform', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'Custom financial platform development', '0', 'user002', 'Existing Business', 'camp002', 'Cold Call', 300000.00, 300000.00, 'USD', '2024-06-30 00:00:00', 'Requirements gathering', 'Qualification', 50.00);

-- Insert sample data for cases table
INSERT INTO cases (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, case_number, type, status, priority, resolution, work_log, account_id, state, contact_created_by_id) VALUES
('550e8400-e29b-41d4-a716-446655440301', 'Software Installation Issue', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Customer experiencing installation problems with latest software version', '0', 'user001', 1001, 'Problem', 'Open', 'High', NULL, 'Initial contact made, gathering system information', '550e8400-e29b-41d4-a716-446655440001', 'Open', '550e8400-e29b-41d4-a716-446655440101'),
('550e8400-e29b-41d4-a716-446655440302', 'Performance Optimization Request', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'Customer requesting system performance improvements', '0', 'user002', 1002, 'Question', 'In Progress', 'Medium', NULL, 'Analyzing current system performance metrics', '550e8400-e29b-41d4-a716-446655440002', 'In Progress', '550e8400-e29b-41d4-a716-446655440102'),
('550e8400-e29b-41d4-a716-446655440303', 'Feature Enhancement Request', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Startup requesting additional features for their package', '0', 'user003', 1003, 'Feature Request', 'New', 'Low', NULL, 'Feature request submitted for product team review', '550e8400-e29b-41d4-a716-446655440003', 'New', '550e8400-e29b-41d4-a716-446655440103'),
('550e8400-e29b-41d4-a716-446655440304', 'Medical Compliance Issue', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Healthcare client needs compliance documentation', '0', 'user001', 1004, 'Compliance', 'Escalated', 'High', NULL, 'Escalated to compliance team for review', '550e8400-e29b-41d4-a716-446655440004', 'Escalated', '550e8400-e29b-41d4-a716-446655440104'),
('550e8400-e29b-41d4-a716-446655440305', 'Security Audit Request', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'Financial services client requesting security audit', '0', 'user002', 1005, 'Security', 'Closed', 'High', 'Security audit completed successfully', 'Security audit completed with no issues found', '550e8400-e29b-41d4-a716-446655440005', 'Closed', '550e8400-e29b-41d4-a716-446655440105');

-- Insert sample data for aos_quotes table
INSERT INTO aos_quotes (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, approval_issue, billing_account_id, billing_contact_id, billing_address_street, billing_address_city, billing_address_state, billing_address_postalcode, billing_address_country, shipping_address_street, shipping_address_city, shipping_address_state, shipping_address_postalcode, shipping_address_country, expiration, number, opportunity_id, template_ddown_c, total_amt, total_amt_usdollar, subtotal_amount, subtotal_amount_usdollar, discount_amount, discount_amount_usdollar, tax_amount, tax_amount_usdollar, shipping_amount, shipping_amount_usdollar, shipping_tax, shipping_tax_amt, shipping_tax_amt_usdollar, total_amount) VALUES
('550e8400-e29b-41d4-a716-446655440401', 'Quote-2024-001', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Annual software license quote for Acme Corporation', '0', 'user001', NULL, '550e8400-e29b-41d4-a716-446655440001', '550e8400-e29b-41d4-a716-446655440101', '123 Business Ave', 'San Francisco', 'CA', '94105', 'United States', '123 Business Ave', 'San Francisco', 'CA', '94105', 'United States', '2024-02-15 00:00:00', 1, '550e8400-e29b-41d4-a716-446655440201', NULL, 50000.00, 50000.00, 45000.00, 45000.00, 5000.00, 5000.00, 4500.00, 4500.00, 0.00, 0.00, '0%', 0.00, 0.00, 50000.00),
('550e8400-e29b-41d4-a716-446655440402', 'Quote-2024-002', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'Manufacturing system upgrade quote for Global Industries', '0', 'user002', NULL, '550e8400-e29b-41d4-a716-446655440002', '550e8400-e29b-41d4-a716-446655440102', '456 Industrial Blvd', 'Chicago', 'IL', '60601', 'United States', '456 Industrial Blvd', 'Chicago', 'IL', '60601', 'United States', '2024-02-16 00:00:00', 2, '550e8400-e29b-41d4-a716-446655440202', NULL, 150000.00, 150000.00, 135000.00, 135000.00, 15000.00, 15000.00, 13500.00, 13500.00, 0.00, 0.00, '0%', 0.00, 0.00, 150000.00),
('550e8400-e29b-41d4-a716-446655440403', 'Quote-2024-003', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Startup software package quote for TechStart Inc', '0', 'user003', NULL, '550e8400-e29b-41d4-a716-446655440003', '550e8400-e29b-41d4-a716-446655440103', '789 Innovation St', 'Austin', 'TX', '73301', 'United States', '789 Innovation St', 'Austin', 'TX', '73301', 'United States', '2024-02-17 00:00:00', 3, '550e8400-e29b-41d4-a716-446655440203', NULL, 15000.00, 15000.00, 13500.00, 13500.00, 1500.00, 1500.00, 1350.00, 1350.00, 0.00, 0.00, '0%', 0.00, 0.00, 15000.00),
('550e8400-e29b-41d4-a716-446655440404', 'Quote-2024-004', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Medical equipment contract quote for Healthcare Partners', '0', 'user001', NULL, '550e8400-e29b-41d4-a716-446655440004', '550e8400-e29b-41d4-a716-446655440104', '321 Medical Plaza', 'Boston', 'MA', '02101', 'United States', '321 Medical Plaza', 'Boston', 'MA', '02101', 'United States', '2024-02-18 00:00:00', 4, '550e8400-e29b-41d4-a716-446655440204', NULL, 75000.00, 75000.00, 67500.00, 67500.00, 7500.00, 7500.00, 6750.00, 6750.00, 0.00, 0.00, '0%', 0.00, 0.00, 75000.00),
('550e8400-e29b-41d4-a716-446655440405', 'Quote-2024-005', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'Financial services platform quote for Financial Services Group', '0', 'user002', NULL, '550e8400-e29b-41d4-a716-446655440005', '550e8400-e29b-41d4-a716-446655440105', '654 Wall Street', 'New York', 'NY', '10005', 'United States', '654 Wall Street', 'New York', 'NY', '10005', 'United States', '2024-02-19 00:00:00', 5, '550e8400-e29b-41d4-a716-446655440205', NULL, 300000.00, 300000.00, 270000.00, 270000.00, 30000.00, 30000.00, 27000.00, 27000.00, 0.00, 0.00, '0%', 0.00, 0.00, 300000.00);

-- Insert sample data for aos_products_quotes table
INSERT INTO aos_products_quotes (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, currency_id, part_number, item_description, number, product_qty, product_cost_price, product_cost_price_usdollar, product_list_price, product_list_price_usdollar, product_discount, product_discount_usdollar, product_discount_amount, product_discount_amount_usdollar, discount, product_unit_price, product_unit_price_usdollar, vat_amt, vat_amt_usdollar, product_total_price, product_total_price_usdollar, vat, parent_type, parent_id, product_id, group_id) VALUES
('550e8400-e29b-41d4-a716-446655440501', 'Enterprise License - 100 Users', '2024-01-15 09:30:00', '2024-01-15 09:30:00', 'user001', 'user001', 'Annual enterprise software license for 100 concurrent users', '0', 'user001', 'USD', 'ENT-100', 'Enterprise Software License - 100 Users', 1, 1.000000, 30000.000000, 30000.000000, 50000.000000, 50000.000000, 10.000000, 10.000000, 5000.000000, 5000.000000, '10%', 45000.000000, 45000.000000, 4500.000000, 4500.000000, 50000.000000, 50000.000000, '10%', 'AOS_Quotes', '550e8400-e29b-41d4-a716-446655440401', 'prod001', NULL),
('550e8400-e29b-41d4-a716-446655440502', 'Manufacturing System - Pro', '2024-01-16 10:15:00', '2024-01-16 10:15:00', 'user002', 'user002', 'Professional manufacturing management system', '0', 'user002', 'USD', 'MFG-PRO', 'Manufacturing System Professional Edition', 1, 1.000000, 90000.000000, 90000.000000, 150000.000000, 150000.000000, 10.000000, 10.000000, 15000.000000, 15000.000000, '10%', 135000.000000, 135000.000000, 13500.000000, 13500.000000, 150000.000000, 150000.000000, '10%', 'AOS_Quotes', '550e8400-e29b-41d4-a716-446655440402', 'prod002', NULL),
('550e8400-e29b-41d4-a716-446655440503', 'Startup Package - Basic', '2024-01-17 11:00:00', '2024-01-17 11:00:00', 'user003', 'user003', 'Basic software package for startup companies', '0', 'user003', 'USD', 'STU-BASIC', 'Startup Software Package - Basic', 1, 1.000000, 9000.000000, 9000.000000, 15000.000000, 15000.000000, 10.000000, 10.000000, 1500.000000, 1500.000000, '10%', 13500.000000, 13500.000000, 1350.000000, 1350.000000, 15000.000000, 15000.000000, '10%', 'AOS_Quotes', '550e8400-e29b-41d4-a716-446655440403', 'prod003', NULL),
('550e8400-e29b-41d4-a716-446655440504', 'Medical Equipment - Standard', '2024-01-18 14:30:00', '2024-01-18 14:30:00', 'user001', 'user001', 'Standard medical equipment package', '0', 'user001', 'USD', 'MED-STD', 'Medical Equipment Standard Package', 1, 1.000000, 45000.000000, 45000.000000, 75000.000000, 75000.000000, 10.000000, 10.000000, 7500.000000, 7500.000000, '10%', 67500.000000, 67500.000000, 6750.000000, 6750.000000, 75000.000000, 75000.000000, '10%', 'AOS_Quotes', '550e8400-e29b-41d4-a716-446655440404', 'prod004', NULL),
('550e8400-e29b-41d4-a716-446655440505', 'Financial Platform - Enterprise', '2024-01-19 16:45:00', '2024-01-19 16:45:00', 'user002', 'user002', 'Enterprise financial services platform', '0', 'user002', 'USD', 'FIN-ENT', 'Financial Platform Enterprise Edition', 1, 1.000000, 180000.000000, 180000.000000, 300000.000000, 300000.000000, 10.000000, 10.000000, 30000.000000, 30000.000000, '10%', 270000.000000, 270000.000000, 27000.000000, 27000.000000, 300000.000000, 300000.000000, '10%', 'AOS_Quotes', '550e8400-e29b-41d4-a716-446655440405', 'prod005', NULL);

-- Insert sample data for junction tables

-- accounts_contacts junction table
INSERT INTO accounts_contacts (id, contact_id, account_id, date_modified, deleted) VALUES
('550e8400-e29b-41d4-a716-446655440601', '550e8400-e29b-41d4-a716-446655440101', '550e8400-e29b-41d4-a716-446655440001', '2024-01-15 09:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440602', '550e8400-e29b-41d4-a716-446655440102', '550e8400-e29b-41d4-a716-446655440002', '2024-01-16 10:15:00', '0'),
('550e8400-e29b-41d4-a716-446655440603', '550e8400-e29b-41d4-a716-446655440103', '550e8400-e29b-41d4-a716-446655440003', '2024-01-17 11:00:00', '0'),
('550e8400-e29b-41d4-a716-446655440604', '550e8400-e29b-41d4-a716-446655440104', '550e8400-e29b-41d4-a716-446655440004', '2024-01-18 14:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440605', '550e8400-e29b-41d4-a716-446655440105', '550e8400-e29b-41d4-a716-446655440005', '2024-01-19 16:45:00', '0');

-- accounts_opportunities junction table
INSERT INTO accounts_opportunities (id, opportunity_id, account_id, date_modified, deleted) VALUES
('550e8400-e29b-41d4-a716-446655440701', '550e8400-e29b-41d4-a716-446655440201', '550e8400-e29b-41d4-a716-446655440001', '2024-01-15 09:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440702', '550e8400-e29b-41d4-a716-446655440202', '550e8400-e29b-41d4-a716-446655440002', '2024-01-16 10:15:00', '0'),
('550e8400-e29b-41d4-a716-446655440703', '550e8400-e29b-41d4-a716-446655440203', '550e8400-e29b-41d4-a716-446655440003', '2024-01-17 11:00:00', '0'),
('550e8400-e29b-41d4-a716-446655440704', '550e8400-e29b-41d4-a716-446655440204', '550e8400-e29b-41d4-a716-446655440004', '2024-01-18 14:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440705', '550e8400-e29b-41d4-a716-446655440205', '550e8400-e29b-41d4-a716-446655440005', '2024-01-19 16:45:00', '0');

-- contacts_cases junction table
INSERT INTO contacts_cases (id, contact_id, case_id, contact_role, date_modified, deleted) VALUES
('550e8400-e29b-41d4-a716-446655440801', '550e8400-e29b-41d4-a716-446655440101', '550e8400-e29b-41d4-a716-446655440301', 'Primary Contact', '2024-01-15 09:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440802', '550e8400-e29b-41d4-a716-446655440102', '550e8400-e29b-41d4-a716-446655440302', 'Primary Contact', '2024-01-16 10:15:00', '0'),
('550e8400-e29b-41d4-a716-446655440803', '550e8400-e29b-41d4-a716-446655440103', '550e8400-e29b-41d4-a716-446655440303', 'Primary Contact', '2024-01-17 11:00:00', '0'),
('550e8400-e29b-41d4-a716-446655440804', '550e8400-e29b-41d4-a716-446655440104', '550e8400-e29b-41d4-a716-446655440304', 'Primary Contact', '2024-01-18 14:30:00', '0'),
('550e8400-e29b-41d4-a716-446655440805', '550e8400-e29b-41d4-a716-446655440105', '550e8400-e29b-41d4-a716-446655440305', 'Primary Contact', '2024-01-19 16:45:00', '0');

-- aop_case_updates table
INSERT INTO aop_case_updates (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, assigned_user_id, case_id, contact_id, internal) VALUES
('550e8400-e29b-41d4-a716-446655440901', 'Initial Response', '2024-01-15 10:00:00', '2024-01-15 10:00:00', 'user001', 'user001', 'Initial response sent to customer regarding installation issue', '0', 'user001', '550e8400-e29b-41d4-a716-446655440301', '550e8400-e29b-41d4-a716-446655440101', '0'),
('550e8400-e29b-41d4-a716-446655440902', 'System Analysis Complete', '2024-01-16 11:00:00', '2024-01-16 11:00:00', 'user002', 'user002', 'Performance analysis completed, recommendations provided', '0', 'user002', '550e8400-e29b-41d4-a716-446655440302', '550e8400-e29b-41d4-a716-446655440102', '0'),
('550e8400-e29b-41d4-a716-446655440903', 'Feature Request Submitted', '2024-01-17 12:00:00', '2024-01-17 12:00:00', 'user003', 'user003', 'Feature request forwarded to product development team', '0', 'user003', '550e8400-e29b-41d4-a716-446655440303', '550e8400-e29b-41d4-a716-446655440103', '0'),
('550e8400-e29b-41d4-a716-446655440904', 'Compliance Review', '2024-01-18 15:00:00', '2024-01-18 15:00:00', 'user001', 'user001', 'Compliance documentation prepared and sent to client', '0', 'user001', '550e8400-e29b-41d4-a716-446655440304', '550e8400-e29b-41d4-a716-446655440104', '0'),
('550e8400-e29b-41d4-a716-446655440905', 'Security Audit Complete', '2024-01-19 17:00:00', '2024-01-19 17:00:00', 'user002', 'user002', 'Security audit completed successfully with no issues found', '0', 'user002', '550e8400-e29b-41d4-a716-446655440305', '550e8400-e29b-41d4-a716-446655440105', '0');

I've successfully generated comprehensive SQL INSERT statements with realistic dummy/synthetic data for all SuiteCRM tables. Here's what I've created:

Sample Data Summary:​

Core Tables (5 records each):​

  1. accounts - 5 companies across different industries (Technology, Manufacturing, Software, Healthcare, Financial Services)
  2. contacts - 5 contacts with realistic names, titles, and contact information
  3. opportunities - 5 sales opportunities with different stages and amounts
  4. cases - 5 support cases with various types and statuses
  5. aos_quotes - 5 quotes linked to opportunities
  6. aos_products_quotes - 5 product line items for the quotes

Junction Tables (5 records each):​

  1. accounts_contacts - Links accounts to their primary contacts
  2. accounts_opportunities - Links accounts to their opportunities
  3. contacts_cases - Links contacts to support cases

Additional Tables:​

  1. aop_case_updates - 5 case update records with realistic descriptions

Key Features of the Sample Data:​

  • Realistic Business Scenarios: Companies from different industries with appropriate contact information
  • Proper Relationships: All foreign key relationships are maintained with consistent UUIDs
  • Diverse Data: Different sales stages, case types, priorities, and amounts
  • Geographic Diversity: Companies from different US cities (San Francisco, Chicago, Austin, Boston, New York)
  • Temporal Consistency: All dates are logically sequenced and realistic
  • Financial Data: Proper pricing, discounts, taxes, and currency handling
  • Contact Information: Complete phone numbers, addresses, and professional details

The data is designed to be realistic and useful for testing SuiteCRM functionality, including sales pipeline management, customer support, and reporting features.