Hi, I created a modified db schema for owncloud. You can find it at http://danger-it.de/owncloud/apps/files_sharing/get.php?token=37faf0c8b4d05089e4946826e5b4f4eccdb13872
There are several files: - ownclouddb-git-modified.svg is the schema that I think should be adopted in oc. It is based on the schema currently used in git master. - ownclouddb-original.svg is the schema currently used in oc3. (ok, the tables all have a suffix - just ignore that) - ownclouddb-modified.svg is a schema based on the one used in oc3. I created that to understand the structure of the db. My aim was: - to give all tables a primary key. - to add foreign keys whereever some other table is referenced. - to have only atomic values in all the tables. - to avoid 'null' values. - to avoid redundant data. The modified versions where created without looking at the code. Also I'm pretty sure, that oc will not work with the modified schema without changes in the code. I will upload SQL- and mysqlworkbench-files for ownclouddb-git-modified.svg tomorrow. Any thoughts/comments on this topic? Regards, Daniel Ps.:I'm also looking into removing 'oc_media_users' and using 'oc_users' instead. I just don't see how to do that, yet. _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
