USE b2b_courier;

INSERT INTO saas_plans
(plan_name,plan_code,billing_cycle,price,max_users,max_shipments,max_clients)
VALUES
('Starter','STARTER','monthly',1999.00,5,1000,50),
('Professional','PRO','monthly',4999.00,20,10000,500),
('Enterprise','ENTERPRISE','yearly',49999.00,100,100000,5000),
('Lifetime','LIFETIME','lifetime',199999.00,500,1000000,10000);

INSERT INTO saas_modules(module_name,module_code,description) VALUES
('Dashboard','DASHBOARD','Dashboard and analytics'),
('Client Management','CLIENTS','Manage business clients'),
('Courier Management','COURIERS','Manage courier partners'),
('Pincode Management','PINCODE','Manage Indian pincodes'),
('Zone Management','ZONES','Manage shipping zones'),
('Rate Management','RATES','Manage shipping rate cards'),
('Shipment Management','SHIPMENTS','Manage shipments'),
('Courier Allocation','ALLOCATION','Automatic courier selection'),
('Tracking','TRACKING','Shipment tracking'),
('NDR Management','NDR','Non delivery management'),
('RTO Management','RTO','Return to origin management'),
('COD Management','COD','COD reconciliation'),
('Wallet','WALLET','Prepaid wallet'),
('Billing','BILLING','Postpaid billing and invoices'),
('Reports','REPORTS','Business reports'),
('API Integration','API','REST API integrations'),
('User Management','USERS','Manage tenant users');

INSERT INTO saas_plan_modules(plan_id,module_id,is_enabled)
SELECT p.id,m.id,1 FROM saas_plans p CROSS JOIN saas_modules m;
