SQLite format 3 @ g . zBv T77Gtablehorde_dav_collectionshorde_dav_collectionsCREATE TABLE "horde_dav_collections" (
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)I//Atablehorde_dav_objectshorde_dav_objectsCREATE TABLE "horde_dav_objects" (
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
)k''tablehorde_signupshorde_signupsCREATE 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")
)9M' indexsqlite_autoindex_horde_signups_1horde_signupsq99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
)=##Atablehorde_cachehorde_cacheCREATE TABLE "horde_cache" (
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
)u;;tablehorde_cache_schema_infohorde_cache_schema_infoCREATE TABLE "horde_cache_schema_info" (
"version" int
)j##tablehorde_usershorde_usersCREATE 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")
)5I# indexsqlite_autoindex_horde_users_1horde_usersq99tablehorde_auth_schema_infohorde_auth_schema_infoCREATE TABLE "horde_auth_schema_info" (
"version" int
)h%%tablehorde_alarmshorde_alarmsCREATE 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))u
;;tablehorde_alarm_schema_infohorde_alarm_schema_infoCREATE TABLE "horde_alarm_schema_info" (
"version" int
)G99)tablerampage_user_tag_statsrampage_user_tag_statsCREATE TABLE "rampage_user_tag_stats" (
"user_id" int NOT NULL,
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("user_id", "tag_id")
)K_9 indexsqlite_autoindex_rampage_user_tag_stats_1rampage_user_tag_stats
//Utablerampage_tag_statsrampage_tag_stats
CREATE TABLE "rampage_tag_stats" (
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("tag_id")
)A
U/ indexsqlite_autoindex_rampage_tag_stats_1rampage_tag_stats_))ytablerampage_taggedrampage_taggedCREATE 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")
);O) indexsqlite_autoindex_rampage_tagged_1rampage_tagged %%tablerampage_tagsrampage_tagsCREATE TABLE "rampage_tags" (
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
)#''tablerampage_usersrampage_usersCREATE TABLE "rampage_users" (
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
)G++Etablerampage_objectsrampage_objectsCREATE TABLE "rampage_objects" (
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#''tablerampage_typesrampage_typesCREATE TABLE "rampage_types" (
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
)h cX KF 20 k ցV B + v~ rk hg \_ SR GJ 3> +
task note event
contact calendar
} rbP8%} )turba_sharesng%turba_shares+trean_bookmarks
!nag_shares%nag_sharesng)mnemo_sharesng%mnemo_shares1kronolith_sharesng
-kronolith_shares'rampage_types3kronolith_resources
'ingo_sharesng #ingo_shares
!ingo_rules%imp_sentmail#horde_muvfshorde_vfs#horde_perms9horde_histories_modseq+horde_histories% horde_groups
v
.nP
+ ~
H NBv T77Gtablehorde_dav_collectionshorde_dav_collectionsCREATE TABLE "horde_dav_collection 77Gtablehorde_dav_collectionshorde_dav_collectionsCREATE TABLE "horde_dav_collections" (
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)I//Atablehorde_dav_objectshorde_dav_objectsCREATE TABLE "horde_dav_objects" (
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
)9M' indexsqlite_autoindex_horde_signups_1horde_signupsk''tablehorde_signupshorde_signupsCREATE 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")
)q99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
)=##Atablehorde_cachehorde_cacheCREATE TABLE "horde_cache" (
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
)u;;tablehorde_cache_schema_infohorde_cache_schema_infoCREATE TABLE "horde_cache_schema_info" (
"version" int
)5I# indexsqlite_autoindex_horde_users_1horde_usersj##tablehorde_usershorde_usersCREATE 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")
)q99tablehorde_auth_schema_infohorde_auth_schema_infoCREATE TABLE "horde_auth_schema_info" (
"version" int
)h%%tablehorde_alarmshorde_alarmsCREATE 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))u
;;tablehorde_alarm_schema_infohorde_alarm_schema_infoCREATE TABLE "horde_alarm_schema_info" (
"version" int
)G99)tablerampage_user_tag_statsrampage_user_tag_statsCREATE TABLE "rampage_user_tag_stats" (
"user_id" int NOT NULL,
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("user_id", "tag_id")
)K_9 indexsqlite_autoindex_rampage_user_tag_stats_1rampage_user_tag_stats
//Utablerampage_tag_statsrampage_tag_stats
CREATE TABLE "rampage_tag_stats" (
"tag_id" int NOT NULL,
"count" int,
PRIMARY KEY("tag_id")
)A
U/ indexsqlite_autoindex_rampage_tag_stats_1rampage_tag_stats_))ytablerampage_taggedrampage_taggedCREATE 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")
);O) indexsqlite_autoindex_rampage_tagged_1rampage_tagged %%tablerampage_tagsrampage_tagsCREATE TABLE "rampage_tags" (
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
)#''tablerampage_usersrampage_usersCREATE TABLE "rampage_users" (
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
)G++Etablerampage_objectsrampage_objectsCREATE TABLE "rampage_objects" (
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)#''tablerampage_typesrampage_typesCREATE TABLE "rampage_types" (
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
)h33ytablecontent_schema_infocontent_schema_infoCREATE TABLE "content_schema_info" (
"version" int
)
Y
&
gx
Iy+Y b Z ==tablehorde_syncml_schema_infohorde_syncml_schema_info1CREATE TABLE "horde_syncml_schema_inf MMtablehorde_sessionhandler_schema_infohorde_sessionhandler_schema_info/CREATE TABLE "horde_sessionhandler_schema_info" (
"version" int
)O+//Mtablehorde_queue_taskshorde_queue_tasks.CREATE TABLE "horde_queue_tasks" (
"task_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"task_queue" varchar(255) NOT NULL,
"task_fields" text NOT NULL
)u*;;tablehorde_queue_schema_infohorde_queue_schema_info-CREATE TABLE "horde_queue_schema_info" (
"version" int
)T77Gtablehorde_dav_collectionshorde_dav_collectionsCREATE TABLE "horde_dav_collections" (
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)M)##atablehorde_prefshorde_prefs,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
)u(;;tablehorde_prefs_schema_infohorde_prefs_schema_info+CREATE TABLE "horde_prefs_schema_info" (
"version" int
)P'##gtablehorde_permshorde_perms*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
)u&;;tablehorde_perms_schema_infohorde_perms_schema_info)CREATE TABLE "horde_perms_schema_info" (
"version" int
)k%##tablehorde_lockshorde_locks(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
)q$99tablehorde_lock_schema_infohorde_lock_schema_info'CREATE TABLE "horde_lock_schema_info" (
"version" int
)<#AAtablehorde_imap_client_metadatahorde_imap_client_metadata&CREATE TABLE "horde_imap_client_metadata" (
"data" blob,
"field" varchar(255) NOT NULL,
"messageid" bigint NOT NULL
):"??tablehorde_imap_client_messagehorde_imap_client_message%CREATE TABLE "horde_imap_client_message" (
"data" blob,
"msguid" varchar(255) NOT NULL,
"messageid" bigint NOT NULL
)2!99tablehorde_imap_client_datahorde_imap_client_data$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
) GG
tablehorde_imap_client_schema_infohorde_imap_client_schema_info#CREATE TABLE "horde_imap_client_schema_info" (
"version" int
)c99atablehorde_histories_modseqhorde_histories_modseq"CREATE TABLE "horde_histories_modseq" (
"history_modseq" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL DEFAULT 0,
"history_modseqempty" int NOT NULL DEFAULT 0
)r++tablehorde_historieshorde_histories!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){??tablehorde_history_schema_infohorde_history_schema_info CREATE TABLE "horde_history_schema_info" (
"version" int
)j%%tablehorde_groupshorde_groupsCREATE 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)
)55Ytablehorde_groups_membershorde_groups_membersCREATE TABLE "horde_groups_members" (
"group_uid" int NOT NULL,
"user_uid" varchar(255) NOT NULL
)u;;tablehorde_group_schema_infohorde_group_schema_infoCREATE TABLE "horde_group_schema_info" (
"version" int
)
t m2
w
[ 3Xm0tA _D 11itableingo_shares_groupsingo_shares_groupsDCREATE 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
)1?E indexsqlite_autoindex_ingo_spam_1ingo_spamC9>Atableingo_spamingo_spamBCREATE TABLE "ingo_spam" (
"spam_owner" varchar(255) NOT NULL,
"spam_level" int DEFAULT 5,
"spam_folder" varchar(255),
PRIMARY KEY("spam_owner")
);=O) indexsqlite_autoindex_ingo_vacations_1ingo_vacationsA<))=tableingo_vacationsingo_vacations@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")
)4;'''tableingo_forwardsingo_forwards?CREATE TABLE "ingo_forwards" (
"forward_owner" varchar(255) NOT NULL,
"forward_addresses" text,
"forward_keep" int NOT NULL DEFAULT 0
)-:!!%tableingo_listsingo_lists>CREATE TABLE "ingo_lists" (
"list_owner" varchar(255) NOT NULL,
"list_blacklist" int DEFAULT 0,
"list_address" varchar(255) NOT NULL
)_9--stableingo_schema_infoingo_schema_info=CREATE TABLE "ingo_schema_info" (
"version" int
)w8%%1tableimp_sentmailimp_sentmail