[Owncloud] Core db schema broken and unfixable without new installation
Bernhard Posselt
nukeawhale at gmail.com
Mon Mar 18 16:15:14 UTC 2013
In response to this issue: https://github.com/owncloud/core/issues/2142
There are currently no primary keys in the schema. A typical primary key
field would look like this:
<field>
<name>id</name>
<type>integer</type>
<default>0</default>
<notnull>true</notnull>
<primary>true</primary>
<unsigned>true</unsigned>
<autoincrement>true</autoincrement>
</field>
Unfortunately there is not a single field like this which makes database
replication (important business customer feature!) virtually impossible.
I've tried adding those fields and removing the primary key values from
the indices fields (why the fuck are they even in there!?) with the
result that owncloud broke and im now in maintenance mode and cant get
out of it (503 responses from server) and i cant get out by removing the
maintenance mode.
Ideas on how to fix this?
More information about the Owncloud
mailing list