Alphaeus Mote 730553bffd Fix merchant categories duplicate key and fraud_types query column names ...

MERCHANT CATEGORIES FIX:

- Fixed duplicate category_code '7995' (Gambling vs Online Gambling)

- Changed Online Gambling code from '7995' to '7996'

- Fixed duplicate 'Direct Marketing' names to be unique

- Changed to 'Direct Marketing Inbound' and 'Direct Marketing Outbound'

- This was causing UNIQUE constraint violation preventing merchant_categories from loading

FRAUD TYPES QUERY FIX:

- Fixed column names in verification query

- Changed from fraud_type_code to fraud_code

- Changed from fraud_type_name to fraud_name

- Matches actual table schema in 01-create-tables.sql

IMPACT:

- Merchant categories will now load correctly (33 categories)

- Fraud types verification query will work without errors

- Setup script will complete all 5 verification queries successfully

2025-10-24 12:25:43 -04:00

..

01-create-tables.sql

Expand to Business Analytics: Add Customer, Sales, and KPI models

2025-10-23 14:17:12 -04:00

02-seed-data.sql

Fix merchant categories duplicate key and fraud_types query column names

2025-10-24 12:25:43 -04:00