Edit: /home/simp499cl/.cphorde/horde.sqlite (1605632B)
SQLite format 3 @ J g J ._ 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
X. ( U 9de3b66b-cb62-63d4-5a3a-aa0fba3bba02( U 8843bcb9-0fb8-9ed2-07ae-7660f7dbfc11( U 14509c50-ad46-ad96-c932-0291d37c1bd6( U 0233cdfc-f532-d14d-24a1-36bf8026ee08( U b556a1cb-85c1-24f5-df68-eb918afd31ff( U 1b7a3c81-e7db-234c-9b67-68f84d133171( U ddce6dd2-2107-3976-92e1-f7e8f0cc5d94
g B%
g ]Ugcalendar9de3b66b-cb62-63d4-5a3a-aa0fba3bba02calendar:9de3b66b-cb62-63d4-5a3a-aa0fba3bba02]Ugcalendar8843bcb9-0fb8-9ed2-07ae-7660f7dbfc11calendar:8843bcb9-0fb8-9ed2-07ae-7660f7dbfc11]Ugcalendar14509c50-ad46-ad96-c932-0291d37c1bd6calendar:14509c50-ad46-ad96-c932-0291d37c1bd6]Ugcalendar0233cdfc-f532-d14d-24a1-36bf8026ee08calendar:0233cdfc-f532-d14d-24a1-36bf8026ee08]Ugcalendarb556a1cb-85c1-24f5-df68-eb918afd31ffcalendar:b556a1cb-85c1-24f5-df68-eb918afd31ff]Ugcalendar1b7a3c81-e7db-234c-9b67-68f84d133171calendar:1b7a3c81-e7db-234c-9b67-68f84d133171]Ugcalendarddce6dd2-2107-3976-92e1-f7e8f0cc5d94calendar:ddce6dd2-2107-3976-92e1-f7e8f0cc5d94
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
)
D
6f
{
;[m/cz cK)]carlos.hidalgo@simplesystems.clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]wK!carlos.hidalgo@simplesystems.clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:31:"carlos.hidalgo@simplesystems.cl";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}oK%ycarlos.hidalgo@simplesystems.clkronolithdisplay_calsa:1:{i:0;s:36:"8843bcb9-0fb8-9ed2-07ae-7660f7dbfc11";}sImarcelasantis@simplesystems.clkronolithfb_calsa:1:{i:0;s:45:"internal_14509c50-ad46-ad96-c932-0291d37c1bd6";}rI'marcelasantis@simplesystems.clkronolithsearch_fields{"cf90278b-6d95-cc3c-ac31-1447fcc8c4ae":["name","email"]}bI)]marcelasantis@simplesystems.clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]uI!marcelasantis@simplesystems.clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:30:"marcelasantis@simplesystems.cl";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}nI%ymarcelasantis@simplesystems.clkronolithdisplay_calsa:1:{i:0;s:36:"14509c50-ad46-ad96-c932-0291d37c1bd6";}n?contacto@simplesystems.clkronolithfb_calsa:1:{i:0;s:45:"internal_0233cdfc-f532-d14d-24a1-36bf8026ee08";}m?'contacto@simplesystems.clkronolithsearch_fields{"cf90278b-6d95-cc3c-ac31-1447fcc8c4ae":["name","email"]}]?)]contacto@simplesystems.clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]k?!contacto@simplesystems.clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:25:"contacto@simplesystems.cl";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}i?%ycontacto@simplesystems.clkronolithdisplay_calsa:1:{i:0;s:36:"0233cdfc-f532-d14d-24a1-36bf8026ee08";}sIcarloshidalgo@simplesystems.clkronolithfb_calsa:1:{i:0;s:45:"internal_b556a1cb-85c1-24f5-df68-eb918afd31ff";}rI'carloshidalgo@simplesystems.clkronolithsearch_fields{"cf90278b-6d95-cc3c-ac31-1447fcc8c4ae":["name","email"]}bI)]carloshidalgo@simplesystems.clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]uI!carloshidalgo@simplesystems.clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:30:"carloshidalgo@simplesystems.cl";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}n
I%ycarloshidalgo@simplesystems.clkronolithdisplay_calsa:1:{i:0;s:36:"b556a1cb-85c1-24f5-df68-eb918afd31ff";}tKhernancastillo@simplesystems.clkronolithfb_calsa:1:{i:0;s:45:"internal_1b7a3c81-e7db-234c-9b67-68f84d133171";}sK'hernancastillo@simplesystems.clkronolithsearch_fields{"cf90278b-6d95-cc3c-ac31-1447fcc8c4ae":["name","email"]}c
K)]hernancastillo@simplesystems.clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]w K!hernancastillo@simplesystems.clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:31:"hernancastillo@simplesystems.cl";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}oK%yhernancastillo@simplesystems.clkronolithdisplay_calsa:1:{i:0;s:36:"1b7a3c81-e7db-234c-9b67-68f84d133171";}^simp499clkronolithfb_calsa:1:{i:0;s:45:"internal_ddce6dd2-2107-3976-92e1-f7e8f0cc5d94";}]'simp499clkronolithsearch_fields{"cf90278b-6d95-cc3c-ac31-1447fcc8c4ae":["name","email"]}M)]simp499clkronolithsearch_sources["cf90278b-6d95-cc3c-ac31-1447fcc8c4ae"]J1Usimp499clcpanelshared_addressbookcf90278b-6d95-cc3c-ac31-1447fcc8c4ae.?simp499clcpanelglobal_addressbook_shared1b!simp499clhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:32:"simp499cl@web019.anacondaweb.com";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}Y%ysimp499clkronolithdisplay_calsa:1:{i:0;s:36:"ddce6dd2-2107-3976-92e1-f7e8f0cc5d
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