USE numis_acquisition;

INSERT IGNORE INTO countries (country_name, region, currency_code, enabled, created_at) VALUES
('Malaysia','Southeast Asia','MYR',1,NOW()),
('Singapore','Southeast Asia','SGD',1,NOW()),
('Philippines','Southeast Asia','PHP',1,NOW()),
('Indonesia','Southeast Asia','IDR',1,NOW()),
('Vietnam','Southeast Asia','VND',1,NOW()),
('United Arab Emirates','Middle East & Asia','AED',1,NOW()),
('Pakistan','Middle East & Asia','PKR',1,NOW()),
('Turkey','Middle East & Asia','TRY',1,NOW()),
('Uzbekistan','Middle East & Asia','UZS',1,NOW()),
('Japan','Middle East & Asia','JPY',1,NOW()),
('India','Middle East & Asia','INR',1,NOW()),
('United Kingdom','Europe','GBP',1,NOW()),
('France','Europe','EUR',1,NOW()),
('Germany','Europe','EUR',1,NOW()),
('Italy','Europe','EUR',1,NOW()),
('United States','North America','USD',1,NOW()),
('Canada','North America','CAD',1,NOW()),
('Mexico','North America','MXN',1,NOW()),
('Australia','Oceania','AUD',1,NOW());

INSERT INTO faq_items (question, answer, position, published) VALUES
('Is there a fee to submit an item?','No. Submitting an item for review does not require an activation fee, customs charge, or advance payment.',1,1),
('How are valuations prepared?','Our specialists assess the item details, condition, authenticity indicators, rarity, and current market demand. A submission is not a guarantee of purchase.',2,1),
('What happens after I submit?','You can follow the review status from your account. If we can make an offer, it will appear in your secure account with the next steps.',3,1),
('Which countries do you support?','We welcome enquiries from supported countries across Southeast Asia, the Middle East, Asia, Europe, and North America. Availability depends on local law and shipping requirements.',4,1);

INSERT IGNORE INTO content_pages (slug, title, body, updated_at) VALUES
('about','About Numis Acquisition','We connect collectors and estates with experienced specialists in historic coinage and banknotes. Every enquiry is reviewed individually, with clear communication and no obligation to accept an offer.',NOW()),
('terms','Terms & Conditions','Submitting an item requests an assessment and does not create a purchase agreement. A sale proceeds only after both parties agree to written terms and any applicable identity, export, and compliance checks are complete.',NOW()),
('privacy','Privacy Policy','We use account and submission information to assess items, communicate with sellers, maintain security, and meet legal obligations. Identity records are access-controlled and retained only as required by applicable law.',NOW());