/home/ariannab/.cphorde/meta
Edit: /home/ariannab/.cphorde/meta/horde.backup.sql.20151022 (460800B)
SQLite format 3 @ d - MU ~ytoje`[VQKE?93-'! ysmga[Up_schema_infoCREATE TABLE "horde_group_schema_info" (
"version" int
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
)q99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
)u;;tablehorde_cache_schema k f a [ U O I C = {7 t1 m+ f% ^ W P J C < 5{ .u 'o !i d _ Z U P K E @ ; 5 ہ/ ԁ) ́# Ł
{ v p l j i h e d }b x` v\ t[ pZ mV jU eR `O \L ZI XH UG PE K@ G= A9 =5 82 3. -* '$
^ ^ ?) Z h33ytablecontent_schema_infocontent_schema_infoCREATE TABLE "content_schema_info" (
"version" int
)u;;tablehorde_alarm_schema_infohorde_alarm_schema_infoCREATE TABLE "horde_alarm_schema_info" (
"version" int
)q99tablehorde_auth_schema_infohorde_auth_schema_infoCREATE TABLE "horde_auth_schema_info" (
"version" int
)u;;tablehorde_cache_schema_infohorde_cache_schema_infoCREATE TABLE "horde_cache_schema_info" (
"version" int
)q99tablehorde_core_schema_infohorde_core_schema_infoCREATE TABLE "horde_core_schema_info" (
"version" int
)n77}tablehorde_dav_schema_infohorde_dav_schema_infoCREATE TABLE "horde_dav_schema_info" (
"version" int
)u;;tablehorde_group_schema_infohorde_group_schema_infoCREATE TABLE "horde_group_schema_info" (
"version" int
){??tablehorde_history_schema_infohorde_history_schema_info CREATE TABLE "horde_history_schema_info" (
"version" int
)
| 6 GG
tablehorde_imap_client_schema_infohorde_imap_client_schema_infoCREATE TABLE "horde_imap_client_schema_info" (
"version" int
)q
99tablehorde_lock_schema_infohorde_lock_schema_info
CREATE TABLE "horde_lock_schema_info" (
"version" int
)u;;tablehorde_perms_schema_infohorde_perms_schema_infoCREATE TABLE "horde_perms_schema_info" (
"version" int
)u;;tablehorde_prefs_schema_infohorde_prefs_schema_infoCREATE TABLE "horde_prefs_schema_info" (
"version" int
)u
;;tablehorde_queue_schema_infohorde_queue_schema_infoCREATE TABLE "horde_queue_schema_info" (
"version" int
)MMtablehorde_sessionhandler_schema_infohorde_sessionhandler_schema_infoCREATE TABLE "horde_sessionhandler_schema_info" (
"version" int
)x==tablehorde_syncml_schema_infohorde_syncml_schema_infoCREATE TABLE "horde_syncml_schema_info" (
"version" int
)u;;tablehorde_token_schema_infohorde_token_schema_infoCREATE TABLE "horde_token_schema_info" (
"version" int
)
0 0 _3Y ,++qtablenag_ n77}tablehorde_vfs_schema_infohorde_vfs_schema_infoCREATE TABLE "horde_vfs_schema_info" (
"version" int
)\++qtableimp_schema_infoimp_schema_infoCREATE TABLE "imp_schema_info" (
"version" int
)_--stableingo_schema_infoingo_schema_infoCREATE TABLE "ingo_schema_info" (
"version" int
)n77}tablekronolith_schema_infokronolith_schema_infoCREATE TABLE "kronolith_schema_info" (
"version" int
)b//utablemnemo_schema_infomnemo_schema_infoCREATE TABLE "mnemo_schema_info" (
"version" int
)\++qtablenag_schema_infonag_schema_infoCREATE TABLE "nag_schema_info" (
"version" int
)b//utabletrean_schema_infotrean_schema_infoCREATE TABLE "trean_schema_info" (
"version" int
)b//utableturba_schema_infoturba_schema_infoCREATE TABLE "turba_schema_info" (
"version" int
)$''tablerampage_typesrampage_typesCREATE TABLE "rampage_types" (
"type_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"type_name" varchar(255) NOT NULL
)
task event calendar
rbO7& -kronolith_shares1kronolith_sharesng%turba_shares+rampage_objects turba_shares+trean_bookmarks
!nag_shares%mnemo_shares3kronolith_resources
'rampage_types #ingo_shares
!ingo_rules%imp_sentmail#horde_muvfshorde_vfs#horde_perms9horde_histories_modseq+horde_histories% horde_groups
v v ; / / A!U/ indexsqlite_autoindex_rampage_tag_stats_1rampage_tag_stats&cP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)I++Itablerampage_objectsrampage_objects CREATE TABLE "rampage_objects" (
"object_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"object_name" varchar(255) NOT NULL,
"type_id" int NOT NULL
)$''tablerampage_usersrampage_users!CREATE TABLE "rampage_users" (
"user_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"user_name" varchar(255) NOT NULL
)%%tablerampage_tagsrampage_tags"CREATE TABLE "rampage_tags" (
"tag_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
"tag_name" varchar(255) NOT NULL
)c))tablerampage_taggedrampage_tagged#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")
);O) indexsqlite_autoindex_rampage_tagged_1rampage_tagged$
( U 3d939760-0ea3-7169-fcbe-8cf7d2e25232( U 5ebf65ce-ce68-ba68-798d-709bb45cb9e8
6 6 + 2 %$ //Ytablerampage_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&J"99/tablerampage_user_tag_statsrampage_user_tag_stats(CREATE 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)R$%%gtablehorde_alarmshorde_alarms*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
)
B2K*n%###tablehorde_usershorde_users+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")
)5&I# indexsqlite_autoindex_horde_users_1horde_users,@'##Gtablehorde_cachehorde_cache.CREATE TABLE "horde_cache" (
"cache_id" varchar(32) NOT NULL,
"cache_timestamp" int NOT NULL,
"cache_expiration" int NOT NULL,
"cache_data" blob
)o(''tablehorde_signupshorde_signups/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")
)9)M' indexsqlite_autoindex_horde_signups_1horde_signups0K*//Etablehorde_dav_objectshorde_dav_objects1CREATE TABLE "horde_dav_objects" (
"id_collection" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
)
B B ]Ugcalendar3d939760-0ea3-7169-fcbe-8cf7d2e25232calendar:3d939760-0ea3-7169-fcbe-8cf7d2e25232]Ugcalendar5ebf65ce-ce68-ba68-798d-709bb45cb9e8calendar:5ebf65ce-ce68-ba68-798d-709bb45cb9e8
V+77Ktablehorde_dav_collectionshorde_dav_collections2CREATE TABLE "horde_dav_collections" (
"id_interface" varchar(255) NOT NULL,
"id_internal" varchar(255) NOT NULL,
"id_external" varchar(255) NOT NULL
),55[tablehorde_groups_membershorde_groups_members4CREATE TABLE "horde_groups_members" (
"group_uid" int NOT NULL,
"user_uid" varchar(255) NOT NULL
)v-%%/tablehorde_groupshorde_groups5CREATE TABLE "horde_groups" (
"group_uid" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"group_name" varchar(255) NOT NULL,
"group_parents" varchar(255) NOT NULL,
"group_email" varchar(255)
)x.++'tablehorde_historieshorde_histories6CREATE 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)
q qXE m 1099 d/99ctablehorde_histories_modseqhorde_histories_modseq7CREATE TABLE "horde_histories_modseq" (
"history_modseq" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL DEFAULT 0,
"history_modseqempty" int NOT NULL DEFAULT 0
)1099}tablehorde_imap_client_datahorde_imap_client_data9CREATE TABLE "horde_imap_client_data" (
"uid" 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
)61??{tablehorde_imap_client_messagehorde_imap_client_message:CREATE TABLE "horde_imap_client_message" (
"data" blob,
"msguid" varchar(255) NOT NULL,
"uid" bigint NOT NULL
)82AA{tablehorde_imap_client_metadatahorde_imap_client_metadata;CREATE TABLE "horde_imap_client_metadata" (
"data" blob,
"field" varchar(255) NOT NULL,
"uid" bigint NOT NULL
)
E- P5##gtablehorde_prefshorde_prefs?CREATE TABLE "horde_prefs" (
"pref_uid" varchar(255) NOT NULL,
"pref_scope" varchar(16) NOT NULL DEFAULT '',
"pref_name" varchar(32) NOT NULLi3##tablehorde_lockshorde_locks
CREATE TABLE "horde_perms" (
"perm_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL,
"perm_name" varchar(255) NOT NULL,
"perm_parents" varchar(255) NOT NULL,
"perm_data" text
)P5##gtablehorde_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
)
<