aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2021-03-20-151809_create_history/up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2021-03-20-151809_create_history/up.sql')
-rw-r--r--migrations/2021-03-20-151809_create_history/up.sql13
1 files changed, 0 insertions, 13 deletions
diff --git a/migrations/2021-03-20-151809_create_history/up.sql b/migrations/2021-03-20-151809_create_history/up.sql
deleted file mode 100644
index 4192b04d..00000000
--- a/migrations/2021-03-20-151809_create_history/up.sql
+++ /dev/null
@@ -1,13 +0,0 @@
--- Your SQL goes here
--- lower case SQL please, this isn't a shouting match
-create table history (
- id bigserial primary key,
- client_id text not null unique, -- the client-generated ID
- user_id bigserial not null, -- allow multiple users
- hostname text not null, -- a unique identifier from the client (can be hashed, random, whatever)
- timestamp timestamp not null, -- one of the few non-encrypted metadatas
-
- data varchar(8192) not null, -- store the actual history data, encrypted. I don't wanna know!
-
- created_at timestamp not null default current_timestamp
-);