[Owncloud] Database Schema

[Daniel]

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.