summaryrefslogtreecommitdiffstats
path: root/l10n
diff options
context:
space:
mode:
authorJenkins for ownCloud <owncloud-bot@tmit.eu>2014-06-22 01:54:36 -0400
committerJenkins for ownCloud <owncloud-bot@tmit.eu>2014-06-22 01:54:36 -0400
commit2b4c2a7b146fc9317b0cb637397cc8a0594dbf0d (patch)
tree9e4bf7d2de5e372b88da63e2f0df5dd2fecaae7e /l10n
parente30dac9afbbbac105bf36413bf57e5f74012dd38 (diff)
downloadnextcloud-server-2b4c2a7b146fc9317b0cb637397cc8a0594dbf0d.tar.gz
nextcloud-server-2b4c2a7b146fc9317b0cb637397cc8a0594dbf0d.zip
[tx-robot] updated from transifex
Diffstat (limited to 'l10n')
-rw-r--r--l10n/el/core.po58
-rw-r--r--l10n/el/files_encryption.po10
-rw-r--r--l10n/el/files_sharing.po26
-rw-r--r--l10n/el/settings.po34
-rw-r--r--l10n/en_GB/files_sharing.po4
-rw-r--r--l10n/it/files_sharing.po18
-rw-r--r--l10n/it/settings.po24
-rw-r--r--l10n/nb_NO/files_sharing.po26
-rw-r--r--l10n/nb_NO/settings.po22
-rw-r--r--l10n/templates/core.pot2
-rw-r--r--l10n/templates/files.pot10
-rw-r--r--l10n/templates/files_encryption.pot2
-rw-r--r--l10n/templates/files_external.pot2
-rw-r--r--l10n/templates/files_sharing.pot2
-rw-r--r--l10n/templates/files_trashbin.pot2
-rw-r--r--l10n/templates/files_versions.pot2
-rw-r--r--l10n/templates/lib.pot2
-rw-r--r--l10n/templates/private.pot2
-rw-r--r--l10n/templates/settings.pot2
-rw-r--r--l10n/templates/user_ldap.pot2
-rw-r--r--l10n/templates/user_webdavauth.pot2
21 files changed, 127 insertions, 127 deletions
diff --git a/l10n/el/core.po b/l10n/el/core.po
index 8ebc5d61b0a..301fc1d9003 100644
--- a/l10n/el/core.po
+++ b/l10n/el/core.po
@@ -18,9 +18,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-18 01:54-0400\n"
-"PO-Revision-Date: 2014-06-17 19:01+0000\n"
-"Last-Translator: Theodore Grammenos <theodorewii121@hotmail.com>\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 16:27+0000\n"
+"Last-Translator: Vassilis Kehayas <vkehayas@gmail.com>\n"
"Language-Team: Greek (http://www.transifex.com/projects/p/owncloud/language/el/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -228,14 +228,14 @@ msgstr "χÏόνια Ï€Ïιν"
#: js/lostpassword.js:3 lostpassword/controller/lostcontroller.php:175
msgid "Couldn't send reset email. Please contact your administrator."
-msgstr ""
+msgstr "Αδυναμία αποστολής ηλ. μηνÏματος επαναφοÏάς. ΠαÏακαλώ επικοινωνήστε με το διαχειÏιστή σας."
#: js/lostpassword.js:5
msgid ""
"The link to reset your password has been sent to your email. If you do not "
"receive it within a reasonable amount of time, check your spam/junk "
"folders.<br>If it is not there ask your local administrator."
-msgstr ""
+msgstr "Ο σÏνδεσμος για την επαναφοÏά του ÎºÏ‰Î´Î¹ÎºÎ¿Ï Ï€Ïόσβασής σας απεστάλη στο ηλ. ταχυδÏομείο σας. Εάν δεν το παÏαλάβετε μέσα σε ένα εÏλογο χÏονικό διάστημα, ελέγξτε το φάκελο ανεπιθÏμητων μηνυμάτων σας. <br>Εάν δεν βÏίσκεται εκεί Ïωτήστε τον τοπικό διαχειÏιστή σας."
#: js/lostpassword.js:7
msgid ""
@@ -243,11 +243,11 @@ msgid ""
"will be no way to get your data back after your password is reset.<br />If "
"you are not sure what to do, please contact your administrator before you "
"continue. <br />Do you really want to continue?"
-msgstr ""
+msgstr "Τα αÏχεία σας είναι κÏυπτογÏαφημένα. Εάν δεν έχετε ενεÏγοποιήσει το κλειδί επαναφοÏάς, δεν θα υπάÏχει Ï„Ïόπος να ανακτήσετε τα δεδομένα σας μετά την επαναφοÏά του ÎºÏ‰Î´Î¹ÎºÎ¿Ï Ï€Ïόσβασής σας.<br />Εάν δεν είστε σίγουÏοι για το τι θα θέλατε να κάνετε, παÏακαλώ επικοινωνήστε με το διαχειÏιστή σας Ï€Ïιν συνεχίσετε. <br />Θέλετε στ' αλήθεια να συνεχίσετε;"
#: js/lostpassword.js:10
msgid "I know what I'm doing"
-msgstr ""
+msgstr "ΓνωÏίζω τι κάνω"
#: js/lostpassword.js:13 lostpassword/templates/resetpassword.php:9
msgid "Reset password"
@@ -255,77 +255,77 @@ msgstr "ΕπαναφοÏά συνθηματικοÏ"
#: js/lostpassword.js:16
msgid "Password can not be changed. Please contact your administrator."
-msgstr ""
+msgstr "Ο κωδικός Ï€Ïόσβασης δεν μποÏεί να αλλάξει. ΠαÏακαλώ επικοινωνήστε με το διαχειÏιστή σας."
-#: js/oc-dialogs.js:109 js/oc-dialogs.js:250
+#: js/oc-dialogs.js:109 js/oc-dialogs.js:257
msgid "Yes"
msgstr "Îαι"
-#: js/oc-dialogs.js:119 js/oc-dialogs.js:260
+#: js/oc-dialogs.js:119 js/oc-dialogs.js:267
msgid "No"
msgstr "Όχι"
-#: js/oc-dialogs.js:198
+#: js/oc-dialogs.js:204
msgid "Choose"
msgstr "Επιλέξτε"
-#: js/oc-dialogs.js:224
+#: js/oc-dialogs.js:231
msgid "Error loading file picker template: {error}"
msgstr "Σφάλμα κατά την φόÏτωση Ï€ÏοτÏπου επιλογέα αÏχείων: {σφάλμα}"
-#: js/oc-dialogs.js:277
+#: js/oc-dialogs.js:284
msgid "Ok"
msgstr "Οκ"
-#: js/oc-dialogs.js:297
+#: js/oc-dialogs.js:304
msgid "Error loading message template: {error}"
msgstr "Σφάλμα φόÏτωσης Ï€ÏοτÏπου μηνυμάτων: {σφάλμα}"
-#: js/oc-dialogs.js:425
+#: js/oc-dialogs.js:432
msgid "{count} file conflict"
msgid_plural "{count} file conflicts"
msgstr[0] "{count} αÏχείο διαφέÏει"
msgstr[1] "{count} αÏχεία διαφέÏουν"
-#: js/oc-dialogs.js:439
+#: js/oc-dialogs.js:446
msgid "One file conflict"
msgstr "Ένα αÏχείο διαφέÏει"
-#: js/oc-dialogs.js:445
+#: js/oc-dialogs.js:452
msgid "New Files"
msgstr "Îέα ΑÏχεία"
-#: js/oc-dialogs.js:446
+#: js/oc-dialogs.js:453
msgid "Already existing files"
msgstr "Ήδη υπάÏχοντα αÏχεία"
-#: js/oc-dialogs.js:448
+#: js/oc-dialogs.js:455
msgid "Which files do you want to keep?"
msgstr "Ποια αÏχεία θέλετε να κÏατήσετε;"
-#: js/oc-dialogs.js:449
+#: js/oc-dialogs.js:456
msgid ""
"If you select both versions, the copied file will have a number added to its"
" name."
msgstr "Εάν επιλέξετε και τις δυο εκδοχές, ένας αÏιθμός θα Ï€Ïοστεθεί στο αντιγÏαφόμενο αÏχείο."
-#: js/oc-dialogs.js:457
+#: js/oc-dialogs.js:464
msgid "Cancel"
msgstr "ΆκυÏο"
-#: js/oc-dialogs.js:467
+#: js/oc-dialogs.js:474
msgid "Continue"
msgstr "Συνέχεια"
-#: js/oc-dialogs.js:514 js/oc-dialogs.js:527
+#: js/oc-dialogs.js:521 js/oc-dialogs.js:534
msgid "(all selected)"
msgstr "(όλα τα επιλεγμένα)"
-#: js/oc-dialogs.js:517 js/oc-dialogs.js:531
+#: js/oc-dialogs.js:524 js/oc-dialogs.js:538
msgid "({count} selected)"
msgstr "({count} επιλέχθησαν)"
-#: js/oc-dialogs.js:539
+#: js/oc-dialogs.js:546
msgid "Error loading file exists template"
msgstr "Σφάλμα κατά την φόÏτωση του Ï€ÏοτÏπου ÏπαÏξης αÏχείου"
@@ -557,17 +557,17 @@ msgstr "Η ενημέÏωση ήταν επιτυχής. Μετάβαση στο
#: lostpassword/controller/lostcontroller.php:110
msgid "Couldn't reset password because the token is invalid"
-msgstr ""
+msgstr "Αδυναμία επαναφοÏάς ÎºÏ‰Î´Î¹ÎºÎ¿Ï Ï€Ïόσβασης καθώς το τεκμήÏιο είναι άκυÏο"
#: lostpassword/controller/lostcontroller.php:136
msgid "Couldn't send reset email. Please make sure your username is correct."
-msgstr ""
+msgstr "Αδυναμία αποστολής ηλ. μηνÏματος επαναφοÏάς. ΠαÏακαλώ ελέγξτε ότι το όνομα χÏήστη σας είναι οÏθό."
#: lostpassword/controller/lostcontroller.php:151
msgid ""
"Couldn't send reset email because there is no email address for this "
"username. Please contact your administrator."
-msgstr ""
+msgstr "Αδυναμία αποστολής ηλ. μηνÏματος επαναφοÏάς καθώς δεν αντιστοιχεί καμμία διεÏθυνση ηλ. ταχυδÏομείου σε αυτό το όνομα χÏήστη. ΠαÏακαλώ επικοινωνήστε με το διαχειÏιστή σας."
#: lostpassword/controller/lostcontroller.php:168
#, php-format
@@ -838,7 +838,7 @@ msgstr "ΠαÏακαλώ επικοινωνήστε με τον διαχειÏι
#: templates/login.php:50
msgid "Forgot your password? Reset it!"
-msgstr ""
+msgstr "Ξεχάσατε τον κωδικό Ï€Ïόσβασής σας; ΕπαναφέÏετέ τον!"
#: templates/login.php:55
msgid "remember"
diff --git a/l10n/el/files_encryption.po b/l10n/el/files_encryption.po
index 4390f9a4f4e..fb9fb6be181 100644
--- a/l10n/el/files_encryption.po
+++ b/l10n/el/files_encryption.po
@@ -8,14 +8,14 @@
# Spyros Melissovas <peppe@cs.uoi.gr>, 2014
# Theodore Grammenos <theodorewii121@hotmail.com>, 2013
# Theodore Grammenos <theodorewii121@hotmail.com>, 2013
-# Vassilis Kehayas <vkehayas@gmail.com>, 2013
+# Vassilis Kehayas <vkehayas@gmail.com>, 2013-2014
msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-14 01:54-0400\n"
-"PO-Revision-Date: 2014-06-14 05:54+0000\n"
-"Last-Translator: I Robot\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 16:31+0000\n"
+"Last-Translator: Vassilis Kehayas <vkehayas@gmail.com>\n"
"Language-Team: Greek (http://www.transifex.com/projects/p/owncloud/language/el/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -112,7 +112,7 @@ msgstr "Εκτέλεση αÏχικής κÏυπτογÏάφησης... ΠαÏα
#: templates/invalid_private_key.php:8
#, php-format
msgid "Go directly to your %spersonal settings%s."
-msgstr ""
+msgstr "Πηγαίνετε κατ'ευθείαν στις %sÏ€Ïοσωπικές Ïυθμίσεις%s σας."
#: templates/settings-admin.php:2 templates/settings-personal.php:2
msgid "Encryption"
diff --git a/l10n/el/files_sharing.po b/l10n/el/files_sharing.po
index 49bb2029390..b26bafdda62 100644
--- a/l10n/el/files_sharing.po
+++ b/l10n/el/files_sharing.po
@@ -10,9 +10,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-19 01:54-0400\n"
-"PO-Revision-Date: 2014-06-18 06:12+0000\n"
-"Last-Translator: I Robot\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 16:12+0000\n"
+"Last-Translator: Vassilis Kehayas <vkehayas@gmail.com>\n"
"Language-Team: Greek (http://www.transifex.com/projects/p/owncloud/language/el/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -22,11 +22,11 @@ msgstr ""
#: ajax/external.php:20
msgid "Server to server sharing is not enabled on this server"
-msgstr ""
+msgstr "Ο διαμοιÏασμός Î¼ÎµÏ„Î±Î¾Ï Î´Î¹Î±ÎºÎ¿Î¼Î¹ÏƒÏ„ÏŽÎ½ δεν έχει ενεÏγοποιηθεί σε αυτόν το διακομιστή"
#: ajax/external.php:50
msgid "Couldn't add remote share"
-msgstr ""
+msgstr "Αδυναμία Ï€Ïοσθήκης απομακÏυσμένου κοινόχÏηστου φακέλου"
#: appinfo/app.php:46 js/app.js:34
msgid "Shared with you"
@@ -54,15 +54,15 @@ msgstr "Δεν έχετε διαμοιÏαστεί κανένα αÏχείο μÎ
#: js/external.js:43 js/external.js:46
msgid "Add {name} from {owner}@{remote}"
-msgstr ""
+msgstr "ΠÏοσθήκη {name} από {owner}@{remote}"
#: js/public.js:200
msgid "No ownCloud installation found at {remote}"
-msgstr ""
+msgstr "Δεν βÏέθηκε εγκατεστημένο ownCloud στο {remote}"
#: js/public.js:201
msgid "Invalid ownCloud url"
-msgstr ""
+msgstr "ΆκυÏη url ownCloud "
#: js/share.js:60
msgid "Shared by {owner}"
@@ -118,11 +118,11 @@ msgstr "Για πεÏισσότεÏες πληÏοφοÏίες, παÏακαλώ
#: templates/public.php:20
msgid "Save to ownCloud"
-msgstr ""
+msgstr "Αποθήκευση στο ownCloud"
#: templates/public.php:22
msgid "example.com/owncloud"
-msgstr ""
+msgstr "example.com/owncloud"
#: templates/public.php:23
msgid "Save"
@@ -143,12 +143,12 @@ msgstr "Άμεσος σÏνδεσμος"
#: templates/settings-admin.php:3
msgid "File Sharing"
-msgstr ""
+msgstr "ΔιαμοιÏασμός ΑÏχείων"
#: templates/settings-admin.php:7
msgid "Allow other instances to mount public links shared from this server"
-msgstr ""
+msgstr "Îα επιτÏέπεται σε άλλες εγκαταστάσεις να επιθέτουν δημόσιους συνδέσμους που έχουν διαμοιÏαστεί από αυτόν το διακομιστή"
#: templates/settings-admin.php:11
msgid "Allow users to mount public link shares"
-msgstr ""
+msgstr "Îα επιτÏέπεται στους χÏήστες να επιθέτουν κοινόχÏηστους φακέλους με δημόσιους συνδέσμους"
diff --git a/l10n/el/settings.po b/l10n/el/settings.po
index f312eac268b..6cc78be06ea 100644
--- a/l10n/el/settings.po
+++ b/l10n/el/settings.po
@@ -16,9 +16,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-18 01:54-0400\n"
-"PO-Revision-Date: 2014-06-17 19:01+0000\n"
-"Last-Translator: Theodore Grammenos <theodorewii121@hotmail.com>\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 16:29+0000\n"
+"Last-Translator: Vassilis Kehayas <vkehayas@gmail.com>\n"
"Language-Team: Greek (http://www.transifex.com/projects/p/owncloud/language/el/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -119,7 +119,7 @@ msgstr "Δεν ήταν δυνατή η οÏιστική διαγÏαφή των
#: ajax/installapp.php:18 ajax/uninstallapp.php:18
msgid "Couldn't remove app."
-msgstr ""
+msgstr "Αδυναμία αφαίÏεσης εφαÏμογής."
#: ajax/lostpassword.php:12
msgid "Email saved"
@@ -220,7 +220,7 @@ msgstr "ΕνημέÏωση σε {appversion}"
#: js/apps.js:90
msgid "Uninstall App"
-msgstr ""
+msgstr "Απεγκατάσταση ΕφαÏμογής"
#: js/apps.js:96 js/apps.js:158 js/apps.js:191
msgid "Disable"
@@ -264,11 +264,11 @@ msgstr "ΕνημεÏώθηκε"
#: js/apps.js:233
msgid "Uninstalling ...."
-msgstr ""
+msgstr "Απεγκατάσταση ...."
#: js/apps.js:236
msgid "Error while uninstalling app"
-msgstr ""
+msgstr "Σφάλμα κατά την απεγκατάσταση της εφαÏμογής"
#: js/apps.js:237 templates/apps.php:56
msgid "Uninstall"
@@ -324,9 +324,9 @@ msgstr "ΠÏέπει να δοθεί ένα έγκυÏο όνομα ομάδας
#: js/users/groups.js:205
msgid "deleted {groupName}"
-msgstr ""
+msgstr "διαγÏαφή {groupName}"
-#: js/users/groups.js:206 js/users/users.js:255
+#: js/users/groups.js:206 js/users/users.js:265
msgid "undo"
msgstr "αναίÏεση"
@@ -346,31 +346,31 @@ msgstr "Ομάδα ΔιαχειÏιστών"
msgid "Delete"
msgstr "ΔιαγÏαφή"
-#: js/users/users.js:84 templates/users/part.userlist.php:98
+#: js/users/users.js:85 templates/users/part.userlist.php:98
msgid "never"
msgstr "ποτέ"
-#: js/users/users.js:254
+#: js/users/users.js:264
msgid "deleted {userName}"
-msgstr ""
+msgstr "διαγÏαφή {userName}"
-#: js/users/users.js:371
+#: js/users/users.js:381
msgid "add group"
msgstr "Ï€Ïοσθήκη ομάδας"
-#: js/users/users.js:568
+#: js/users/users.js:578
msgid "A valid username must be provided"
msgstr "ΠÏέπει να δοθεί έγκυÏο όνομα χÏήστη"
-#: js/users/users.js:569 js/users/users.js:575 js/users/users.js:590
+#: js/users/users.js:579 js/users/users.js:585 js/users/users.js:600
msgid "Error creating user"
msgstr "Σφάλμα δημιουÏγίας χÏήστη"
-#: js/users/users.js:574
+#: js/users/users.js:584
msgid "A valid password must be provided"
msgstr "ΠÏέπει να δοθεί έγκυÏο συνθηματικό"
-#: js/users/users.js:598
+#: js/users/users.js:608
msgid "Warning: Home directory for user \"{user}\" already exists"
msgstr "ΠÏοειδοποίηση: Ο μητÏικός κατάλογος του χÏήστη \"{user}\" υπάÏχει ήδη"
diff --git a/l10n/en_GB/files_sharing.po b/l10n/en_GB/files_sharing.po
index 5bdcf10aa08..42683ac1dca 100644
--- a/l10n/en_GB/files_sharing.po
+++ b/l10n/en_GB/files_sharing.po
@@ -8,8 +8,8 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-20 01:54-0400\n"
-"PO-Revision-Date: 2014-06-19 13:11+0000\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 14:47+0000\n"
"Last-Translator: Darren Richardson <transifex@mnestis.net>\n"
"Language-Team: English (United Kingdom) (http://www.transifex.com/projects/p/owncloud/language/en_GB/)\n"
"MIME-Version: 1.0\n"
diff --git a/l10n/it/files_sharing.po b/l10n/it/files_sharing.po
index e86ac167372..f9dcfeb95ec 100644
--- a/l10n/it/files_sharing.po
+++ b/l10n/it/files_sharing.po
@@ -10,9 +10,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
-"PO-Revision-Date: 2014-06-20 14:50+0000\n"
-"Last-Translator: Nicolas North\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 09:41+0000\n"
+"Last-Translator: Vincenzo Reale <vinx.reale@gmail.com>\n"
"Language-Team: Italian (http://www.transifex.com/projects/p/owncloud/language/it/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -22,11 +22,11 @@ msgstr ""
#: ajax/external.php:20
msgid "Server to server sharing is not enabled on this server"
-msgstr "La condivisione da server a server non è abilitata su questo server"
+msgstr "La condivisione tra server non è abilitata su questo server"
#: ajax/external.php:50
msgid "Couldn't add remote share"
-msgstr "Aggiunta della condivisione remota non riuscita"
+msgstr "Impossibile aggiungere la condivisione remota"
#: appinfo/app.php:46 js/app.js:34
msgid "Shared with you"
@@ -122,7 +122,7 @@ msgstr "Salva su ownCloud"
#: templates/public.php:22
msgid "example.com/owncloud"
-msgstr "example.com/owncloud"
+msgstr "esempio.com/owncloud"
#: templates/public.php:23
msgid "Save"
@@ -143,12 +143,12 @@ msgstr "Collegamento diretto"
#: templates/settings-admin.php:3
msgid "File Sharing"
-msgstr "Condivisione di File"
+msgstr "Condivisione file"
#: templates/settings-admin.php:7
msgid "Allow other instances to mount public links shared from this server"
-msgstr "Permetti ad altre istanze di montare link pubblici condivisi da questo server"
+msgstr "Permetti ad altre istanze di montare collegamenti pubblici condivisi da questo server"
#: templates/settings-admin.php:11
msgid "Allow users to mount public link shares"
-msgstr "Permetti agli utenti di montare condivisioni con link pubblico"
+msgstr "Permetti agli utenti di montare condivisioni con collegamento pubblico"
diff --git a/l10n/it/settings.po b/l10n/it/settings.po
index f2779a407e4..e32a4e034cb 100644
--- a/l10n/it/settings.po
+++ b/l10n/it/settings.po
@@ -11,9 +11,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-18 01:54-0400\n"
-"PO-Revision-Date: 2014-06-17 08:55+0000\n"
-"Last-Translator: Paolo Velati <paolo.velati@gmail.com>\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 09:38+0000\n"
+"Last-Translator: Vincenzo Reale <vinx.reale@gmail.com>\n"
"Language-Team: Italian (http://www.transifex.com/projects/p/owncloud/language/it/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -259,7 +259,7 @@ msgstr "Aggiornato"
#: js/apps.js:233
msgid "Uninstalling ...."
-msgstr "Disinstallazione ..."
+msgstr "Disinstallazione..."
#: js/apps.js:236
msgid "Error while uninstalling app"
@@ -321,7 +321,7 @@ msgstr "Deve essere fornito un nome valido per il gruppo"
msgid "deleted {groupName}"
msgstr "{groupName} eliminato"
-#: js/users/groups.js:206 js/users/users.js:255
+#: js/users/groups.js:206 js/users/users.js:265
msgid "undo"
msgstr "annulla"
@@ -341,31 +341,31 @@ msgstr "Gruppi amministrati"
msgid "Delete"
msgstr "Elimina"
-#: js/users/users.js:84 templates/users/part.userlist.php:98
+#: js/users/users.js:85 templates/users/part.userlist.php:98
msgid "never"
msgstr "mai"
-#: js/users/users.js:254
+#: js/users/users.js:264
msgid "deleted {userName}"
msgstr "{userName} eliminato"
-#: js/users/users.js:371
+#: js/users/users.js:381
msgid "add group"
msgstr "aggiungi gruppo"
-#: js/users/users.js:568
+#: js/users/users.js:578
msgid "A valid username must be provided"
msgstr "Deve essere fornito un nome utente valido"
-#: js/users/users.js:569 js/users/users.js:575 js/users/users.js:590
+#: js/users/users.js:579 js/users/users.js:585 js/users/users.js:600
msgid "Error creating user"
msgstr "Errore durante la creazione dell'utente"
-#: js/users/users.js:574
+#: js/users/users.js:584
msgid "A valid password must be provided"
msgstr "Deve essere fornita una password valida"
-#: js/users/users.js:598
+#: js/users/users.js:608
msgid "Warning: Home directory for user \"{user}\" already exists"
msgstr "Avviso: la cartella home dell'utente \"{user}\" esiste già"
diff --git a/l10n/nb_NO/files_sharing.po b/l10n/nb_NO/files_sharing.po
index 5b02d592bc9..68b07665f46 100644
--- a/l10n/nb_NO/files_sharing.po
+++ b/l10n/nb_NO/files_sharing.po
@@ -9,9 +9,9 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-19 01:54-0400\n"
-"PO-Revision-Date: 2014-06-18 06:12+0000\n"
-"Last-Translator: I Robot\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 10:47+0000\n"
+"Last-Translator: vidaren <news@vidartysse.net>\n"
"Language-Team: Norwegian Bokmål (Norway) (http://www.transifex.com/projects/p/owncloud/language/nb_NO/)\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
@@ -21,11 +21,11 @@ msgstr ""
#: ajax/external.php:20
msgid "Server to server sharing is not enabled on this server"
-msgstr ""
+msgstr "Server til server-deling er ikke aktivert på denne serveren"
#: ajax/external.php:50
msgid "Couldn't add remote share"
-msgstr ""
+msgstr "Klarte ikke å legge til ekstern deling"
#: appinfo/app.php:46 js/app.js:34
msgid "Shared with you"
@@ -53,15 +53,15 @@ msgstr "Du har ikke delt noen filer med lenke ennå."
#: js/external.js:43 js/external.js:46
msgid "Add {name} from {owner}@{remote}"
-msgstr ""
+msgstr "Legg til {name} fra {owner}@{remote}"
#: js/public.js:200
msgid "No ownCloud installation found at {remote}"
-msgstr ""
+msgstr "Ingen ownCloud-installasjon funnet på {remote}"
#: js/public.js:201
msgid "Invalid ownCloud url"
-msgstr ""
+msgstr "Ugyldig ownCloud-url"
#: js/share.js:60
msgid "Shared by {owner}"
@@ -117,11 +117,11 @@ msgstr "For mer informasjon, spør personen som sendte lenken."
#: templates/public.php:20
msgid "Save to ownCloud"
-msgstr ""
+msgstr "Lagre til ownCloud"
#: templates/public.php:22
msgid "example.com/owncloud"
-msgstr ""
+msgstr "example.com/owncloud"
#: templates/public.php:23
msgid "Save"
@@ -142,12 +142,12 @@ msgstr "Direkte lenke"
#: templates/settings-admin.php:3
msgid "File Sharing"
-msgstr ""
+msgstr "Fildeling"
#: templates/settings-admin.php:7
msgid "Allow other instances to mount public links shared from this server"
-msgstr ""
+msgstr "Tillat at andre instanser monterer offentlige lenker som er delt fra denne serveren"
#: templates/settings-admin.php:11
msgid "Allow users to mount public link shares"
-msgstr ""
+msgstr "Tillat at brukere monterer offentlige lenke-delinger"
diff --git a/l10n/nb_NO/settings.po b/l10n/nb_NO/settings.po
index e6f5cdda407..b44693d16d0 100644
--- a/l10n/nb_NO/settings.po
+++ b/l10n/nb_NO/settings.po
@@ -11,8 +11,8 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-18 01:54-0400\n"
-"PO-Revision-Date: 2014-06-17 23:40+0000\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
+"PO-Revision-Date: 2014-06-21 13:55+0000\n"
"Last-Translator: vidaren <news@vidartysse.net>\n"
"Language-Team: Norwegian Bokmål (Norway) (http://www.transifex.com/projects/p/owncloud/language/nb_NO/)\n"
"MIME-Version: 1.0\n"
@@ -321,7 +321,7 @@ msgstr "Et gyldig gruppenavn må oppgis"
msgid "deleted {groupName}"
msgstr "slettet {groupName}"
-#: js/users/groups.js:206 js/users/users.js:255
+#: js/users/groups.js:206 js/users/users.js:265
msgid "undo"
msgstr "angre"
@@ -341,31 +341,31 @@ msgstr "Gruppeadministrator"
msgid "Delete"
msgstr "Slett"
-#: js/users/users.js:84 templates/users/part.userlist.php:98
+#: js/users/users.js:85 templates/users/part.userlist.php:98
msgid "never"
msgstr "aldri"
-#: js/users/users.js:254
+#: js/users/users.js:264
msgid "deleted {userName}"
msgstr "slettet {userName}"
-#: js/users/users.js:371
+#: js/users/users.js:381
msgid "add group"
msgstr "legg til gruppe"
-#: js/users/users.js:568
+#: js/users/users.js:578
msgid "A valid username must be provided"
msgstr "Oppgi et gyldig brukernavn"
-#: js/users/users.js:569 js/users/users.js:575 js/users/users.js:590
+#: js/users/users.js:579 js/users/users.js:585 js/users/users.js:600
msgid "Error creating user"
msgstr "Feil ved oppretting av bruker"
-#: js/users/users.js:574
+#: js/users/users.js:584
msgid "A valid password must be provided"
msgstr "Oppgi et gyldig passord"
-#: js/users/users.js:598
+#: js/users/users.js:608
msgid "Warning: Home directory for user \"{user}\" already exists"
msgstr "Advarsel: Hjemmemappe for bruker \"{user}\" eksisterer allerede"
@@ -466,7 +466,7 @@ msgstr "Dette forårsakes sannsynligvis av en bufrer/akselerator, som f.eks. Zen
#: templates/admin.php:105
msgid "Database Performance Info"
-msgstr "Info om databaseytelse"
+msgstr "Info om database-ytelse"
#: templates/admin.php:108
msgid ""
diff --git a/l10n/templates/core.pot b/l10n/templates/core.pot
index ad2b28892b0..97badb6465d 100644
--- a/l10n/templates/core.pot
+++ b/l10n/templates/core.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/files.pot b/l10n/templates/files.pot
index 01b3ea95b57..da1e227208c 100644
--- a/l10n/templates/files.pot
+++ b/l10n/templates/files.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -193,19 +193,19 @@ msgstr ""
msgid "Error fetching URL"
msgstr ""
-#: js/fileactions.js:211
+#: js/fileactions.js:213
msgid "Share"
msgstr ""
-#: js/fileactions.js:224
+#: js/fileactions.js:226
msgid "Delete permanently"
msgstr ""
-#: js/fileactions.js:226 templates/list.php:78 templates/list.php:79
+#: js/fileactions.js:228 templates/list.php:78 templates/list.php:79
msgid "Delete"
msgstr ""
-#: js/fileactions.js:262
+#: js/fileactions.js:264
msgid "Rename"
msgstr ""
diff --git a/l10n/templates/files_encryption.pot b/l10n/templates/files_encryption.pot
index fe70dd7bcc4..c06c6945e81 100644
--- a/l10n/templates/files_encryption.pot
+++ b/l10n/templates/files_encryption.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/files_external.pot b/l10n/templates/files_external.pot
index 7e12b22cdc5..3cfe4ee44c4 100644
--- a/l10n/templates/files_external.pot
+++ b/l10n/templates/files_external.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/files_sharing.pot b/l10n/templates/files_sharing.pot
index 317f3e1a781..eb8a01c91ea 100644
--- a/l10n/templates/files_sharing.pot
+++ b/l10n/templates/files_sharing.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/files_trashbin.pot b/l10n/templates/files_trashbin.pot
index c905d9500f3..0bbbabe8978 100644
--- a/l10n/templates/files_trashbin.pot
+++ b/l10n/templates/files_trashbin.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/files_versions.pot b/l10n/templates/files_versions.pot
index d8ccd0ade8c..6afb9a17030 100644
--- a/l10n/templates/files_versions.pot
+++ b/l10n/templates/files_versions.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/lib.pot b/l10n/templates/lib.pot
index 8890035878e..664585b2ee3 100644
--- a/l10n/templates/lib.pot
+++ b/l10n/templates/lib.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/private.pot b/l10n/templates/private.pot
index 2508c33f08f..940c254016c 100644
--- a/l10n/templates/private.pot
+++ b/l10n/templates/private.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/settings.pot b/l10n/templates/settings.pot
index 1bf76bb90b9..f6c46b3ee9e 100644
--- a/l10n/templates/settings.pot
+++ b/l10n/templates/settings.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/user_ldap.pot b/l10n/templates/user_ldap.pot
index 3e0376bcb48..1c0780fd0ec 100644
--- a/l10n/templates/user_ldap.pot
+++ b/l10n/templates/user_ldap.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
diff --git a/l10n/templates/user_webdavauth.pot b/l10n/templates/user_webdavauth.pot
index af2ecc267e8..dc2368a92e8 100644
--- a/l10n/templates/user_webdavauth.pot
+++ b/l10n/templates/user_webdavauth.pot
@@ -8,7 +8,7 @@ msgid ""
msgstr ""
"Project-Id-Version: ownCloud Core 6.0.0\n"
"Report-Msgid-Bugs-To: translations@owncloud.org\n"
-"POT-Creation-Date: 2014-06-21 01:54-0400\n"
+"POT-Creation-Date: 2014-06-22 01:54-0400\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
n1944' href='#n1944'>1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100
<?xml version="1.0" encoding="utf-8" ?>
<database>

	<name>*dbname*</name>
	<create>true</create>
	<overwrite>false</overwrite>

	<charset>utf8</charset>

	<table>

		<!--
		Namespaced Key-Value Store for Application Configuration.
		 - Keys are namespaced per appid.
		 - E.g. (core, global_cache_gc_lastrun) -> 1385463286
		-->
		<name>*dbprefix*appconfig</name>

		<declaration>

			<field>
				<name>appid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>32</length>
			</field>

			<field>
				<name>configkey</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>configvalue</name>
				<type>clob</type>
				<notnull>false</notnull>
			</field>

			<index>
				<name>appconfig_appid_key_index</name>
				<primary>true</primary>
				<unique>true</unique>
				<field>
					<name>appid</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>configkey</name>
					<sorting>ascending</sorting>
				</field>
			</index>
			<index>
				<name>appconfig_config_key_index</name>
				<field>
					<name>configkey</name>
					<sorting>ascending</sorting>
				</field>
			</index>
			<index>
				<name>appconfig_appid_key</name>
				<field>
					<name>appid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Bidirectional Map for Storage Names and Storage Ids.
		 - Assigns each storage name a unique storage id integer.
		 - Long storage names are hashed.
		 - E.g.                     local::/tmp/ <-> 2
		 - E.g. b5db994aa8c6625100e418406c798269 <-> 27
		-->
		<name>*dbprefix*storages</name>

		<declaration>

			<field>
				<name>id</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>

			<field>
				<name>numeric_id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<length>4</length>
			</field>

			<field>
				<name>available</name>
				<type>integer</type>
				<default>1</default>
				<notnull>true</notnull>
			</field>

			<field>
				<name>last_checked</name>
				<type>integer</type>
			</field>

			<index>
				<name>storages_id_index</name>
				<unique>true</unique>
				<field>
					<name>id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<!-- a list of all mounted storage per user, populated on filesystem setup -->
	<table>

		<name>*dbprefix*mounts</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<length>4</length>
			</field>

			<field>
				<name>storage_id</name>
				<type>integer</type>
				<notnull>true</notnull>
			</field>

			<!-- fileid of the root of the mount, foreign key: oc_filecache.fileid -->
			<field>
				<name>root_id</name>
				<type>integer</type>
				<notnull>true</notnull>
			</field>

			<field>
				<name>user_id</name>
				<type>text</type>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>mount_point</name>
				<type>text</type>
				<notnull>true</notnull>
				<length>4000</length>
			</field>

			<field>
				<name>mount_id</name>
				<type>integer</type>
			</field>

			<index>
				<name>mounts_user_index</name>
				<unique>false</unique>
				<field>
					<name>user_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>mounts_storage_index</name>
				<unique>false</unique>
				<field>
					<name>storage_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>mounts_root_index</name>
				<unique>false</unique>
				<field>
					<name>root_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>mounts_mount_id_index</name>
				<unique>false</unique>
				<field>
					<name>mount_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>mounts_user_root_index</name>
				<unique>true</unique>
				<field>
					<name>user_id</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>root_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Bidirectional Map for Mimetypes and Mimetype Id
		 - Assigns each mimetype (and supertype) a unique mimetype id integer.
		 - E.g.     application <-> 5
		 - E.g. application/pdf <-> 6
		-->
		<name>*dbprefix*mimetypes</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<length>4</length>
			</field>

			<field>
				<name>mimetype</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<index>
				<name>mimetype_id_index</name>
				<unique>true</unique>
				<field>
					<name>mimetype</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</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>

			<field>
				<name>fileid</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<length>4</length>
			</field>

			<!-- Foreign Key storages::numeric_id -->
			<field>
				<name>storage</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>path</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>4000</length>
			</field>

			<field>
				<name>path_hash</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>32</length>
			</field>

			<!-- Foreign Key filecache::fileid -->
			<field>
				<name>parent</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>name</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>250</length>
			</field>

			<!-- Foreign Key mimetypes::id -->
			<field>
				<name>mimetype</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<!-- Foreign Key mimetypes::id -->
			<field>
				<name>mimepart</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>size</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>8</length>
			</field>

			<field>
				<name>mtime</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>storage_mtime</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>encrypted</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

            <field>
                <name>unencrypted_size</name>
                <type>integer</type>
                <default>0</default>
                <notnull>true</notnull>
                <length>8</length>
            </field>

			<field>
				<name>etag</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>40</length>
			</field>

            <field>
                <name>permissions</name>
                <type>integer</type>
                <default>0</default>
                <notnull>false</notnull>
                <length>4</length>
            </field>

			<field>
				<name>checksum</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>255</length>
			</field>


            <index>
				<name>fs_storage_path_hash</name>
				<unique>true</unique>
				<field>
					<name>storage</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>path_hash</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>fs_parent_name_hash</name>
				<field>
					<name>parent</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>name</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>fs_storage_mimetype</name>
				<field>
					<name>storage</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>mimetype</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>fs_storage_mimepart</name>
				<field>
					<name>storage</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>mimepart</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>fs_storage_size</name>
				<field>
					<name>storage</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>size</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>fileid</name>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Stores which groups have which users as members in an n:m relationship.
		 - Maps group id (gid) to a set of users (uid)
		 - Maps user id (uid) to a set of groups (gid) (but without index)
		-->
		<name>*dbprefix*group_user</name>

		<declaration>

			<!-- Foreign Key groups::gid -->
			<field>
				<name>gid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<!-- Foreign Key users::uid -->
			<field>
				<name>uid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<index>
				<name>gu_gid_uid_index</name>
				<primary>true</primary>
				<unique>true</unique>
				<field>
					<name>gid</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>gu_uid_index</name>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Stores which groups have which users as admins in an n:m relationship.
		 - Maps group id (gid) to a set of users (uid)
		 - Maps user id (uid) to a set of groups (gid)

		NOTE: This could (very likely) be reduced to a single bit in group_user
		      instead of repeating varchars gid and uid here
		-->
		<name>*dbprefix*group_admin</name>

		<declaration>

			<!-- Foreign Key groups::gid -->
			<field>
				<name>gid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<!-- Foreign Key users::uid -->
			<field>
				<name>uid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>
			<index>
				<name>group_admin_uid</name>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>ga_gid_uid_index</name>
				<primary>true</primary>
				<unique>true</unique>
				<field>
					<name>gid</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		A simple list of groups.
		-->
		<name>*dbprefix*groups</name>

		<declaration>

			<field>
				<name>gid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<index>
				<name>groups_pKey</name>
				<primary>true</primary>
				<field>
					<name>gid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Namespaced Key-Value Store for User Preferences
		 - Keys are namespaced per userid and appid.
		 - E.g. (admin, files, cache_version) -> 5
		-->
		<name>*dbprefix*preferences</name>

		<declaration>

			<!-- Foreign Key users::uid -->
			<field>
				<name>userid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>appid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>32</length>
			</field>

			<field>
				<name>configkey</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>configvalue</name>
				<type>clob</type>
				<notnull>false</notnull>
			</field>

			<index>
				<name>pref_userid_appid_key_index</name>
				<primary>true</primary>
				<unique>true</unique>
				<field>
					<name>userid</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>appid</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>configkey</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		WebDAV properties.
		-->
		<name>*dbprefix*properties</name>

		<declaration>

			<field>
				<name>id</name>
				<autoincrement>1</autoincrement>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<!-- Foreign Key users::uid -->
			<field>
				<name>userid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>propertypath</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>propertyname</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>propertyvalue</name>
				<type>text</type>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<index>
				<name>property_index</name>
				<field>
					<name>userid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		Shares of all types (user-to-user, external-via-link, etc.)
		-->
		<name>*dbprefix*share</name>

		<declaration>

			<field>
				<name>id</name>
				<autoincrement>1</autoincrement>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<!-- Constant OCP\Share::SHARE_TYPE_* -->
			<field>
				<name>share_type</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<!-- Foreign Key users::uid or NULL -->
			<field>
				<name>share_with</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>255</length>
			</field>

			<!-- Foreign Key users::uid -->
            <!-- This is the owner of the share
                 which does not have to be the initiator of the share -->
			<field>
				<name>uid_owner</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<!-- Foreign Key users::uid -->
            <!-- This is the initiator of the share -->
			<field>
				<name>uid_initiator</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>



			<!-- Foreign Key share::id or NULL -->
			<field>
				<name>parent</name>
				<type>integer</type>
				<notnull>false</notnull>
				<length>4</length>
			</field>

			<!-- E.g. file or folder -->
			<field>
				<name>item_type</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<!-- Foreign Key filecache::fileid -->
			<field>
				<name>item_source</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>255</length>
			</field>

			<field>
				<name>item_target</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>255</length>
			</field>

			<!-- Foreign Key filecache::fileid -->
			<field>
				<name>file_source</name>
				<type>integer</type>
				<notnull>false</notnull>
				<length>4</length>
			</field>

			<field>
				<name>file_target</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>512</length>
			</field>

			<!-- Permission bitfield -->
			<field>
				<name>permissions</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<!-- Time of share creation -->
			<field>
				<name>stime</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>8</length>
			</field>

			<!-- Whether the receiver accepted the share, if share_with is set. -->
			<field>
				<name>accepted</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<!-- Time of share expiration -->
			<field>
				<name>expiration</name>
				<type>timestamp</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>token</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>32</length>
			</field>

			<field>
				<name>mail_send</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<index>
				<name>item_share_type_index</name>
				<field>
					<name>item_type</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>share_type</name>
					<sorting>ascending</sorting>
				</field>
			</index>
			<index>
				<name>file_source_index</name>
				<field>
					<name>file_source</name>
					<sorting>ascending</sorting>
				</field>
			</index>
			<index>
				<name>token_index</name>
				<field>
					<name>token</name>
					<sorting>ascending</sorting>
				</field>
			</index>
		</declaration>

	</table>

	<table>

		<!--
		Scheduled background jobs.
		See OC\BackgroundJob\JobList.
		-->
		<name>*dbprefix*jobs</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>class</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>argument</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>4000</length>
			</field>

			<field>
				<!-- timestamp when the job was executed the last time -->
				<name>last_run</name>
				<type>integer</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<!-- timestamp when the job was checked if it needs execution the last time -->
				<name>last_checked</name>
				<type>integer</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<!-- timestamp when the job was reserved the last time, 1 day timeout -->
				<name>reserved_at</name>
				<type>integer</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<index>
				<name>job_class_index</name>
				<field>
					<name>class</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		List of usernames, their display name and login password.
		-->
		<name>*dbprefix*users</name>

		<declaration>

			<field>
				<name>uid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>displayname</name>
				<type>text</type>
				<default></default>
				<length>64</length>
			</field>

			<field>
				<name>password</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<index>
				<name>users_pKey</name>
				<primary>true</primary>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>
		<name>*dbprefix*authtoken</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<!-- Foreign Key users::uid -->
			<field>
				<name>uid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>login_name</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>password</name>
				<type>clob</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>name</name>
				<type>clob</type>
				<default></default>
				<notnull>true</notnull>
			</field>

			<field>
				<name>token</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>200</length>
			</field>

			<field>
				<name>type</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>2</length>
			</field>

			<field>
				<name>last_activity</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>last_check</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<index>
				<name>authtoken_token_index</name>
				<unique>true</unique>
				<field>
					<name>token</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>authtoken_last_activity_index</name>
				<field>
					<name>last_activity</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>
	</table>

	<table>

		<!--
		List of usernames, their display name and login password.
		-->
		<name>*dbprefix*bruteforce_attempts</name>

		<declaration>
			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>action</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>occurred</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>ip</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>subnet</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>metadata</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<index>
				<name>bruteforce_attempts_ip</name>
				<field>
					<name>ip</name>
					<sorting>ascending</sorting>
				</field>
			</index>
			<index>
				<name>bruteforce_attempts_subnet</name>
				<field>
					<name>subnet</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>

		<!--
		List of tags (category) + a unique tag id (id) per user (uid) and type.
		-->
		<name>*dbprefix*vcategory</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<!-- Foreign Key users::uid -->
			<field>
				<name>uid</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>type</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>category</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<index>
				<name>uid_index</name>
				<field>
					<name>uid</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>type_index</name>
				<field>
					<name>type</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>category_index</name>
				<field>
					<name>category</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>
	</table>

	<table>

		<!--
		Object-Tag associations per tag type.
		-->
		<name>*dbprefix*vcategory_to_object</name>

		<declaration>

		<field>
			<name>objid</name>
			<type>integer</type>
			<default>0</default>
			<notnull>true</notnull>
			<unsigned>true</unsigned>
			<length>4</length>
		</field>

		<!-- Foreign Key vcategory::id -->
		<field>
			<name>categoryid</name>
			<type>integer</type>
			<default>0</default>
			<notnull>true</notnull>
			<unsigned>true</unsigned>
			<length>4</length>
		</field>

		<field>
			<name>type</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>64</length>
		</field>

		<index>
			<primary>true</primary>
			<unique>true</unique>
			<name>category_object_index</name>
			<field>
				<name>categoryid</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>objid</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>type</name>
				<sorting>ascending</sorting>
			</field>
		</index>

		<index>
			<name>vcategory_objectd_index</name>
			<field>
				<name>objid</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>type</name>
				<sorting>ascending</sorting>
			</field>
		</index>

		</declaration>

	</table>

	<table>
		<!--
		List of system-wide tags
		-->
		<name>*dbprefix*systemtag</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<!-- Tag name -->
			<field>
				<name>name</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<!-- Visibility: 0 user-not-visible, 1 user-visible -->
			<field>
				<name>visibility</name>
				<type>integer</type>
				<default>1</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<!-- Editable: 0 user-not-editable, 1 user-editable -->
			<field>
				<name>editable</name>
				<type>integer</type>
				<default>1</default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<index>
				<name>tag_ident</name>
				<unique>true</unique>
				<field>
					<name>name</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>visibility</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>editable</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>
	</table>

	<table>

		<!--
		System tag to object associations per object type.
		-->
		<name>*dbprefix*systemtag_object_mapping</name>

		<declaration>

		<!-- object id (ex: file id for files)-->
		<field>
			<name>objectid</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>64</length>
		</field>

		<!-- object type (ex: "files")-->
		<field>
			<name>objecttype</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>64</length>
		</field>

		<!-- Foreign Key systemtag::id -->
		<field>
			<name>systemtagid</name>
			<type>integer</type>
			<default>0</default>
			<notnull>true</notnull>
			<unsigned>true</unsigned>
			<length>4</length>
		</field>

		<index>
			<unique>true</unique>
			<name>mapping</name>
			<field>
				<name>objecttype</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>objectid</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>systemtagid</name>
				<sorting>ascending</sorting>
			</field>
		</index>

		</declaration>

	</table>

	<table>

		<!--
		System tag to group mapping
		-->
		<name>*dbprefix*systemtag_group</name>

		<declaration>

		<!-- Foreign Key systemtag::id -->
		<field>
			<name>systemtagid</name>
			<type>integer</type>
			<default>0</default>
			<notnull>true</notnull>
			<unsigned>true</unsigned>
			<length>4</length>
		</field>

		<field>
			<name>gid</name>
			<type>string</type>
			<notnull>true</notnull>
		</field>

		<index>
			<name>systemtag_group</name>
			<primary>true</primary>
			<unique>true</unique>
			<field>
				<name>gid</name>
				<sorting>ascending</sorting>
			</field>
			<field>
				<name>systemtagid</name>
				<sorting>ascending</sorting>
			</field>
		</index>

		</declaration>

	</table>

	<table>

		<!--
		Namespaced Key-Value Store for arbitrary data.
		 - Keys are namespaced per userid and appid.
		 - E.g. (admin, files, foo) -> bar
		-->
		<name>*dbprefix*privatedata</name>

		<declaration>

		<field>
			<name>keyid</name>
			<type>integer</type>
			<default>0</default>
			<notnull>true</notnull>
			<unsigned>true</unsigned>
			<length>4</length>
			<autoincrement>1</autoincrement>
		</field>

		<!-- Foreign Key users::uid -->
		<field>
			<name>user</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>64</length>
		</field>

		<field>
			<name>app</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>255</length>
		</field>

		<field>
			<name>key</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>255</length>
		</field>

		<field>
			<name>value</name>
			<type>text</type>
			<default></default>
			<notnull>true</notnull>
			<length>255</length>
		</field>

		<index>
			<primary>true</primary>
			<unique>true</unique>
			<name>keyid_index</name>
			<field>
				<name>keyid</name>
				<sorting>ascending</sorting>
			</field>
		</index>

		</declaration>

	</table>

	<table>

		<!--
		Table for storing transactional file locking
		-->
		<name>*dbprefix*file_locks</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
				<autoincrement>1</autoincrement>
			</field>

			<field>
				<name>lock</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<field>
				<name>key</name>
				<type>text</type>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>ttl</name>
				<type>integer</type>
				<default>-1</default>
				<notnull>true</notnull>
				<length>4</length>
			</field>

			<index>
				<primary>true</primary>
				<unique>true</unique>
				<name>lock_id_index</name>
				<field>
					<name>id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<unique>true</unique>
				<name>lock_key_index</name>
				<field>
					<name>key</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>lock_ttl_index</name>
				<field>
					<name>ttl</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>
		<!--
		default place to store comment data
		-->
		<name>*dbprefix*comments</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
				<autoincrement>1</autoincrement>
			</field>

			<field>
				<name>parent_id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>topmost_parent_id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>children_count</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<unsigned>true</unsigned>
				<length>4</length>
			</field>

			<field>
				<name>actor_type</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>actor_id</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>message</name>
				<type>clob</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>verb</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>

			<field>
				<name>creation_timestamp</name>
				<type>timestamp</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>latest_child_timestamp</name>
				<type>timestamp</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>object_type</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>object_id</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<index>
				<name>comments_parent_id_index</name>
				<unique>false</unique>
				<field>
					<name>parent_id</name>
					<sorting>descending</sorting>
				</field>
			</index>

			<index>
				<name>comments_topmost_parent_id_idx</name>
				<unique>false</unique>
				<field>
					<name>topmost_parent_id</name>
					<sorting>descending</sorting>
				</field>
			</index>

			<index>
				<name>comments_object_index</name>
				<unique>false</unique>
				<field>
					<name>object_type</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>object_id</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>creation_timestamp</name>
					<sorting>descending</sorting>
				</field>
			</index>

			<index>
				<name>comments_actor_index</name>
				<unique>false</unique>
				<field>
					<name>actor_type</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>actor_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>
		<!--
		default place to store per user and object read markers
		-->
		<name>*dbprefix*comments_read_markers</name>

		<declaration>

			<field>
				<name>user_id</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>marker_datetime</name>
				<type>timestamp</type>
				<default></default>
				<notnull>false</notnull>
			</field>

			<field>
				<name>object_type</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>object_id</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<index>
				<name>comments_marker_object_index</name>
				<unique>false</unique>
				<field>
					<name>object_type</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>object_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>comments_marker_index</name>
				<unique>true</unique>
				<field>
					<name>user_id</name>
					<sorting>descending</sorting>
				</field>
				<field>
					<name>object_type</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>object_id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>
		<!--
		Encrypted credentials storage
		-->
		<name>*dbprefix*credentials</name>

		<declaration>

			<field>
				<name>user</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>

			<field>
				<name>identifier</name>
				<type>text</type>
				<notnull>true</notnull>
				<length>64</length>
			</field>

			<field>
				<name>credentials</name>
				<type>clob</type>
				<notnull>false</notnull>
			</field>

			<index>
				<name>credentials_user_id</name>
				<primary>true</primary>
				<unique>true</unique>
				<field>
					<name>user</name>
					<sorting>ascending</sorting>
				</field>
				<field>
					<name>identifier</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>credentials_user</name>
				<unique>false</unique>
				<field>
					<name>user</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>

	</table>

	<table>
		<!-- Extra admin settings sections -->
		<name>*dbprefix*admin_sections</name>

		<declaration>

			<field>
				<name>id</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>

			<field>
				<name>class</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<field>
				<name>priority</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<index>
				<name>admin_sections_id_index</name>
				<primary>true</primary>
				<field>
					<name>id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>admin_sections_class</name>
				<unique>true</unique>
				<field>
					<name>class</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>
	</table>

	<table>
		<!-- Extra admin settings -->
		<name>*dbprefix*admin_settings</name>

		<declaration>

			<field>
				<name>id</name>
				<type>integer</type>
				<default>0</default>
				<notnull>true</notnull>
				<autoincrement>1</autoincrement>
				<length>4</length>
			</field>

			<field>
				<name>class</name>
				<type>text</type>
				<default></default>
				<notnull>true</notnull>
				<length>255</length>
			</field>

			<!-- id of the section, foreign key: admin_sections.id -->
			<field>
				<name>section</name>
				<type>text</type>
				<default></default>
				<notnull>false</notnull>
				<length>64</length>
			</field>

			<field>
				<name>priority</name>
				<type>integer</type>
				<default></default>
				<notnull>true</notnull>
				<length>1</length>
			</field>

			<index>
				<name>admin_settings_id_index</name>
				<primary>true</primary>
				<field>
					<name>id</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>admin_settings_class</name>
				<unique>true</unique>
				<field>
					<name>class</name>
					<sorting>ascending</sorting>
				</field>
			</index>

			<index>
				<name>admin_settings_section</name>
				<unique>false</unique>
				<field>
					<name>section</name>
					<sorting>ascending</sorting>
				</field>
			</index>

		</declaration>
	</table>

</database>