-- MySQL dump 10.11
--
-- Host: localhost    Database: horde
-- ------------------------------------------------------
-- Server version	5.0.67

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `horde_alarms`
--

DROP TABLE IF EXISTS `horde_alarms`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_alarms` (
  `alarm_id` varchar(250) NOT NULL,
  `alarm_uid` varchar(250) NOT NULL,
  `alarm_start` datetime NOT NULL,
  `alarm_end` datetime default NULL,
  `alarm_methods` varchar(255) default NULL,
  `alarm_params` text,
  `alarm_title` varchar(255) NOT NULL,
  `alarm_text` text,
  `alarm_snooze` datetime default NULL,
  `alarm_dismissed` tinyint(1) NOT NULL default '0',
  `alarm_internal` text,
  KEY `alarm_id_idx` (`alarm_id`),
  KEY `alarm_user_idx` (`alarm_uid`),
  KEY `alarm_start_idx` (`alarm_start`),
  KEY `alarm_end_idx` (`alarm_end`),
  KEY `alarm_snooze_idx` (`alarm_snooze`),
  KEY `alarm_dismissed_idx` (`alarm_dismissed`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_alarms`
--

LOCK TABLES `horde_alarms` WRITE;
/*!40000 ALTER TABLE `horde_alarms` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_alarms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_cache`
--

DROP TABLE IF EXISTS `horde_cache`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_cache` (
  `cache_id` varchar(32) NOT NULL,
  `cache_timestamp` bigint(20) NOT NULL,
  `cache_expiration` bigint(20) NOT NULL,
  `cache_data` longblob,
  PRIMARY KEY  (`cache_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_cache`
--

LOCK TABLES `horde_cache` WRITE;
/*!40000 ALTER TABLE `horde_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_datatree`
--

DROP TABLE IF EXISTS `horde_datatree`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_datatree` (
  `datatree_id` int(10) unsigned NOT NULL,
  `group_uid` varchar(255) NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  `datatree_name` varchar(255) NOT NULL,
  `datatree_parents` varchar(255) NOT NULL,
  `datatree_order` int(11) default NULL,
  `datatree_data` text,
  `datatree_serialized` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`datatree_id`),
  KEY `datatree_datatree_name_idx` (`datatree_name`),
  KEY `datatree_group_idx` (`group_uid`),
  KEY `datatree_user_idx` (`user_uid`),
  KEY `datatree_serialized_idx` (`datatree_serialized`),
  KEY `datatree_parents_idx` (`datatree_parents`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_datatree`
--

LOCK TABLES `horde_datatree` WRITE;
/*!40000 ALTER TABLE `horde_datatree` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_datatree` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_datatree_attributes`
--

DROP TABLE IF EXISTS `horde_datatree_attributes`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_datatree_attributes` (
  `datatree_id` int(10) unsigned NOT NULL,
  `attribute_name` varchar(255) NOT NULL,
  `attribute_key` varchar(255) NOT NULL default '',
  `attribute_value` text,
  KEY `datatree_attribute_idx` (`datatree_id`),
  KEY `datatree_attribute_name_idx` (`attribute_name`),
  KEY `datatree_attribute_key_idx` (`attribute_key`),
  KEY `datatree_attribute_value_idx` (`attribute_value`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_datatree_attributes`
--

LOCK TABLES `horde_datatree_attributes` WRITE;
/*!40000 ALTER TABLE `horde_datatree_attributes` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_datatree_attributes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_groups`
--

DROP TABLE IF EXISTS `horde_groups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_groups` (
  `group_uid` int(10) unsigned NOT NULL,
  `group_name` varchar(255) NOT NULL,
  `group_parents` varchar(255) NOT NULL,
  `group_email` varchar(255) default NULL,
  PRIMARY KEY  (`group_uid`),
  UNIQUE KEY `group_name` (`group_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_groups`
--

LOCK TABLES `horde_groups` WRITE;
/*!40000 ALTER TABLE `horde_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_groups_members`
--

DROP TABLE IF EXISTS `horde_groups_members`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_groups_members` (
  `group_uid` int(10) unsigned NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  KEY `group_uid_idx` (`group_uid`),
  KEY `user_uid_idx` (`user_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_groups_members`
--

LOCK TABLES `horde_groups_members` WRITE;
/*!40000 ALTER TABLE `horde_groups_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_groups_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_histories`
--

DROP TABLE IF EXISTS `horde_histories`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_histories` (
  `history_id` int(10) unsigned NOT NULL,
  `object_uid` varchar(255) NOT NULL,
  `history_action` varchar(32) NOT NULL,
  `history_ts` bigint(20) NOT NULL,
  `history_desc` text,
  `history_who` varchar(255) default NULL,
  `history_extra` text,
  PRIMARY KEY  (`history_id`),
  KEY `history_action_idx` (`history_action`),
  KEY `history_ts_idx` (`history_ts`),
  KEY `history_uid_idx` (`object_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_histories`
--

LOCK TABLES `horde_histories` WRITE;
/*!40000 ALTER TABLE `horde_histories` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_histories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_locks`
--

DROP TABLE IF EXISTS `horde_locks`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_locks` (
  `lock_id` varchar(36) NOT NULL,
  `lock_owner` varchar(32) NOT NULL,
  `lock_scope` varchar(32) NOT NULL,
  `lock_principal` varchar(255) NOT NULL,
  `lock_origin_timestamp` bigint(20) NOT NULL,
  `lock_update_timestamp` bigint(20) NOT NULL,
  `lock_expiry_timestamp` bigint(20) NOT NULL,
  `lock_type` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY  (`lock_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_locks`
--

LOCK TABLES `horde_locks` WRITE;
/*!40000 ALTER TABLE `horde_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_perms`
--

DROP TABLE IF EXISTS `horde_perms`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_perms` (
  `perm_id` int(11) NOT NULL,
  `perm_name` varchar(255) NOT NULL,
  `perm_parents` varchar(255) NOT NULL,
  `perm_data` text,
  PRIMARY KEY  (`perm_id`),
  UNIQUE KEY `perm_name` (`perm_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_perms`
--

LOCK TABLES `horde_perms` WRITE;
/*!40000 ALTER TABLE `horde_perms` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_perms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_prefs`
--

DROP TABLE IF EXISTS `horde_prefs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_prefs` (
  `pref_uid` varchar(200) NOT NULL,
  `pref_scope` varchar(16) NOT NULL default '',
  `pref_name` varchar(32) NOT NULL,
  `pref_value` longtext,
  PRIMARY KEY  (`pref_uid`,`pref_scope`,`pref_name`),
  KEY `pref_uid_idx` (`pref_uid`),
  KEY `pref_scope_idx` (`pref_scope`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_prefs`
--

LOCK TABLES `horde_prefs` WRITE;
/*!40000 ALTER TABLE `horde_prefs` DISABLE KEYS */;
INSERT INTO `horde_prefs` VALUES ('Administrator','horde','last_login','a:2:{s:4:\"time\";i:1228087893;s:4:\"host\";s:39:\"ip109-49-242-200.mns.wavetelecom.com.br\";}'),('diogo@opuromel.com.br','horde','last_maintenance','1228093155'),('diogo@opuromel.com.br','horde','last_login','a:2:{s:4:\"time\";i:1228093155;s:4:\"host\";s:39:\"ip109-49-242-200.mns.wavetelecom.com.br\";}'),('diogo@opuromel.com.br','imp','expanded_folders','a:0:{}'),('diogo@opuromel.com.br','imp','vinbox_id','52p6kf3dgjoksc0og48g0w'),('diogo@opuromel.com.br','imp','vfolder','a:0:{}'),('amazonti@editoranovotempo.com.br','horde','last_maintenance','1228092576'),('amazonti@editoranovotempo.com.br','horde','last_login','a:2:{s:4:\"time\";i:1228092576;s:4:\"host\";s:39:\"ip109-49-242-200.mns.wavetelecom.com.br\";}'),('amazonti@editoranovotempo.com.br','imp','expanded_folders','a:0:{}'),('amazonti@editoranovotempo.com.br','imp','vinbox_id','3xk5rdoujj6s4wswkcccc'),('diogo@opuromel.com.br','turba','addressbooks','\nd52335bbe2559c25b8c6e6ed988fcdfc\n010c6a92c04adad05b1bcec259bcc51b\n997b6a71c2f005582eef27814160bd64\n3fea3bdccdcff116a6660eb262cf82df\nd568021a44288639fea7e3b092f6876d\na54b1533edbbc9522c9c0b597247d582\nbc392d7976cac7e717447d3713f061bd\n17534a5f1f28498bb1db92c98f56abc6\n61361943c827165d51de09851b80e044\n9eff45088b5e596205915aa47353b0db\n058532a0c0746edbe1513dc786416c18\n5a9b635d0880b06e835f499bb5adb536\n23183914260d0af9d34f6500e04a692a\n31f74f4e3f779e458600d800c0845783\n8769cb07885eced5f01a85bd0d22789b\nefe25b84e3888d571d4910d0cf237ea5\n3900fed961a4079ab5a26515d64df611\ndf95ac5f9ba7bf651ff144ac33fadfd9\nabb086eaffb5a6e3393b1228ccb8fd48\n3f62742626402d87ba965cbd393708f8'),('diogo@opuromel.com.br','turba','columns','netcenter	email\nverisign	email\nd52335bbe2559c25b8c6e6ed988fcdfc	email'),('diogo@opuromel.com.br','turba','turba_maintenance_tasks','a:2:{i:0;s:12:\"upgradeprefs\";i:1;s:12:\"upgradelists\";}'),('amazonti@editoranovotempo.com.br','turba','addressbooks','\nfe4f87675ea41952482b664e9728363d\n86fde5e3b9701178b103a79124be1413\na4df62c7091cfa0d002df00cd8c381bb\n5f500e3b370d21c9640d42d565a30254\nb149f86334d1f37dc5a330fee33873ce\na8d289ce83a257e1cf9172b9dd810308\ndd18781841e0f6a3abda259d6403aa11\ne30097944b8e8fdff8f0ec7f196905f7\n7e9685ff2825e3764caa9cb783304f42\n54b7d265cf16ea601de0a456b665838a\ne5eb09fe7bd9334ba267a1cd2005abcb\nb9538a971b9e5bb729ed5f4a80c53cc9'),('amazonti@editoranovotempo.com.br','turba','columns','netcenter	email\nverisign	email\nfe4f87675ea41952482b664e9728363d	email'),('amazonti@editoranovotempo.com.br','turba','turba_maintenance_tasks','a:2:{i:0;s:12:\"upgradeprefs\";i:1;s:12:\"upgradelists\";}'),('diogo@opuromel.com.br','horde','theme','bluewhite'),('diogo@opuromel.com.br','horde','summary_refresh_time','300'),('diogo@opuromel.com.br','horde','show_sidebar','1'),('diogo@opuromel.com.br','horde','sidebar_width','200'),('diogo@opuromel.com.br','horde','menu_view','both'),('diogo@opuromel.com.br','horde','menu_refresh_time','300'),('diogo@opuromel.com.br','horde','initial_application','horde'),('diogo@opuromel.com.br','horde','widget_accesskey','1'),('diogo@opuromel.com.br','horde','show_last_login','1'),('diogo@opuromel.com.br','turba','sync_books','a:1:{i:0;s:32:\"df95ac5f9ba7bf651ff144ac33fadfd9\";}');
/*!40000 ALTER TABLE `horde_prefs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_sessionhandler`
--

DROP TABLE IF EXISTS `horde_sessionhandler`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_sessionhandler` (
  `session_id` varchar(32) NOT NULL,
  `session_lastmodified` bigint(20) NOT NULL,
  `session_data` longblob,
  PRIMARY KEY  (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_sessionhandler`
--

LOCK TABLES `horde_sessionhandler` WRITE;
/*!40000 ALTER TABLE `horde_sessionhandler` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_sessionhandler` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_signups`
--

DROP TABLE IF EXISTS `horde_signups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_signups` (
  `user_name` varchar(255) NOT NULL,
  `signup_date` varchar(255) NOT NULL,
  `signup_host` varchar(255) NOT NULL,
  `signup_email` varchar(255) NOT NULL,
  `signup_data` text NOT NULL,
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `signup_email` (`signup_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_signups`
--

LOCK TABLES `horde_signups` WRITE;
/*!40000 ALTER TABLE `horde_signups` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_signups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_syncml_anchors`
--

DROP TABLE IF EXISTS `horde_syncml_anchors`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_syncml_anchors` (
  `syncml_syncpartner` varchar(255) NOT NULL,
  `syncml_db` varchar(255) NOT NULL,
  `syncml_uid` varchar(255) NOT NULL,
  `syncml_clientanchor` varchar(255) default NULL,
  `syncml_serveranchor` varchar(255) default NULL,
  KEY `syncml_anchors_syncpartner_idx` (`syncml_syncpartner`),
  KEY `syncml_anchors_db_idx` (`syncml_db`),
  KEY `syncml_anchors_uid_idx` (`syncml_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_syncml_anchors`
--

LOCK TABLES `horde_syncml_anchors` WRITE;
/*!40000 ALTER TABLE `horde_syncml_anchors` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_syncml_anchors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_syncml_map`
--

DROP TABLE IF EXISTS `horde_syncml_map`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_syncml_map` (
  `syncml_syncpartner` varchar(255) NOT NULL,
  `syncml_db` varchar(255) NOT NULL,
  `syncml_uid` varchar(255) NOT NULL,
  `syncml_cuid` varchar(255) default NULL,
  `syncml_suid` varchar(255) default NULL,
  `syncml_timestamp` int(11) default NULL,
  KEY `syncml_syncpartner_idx` (`syncml_syncpartner`),
  KEY `syncml_db_idx` (`syncml_db`),
  KEY `syncml_uid_idx` (`syncml_uid`),
  KEY `syncml_cuid_idx` (`syncml_cuid`),
  KEY `syncml_suid_idx` (`syncml_suid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_syncml_map`
--

LOCK TABLES `horde_syncml_map` WRITE;
/*!40000 ALTER TABLE `horde_syncml_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_syncml_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_tokens`
--

DROP TABLE IF EXISTS `horde_tokens`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_tokens` (
  `token_address` varchar(100) NOT NULL,
  `token_id` varchar(32) NOT NULL,
  `token_timestamp` bigint(20) NOT NULL,
  PRIMARY KEY  (`token_address`,`token_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_tokens`
--

LOCK TABLES `horde_tokens` WRITE;
/*!40000 ALTER TABLE `horde_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_users`
--

DROP TABLE IF EXISTS `horde_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_users` (
  `user_uid` varchar(255) NOT NULL,
  `user_pass` varchar(255) NOT NULL,
  `user_soft_expiration_date` int(11) default NULL,
  `user_hard_expiration_date` int(11) default NULL,
  PRIMARY KEY  (`user_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_users`
--

LOCK TABLES `horde_users` WRITE;
/*!40000 ALTER TABLE `horde_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horde_vfs`
--

DROP TABLE IF EXISTS `horde_vfs`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `horde_vfs` (
  `vfs_id` int(10) unsigned NOT NULL,
  `vfs_type` smallint(5) unsigned NOT NULL,
  `vfs_path` varchar(255) NOT NULL,
  `vfs_name` varchar(255) NOT NULL,
  `vfs_modified` bigint(20) NOT NULL,
  `vfs_owner` varchar(255) NOT NULL,
  `vfs_data` longblob,
  PRIMARY KEY  (`vfs_id`),
  KEY `vfs_path_idx` (`vfs_path`),
  KEY `vfs_name_idx` (`vfs_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `horde_vfs`
--

LOCK TABLES `horde_vfs` WRITE;
/*!40000 ALTER TABLE `horde_vfs` DISABLE KEYS */;
/*!40000 ALTER TABLE `horde_vfs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `turba_objects`
--

DROP TABLE IF EXISTS `turba_objects`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
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) default NULL,
  `object_members` blob,
  `object_firstname` varchar(255) default NULL,
  `object_lastname` varchar(255) default NULL,
  `object_middlenames` varchar(255) default NULL,
  `object_nameprefix` varchar(32) default NULL,
  `object_namesuffix` varchar(32) default NULL,
  `object_alias` varchar(32) default NULL,
  `object_photo` blob,
  `object_phototype` varchar(10) default NULL,
  `object_bday` varchar(10) default NULL,
  `object_homestreet` varchar(255) default NULL,
  `object_homepob` varchar(10) default NULL,
  `object_homecity` varchar(255) default NULL,
  `object_homeprovince` varchar(255) default NULL,
  `object_homepostalcode` varchar(10) default NULL,
  `object_homecountry` varchar(255) default NULL,
  `object_workstreet` varchar(255) default NULL,
  `object_workpob` varchar(10) default NULL,
  `object_workcity` varchar(255) default NULL,
  `object_workprovince` varchar(255) default NULL,
  `object_workpostalcode` varchar(10) default NULL,
  `object_workcountry` varchar(255) default NULL,
  `object_tz` varchar(32) default NULL,
  `object_geo` varchar(255) default NULL,
  `object_email` varchar(255) default NULL,
  `object_homephone` varchar(25) default NULL,
  `object_workphone` varchar(25) default NULL,
  `object_cellphone` varchar(25) default NULL,
  `object_fax` varchar(25) default NULL,
  `object_pager` varchar(25) default NULL,
  `object_title` varchar(255) default NULL,
  `object_role` varchar(255) default NULL,
  `object_logo` blob,
  `object_logotype` varchar(10) default NULL,
  `object_company` varchar(255) default NULL,
  `object_category` varchar(80) default NULL,
  `object_notes` text,
  `object_url` varchar(255) default NULL,
  `object_freebusyurl` varchar(255) default NULL,
  `object_pgppublickey` text,
  `object_smimepublickey` text,
  PRIMARY KEY  (`object_id`),
  KEY `turba_owner_idx` (`owner_id`),
  KEY `turba_email_idx` (`object_email`),
  KEY `turba_firstname_idx` (`object_firstname`),
  KEY `turba_lastname_idx` (`object_lastname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `turba_objects`
--

LOCK TABLES `turba_objects` WRITE;
/*!40000 ALTER TABLE `turba_objects` DISABLE KEYS */;
/*!40000 ALTER TABLE `turba_objects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `turba_shares`
--

DROP TABLE IF EXISTS `turba_shares`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `turba_shares` (
  `share_id` int(11) NOT NULL,
  `share_name` varchar(255) NOT NULL,
  `share_owner` varchar(32) NOT NULL,
  `share_flags` smallint(6) NOT NULL default '0',
  `perm_creator` smallint(6) NOT NULL default '0',
  `perm_default` smallint(6) NOT NULL default '0',
  `perm_guest` smallint(6) NOT NULL default '0',
  `attribute_name` varchar(255) NOT NULL,
  `attribute_desc` varchar(255) default NULL,
  `attribute_params` text,
  PRIMARY KEY  (`share_id`),
  KEY `turba_shares_share_name_idx` (`share_name`),
  KEY `turba_shares_share_owner_idx` (`share_owner`),
  KEY `turba_shares_perm_creator_idx` (`perm_creator`),
  KEY `turba_shares_perm_default_idx` (`perm_default`),
  KEY `turba_shares_perm_guest_idx` (`perm_guest`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `turba_shares`
--

LOCK TABLES `turba_shares` WRITE;
/*!40000 ALTER TABLE `turba_shares` DISABLE KEYS */;
/*!40000 ALTER TABLE `turba_shares` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `turba_shares_groups`
--

DROP TABLE IF EXISTS `turba_shares_groups`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `turba_shares_groups` (
  `share_id` int(11) NOT NULL,
  `group_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `turba_shares_groups_share_id_idx` (`share_id`),
  KEY `turba_shares_groups_group_uid_idx` (`group_uid`),
  KEY `turba_shares_groups_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `turba_shares_groups`
--

LOCK TABLES `turba_shares_groups` WRITE;
/*!40000 ALTER TABLE `turba_shares_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `turba_shares_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `turba_shares_users`
--

DROP TABLE IF EXISTS `turba_shares_users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `turba_shares_users` (
  `share_id` int(11) NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `turba_shares_users_share_id_idx` (`share_id`),
  KEY `turba_shares_users_user_uid_idx` (`user_uid`),
  KEY `turba_shares_users_perm_idx` (`perm`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `turba_shares_users`
--

LOCK TABLES `turba_shares_users` WRITE;
/*!40000 ALTER TABLE `turba_shares_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `turba_shares_users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-12-01  3:49:56