aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authoradam <adam@>2021-02-11 19:34:16 +0200
committeradam <adam@>2021-02-11 19:34:16 +0200
commitd35678c131d4547cea8b3d9fcc1978dec0d2d903 (patch)
tree93869e8419deb92a946c3ed817341ca4ae9cc04b /sql
parentd14f3109973c7d95a15174db1a1346887765988d (diff)
downloadfileup-d35678c131d4547cea8b3d9fcc1978dec0d2d903.tar.gz
setting up
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) ,