PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE "content_schema_info" (
  "version" int
);
INSERT INTO "content_schema_info" VALUES(2);
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(5,'contact');
INSERT INTO "rampage_types" VALUES(2,'event');
INSERT INTO "rampage_types" VALUES(3,'note');
INSERT INTO "rampage_types" VALUES(4,'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_alarm_schema_info" (
  "version" int
);
INSERT INTO "horde_alarm_schema_info" VALUES(2);
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
, "alarm_instanceid" varchar(255));
CREATE TABLE "horde_auth_schema_info" (
  "version" int
);
INSERT INTO "horde_auth_schema_info" VALUES(1);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_cache_schema_info" VALUES(2);
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_core_schema_info" (
  "version" int
);
INSERT INTO "horde_core_schema_info" VALUES(1);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_dav_schema_info" VALUES(2);
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_group_schema_info" (
  "version" int
);
INSERT INTO "horde_group_schema_info" VALUES(3);
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,
  "group_name" varchar(255) NOT NULL,
  "group_parents" varchar(255) NOT NULL,
  "group_email" varchar(255)
);
CREATE TABLE "horde_history_schema_info" (
  "version" int
);
INSERT INTO "horde_history_schema_info" VALUES(6);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_imap_client_schema_info" VALUES(2);
CREATE TABLE "horde_imap_client_data" (
  "messageid" 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,
  "messageid" bigint NOT NULL
);
CREATE TABLE "horde_imap_client_metadata" (
  "data" blob,
  "field" varchar(255) NOT NULL,
  "messageid" bigint NOT NULL
);
CREATE TABLE "horde_lock_schema_info" (
  "version" int
);
INSERT INTO "horde_lock_schema_info" VALUES(3);
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" int NOT NULL,
  "lock_update_timestamp" int NOT NULL,
  "lock_expiry_timestamp" int NOT NULL,
  "lock_type" int NOT NULL
);
CREATE TABLE "horde_perms_schema_info" (
  "version" int
);
INSERT INTO "horde_perms_schema_info" VALUES(3);
CREATE TABLE "horde_perms" (
  "perm_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "perm_name" varchar(255) NOT NULL,
  "perm_parents" varchar(255),
  "perm_data" text
);
CREATE TABLE "horde_prefs_schema_info" (
  "version" int
);
INSERT INTO "horde_prefs_schema_info" VALUES(3);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_queue_schema_info" VALUES(1);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_sessionhandler_schema_info" VALUES(2);
CREATE TABLE "horde_sessionhandler" (
  "session_id" varchar(32) NOT NULL,
  "session_lastmodified" int NOT NULL,
  "session_data" blob
);
CREATE TABLE "horde_syncml_schema_info" (
  "version" int
);
INSERT INTO "horde_syncml_schema_info" VALUES(1);
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_token_schema_info" (
  "version" int
);
INSERT INTO "horde_token_schema_info" VALUES(1);
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_schema_info" (
  "version" int
);
INSERT INTO "horde_vfs_schema_info" VALUES(4);
CREATE TABLE "horde_vfs" (
  "vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "vfs_type" int NOT NULL,
  "vfs_path" varchar(255),
  "vfs_name" varchar(255) NOT NULL,
  "vfs_modified" int NOT NULL,
  "vfs_owner" varchar(255),
  "vfs_data" blob
);
CREATE TABLE "horde_muvfs" (
  "vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  "vfs_type" int NOT NULL,
  "vfs_path" varchar(255),
  "vfs_name" varchar(255) NOT NULL,
  "vfs_modified" int NOT NULL,
  "vfs_owner" varchar(255),
  "vfs_perms" int NOT NULL,
  "vfs_data" blob
);
CREATE TABLE "imp_schema_info" (
  "version" int
);
INSERT INTO "imp_schema_info" VALUES(3);
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_schema_info" (
  "version" int
);
INSERT INTO "ingo_schema_info" VALUES(7);
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_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 "ingo_shares" (
  "share_id" INTEGER PRIMARY KEY AUTOINCREMENT 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" varchar(4000)
);
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" varchar(4000)
);
CREATE TABLE "kronolith_schema_info" (
  "version" int
);
INSERT INTO "kronolith_schema_info" VALUES(23);
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_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 "kronolith_shares" (
  "share_id" INTEGER PRIMARY KEY AUTOINCREMENT 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,
  "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 "mnemo_schema_info" (
  "version" int
);
INSERT INTO "mnemo_schema_info" VALUES(8);
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_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 "mnemo_shares" (
  "share_id" INTEGER PRIMARY KEY AUTOINCREMENT 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" varchar(4000)
);
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" varchar(4000)
);
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(255) NOT NULL,
  "memo_body" text,
  "memo_private" int NOT NULL DEFAULT 0
);
CREATE TABLE "nag_schema_info" (
  "version" int
);
INSERT INTO "nag_schema_info" VALUES(14);
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_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 "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" varchar(4000),
  "attribute_issmart" int DEFAULT 0,
  "attribute_search" text
);
CREATE TABLE "nag_shares" (
  "share_id" INTEGER PRIMARY KEY AUTOINCREMENT 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" varchar(4000),
  "attribute_issmart" int DEFAULT 0,
  "attribute_search" varchar(4000)
);
CREATE TABLE "trean_schema_info" (
  "version" int
);
INSERT INTO "trean_schema_info" VALUES(5);
CREATE TABLE "trean_bookmarks" (
  "bookmark_id" INTEGER PRIMARY KEY AUTOINCREMENT 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 NOT NULL
, "favicon_url" varchar(255));
CREATE TABLE "turba_schema_info" (
  "version" int
);
INSERT INTO "turba_schema_info" VALUES(11);
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_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_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)
);
CREATE TABLE "turba_shares" (
  "share_id" INTEGER PRIMARY KEY AUTOINCREMENT 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" varchar(4000)
);
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" varchar(4000)
);
CREATE TABLE cpanel_schema_info (version VARCHAR(20));
INSERT INTO "cpanel_schema_info" VALUES('11.58');
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('ingo_sharesng',0);
INSERT INTO "sqlite_sequence" VALUES('kronolith_resources',0);
INSERT INTO "sqlite_sequence" VALUES('rampage_types',5);
INSERT INTO "sqlite_sequence" VALUES('kronolith_shares',0);
INSERT INTO "sqlite_sequence" VALUES('kronolith_sharesng',0);
INSERT INTO "sqlite_sequence" VALUES('mnemo_shares',0);
INSERT INTO "sqlite_sequence" VALUES('mnemo_sharesng',0);
INSERT INTO "sqlite_sequence" VALUES('nag_sharesng',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('turba_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_dav_objects_on_id_external" ON "horde_dav_objects" ("id_external");
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_messageid" ON "horde_imap_client_message" ("msguid", "messageid");
CREATE INDEX "index_horde_imap_client_metadata_on_messageid" ON "horde_imap_client_metadata" ("messageid");
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_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_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_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_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_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_events_on_event_baseid" ON "kronolith_events" ("event_baseid");
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_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_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_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_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_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_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_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_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_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 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_collections_on_id_external" ON "horde_dav_collections" ("id_external");
CREATE UNIQUE INDEX "index_horde_dav_objects_on_id_external_and_id_collection" ON "horde_dav_objects" ("id_external", "id_collection");
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");
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 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");
COMMIT;
