diff options
author | adam <adam@> | 2021-02-13 12:44:19 +0200 |
---|---|---|
committer | adam <adam@> | 2021-02-13 12:44:19 +0200 |
commit | cfc5bf135b131827f8b269f2daebe614f8baa56e (patch) | |
tree | a396746d7ced1ddac4fb506f606966fd05979f92 /sql/fileshare.sql | |
parent | e4c0f4eeaa3f1a0707d6bf668619bb48b77c43ce (diff) | |
download | fileup-cfc5bf135b131827f8b269f2daebe614f8baa56e.tar.gz |
stuff
Diffstat (limited to 'sql/fileshare.sql')
-rw-r--r-- | sql/fileshare.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/fileshare.sql b/sql/fileshare.sql index 010b35d..8e69881 100644 --- a/sql/fileshare.sql +++ b/sql/fileshare.sql @@ -24,7 +24,7 @@ create table users ( email varchar(50), home_directory int not null, primary key (user_id), - foreign key (home_directory) references nodes(node_id) + foreign key (home_directory) references nodes(node_id) on delete cascade ); create table node_access ( @@ -33,8 +33,8 @@ create table node_access ( can_view boolean not null default true, can_edit boolean not null default false, - foreign key (node_id) references nodes(node_id), - foreign key (user_id) references users(user_id) + foreign key (node_id) references nodes(node_id) on delete cascade, + foreign key (user_id) references users(user_id) on delete cascade ); /*we can name a node in many different ways */ create table node_links ( @@ -43,8 +43,8 @@ create table node_links ( name varchar(100) not null default 'no name', note varchar(200) not null default "", check (directory_id != node_id), - foreign key (directory_id) references nodes(node_id), - foreign key (node_id) references nodes(node_id) + foreign key (directory_id) references nodes(node_id) on delete cascade, + foreign key (node_id) references nodes(node_id) on delete cascade ); |