[Kolab-devel] Fwd: New Kolab Webclient Release

[Stephan Buys]

As I said, just the category data. So it is a minimal amount of data. The tables 
created are shown below. Theoretically it should be able to store this data in LDAP,
we have not undertaken to write such a driver yet, though...

-- Table structure for table `horde_categories`
--

CREATE TABLE horde_categories (
  category_id int(11) NOT NULL default '0',
  group_uid varchar(255) NOT NULL default '',
  user_uid varchar(255) NOT NULL default '',
  category_name varchar(255) NOT NULL default '',
  category_parents varchar(255) NOT NULL default '',
  category_order int(11) default NULL,
  category_data text,
  category_serialized smallint(6) NOT NULL default '0',
  category_updated timestamp(14) NOT NULL,
  PRIMARY KEY  (category_id),
  KEY category_category_name_idx (category_name),
  KEY category_group_idx (group_uid),
  KEY category_user_idx (user_uid),
  KEY category_serialized_idx (category_serialized)
) TYPE=MyISAM;

-- Table structure for table `horde_categories_seq`
--

CREATE TABLE horde_categories_seq (
  id int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

-- Table structure for table `horde_category_attributes`
--

CREATE TABLE horde_category_attributes (
  category_id int(11) NOT NULL default '0',
  attribute_name varchar(255) NOT NULL default '',
  attribute_key varchar(255) NOT NULL default '',
  attribute_value text,
  KEY category_attribute_idx (category_id),
  KEY category_attribute_name_idx (attribute_name),
  KEY category_attribute_key_idx (attribute_key)
) TYPE=MyISAM;

-- Table structure for table `horde_prefs`
--

CREATE TABLE horde_prefs (
  pref_uid varchar(200) NOT NULL default '',
  pref_scope varchar(16) NOT NULL default '',
  pref_name varchar(32) NOT NULL default '',
  pref_value longtext,
  PRIMARY KEY  (pref_uid,pref_scope,pref_name)
) TYPE=MyISAM;

-- Table structure for table `horde_users`
--

CREATE TABLE horde_users (
  user_uid varchar(255) NOT NULL default '',
  user_pass varchar(32) NOT NULL default '',
  PRIMARY KEY  (user_uid)
) TYPE=MyISAM;



On Wednesday 28 April 2004 23:46, Martin Konold wrote:
> Am Wednesday 28 April 2004 09:17 am schrieb Stephan Buys:
> 
> Hi Stephan,
> 
> > We need MySQL for a datasource used by Horde called a DataTree.
> > Unfortunately this only works with MySQL at the moment. It is used to store
> > the categories of the different messages, etc.
> 
> How much data is actually in the MySQL db?
> 
> Yours,
> -- martin
> 
> Dipl.-Phys. Martin Konold
> 
> e r f r a k o n
> Erlewein, Frank, Konold & Partner - Beratende Ingenieure und Physiker
> Nobelstrasse 15, 70569 Stuttgart, Germany
> fon: 0711 67400963, fax: 0711 67400959
> email: martin.konold at erfrakon.de
> 
> _______________________________________________
> Kolab-devel mailing list
> Kolab-devel at intevation.org
> https://kroupware.org/mailman/listinfo/kolab-devel
> 
> 
> 

-- 
Stephan  Buys
Code Fusion cc.
Tel: +27 11 391 1412
Mobile: +27 83 294 1876
Email: s.buys at codefusion.co.za

E-mail Solutions, Kolab Specialists.
http://www.codefusion.co.za