From e26ab014a12650b77cc323ee5c0218e68405bfa0 Mon Sep 17 00:00:00 2001
From: adam <adam@>
Date: Fri, 12 Feb 2021 13:55:01 +0200
Subject: sql restructure

---
 php/configuration.php | 4 ++--
 php/node.php          | 3 ++-
 sql/fileshare.sql     | 4 ++--
 3 files changed, 6 insertions(+), 5 deletions(-)

diff --git a/php/configuration.php b/php/configuration.php
index 1ee0a99..313f0ad 100644
--- a/php/configuration.php
+++ b/php/configuration.php
@@ -17,8 +17,8 @@ $database_name="fileup_testing";
 $database_username="outsider";
 $database_password="parola123";
 $database_location="localhost";
-
-    $storage_root = "/srv/apache/testing/project/files/";
+/*storage root must be in the webroot*/
+$storage_root = "/srv/apache/testing/project/files/";
 }
 
 
diff --git a/php/node.php b/php/node.php
index 3c18519..062da90 100644
--- a/php/node.php
+++ b/php/node.php
@@ -14,7 +14,8 @@ require_once "database.php";
 			$this->node_id=$node_id;
 		}
 	}
-	class Current_Directory
+	
+	class Current_Directory extends Node
 	{
 		/*an array of the dir_ids taken to reach here*/
 		public $path;
diff --git a/sql/fileshare.sql b/sql/fileshare.sql
index b0f1696..b3c9c6e 100644
--- a/sql/fileshare.sql
+++ b/sql/fileshare.sql
@@ -12,7 +12,6 @@ create table nodes (
 	is_directory boolean default false,
 	relative_path varchar(500) not null,
 	type varchar(20) not null default 'data',
-	name varchar(100) not null default 'no name',
 	note varchar(200) not null default "",
 	code varchar(100) not null default "error",
 	primary key (node_id)
@@ -39,10 +38,11 @@ create table node_access (
 	foreign key (node_id) references nodes(node_id),
 	foreign key (user_id) references users(user_id)
 );
-
+/*we can name a node in many different ways */
 create table node_links (
 	directory_id int not null,
 	node_id int not null,
+	name varchar(100) not null default 'no name',
 	check (directory_id != node_id), 
 	foreign key (directory_id) references nodes(node_id),
 	foreign key (node_id) references nodes(node_id)
-- 
cgit v1.2.3


From 76970dca67894917bdbc4213f4c5df60d0c8dec3 Mon Sep 17 00:00:00 2001
From: adam <adam@>
Date: Fri, 12 Feb 2021 14:07:16 +0200
Subject: asdf

---
 php/readdir.php | 0
 1 file changed, 0 insertions(+), 0 deletions(-)
 create mode 100644 php/readdir.php

diff --git a/php/readdir.php b/php/readdir.php
new file mode 100644
index 0000000..e69de29
-- 
cgit v1.2.3