spec/dummy/db/test.sqlite3 in enju_event-0.0.9 vs spec/dummy/db/test.sqlite3 in enju_event-0.0.10
- old
+ new
@@ -1,38 +1,196 @@
-SQLite format 3 @ % : D % - &l{} OutableshelvesshelvesCREATE TABLE "shelves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "library_id" integer DEFAULT 1 NOT NULL, "items_count" integer DEFAULT 0 NOT NULL, "position" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)r
;indexindex_libraries_on_namelibrariesCREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")S9indexindex_libraries_on_library_group_idlibraries
CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")E+indexindex_libraries_on_patron_idlibrariesCREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id")a
-tablelibrarieslibrariesCREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer, "patron_type" varchar(255), "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)r Aindexindex_patrons_on_full_namepatrons
-CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")xEindexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)MqtablepatronspatronsCREATE TABLE "patrons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_name" varchar(255), "middle_name" varchar(255), "first_name" varchar(255), "last_name_transcription" varchar(255), "middle_name_transcription" varchar(255), "first_name_transcription" varchar(255), "corporate_name" varchar(255), "corporate_name_transcription" varchar(255), "full_name" varchar(255), "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "zip_code_1" varchar(255), "zip_code_2" varchar(255), "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number_1" varchar(255), "fax_number_2" varchar(255), "other_designation" text, "place" text, "postal_code" varchar(255), "street" text, "locality" text, "region" text, "date_of_birth" datetime, "date_of_death" datetime, "language_id" integer DEFAULT 1 NOT NULL, "country_id" integer DEFAULT 1 NOT NULL, "patron_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "creates_count" integer DEFAULT 0 NOT NULL, "realizes_count" integer DEFAULT 0 NOT NULL, "produces_count" integer DEFAULT 0 NOT NULL, "owns_count" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) #
o]K9' )20081025083323)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639
)20100527113752)20100222124420)20100211105551
-)20090519203307 )20081028093607)20081025083905)200809051914421141138069591
- vcP=* )20081025083323)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752
)20100222124420)20100211105551)20090519203307
-)20081028093607 )20081025083905)200809051914421141138069591
iB
*n
+SQLite format 3 @ = 9 F = - %Ziku_ r
;indexindex_libraries_on_namelibrariesCREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")S9indexindex_libraries_on_library_group_idlibraries
CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")E+indexindex_libraries_on_patron_idlibrariesCREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id")s
+5tablelibrarieslibrariesCREATE TABLE "libraries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer, "patron_type" varchar(255), "name" varchar(255) NOT NULL, "display_name" text, "short_display_name" varchar(255) NOT NULL, "zip_code" varchar(255), "street" text, "locality" text, "region" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number" varchar(255), "note" text, "call_number_rows" integer DEFAULT 1 NOT NULL, "call_number_delimiter" varchar(255) DEFAULT '|' NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "users_count" integer DEFAULT 0 NOT NULL, "position" integer, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)r Aindexindex_patrons_on_full_namepatrons
+CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")xEindexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)_tablepatronspatronsCREATE TABLE "patrons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "last_name" varchar(255), "middle_name" varchar(255), "first_name" varchar(255), "last_name_transcription" varchar(255), "middle_name_transcription" varchar(255), "first_name_transcription" varchar(255), "corporate_name" varchar(255), "corporate_name_transcription" varchar(255), "full_name" varchar(255), "full_name_transcription" text, "full_name_alternative" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "zip_code_1" varchar(255), "zip_code_2" varchar(255), "address_1" text, "address_2" text, "address_1_note" text, "address_2_note" text, "telephone_number_1" varchar(255), "telephone_number_2" varchar(255), "fax_number_1" varchar(255), "fax_number_2" varchar(255), "other_designation" text, "place" text, "postal_code" varchar(255), "street" text, "locality" text, "region" text, "date_of_birth" datetime, "date_of_death" datetime, "language_id" integer DEFAULT 1 NOT NULL, "country_id" integer DEFAULT 1 NOT NULL, "patron_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "creates_count" integer DEFAULT 0 NOT NULL, "realizes_count" integer DEFAULT 0 NOT NULL, "produces_count" integer DEFAULT 0 NOT NULL, "owns_count" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "state" varchar(255), "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) $
s o]K9's )20120413170734)20120105074911)20120413051535)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752
)20100222124420)20100211105551)20090519203307
+)20081028093607 )20081025083905)20081025083323)200809051914421141138069591
+ Y vcP=*lY )20120413170734)20120105074911)20120413051535)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752)20100222124420
)20100211105551)20090519203307)20081028093607
+)20081025083905 )20081025083323)200809051914421141138069591
iB
*n
F vJ1 AA
Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 {I1 % AA
オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396 ~h1 + AA
試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 ~g1 + AA
作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396 f1 1 AA
出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 ,e1 + + 7 AA
! テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01 1 AA
! User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01
-1 % % AA
! New patron 5New patron 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 4New patron 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 3New patron 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 2New patron 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 % % AA
! New patron 1New patron 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 AA
! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 ! ! AA ! Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01 1 '