16 lines
508 B
SQL
16 lines
508 B
SQL
-- Drop triggers
|
|
DROP TRIGGER IF EXISTS update_task_comments_updated_at ON task_comments;
|
|
DROP TRIGGER IF EXISTS update_work_orders_updated_at ON work_orders;
|
|
DROP TRIGGER IF EXISTS update_tasks_updated_at ON tasks;
|
|
DROP TRIGGER IF EXISTS update_projects_updated_at ON projects;
|
|
|
|
-- Drop tables
|
|
DROP TABLE IF EXISTS task_comments;
|
|
DROP TABLE IF EXISTS work_orders;
|
|
DROP TABLE IF EXISTS tasks;
|
|
DROP TABLE IF EXISTS projects;
|
|
|
|
-- Drop types
|
|
DROP TYPE IF EXISTS task_status;
|
|
DROP TYPE IF EXISTS project_status;
|