Database Diff Report
Export PDF
Generated
2026-05-03 13:38:34 +0530
Source
localhost:3316/prod_ecommerce
Target
localhost:3317/dev_ecommerce
Version
v1.4.0-dev.20260503T080705Z.59ac4a3
DRIFT
Schema
7
Tables
+20
Added
-7
Removed
18
Modified
18
Conflicts
Schema
12
Data
6
Conflicts
18
feature_flags
New Table
i
Table 'feature_flags' exists in dev but not in prod
customers
Modified
~
email
Type changed: varchar(100) -> varchar(255)
orders
Modified
+
INDEX idx_customer_id
(customer_id)
−
INDEX customer_id
(customer_id)
products
Modified
+
discount_percent
Column added: discount_percent decimal(5,2)
Views
3 change(s)
+
v_customer_stats
View 'v_customer_stats' exists in dev but not in prod
−
v_customer_summary
View 'v_customer_summary' exists in prod but not in dev
~
v_active_orders
View definition changed
Routines
3 change(s)
+
FUNCTION: fn_format_price
FUNCTION 'fn_format_price' exists in dev but not in prod
~
fn_calculate_total
definition changed; parameters changed
~
fn_get_customer_tier
definition changed
Triggers
2 change(s)
+
trg_products_updated_at (table: products)
Trigger 'trg_products_updated_at' on table 'products' exists in dev but not in prod
~
trg_orders_audit
definition changed
All tables
audit_log
customers
inventory_log
order_items
orders
products
Table
Added
Removed
Modified
audit_log
(click to expand)
—
−7
—
Removed Keys:
8
9
7
10
3
4
6
customers
(click to expand)
+1
—
~5
Added Keys:
6
Modified Keys:
3
4
5
1
2
inventory_log
(click to expand)
+5
—
—
Added Keys:
7
8
9
10
6
order_items
(click to expand)
+6
—
—
Added Keys:
9
11
13
14
10
12
orders
(click to expand)
+5
—
~3
Added Keys:
10
6
7
8
9
Modified Keys:
4
5
3
products
(click to expand)
+3
—
~10
Added Keys:
13
11
12
Modified Keys:
1
3
5
7
8
2
4
6
9
10
All tables
orders
3
50e98d4f0d2f...
→
3bc0bb9da318...
Pending
orders
4
91c74b904980...
→
932e3c9169d2...
Pending
orders
5
579ea721981c...
→
f71fa3411956...
Pending
products
10
056fec0d5c80...
→
3ebc00ec928f...
Pending
products
1
91290ea738a1...
→
6a0483d92962...
Pending
products
3
8d56e3071d26...
→
f0a691c2fd9a...
Pending
products
5
809e6e458343...
→
d9e14527579f...
Pending
products
7
2c83bd23bb23...
→
0fceddb13a5d...
Pending
products
8
602de4ce149c...
→
74347a9a8653...
Pending
products
2
bf9d32823bd2...
→
0c78ab070b93...
Pending
products
4
0a4bb61bbee7...
→
d86101d3905a...
Pending
products
6
131705dda71e...
→
fd58eb3590d5...
Pending
products
9
b58fe1a5cd09...
→
8fc3ad499b63...
Pending
customers
2
99cac2a7c695...
→
0a949f3c2ddf...
Pending
customers
3
8f56cdab82c9...
→
2a3cf69f64dc...
Pending
customers
4
b4257f97cc9f...
→
a16b7ce17528...
Pending
customers
5
2014b0374b60...
→
7f8723118572...
Pending
customers
1
f30811df6706...
→
dcb1c5d6e44a...
Pending