aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/fileshare.sql1
1 files changed, 1 insertions, 0 deletions
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) ,