🔧 Database Table Fix & Update
Step 1: Creating Missing Tables
Creating tables in correct order (customers before dishes)...
⏭ Table 'ingredients' already exists
⏭ Table 'customers' already exists
⏭ Table 'dishes' already exists
⏭ Table 'dish_bom' already exists
⏭ Table 'dish_cogs_history' already exists
⏭ Table 'purchase' already exists
⏭ Table 'customer_dishes' already exists
⏭ Table 'customer_bom' already exists
⏭ Table 'customer_cogs_history' already exists
Step 2: Updating Existing Tables
Checking 'dishes' table...
✓ 'customer_id' column already exists in dishes table
✓ 'last_updated' column already exists in ingredients table
Step 3: Verification
✅ Table 'ingredients' exists
✅ Table 'dishes' exists
✅ Table 'dish_bom' exists
✅ Table 'dish_cogs_history' exists
✅ Table 'purchase' exists
✅ Table 'customers' exists
✅ Table 'customer_dishes' exists
✅ Table 'customer_bom' exists
✅ Table 'customer_cogs_history' exists
✅ Column 'dishes.id' exists
✅ Column 'dishes.customer_id' exists
✅ Column 'dishes.name' exists
✅ Column 'dishes.category' exists
✅ Column 'dishes.selling_price' exists
✅ Column 'dishes.created_at' exists
✅ Column 'dishes.updated_at' exists
✅ Column 'ingredients.id' exists
✅ Column 'ingredients.name' exists
✅ Column 'ingredients.unit' exists
✅ Column 'ingredients.cost_per_unit' exists
✅ Column 'ingredients.last_updated' exists
✅ Column 'customers.id' exists
✅ Column 'customers.name' exists
✅ Column 'customers.address' exists
✅ Column 'customers.business_id' exists
✅ Column 'customers.business_id_type' exists
✅ Column 'customers.phone' exists
✅ Column 'customers.email' exists
📊 Summary