Viewing File: /usr/local/cpanel/share/horde/horde_11.48_mysql.schema
-- MySQL dump 10.13 Distrib 5.1.73, for redhat-linux-gnu (i686)
--
-- Host: localhost Database: horde
-- ------------------------------------------------------
-- Server version 5.6.23
/*!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 `content_schema_info`
--
DROP TABLE IF EXISTS `content_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `content_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_alarm_schema_info`
--
DROP TABLE IF EXISTS `horde_alarm_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_alarm_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`alarm_id` varchar(255) NOT NULL,
`alarm_uid` varchar(255) DEFAULT 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` int(1) NOT NULL DEFAULT '0',
`alarm_internal` text,
PRIMARY KEY (`id`),
KEY `index_horde_alarms_on_alarm_id` (`alarm_id`),
KEY `index_horde_alarms_on_alarm_uid` (`alarm_uid`),
KEY `index_horde_alarms_on_alarm_start` (`alarm_start`),
KEY `index_horde_alarms_on_alarm_end` (`alarm_end`),
KEY `index_horde_alarms_on_alarm_snooze` (`alarm_snooze`),
KEY `index_horde_alarms_on_alarm_dismissed` (`alarm_dismissed`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_auth_schema_info`
--
DROP TABLE IF EXISTS `horde_auth_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_auth_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_cache_schema_info`
--
DROP TABLE IF EXISTS `horde_cache_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_cache_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_core_schema_info`
--
DROP TABLE IF EXISTS `horde_core_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_core_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_dav_collections`
--
DROP TABLE IF EXISTS `horde_dav_collections`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_dav_collections` (
`id_interface` varchar(255) NOT NULL,
`id_internal` varchar(255) NOT NULL,
`id_external` varchar(255) NOT NULL,
UNIQUE KEY `index_horde_dav_collections_on_id_external` (`id_external`),
KEY `index_horde_dav_collections_on_id_interface` (`id_interface`),
KEY `index_horde_dav_collections_on_id_internal` (`id_internal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_dav_objects`
--
DROP TABLE IF EXISTS `horde_dav_objects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_dav_objects` (
`id_collection` varchar(255) NOT NULL,
`id_internal` varchar(255) NOT NULL,
`id_external` varchar(255) NOT NULL,
UNIQUE KEY `index_horde_dav_objects_on_id_internal` (`id_internal`),
UNIQUE KEY `index_horde_dav_objects_on_id_external` (`id_external`),
KEY `index_horde_dav_objects_on_id_collection` (`id_collection`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_dav_schema_info`
--
DROP TABLE IF EXISTS `horde_dav_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_dav_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_group_schema_info`
--
DROP TABLE IF EXISTS `horde_group_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_group_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 AUTO_INCREMENT,
`group_name` varchar(255) NOT NULL,
`group_parents` varchar(255) NOT NULL,
`group_email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`group_uid`),
UNIQUE KEY `index_horde_groups_on_group_name` (`group_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 `index_horde_groups_members_on_group_uid` (`group_uid`),
KEY `index_horde_groups_members_on_user_uid` (`user_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 AUTO_INCREMENT,
`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,
`history_modseq` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`history_id`),
KEY `index_horde_histories_on_history_action` (`history_action`),
KEY `index_horde_histories_on_history_ts` (`history_ts`),
KEY `index_horde_histories_on_history_modseq` (`history_modseq`),
KEY `index_horde_histories_on_object_uid` (`object_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_histories_modseq`
--
DROP TABLE IF EXISTS `horde_histories_modseq`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_histories_modseq` (
`history_modseq` int(10) unsigned NOT NULL AUTO_INCREMENT,
`history_modseqempty` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`history_modseq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_history_schema_info`
--
DROP TABLE IF EXISTS `horde_history_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_history_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_imap_client_data`
--
DROP TABLE IF EXISTS `horde_imap_client_data`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_imap_client_data` (
`uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`hostspec` varchar(255) NOT NULL,
`mailbox` varchar(255) NOT NULL,
`modified` bigint(20) DEFAULT NULL,
`port` int(11) NOT NULL,
`username` varchar(255) NOT NULL,
PRIMARY KEY (`uid`),
KEY `index_horde_imap_client_data_on_hostspec_and_mailbox_and_port_an` (`hostspec`,`mailbox`,`port`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_imap_client_message`
--
DROP TABLE IF EXISTS `horde_imap_client_message`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_imap_client_message` (
`data` longblob,
`msguid` varchar(255) NOT NULL,
`uid` bigint(20) NOT NULL,
KEY `index_horde_imap_client_message_on_msguid_and_uid` (`msguid`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_imap_client_metadata`
--
DROP TABLE IF EXISTS `horde_imap_client_metadata`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_imap_client_metadata` (
`data` longblob,
`field` varchar(255) NOT NULL,
`uid` bigint(20) NOT NULL,
KEY `index_horde_imap_client_metadata_on_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_imap_client_schema_info`
--
DROP TABLE IF EXISTS `horde_imap_client_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_imap_client_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_lock_schema_info`
--
DROP TABLE IF EXISTS `horde_lock_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_lock_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(255) 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` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`lock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_muvfs`
--
DROP TABLE IF EXISTS `horde_muvfs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_muvfs` (
`vfs_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`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_perms` smallint(5) unsigned NOT NULL,
`vfs_data` longblob,
PRIMARY KEY (`vfs_id`),
KEY `index_horde_muvfs_on_vfs_path` (`vfs_path`),
KEY `index_horde_muvfs_on_vfs_name` (`vfs_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`perm_name` varchar(255) NOT NULL,
`perm_parents` varchar(255) NOT NULL,
`perm_data` text,
PRIMARY KEY (`perm_id`),
UNIQUE KEY `index_horde_perms_on_perm_name` (`perm_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_perms_schema_info`
--
DROP TABLE IF EXISTS `horde_perms_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_perms_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(255) NOT NULL,
`pref_scope` varchar(16) NOT NULL DEFAULT '',
`pref_name` varchar(32) NOT NULL,
`pref_value` longblob,
PRIMARY KEY (`pref_uid`,`pref_scope`,`pref_name`),
KEY `index_horde_prefs_on_pref_uid` (`pref_uid`),
KEY `index_horde_prefs_on_pref_scope` (`pref_scope`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_prefs_schema_info`
--
DROP TABLE IF EXISTS `horde_prefs_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_prefs_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_queue_schema_info`
--
DROP TABLE IF EXISTS `horde_queue_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_queue_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_queue_tasks`
--
DROP TABLE IF EXISTS `horde_queue_tasks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_queue_tasks` (
`task_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`task_queue` varchar(255) NOT NULL,
`task_fields` text NOT NULL,
PRIMARY KEY (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` int(11) NOT NULL,
`session_data` longblob,
PRIMARY KEY (`session_id`),
KEY `index_horde_sessionhandler_on_session_lastmodified` (`session_lastmodified`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_sessionhandler_schema_info`
--
DROP TABLE IF EXISTS `horde_sessionhandler_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_sessionhandler_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` int(11) NOT NULL,
`signup_host` varchar(255) NOT NULL,
`signup_data` text NOT NULL,
PRIMARY KEY (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 `index_horde_syncml_anchors_on_syncml_syncpartner` (`syncml_syncpartner`),
KEY `index_horde_syncml_anchors_on_syncml_db` (`syncml_db`),
KEY `index_horde_syncml_anchors_on_syncml_uid` (`syncml_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 `index_horde_syncml_map_on_syncml_syncpartner` (`syncml_syncpartner`),
KEY `index_horde_syncml_map_on_syncml_db` (`syncml_db`),
KEY `index_horde_syncml_map_on_syncml_uid` (`syncml_uid`),
KEY `index_horde_syncml_map_on_syncml_cuid` (`syncml_cuid`),
KEY `index_horde_syncml_map_on_syncml_suid` (`syncml_suid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_syncml_schema_info`
--
DROP TABLE IF EXISTS `horde_syncml_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_syncml_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_token_schema_info`
--
DROP TABLE IF EXISTS `horde_token_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_token_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 AUTO_INCREMENT,
`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 `index_horde_vfs_on_vfs_path` (`vfs_path`),
KEY `index_horde_vfs_on_vfs_name` (`vfs_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `horde_vfs_schema_info`
--
DROP TABLE IF EXISTS `horde_vfs_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horde_vfs_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `imp_schema_info`
--
DROP TABLE IF EXISTS `imp_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `imp_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` int(10) unsigned NOT NULL AUTO_INCREMENT,
`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 `index_imp_sentmail_on_sentmail_ts` (`sentmail_ts`),
KEY `index_imp_sentmail_on_sentmail_who` (`sentmail_who`),
KEY `index_imp_sentmail_on_sentmail_success` (`sentmail_success`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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 `index_ingo_lists_on_list_owner_and_list_blacklist` (`list_owner`,`list_blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`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 `index_ingo_rules_on_rule_owner` (`rule_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ingo_schema_info`
--
DROP TABLE IF EXISTS `ingo_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) NOT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator` int(11) NOT NULL DEFAULT '0',
`perm_default` int(11) NOT NULL DEFAULT '0',
`perm_guest` int(11) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_ingo_shares_on_share_name` (`share_name`),
KEY `index_ingo_shares_on_share_owner` (`share_owner`),
KEY `index_ingo_shares_on_perm_creator` (`perm_creator`),
KEY `index_ingo_shares_on_perm_default` (`perm_default`),
KEY `index_ingo_shares_on_perm_guest` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_ingo_shares_groups_on_share_id` (`share_id`),
KEY `index_ingo_shares_groups_on_group_uid` (`group_uid`),
KEY `index_ingo_shares_groups_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_ingo_shares_users_on_share_id` (`share_id`),
KEY `index_ingo_shares_users_on_user_uid` (`user_uid`),
KEY `index_ingo_shares_users_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ingo_sharesng`
--
DROP TABLE IF EXISTS `ingo_sharesng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_sharesng` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_16` tinyint(1) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_ingo_sharesng_on_share_name` (`share_name`),
KEY `index_ingo_sharesng_on_share_owner` (`share_owner`),
KEY `index_ingo_sharesng_on_perm_creator_2` (`perm_creator_2`),
KEY `index_ingo_sharesng_on_perm_creator_4` (`perm_creator_4`),
KEY `index_ingo_sharesng_on_perm_creator_8` (`perm_creator_8`),
KEY `index_ingo_sharesng_on_perm_creator_16` (`perm_creator_16`),
KEY `index_ingo_sharesng_on_perm_default_2` (`perm_default_2`),
KEY `index_ingo_sharesng_on_perm_default_4` (`perm_default_4`),
KEY `index_ingo_sharesng_on_perm_default_8` (`perm_default_8`),
KEY `index_ingo_sharesng_on_perm_default_16` (`perm_default_16`),
KEY `index_ingo_sharesng_on_perm_guest_2` (`perm_guest_2`),
KEY `index_ingo_sharesng_on_perm_guest_4` (`perm_guest_4`),
KEY `index_ingo_sharesng_on_perm_guest_8` (`perm_guest_8`),
KEY `index_ingo_sharesng_on_perm_guest_16` (`perm_guest_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ingo_sharesng_groups`
--
DROP TABLE IF EXISTS `ingo_sharesng_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_sharesng_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_ingo_sharesng_groups_on_share_id` (`share_id`),
KEY `index_ingo_sharesng_groups_on_group_uid` (`group_uid`),
KEY `index_ingo_sharesng_groups_on_perm_2` (`perm_2`),
KEY `index_ingo_sharesng_groups_on_perm_4` (`perm_4`),
KEY `index_ingo_sharesng_groups_on_perm_8` (`perm_8`),
KEY `index_ingo_sharesng_groups_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `ingo_sharesng_users`
--
DROP TABLE IF EXISTS `ingo_sharesng_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ingo_sharesng_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_ingo_sharesng_users_on_share_id` (`share_id`),
KEY `index_ingo_sharesng_users_on_user_uid` (`user_uid`),
KEY `index_ingo_sharesng_users_on_perm_2` (`perm_2`),
KEY `index_ingo_sharesng_users_on_perm_4` (`perm_4`),
KEY `index_ingo_sharesng_users_on_perm_8` (`perm_8`),
KEY `index_ingo_sharesng_users_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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_recurtype` int(11) DEFAULT '0',
`event_recurinterval` int(11) DEFAULT NULL,
`event_recurdays` int(11) 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) DEFAULT '0',
`event_private` int(11) NOT NULL DEFAULT '0',
`event_allday` int(11) DEFAULT '0',
`event_alarm_methods` text,
`event_url` text,
`event_baseid` varchar(255) DEFAULT '',
`event_exceptionoriginaldate` datetime DEFAULT NULL,
`event_resources` text,
`event_timezone` varchar(50) DEFAULT NULL,
PRIMARY KEY (`event_id`),
KEY `index_kronolith_events_on_calendar_id` (`calendar_id`),
KEY `index_kronolith_events_on_event_uid` (`event_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_events_geo`
--
DROP TABLE IF EXISTS `kronolith_events_geo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_events_geo` (
`event_id` varchar(32) NOT NULL,
`event_lat` varchar(32) NOT NULL,
`event_lon` varchar(32) NOT NULL,
`event_zoom` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_events_mysqlgeo`
--
DROP TABLE IF EXISTS `kronolith_events_mysqlgeo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_events_mysqlgeo` (
`event_id` varchar(32) NOT NULL,
`event_coordinates` point NOT NULL,
`event_zoom` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`event_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_resources`
--
DROP TABLE IF EXISTS `kronolith_resources`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_resources` (
`resource_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`resource_name` varchar(255) DEFAULT NULL,
`resource_calendar` varchar(255) DEFAULT NULL,
`resource_description` text,
`resource_response_type` int(11) DEFAULT '0',
`resource_type` varchar(255) NOT NULL,
`resource_members` text,
`resource_email` varchar(255) DEFAULT NULL,
PRIMARY KEY (`resource_id`),
KEY `index_kronolith_resources_on_resource_calendar` (`resource_calendar`),
KEY `index_kronolith_resources_on_resource_type` (`resource_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_schema_info`
--
DROP TABLE IF EXISTS `kronolith_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator` int(11) NOT NULL DEFAULT '0',
`perm_default` int(11) NOT NULL DEFAULT '0',
`perm_guest` int(11) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_color` varchar(7) DEFAULT NULL,
`share_parents` varchar(4000) DEFAULT NULL,
PRIMARY KEY (`share_id`),
KEY `index_kronolith_shares_on_share_name` (`share_name`),
KEY `index_kronolith_shares_on_share_owner` (`share_owner`),
KEY `index_kronolith_shares_on_perm_creator` (`perm_creator`),
KEY `index_kronolith_shares_on_perm_default` (`perm_default`),
KEY `index_kronolith_shares_on_perm_guest` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_kronolith_shares_groups_on_share_id` (`share_id`),
KEY `index_kronolith_shares_groups_on_group_uid` (`group_uid`),
KEY `index_kronolith_shares_groups_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_kronolith_shares_users_on_share_id` (`share_id`),
KEY `index_kronolith_shares_users_on_user_uid` (`user_uid`),
KEY `index_kronolith_shares_users_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_sharesng`
--
DROP TABLE IF EXISTS `kronolith_sharesng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_sharesng` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_1024` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_1024` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_1024` tinyint(1) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_color` varchar(7) DEFAULT NULL,
`share_parents` varchar(4000) DEFAULT NULL,
PRIMARY KEY (`share_id`),
KEY `index_kronolith_sharesng_on_share_name` (`share_name`),
KEY `index_kronolith_sharesng_on_share_owner` (`share_owner`),
KEY `index_kronolith_sharesng_on_perm_creator_2` (`perm_creator_2`),
KEY `index_kronolith_sharesng_on_perm_creator_4` (`perm_creator_4`),
KEY `index_kronolith_sharesng_on_perm_creator_8` (`perm_creator_8`),
KEY `index_kronolith_sharesng_on_perm_creator_16` (`perm_creator_16`),
KEY `index_kronolith_sharesng_on_perm_creator_1024` (`perm_creator_1024`),
KEY `index_kronolith_sharesng_on_perm_default_2` (`perm_default_2`),
KEY `index_kronolith_sharesng_on_perm_default_4` (`perm_default_4`),
KEY `index_kronolith_sharesng_on_perm_default_8` (`perm_default_8`),
KEY `index_kronolith_sharesng_on_perm_default_16` (`perm_default_16`),
KEY `index_kronolith_sharesng_on_perm_default_1024` (`perm_default_1024`),
KEY `index_kronolith_sharesng_on_perm_guest_2` (`perm_guest_2`),
KEY `index_kronolith_sharesng_on_perm_guest_4` (`perm_guest_4`),
KEY `index_kronolith_sharesng_on_perm_guest_8` (`perm_guest_8`),
KEY `index_kronolith_sharesng_on_perm_guest_16` (`perm_guest_16`),
KEY `index_kronolith_sharesng_on_perm_guest_1024` (`perm_guest_1024`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_sharesng_groups`
--
DROP TABLE IF EXISTS `kronolith_sharesng_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_sharesng_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_1024` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_kronolith_sharesng_groups_on_share_id` (`share_id`),
KEY `index_kronolith_sharesng_groups_on_group_uid` (`group_uid`),
KEY `index_kronolith_sharesng_groups_on_perm_2` (`perm_2`),
KEY `index_kronolith_sharesng_groups_on_perm_4` (`perm_4`),
KEY `index_kronolith_sharesng_groups_on_perm_8` (`perm_8`),
KEY `index_kronolith_sharesng_groups_on_perm_16` (`perm_16`),
KEY `index_kronolith_sharesng_groups_on_perm_1024` (`perm_1024`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `kronolith_sharesng_users`
--
DROP TABLE IF EXISTS `kronolith_sharesng_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kronolith_sharesng_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_1024` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_kronolith_sharesng_users_on_share_id` (`share_id`),
KEY `index_kronolith_sharesng_users_on_user_uid` (`user_uid`),
KEY `index_kronolith_sharesng_users_on_perm_2` (`perm_2`),
KEY `index_kronolith_sharesng_users_on_perm_4` (`perm_4`),
KEY `index_kronolith_sharesng_users_on_perm_8` (`perm_8`),
KEY `index_kronolith_sharesng_users_on_perm_16` (`perm_16`),
KEY `index_kronolith_sharesng_users_on_perm_1024` (`perm_1024`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`vfb_owner` varchar(255) DEFAULT NULL,
`vfb_email` varchar(255) NOT NULL,
`vfb_serialized` text NOT NULL,
PRIMARY KEY (`id`),
KEY `index_kronolith_storage_on_vfb_owner` (`vfb_owner`),
KEY `index_kronolith_storage_on_vfb_email` (`vfb_email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`memo_owner`,`memo_id`),
KEY `index_mnemo_memos_on_memo_owner` (`memo_owner`),
KEY `index_mnemo_memos_on_memo_uid` (`memo_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mnemo_schema_info`
--
DROP TABLE IF EXISTS `mnemo_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) NOT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator` int(11) NOT NULL DEFAULT '0',
`perm_default` int(11) NOT NULL DEFAULT '0',
`perm_guest` int(11) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_mnemo_shares_on_share_name` (`share_name`),
KEY `index_mnemo_shares_on_share_owner` (`share_owner`),
KEY `index_mnemo_shares_on_perm_creator` (`perm_creator`),
KEY `index_mnemo_shares_on_perm_default` (`perm_default`),
KEY `index_mnemo_shares_on_perm_guest` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_mnemo_shares_groups_on_share_id` (`share_id`),
KEY `index_mnemo_shares_groups_on_group_uid` (`group_uid`),
KEY `index_mnemo_shares_groups_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_mnemo_shares_users_on_share_id` (`share_id`),
KEY `index_mnemo_shares_users_on_user_uid` (`user_uid`),
KEY `index_mnemo_shares_users_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mnemo_sharesng`
--
DROP TABLE IF EXISTS `mnemo_sharesng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_sharesng` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_16` tinyint(1) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_mnemo_sharesng_on_share_name` (`share_name`),
KEY `index_mnemo_sharesng_on_share_owner` (`share_owner`),
KEY `index_mnemo_sharesng_on_perm_creator_2` (`perm_creator_2`),
KEY `index_mnemo_sharesng_on_perm_creator_4` (`perm_creator_4`),
KEY `index_mnemo_sharesng_on_perm_creator_8` (`perm_creator_8`),
KEY `index_mnemo_sharesng_on_perm_creator_16` (`perm_creator_16`),
KEY `index_mnemo_sharesng_on_perm_default_2` (`perm_default_2`),
KEY `index_mnemo_sharesng_on_perm_default_4` (`perm_default_4`),
KEY `index_mnemo_sharesng_on_perm_default_8` (`perm_default_8`),
KEY `index_mnemo_sharesng_on_perm_default_16` (`perm_default_16`),
KEY `index_mnemo_sharesng_on_perm_guest_2` (`perm_guest_2`),
KEY `index_mnemo_sharesng_on_perm_guest_4` (`perm_guest_4`),
KEY `index_mnemo_sharesng_on_perm_guest_8` (`perm_guest_8`),
KEY `index_mnemo_sharesng_on_perm_guest_16` (`perm_guest_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mnemo_sharesng_groups`
--
DROP TABLE IF EXISTS `mnemo_sharesng_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_sharesng_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_mnemo_sharesng_groups_on_share_id` (`share_id`),
KEY `index_mnemo_sharesng_groups_on_group_uid` (`group_uid`),
KEY `index_mnemo_sharesng_groups_on_perm_2` (`perm_2`),
KEY `index_mnemo_sharesng_groups_on_perm_4` (`perm_4`),
KEY `index_mnemo_sharesng_groups_on_perm_8` (`perm_8`),
KEY `index_mnemo_sharesng_groups_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `mnemo_sharesng_users`
--
DROP TABLE IF EXISTS `mnemo_sharesng_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mnemo_sharesng_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_mnemo_sharesng_users_on_share_id` (`share_id`),
KEY `index_mnemo_sharesng_users_on_user_uid` (`user_uid`),
KEY `index_mnemo_sharesng_users_on_perm_2` (`perm_2`),
KEY `index_mnemo_sharesng_users_on_perm_4` (`perm_4`),
KEY `index_mnemo_sharesng_users_on_perm_8` (`perm_8`),
KEY `index_mnemo_sharesng_users_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_schema_info`
--
DROP TABLE IF EXISTS `nag_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_shares`
--
DROP TABLE IF EXISTS `nag_shares`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_shares` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(2) NOT NULL DEFAULT '0',
`perm_creator` int(2) NOT NULL DEFAULT '0',
`perm_default` int(2) NOT NULL DEFAULT '0',
`perm_guest` int(2) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_color` varchar(7) DEFAULT NULL,
`share_parents` text,
`attribute_issmart` int(11) DEFAULT '0',
`attribute_search` text,
PRIMARY KEY (`share_id`),
KEY `index_nag_shares_on_share_name` (`share_name`),
KEY `index_nag_shares_on_share_owner` (`share_owner`),
KEY `index_nag_shares_on_perm_creator` (`perm_creator`),
KEY `index_nag_shares_on_perm_default` (`perm_default`),
KEY `index_nag_shares_on_perm_guest` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_shares_groups`
--
DROP TABLE IF EXISTS `nag_shares_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_shares_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm` int(2) NOT NULL,
KEY `index_nag_shares_groups_on_share_id` (`share_id`),
KEY `index_nag_shares_groups_on_group_uid` (`group_uid`),
KEY `index_nag_shares_groups_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_shares_users`
--
DROP TABLE IF EXISTS `nag_shares_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_shares_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm` int(2) NOT NULL,
KEY `index_nag_shares_users_on_share_id` (`share_id`),
KEY `index_nag_shares_users_on_user_uid` (`user_uid`),
KEY `index_nag_shares_users_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_sharesng`
--
DROP TABLE IF EXISTS `nag_sharesng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_sharesng` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_16` tinyint(1) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_color` varchar(7) DEFAULT NULL,
`share_parents` text,
`attribute_issmart` int(11) DEFAULT '0',
`attribute_search` text,
PRIMARY KEY (`share_id`),
KEY `index_nag_sharesng_on_share_name` (`share_name`),
KEY `index_nag_sharesng_on_share_owner` (`share_owner`),
KEY `index_nag_sharesng_on_perm_creator_2` (`perm_creator_2`),
KEY `index_nag_sharesng_on_perm_creator_4` (`perm_creator_4`),
KEY `index_nag_sharesng_on_perm_creator_8` (`perm_creator_8`),
KEY `index_nag_sharesng_on_perm_creator_16` (`perm_creator_16`),
KEY `index_nag_sharesng_on_perm_default_2` (`perm_default_2`),
KEY `index_nag_sharesng_on_perm_default_4` (`perm_default_4`),
KEY `index_nag_sharesng_on_perm_default_8` (`perm_default_8`),
KEY `index_nag_sharesng_on_perm_default_16` (`perm_default_16`),
KEY `index_nag_sharesng_on_perm_guest_2` (`perm_guest_2`),
KEY `index_nag_sharesng_on_perm_guest_4` (`perm_guest_4`),
KEY `index_nag_sharesng_on_perm_guest_8` (`perm_guest_8`),
KEY `index_nag_sharesng_on_perm_guest_16` (`perm_guest_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_sharesng_groups`
--
DROP TABLE IF EXISTS `nag_sharesng_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_sharesng_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_nag_sharesng_groups_on_share_id` (`share_id`),
KEY `index_nag_sharesng_groups_on_group_uid` (`group_uid`),
KEY `index_nag_sharesng_groups_on_perm_2` (`perm_2`),
KEY `index_nag_sharesng_groups_on_perm_4` (`perm_4`),
KEY `index_nag_sharesng_groups_on_perm_8` (`perm_8`),
KEY `index_nag_sharesng_groups_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_sharesng_users`
--
DROP TABLE IF EXISTS `nag_sharesng_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_sharesng_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_nag_sharesng_users_on_share_id` (`share_id`),
KEY `index_nag_sharesng_users_on_user_uid` (`user_uid`),
KEY `index_nag_sharesng_users_on_perm_2` (`perm_2`),
KEY `index_nag_sharesng_users_on_perm_4` (`perm_4`),
KEY `index_nag_sharesng_users_on_perm_8` (`perm_8`),
KEY `index_nag_sharesng_users_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nag_tasks`
--
DROP TABLE IF EXISTS `nag_tasks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nag_tasks` (
`task_id` varchar(32) NOT NULL,
`task_owner` varchar(255) NOT NULL,
`task_creator` varchar(255) NOT NULL,
`task_parent` varchar(255) DEFAULT NULL,
`task_assignee` varchar(255) DEFAULT NULL,
`task_name` varchar(255) NOT NULL,
`task_uid` varchar(255) NOT NULL,
`task_desc` text,
`task_start` int(11) DEFAULT NULL,
`task_due` int(11) DEFAULT NULL,
`task_priority` int(11) NOT NULL DEFAULT '0',
`task_estimate` float DEFAULT NULL,
`task_completed` int(1) NOT NULL DEFAULT '0',
`task_completed_date` int(11) DEFAULT NULL,
`task_alarm` int(11) NOT NULL DEFAULT '0',
`task_alarm_methods` text,
`task_private` int(1) NOT NULL DEFAULT '0',
`task_recurtype` int(11) DEFAULT '0',
`task_recurinterval` int(11) DEFAULT NULL,
`task_recurdays` int(11) DEFAULT NULL,
`task_recurenddate` datetime DEFAULT NULL,
`task_recurcount` int(11) DEFAULT NULL,
`task_exceptions` text,
`task_completions` text,
PRIMARY KEY (`task_id`),
KEY `index_nag_tasks_on_task_owner` (`task_owner`),
KEY `index_nag_tasks_on_task_uid` (`task_uid`),
KEY `index_nag_tasks_on_task_start` (`task_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_objects`
--
DROP TABLE IF EXISTS `rampage_objects`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_objects` (
`object_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`object_name` varchar(255) NOT NULL,
`type_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`object_id`),
UNIQUE KEY `rampage_objects_type_object_name` (`type_id`,`object_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_tag_stats`
--
DROP TABLE IF EXISTS `rampage_tag_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_tag_stats` (
`tag_id` int(10) unsigned NOT NULL,
`count` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_tagged`
--
DROP TABLE IF EXISTS `rampage_tagged`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_tagged` (
`user_id` int(10) unsigned NOT NULL,
`object_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
`created` datetime DEFAULT NULL,
PRIMARY KEY (`user_id`,`object_id`,`tag_id`),
KEY `rampage_tagged_object_id` (`object_id`),
KEY `rampage_tagged_tag_id` (`tag_id`),
KEY `rampage_tagged_created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_tags`
--
DROP TABLE IF EXISTS `rampage_tags`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_tags` (
`tag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`tag_name` varchar(255) NOT NULL,
PRIMARY KEY (`tag_id`),
UNIQUE KEY `rampage_tags_tag_name` (`tag_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_types`
--
DROP TABLE IF EXISTS `rampage_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_types` (
`type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`type_name` varchar(255) NOT NULL,
PRIMARY KEY (`type_id`),
UNIQUE KEY `rampage_objects_type_name` (`type_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `rampage_types`
LOCK TABLES `rampage_types` WRITE;
/*!40000 ALTER TABLE `rampage_types` DISABLE KEYS */;
INSERT INTO `rampage_types` VALUES (1,'calendar'),(2,'event'),(3,'task');
/*!40000 ALTER TABLE `rampage_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rampage_user_tag_stats`
--
DROP TABLE IF EXISTS `rampage_user_tag_stats`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_user_tag_stats` (
`user_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
`count` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`user_id`,`tag_id`),
KEY `rampage_user_tag_stats_tag_id` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `rampage_users`
--
DROP TABLE IF EXISTS `rampage_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rampage_users` (
`user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) NOT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `rampage_users_user_name` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `trean_bookmarks`
--
DROP TABLE IF EXISTS `trean_bookmarks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trean_bookmarks` (
`bookmark_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`bookmark_url` varchar(1024) DEFAULT NULL,
`bookmark_title` varchar(255) DEFAULT NULL,
`bookmark_description` varchar(1024) DEFAULT NULL,
`bookmark_clicks` int(10) unsigned DEFAULT '0',
`bookmark_http_status` varchar(5) DEFAULT NULL,
`bookmark_dt` datetime DEFAULT NULL,
`user_id` int(10) unsigned NOT NULL,
`favicon_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`bookmark_id`),
KEY `index_trean_bookmarks_on_bookmark_clicks` (`bookmark_clicks`),
KEY `index_trean_bookmarks_on_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `trean_schema_info`
--
DROP TABLE IF EXISTS `trean_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `trean_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` text,
`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` longblob,
`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` longblob,
`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,
`object_anniversary` varchar(10) DEFAULT NULL,
`object_department` varchar(255) DEFAULT NULL,
`object_spouse` varchar(255) DEFAULT NULL,
`object_homefax` varchar(25) DEFAULT NULL,
`object_nickname` varchar(255) DEFAULT NULL,
`object_assistantphone` varchar(25) DEFAULT NULL,
`object_imaddress` varchar(255) DEFAULT NULL,
`object_imaddress2` varchar(255) DEFAULT NULL,
`object_imaddress3` varchar(255) DEFAULT NULL,
`object_homephone2` varchar(25) DEFAULT NULL,
`object_carphone` varchar(25) DEFAULT NULL,
`object_workphone2` varchar(25) DEFAULT NULL,
`object_radiophone` varchar(25) DEFAULT NULL,
`object_companyphone` varchar(25) DEFAULT NULL,
`object_otherstreet` varchar(255) DEFAULT NULL,
`object_otherpob` varchar(10) DEFAULT NULL,
`object_othercity` varchar(255) DEFAULT NULL,
`object_otherprovince` varchar(255) DEFAULT NULL,
`object_otherpostalcode` varchar(10) DEFAULT NULL,
`object_othercountry` varchar(255) DEFAULT NULL,
`object_yomifirstname` varchar(255) DEFAULT NULL,
`object_yomilastname` varchar(255) DEFAULT NULL,
`object_manager` varchar(255) DEFAULT NULL,
`object_assistant` varchar(255) DEFAULT NULL,
`object_workemail` varchar(255) DEFAULT NULL,
`object_homeemail` varchar(255) DEFAULT NULL,
PRIMARY KEY (`object_id`),
KEY `index_turba_objects_on_owner_id` (`owner_id`),
KEY `index_turba_objects_on_object_email` (`object_email`),
KEY `index_turba_objects_on_object_firstname` (`object_firstname`),
KEY `index_turba_objects_on_object_lastname` (`object_lastname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `turba_schema_info`
--
DROP TABLE IF EXISTS `turba_schema_info`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turba_schema_info` (
`version` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) NOT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator` int(11) NOT NULL DEFAULT '0',
`perm_default` int(11) NOT NULL DEFAULT '0',
`perm_guest` int(11) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_params` text,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_turba_shares_on_share_name` (`share_name`),
KEY `index_turba_shares_on_share_owner` (`share_owner`),
KEY `index_turba_shares_on_perm_creator` (`perm_creator`),
KEY `index_turba_shares_on_perm_default` (`perm_default`),
KEY `index_turba_shares_on_perm_guest` (`perm_guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_turba_shares_groups_on_share_id` (`share_id`),
KEY `index_turba_shares_groups_on_group_uid` (`group_uid`),
KEY `index_turba_shares_groups_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- 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` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `index_turba_shares_users_on_share_id` (`share_id`),
KEY `index_turba_shares_users_on_user_uid` (`user_uid`),
KEY `index_turba_shares_users_on_perm` (`perm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `turba_sharesng`
--
DROP TABLE IF EXISTS `turba_sharesng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turba_sharesng` (
`share_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`share_name` varchar(255) NOT NULL,
`share_owner` varchar(255) DEFAULT NULL,
`share_flags` int(11) NOT NULL DEFAULT '0',
`perm_creator_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_creator_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_default_16` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_guest_16` tinyint(1) NOT NULL DEFAULT '0',
`attribute_name` varchar(255) NOT NULL,
`attribute_desc` varchar(255) DEFAULT NULL,
`attribute_params` text,
`share_parents` text,
PRIMARY KEY (`share_id`),
KEY `index_turba_sharesng_on_share_name` (`share_name`),
KEY `index_turba_sharesng_on_share_owner` (`share_owner`),
KEY `index_turba_sharesng_on_perm_creator_2` (`perm_creator_2`),
KEY `index_turba_sharesng_on_perm_creator_4` (`perm_creator_4`),
KEY `index_turba_sharesng_on_perm_creator_8` (`perm_creator_8`),
KEY `index_turba_sharesng_on_perm_creator_16` (`perm_creator_16`),
KEY `index_turba_sharesng_on_perm_default_2` (`perm_default_2`),
KEY `index_turba_sharesng_on_perm_default_4` (`perm_default_4`),
KEY `index_turba_sharesng_on_perm_default_8` (`perm_default_8`),
KEY `index_turba_sharesng_on_perm_default_16` (`perm_default_16`),
KEY `index_turba_sharesng_on_perm_guest_2` (`perm_guest_2`),
KEY `index_turba_sharesng_on_perm_guest_4` (`perm_guest_4`),
KEY `index_turba_sharesng_on_perm_guest_8` (`perm_guest_8`),
KEY `index_turba_sharesng_on_perm_guest_16` (`perm_guest_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `turba_sharesng_groups`
--
DROP TABLE IF EXISTS `turba_sharesng_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turba_sharesng_groups` (
`share_id` int(11) NOT NULL,
`group_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_turba_sharesng_groups_on_share_id` (`share_id`),
KEY `index_turba_sharesng_groups_on_group_uid` (`group_uid`),
KEY `index_turba_sharesng_groups_on_perm_2` (`perm_2`),
KEY `index_turba_sharesng_groups_on_perm_4` (`perm_4`),
KEY `index_turba_sharesng_groups_on_perm_8` (`perm_8`),
KEY `index_turba_sharesng_groups_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `turba_sharesng_users`
--
DROP TABLE IF EXISTS `turba_sharesng_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `turba_sharesng_users` (
`share_id` int(11) NOT NULL,
`user_uid` varchar(255) NOT NULL,
`perm_2` tinyint(1) NOT NULL DEFAULT '0',
`perm_4` tinyint(1) NOT NULL DEFAULT '0',
`perm_8` tinyint(1) NOT NULL DEFAULT '0',
`perm_16` tinyint(1) NOT NULL DEFAULT '0',
KEY `index_turba_sharesng_users_on_share_id` (`share_id`),
KEY `index_turba_sharesng_users_on_user_uid` (`user_uid`),
KEY `index_turba_sharesng_users_on_perm_2` (`perm_2`),
KEY `index_turba_sharesng_users_on_perm_4` (`perm_4`),
KEY `index_turba_sharesng_users_on_perm_8` (`perm_8`),
KEY `index_turba_sharesng_users_on_perm_16` (`perm_16`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2015-06-24 16:51:31
Back to Directory
File Manager