-- MySQL dump 10.13  Distrib 5.1.48, for Win32 (ia32)
--
-- Host: localhost    Database: horde
-- ------------------------------------------------------
-- Server version	5.1.48-community

/*!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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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 */;
/*!40000 ALTER TABLE `horde_prefs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `horde_sessionhandler`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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`),
  KEY `session_lastmodified_idx` (`session_lastmodified`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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_data` text NOT NULL,
  PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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 `imp_sentmail`
--

DROP TABLE IF EXISTS `imp_sentmail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imp_sentmail` (
  `sentmail_id` bigint(20) NOT NULL,
  `sentmail_who` varchar(255) NOT NULL,
  `sentmail_ts` bigint(20) NOT NULL,
  `sentmail_messageid` varchar(255) NOT NULL,
  `sentmail_action` varchar(32) NOT NULL,
  `sentmail_recipient` varchar(255) NOT NULL,
  `sentmail_success` int(11) NOT NULL,
  PRIMARY KEY (`sentmail_id`),
  KEY `sentmail_ts_idx` (`sentmail_ts`),
  KEY `sentmail_who_idx` (`sentmail_who`),
  KEY `sentmail_success_idx` (`sentmail_success`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `imp_sentmail`
--

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

--
-- Table structure for table `ingo_forwards`
--

DROP TABLE IF EXISTS `ingo_forwards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_forwards` (
  `forward_owner` varchar(255) NOT NULL,
  `forward_addresses` text,
  `forward_keep` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`forward_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_forwards`
--

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

--
-- Table structure for table `ingo_lists`
--

DROP TABLE IF EXISTS `ingo_lists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_lists` (
  `list_owner` varchar(255) NOT NULL,
  `list_blacklist` int(11) DEFAULT '0',
  `list_address` varchar(255) NOT NULL,
  KEY `list_idx` (`list_owner`,`list_blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_lists`
--

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

--
-- Table structure for table `ingo_rules`
--

DROP TABLE IF EXISTS `ingo_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_rules` (
  `rule_id` int(11) NOT NULL,
  `rule_owner` varchar(255) NOT NULL,
  `rule_name` varchar(255) NOT NULL,
  `rule_action` int(11) NOT NULL,
  `rule_value` varchar(255) DEFAULT NULL,
  `rule_flags` int(11) DEFAULT NULL,
  `rule_conditions` text,
  `rule_combine` int(11) DEFAULT NULL,
  `rule_stop` int(11) DEFAULT NULL,
  `rule_active` int(11) NOT NULL DEFAULT '1',
  `rule_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rule_id`),
  KEY `rule_owner_idx` (`rule_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_rules`
--

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

--
-- Table structure for table `ingo_shares`
--

DROP TABLE IF EXISTS `ingo_shares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_shares` (
  `share_id` int(11) NOT NULL,
  `share_name` varchar(255) NOT NULL,
  `share_owner` varchar(255) 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,
  PRIMARY KEY (`share_id`),
  KEY `ingo_shares_share_name_idx` (`share_name`),
  KEY `ingo_shares_share_owner_idx` (`share_owner`),
  KEY `ingo_shares_perm_creator_idx` (`perm_creator`),
  KEY `ingo_shares_perm_default_idx` (`perm_default`),
  KEY `ingo_shares_perm_guest_idx` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_shares`
--

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

--
-- Table structure for table `ingo_shares_groups`
--

DROP TABLE IF EXISTS `ingo_shares_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_shares_groups` (
  `share_id` int(11) NOT NULL,
  `group_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `ingo_shares_groups_share_id_idx` (`share_id`),
  KEY `ingo_shares_groups_group_uid_idx` (`group_uid`),
  KEY `ingo_shares_groups_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_shares_groups`
--

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

--
-- Table structure for table `ingo_shares_users`
--

DROP TABLE IF EXISTS `ingo_shares_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_shares_users` (
  `share_id` int(11) NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `ingo_shares_users_share_id_idx` (`share_id`),
  KEY `ingo_shares_users_user_uid_idx` (`user_uid`),
  KEY `ingo_shares_users_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_shares_users`
--

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

--
-- Table structure for table `ingo_spam`
--

DROP TABLE IF EXISTS `ingo_spam`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_spam` (
  `spam_owner` varchar(255) NOT NULL,
  `spam_level` int(11) DEFAULT '5',
  `spam_folder` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`spam_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_spam`
--

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

--
-- Table structure for table `ingo_vacations`
--

DROP TABLE IF EXISTS `ingo_vacations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_vacations` (
  `vacation_owner` varchar(255) NOT NULL,
  `vacation_addresses` text,
  `vacation_subject` varchar(255) DEFAULT NULL,
  `vacation_reason` text,
  `vacation_days` int(11) DEFAULT '7',
  `vacation_start` int(11) DEFAULT NULL,
  `vacation_end` int(11) DEFAULT NULL,
  `vacation_excludes` text,
  `vacation_ignorelists` int(11) DEFAULT '1',
  PRIMARY KEY (`vacation_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ingo_vacations`
--

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

--
-- Table structure for table `kronolith_events`
--

DROP TABLE IF EXISTS `kronolith_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_events` (
  `event_id` varchar(32) NOT NULL,
  `event_uid` varchar(255) NOT NULL,
  `calendar_id` varchar(255) NOT NULL,
  `event_creator_id` varchar(255) NOT NULL,
  `event_description` text,
  `event_location` text,
  `event_status` int(11) DEFAULT '0',
  `event_attendees` text,
  `event_keywords` text,
  `event_exceptions` text,
  `event_title` varchar(255) DEFAULT NULL,
  `event_category` varchar(80) DEFAULT NULL,
  `event_recurtype` smallint(6) DEFAULT '0',
  `event_recurinterval` smallint(6) DEFAULT NULL,
  `event_recurdays` smallint(6) DEFAULT NULL,
  `event_recurenddate` datetime DEFAULT NULL,
  `event_recurcount` int(11) DEFAULT NULL,
  `event_start` datetime DEFAULT NULL,
  `event_end` datetime DEFAULT NULL,
  `event_alarm` int(11) DEFAULT '0',
  `event_modified` int(11) NOT NULL,
  `event_private` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`event_id`),
  KEY `kronolith_calendar_idx` (`calendar_id`),
  KEY `kronolith_uid_idx` (`event_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kronolith_events`
--

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

--
-- Table structure for table `kronolith_shares`
--

DROP TABLE IF EXISTS `kronolith_shares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_shares` (
  `share_id` int(11) NOT NULL,
  `share_name` varchar(255) NOT NULL,
  `share_owner` varchar(255) 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,
  PRIMARY KEY (`share_id`),
  KEY `kronolith_shares_share_name_idx` (`share_name`),
  KEY `kronolith_shares_share_owner_idx` (`share_owner`),
  KEY `kronolith_shares_perm_creator_idx` (`perm_creator`),
  KEY `kronolith_shares_perm_default_idx` (`perm_default`),
  KEY `kronolith_shares_perm_guest_idx` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kronolith_shares`
--

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

--
-- Table structure for table `kronolith_shares_groups`
--

DROP TABLE IF EXISTS `kronolith_shares_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_shares_groups` (
  `share_id` int(11) NOT NULL,
  `group_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `kronolith_shares_groups_share_id_idx` (`share_id`),
  KEY `kronolith_shares_groups_group_uid_idx` (`group_uid`),
  KEY `kronolith_shares_groups_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kronolith_shares_groups`
--

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

--
-- Table structure for table `kronolith_shares_users`
--

DROP TABLE IF EXISTS `kronolith_shares_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_shares_users` (
  `share_id` int(11) NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `kronolith_shares_users_share_id_idx` (`share_id`),
  KEY `kronolith_shares_users_user_uid_idx` (`user_uid`),
  KEY `kronolith_shares_users_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kronolith_shares_users`
--

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

--
-- Table structure for table `kronolith_storage`
--

DROP TABLE IF EXISTS `kronolith_storage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_storage` (
  `vfb_owner` varchar(255) DEFAULT NULL,
  `vfb_email` varchar(255) NOT NULL,
  `vfb_serialized` text NOT NULL,
  KEY `kronolith_vfb_owner_idx` (`vfb_owner`),
  KEY `kronolith_vfb_email_idx` (`vfb_email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kronolith_storage`
--

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

--
-- Table structure for table `mnemo_memos`
--

DROP TABLE IF EXISTS `mnemo_memos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_memos` (
  `memo_owner` varchar(255) NOT NULL,
  `memo_id` varchar(32) NOT NULL,
  `memo_uid` varchar(255) NOT NULL,
  `memo_desc` varchar(64) NOT NULL,
  `memo_body` text,
  `memo_category` varchar(80) DEFAULT NULL,
  `memo_private` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`memo_owner`,`memo_id`),
  KEY `mnemo_notepad_idx` (`memo_owner`),
  KEY `mnemo_uid_idx` (`memo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mnemo_memos`
--

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

--
-- Table structure for table `mnemo_shares`
--

DROP TABLE IF EXISTS `mnemo_shares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_shares` (
  `share_id` int(11) NOT NULL,
  `share_name` varchar(255) NOT NULL,
  `share_owner` varchar(255) 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,
  PRIMARY KEY (`share_id`),
  KEY `mnemo_shares_share_name_idx` (`share_name`),
  KEY `mnemo_shares_share_owner_idx` (`share_owner`),
  KEY `mnemo_shares_perm_creator_idx` (`perm_creator`),
  KEY `mnemo_shares_perm_default_idx` (`perm_default`),
  KEY `mnemo_shares_perm_guest_idx` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mnemo_shares`
--

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

--
-- Table structure for table `mnemo_shares_groups`
--

DROP TABLE IF EXISTS `mnemo_shares_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_shares_groups` (
  `share_id` int(11) NOT NULL,
  `group_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `mnemo_shares_groups_share_id_idx` (`share_id`),
  KEY `mnemo_shares_groups_group_uid_idx` (`group_uid`),
  KEY `mnemo_shares_groups_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mnemo_shares_groups`
--

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

--
-- Table structure for table `mnemo_shares_users`
--

DROP TABLE IF EXISTS `mnemo_shares_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_shares_users` (
  `share_id` int(11) NOT NULL,
  `user_uid` varchar(255) NOT NULL,
  `perm` smallint(6) NOT NULL,
  KEY `mnemo_shares_users_share_id_idx` (`share_id`),
  KEY `mnemo_shares_users_user_uid_idx` (`user_uid`),
  KEY `mnemo_shares_users_perm_idx` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mnemo_shares_users`
--

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

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

DROP TABLE IF EXISTS `turba_objects`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turba_shares` (
  `share_id` int(11) NOT NULL,
  `share_name` varchar(255) NOT NULL,
  `share_owner` varchar(255) 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 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=InnoDB DEFAULT CHARSET=latin1;
/*!40101 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 2017-01-26  8:03:25