SQLite format 3@ \\-âûû X É Q è d Œ ¥¢;Û~©<ÞÓWOì{%!T-sindexix_notes_on_typenotesCREATE INDEX "ix_notes_on_type" ON "notes" ("type")o-'indexix_notes_fk_typenotesCREATE INDEX "ix_notes_fk_type" ON "notes" ("owner_id", "owner_type", "type")a5indexix_notes_on_languagenotesCREATE INDEX "ix_notes_on_language" ON "notes" ("language")‚ƒitablenotesnotesCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "language" varchar(2), "value" varchar(4000), "type" varchar(50), "created_at" datetime, "updated_at" datetime, "owner_id" integer, "owner_type" varchar(255) NOT NULL)z9-indexix_note_annotations_fknote_annotationsCREATE INDEX "ix_note_annotations_fk" ON "note_annotations" ("note_id")‚--ƒCtablenote_annotationsnote_annotationsCREATE TABLE "note_annotations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note_id" integer, "predicate" varchar(50), "value" varchar(1024), "created_at" datetime, "updated_at" datetime, "namespace" varchar(50))\1{indexix_matches_on_typematchesCREATE INDEX "ix_matches_on_type" ON "matches" ("type")k1indexix_matches_fk_typematchesCREATE INDEX "ix_matches_fk_type" ON "matches" ("concept_id", "type")R‚{tablematchesmatchesCREATE TABLE "matches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "concept_id" integer, "type" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)[1{indexix_labels_on_valuelabelsCREATE INDEX "ix_labels_on_value" ON "labels" ("value")^3indexix_labels_on_originlabelsCREATE INDEX "ix_labels_on_origin" ON "labels" ("origin")e 7indexix_labels_on_languagelabelsCREATE INDEX "ix_labels_on_language" ON "labels" ("language")‚ ƒ[tablelabelslabels CREATE TABLE "labels" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "origin" varchar(4000), "language" varchar(255), "value" varchar(1024), "created_at" datetime, "updated_at" datetime, "published_at" date)e 5indexix_labelings_on_typelabelings CREATE INDEX "ix_labelings_on_type" ON "labelings" ("type")~ 55indexix_labelings_fk_typelabelings CREATE INDEX "ix_labelings_fk_type" ON "labelings" ("owner_id", "target_id", "type")U ‚ytablelabelingslabelings CREATE TABLE "labelings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "owner_id" integer, "target_id" integer, "created_at" datetime, "updated_at" datetime)C/indexix_concepts_publ_version_idconcepts CREATE INDEX "ix_concepts_publ_version_id" ON "concepts" ("published_version_id")g7indexix_concepts_on_originconceptsCREATE INDEX "ix_concepts_on_origin" ON "concepts" ("origin")‚u…=tableconceptsconceptsCREATE TABLE "concepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "origin" varchar(4000), "rev" integer DEFAULT 1, "published_at" date, "published_version_id" integer, "locked_by" integer, "expired_at" date, "follow_up" date, "to_review" boolean, "rdf_updated_at" date, "created_at" datetime, "updated_at" datetime) ;/;indexix_concept_relations_fkconcept_relationsCREATE INDEX "ix_concept_relations_fk" ON "concept_relations" ("owner_id", "target_id")m//ƒ tableconcept_relationsconcept_relationsCREATE TABLE "concept_relations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "owner_id" integer, "target_id" integer, "created_at" datetime, "updated_at" datetime)91Uindexix_collections_fk_typecollection_membersCREATE INDEX "ix_collections_fk_type" ON "collection_members" ("collection_id", "target_id", "type")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)G11‚9tablecollection_memberscollection_membersCREATE TABLE "collection_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "collection_id" integer, "target_id" integer, "type" varchar(  ”ôå×Àµª”-note_annotations notes users/concept_relations concepts labelings labels  Ñ7md[AAConcept::Relation::SKOS::Narrower::Base2011-09-15 09:57:01.5663612011-09-15 09:57:01.574948bYAAConcept::Relation::SKOS::Broader::Mono2011-09-15 09:57:01.5693632011-09-15 09:57:01.569363d[AAConcept::Relation::SKOS::Narrower::Base2011-09-15 09:57:15.6444582011-09-15 09:57:15.652676bYAAConcept::Relation::SKOS::Broader::Mono2011-09-15 09:57:15.6473932011-09-15 09:57:15.647393e[AAConcept::Relation::SKOS::Narrower::Base2011-09-15 09:57:15.6444582011-09-15 09:57:15.644458 òêãÛ …"©H_3AAConcept::SKOS::Base_000000232011-09-15 09:57:01.5730762011-09-15 09:57:01.573076y3AAAConcept::SKOS::Base_000000242011-09-12 09:56:59.0705032011-09-15 09:57:01.56158|3AAAConcept::a3AAConcept::SKOS::Base_000000252011-09-15 09:57:15.6510252011-09-15 09:57:28.313574y3AAAConcept::SKOS::Base_000000262011-09-12 09:56:59.0705032011-09-15 09:57:15.6402412011-09-15 09:57:15.640241 äòÈÖ _00000023 _00000024 _00000025 _00000026 ûõñì QùI¡V?AALabeling::SKOS::PrefLabel2011-09-15 09:57:01.5516452011-09-15 09:57:01.575932V?AALabeling::SKOS::PrefLabel2011-09-15 09:57:01.5573212011-09-15 09:57:01.563995V?AALabeling::SKOS::PrefLabel2011-09-15 09:57:28.6943902011-09-15 09:57:28.694390V?AALabeling::SKOS::PrefLabel2011-09-15 09:57:15.6352372011-09-15 09:57:15.642183W?AALabeling::SKOS::PrefLabel2011-09-15 09:57:15.6297682011-09-15 09:57:15.629768 ½›yW!?Labeling::SKOS::PrefLabel!?Labeling::SKOS::PrefLabel!?Labeling::SKOS::PrefLabel!?Labeling::SKOS::PrefLabel!?Labeling::SKOS::PrefLabel Ä⦈?Labeling::SKOS::PrefLabel?Labeling::SKOS::PrefLabel?Labeling::SKOS::PrefLabel?Labeling::SKOS::PrefLabel  Ž™ /9AAALabel::SKOS::BaseenSome narrower relation2011-09-15 09:57:01.5546542011-09-15 09:57:01.5546542011-09-13 09:56:59.073140p /AAALabel::SKOS::BaseenTree 22011-09-15 09:57:01.5488122011-09-15 09:57:01.5488122011-09-13 09:56:59.073140 /9AAALabel::SKOS::BaseenSome narrower relation2011-09-15 09:57:15.6328642011-09-15 09:57:15.6328642011-09-13 09:56:59.073140p /AAALabel::SKOS::BaseenTree 22011-09-15 09:57:28.6931812011-09-15 09:57:28.6931812011-09-15 09:57:28.689262 òùëäenenenen öûñì ÚõõÏ9Some narrower relation Tree 29Some narrower relation Tree 2    ®Ka?AAmodified2011-09-15T11:57:28+02:002011-09-15 09:57:28.3167332011-09-15 09:57:28.316733dctPAAcreatorTest User2011-09-15 09:57:28.3158922011-09-15 09:57:28.315892dct úô ›š E9AA'enconsectetur adipisicing elitNote::SKOS::Definition2011-09-15 09:57:28.6963812011-09-15 09:57:28.696381Concept::Base~ C9AA'enlorem ipsum dolor sit ametNote::SKOS::Definition2011-09-15 09:57:28.6953552011-09-15 09:57:28.695355Concept::Basec 9AA'deNote::SKOS::ChangeNote2011-09-15 09:57:28.3147402011-09-15 09:57:28.314740Concept::Base ùòëenende Õª*'9Concept::BaseNote::SKOS::Definition*'9Concept::BaseNote::SKOS::Definition*'9Concept::BaseNote::SKOS::ChangeNote åʯ9Note::SKOS::Definition9Note::SKOS::Definition9Note::SKOS::ChangeNote hƒ5‚ AA3‚ 5'TestUsertestuser@iqvoc.local0f2a384497e967bef3b3b0ca5e0ba6f6cc9a25ffcf8bdc84a9df8801a557fd3b331fcef45b6ae7b1d425e2c1531a483a37d54f73163da79d46bf7bccb7909e3et2011-09-15 09:57:17.8199712011-09-15 09:57:17.995067xdNKHKbUwxuwP9JDURh7d79cbf1bbbdd1591f3085542d3a59dada7045487653502a71e2c05b6a739895f6a518d843e947b668d6521c10e1010a80664fd7674b29a5cc84ad62287e24f11ssQ3LWRiB6cNfLEH0hZadministrator ¢¢l¾ Z J Ù Q º >–ý;Û~©<ÞÓWOì{%!T-sindexix_notes_on_typenotesCREATE INDEX "ix_notes_on_type" ON "notes" ("type")o-'indexix_notes_fk_typenotesCREATE INDEX "ix_notes_fk_type" ON "notes" ("owner_id", "owner_type", "type")a5indexix_notes_on_languagenotesCREATE INDEX "ix_notes_on_language" ON "notes" ("language")‚ƒitablenotesnotesCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "language" varchar(2), "value" varchar(4000), "type" varchar(50), "created_at" datetime, "updated_at" datetime, "owner_id" integer, "owner_type" varchar(255) NOT NULL)z9-indexix_note_annotations_fknote_annotationsCREATE INDEX "ix_note_annotations_fk" ON "note_annotations" ("note_id")‚--ƒCtablenote_annotationsnote_annotationsCREATE TABLE "note_annotations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note_id" integer, "predicate" varchar(50), "value" varchar(1024), "created_at" datetime, "updated_at" datetime, "namespace" varchar(50))\1{indexix_matches_on_typematchesCREATE INDEX "ix_matches_on_type" ON "matches" ("type")k1indexix_matches_fk_typematchesCREATE INDEX "ix_matches_fk_type" ON "matches" ("concept_id", "type")R‚{tablematchesmatchesCREATE TABLE "matches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "concept_id" integer, "type" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)[1{indexix_labels_on_valuelabelsCREATE INDEX "ix_labels_on_value" ON "labels" ("value")^3indexix_labels_on_originlabelsCREATE INDEX "ix_labels_on_origin" ON "labels" ("origin")e 7indexix_labels_on_languagelabelsCREATE INDEX "ix_labels_on_language" ON "labels" ("language")G11‚9tablecollection_memberscollection_membersCREATE TABLE "collection_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "collection_id" integer, "target_id" integer, "type" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)91Uindexix_collections_fk_typecollection_membersCREATE INDEX "ix_collections_fk_type" ON "collection_members" ("collection_id", "target_id", "type")m//ƒ tableconcept_relationsconcept_relationsCREATE TABLE "concept_relations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "owner_id" integer, "target_id" integer, "created_at" datetime, "updated_at" datetime) ;/;indexix_concept_relations_fkconcept_relationsCREATE INDEX "ix_concept_relations_fk" ON "concept_relations" ("owner_id", "target_id")‚u…=tableconceptsconceptsCREATE TABLE "concepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "origin" varchar(4000), "rev" integer DEFAULT 1, "published_at" date, "published_version_id" integer, "locked_by" integer, "expired_at" date, "follow_up" date, "to_review" boolean, "rdf_updated_at" date, "created_at" datetime, "updated_at" datetime)g7indexix_concepts_on_originconceptsCREATE INDEX "ix_concepts_on_origin" ON "concepts" ("origin")C/indexix_concepts_publ_version_idconcepts CREATE INDEX "ix_concepts_publ_version_id" ON "concepts" ("published_version_id")U ‚ytablelabelingslabelings CREATE TABLE "labelings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "owner_id" integer, "target_id" integer, "created_at" datetime, "updated_at" datetime)~ 55indexix_labelings_fk_typelabelings CREATE INDEX "ix_labelings_fk_type" ON "labelings" ("owner_id", "target_id", "type")e 5indexix_labelings_on_typelabelings CREATE INDEX "ix_labelings_on_type" ON "labelings" ("type")‚ ƒ[tablelabelslabels CREATE TABLE "labels" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "origin" varchar(4000), "language" varchar(255), "value" varchar(1024), "created_at" datetime, "updated_at" datetime, "published_at" date) çäK«  Ý J ¨ ³ / 7 š aqç=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)e 7indexix_labels_on_languagelabelsCREATE INDEX "ix_labels_on_language" ON "labels" ("language")^3indexix_labels_on_originlabelsCREATE INDEX "ix_labels_on_origin" ON "labels" ("origin")[1{indexix_labels_on_valuelabelsCREATE INDEX "ix_labels_on_value" ON "labels" ("value")R‚{tablematchesmatchesCREATE TABLE "matches" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "concept_id" integer, "type" varchar(255), "value" varchar(255), "created_at" datetime, "updated_at" datetime)k1indexix_matches_fk_typematchesCREATE INDEX "ix_matches_fk_type" ON "matches" ("concept_id", "type")\1{indexix_matches_on_typematchesCREATE INDEX "ix_matches_on_type" ON "matches" ("type")‚--ƒCtablenote_annotationsnote_annotationsCREATE TABLE "note_annotations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "note_id" integer, "predicate" varchar(50), "value" varchar(1024), "created_at" datetime, "updated_at" datetime, "namespace" varchar(50))z9-indexix_note_annotations_fknote_annotationsCREATE INDEX "ix_note_annotations_fk" ON "note_annotations" ("note_id")‚ƒitablenotesnotesCREATE TABLE "notes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "language" varchar(2), "value" varchar(4000), "type" varchar(50), "created_at" datetime, "updated_at" datetime, "owner_id" integer, "owner_type" varchar(255) NOT NULL)a5indexix_notes_on_languagenotesCREATE INDEX "ix_notes_on_language" ON "notes" ("language")o-'indexix_notes_fk_typenotesCREATE INDEX "ix_notes_fk_type" ON "notes" ("owner_id", "owner_type", "type")T-sindexix_notes_on_typenotesCREATE INDEX "ix_notes_on_type" ON "notes" ("type")ƒ†tableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "forename" varchar(255), "surname" varchar(255), "email" varchar(255), "crypted_password" varchar(255), "active" boolean, "created_at" datetime, "updated_at" datetime, "password_salt" varchar(255), "persistence_token" varchar(255), "perishable_token" varchar(255), "role" varchar(255), "telephone_number" varchar(255)) ¼îÜʸ¦”‚p^L:(òàμ)20110525103100)20110512132624)20110510162719)20110427120534)20110420133640 )20110408120740 )20110408120357 )20110328124300 )20110208084250 )20110204121244)20101210153916)20101208103531)20101202135420)20101202094602)20101129161528)20101125141218)20100927101502)20110615134040 ªÚÇ´¡Ž{hUB/ öãнªí)20110525103100)20110512132624)20110510162719)20110427120534)20110420133640)20110408120740 )20110408120357 )20110328124300 )20110208084250 )20110204121244 )20101210153916)20101208103531)20101202135420)20101202094602)20101129161528)20101125141218)20100927101502)20110615134040