SQLite format 3@ q-&q-$* c@kFBE'+indexindex_images_on_moderator_idlentil_imagesCREATE INDEX "index_images_on_moderator_id" ON "lentil_images" ("moderator_id") S'Gindexindex_images_on_external_identifierlentil_imagesCREATE INDEX "index_images_on_external_identifier" ON "lentil_images" ("external_identifier")R ''ctablelentil_imageslentil_images CREATE TABLE "lentil_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "like_votes_count" integer DEFAULT 0, "url" varchar(255), "user_id" integer, "state" integer DEFAULT 0, "external_identifier" varchar(255), "long_url" varchar(255), "original_metadata" text, "original_datetime" datetime, "staff_like" boolean DEFAULT 'f', "moderator_id" integer, "moderated_at" datetime, "second_moderation" boolean DEFAULT 'f', "wins_count" integer DEFAULT 0, "losses_count" integer DEFAULT 0, "win_pct" float, "popular_score" integer DEFAULT 0, "file_harvested_date" datetime, "file_harvest_failed" integer DEFAULT 0, "donor_agreement_submitted_date" datetime, "donor_agreement_failed" integer DEFAULT 0, "failed_file_checks" integer DEFAULT 0, "file_last_checked" datetime, "donor_agreement_rejected" datetime, "do_not_request_donation" boolean DEFAULT 'f')u ;%indexindex_flags_on_image_idlentil_flags CREATE INDEX "index_flags_on_image_id" ON "lentil_flags" ("image_id")F %%Otablelentil_flagslentil_flags CREATE TABLE "lentil_flags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)` )){tablelentil_battleslentil_battles CREATE TABLE "lentil_battles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "loser_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)8_1mindexindex_admin_users_on_reset_password_tokenlentil_admin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "lentil_admin_users" ("reset_password_token") A11indexindex_admin_users_on_emaillentil_admin_usersCREATE UNIQUE INDEX "index_admin_users_on_email" ON "lentil_admin_users" ("email").11tablelentil_admin_userslentil_admin_usersCREATE TABLE "lentil_admin_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Qq7indexindex_admin_notes_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_admin_notes_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")*]7Mindexindex_active_admin_comments_on_namespaceactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")Y}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q77tableactive_admin_commentsactive_admin_commentsCREATE TABLE "active_admin_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_id" varchar(255) NOT NULL, "resource_type" varchar(255) NOT NULL, "author_id" integer, "author_type" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "namespace" var  qW?' %lentil_users  )lentil_tagsets:l ?lentil_tagset_assignments:l #lentil_tags< +lentil_taggings:l+lentil_services$/lentil_like_votes:l/lentil_licensings:l+lentil_licenses:l'lentil_images:l%lentil_flags:l)lentil_battles:l1lentil_admin_users:l    ||~Ӳr///admin@example.com$2a$10$Jln3fQjXhb6Tqecn29ZSZei7lHspu22aVlYTDOKEn.dmio4cJGrh.13-06-13 16:59:2713-06-13 16:59:27 /admin@example.com:l :l T BӲuAA IK2013-06-13 21:00:18.9086562013-06-13 21:00:18.908656BӲtAA:l2013-06-13 21:00:16.6154062013-06-13 21:00:16.615406BӲsAA IK2013-06-13 21:00:14.6387052013-06-13 21:00:14.638705,f 332013-06-13 20:59:272013-06-13 20:59:27,Ӳr 332013-06-13 20:59:272013-06-13 20:59:27 /f33:l2013-06-13 20:59:272013-06-13 20:59:27/Ӳr33:l2013-06-13 20:59:272013-06-13 20:59:27  :lʊf :l:l- MGf-AAQE+yAtwo #hunttesting2013-04-16 16:16:15.8909722013-04-16 16:16:16.097712http://instagram.com/p/YK-nyDwMO1/ 435435726688011189_228379143http://distilleryimage9.s3.amazonaws.com/b443124ea6ae11e286b422000a9d0dd8_7.jpg--- attribution: tags: - hunttesting location: comments: count: 0 data: [] filter: Normal created_time: '1366128005' link: http://instagram.com/p/YK-nyDwMO1/ likes: count: 0 data: [] images: low_resolution: url: http://distilleryimage9.s3.amazonaws.com/b443124ea6ae11e286b422000a9d0dd8_6.jpg width: 306 height: 306 thumbnail: url: http://distilleryimage9.s3.amazonaws.com/b443124ea6ae11e286b422000a9d0dd8_5.jpg width: 150 height: 150 standard_resolution: url: http://distilleryimage9.s3.amazonaws.com/b443124ea6ae11e286b422000a9d0dd8_7.jpg width: 612 height: 612 caption: created_time: '1366128020' text: ! 'two #hunttesting' from: username: jronallo profile_picture: http://images.ak.instagram.com/profiles/anonymousUser.jpg id: '228379143' full_name: jronallo id: '435435854178074722' type: image id: '435435726688011189_228379143' user: username: jronallo website: '' profile_picture: http://images.ak.instagram.com/profiles/anonymousUser.jpg full_name: jronallo bio: '' id: '228379143' 2013-04-16 16:00:05.000000fffKӲr-AAQ E+{Aone #hunttesting2013-04-16 16:16:16.2736982013-04-16 16:16:16.481430http://instagram.com/p/YK-cpswMOn/ 435434961797956519_228379143http://distilleryimage7.s3.amazonaws.com/7deb2d9ea6ae11e28a1a22000aa81ffa_7.jpg--- attribution: tags: - hunttesting location: comments: count: 0 data: [] filter: Inkwell created_time: '1366127914' link: http://instagram.com/p/YK-cpswMOn/ likes: count: 0 data: [] images: low_resolution: url: http://distilleryimage7.s3.amazonaws.com/7deb2d9ea6ae11e28a1a22000aa81ffa_6.jpg width: 306 height: 306 thumbnail: url: http://distilleryimage7.s3.amazonaws.com/7deb2d9ea6ae11e28a1a22000aa81ffa_5.jpg width: 150 height: 150 standard_resolution: url: http://distilleryimage7.s3.amazonaws.com/7deb2d9ea6ae11e28a1a22000aa81ffa_7.jpg width: 612 height: 612 caption: created_time: '1366127959' text: ! 'one #hunttesting' from: username: jronallo profile_picture: http://images.ak.instagram.com/profiles/anonymousUser.jpg id: '228379143' full_name: jronallo id: '435435338345791571' type: image id: '435434961797956519_228379143' user: username: jronallo website: '' profile_picture: http://images.ak.instagram.com/profiles/anonymousUser.jpg full_name: jronallo bio: '' id: '228379143' 2013-04-16 15:58:34.000000tf2fm333Q C+This is a bad image2013-06-13 20:59:272013-06-13 20:59:27http://instagram.com/p/ZA1L0nINXi/ p0450593871607420386_31727100http://distilleryimage6.ak.instagram.com/ef3c7ff0b71d11e2b1b722000a1d0aba_7.jpgff2f%'33Q C+Love the new @snohetta_design #HuntLibrary at #NCState @CentCampus #nofilter2013-06-13 20:59:272013-06-13 20:59:27http://instagram.com/p/R82ycNoNfn/ 323374234042685415_31727100http://distilleryimage3.s3.amazonaws.com/644f52a02d2f11e2b55e22000a9f09fb_7.jpgfff<ءKM33Q E+A taste of #HuntLibrary. Our #microtiles prototype wall in #MiniHunt #venus #NASA #4k #videowall2013-06-13 20:59:272013-06-13 20:59:27http://instagram.com/p/R0NyCsK_xf/ p0320942086917192799_244467814http://distilleryimage7.s3.amazonaws.com/55dcf0ba2a8c11e29cc822000a1f96e3_7.,f *rN*#E435436130255553469_228379143#E435435726688011189_228379143ʊf#E435434961797956519_228379143:l"C450593871607420386_31727100"C323374234042685415_31727100#E320942086917192799_244467814 IK ʊf:l IK qq^f3A33All Rights ReservedDefault Instagram license.2013-06-13 20:59:282013-06-13 20:59:28ARR$Ӳr %ki33%CC BY-SA 2.0Attribution — You must attribute the work in the manner specified by the author or licensor (but not in any way that suggests that they endorse you or your use of the work).http://creativecommons.org/licenses/by-sa/2.0/2013-06-13 20:59:282013-06-13 20:59:28CC-BY-SA-2.0 kk1  M  + bq77tableactive_admin_commentsactive_admin_commentsCREATE TABLE "active_admin_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_id" varchar(255) NOT NULL, "resource_type" varchar(255) NOT NULL, "author_id" integer, "author_type" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "namespace" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Y}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_commentsCREATE INDEX "index_actiq77tableactive_admin_commentsactive_admin_commentsCREATE TABLE "active_admin_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_id" varchar(255) NOT NULL, "resource_type" varchar(255) NOT NULL, "author_id" integer, "author_type" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "namespace" varchar(255))P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)Y}7 indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")*]7Mindexindex_active_admin_comments_on_namespaceactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")Qq7indexindex_admin_notes_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_admin_notes_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id").11tablelentil_admin_userslentil_admin_usersCREATE TABLE "lentil_admin_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) A11indexindex_admin_users_on_emaillentil_admin_usersCREATE UNIQUE INDEX "index_admin_users_on_email" ON "lentil_admin_users" ("email")8_1mindexindex_admin_users_on_reset_password_tokenlentil_admin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "lentil_admin_users" ("reset_password_token")` )){tablelentil_battleslentil_battles CREATE TABLE "lentil_battles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "loser_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)F %%Otablelentil_flagslentil_flags CREATE TABLE "lentil_flags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u ;%indexindex_flags_on_image_idlentil_flags CREATE INDEX "index_flags_on_image_id" ON "lentil_flags" ("image_id")R ''ctablelentil_imageslentil_images CREATE TABLE "lentil_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "like_votes_count" integer DEFAULT 0, "url" varchar(255), "user_id" integer, "state" integer DEFAULT 0, "external_identifier" varchar(255), "long_url" varchar(255), "original_metadata" text, "original_datetime" datetime, "staff_like" boolean DEFAULT 'f', "moderator_id" integer, "moderated_at" datetime, "second_moderation" boolean DEFAULT 'f', "wins_count" integer DEFAULT 0, "losses_count" integer DEFAULT 0, "win_pct" float, "popular_score" integer DEFAULT 0, "file_harvested_date" datetime, "file_harvest_failed" integer DEFAULT 0, "donor_agreement_submitted_date" datetime, "donor_agreement_failed" integer DEFAULT 0, "failed_file_checks" integer DEFAULT 0, "file_last_checked" datetime, "donor_agreement_rejected" datetime, "do_not_request_donation" boolean DEFAULT 'f')  ARRʊf%CC-BY-SA-2.0:l =e S q I 389 CG y%Eindexindex_sessions_on_updated_atsessions(CREATE INDEX "index_sessions_on_updated_at" ON "sessions" ("updated_at")y$Eindexindex_sessions_on_session_idsessions'CREATE INDEX "index_sessions_on_session_id" ON "sessions" ("session_id")W#tablesessionssessions&CREATE TABLE "sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "session_id" varchar(255) NOT NULL, "data" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)E++indexindex_licenses_on_short_namelentil_licensesCREATE INDEX "index_licenses_on_short_name" ON "lentil_licenses" ("short_name")k//tablelentil_licensingslentil_licensingsCREATE TABLE "lentil_licensings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "license_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) E/+indexindex_licensings_on_image_idlentil_licensingsCREATE INDEX "index_licensings_on_image_id" ON "lentil_licensings" ("image_id")I/3indexindex_licensings_on_license_idlentil_licensingsCREATE INDEX "index_licensings_on_license_id" ON "lentil_licensings" ("license_id")U//Ytablelentil_like_voteslentil_like_votesCREATE TABLE "lentil_like_votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "created_at" datet S'Gindexindex_images_on_external_identifierlentil_imagesCREATE INDEX "index_images_on_external_identifier" ON "lentil_images" ("external_identifier")E'+indexindex_images_on_moderator_idlentil_imagesCREATE INDEX "index_images_on_moderator_id" ON "lentil_images" ("moderator_id")++]tablelentil_licenseslentil_licensesCREATE TABLE "lentil_licenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "url" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "short_name" varchar(255))E++indexindex_licenses_on_short_namelentil_licensesCREATE INDEX "index_licenses_on_short_name" ON "lentil_licenses" ("short_name")k//tablelentil_licensingslentil_licensingsCREATE TABLE "lentil_licensings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "license_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) E/+indexindex_licensings_on_image_idlentil_licensingsCREATE INDEX "index_licensings_on_image_id" ON "lentil_licensings" ("image_id")I/3indexindex_licensings_on_license_idlentil_licensingsCREATE INDEX "index_licensings_on_license_id" ON "lentil_licensings" ("license_id")U//Ytablelentil_like_voteslentil_like_votesCREATE TABLE "lentil_like_votes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) E/+indexindex_like_votes_on_image_idlentil_like_votesCREATE INDEX "index_like_votes_on_image_id" ON "lentil_like_votes" ("image_id")d++tablelentil_serviceslentil_servicesCREATE TABLE "lentil_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "url" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)u9+indexindex_services_on_namelentil_servicesCREATE INDEX "index_services_on_name" ON "lentil_services" ("name")++;tablelentil_taggingslentil_taggingsCREATE TABLE "lentil_taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "image_id" integer, "tag_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "staff_tag" boolean DEFAULT 'f')A+#indexindex_taggings_on_image_idlentil_taggingsCREATE INDEX "index_taggings_on_image_id" ON "lentil_taggings" ("image_id"){=+indexindex_taggings_on_tag_idlentil_taggingsCREATE INDEX "index_taggings_on_tag_id" ON "lentil_taggings" ("tag_id")D##Otablelentil_tagslentil_tagsCREATE TABLE "lentil_tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 4f33ʊfʊf2013-06-13 20:59:282013-06-13 20:59:284Ӳr33:l:l2013-06-13 20:59:282013-06-13 20:59:28  ʊfʊf :l:l  ʊfʊf :l:l /f33ʊf2013-06-13 20:59:282013-06-13 20:59:28/Ӳr33ʊf2013-06-13 20:59:282013-06-13 20:59:28  ʊfʊf ʊf:l ``H$933Flickrhttp://www.flickr.com/2013-06-13 20:59:282013-06-13 20:59:28NE?33Instagramhttp://www.instagram.com/2013-06-13 20:59:282013-06-13 20:59:28  Flickr$Instagram~ M6X33:lj2013-06-13 20:59:282013-06-13 20:59:28f6v33 IK2013-06-13 20:59:282013-06-13 20:59:28f6f332013-06-13 20:59:282013-06-13 20:59:28f6Ӳr33 IK IK2013-06-13 20:59:282013-06-13 20:59:28f  :l ?_  IK ʊf  IK:l  j ?_  ʊf  IK:l Y6Ӑj#33hunttesting2013-06-13 20:59:282013-06-13 20:59:281˙K33vetmed2013-06-13 20:59:282013-06-13 20:59:288'33designlibrary2013-06-13 20:59:282013-06-13 20:59:28/v33ncsu2013-06-13 20:59:282013-06-13 20:59:281f33dhhill2013-06-13 20:59:282013-06-13 20:59:286Ӳr#33huntlibrary2013-06-13 20:59:282013-06-13 20:59:28 #hunttestingj vetmed<'designlibraryf ncsu dhhillʊf#huntlibrary:l S4ʹ 33(Z (Z 2013-06-13 20:59:282013-06-13 20:59:284v33ʊf2013-06-13 20:59:282013-06-13 20:59:284f33ʊfʊf2013-06-13 20:59:282013-06-13 20:59:284Ӳr33:l:l2013-06-13 20:59:282013-06-13 20:59:28  (Z (Z  ʊfʊf :l:l  (Z (Z ʊf ʊfʊf :l:l FLʹ )-33Testing tagsetTags for testing2013-06-13 20:59:282013-06-13 20:59:28t]f1G33D. H. Hill LibraryTags about D. H. Hill Library2013-06-13 20:59:282013-06-13 20:59:28fQӲr%;33Hunt LibraryTags about Hunt Library2013-06-13 20:59:282013-06-13 20:59:28f eJC '33jronalloJason Ronallof2013-06-13 20:59:282013-06-13 20:59:28~I0 %33jmcasdenJason Casdenf2013-06-13 20:59:282013-06-13 20:59:28~J '33bddavidsBret Davidsonf2013-06-13 20:59:282013-06-13 20:59:28~Fشi 33corylownCory Lownf2013-06-13 20:59:282013-06-13 20:59:28~ jronallo jmcasden p0bddavids;corylown     5 Fp^L:(tbP>, x f T B 0  | j X F5)201305062047284)201304130059433)201304121953482)201304031356401)201303061450130)20130306144752/)20130130194955.)20130116145103-)20130108195949,)20130107192518+)20121220182845*)20121220155108))20121220151517()20121213142215')20121206145832&)20121130212917%)20121130202753$)20121128213305#)20121128190207")20121127211257!)20121127210507 )20121127195059)20121127194428)20121127194027)20121127193932)20121127160158)20121127154531)20121126205839)20121126192652)20121126170008)20121121204450)20121120191531)20121120191530)20121120191524)20121120172712)20121120172450)20121119211236)20121119210538)20121119210450)20121119210407 )20121112200340 )20121112165849 )20121112163857 )20121112163635 )20121112163008)20121112162243)20121030170542)20121030170509)20121028164239)20121028052935)20121028042738)20121028023144)20130506205348 A Q  C '=//indexunique_schema_migrationsschema_migrations+CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")e1#indexindex_tags_on_namelentil_tagsCREATE INDEX "index_tags_on_name" ON "lentil_tags" ("name")??tablelentil_tagset_assignmentslentil_tagset_assignments CREATE TABLE "lentil_tagset_assignments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "tagset_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)#Q?Cindexindex_tagset_assignments_on_tag_idlentil_tagset_assignments!CREATE INDEX "index_tagset_assignments_on_tag_id" ON "lentil_tagset_assignments" ("tag_id"),W?Oindexindex_tagset_assignments_on_tagset_idlentil_tagset_assignments"CREATE INDEX "index_tagset_assignments_on_tagset_id" ON "lentil_tagset_assignments" ("tagset_id") ))=tablelentil_tagsetslentil_tagsets#CREATE TABLE "lentil_tagsets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "description" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "harvest" boolean DEFAULT 'f')