From d35678c131d4547cea8b3d9fcc1978dec0d2d903 Mon Sep 17 00:00:00 2001 From: adam Date: Thu, 11 Feb 2021 19:34:16 +0200 Subject: setting up --- sql/fileshare.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'sql') diff --git a/sql/fileshare.sql b/sql/fileshare.sql index a079a7f..dfb9010 100644 --- a/sql/fileshare.sql +++ b/sql/fileshare.sql @@ -23,6 +23,7 @@ create table files ( create table access ( file_id int not null, user_id int not null, + can_view boolean not null default true, can_remove boolean not null default false, check (can_view=true or can_remove=true) , -- cgit v1.2.3