/home/altere25/.cphorde/meta
Edit: /home/altere25/.cphorde/meta/horde.backup.sql.20180928 (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 / rbP8%AnW}/ ' rampage_users
-kronolith_shares%turba_shares
! nag_shares)turba_sharesng% mnemo_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 879f3d82-61f9-61eb-9290-ccd9899ab553( U a8bd4f48-4ab4-6eb5-6afb-54189199ac65
;ryan@altereddigital.com
B B ]Ugcalendar879f3d82-61f9-61eb-9290-ccd9899ab553calendar:879f3d82-61f9-61eb-9290-ccd9899ab553]Ugcalendara8bd4f48-4ab4-6eb5-6afb-54189199ac65calendar:a8bd4f48-4ab4-6eb5-6afb-54189199ac65
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
)
: E
:
+ B4: S;;Gryan@altereddigital.comimpimage_replacement_addrs["cpanel@altereddigital.com"]Z;-_ryan@altereddigital.commnemodisplay_notepadsa:1:{i:0;s:23:"0A7x94uTJ9NS4EYP9BpTgeZ";}G;+;ryan@altereddigital.commnemodefault_notepad0A7x94uTJ9NS4EYP9BpTgeZY;/_ryan@altereddigital.comnagdisplay_tasklistsa:1:{i:0;s:23:"XJashwvDhKH_QszmLzzCiTp";}F;-;ryan@altereddigital.comnagdefault_tasklistXJashwvDhKH_QszmLzzCiTpi;7kryan@altereddigital.comkronolithdisplay_external_calsa:1:{i:0;s:29:"tasks/XJashwvDhKH_QszmLzzCiTp";}f;+yryan@altereddigital.comhordelast_logintasksa:2:{s:5:"horde";i:1538151322;s:3:"imp";i:1538151322;};!3ryan@altereddigital.comhordelast_logina:2:{s:4:"host";s:34:"S010600fc8df10b23.cg.shawcable.net";s:4:"time";i:1538151322;}
;'1ryan@altereddigital.comhordeupgrade_tasksa:3:{s:5:"horde";s:6:"5.2.10";s:3:"imp";s:6:"6.2.14";s:8:"imp_auth";s:6:"6.2.14";}l;ryan@altereddigital.comkronolithfb_calsa:1:{i:0;s:45:"internal_879f3d82-61f9-61eb-9290-ccd9899ab553";}k;'ryan@altereddigital.comkronolithsearch_fields{"e29f6e95-3b9b-07e4-face-d293f123ae6b":["name","email"]}[
;)]ryan@altereddigital.comkronolithsearch_sources["e29f6e95-3b9b-07e4-face-d293f123ae6b"]g ;!ryan@altereddigital.comhordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:23:"ryan@altereddigital.com";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}g;%yryan@altereddigital.comkronolithdisplay_calsa:1:{i:0;s:36:"879f3d82-61f9-61eb-9290-ccd9899ab553";}]altere25kronolithfb_calsa:1:{i:0;s:45:"internal_a8bd4f48-4ab4-6eb5-6afb-54189199ac65";}\'altere25kronolithsearch_fields{"e29f6e95-3b9b-07e4-face-d293f123ae6b":["name","email"]}L)]altere25kronolithsearch_sources["e29f6e95-3b9b-07e4-face-d293f123ae6b"]I1Ualtere25cpanelshared_addressbooke29f6e95-3b9b-07e4-face-d293f123ae6b-?altere25cpanelglobal_addressbook_shared1d!altere25hordeidentitiesa:1:{i:0;a:6:{s:16:"default_identity";i:1;s:9:"from_addr";s:35:"altere25@ngx249.inmotionhosting.com";s:8:"fullname";s:0:"";s:2:"id";s:7:"default";s:10:"identities";s:6:"a:0:{}";s:10:"properties";N;}}X%yaltere25kronolithdisplay_calsa:1:{i:0;s:36:"a8bd4f48-4ab4-6eb5-6afb-54189199ac65";}
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