PRAGMA foreign_keys=OFF;
PRAGMA encoding="UTF-8";
BEGIN TRANSACTION;
CREATE TABLE "content_schema_info" (
"version" int
);
INSERT INTO "content_schema_info" VALUES(2);
CREATE TABLE "horde_alarm_schema_info" (
"version" int
);
INSERT INTO "horde_alarm_schema_info" VALUES(1);
CREATE TABLE "horde_auth_schema_info" (
"version" int
);
INSERT INTO "horde_auth_schema_info" VALUES(1);
CREATE TABLE "horde_cache_schema_info" (
"version" int
);
INSERT INTO "horde_cache_schema_info" VALUES(2);
CREATE TABLE "horde_core_schema_info" (
"version" int
);
INSERT INTO "horde_core_schema_info" VALUES(1);
CREATE TABLE "horde_dav_schema_info" (
"version" int
);
INSERT INTO "horde_dav_schema_info" VALUES(1);
CREATE TABLE "horde_group_schema_info" (
"version" int
);
INSERT INTO "horde_group_schema_info" VALUES(2);
CREATE TABLE "horde_history_schema_info" (
"version" int
);
INSERT INTO "horde_history_schema_info" VALUES(6);
CREATE TABLE "horde_imap_client_schema_info" (
"version" int
);
INSERT INTO "horde_imap_client_schema_info" VALUES(1);
CREATE TABLE "horde_lock_schema_info" (
"version" int
);
INSERT INTO "horde_lock_schema_info" VALUES(3);
CREATE TABLE "horde_perms_schema_info" (
"version" int
);
INSERT INTO "horde_perms_schema_info" VALUES(2);
CREATE TABLE "horde_prefs_schema_info" (
"version" int
);
INSERT INTO "horde_prefs_schema_info" VALUES(3);
CREATE TABLE "horde_queue_schema_info" (
"version" int
);
INSERT INTO "horde_queue_schema_info" VALUES(1);
CREATE TABLE "horde_sessionhandler_schema_info" (
"version" int
);
INSERT INTO "horde_sessionhandler_schema_info" VALUES(2);
CREATE TABLE "horde_syncml_schema_info" (
"version" int
);
INSERT INTO "horde_syncml_schema_info" VALUES(1);
CREATE TABLE "horde_token_schema_info" (
"version" int
);
INSERT INTO "horde_token_schema_info" VALUES(1);
CREATE TABLE "horde_vfs_schema_info" (
"version" int
);
INSERT INTO "horde_vfs_schema_info" VALUES(3);
CREATE TABLE "imp_schema_info" (
"version" int
);
INSERT INTO "imp_schema_info" VALUES(3);
CREATE TABLE "ingo_schema_info" (
"version" int
);
INSERT INTO "ingo_schema_info" VALUES(5);
CREATE TABLE "kronolith_schema_info" (
"version" int
);
INSERT INTO "kronolith_schema_info" VALUES(22);
CREATE TABLE "mnemo_schema_info" (
"version" int
);
INSERT INTO "mnemo_schema_info" VALUES(5);
CREATE TABLE "nag_schema_info" (
"version" int
);
INSERT INTO "nag_schema_info" VALUES(12);
CREATE TABLE "trean_schema_info" (
"version" int
);
INSERT INTO "trean_schema_info" VALUES(5);
CREATE TABLE "turba_schema_info" (
"version" int
);
INSERT INTO "turba_schema_info" VALUES(9);
CREATE TABLE "rampage_types" (
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
);
INSERT INTO "rampage_types" VALUES(1,'calendar');
INSERT INTO "rampage_types" VALUES(2,'event');
INSERT INTO "rampage_types" VALUES(3,'task');
CREATE TABLE "rampage_objects" (
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
);
CREATE TABLE "rampage_users" (
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
);
CREATE TABLE "rampage_tags" (
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
);
CREATE TABLE "rampage_tagged" (
"user_id" int NOT NULL,
"object_id" int NOT NULL,
"tag_id" int NOT NULL,
"created" datetime,
PRIMARY KEY("user_id", "object_id", "tag_id")
);
CREATE TABLE "rampage_tag_stats" (
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("tag_id")
);
CREATE TABLE "rampage_user_tag_stats" (
"user_id" int NOT NULL,
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("user_id", "tag_id")
);
CREATE TABLE "horde_alarms" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"alarm_id" varchar(255) NOT NULL,
"alarm_uid" varchar(255),
"alarm_start" datetime NOT NULL,
"alarm_end" datetime,
"alarm_methods" varchar(255),
"alarm_params" text,
"alarm_title" varchar(255) NOT NULL,
"alarm_text" text,
"alarm_snooze" datetime,
"alarm_dismissed" int(1) NOT NULL DEFAULT 0,
"alarm_internal" text
);
CREATE TABLE "horde_users" (
"user_uid" varchar(255) NOT NULL,
"user_pass" varchar(255) NOT NULL,
"user_soft_expiration_date" int,
"user_hard_expiration_date" int,
PRIMARY KEY("user_uid")
);
CREATE TABLE "horde_cache" (
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
);
CREATE TABLE "horde_signups" (
"user_name" varchar(255) NOT NULL,
"signup_date" int NOT NULL,
"signup_host" varchar(255) NOT NULL,
"signup_data" text NOT NULL,
PRIMARY KEY("user_name")
);
CREATE TABLE "horde_dav_objects" (
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
);
CREATE TABLE "horde_dav_collections" (
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
);
CREATE TABLE "horde_groups_members" (
"group_uid" int NOT NULL,
"user_uid" varchar(255) NOT NULL
);
CREATE TABLE "horde_groups" (
"group_uid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"group_name" varchar(255) NOT NULL,
"group_parents" varchar(255) NOT NULL,
"group_email" varchar(255)
);
CREATE TABLE "horde_histories" (
"history_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"object_uid" varchar(255) NOT NULL,
"history_action" varchar(32) NOT NULL,
"history_ts" int NOT NULL,
"history_desc" text,
"history_who" varchar(255),
"history_extra" text
, "history_modseq" int NOT NULL DEFAULT 0);
CREATE TABLE "horde_histories_modseq" (
"history_modseq" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL DEFAULT 0,
"history_modseqempty" int NOT NULL DEFAULT 0
);
CREATE TABLE "horde_imap_client_data" (
"uid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"hostspec" varchar(255) NOT NULL,
"mailbox" varchar(255) NOT NULL,
"modified" bigint,
"port" int NOT NULL,
"username" varchar(255) NOT NULL
);
CREATE TABLE "horde_imap_client_message" (
"data" blob,
"msguid" varchar(255) NOT NULL,
"uid" bigint NOT NULL
);
CREATE TABLE "horde_imap_client_metadata" (
"data" blob,
"field" varchar(255) NOT NULL,
"uid" bigint NOT NULL
);
CREATE TABLE "horde_locks" (
"lock_id" varchar(36) NOT NULL,
"lock_owner" varchar(255),
"lock_scope" varchar(32) NOT NULL,
"lock_principal" varchar(255) NOT NULL,
"lock_origin_timestamp" int NOT NULL,
"lock_update_timestamp" int NOT NULL,
"lock_expiry_timestamp" int NOT NULL,
"lock_type" int NOT NULL
);
CREATE TABLE "horde_perms" (
"perm_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"perm_name" varchar(255) NOT NULL,
"perm_parents" varchar(255) NOT NULL,
"perm_data" text
);
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" blob
);
CREATE TABLE "horde_queue_tasks" (
"task_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"task_queue" varchar(255) NOT NULL,
"task_fields" text NOT NULL
);
CREATE TABLE "horde_sessionhandler" (
"session_id" varchar(32) NOT NULL,
"session_lastmodified" int NOT NULL,
"session_data" blob
);
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),
"syncml_suid" varchar(255),
"syncml_timestamp" int
);
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),
"syncml_serveranchor" varchar(255)
);
CREATE TABLE "horde_tokens" (
"token_address" varchar(100) NOT NULL,
"token_id" varchar(32) NOT NULL,
"token_timestamp" bigint NOT NULL,
PRIMARY KEY("token_address", "token_id")
);
CREATE TABLE "horde_vfs" (
"vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"vfs_type" int NOT NULL,
"vfs_path" varchar(255) NOT NULL,
"vfs_name" varchar(255) NOT NULL,
"vfs_modified" int NOT NULL,
"vfs_owner" varchar(255) NOT NULL,
"vfs_data" blob
);
CREATE TABLE "horde_muvfs" (
"vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"vfs_type" int NOT NULL,
"vfs_path" varchar(255) NOT NULL,
"vfs_name" varchar(255) NOT NULL,
"vfs_modified" int NOT NULL,
"vfs_owner" varchar(255) NOT NULL,
"vfs_perms" int NOT NULL,
"vfs_data" blob
);
CREATE TABLE "imp_sentmail" (
"sentmail_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"sentmail_who" varchar(255) NOT NULL,
"sentmail_ts" int NOT NULL,
"sentmail_messageid" varchar(255) NOT NULL,
"sentmail_action" varchar(32) NOT NULL,
"sentmail_recipient" varchar(255) NOT NULL,
"sentmail_success" int NOT NULL
);
CREATE TABLE "ingo_lists" (
"list_owner" varchar(255) NOT NULL,
"list_blacklist" int DEFAULT 0,
"list_address" varchar(255) NOT NULL
);
CREATE TABLE "ingo_forwards" (
"forward_owner" varchar(255) NOT NULL,
"forward_addresses" text,
"forward_keep" int NOT NULL DEFAULT 0
);
CREATE TABLE "ingo_vacations" (
"vacation_owner" varchar(255) NOT NULL,
"vacation_addresses" text,
"vacation_subject" varchar(255),
"vacation_reason" text,
"vacation_days" int DEFAULT 7,
"vacation_start" int,
"vacation_end" int,
"vacation_excludes" text,
"vacation_ignorelists" int DEFAULT 1,
PRIMARY KEY("vacation_owner")
);
CREATE TABLE "ingo_spam" (
"spam_owner" varchar(255) NOT NULL,
"spam_level" int DEFAULT 5,
"spam_folder" varchar(255),
PRIMARY KEY("spam_owner")
);
CREATE TABLE "ingo_shares_groups" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "ingo_shares_users" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "ingo_rules" (
"rule_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"rule_owner" varchar(255) NOT NULL,
"rule_name" varchar(255) NOT NULL,
"rule_action" int NOT NULL,
"rule_value" varchar(255),
"rule_flags" int,
"rule_conditions" text,
"rule_combine" int,
"rule_stop" int,
"rule_active" int NOT NULL DEFAULT 1,
"rule_order" int NOT NULL DEFAULT 0
);
CREATE TABLE "ingo_shares" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255)
, "share_parents" text);
CREATE TABLE "ingo_sharesng" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255)
, "share_parents" text);
CREATE TABLE "ingo_sharesng_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "ingo_sharesng_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "kronolith_storage" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"vfb_owner" varchar(255),
"vfb_email" varchar(255) NOT NULL,
"vfb_serialized" text NOT NULL
);
CREATE TABLE "kronolith_shares_groups" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "kronolith_shares_users" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "kronolith_resources" (
"resource_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"resource_name" varchar(255),
"resource_calendar" varchar(255),
"resource_description" text,
"resource_response_type" int DEFAULT 0,
"resource_type" varchar(255) NOT NULL,
"resource_members" text
, "resource_email" varchar(255));
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 NOT NULL DEFAULT 0,
PRIMARY KEY("event_id")
);
CREATE TABLE "kronolith_shares" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000)
);
CREATE TABLE "kronolith_sharesng" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_creator_1024" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_default_1024" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"perm_guest_1024" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7),
"share_parents" varchar(4000)
);
CREATE TABLE "kronolith_sharesng_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0,
"perm_1024" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "kronolith_sharesng_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0,
"perm_1024" boolean NOT NULL DEFAULT 0
);
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 DEFAULT 0,
"event_attendees" text,
"event_keywords" text,
"event_exceptions" text,
"event_title" varchar(255),
"event_recurtype" int DEFAULT 0,
"event_recurinterval" int,
"event_recurdays" int,
"event_recurenddate" datetime,
"event_recurcount" int,
"event_start" datetime,
"event_end" datetime,
"event_alarm" int DEFAULT 0,
"event_modified" int DEFAULT 0,
"event_private" int NOT NULL DEFAULT 0,
"event_allday" int DEFAULT 0,
"event_alarm_methods" text,
"event_url" text,
"event_baseid" varchar(255) DEFAULT '',
"event_exceptionoriginaldate" datetime,
"event_resources" text
, "event_timezone" varchar(50));
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),
"memo_private" int NOT NULL DEFAULT 0,
PRIMARY KEY("memo_owner", "memo_id")
);
CREATE TABLE "mnemo_shares_groups" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "mnemo_shares_users" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "mnemo_shares" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255)
, "share_parents" text);
CREATE TABLE "mnemo_sharesng" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255)
, "share_parents" text);
CREATE TABLE "mnemo_sharesng_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "mnemo_sharesng_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "nag_shares_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int(2) NOT NULL
);
CREATE TABLE "nag_shares_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int(2) NOT NULL
);
CREATE TABLE "nag_shares" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"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),
"attribute_color" varchar(7)
, "share_parents" text, "attribute_issmart" int DEFAULT 0, "attribute_search" text);
CREATE TABLE "nag_sharesng" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_color" varchar(7)
, "share_parents" text, "attribute_issmart" int DEFAULT 0, "attribute_search" text);
CREATE TABLE "nag_sharesng_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "nag_sharesng_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
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),
"task_assignee" varchar(255),
"task_name" varchar(255) NOT NULL,
"task_uid" varchar(255) NOT NULL,
"task_desc" text,
"task_start" int,
"task_due" int,
"task_priority" int NOT NULL DEFAULT 0,
"task_estimate" float,
"task_completed" int(1) NOT NULL DEFAULT 0,
"task_completed_date" int,
"task_alarm" int NOT NULL DEFAULT 0,
"task_alarm_methods" text,
"task_private" int(1) NOT NULL DEFAULT 0,
"task_recurtype" int DEFAULT 0,
"task_recurinterval" int,
"task_recurdays" int,
"task_recurenddate" datetime,
"task_recurcount" int,
"task_exceptions" text,
"task_completions" text
);
CREATE TABLE "trean_bookmarks" (
"bookmark_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"bookmark_url" varchar(1024) NOT NULL,
"bookmark_title" varchar(255),
"bookmark_description" varchar(1024),
"bookmark_clicks" int DEFAULT 0,
"bookmark_http_status" varchar(5),
"bookmark_dt" datetime,
"user_id" int
, "favicon_url" varchar(255));
CREATE TABLE "turba_shares_groups" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "turba_shares_users" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm" int NOT NULL
);
CREATE TABLE "turba_shares" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255) NOT NULL,
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator" int NOT NULL DEFAULT 0,
"perm_default" int NOT NULL DEFAULT 0,
"perm_guest" int NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_params" text
, "share_parents" text);
CREATE TABLE "turba_sharesng" (
"share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"share_name" varchar(255) NOT NULL,
"share_owner" varchar(255),
"share_flags" int NOT NULL DEFAULT 0,
"perm_creator_2" boolean NOT NULL DEFAULT 0,
"perm_creator_4" boolean NOT NULL DEFAULT 0,
"perm_creator_8" boolean NOT NULL DEFAULT 0,
"perm_creator_16" boolean NOT NULL DEFAULT 0,
"perm_default_2" boolean NOT NULL DEFAULT 0,
"perm_default_4" boolean NOT NULL DEFAULT 0,
"perm_default_8" boolean NOT NULL DEFAULT 0,
"perm_default_16" boolean NOT NULL DEFAULT 0,
"perm_guest_2" boolean NOT NULL DEFAULT 0,
"perm_guest_4" boolean NOT NULL DEFAULT 0,
"perm_guest_8" boolean NOT NULL DEFAULT 0,
"perm_guest_16" boolean NOT NULL DEFAULT 0,
"attribute_name" varchar(255) NOT NULL,
"attribute_desc" varchar(255),
"attribute_params" text
, "share_parents" text);
CREATE TABLE "turba_sharesng_groups" (
"share_id" int NOT NULL,
"group_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
CREATE TABLE "turba_sharesng_users" (
"share_id" int NOT NULL,
"user_uid" varchar(255) NOT NULL,
"perm_2" boolean NOT NULL DEFAULT 0,
"perm_4" boolean NOT NULL DEFAULT 0,
"perm_8" boolean NOT NULL DEFAULT 0,
"perm_16" boolean NOT NULL DEFAULT 0
);
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),
"object_members" text,
"object_firstname" varchar(255),
"object_lastname" varchar(255),
"object_middlenames" varchar(255),
"object_nameprefix" varchar(32),
"object_namesuffix" varchar(32),
"object_alias" varchar(32),
"object_photo" blob,
"object_phototype" varchar(10),
"object_bday" varchar(10),
"object_homestreet" varchar(255),
"object_homepob" varchar(10),
"object_homecity" varchar(255),
"object_homeprovince" varchar(255),
"object_homepostalcode" varchar(10),
"object_homecountry" varchar(255),
"object_workstreet" varchar(255),
"object_workpob" varchar(10),
"object_workcity" varchar(255),
"object_workprovince" varchar(255),
"object_workpostalcode" varchar(10),
"object_workcountry" varchar(255),
"object_tz" varchar(32),
"object_geo" varchar(255),
"object_email" varchar(255),
"object_homephone" varchar(25),
"object_workphone" varchar(25),
"object_cellphone" varchar(25),
"object_fax" varchar(25),
"object_pager" varchar(25),
"object_title" varchar(255),
"object_role" varchar(255),
"object_logo" blob,
"object_logotype" varchar(10),
"object_company" varchar(255),
"object_category" varchar(80),
"object_notes" text,
"object_url" varchar(255),
"object_freebusyurl" varchar(255),
"object_pgppublickey" text,
"object_smimepublickey" text,
"object_anniversary" varchar(10),
"object_department" varchar(255),
"object_spouse" varchar(255),
"object_homefax" varchar(25),
"object_nickname" varchar(255),
"object_assistantphone" varchar(25),
"object_imaddress" varchar(255),
"object_imaddress2" varchar(255),
"object_imaddress3" varchar(255),
"object_homephone2" varchar(25),
"object_carphone" varchar(25),
"object_workphone2" varchar(25),
"object_radiophone" varchar(25),
"object_companyphone" varchar(25),
"object_otherstreet" varchar(255),
"object_otherpob" varchar(10),
"object_othercity" varchar(255),
"object_otherprovince" varchar(255),
"object_otherpostalcode" varchar(10),
"object_othercountry" varchar(255),
"object_yomifirstname" varchar(255),
"object_yomilastname" varchar(255),
"object_manager" varchar(255)
, "object_assistant" varchar(255), "object_workemail" varchar(255), "object_homeemail" varchar(255));
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('horde_groups',NULL);
INSERT INTO "sqlite_sequence" VALUES('horde_histories',0);
INSERT INTO "sqlite_sequence" VALUES('horde_histories_modseq',0);
INSERT INTO "sqlite_sequence" VALUES('horde_perms',0);
INSERT INTO "sqlite_sequence" VALUES('horde_vfs',0);
INSERT INTO "sqlite_sequence" VALUES('horde_muvfs',0);
INSERT INTO "sqlite_sequence" VALUES('imp_sentmail',0);
INSERT INTO "sqlite_sequence" VALUES('ingo_rules',0);
INSERT INTO "sqlite_sequence" VALUES('ingo_shares',0);
INSERT INTO "sqlite_sequence" VALUES('rampage_types',3);
INSERT INTO "sqlite_sequence" VALUES('kronolith_resources',0);
INSERT INTO "sqlite_sequence" VALUES('mnemo_shares',0);
INSERT INTO "sqlite_sequence" VALUES('nag_shares',0);
INSERT INTO "sqlite_sequence" VALUES('trean_bookmarks',0);
INSERT INTO "sqlite_sequence" VALUES('turba_shares',0);
INSERT INTO "sqlite_sequence" VALUES('rampage_objects',0);
INSERT INTO "sqlite_sequence" VALUES('kronolith_shares',0);
INSERT INTO "sqlite_sequence" VALUES('kronolith_sharesng',0);
CREATE INDEX "rampage_tagged_object_id" ON "rampage_tagged" ("object_id");
CREATE INDEX "rampage_tagged_tag_id" ON "rampage_tagged" ("tag_id");
CREATE INDEX "rampage_tagged_created" ON "rampage_tagged" ("created");
CREATE INDEX "rampage_user_tag_stats_tag_id" ON "rampage_user_tag_stats" ("tag_id");
CREATE INDEX "index_horde_alarms_on_alarm_id" ON "horde_alarms" ("alarm_id");
CREATE INDEX "index_horde_alarms_on_alarm_uid" ON "horde_alarms" ("alarm_uid");
CREATE INDEX "index_horde_alarms_on_alarm_start" ON "horde_alarms" ("alarm_start");
CREATE INDEX "index_horde_alarms_on_alarm_end" ON "horde_alarms" ("alarm_end");
CREATE INDEX "index_horde_alarms_on_alarm_snooze" ON "horde_alarms" ("alarm_snooze");
CREATE INDEX "index_horde_alarms_on_alarm_dismissed" ON "horde_alarms" ("alarm_dismissed");
CREATE INDEX "index_horde_dav_objects_on_id_collection" ON "horde_dav_objects" ("id_collection");
CREATE INDEX "index_horde_dav_collections_on_id_interface" ON "horde_dav_collections" ("id_interface");
CREATE INDEX "index_horde_dav_collections_on_id_internal" ON "horde_dav_collections" ("id_internal");
CREATE INDEX "index_horde_groups_members_on_group_uid" ON "horde_groups_members" ("group_uid");
CREATE INDEX "index_horde_groups_members_on_user_uid" ON "horde_groups_members" ("user_uid");
CREATE INDEX "index_horde_histories_on_history_action" ON "horde_histories" ("history_action");
CREATE INDEX "index_horde_histories_on_history_ts" ON "horde_histories" ("history_ts");
CREATE INDEX "index_horde_histories_on_history_modseq" ON "horde_histories" ("history_modseq");
CREATE INDEX "index_horde_histories_on_object_uid" ON "horde_histories" ("object_uid");
CREATE INDEX "index_horde_imap_client_data_on_hostspec_and_mailbox_and_port_and_username" ON "horde_imap_client_data" ("hostspec", "mailbox", "port", "username");
CREATE INDEX "index_horde_imap_client_message_on_msguid_and_uid" ON "horde_imap_client_message" ("msguid", "uid");
CREATE INDEX "index_horde_imap_client_metadata_on_uid" ON "horde_imap_client_metadata" ("uid");
CREATE INDEX "index_horde_prefs_on_pref_uid" ON "horde_prefs" ("pref_uid");
CREATE INDEX "index_horde_prefs_on_pref_scope" ON "horde_prefs" ("pref_scope");
CREATE INDEX "index_horde_sessionhandler_on_session_lastmodified" ON "horde_sessionhandler" ("session_lastmodified");
CREATE INDEX "index_horde_syncml_map_on_syncml_syncpartner" ON "horde_syncml_map" ("syncml_syncpartner");
CREATE INDEX "index_horde_syncml_map_on_syncml_db" ON "horde_syncml_map" ("syncml_db");
CREATE INDEX "index_horde_syncml_map_on_syncml_uid" ON "horde_syncml_map" ("syncml_uid");
CREATE INDEX "index_horde_syncml_map_on_syncml_cuid" ON "horde_syncml_map" ("syncml_cuid");
CREATE INDEX "index_horde_syncml_map_on_syncml_suid" ON "horde_syncml_map" ("syncml_suid");
CREATE INDEX "index_horde_syncml_anchors_on_syncml_syncpartner" ON "horde_syncml_anchors" ("syncml_syncpartner");
CREATE INDEX "index_horde_syncml_anchors_on_syncml_db" ON "horde_syncml_anchors" ("syncml_db");
CREATE INDEX "index_horde_syncml_anchors_on_syncml_uid" ON "horde_syncml_anchors" ("syncml_uid");
CREATE INDEX "index_horde_vfs_on_vfs_path" ON "horde_vfs" ("vfs_path");
CREATE INDEX "index_horde_vfs_on_vfs_name" ON "horde_vfs" ("vfs_name");
CREATE INDEX "index_horde_muvfs_on_vfs_path" ON "horde_muvfs" ("vfs_path");
CREATE INDEX "index_horde_muvfs_on_vfs_name" ON "horde_muvfs" ("vfs_name");
CREATE INDEX "index_imp_sentmail_on_sentmail_ts" ON "imp_sentmail" ("sentmail_ts");
CREATE INDEX "index_imp_sentmail_on_sentmail_who" ON "imp_sentmail" ("sentmail_who");
CREATE INDEX "index_imp_sentmail_on_sentmail_success" ON "imp_sentmail" ("sentmail_success");
CREATE INDEX "index_ingo_lists_on_list_owner_and_list_blacklist" ON "ingo_lists" ("list_owner", "list_blacklist");
CREATE INDEX "index_ingo_shares_groups_on_share_id" ON "ingo_shares_groups" ("share_id");
CREATE INDEX "index_ingo_shares_groups_on_group_uid" ON "ingo_shares_groups" ("group_uid");
CREATE INDEX "index_ingo_shares_groups_on_perm" ON "ingo_shares_groups" ("perm");
CREATE INDEX "index_ingo_shares_users_on_share_id" ON "ingo_shares_users" ("share_id");
CREATE INDEX "index_ingo_shares_users_on_user_uid" ON "ingo_shares_users" ("user_uid");
CREATE INDEX "index_ingo_shares_users_on_perm" ON "ingo_shares_users" ("perm");
CREATE INDEX "index_ingo_rules_on_rule_owner" ON "ingo_rules" ("rule_owner");
CREATE INDEX "index_ingo_shares_on_share_name" ON "ingo_shares" ("share_name");
CREATE INDEX "index_ingo_shares_on_share_owner" ON "ingo_shares" ("share_owner");
CREATE INDEX "index_ingo_shares_on_perm_creator" ON "ingo_shares" ("perm_creator");
CREATE INDEX "index_ingo_shares_on_perm_default" ON "ingo_shares" ("perm_default");
CREATE INDEX "index_ingo_shares_on_perm_guest" ON "ingo_shares" ("perm_guest");
CREATE INDEX "index_ingo_sharesng_on_share_name" ON "ingo_sharesng" ("share_name");
CREATE INDEX "index_ingo_sharesng_on_share_owner" ON "ingo_sharesng" ("share_owner");
CREATE INDEX "index_ingo_sharesng_on_perm_creator_2" ON "ingo_sharesng" ("perm_creator_2");
CREATE INDEX "index_ingo_sharesng_on_perm_creator_4" ON "ingo_sharesng" ("perm_creator_4");
CREATE INDEX "index_ingo_sharesng_on_perm_creator_8" ON "ingo_sharesng" ("perm_creator_8");
CREATE INDEX "index_ingo_sharesng_on_perm_creator_16" ON "ingo_sharesng" ("perm_creator_16");
CREATE INDEX "index_ingo_sharesng_on_perm_default_2" ON "ingo_sharesng" ("perm_default_2");
CREATE INDEX "index_ingo_sharesng_on_perm_default_4" ON "ingo_sharesng" ("perm_default_4");
CREATE INDEX "index_ingo_sharesng_on_perm_default_8" ON "ingo_sharesng" ("perm_default_8");
CREATE INDEX "index_ingo_sharesng_on_perm_default_16" ON "ingo_sharesng" ("perm_default_16");
CREATE INDEX "index_ingo_sharesng_on_perm_guest_2" ON "ingo_sharesng" ("perm_guest_2");
CREATE INDEX "index_ingo_sharesng_on_perm_guest_4" ON "ingo_sharesng" ("perm_guest_4");
CREATE INDEX "index_ingo_sharesng_on_perm_guest_8" ON "ingo_sharesng" ("perm_guest_8");
CREATE INDEX "index_ingo_sharesng_on_perm_guest_16" ON "ingo_sharesng" ("perm_guest_16");
CREATE INDEX "index_ingo_sharesng_groups_on_share_id" ON "ingo_sharesng_groups" ("share_id");
CREATE INDEX "index_ingo_sharesng_groups_on_group_uid" ON "ingo_sharesng_groups" ("group_uid");
CREATE INDEX "index_ingo_sharesng_groups_on_perm_2" ON "ingo_sharesng_groups" ("perm_2");
CREATE INDEX "index_ingo_sharesng_groups_on_perm_4" ON "ingo_sharesng_groups" ("perm_4");
CREATE INDEX "index_ingo_sharesng_groups_on_perm_8" ON "ingo_sharesng_groups" ("perm_8");
CREATE INDEX "index_ingo_sharesng_groups_on_perm_16" ON "ingo_sharesng_groups" ("perm_16");
CREATE INDEX "index_ingo_sharesng_users_on_share_id" ON "ingo_sharesng_users" ("share_id");
CREATE INDEX "index_ingo_sharesng_users_on_user_uid" ON "ingo_sharesng_users" ("user_uid");
CREATE INDEX "index_ingo_sharesng_users_on_perm_2" ON "ingo_sharesng_users" ("perm_2");
CREATE INDEX "index_ingo_sharesng_users_on_perm_4" ON "ingo_sharesng_users" ("perm_4");
CREATE INDEX "index_ingo_sharesng_users_on_perm_8" ON "ingo_sharesng_users" ("perm_8");
CREATE INDEX "index_ingo_sharesng_users_on_perm_16" ON "ingo_sharesng_users" ("perm_16");
CREATE INDEX "index_kronolith_storage_on_vfb_owner" ON "kronolith_storage" ("vfb_owner");
CREATE INDEX "index_kronolith_storage_on_vfb_email" ON "kronolith_storage" ("vfb_email");
CREATE INDEX "index_kronolith_shares_groups_on_share_id" ON "kronolith_shares_groups" ("share_id");
CREATE INDEX "index_kronolith_shares_groups_on_group_uid" ON "kronolith_shares_groups" ("group_uid");
CREATE INDEX "index_kronolith_shares_groups_on_perm" ON "kronolith_shares_groups" ("perm");
CREATE INDEX "index_kronolith_shares_users_on_share_id" ON "kronolith_shares_users" ("share_id");
CREATE INDEX "index_kronolith_shares_users_on_user_uid" ON "kronolith_shares_users" ("user_uid");
CREATE INDEX "index_kronolith_shares_users_on_perm" ON "kronolith_shares_users" ("perm");
CREATE INDEX "index_kronolith_resources_on_resource_calendar" ON "kronolith_resources" ("resource_calendar");
CREATE INDEX "index_kronolith_resources_on_resource_type" ON "kronolith_resources" ("resource_type");
CREATE INDEX "index_kronolith_shares_on_share_name" ON "kronolith_shares" ("share_name");
CREATE INDEX "index_kronolith_shares_on_share_owner" ON "kronolith_shares" ("share_owner");
CREATE INDEX "index_kronolith_shares_on_perm_creator" ON "kronolith_shares" ("perm_creator");
CREATE INDEX "index_kronolith_shares_on_perm_default" ON "kronolith_shares" ("perm_default");
CREATE INDEX "index_kronolith_shares_on_perm_guest" ON "kronolith_shares" ("perm_guest");
CREATE INDEX "index_kronolith_sharesng_on_share_name" ON "kronolith_sharesng" ("share_name");
CREATE INDEX "index_kronolith_sharesng_on_share_owner" ON "kronolith_sharesng" ("share_owner");
CREATE INDEX "index_kronolith_sharesng_on_perm_creator_2" ON "kronolith_sharesng" ("perm_creator_2");
CREATE INDEX "index_kronolith_sharesng_on_perm_creator_4" ON "kronolith_sharesng" ("perm_creator_4");
CREATE INDEX "index_kronolith_sharesng_on_perm_creator_8" ON "kronolith_sharesng" ("perm_creator_8");
CREATE INDEX "index_kronolith_sharesng_on_perm_creator_16" ON "kronolith_sharesng" ("perm_creator_16");
CREATE INDEX "index_kronolith_sharesng_on_perm_creator_1024" ON "kronolith_sharesng" ("perm_creator_1024");
CREATE INDEX "index_kronolith_sharesng_on_perm_default_2" ON "kronolith_sharesng" ("perm_default_2");
CREATE INDEX "index_kronolith_sharesng_on_perm_default_4" ON "kronolith_sharesng" ("perm_default_4");
CREATE INDEX "index_kronolith_sharesng_on_perm_default_8" ON "kronolith_sharesng" ("perm_default_8");
CREATE INDEX "index_kronolith_sharesng_on_perm_default_16" ON "kronolith_sharesng" ("perm_default_16");
CREATE INDEX "index_kronolith_sharesng_on_perm_default_1024" ON "kronolith_sharesng" ("perm_default_1024");
CREATE INDEX "index_kronolith_sharesng_on_perm_guest_2" ON "kronolith_sharesng" ("perm_guest_2");
CREATE INDEX "index_kronolith_sharesng_on_perm_guest_4" ON "kronolith_sharesng" ("perm_guest_4");
CREATE INDEX "index_kronolith_sharesng_on_perm_guest_8" ON "kronolith_sharesng" ("perm_guest_8");
CREATE INDEX "index_kronolith_sharesng_on_perm_guest_16" ON "kronolith_sharesng" ("perm_guest_16");
CREATE INDEX "index_kronolith_sharesng_on_perm_guest_1024" ON "kronolith_sharesng" ("perm_guest_1024");
CREATE INDEX "index_kronolith_sharesng_groups_on_share_id" ON "kronolith_sharesng_groups" ("share_id");
CREATE INDEX "index_kronolith_sharesng_groups_on_group_uid" ON "kronolith_sharesng_groups" ("group_uid");
CREATE INDEX "index_kronolith_sharesng_groups_on_perm_2" ON "kronolith_sharesng_groups" ("perm_2");
CREATE INDEX "index_kronolith_sharesng_groups_on_perm_4" ON "kronolith_sharesng_groups" ("perm_4");
CREATE INDEX "index_kronolith_sharesng_groups_on_perm_8" ON "kronolith_sharesng_groups" ("perm_8");
CREATE INDEX "index_kronolith_sharesng_groups_on_perm_16" ON "kronolith_sharesng_groups" ("perm_16");
CREATE INDEX "index_kronolith_sharesng_groups_on_perm_1024" ON "kronolith_sharesng_groups" ("perm_1024");
CREATE INDEX "index_kronolith_sharesng_users_on_share_id" ON "kronolith_sharesng_users" ("share_id");
CREATE INDEX "index_kronolith_sharesng_users_on_user_uid" ON "kronolith_sharesng_users" ("user_uid");
CREATE INDEX "index_kronolith_sharesng_users_on_perm_2" ON "kronolith_sharesng_users" ("perm_2");
CREATE INDEX "index_kronolith_sharesng_users_on_perm_4" ON "kronolith_sharesng_users" ("perm_4");
CREATE INDEX "index_kronolith_sharesng_users_on_perm_8" ON "kronolith_sharesng_users" ("perm_8");
CREATE INDEX "index_kronolith_sharesng_users_on_perm_16" ON "kronolith_sharesng_users" ("perm_16");
CREATE INDEX "index_kronolith_sharesng_users_on_perm_1024" ON "kronolith_sharesng_users" ("perm_1024");
CREATE INDEX "index_kronolith_events_on_calendar_id" ON "kronolith_events" ("calendar_id");
CREATE INDEX "index_kronolith_events_on_event_uid" ON "kronolith_events" ("event_uid");
CREATE INDEX "index_mnemo_memos_on_memo_owner" ON "mnemo_memos" ("memo_owner");
CREATE INDEX "index_mnemo_memos_on_memo_uid" ON "mnemo_memos" ("memo_uid");
CREATE INDEX "index_mnemo_shares_groups_on_share_id" ON "mnemo_shares_groups" ("share_id");
CREATE INDEX "index_mnemo_shares_groups_on_group_uid" ON "mnemo_shares_groups" ("group_uid");
CREATE INDEX "index_mnemo_shares_groups_on_perm" ON "mnemo_shares_groups" ("perm");
CREATE INDEX "index_mnemo_shares_users_on_share_id" ON "mnemo_shares_users" ("share_id");
CREATE INDEX "index_mnemo_shares_users_on_user_uid" ON "mnemo_shares_users" ("user_uid");
CREATE INDEX "index_mnemo_shares_users_on_perm" ON "mnemo_shares_users" ("perm");
CREATE INDEX "index_mnemo_shares_on_share_name" ON "mnemo_shares" ("share_name");
CREATE INDEX "index_mnemo_shares_on_share_owner" ON "mnemo_shares" ("share_owner");
CREATE INDEX "index_mnemo_shares_on_perm_creator" ON "mnemo_shares" ("perm_creator");
CREATE INDEX "index_mnemo_shares_on_perm_default" ON "mnemo_shares" ("perm_default");
CREATE INDEX "index_mnemo_shares_on_perm_guest" ON "mnemo_shares" ("perm_guest");
CREATE INDEX "index_mnemo_sharesng_on_share_name" ON "mnemo_sharesng" ("share_name");
CREATE INDEX "index_mnemo_sharesng_on_share_owner" ON "mnemo_sharesng" ("share_owner");
CREATE INDEX "index_mnemo_sharesng_on_perm_creator_2" ON "mnemo_sharesng" ("perm_creator_2");
CREATE INDEX "index_mnemo_sharesng_on_perm_creator_4" ON "mnemo_sharesng" ("perm_creator_4");
CREATE INDEX "index_mnemo_sharesng_on_perm_creator_8" ON "mnemo_sharesng" ("perm_creator_8");
CREATE INDEX "index_mnemo_sharesng_on_perm_creator_16" ON "mnemo_sharesng" ("perm_creator_16");
CREATE INDEX "index_mnemo_sharesng_on_perm_default_2" ON "mnemo_sharesng" ("perm_default_2");
CREATE INDEX "index_mnemo_sharesng_on_perm_default_4" ON "mnemo_sharesng" ("perm_default_4");
CREATE INDEX "index_mnemo_sharesng_on_perm_default_8" ON "mnemo_sharesng" ("perm_default_8");
CREATE INDEX "index_mnemo_sharesng_on_perm_default_16" ON "mnemo_sharesng" ("perm_default_16");
CREATE INDEX "index_mnemo_sharesng_on_perm_guest_2" ON "mnemo_sharesng" ("perm_guest_2");
CREATE INDEX "index_mnemo_sharesng_on_perm_guest_4" ON "mnemo_sharesng" ("perm_guest_4");
CREATE INDEX "index_mnemo_sharesng_on_perm_guest_8" ON "mnemo_sharesng" ("perm_guest_8");
CREATE INDEX "index_mnemo_sharesng_on_perm_guest_16" ON "mnemo_sharesng" ("perm_guest_16");
CREATE INDEX "index_mnemo_sharesng_groups_on_share_id" ON "mnemo_sharesng_groups" ("share_id");
CREATE INDEX "index_mnemo_sharesng_groups_on_group_uid" ON "mnemo_sharesng_groups" ("group_uid");
CREATE INDEX "index_mnemo_sharesng_groups_on_perm_2" ON "mnemo_sharesng_groups" ("perm_2");
CREATE INDEX "index_mnemo_sharesng_groups_on_perm_4" ON "mnemo_sharesng_groups" ("perm_4");
CREATE INDEX "index_mnemo_sharesng_groups_on_perm_8" ON "mnemo_sharesng_groups" ("perm_8");
CREATE INDEX "index_mnemo_sharesng_groups_on_perm_16" ON "mnemo_sharesng_groups" ("perm_16");
CREATE INDEX "index_mnemo_sharesng_users_on_share_id" ON "mnemo_sharesng_users" ("share_id");
CREATE INDEX "index_mnemo_sharesng_users_on_user_uid" ON "mnemo_sharesng_users" ("user_uid");
CREATE INDEX "index_mnemo_sharesng_users_on_perm_2" ON "mnemo_sharesng_users" ("perm_2");
CREATE INDEX "index_mnemo_sharesng_users_on_perm_4" ON "mnemo_sharesng_users" ("perm_4");
CREATE INDEX "index_mnemo_sharesng_users_on_perm_8" ON "mnemo_sharesng_users" ("perm_8");
CREATE INDEX "index_mnemo_sharesng_users_on_perm_16" ON "mnemo_sharesng_users" ("perm_16");
CREATE INDEX "index_nag_shares_groups_on_share_id" ON "nag_shares_groups" ("share_id");
CREATE INDEX "index_nag_shares_groups_on_group_uid" ON "nag_shares_groups" ("group_uid");
CREATE INDEX "index_nag_shares_groups_on_perm" ON "nag_shares_groups" ("perm");
CREATE INDEX "index_nag_shares_users_on_share_id" ON "nag_shares_users" ("share_id");
CREATE INDEX "index_nag_shares_users_on_user_uid" ON "nag_shares_users" ("user_uid");
CREATE INDEX "index_nag_shares_users_on_perm" ON "nag_shares_users" ("perm");
CREATE INDEX "index_nag_shares_on_share_name" ON "nag_shares" ("share_name");
CREATE INDEX "index_nag_shares_on_share_owner" ON "nag_shares" ("share_owner");
CREATE INDEX "index_nag_shares_on_perm_creator" ON "nag_shares" ("perm_creator");
CREATE INDEX "index_nag_shares_on_perm_default" ON "nag_shares" ("perm_default");
CREATE INDEX "index_nag_shares_on_perm_guest" ON "nag_shares" ("perm_guest");
CREATE INDEX "index_nag_sharesng_on_share_name" ON "nag_sharesng" ("share_name");
CREATE INDEX "index_nag_sharesng_on_share_owner" ON "nag_sharesng" ("share_owner");
CREATE INDEX "index_nag_sharesng_on_perm_creator_2" ON "nag_sharesng" ("perm_creator_2");
CREATE INDEX "index_nag_sharesng_on_perm_creator_4" ON "nag_sharesng" ("perm_creator_4");
CREATE INDEX "index_nag_sharesng_on_perm_creator_8" ON "nag_sharesng" ("perm_creator_8");
CREATE INDEX "index_nag_sharesng_on_perm_creator_16" ON "nag_sharesng" ("perm_creator_16");
CREATE INDEX "index_nag_sharesng_on_perm_default_2" ON "nag_sharesng" ("perm_default_2");
CREATE INDEX "index_nag_sharesng_on_perm_default_4" ON "nag_sharesng" ("perm_default_4");
CREATE INDEX "index_nag_sharesng_on_perm_default_8" ON "nag_sharesng" ("perm_default_8");
CREATE INDEX "index_nag_sharesng_on_perm_default_16" ON "nag_sharesng" ("perm_default_16");
CREATE INDEX "index_nag_sharesng_on_perm_guest_2" ON "nag_sharesng" ("perm_guest_2");
CREATE INDEX "index_nag_sharesng_on_perm_guest_4" ON "nag_sharesng" ("perm_guest_4");
CREATE INDEX "index_nag_sharesng_on_perm_guest_8" ON "nag_sharesng" ("perm_guest_8");
CREATE INDEX "index_nag_sharesng_on_perm_guest_16" ON "nag_sharesng" ("perm_guest_16");
CREATE INDEX "index_nag_sharesng_groups_on_share_id" ON "nag_sharesng_groups" ("share_id");
CREATE INDEX "index_nag_sharesng_groups_on_group_uid" ON "nag_sharesng_groups" ("group_uid");
CREATE INDEX "index_nag_sharesng_groups_on_perm_2" ON "nag_sharesng_groups" ("perm_2");
CREATE INDEX "index_nag_sharesng_groups_on_perm_4" ON "nag_sharesng_groups" ("perm_4");
CREATE INDEX "index_nag_sharesng_groups_on_perm_8" ON "nag_sharesng_groups" ("perm_8");
CREATE INDEX "index_nag_sharesng_groups_on_perm_16" ON "nag_sharesng_groups" ("perm_16");
CREATE INDEX "index_nag_sharesng_users_on_share_id" ON "nag_sharesng_users" ("share_id");
CREATE INDEX "index_nag_sharesng_users_on_user_uid" ON "nag_sharesng_users" ("user_uid");
CREATE INDEX "index_nag_sharesng_users_on_perm_2" ON "nag_sharesng_users" ("perm_2");
CREATE INDEX "index_nag_sharesng_users_on_perm_4" ON "nag_sharesng_users" ("perm_4");
CREATE INDEX "index_nag_sharesng_users_on_perm_8" ON "nag_sharesng_users" ("perm_8");
CREATE INDEX "index_nag_sharesng_users_on_perm_16" ON "nag_sharesng_users" ("perm_16");
CREATE INDEX "index_nag_tasks_on_task_owner" ON "nag_tasks" ("task_owner");
CREATE INDEX "index_nag_tasks_on_task_uid" ON "nag_tasks" ("task_uid");
CREATE INDEX "index_nag_tasks_on_task_start" ON "nag_tasks" ("task_start");
CREATE INDEX "index_trean_bookmarks_on_bookmark_clicks" ON "trean_bookmarks" ("bookmark_clicks");
CREATE INDEX "index_trean_bookmarks_on_user_id" ON "trean_bookmarks" ("user_id");
CREATE INDEX "index_turba_shares_groups_on_share_id" ON "turba_shares_groups" ("share_id");
CREATE INDEX "index_turba_shares_groups_on_group_uid" ON "turba_shares_groups" ("group_uid");
CREATE INDEX "index_turba_shares_groups_on_perm" ON "turba_shares_groups" ("perm");
CREATE INDEX "index_turba_shares_users_on_share_id" ON "turba_shares_users" ("share_id");
CREATE INDEX "index_turba_shares_users_on_user_uid" ON "turba_shares_users" ("user_uid");
CREATE INDEX "index_turba_shares_users_on_perm" ON "turba_shares_users" ("perm");
CREATE INDEX "index_turba_shares_on_share_name" ON "turba_shares" ("share_name");
CREATE INDEX "index_turba_shares_on_share_owner" ON "turba_shares" ("share_owner");
CREATE INDEX "index_turba_shares_on_perm_creator" ON "turba_shares" ("perm_creator");
CREATE INDEX "index_turba_shares_on_perm_default" ON "turba_shares" ("perm_default");
CREATE INDEX "index_turba_shares_on_perm_guest" ON "turba_shares" ("perm_guest");
CREATE INDEX "index_turba_sharesng_on_share_name" ON "turba_sharesng" ("share_name");
CREATE INDEX "index_turba_sharesng_on_share_owner" ON "turba_sharesng" ("share_owner");
CREATE INDEX "index_turba_sharesng_on_perm_creator_2" ON "turba_sharesng" ("perm_creator_2");
CREATE INDEX "index_turba_sharesng_on_perm_creator_4" ON "turba_sharesng" ("perm_creator_4");
CREATE INDEX "index_turba_sharesng_on_perm_creator_8" ON "turba_sharesng" ("perm_creator_8");
CREATE INDEX "index_turba_sharesng_on_perm_creator_16" ON "turba_sharesng" ("perm_creator_16");
CREATE INDEX "index_turba_sharesng_on_perm_default_2" ON "turba_sharesng" ("perm_default_2");
CREATE INDEX "index_turba_sharesng_on_perm_default_4" ON "turba_sharesng" ("perm_default_4");
CREATE INDEX "index_turba_sharesng_on_perm_default_8" ON "turba_sharesng" ("perm_default_8");
CREATE INDEX "index_turba_sharesng_on_perm_default_16" ON "turba_sharesng" ("perm_default_16");
CREATE INDEX "index_turba_sharesng_on_perm_guest_2" ON "turba_sharesng" ("perm_guest_2");
CREATE INDEX "index_turba_sharesng_on_perm_guest_4" ON "turba_sharesng" ("perm_guest_4");
CREATE INDEX "index_turba_sharesng_on_perm_guest_8" ON "turba_sharesng" ("perm_guest_8");
CREATE INDEX "index_turba_sharesng_on_perm_guest_16" ON "turba_sharesng" ("perm_guest_16");
CREATE INDEX "index_turba_sharesng_groups_on_share_id" ON "turba_sharesng_groups" ("share_id");
CREATE INDEX "index_turba_sharesng_groups_on_group_uid" ON "turba_sharesng_groups" ("group_uid");
CREATE INDEX "index_turba_sharesng_groups_on_perm_2" ON "turba_sharesng_groups" ("perm_2");
CREATE INDEX "index_turba_sharesng_groups_on_perm_4" ON "turba_sharesng_groups" ("perm_4");
CREATE INDEX "index_turba_sharesng_groups_on_perm_8" ON "turba_sharesng_groups" ("perm_8");
CREATE INDEX "index_turba_sharesng_groups_on_perm_16" ON "turba_sharesng_groups" ("perm_16");
CREATE INDEX "index_turba_sharesng_users_on_share_id" ON "turba_sharesng_users" ("share_id");
CREATE INDEX "index_turba_sharesng_users_on_user_uid" ON "turba_sharesng_users" ("user_uid");
CREATE INDEX "index_turba_sharesng_users_on_perm_2" ON "turba_sharesng_users" ("perm_2");
CREATE INDEX "index_turba_sharesng_users_on_perm_4" ON "turba_sharesng_users" ("perm_4");
CREATE INDEX "index_turba_sharesng_users_on_perm_8" ON "turba_sharesng_users" ("perm_8");
CREATE INDEX "index_turba_sharesng_users_on_perm_16" ON "turba_sharesng_users" ("perm_16");
CREATE INDEX "index_turba_objects_on_owner_id" ON "turba_objects" ("owner_id");
CREATE INDEX "index_turba_objects_on_object_email" ON "turba_objects" ("object_email");
CREATE INDEX "index_turba_objects_on_object_firstname" ON "turba_objects" ("object_firstname");
CREATE INDEX "index_turba_objects_on_object_lastname" ON "turba_objects" ("object_lastname");
CREATE UNIQUE INDEX "rampage_objects_type_name" ON "rampage_types" ("type_name");
CREATE UNIQUE INDEX "rampage_objects_type_object_name" ON "rampage_objects" ("type_id", "object_name");
CREATE UNIQUE INDEX "rampage_users_user_name" ON "rampage_users" ("user_name");
CREATE UNIQUE INDEX "rampage_tags_tag_name" ON "rampage_tags" ("tag_name");
CREATE UNIQUE INDEX "index_horde_dav_objects_on_id_internal" ON "horde_dav_objects" ("id_internal");
CREATE UNIQUE INDEX "index_horde_dav_objects_on_id_external" ON "horde_dav_objects" ("id_external");
CREATE UNIQUE INDEX "index_horde_dav_collections_on_id_external" ON "horde_dav_collections" ("id_external");
CREATE UNIQUE INDEX "index_horde_groups_on_group_name" ON "horde_groups" ("group_name");
CREATE UNIQUE INDEX "index_horde_perms_on_perm_name" ON "horde_perms" ("perm_name");
COMMIT;