summaryrefslogtreecommitdiff
path: root/migrations/20241005021100_event_sequence.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/20241005021100_event_sequence.sql')
-rw-r--r--migrations/20241005021100_event_sequence.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/migrations/20241005021100_event_sequence.sql b/migrations/20241005021100_event_sequence.sql
new file mode 100644
index 0000000..ac6821d
--- /dev/null
+++ b/migrations/20241005021100_event_sequence.sql
@@ -0,0 +1,10 @@
+create table event_sequence (
+ last_value bigint
+ not null
+);
+
+create unique index event_sequence_singleton
+on event_sequence (0);
+
+insert into event_sequence
+values (0);