Blame utilities/migrations/pg.sql
|
Luc Didry |
164698 |
-- 1 up
|
|
Luc Didry |
164698 |
CREATE TABLE IF NOT EXISTS files (
|
|
Luc Didry |
164698 |
short text PRIMARY KEY,
|
|
Luc Didry |
164698 |
deleted boolean default false,
|
|
Luc Didry |
164698 |
mediatype text,
|
|
Luc Didry |
164698 |
filename text,
|
|
Luc Didry |
164698 |
filesize integer,
|
|
Luc Didry |
164698 |
counter integer default 0,
|
|
Luc Didry |
164698 |
delete_at_first_view boolean,
|
|
Luc Didry |
164698 |
delete_at_day integer,
|
|
Luc Didry |
164698 |
created_at integer,
|
|
Luc Didry |
164698 |
created_by text,
|
|
Luc Didry |
164698 |
last_access_at integer,
|
|
Luc Didry |
164698 |
mod_token text,
|
|
Luc Didry |
164698 |
nbslices integer,
|
|
Luc Didry |
164698 |
complete boolean default false,
|
|
Luc Didry |
164698 |
passwd text
|
|
Luc Didry |
164698 |
);
|
|
Luc Didry |
164698 |
|
|
Luc Didry |
164698 |
CREATE TABLE IF NOT EXISTS slices (
|
|
Luc Didry |
164698 |
short text NOT NULL REFERENCES files(short) ON DELETE CASCADE,
|
|
Luc Didry |
164698 |
j integer NOT NULL,
|
|
Luc Didry |
164698 |
path text unique NOT NULL,
|
|
Luc Didry |
164698 |
constraint slice_short_j UNIQUE (short, j)
|
|
Luc Didry |
164698 |
);
|
|
Luc Didry |
164698 |
-- 1 down
|
|
Luc Didry |
164698 |
DROP TABLE slices;
|
|
Luc Didry |
164698 |
DROP TABLE files;
|
|
Luc Didry |
25ab7e |
-- 2 up
|
|
Luc Didry |
25ab7e |
ALTER TABLE files ADD COLUMN abuse integer;
|
|
Luc Didry |
25ab7e |
-- 2 down
|
|
Luc Didry |
25ab7e |
ALTER TABLE files DROP COLUMN abuse;
|
|
Luc Didry |
0700ea |
-- 3 up
|
|
Luc Didry |
0700ea |
ALTER TABLE files ADD COLUMN zipped boolean default false;
|
|
Luc Didry |
0700ea |
-- 3 down
|
|
Luc Didry |
0700ea |
ALTER TABLE files DROP COLUMN zipped;
|
|
Luc Didry |
883ea8 |
-- 4 up
|
|
Luc Didry |
883ea8 |
CREATE TABLE IF NOT EXISTS invitations (
|
|
Luc Didry |
883ea8 |
token text PRIMARY KEY,
|
|
Luc Didry |
883ea8 |
ldap_user text,
|
|
Luc Didry |
883ea8 |
ldap_user_mail text,
|
|
Luc Didry |
883ea8 |
guest_mail text,
|
|
Luc Didry |
883ea8 |
created_at integer,
|
|
Luc Didry |
883ea8 |
expire_at integer,
|
|
Luc Didry |
883ea8 |
files_sent_at integer,
|
|
Luc Didry |
883ea8 |
expend_expire_at integer,
|
|
Luc Didry |
883ea8 |
files text,
|
|
Luc Didry |
883ea8 |
show_in_list boolean,
|
|
Luc Didry |
883ea8 |
deleted boolean
|
|
Luc Didry |
883ea8 |
);
|
|
Luc Didry |
883ea8 |
-- 4 down
|
|
Luc Didry |
883ea8 |
DROP TABLE invitations;
|
|
Luc Didry |
740268 |
-- 5 up
|
|
Luc Didry |
740268 |
ALTER TABLE files ALTER COLUMN filesize TYPE bigint;
|
|
Luc Didry |
740268 |
-- 5 down
|
|
Luc Didry |
740268 |
ALTER TABLE files ALTER COLUMN filesize TYPE integer;
|
|
Luc Didry |
8d6f10 |
-- 6 up
|
|
Luc Didry |
8d6f10 |
ALTER TABLE slices ALTER COLUMN path DROP NOT NULL;
|
|
Luc Didry |
8d6f10 |
ALTER TABLE slices DROP CONSTRAINT slices_path_key;
|
|
Luc Didry |
8d6f10 |
-- 6 down
|
|
Luc Didry |
8d6f10 |
ALTER TABLE slices ADD CONSTRAINT slices_path_key UNIQUE (path) ;
|
|
Luc Didry |
8d6f10 |
ALTER TABLE slices ALTER COLUMN path SET NOT NULL;
|