View file File name : horde.sqlite Content :SQLite format 3 @ � � g � ._ � z��������������������Bv � �T77�Gtablehorde_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 c�X K�F 2�0 � � �k ցV ��B ��+ �� v~ rk hg \_ SR GJ 3>