diff options
Diffstat (limited to 'internal/db/migrations')
| -rw-r--r-- | internal/db/migrations/000001_initial.down.sql | 10 | ||||
| -rw-r--r-- | internal/db/migrations/20250424200609_initial.sql (renamed from internal/db/migrations/000001_initial.up.sql) | 18 |
2 files changed, 18 insertions, 10 deletions
diff --git a/internal/db/migrations/000001_initial.down.sql b/internal/db/migrations/000001_initial.down.sql deleted file mode 100644 index a2b0d1321..000000000 --- a/internal/db/migrations/000001_initial.down.sql +++ /dev/null @@ -1,10 +0,0 @@ -DROP TRIGGER IF EXISTS update_sessions_updated_at; -DROP TRIGGER IF EXISTS update_messages_updated_at; -DROP TRIGGER IF EXISTS update_files_updated_at; - -DROP TRIGGER IF EXISTS update_session_message_count_on_delete; -DROP TRIGGER IF EXISTS update_session_message_count_on_insert; - -DROP TABLE IF EXISTS sessions; -DROP TABLE IF EXISTS messages; -DROP TABLE IF EXISTS files; diff --git a/internal/db/migrations/000001_initial.up.sql b/internal/db/migrations/20250424200609_initial.sql index b846ec600..02caecf0c 100644 --- a/internal/db/migrations/000001_initial.up.sql +++ b/internal/db/migrations/20250424200609_initial.sql @@ -1,3 +1,5 @@ +-- +goose Up +-- +goose StatementBegin -- Sessions CREATE TABLE IF NOT EXISTS sessions ( id TEXT PRIMARY KEY, @@ -78,3 +80,19 @@ UPDATE sessions SET message_count = message_count - 1 WHERE id = old.session_id; END; + +-- +goose StatementEnd + +-- +goose Down +-- +goose StatementBegin +DROP TRIGGER IF EXISTS update_sessions_updated_at; +DROP TRIGGER IF EXISTS update_messages_updated_at; +DROP TRIGGER IF EXISTS update_files_updated_at; + +DROP TRIGGER IF EXISTS update_session_message_count_on_delete; +DROP TRIGGER IF EXISTS update_session_message_count_on_insert; + +DROP TABLE IF EXISTS sessions; +DROP TABLE IF EXISTS messages; +DROP TABLE IF EXISTS files; +-- +goose StatementEnd |