-- 0011_soft_delete.sql (MySQL)
ALTER TABLE vehicles ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE wash_records ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE chemical_usage ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE maintenance_records ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE refuel_records ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE charging_records ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE insurance_records ADD COLUMN is_deleted TINYINT(1) NOT NULL DEFAULT 0;

CREATE INDEX ix_vehicles_is_deleted     ON vehicles(is_deleted);
CREATE INDEX ix_wash_records_is_deleted  ON wash_records(is_deleted);
CREATE INDEX ix_maintenance_is_deleted   ON maintenance_records(is_deleted);
CREATE INDEX ix_refuel_is_deleted       ON refuel_records(is_deleted);
CREATE INDEX ix_charging_is_deleted     ON charging_records(is_deleted);
CREATE INDEX ix_insurance_is_deleted    ON insurance_records(is_deleted);