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

Mon Mar 18 21:30:37 UTC 2013

I don’t know much about databases, but in general wouldn’t it be good to
define which databases we support? Like: MySQL, SQLite, PostgreSQL, Oracle,
more?

Much like for browsers, we only support down to IE8. Servers only Apache,
and I’m not sure if IIS. But Ngninx or Lighttpd I think not really. PHP
version 5.3 minimum. Javascript required.

Do we have a clear requirements page like this somewhere on the website? If
not we need it, so that everyone clearly knows what we need to support,
what needs to be tested against, and what the baseline is. And what we
explicitly _do not_ support because we can’t do it all.

On Mon, Mar 18, 2013 at 7:05 PM, André Schild <a.schild at aarboard.ch> wrote:

> 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é
> ______________________________**_________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/**listinfo/owncloud<https://mail.kde.org/mailman/listinfo/owncloud>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20130318/73c08781/attachment.html>