[Owncloud] Core db schema broken and unfixable without new installation

[André Schild]

Am 18.03.2013 18:49, schrieb Bernhard Posselt:
> On 03/18/2013 06:48 PM, Thomas Tanghus wrote:
>> On Monday 18 March 2013 17:15 Bernhard Posselt wrote:
>>> I've tried adding those fields and removing the primary key values from
>>> the indices fields (why the fuck are they even in there!?)
>> An unique index defined as primary is AFAIK a primary key.
>>
> Yeah but if the field that the index refers to is a primary key, then 
> so is the index. Or am i wrong?
Some databases automatically create indexes for PK fields,
for others you have to create a index for PK fields.

And if the database has a concept of Primarykey is not always granted 
(But today most DB have this concept)

In a DB schema PK fields makes most sense when you then also use them in 
foreign keys, that way your data integrity
is protected by the database. (You can't insert children without parents 
etc.)

André