Codex
13 lines
449 B
SQL
13 lines
449 B
SQL
DELETE rp FROM qipai_role_permissions rp
|
|
INNER JOIN qipai_permissions p ON p.id = rp.permission_id
|
|
WHERE p.code IN ('cleaning.settlement.read', 'cleaning.settlement.write');
|
|
|
|
DELETE FROM qipai_permissions
|
|
WHERE code IN ('cleaning.settlement.read', 'cleaning.settlement.write');
|
|
|
|
DROP TABLE IF EXISTS qipai_cleaning_settlement_items;
|
|
DROP TABLE IF EXISTS qipai_cleaning_settlements;
|
|
|
|
DELETE FROM qipai_schema_migrations
|
|
WHERE version = '2026062626';
|