Codex
12 lines
450 B
SQL
12 lines
450 B
SQL
DELETE FROM qipai_schema_migrations
|
|
WHERE version = '2026062627';
|
|
|
|
ALTER TABLE qipai_cleaning_settlement_items
|
|
DROP FOREIGN KEY fk_qipai_cleaning_settlement_items_cleaner,
|
|
DROP INDEX uq_qipai_cleaning_settlement_item_task_user,
|
|
DROP INDEX idx_qipai_cleaning_settlement_items_cleaner,
|
|
DROP COLUMN cleaner_user_id,
|
|
ADD UNIQUE KEY uq_qipai_cleaning_settlement_item_task (tenant_id, task_id);
|
|
|
|
DROP TABLE IF EXISTS qipai_cleaning_task_members;
|