|
Last change
on this file since 545738f was 545738f, checked in by Andrej <asumanovski@…>, 2 weeks ago |
|
Switched to dockerized db and improved Task model and Task Ui
|
-
Property mode
set to
100644
|
|
File size:
735 bytes
|
| Line | |
|---|
| 1 | -- Migration 002: Add description, due_date, priority, status to tasks
|
|---|
| 2 | -- Replace is_finished boolean with status enum string
|
|---|
| 3 |
|
|---|
| 4 | SET search_path TO trekr;
|
|---|
| 5 |
|
|---|
| 6 | ALTER TABLE tasks ADD COLUMN IF NOT EXISTS description TEXT;
|
|---|
| 7 | ALTER TABLE tasks ADD COLUMN IF NOT EXISTS due_date DATE;
|
|---|
| 8 | ALTER TABLE tasks ADD COLUMN IF NOT EXISTS priority VARCHAR(10);
|
|---|
| 9 | ALTER TABLE tasks ADD COLUMN IF NOT EXISTS status VARCHAR(20);
|
|---|
| 10 |
|
|---|
| 11 | -- Migrate existing data from is_finished to status
|
|---|
| 12 | UPDATE tasks SET status = CASE WHEN is_finished THEN 'FINISHED' ELSE 'NOT_STARTED' END WHERE status IS NULL;
|
|---|
| 13 |
|
|---|
| 14 | ALTER TABLE tasks ALTER COLUMN status SET NOT NULL;
|
|---|
| 15 | ALTER TABLE tasks ALTER COLUMN status SET DEFAULT 'NOT_STARTED';
|
|---|
| 16 |
|
|---|
| 17 | ALTER TABLE tasks DROP COLUMN IF EXISTS is_finished;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
