File: /home/rockyroadprintin/.cphorde/meta/latest
SQLite format 3   @       �          g                                                  .C�   �   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>