diff options
| -rw-r--r-- | php/configuration.php | 4 | ||||
| -rw-r--r-- | php/node.php | 3 | ||||
| -rw-r--r-- | 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) |