summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorAndreas Fischer <bantu@owncloud.com>2013-11-26 20:27:18 +0100
committerAndreas Fischer <bantu@owncloud.com>2013-11-26 20:27:18 +0100
commit421a1e69dc61924a3bcfc7302c387c7ed34eac8e (patch)
tree249e71be7d5fd1ccd530a51b069fd0d13de921d1
parentad603388ca32492d9fd413237b7b5c8b797067c6 (diff)
downloadnextcloud-server-421a1e69dc61924a3bcfc7302c387c7ed34eac8e.tar.gz
nextcloud-server-421a1e69dc61924a3bcfc7302c387c7ed34eac8e.zip
db-doc: filecache description
-rw-r--r--db_structure.xml15
1 files changed, 14 insertions, 1 deletions
diff --git a/db_structure.xml b/db_structure.xml
index ef161ded509..ba8acaba923 100644
--- a/db_structure.xml
+++ b/db_structure.xml
@@ -210,7 +210,16 @@
</table>
<table>
-
+ <!--
+ Main file table containing one row for each directory and file.
+ - Assigns a unique integer fileid to each file (and directory)
+ - Assigns an etag to each file (and directory)
+ - Caches various file/dir properties such as:
+ - path (filename, e.g. files/combinatoricslib-2.0_doc.zip)
+ - path_hash = md5(path)
+ - name (basename, e.g. combinatoricslib-2.0_doc.zip)
+ - size (for directories this is the sum of all contained file sizes)
+ -->
<name>*dbprefix*filecache</name>
<declaration>
@@ -224,6 +233,7 @@
<length>4</length>
</field>
+ <!-- Foreign Key *dbprefix*storages::numeric_id -->
<field>
<name>storage</name>
<type>integer</type>
@@ -248,6 +258,7 @@
<length>32</length>
</field>
+ <!-- Foreign Key *dbprefix*filecache::fileid -->
<field>
<name>parent</name>
<type>integer</type>
@@ -264,6 +275,7 @@
<length>250</length>
</field>
+ <!-- Foreign Key *dbprefix*mimetypes::id -->
<field>
<name>mimetype</name>
<type>integer</type>
@@ -272,6 +284,7 @@
<length>4</length>
</field>
+ <!-- Foreign Key *dbprefix*mimetypes::id -->
<field>
<name>mimepart</name>
<type>integer</type>