-- ============================================================================
-- Optional starter values for the managed dropdown lists (the Configurations
-- page). Import this into a database that already has schema.sql applied, the
-- same way you imported the schema: in phpMyAdmin, select your database on the
-- left, then Import this file.
--
-- These are only sensible defaults so the app's dropdowns aren't empty on day
-- one — add, rename, or delete any of them freely in the app under
-- Configurations. Safe to re-run: INSERT IGNORE skips anything already present.
-- ============================================================================

INSERT IGNORE INTO managed_lists (list_key, value, sort_order) VALUES
  ('houses','H-1',1),('houses','H-2',2),('houses','H-3',3),('houses','H-4',4),('houses','H-5',5),('houses','H-6',6),
  ('breeds','Isa Brown',1),('breeds','Lohmann',2),('breeds','Hy-Line',3),('breeds','Cobb 500',4),('breeds','Ross 308',5),
  ('feedTypes','Layer mash',1),('feedTypes','Grower pellets',2),('feedTypes','Chick starter',3),('feedTypes','Oyster shell',4),('feedTypes','Finisher pellets',5),
  ('vets','Dr. Ssali',1),('vets','Dr. Namuli',2),('vets','External vet',3),
  ('vaccines','Newcastle (booster)',1),('vaccines','Infectious Bronchitis',2),('vaccines','Gumboro',3),('vaccines','Fowl Pox',4),('vaccines','Marek''s',5),
  ('vaccineRoutes','Drinking water',1),('vaccineRoutes','Eye drop',2),('vaccineRoutes','Injection',3),('vaccineRoutes','Spray',4),
  ('inventoryCategories','Equipment',1),('inventoryCategories','Packaging',2),('inventoryCategories','Medication',3),('inventoryCategories','Cleaning',4),('inventoryCategories','Spare parts',5),
  ('units','pcs',1),('units','kg',2),('units','L',3),('units','boxes',4),('units','bags',5),
  ('saleItems','Eggs (trays)',1),('saleItems','Eggs (pieces)',2),('saleItems','Spent hens',3),('saleItems','Day-old chicks',4),('saleItems','Manure (bags)',5),('saleItems','Point-of-lay pullets',6),
  ('expenseCategories','Feed',1),('expenseCategories','Medication',2),('expenseCategories','Utilities',3),('expenseCategories','Labour',4),('expenseCategories','Transport',5),('expenseCategories','Maintenance',6),('expenseCategories','Other',7),
  ('paymentMethods','Bank transfer',1),('paymentMethods','Mobile money',2),('paymentMethods','Cash',3),('paymentMethods','Cheque',4),
  ('roles','Farm Manager',1),('roles','Farm Worker',2),('roles','Store Keeper',3),('roles','Veterinarian',4),('roles','Driver',5),('roles','Accountant',6),
  ('departments','Production',1),('departments','Health',2),('departments','Inventory',3),('departments','Logistics',4),('departments','Finance',5),('departments','Admin',6);