diff options
Diffstat (limited to 'migrations/2021-03-20-151809_create_history')
| -rw-r--r-- | migrations/2021-03-20-151809_create_history/down.sql | 2 | ||||
| -rw-r--r-- | migrations/2021-03-20-151809_create_history/up.sql | 13 |
2 files changed, 0 insertions, 15 deletions
diff --git a/migrations/2021-03-20-151809_create_history/down.sql b/migrations/2021-03-20-151809_create_history/down.sql deleted file mode 100644 index ea02ce42..00000000 --- a/migrations/2021-03-20-151809_create_history/down.sql +++ /dev/null @@ -1,2 +0,0 @@ --- This file should undo anything in `up.sql` -drop table history; 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 -); |