1
insert into saas_features(feature_key,display_name,entitlement_type,dependency_json) values
2
('core_service','Core Service','boolean','[]'),
3
('reservations','Reservations','boolean','[]'),
4
('kds','Kitchen Display','boolean','["core_service"]'),
5
('inventory','Inventory','boolean','["core_service"]'),
6
('purchasing','Purchasing','boolean','["inventory"]'),
7
('costing','Costing','boolean','["inventory"]'),
8
('operations','Operations','boolean','["core_service"]'),
9
('haccp','HACCP','boolean','["operations"]'),
10
('reporting','Reporting','boolean','["core_service"]'),
11
('multi_location','Multi-location','boolean','["core_service"]'),
12
('public_booking','Public Booking','boolean','["reservations"]'),
13
('wordpress','WordPress Booking','boolean','["public_booking"]'),
14
('reservation_integrations','Reservation Integrations','boolean','["reservations"]'),
15
('payment_integrations','Payment Integrations','boolean','["core_service"]'),
16
('fiscalization','Fiscalization','boolean','["core_service"]'),
17
('accounting','Accounting','boolean','["core_service"]'),
18
('pms','PMS Integration','boolean','["core_service"]'),
19
('external_pos','External POS','boolean','["core_service"]'),
20
('supplier_integrations','Supplier Integrations','boolean','["purchasing"]'),
21
('advanced_offline','Advanced Offline','boolean','["core_service"]'),
22
('max_locations','Maximum Locations','numeric_limit','[]'),
23
('max_active_users','Maximum Active Users','numeric_limit','[]'),
24
('max_wordpress_connections','Maximum WordPress Connections','numeric_limit','["wordpress"]'),
25
('max_reservation_integrations','Maximum Reservation Integrations','numeric_limit','["reservation_integrations"]'),
26
('max_payment_connections','Maximum Payment Connections','numeric_limit','["payment_integrations"]'),
27
('max_pms_connections','Maximum PMS Connections','numeric_limit','["pms"]')
28
on conflict(feature_key) do nothing;
29