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 t�1 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 )�MM�tablehorde_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 � �_�3��Y ,++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&���� 1kronolith_sharesng-kronolith_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$ 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 ) B�2�K*�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_signups0�K*//�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 ) ��� � ��V+77�Ktablehorde_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 qX�E m �1099 32�d/99�ctablehorde_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- 65�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�i3##�tablehorde_lockshorde_locks<CREATE TABLE "horde_locks" ( "lock_id" varchar(36) NOT NULL, "lock_owner" varchar(255), "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 )�e4##�tablehorde_permshorde_perms>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 ) ��� :9�Q6//�Qtablehorde_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 )�@755�#tablehorde_sessionhandlerhorde_sessionhandlerBCREATE TABLE "horde_sessionhandler" ( "session_id" varchar(32) NOT NULL, "session_lastmodified" int NOT NULL, "session_data" blob )�#8--�ytablehorde_syncml_maphorde_syncml_mapCCREATE TABLE "horde_syncml_map" ( "syncml_syncpartner" varchar(255) NOT NULL, "syncml_db" varchar(255) NOT NULL, "syncml_uid" varchar(255) NOT NULL, "syncml_cuid" varchar(255), "syncml_suid" varchar(255), "syncml_timestamp" int )�$955�ktablehorde_syncml_anchorshorde_syncml_anchorsDCREATE TABLE "horde_syncml_anchors" ( "syncml_syncpartner" varchar(255) NOT NULL, "syncml_db" varchar(255) NOT NULL, "syncml_uid" varchar(255) NOT NULL, "syncml_clientanchor" varchar(255), "syncml_serveranchor" varchar(255) ) D D*c� @ >=�c:%%� tablehorde_tokenshorde_tokensECREATE TABLE "horde_tokens" ( "token_address" varchar(100) NOT NULL, "token_id" varchar(32) NOT NULL, "token_timestamp" bigint NOT NULL, PRIMARY KEY("token_address", "token_id") )7;K% indexsqlite_autoindex_horde_tokens_1horde_tokensF�:<�Ctablehorde_vfshorde_vfsHCREATE TABLE "horde_vfs" ( "vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "vfs_type" int NOT NULL, "vfs_path" varchar(255) NOT NULL, "vfs_name" varchar(255) NOT NULL, "vfs_modified" int NOT NULL, "vfs_owner" varchar(255) NOT NULL, "vfs_data" blob )�]=##�tablehorde_muvfshorde_muvfsICREATE TABLE "horde_muvfs" ( "vfs_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "vfs_type" int NOT NULL, "vfs_path" varchar(255) NOT NULL, "vfs_name" varchar(255) NOT NULL, "vfs_modified" int NOT NULL, "vfs_owner" varchar(255) NOT NULL, "vfs_perms" int NOT NULL, "vfs_data" blob ) �G � � ;BO) indexsqlite_autoindex_ingo_vacations_1ingo_vacationsO �}>%%�=tableimp_sentmailimp_sentmailJCREATE TABLE "imp_sentmail" ( "sentmail_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "sentmail_who" varchar(255) NOT NULL, "sentmail_ts" int NOT NULL, "sentmail_messageid" varchar(255) NOT NULL, "sentmail_action" varchar(32) NOT NULL, "sentmail_recipient" varchar(255) NOT NULL, "sentmail_success" int NOT NULL )�/?!!�)tableingo_listsingo_listsLCREATE TABLE "ingo_lists" ( "list_owner" varchar(255) NOT NULL, "list_blacklist" int DEFAULT 0, "list_address" varchar(255) NOT NULL )�6@''�+tableingo_forwardsingo_forwardsMCREATE TABLE "ingo_forwards" ( "forward_owner" varchar(255) NOT NULL, "forward_addresses" text, "forward_keep" int NOT NULL DEFAULT 0 ) _ _�)�2 �bE� A))�Otableingo_vacationsingo_vacationsNCREATE 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") );BO) indexsqlite_autoindex_ingo_vacations_1ingo_vacationsO�<C�Gtableingo_spamingo_spamQCREATE TABLE "ingo_spam" ( "spam_owner" varchar(255) NOT NULL, "spam_level" int DEFAULT 5, "spam_folder" varchar(255), PRIMARY KEY("spam_owner") )1DE indexsqlite_autoindex_ingo_spam_1ingo_spamR�bE11�otableingo_shares_groupsingo_shares_groupsSCREATE 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 ) h hI P L HG�4G!!�3tableingo_rulesingo_rulesVCREATE TABLE "ingo_rules" ( "rule_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "rule_owner" varchar(255) NOT NULL, "rule_name" varchar(255) NOT NULL, "rule_action" int NOT NULL, "rule_value" varchar(255), "rule_flag�^F//�ktableingo_shares_usersingo_shares_usersTCREATE TABLE "ingo_shares_users" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm" int NOT NULL )�4G!!�3tableingo_rulesingo_rulesVCREATE TABLE "ingo_rules" ( "rule_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "rule_owner" varchar(255) NOT NULL, "rule_name" varchar(255) NOT NULL, "rule_action" int NOT NULL, "rule_value" varchar(255), "rule_flags" int, "rule_conditions" text, "rule_combine" int, "rule_stop" int, "rule_active" int NOT NULL DEFAULT 1, "rule_order" int NOT NULL DEFAULT 0 ) $ $ IH�YH##�ytableingo_sharesingo_sharesWCREATE TABLE "ingo_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL, "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0, "perm_guest" int NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255) , "share_parents" text) q q m JI�I''�Wtableingo_sharesngingo_sharesngYCREATE TABLE "ingo_sharesng" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int NOT NULL DEFAULT 0, "perm_creator_2" boolean NOT NULL DEFAULT 0, "perm_creator_4" boolean NOT NULL DEFAULT 0, "perm_creator_8" boolean NOT NULL DEFAULT 0, "perm_creator_16" boolean NOT NULL DEFAULT 0, "perm_default_2" boolean NOT NULL DEFAULT 0, "perm_default_4" boolean NOT NULL DEFAULT 0, "perm_default_8" boolean NOT NULL DEFAULT 0, "perm_default_16" boolean NOT NULL DEFAULT 0, "perm_guest_2" boolean NOT NULL DEFAULT 0, "perm_guest_4" boolean NOT NULL DEFAULT 0, "perm_guest_8" boolean NOT NULL DEFAULT 0, "perm_guest_16" boolean NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255) , "share_parents" text) � �� � ML�=J55�tableingo_sharesng_groupsingo_sharesng_groups[CREATE TABLE "ingo_sharesng_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�9K33�tableingo_sharesng_usersingo_sharesng_users]CREATE TABLE "ingo_sharesng_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�kL//�tablekronolith_storagekronolith_storage^CREATE TABLE "kronolith_storage" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "vfb_owner" varchar(255), "vfb_email" varchar(255) NOT NULL, "vfb_serialized" text NOT NULL ) � �zj 9 9 GQ[5 indexsqlite_autoindex_kronolith_events_geo_1kronolith_events_geod �qM;;�ytablekronolith_shares_groupskronolith_shares_groups_CREATE TABLE "kronolith_shares_groups" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm" int NOT NULL )�mN99�utablekronolith_shares_userskronolith_shares_usersaCREATE TABLE "kronolith_shares_users" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm" int NOT NULL )�O33�Mtablekronolith_resourceskronolith_resourcesbCREATE TABLE "kronolith_resources" ( "resource_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "resource_name" varchar(255), "resource_calendar" varchar(255), "resource_description" text, "resource_response_type" int DEFAULT 0, "resource_type" varchar(255) NOT NULL, "resource_members" text , "resource_email" varchar(255)) � ��� TS�hS11�{tablekronolith_sharesngkronolith_sharesnggCREATE TABLE "kronolith_sharesng" ( "share_id" INTEGER PR h� P55�5tablekronolith_events_geokronolith_events_geocCREATE TABLE "kronolith_events_geo" ( "event_id" varchar(32) NOT NULL, "event_lat" varchar(32) NOT NULL, "event_lon" varchar(32) NOT NULL, "event_zoom" int NOT NULL DEFAULT 0, PRIMARY KEY("event_id") )GQ[5 indexsqlite_autoindex_kronolith_events_geo_1kronolith_events_geod�R--�]tablekronolith_shareskronolith_sharesfCREATE TABLE "kronolith_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL, "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0, "perm_guest" int NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_color" varchar(7), "share_parents" varchar(4000) ) IMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int NOT NULL DEFAULT 0, "perm_creator_2" boolean NOT NULL DEFAULT 0, "perm_creator_4" boolean NOT NULL DEFAULT 0, "perm_creator_8" boolean NOT NULL DEFAULT 0, "perm_creator_16" boolean NOT NULL DEFAULT 0, "perm_creator_1024" boolean NOT NULL DEFAULT 0, "perm_default_2" boolean NOT NULL DEFAULT 0, "perm_default_4" boolean NOT NULL DEFAULT 0, "perm_default_8" boolean NOT NULL DEFAULT 0, "perm_default_16" boolean NOT NULL DEFAULT 0, "perm_default_1024" boolean NOT NULL DEFAULT 0, "perm_guest_2" boolean NOT NULL DEFAULT 0, "perm_guest_4" boolean NOT NULL DEFAULT 0, "perm_guest_8" boolean NOT NULL DEFAULT 0, "perm_guest_16" boolean NOT NULL DEFAULT 0, "perm_guest_1024" boolean NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_color" varchar(7), "share_parents" varchar(4000) ) � �� � VU�hS11�{tablekronolith_sharesngkronolith_sharesnggCREATE TABLE "kronolith_sharesng" ( "share_id" INTEGER PR h�wT??�}tablekronolith_sharesng_groupskronolith_sharesng_groupsiCREATE TABLE "kronolith_sharesng_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0, "perm_1024" boolean NOT NULL DEFAULT 0 )�sU==�ytablekronolith_sharesng_userskronolith_sharesng_userskCREATE TABLE "kronolith_sharesng_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0, "perm_1024" boolean NOT NULL DEFAULT 0 ) ) ) % WV�TV--�[tablekronolith_eventskronolith_eventslCREATE TABLE "kronolith_events" ( "event_id" varchar(32) NOT NULL, "event_uid" varchar(255) NOT NULL, "calendar_id" varchar(255) NOT NULL, "event_creator_id" varchar(255) NOT NULL, "event_description" text, "event_location" text, "event_status" int DEFAULT 0, "event_attendees" text, "event_keywords" text, "event_exceptions" text, "event_title" varchar(255), "event_recurtype" int DEFAULT 0, "event_recurinterval" int, "event_recurdays" int, "event_recurenddate" datetime, "event_recurcount" int, "event_start" datetime, "event_end" datetime, "event_alarm" int DEFAULT 0, "event_modified" int DEFAULT 0, "event_private" int NOT NULL DEFAULT 0, "event_allday" int DEFAULT 0, "event_alarm_methods" text, "event_url" text, "event_baseid" varchar(255) DEFAULT '', "event_exceptionoriginaldate" datetime, "event_resources" text , "event_timezone" varchar(50)) � ��4 � [Z�[W##�}tablemnemo_memosmnemo_memosnCREATE TABLE "mnemo_memos" ( "memo_owner" varchar(255) NOT NULL, "memo_id" varchar(32) NOT NULL, "memo_uid" varchar(255) NOT NULL, "memo_desc" varchar(64) NOT NULL, "memo_body" text, "memo_category" varchar(80), "memo_private" int NOT NULL DEFAULT 0, PRIMARY KEY("memo_owner", "memo_id") )5XI# indexsqlite_autoindex_mnemo_memos_1mnemo_memoso�eY33�qtablemnemo_shares_groupsmnemo_shares_groupsqCREATE TABLE "mnemo_shares_groups" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm" int NOT NULL )�aZ11�mtablemnemo_shares_usersmnemo_shares_usersrCREATE TABLE "mnemo_shares_users" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm" int NOT NULL ) ! ! \[�\[%%�{tablemnemo_sharesmnemo_sharessCREATE TABLE "mnemo_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL, "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0, "perm_guest" int NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255) , "share_parents" text) n n j ]\�\))�Ytablemnemo_sharesngmnemo_sharesnguCREATE TABLE "mnemo_sharesng" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int NOT NULL DEFAULT 0, "perm_creator_2" boolean NOT NULL DEFAULT 0, "perm_creator_4" boolean NOT NULL DEFAULT 0, "perm_creator_8" boolean NOT NULL DEFAULT 0, "perm_creator_16" boolean NOT NULL DEFAULT 0, "perm_default_2" boolean NOT NULL DEFAULT 0, "perm_default_4" boolean NOT NULL DEFAULT 0, "perm_default_8" boolean NOT NULL DEFAULT 0, "perm_default_16" boolean NOT NULL DEFAULT 0, "perm_guest_2" boolean NOT NULL DEFAULT 0, "perm_guest_4" boolean NOT NULL DEFAULT 0, "perm_guest_8" boolean NOT NULL DEFAULT 0, "perm_guest_16" boolean NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255) , "share_parents" text) c�S a`�@]77�tablemnemo_sharesng_groupsmnemo_sharesng_groupswCREATE TABLE "mnemo_sharesng_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�<^55�tablemnemo_sharesng_usersmnemo_sharesng_usersyCREATE TABLE "mnemo_sharesng_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�._//�tablenag_shares_groupsnag_shares_groupszCREATE TABLE "nag_shares_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm" int(2) NOT NULL )�*`--�tablenag_shares_usersnag_shares_users{CREATE TABLE "nag_shares_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm" int(2) NOT NULL ) Y Y�� dc�6a!!�7tablenag_sharesnag_shares|CREATE TABLE "nag_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int(2) NOT NULL DEFAULT 0, "perm_creator" int(2) NOT NULL DEFAULT 0, "perm_default" int(2) NOT �6a!!�7tablenag_sharesnag_shares|CREATE TABLE "nag_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int(2) NOT NULL DEFAULT 0, "perm_creator" int(2) NOT NULL DEFAULT 0, "perm_default" int(2) NOT NULL DEFAULT 0, "perm_guest" int(2) NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_color" varchar(7) , "share_parents" text, "attribute_issmart" int DEFAULT 0, "attribute_search" text)�fb%%�tablenag_sharesngnag_sharesng~CREATE TABLE "nag_sharesng" ( "share_id" INTEGER PRIMARY KEY AUT OINCREMENT NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int NOT NULL DEFAULT 0, "perm_creator_2" boolean NOT NULL DEFAULT 0, "perm_creator_4" boolean NOT NULL DEFAULT 0, "perm_creator_8" boolean NOT NULL DEFAULT 0, "perm_creator_16" boolean NOT NULL DEFAULT 0, "perm_default_2" boolean NOT NULL DEFAULT 0, "perm_default_4" boolean NOT NULL DEFAULT 0, "perm_default_8" boolean NOT NULL DEFAULT 0, "perm_default_16" boolean NOT NULL DEFAULT 0, "perm_guest_2" boolean NOT NULL DEFAULT 0, "perm_guest_4" boolean NOT NULL DEFAULT 0, "perm_guest_8" boolean NOT NULL DEFAULT 0, "perm_guest_16" boolean NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_color" varchar(7) , "share_parents" text, "attribute_issmart" int DEFAULT 0, "attribute_search" text) � ��� ed�;c33�tablenag_sharesng_groupsnag_sharesng_groups �CREATE TABLE "nag_sharesng_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�7d11�tablenag_sharesng_usersnag_sharesng_users �CREATE TABLE "nag_sharesng_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 ) � � � fe�Ee�Wtablenag_tasksnag_tasks �CREATE TABLE "nag_tasks" ( "task_id" varchar(32) NOT NULL, "task_owner" varchar(255) NOT NULL, "task_creator" varchar(255) NOT NULL, "task_parent" varchar(255), "task_assignee" varchar(255), "task_name" varchar(255) NOT NULL, "task_uid" varchar(255) NOT NULL, "task_desc" text, "task_start" int, "task_due" int, "task_priority" int NOT NULL DEFAULT 0, "task_estimate" float, "task_completed" int(1) NOT NULL DEFAULT 0, "task_completed_date" int, "task_alarm" int NOT NULL DEFAULT 0, "task_alarm_methods" text, "task_private" int(1) NOT NULL DEFAULT 0, "task_recurtype" int DEFAULT 0, "task_recurinterval" int, "task_recurdays" int, "task_recurenddate" datetime, "task_recurcount" int, "task_exceptions" text, "task_completions" text ) � �2 � ih�f++�itabletrean_bookmarkstrean_bookmarks �CREATE TABLE "trean_bookmarks" ( "bookmark_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "bookmark_url" varchar(1024) NOT NULL, "bookmark_title" varchar(255), "bookmark_description" varchar(1024), "bookmark_clicks" int DEFAULT 0, "bookmark_http_status" varchar(5), "bookmark_dt" datetime, "user_id" int , "favicon_url" varchar(255))�fg33�qtableturba_shares_groupsturba_shares_groups �CREATE TABLE "turba_shares_groups" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm" int NOT NULL )�bh11�mtableturba_shares_usersturba_shares_users �CREATE TABLE "turba_shares_users" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm" int NOT NULL ) ji�yi%%�3tableturba_sharesturba_shares �CREATE TABLE "turba_shares" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255) NOT NULL, "share_flags" int NOT NULL DEFAULT 0, "perm_creator" int NOT NULL DEFAULT 0, "perm_default" int NOT NULL DEFAULT 0, "perm_guest" int NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_params" text , "share_parents" text) Q Q M kj�,j))�tableturba_sharesngturba_sharesng �CREATE TABLE "turba_sharesng" ( "share_id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "share_name" varchar(255) NOT NULL, "share_owner" varchar(255), "share_flags" int NOT NULL DEFAULT 0, "perm_creator_2" boolean NOT NULL DEFAULT 0, "perm_creator_4" boolean NOT NULL DEFAULT 0, "perm_creator_8" boolean NOT NULL DEFAULT 0, "perm_creator_16" boolean NOT NULL DEFAULT 0, "perm_default_2" boolean NOT NULL DEFAULT 0, "perm_default_4" boolean NOT NULL DEFAULT 0, "perm_default_8" boolean NOT NULL DEFAULT 0, "perm_default_16" boolean NOT NULL DEFAULT 0, "perm_guest_2" boolean NOT NULL DEFAULT 0, "perm_guest_4" boolean NOT NULL DEFAULT 0, "perm_guest_8" boolean NOT NULL DEFAULT 0, "perm_guest_16" boolean NOT NULL DEFAULT 0, "attribute_name" varchar(255) NOT NULL, "attribute_desc" varchar(255), "attribute_params" text , "share_parents" text) | |�x ml�Ak77�tableturba_sharesng_groupsturba_sharesng_groups �CREATE TABLE "turba_sharesng_groups" ( "share_id" int NOT NULL, "group_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 )�=l55�tableturba_sharesng_usersturba_sharesng_users �CREATE TABLE "turba_sharesng_users" ( "share_id" int NOT NULL, "user_uid" varchar(255) NOT NULL, "perm_2" boolean NOT NULL DEFAULT 0, "perm_4" boolean NOT NULL DEFAULT 0, "perm_8" boolean NOT NULL DEFAULT 0, "perm_16" boolean NOT NULL DEFAULT 0 ) �ototype" varchar(10), "object_bday" varchar(10), "object_homestreet" varchar(255), "object_homepob" varchar(10), "object_homecity" varchar(255), "object_homeprovince" varchar(255), "object_homepostalcode" varchar(10), "object_homecountry" varchar(255), "object_workstreet" varchar(255), "object_workpob" varchar(10), "object_workcity" varchar(255), "object_workprovince" varchar(255), "object_workpostalcode" varchar(10), "object_workcountry" varchar(255), "object_tz" varchar(32), "object_geo" varchar(255), "object_email" varchar(255), "object_homephone" varchar(25), "object_workphone" varchar(25), "object_cellphone" varchar(25), "object_fax" varchar(25), "object_pager" varchar(25), "object_title" varchar(255), "object_role" varchar(255), "object_logo" blob, "object_logotype" varchar(10), "object_company" varchar(255), "object_category" varchar(80), "object_notes" text, "object_url" varchar(255), "object_freebusyurl" var char(255), "object_pgppublickey" text, "object_smimepublickey" text, "object_anniversary" varchar(10), "object_department" varchar(255), "object_spouse" varchar(255), "object_homefax" varchar(25), "object_nickname" varchar(255), "object_assistantphone" varchar(25), "object_imaddress" varchar(255), "object_imaddress2" varchar(255), "object_imaddress3" varchar(255), "object_homephone2" varchar(25), "object_carphone" varchar(25), "object_workphone2" varchar(25), "object_radiophone" varchar(25), "object_companyphone" varchar(25), "object_otherstreet" varchar(255), "object_otherpob" varchar(10), "object_othercity" varchar(255), "object_otherprovince" varchar(255), "object_otherpostalcode" varchar(10), "object_othercountry" varchar(255), "object_yomifirstname" varchar(255), "object_yomilastname" varchar(255), "object_manager" varchar(255) , "object_assistant" varchar(255), "object_workemail" varchar(255), "object_homeemail" varchar(255)) � ��� �rm''�!tableturba_objectsturba_objects �CREATE TABLE "turba_objects" ( "object_id" varchar(32) NOT NULL, "owner_id" varchar(255) NOT NULL, "object_type" varchar(255) NOT NULL DEFAULT 'Object', "object_uid" varchar(255), "object_members" text, "object_firstname" varchar(255), "object_lastname" varchar(255), "object_middlenames" varchar(255), "object_nameprefix" varchar(32), "object_namesuffix" varchar(32), "object_alias" varchar(32), "object_photo" blob, "object_ph �}n=)�indexrampage_tagged_object_idrampage_tagged �CREATE INDEX "rampage_tagged_object_id" ON "rampage_tagged" ("object_id")to7)�indexrampage_tagged_tag_idrampage_tagged �CREATE INDEX "rampage_tagged_tag_id" ON "rampage_tagged" ("tag_id")wp9)�indexrampage_tagged_createdrampage_tagged �CREATE INDEX "rampage_tagged_created" ON "rampage_tagged" ("created") � �B�S�m O �uK%�)indexindex_horde_alarms_on_alarm_endhorde_alarms �CREATE INDEX "index_horde_alarms�qG9�3indexrampage_user_tag_stats_tag_idrampage_user_tag_stats �CREATE INDEX "rampage_user_tag_stats_tag_id" ON "rampage_user_tag_stats" ("tag_id")�rI%�%indexindex_horde_alarms_on_alarm_idhorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_id" ON "horde_alarms" ("alarm_id")�sK%�)indexindex_horde_alarms_on_alarm_uidhorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_uid" ON "horde_alarms" ("alarm_uid")� tO%�1indexindex_horde_alarms_on_alarm_starthorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_start" ON "horde_alarms" ("alarm_start")�uK%�)indexindex_horde_alarms_on_alarm_endhorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_end" ON "horde_alarms" ("alarm_end")�vQ%�5indexindex_horde_alarms_on_alarm_snoozehorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_snooze" ON "horde_alarms" ("alarm_snooze") � �A��V 2 �1za7�Uindexindex_horde_dav_collections_on_id_internalhorde_dav_collections �CREATE INDEX "index_horde_dav_colle�wW%�Aindexindex_horde_alarms_on_alarm_dismissedhorde_alarms �CREATE INDEX "index_horde_alarms_on_alarm_dismissed" ON "horde_alarms" ("alarm_dismissed")�'x]/�Mindexindex_horde_dav_objects_on_id_collectionhorde_dav_objects �CREATE INDEX "index_horde_dav_objects_on_id_collection" ON "horde_dav_objects" ("id_collection")�4yc7�Yindexindex_horde_dav_collections_on_id_interfacehorde_dav_collections �CREATE INDEX "index_horde_dav_collections_on_id_interface" ON "horde_dav_collections" ("id_interface")�1za7�Uindexindex_horde_dav_collections_on_id_internalhorde_dav_collections �CREATE INDEX "index_horde_dav_collections_on_id_internal" ON "horde_dav_collections" ("id_internal")�'{[5�Iindexindex_horde_groups_members_on_group_uidhorde_groups_members �CREATE INDEX "index_horde_groups_members_on_group_uid" ON "horde_groups_members" ("group_uid") � ��(�f 2 �� S+�9indexindex_horde_histories_on_object_uidhorde_histories �CREATE INDEX "index_horde_histories_on_object_uid" ON "horde_histories" ("object_uid")�"[+�Iindexi�$|Y5�Eindexindex_horde_groups_members_on_user_uidhorde_groups_members �CREATE INDEX "index_horde_groups_members_on_user_uid" ON "horde_groups_members" ("user_uid")�"}[+�Iindexindex_horde_histories_on_history_actionhorde_histories �CREATE INDEX "index_horde_histories_on_history_action" ON "horde_histories" ("history_action")�~S+�9indexindex_horde_histories_on_history_tshorde_histories �CREATE INDEX "index_horde_histories_on_history_ts" ON "horde_histories" ("history_ts")�"[+�Iindexindex_horde_histories_on_history_modseqhorde_histories �CREATE INDEX "index_horde_histories_on_history_modseq" ON "horde_histories" ("history_modseq")�� S+�9indexindex_horde_histories_on_object_uidhorde_histories �CREATE INDEX "index_horde_histories_on_object_uid" ON "horde_histories" ("object_uid") ` `tA�v � �G#�!index���!9�Oindexindex_horde_imap_client_data_on_hostspec_and_mailbox_and_port_and_usernamehorde_imap_client_data �CREATE INDEX "index_horde_imap_client_data_on_hostspec_and_mailbox_and_port_and_username" ON "horde_imap_client_data" ("hostspec", "mailbox", "port", "username")�I�o?�oindexindex_horde_imap_client_message_on_msguid_and_uidhorde_imap_client_message �CREATE INDEX "index_horde_imap_client_message_on_msguid_and_uid" ON "horde_imap_client_message" ("msguid", "uid")�-�[A�Iindexindex_horde_imap_client_metadata_on_uidhorde_imap_client_metadata �CREATE INDEX "index_horde_imap_client_metadata_on_uid" ON "horde_imap_client_metadata" ("uid")� �G#�!indexindex_horde_prefs_on_pref_uidhorde_prefs �CREATE INDEX "index_horde_prefs_on_pref_uid" ON "horde_prefs" ("pref_uid")��K#�)indexindex_horde_prefs_on_pref_scopehorde_prefs �CREATE INDEX "index_horde_prefs_on_pref_scope" ON "horde_prefs" ("pref_scope") � �p&�_ 7 �� U-�=indexindex_horde_syncml_map_on_syncml_uidhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on�H�q5�uindexindex_horde_sessionhandler_on_session_lastmodifiedhorde_sessionhandler �CREATE INDEX "index_horde_sessionhandler_on_session_lastmodified" ON "horde_sessionhandler" ("session_lastmodified")�2�e-�]indexindex_horde_syncml_map_on_syncml_syncpartnerhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on_syncml_syncpartner" ON "horde_syncml_map" ("syncml_syncpartner")��S-�9indexindex_horde_syncml_map_on_syncml_dbhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on_syncml_db" ON "horde_syncml_map" ("syncml_db")�� U-�=indexindex_horde_syncml_map_on_syncml_uidhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on_syncml_uid" ON "horde_syncml_map" ("syncml_uid")�� W-�Aindexindex_horde_syncml_map_on_syncml_cuidhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on_syncml_cuid" ON "horde_syncml_map" ("syncml_cuid") J J ��\ � ��W-�Aindexindex_horde_syncml_map_on_syncml_suidhorde_syncml_map �CREATE INDEX "index_horde_syncml_map_on_syncml_suid" ON "horde_syncml_map" ("syncml_suid")�B�m5�mindexindex_horde_syncml_anchors_on_syncml_syncpartnerhorde_syncml_anchors �CREATE INDEX "index_horde_syncml_anchors_on_syncml_syncpartner" ON "horde_syncml_anchors" ("syncml_syncpartner")�'� [5�Iindexindex_horde_syncml_anchors_on_syncml_dbhorde_syncml_anchors �CREATE INDEX "index_horde_syncml_anchors_on_syncml_db" ON "horde_syncml_anchors" ("syncml_db")�*�]5�Mindexindex_horde_syncml_anchors_on_syncml_uidhorde_syncml_anchors �CREATE INDEX "index_horde_syncml_anchors_on_syncml_uid" ON "horde_syncml_anchors" ("syncml_uid")x�C�indexindex_horde_vfs_on_vfs_pathhorde_vfs �CREATE INDEX "index_horde_vfs_on_vfs_path" ON "horde_vfs" ("vfs_path")x�C�indexindex_horde_vfs_on_vfs_namehorde_vfs �CREATE INDEX "index_horde_vfs_on_vfs_name" ON "horde_vfs" ("vfs_name") u u �}�B = ��Y%�Eindexindex_imp_sentmail_on_sentmail_successim� �G#�!indexindex_horde_muvfs_on_vfs_pathhorde_muvfs �CREATE INDEX "index_horde_muvfs_on_vfs_path" ON "horde_muvfs" ("vfs_path")� �G#�!indexindex_horde_muvfs_on_vfs_namehorde_muvfs �CREATE INDEX "index_horde_muvfs_on_vfs_name" ON "horde_muvfs" ("vfs_name")� �O%�1indexindex_imp_sentmail_on_sentmail_tsimp_sentmail �CREATE INDEX "index_imp_sentmail_on_sentmail_ts" ON "imp_sentmail" ("sentmail_ts")��Q%�5indexindex_imp_sentmail_on_sentmail_whoimp_sentmail �CREATE INDEX "index_imp_sentmail_on_sentmail_who" ON "imp_sentmail" ("sentmail_who")��Y%�Eindexindex_imp_sentmail_on_sentmail_successimp_sentmail �CREATE INDEX "index_imp_sentmail_on_sentmail_success" ON "imp_sentmail" ("sentmail_success")�:�o!�oindexindex_ingo_lists_on_list_owner_and_list_blacklistingo_lists �CREATE INDEX "index_ingo_lists_on_list_owner_and_list_blacklist" ON "ingo_lists" ("list_owner", "list_blacklist") a a�8�p ��S/�9indexindex_ingo_shares_users_on_share_i��U1�=indexindex_ingo_shares_groups_on_share_idingo_shares_groups �CREATE INDEX "index_ingo_shares_groups_on_share_id" ON "ingo_shares_groups" ("share_id")��W1�Aindexindex_ingo_shares_groups_on_group_uidingo_shares_groups �CREATE INDEX "index_ingo_shares_groups_on_group_uid" ON "ingo_shares_groups" ("group_uid")��M1�-indexindex_ingo_shares_groups_on_permingo_shares_groups �CREATE INDEX "index_ingo_shares_groups_on_perm" ON "ingo_shares_groups" ("perm")��S/�9indexindex_ingo_shares_users_on_share_idingo_shares_users �CREATE INDEX "index_ingo_shares_users_on_share_id" ON "ingo_shares_users" ("share_id")��S/�9indexindex_ingo_shares_users_on_user_uidingo_shares_users �CREATE INDEX "index_ingo_shares_users_on_user_uid" ON "ingo_shares_users" ("user_uid")��K/�)indexindex_ingo_shares_users_on_permingo_shares_users �CREATE INDEX "index_ingo_shares_users_on_perm" ON "ingo_shares_users" ("perm") '