芝麻web文件管理V1.00
编辑当前文件:/home4/randall/.cphorde/horde.sqlite.from1454125096
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_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�