SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `horde`
-- 

CREATE DATABASE `horde` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

-- --------------------------------------------------------

-- 
-- Table structure for table `aliases`
-- 

CREATE TABLE IF NOT EXISTS `aliases` (
  `type` set('domain','system') NOT NULL default 'domain',
  `alias` char(128) NOT NULL default '',
  `login` char(128) NOT NULL default '',
  KEY `alias` (`alias`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `domains`
-- 

CREATE TABLE IF NOT EXISTS `domains` (
  `domain` char(128) NOT NULL default '',
  `type` enum('local','relay') NOT NULL default 'local',
  `relay_host` char(128) NOT NULL default '',
  KEY `domain` (`domain`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `horde_datatree` (
  `datatree_id` int(11) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `horde_datatree_attributes` (
  `datatree_id` int(11) 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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- 
-- Table structure for table `horde_datatree_seq`
-- 

CREATE TABLE IF NOT EXISTS `horde_datatree_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `horde_sessionhandler` (
  `session_id` varchar(32) NOT NULL,
  `session_lastmodified` int(11) NOT NULL,
  `session_data` longblob,
  PRIMARY KEY  (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `horde_users` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `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,
  `uid` int(10) unsigned NOT NULL default '8',
  `gid` int(10) unsigned NOT NULL default '8',
  `name` char(128) NOT NULL,
  `home` char(255) NOT NULL,
  `maildir` char(255) NOT NULL,
  `quota` char(255) NOT NULL,
  `status` varchar(5) NOT NULL default 'User',
  `vacation` text NOT NULL,
  `vacation_enabled` varchar(1) NOT NULL default 'n',
  `vacation_subject` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `horde_vfs` (
  `vfs_id` bigint(20) NOT NULL,
  `vfs_type` smallint(6) NOT NULL,
  `vfs_path` varchar(255) NOT NULL,
  `vfs_name` varchar(255) NOT NULL,
  `vfs_modified` bigint(20) NOT NULL,
  `vfs_owner` varchar(255) NOT NULL,
  `vfs_data` longblob,
  PRIMARY KEY  (`vfs_id`),
  KEY `vfs_path_idx` (`vfs_path`),
  KEY `vfs_name_idx` (`vfs_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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_start` datetime default NULL,
  `event_end` datetime default NULL,
  `event_alarm` int(11) default '0',
  `event_modified` int(11) NOT NULL,
  PRIMARY KEY  (`event_id`),
  KEY `kronolith_calendar_idx` (`calendar_id`),
  KEY `kronolith_uid_idx` (`event_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `kronolith_storage` (
  `vfb_owner` varchar(255) default NULL,
  `vfb_email` varchar(255) NOT NULL default '',
  `vfb_serialized` text NOT NULL,
  KEY `kronolith_vfb_owner_idx` (`vfb_owner`),
  KEY `kronolith_vfb_email_idx` (`vfb_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

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

CREATE TABLE IF NOT EXISTS `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_name` varchar(255) default NULL,
  `object_alias` varchar(32) default NULL,
  `object_email` varchar(255) default NULL,
  `object_homeaddress` varchar(255) default NULL,
  `object_workaddress` 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_title` varchar(255) default NULL,
  `object_company` varchar(255) default NULL,
  `object_notes` text,
  `object_pgppublickey` text,
  `object_smimepublickey` text,
  `object_freebusyurl` varchar(255) default NULL,
  PRIMARY KEY  (`object_id`),
  KEY `turba_owner_idx` (`owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;