test/dummy/db/test.sqlite3 in kinney-0.0.2 vs test/dummy/db/test.sqlite3 in kinney-0.0.3
- old
+ new
@@ -1,28 +1,28 @@
-SQLite format 3 @ 7 , 7 -% , + ( " & #
{ ' }
# jT9# 'kinney_topics:%1kinney_admin_usersqY'kinney_people;MJ1kinney_clip_people<+kinney_trackers:l%kinney_clips;MJ1kinney_clip_topics:l'kinney_images0B5kinney_person_images<
+SQLite format 3 @ B , B -' , + ( " & #
{ ' }
# jT9# 'kinney_topics:%1kinney_admin_usersqY'kinney_people;MJ1kinney_clip_people<+kinney_trackers:l%kinney_clips;MJ1kinney_clip_topics:l'kinney_images0B5kinney_person_images<
s $ $ v P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q //tableschema_migrationsschema_migrations)CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)!=//indexunique_schema_migrationsschema_migrations*CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") E
$ q|77tableactive_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))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") % !
-
WN DB // WilliamFriday13-04-01 17:14:4513-04-01 17:14:45BJ // BrooksRaiford13-04-01 17:14:4513-04-01 17:14:45cT ? // JohnLeslieAtkins<p>Atkin's biography.</p>13-04-01 17:14:4513-04-01 17:14:45IIICp // AndrewXavier13-04-01 17:14:4513-04-01 17:14:45?̰7 // ThirdMan13-04-01 17:14:4513-04-01 17:14:45DL // WilliamWilliams13-04-01 17:14:4513-04-01 17:14:45an oaWYA[ //5 5EdwardNorrisTolson<p>Norris Tolson grew up in Edgecombe County.</p><p>These are Tolson's accomplishments.</p><p>These are Tolson's activities.</p><p>What Tolson is currently doing.</p><p>This is a citation.</p><p>Student Body President 1962-1963</p>1962-196313-04-01 17:14:4513-04-01 17:14:45edward-norris-tolsonEdgecombe County, NC
+ + NY / AA /Aadmin@example.com$2a$10$QmChtnqHqfMVlVao07wCmOxoNYp.V7UcyN5ottVfdQFIMMy81Z3Qq
-2013-04-01 21:15:49.1780802013-04-01 21:15:44.735350127.0.0.1127.0.0.113-04-01 17:14:452013-04-01 21:15:49.179109
+
WN DB // WilliamFriday13-07-11 09:53:1813-07-11 09:53:18BJ // BrooksRaiford13-07-11 09:53:1813-07-11 09:53:18cT ? // JohnLeslieAtkins<p>Atkin's biography.</p>13-07-11 09:53:1813-07-11 09:53:18IIICp // AndrewXavier13-07-11 09:53:1813-07-11 09:53:18?̰7 // ThirdMan13-07-11 09:53:1813-07-11 09:53:18DL // WilliamWilliams13-07-11 09:53:1813-07-11 09:53:18an oaWYA[ //5 5EdwardNorrisTolson<p>Norris Tolson grew up in Edgecombe County.</p><p>These are Tolson's accomplishments.</p><p>These are Tolson's activities.</p><p>What Tolson is currently doing.</p><p>This is a citation.</p><p>Student Body President 1962-1963</p>1962-196313-07-11 09:53:1813-07-11 09:53:18edward-norris-tolsonEdgecombe County, NC
+ + NY / AA /Aadmin@example.com$2a$10$QmChtnqHqfMVlVao07wCmOxoNYp.V7UcyN5ottVfdQFIMMy81Z3Qq
+2013-07-11 13:54:34.5666722013-07-11 13:54:29.308096127.0.0.1127.0.0.113-07-11 09:53:182013-07-11 13:54:34.567560
- /admin@example.comqY
S 4˙K 330B0B2013-04-01 21:14:452013-04-01 21:14:454 33'kT W
-2013-04-01 21:14:452013-04-01 21:14:454v 33;n 2013-04-01 21:14:452013-04-01 21:14:454f 33;n)C2013-04-01 21:14:452013-04-01 21:14:454Ӳr 33;n02013-04-01 21:14:452013-04-01 21:14:45
_) 0˙K //;MJ;MJ13-04-01 17:14:4513-04-01 17:14:450 //'kT13-04-01 17:14:4513-04-01 17:14:450v //'kT 13-04-01 17:14:4513-04-01 17:14:450f //;n!13-04-01 17:14:4513-04-01 17:14:450Ӳr //;nY~13-04-01 17:14:4513-04-01 17:14:45
+ /admin@example.comqY
S 4˙K 330B0B2013-07-11 13:53:182013-07-11 13:53:184 33'kT W
+2013-07-11 13:53:182013-07-11 13:53:184v 33;n 2013-07-11 13:53:182013-07-11 13:53:184f 33;n)C2013-07-11 13:53:182013-07-11 13:53:184Ӳr 33;n02013-07-11 13:53:182013-07-11 13:53:18
_) 0˙K //;MJ;MJ13-07-11 09:53:1813-07-11 09:53:180 //'kT13-07-11 09:53:1813-07-11 09:53:180v //'kT 13-07-11 09:53:1813-07-11 09:53:180f //;n!13-07-11 09:53:1813-07-11 09:53:180Ӳr //;nY~13-07-11 09:53:1813-07-11 09:53:18
qY
;MJ< f !ʊf Y~:l
-
_ _ 0v //'13-04-01 17:14:4513-04-01 17:14:450f //!:%13-04-01 17:14:4513-04-01 17:14:450Ӳr //Y~'13-04-01 17:14:4513-04-01 17:14:45
+
_ _ 0v //'13-07-11 09:53:1813-07-11 09:53:180f //!:%13-07-11 09:53:1813-07-11 09:53:180Ӳr //Y~'13-07-11 09:53:1813-07-11 09:53:18
!ʊf Y~:l
' :%ʊf ':l
- ;MJ< 'kTf 'kT ;nʊf ;n:l
H [J
?/ // raiford-academics_balanceAcademics Balancef13-04-01 17:14:4513-04-01 17:14:45fZݒ
75 // atkins-roots_applyingApplying to NC Statef13-04-01 17:14:4513-04-01 17:14:45t]
9# //# atkins-campuslife_firePullen Firet13-04-01 17:14:4513-04-01 17:14:45pullen-firefU
;// tolson-mentors_caldwellMentorsMyTextf13-04-01 17:14:4513-04-01 17:14:45ftl %I//I!]tolson-rootsGrowing Up in Edgecombe County<p>Quotes on Tolson's Roots.</p><p>Another quote on Tolson's Roots.</p>t13-04-01 17:14:4513-04-01 17:14:45growing-up-in-edgecombe-county,2011-06-04This is a description of the Roots clip.f
- ;MJ #pullen-fire !%Igrowing-up-in-edgecombe-countyY~
4x 0B //0004685t13-04-01 17:14:4513-04-01 17:14:45>
- 7//si-ag1964-p123-atkinst13-04-01 17:14:4513-04-01 17:14:45>V 7//si-ag1962-p212-tolsonf13-04-01 17:14:4513-04-01 17:14:45>̎C 7//si-ag1962-p408-tolsont13-04-01 17:14:4513-04-01 17:14:45>{ 7//si-ag1962-p100-tolsonf13-04-01 17:14:4513-04-01 17:14:45
+ ;MJ< 'kTf 'kT ;nʊf ;n:l
H [J
?/ // raiford-academics_balanceAcademics Balancef13-07-11 09:53:1813-07-11 09:53:18fZݒ
75 // atkins-roots_applyingApplying to NC Statef13-07-11 09:53:1813-07-11 09:53:18t]
9# //# atkins-campuslife_firePullen Firet13-07-11 09:53:1813-07-11 09:53:18pullen-firefU
;// tolson-mentors_caldwellMentorsMyTextf13-07-11 09:53:1813-07-11 09:53:18ftl %I//I!]tolson-rootsGrowing Up in Edgecombe County<p>Quotes on Tolson's Roots.</p><p>Another quote on Tolson's Roots.</p>t13-07-11 09:53:1813-07-11 09:53:18growing-up-in-edgecombe-county,2011-06-04This is a description of the Roots clip.f
+ ;MJ #pullen-fire !%Igrowing-up-in-edgecombe-countyY~
4x 0B //0004685t13-07-11 09:53:1813-07-11 09:53:18>
+ 7//si-ag1964-p123-atkinst13-07-11 09:53:1813-07-11 09:53:18>V 7//si-ag1962-p212-tolsonf13-07-11 09:53:1813-07-11 09:53:18>̎C 7//si-ag1962-p408-tolsont13-07-11 09:53:1813-07-11 09:53:18>{ 7//si-ag1962-p100-tolsonf13-07-11 09:53:1813-07-11 09:53:18
0B0B W
W
)C)C 00
0B ;MJ 'kT 2 97 ( 7L5edward-norris-tolson;n
0B< W
-f )Cʊf 0:l
e Kԧ" 33 7Academics2013-04-01 21:14:452013-04-01 21:14:45Academics descriptionGה; 33 3Mentors2013-04-01 21:14:452013-04-01 21:14:45Mentors descriptionH 33/Roots2013-04-01 21:14:452013-04-01 21:14:45rootsRoots description
+f )Cʊf 0:l
e Kԧ" 33 7Academics2013-07-11 13:53:182013-07-11 13:53:18Academics descriptionGה; 33 3Mentors2013-07-11 13:53:182013-07-11 13:53:18Mentors descriptionH 33/Roots2013-07-11 13:53:182013-07-11 13:53:18rootsRoots description
0B< 'kTf ;n ;nʊf ;n:l
:% roots'
2l A11indexindex_admin_users_on_emailkinney_admin_usersCREATE UNIQUE INDEX "index_admin_users_on_email" ON "kinney_admin_users" ("email")8_1mindexindex_admin_users_on_reset_password_tokenkinney_admin_usersCREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "kinney_admin_users" ("reset_password_token")l11tablekinney_clip_peoplekinney_clip_peopleCREATE TABLE "kinney_clip_people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "person_id" integer, "clip_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
E1+indexindex_clip_people_on_clip_idkinney_clip_peopleCREATE INDEX "index_clip_people_on_clip_id" ON "kinney_clip_people" ("clip_id") I13indexindex_clip_people_on_person_idkinney_clip_peopleCREATE INDEX "index_clip_people_on_person_id" ON "kinney_clip_people" ("person_id")
q k
11tablekinney_clip_topicskinney_clip_topicsCREATE TABLE "kinney_clip_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "clip_id" integer, "topic_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
E1+indexindex_clip_topics_on_clip_idkinney_clip_topicsCREATE INDEX "index_clip_topics_on_clip_id" ON "kinney_clip_topics" ("clip_id")
G1/indexindex_clip_topics_on_topic_idkinney_clip_topicsCREATE INDEX "index_clip_topics_on_topic_id" ON "kinney_clip_topics" ("topic_id")l
%%tablekinney_clipskinney_clipsCREATE TABLE "kinney_clips" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar(255), "title" varchar(255), "quotes" text, "top_pick" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar(255), "duration" integer, "interview_date" date, "description" text, "featured" boolean)
(
@@ -49,11 +49,11 @@
- 4
- 5
- 5
- 5
- 5
-tolson-rootsMyString2012-07-18MyStringfalse fb954870-fbb1-4222-9b60-50b529f41cda2013-04-01 21:14:452013-04-01 21:14:45if Ue% ! 33517049cb-b261-4821-b3d0-92bdfe8e7988---
+tolson-rootsMyString2012-07-18MyStringfalse fb954870-fbb1-4222-9b60-50b529f41cda2013-07-11 13:53:182013-07-11 13:53:18if Ue% ! 33517049cb-b261-4821-b3d0-92bdfe8e7988---
- 6
- 6
- 6
- 6
- 7
@@ -74,11 +74,11 @@
- 10
- 11
- 11
- 11
- 11
-tolson-rootsMyString2012-07-18MyStringf2013-04-01 21:14:452013-04-01 21:14:45aӲr UU% ! 33517049cb-b261-4821-b3d0-92bdfe8e7988---
+tolson-rootsMyString2012-07-18MyStringf2013-07-11 13:53:182013-07-11 13:53:18aӲr UU% ! 33517049cb-b261-4821-b3d0-92bdfe8e7988---
- 0
- 0
- 0
- 0
- 1
@@ -99,10 +99,10 @@
- 4
- 5
- 5
- 5
- 5
-tolson-rootsMyString2012-07-18MyStringf2013-04-01 21:14:452013-04-01 21:14:45
e92 *~]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")u //tablefriendly_id_slugsfriendly_id_slugs CREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(40), "created_at" datetime)Jq/indexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugs
+tolson-rootsMyString2012-07-18MyStringf2013-07-11 13:53:182013-07-11 13:53:18
e92 *~]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")u //tablefriendly_id_slugsfriendly_id_slugs CREATE TABLE "friendly_id_slugs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "slug" varchar(255) NOT NULL, "sluggable_id" integer NOT NULL, "sluggable_type" varchar(40), "created_at" datetime)Jq/indexindex_friendly_id_slugs_on_slug_and_sluggable_typefriendly_id_slugs
CREATE UNIQUE INDEX "index_friendly_id_slugs_on_slug_and_sluggable_type" ON "friendly_id_slugs" ("slug", "sluggable_type")
z z! #[/Iindexindex_friendly_id_slugs_on_sluggable_idfriendly_id_slugs CREATE INDEX "index_friendly_id_slugs_on_sluggable_id" ON "friendly_id_slugs" ("sluggable_id"))_/Qindexindex_friendly_id_slugs_on_sluggable_typefriendly_id_slugsCREATE INDEX "index_friendly_id_slugs_on_sluggable_type" ON "friendly_id_slugs" ("sluggable_type").11tablekinney_admin_userskinney_admin_users
CREATE TABLE "kinney_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)
- - p3%indexindex_clips_on_slugkinney_clipsCREATE UNIQUE INDEX "index_clips_on_slug" ON "kinney_clips" ("slug")b''tablekinney_imageskinney_imagesCREATE TABLE "kinney_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "filename" varchar(255), "top_pick" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g1'indexindex_images_on_idkinney_images CREATE INDEX "index_images_on_id" ON "kinney_images" ("id") ''Wtablekinney_peoplekinney_people CREATE TABLE "kinney_people" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "middle_name" varchar(255), "last_name" varchar(255), "nickname" varchar(255), "biography" text, "accomplishments" text, "activities" text, "currently" text, "citations" text, "graduating_class" integer, "term" text, "term_date_ranges" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar(255), "name_suffix" varchar(255), "location" varchar(255))
b p^L:(tb )20120608154325)20120608154751)20120621152659)20120621180532)20120608112308)20120628214103)20120619182436)20120613160548)20120619170552)20120718171649
)20120608203825 )20120712175934 )20120608112307
)20120629141221 )20120614211751)20120608154850)20120723182032)20120608152305)20120608155215)20120608155306)20120608174402)20120718171714)20120805015831
K /K^h UqB { )20120608154325)20120608154751)20120621152659)20120621180532)20120608112308)20120628214103)20120619182436)20120613160548)20120619170552)20120718171649)20120608203825
)20120712175934 )20120608112307 )20120629141221
)20120614211751 )20120608154850)20120723182032)20120608152305)20120608155215)20120608155306)20120608174402)20120718171714)20120805015831
f f m t5'indexindex_people_on_slugkinney_people CREATE UNIQUE INDEX "index_people_on_slug" ON "kinney_people" ("slug")s55 tablekinney_person_imageskinney_person_imagesCREATE TABLE "kinney_person_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "person_id" integer, "image_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K57indexindex_person_images_on_image_idkinney_person_images CREATE INDEX "index_person_images_on_image_id" ON "kinney_person_images" ("image_id")M5;indexindex_person_images_on_person_idkinney_person_images CREATE INDEX "index_person_images_on_person_id" ON "kinney_person_images" ("person_id")s''%tablekinney_topicskinney_topics CREATE TABLE "kinney_topics" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "slug" varchar(255), "description" text)
q t5'indexindex_topics_on_slugkinney_topics!CREATE UNIQUE INDEX "index_topics_on_slug" ON "kinney_topics" ("slug")E++Atablekinney_trackerskinney_trackers$CREATE TABLE "kinney_trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "uuid" varchar(255), "seconds" text, "video" varchar(255), "site" varchar(255), "time" date, "session" varchar(255), "sessioned" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)B77#tablekinney_video_sessionskinney_video_sessions%CREATE TABLE "kinney_video_sessions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "uuid" varchar(255), "seconds" text, "video" varchar(255), "site" varchar(255), "time" date, "session" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
\ No newline at end of file