aboutsummaryrefslogtreecommitdiff
path: root/migrations/001_create_timestamp_trigger.sql
diff options
context:
space:
mode:
authorAlexander Kavon <me+git@alexkavon.com>2024-01-22 00:35:11 -0500
committerAlexander Kavon <me+git@alexkavon.com>2024-01-22 00:35:11 -0500
commit857a7dd47a42faeee4c91e8089905b2ba7135bb7 (patch)
treeb5ef9b9bae1eb26542eec898ee28591ae6d4942b /migrations/001_create_timestamp_trigger.sql
parentbc47e526e962c1c5bce850de312c6e5fbaf16458 (diff)
updated migrations (added rollback for function), lowered varchar to 255 length, updated packages, make dev, make halt commands for container management
Diffstat (limited to 'migrations/001_create_timestamp_trigger.sql')
-rw-r--r--migrations/001_create_timestamp_trigger.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/migrations/001_create_timestamp_trigger.sql b/migrations/001_create_timestamp_trigger.sql
index 4fa369a..f181510 100644
--- a/migrations/001_create_timestamp_trigger.sql
+++ b/migrations/001_create_timestamp_trigger.sql
@@ -5,3 +5,7 @@ BEGIN
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
+
+---- create above / drop below ----
+
+DROP FUNCTION trigger_set_timestamp()