/home/sharedstore/.cphorde
Edit: /home/sharedstore/.cphorde/horde.sqlite (1597440B)
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
i A rbP8%AW}
-kronolith_shares%turba_shares rampage_objects)turba_sharesng turba_shares+trean_bookmarks
!nag_shares%nag_sharesng)mnemo_sharesng%mnemo_shares1kronolith_sharesng+rampage_objects'rampage_types3kronolith_resources
'ingo_sharesng #ingo_shares
!ingo_rules%imp_sentmail#horde_muvfshorde_vfs#horde_perms9horde_histories_modseq+horde_histories% horde_groups
( U 6f46cdd3-c4d9-9819-de69-a5b077f3f309( U fe96d81e-f782-b16a-4b4d-00f7a0982765( U 30717596-1b11-ec03-8324-be46c069dae0
B ]Ugcalendar6f46cdd3-c4d9-9819-de69-a5b077f3f309calendar:6f46cdd3-c4d9-9819-de69-a5b077f3f309]Ugcalendarfe96d81e-f782-b16a-4b4d-00f7a0982765calendar:fe96d81e-f782-b16a-4b4d-00f7a0982765]Ugcalendar30717596-1b11-ec03-8324-be46c069dae0calendar:30717596-1b11-ec03-8324-be46c069dae0
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
)
9 9
%
G e 9 h3info@sharedstore.makronolithfb_calsa:1:{i:0;s:45:"internal_6f46cdd3-c4d9-9819-de69-a5b077f3f309";}g3'info@sharedstore.makronolithsearch_fields{"f32a59d2-7c8f-1892-5536-0a1acbe16553":["name","email"]}W3)]info@sharedstore.makronolithsearch_sources["f32a59d2-7c8f-1892-5536-0a1acbe16553"]_3!{info@sharedstore.mahordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:19:"info@sharedstore.ma";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}c
3%yinfo@sharedstore.makronolithdisplay_calsa:1:{i:0;s:36:"6f46cdd3-c4d9-9819-de69-a5b077f3f309";}i5admin@sharedstore.makronolithfb_calsa:1:{i:0;s:45:"internal_fe96d81e-f782-b16a-4b4d-00f7a0982765";}h5'admin@sharedstore.makronolithsearch_fields{"f32a59d2-7c8f-1892-5536-0a1acbe16553":["name","email"]}X
5)]admin@sharedstore.makronolithsearch_sources["f32a59d2-7c8f-1892-5536-0a1acbe16553"]a 5!}admin@sharedstore.mahordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:20:"admin@sharedstore.ma";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}d5%yadmin@sharedstore.makronolithdisplay_calsa:1:{i:0;s:36:"fe96d81e-f782-b16a-4b4d-00f7a0982765";}`#sharedstorekronolithfb_calsa:1:{i:0;s:45:"internal_30717596-1b11-ec03-8324-be46c069dae0";}_#'sharedstorekronolithsearch_fields{"f32a59d2-7c8f-1892-5536-0a1acbe16553":["name","email"]}O#)]sharedstorekronolithsearch_sources["f32a59d2-7c8f-1892-5536-0a1acbe16553"]L#1Usharedstorecpanelshared_addressbookf32a59d2-7c8f-1892-5536-0a1acbe165530#?sharedstorecpanelglobal_addressbook_shared1g#!sharedstorehordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:35:"sharedstore@mocha9006.mochahost.com";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}[#%ysharedstorekronolithdisplay_calsa:1:{i:0;s:36:"30717596-1b11-ec03-8324-be46c069dae0";}
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