6.0.0-beta1
8/2/25

[#5862] Missing turba table creation in groupware.mysql.sql
Summary Missing turba table creation in groupware.mysql.sql
Queue Horde Groupware Webmail Edition
Queue Version 1.0.3
Type Bug
State Resolved
Priority 2. Medium
Owners
Requester lfbm.andamentos (at) gmail (dot) com
Created 11/04/2007 (6481 days ago)
Due
Updated 11/18/2007 (6467 days ago)
Assigned 11/05/2007 (6480 days ago)
Resolved 11/18/2007 (6467 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
11/18/2007 12:00:32 PM Jan Schneider Comment #4
State ⇒ Resolved
Reply to this comment
The scripts with the new names will be included with HGW 1.1 or 1.0.4 
if there ever will be a 1.0 release with a newer Turba version.
11/05/2007 04:28:39 PM Chuck Hagenbuch Comment #3 Reply to this comment
I've thought for a while that we should keep it as turba_objects 
because that's the table, and you can use turba with other tables. But 
I think it's time to let go of that to make the default install 
easier, so just turba.sql is okay with me.
11/05/2007 11:17:46 AM Jan Schneider Comment #2
State ⇒ Feedback
Reply to this comment
Question to all developers: should we rename the default schema sql 
script to turba.sql (instead of turba_objects.sql) so that it's picked 
up automatically from the groupware build script? Or is there any 
reason to keep the current name and we should better work around this 
in the build script?
11/04/2007 06:08:14 PM lfbm (dot) andamentos (at) gmail (dot) com Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Missing turba table creation in groupware.mysql.sql
Queue ⇒ Horde Groupware Webmail Edition
State ⇒ Unconfirmed
Reply to this comment
$Horde: horde/scripts/sql/create.mysql.sql,v 1.4.6.10 2007/09/27 
22:36:49 jan Exp $

[I think the description should say: "../sql/groupware.mysql.sql ..."



There is no turba table creation in the script:



"CREATE TABLE turba_objects (

     object_id VARCHAR(32) NOT NULL,

     owner_id VARCHAR(255) NOT NULL,

     object_type VARCHAR(255) NOT NULL DEFAULT 'Object',

     object_uid VARCHAR(255),

     object_members BLOB,

     object_name VARCHAR(255),

     object_alias VARCHAR(32),

     object_email VARCHAR(255),

     object_homeaddress VARCHAR(255),

     object_workaddress VARCHAR(255),

     object_homephone VARCHAR(25),

     object_workphone VARCHAR(25),

     object_cellphone VARCHAR(25),

     object_fax VARCHAR(25),

     object_title VARCHAR(255),

     object_company VARCHAR(255),

     object_notes TEXT,

     object_pgppublickey TEXT,

     object_smimepublickey TEXT,

     object_freebusyurl VARCHAR(255),



     PRIMARY KEY(object_id)

);



CREATE INDEX turba_owner_idx ON turba_objects (owner_id);



GRANT SELECT, INSERT, UPDATE, DELETE ON turba_objects TO horde@localhost;"


Saved Queries