[Tickets #7433] scripts/setup.php generates wrong database schema

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7433
------------------------------------------------------------------------------
  Ticket             | 7433
  Created By         | horde at hauke-m.de
  Summary            | scripts/setup.php generates wrong database schema
  Queue              | Horde Base
  Version            | 3.3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


horde at hauke-m.de (2008-10-05 12:34) wrote:

The script at scripts/setup.php in Horde Groupware Webmail Edition 1.2  
generates a wrong database schema.
After making a fresh install for example my horde_locks has no  
attribute lock_owner and lock_scope

This produces this error: Oct 05 17:40:12 HORDE [error] [horde] DB  
Error: no such field: SELECT lock_id, lock_owner, lock_scope,  
lock_principal, lock_origin_timestamp, lock_update_tim
estamp, lock_expiry_timestamp, lock_type FROM horde_locks WHERE  
lock_expiry_timestamp >= 1223221212 AND lock_principal =  
'/nag/hauke at hauke-m.de/hauke at hauke-m
.de.ics' AND lock_scope = 'webdav' [nativecode=1054 ** Unknown column  
'lock_owner' in 'field list'] [pid 21056 on line 536 of  
"/var/www/horde/web/lib/Horde/R
PC/webdav.php"]

After installing the tables from groupware.mysql.sql it works.
This is not the only difference between groupware.mysql.sql and the  
installed tables.