spec/dummy/db/test.sqlite3 in enju_event-0.0.17 vs spec/dummy/db/test.sqlite3 in enju_event-0.0.18
- old
+ new
@@ -1,6 +1,6 @@
-SQLite format 3 @ 9 K - %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
+SQLite format 3 @ % 9 K % - %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) (
a o]K9'sa )20120415060342)20120413170734)20120413051535)20120105074911)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752
)20100222124420)20100211105551)20090519203307
)20081028093607 )20081025083905)20081025083323)200809051914421141138069591
F vcP=*lYF )20120415060342)20120413170734)20120413051535)20120105074911)20111201163718)20111201163342)20111201155513)20111201155456)20111201121844)20111020063828)20110222073537)20110115022329)20100925074639)20100527113752)20100222124420
)20100211105551)20090519203307)20081028093607
)20081025083905 )20081025083323)200809051914421141138069591
iB
*n
@@ -20,20 +20,20 @@
p_U;$ Ruby社 %オーム社 +試験用会社h+作者ダミーg1出版社テストf7テスト正式名称e User3%New patron 5
%New patron 4 %New patron 3%New patron 2%New patron 1 User2!Librarian2'Kosuke Tanabe!Librarian1'Administrator
^
| %
AA mitaMita Library三田108-8345MinatoTokyo| 2007-08-23 10:51:00.0000002007-08-30 15:18:20.043951! - %
% AA hachiojiHachioji Library八王子192-0982HachiojiTokyo042-637-2033042-637-2116| 2007-08-14 07:37:00.0000002007-08-30 15:18:16.188285 ) )
AA !kamataKamata Library蒲田144-8535Tokyo81-3-3732-5111| 2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349JP-0000000g ) AA webWorld Wide WebWeb| 2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349
mitahachioji
-kamataweb
k J ## 33 third_shelfThird shelf 2012-05-14 19:30:292012-05-14 19:30:29L %% 33 second_shelfSecond shelf 2012-05-14 19:30:292012-05-14 19:30:29J ## 33 first_shelfFirst shelf 2012-05-14 19:30:292012-05-14 19:30:29G - 33 webLibrary bookmark 2012-05-14 19:30:292012-05-14 19:30:29
r r oQ
+kamataweb
k J ## 33 third_shelfThird shelf 2012-05-14 22:51:152012-05-14 22:51:15L %% 33 second_shelfSecond shelf 2012-05-14 22:51:152012-05-14 22:51:15J ## 33 first_shelfFirst shelf 2012-05-14 22:51:152012-05-14 22:51:15G - 33 webLibrary bookmark 2012-05-14 22:51:152012-05-14 22:51:15
r r oQ
( q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")_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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)s=indexindex_patrons_on_user_idpatronsCREATE UNIQUE INDEX "index_patrons_on_user_id" ON "patrons" ("user_id")xEindexindex_patrons_on_language_idpatronsCREATE INDEX "index_patrons_on_language_id" ON "patrons" ("language_id")uCindexindex_patrons_on_country_idpatronsCREATE INDEX "index_patrons_on_country_id" ON "patrons" ("country_id")O1indexindex_patrons_on_required_role_idpatrons CREATE INDEX "index_patrons_on_required_role_id" ON "patrons" ("required_role_id")r Aindexindex_patrons_on_full_namepatrons
CREATE INDEX "index_patrons_on_full_name" ON "patrons" ("full_name")
_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 NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "isil" varchar(255))E+indexindex_libraries_on_patron_idlibrariesCREATE UNIQUE INDEX "index_libraries_on_patron_id" ON "libraries" ("patron_id")S9indexindex_libraries_on_library_group_idlibraries
CREATE INDEX "index_libraries_on_library_group_id" ON "libraries" ("library_group_id")r
;indexindex_libraries_on_namelibrariesCREATE UNIQUE INDEX "index_libraries_on_name" ON "libraries" ("name")atableshelvesshelvesCREATE 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 NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime)
d duq| n
- G113tableevent_import_filesevent_import_files$CREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" inteuCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer DEFAULT 1 NOT NULL, "event_category_id" integer DEFAULT 1 NOT NULL, "name" varchar(255), "note" text, "start_at" datetime, "end_at" datetime, "all_day" boolean DEFAULT 'f' NOT NULL, "deleted_at" datetime, "display_name" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)qAindexindex_events_on_library_ideventsCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")O1indexindex_events_on_event_category_ideventsCREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")--Wtableevent_categoriesevent_categoriesCREATE TABLE "event_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%%Otablepatron_typespatron_typesCREATE TABLE "patron_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]tablecountriescountriesCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "alpha_2" varchar(255), "alpha_3" varchar(255), "numeric_3" varchar(255), "note" text, "position" integer)k; indexindex_countries_on_namecountriesCREATE INDEX "index_countries_on_name" ON "countries" ("name")tAindexindex_countries_on_alpha_2countriesCREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")tAindexindex_countries_on_alpha_3countriesCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")zEindexindex_countries_on_numeric_3countriesCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")'tablelanguageslanguagesCREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "native_name" varchar(255), "display_name" text, "iso_639_1" varchar(255), "iso_639_2" varchar(255), "iso_639_3" varchar(255), "note" text, "position" integer)r;indexindex_languages_on_namelanguages CREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")zEindexindex_languages_on_iso_639_1languages!CREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")zEindexindex_languages_on_iso_639_2languages"CREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")z Eindexindex_languages_on_iso_639_3languages#CREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")%%%Etableparticipatesparticipates)CREATE TABLE "participates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "event_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)&I%%indexindex_participates_on_event_idparticipates*CREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")'K%)indexindex_participates_on_patron_idparticipates+CREATE INDEX "index_participates_on_patron_id" ON "participates" ("patron_id")j(%%tabledelayed_jobsdelayed_jobs,CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
t t ? 33 9unknownunknownunknownnext-l@library.example.jp0.0.0.0/0mf2012-05-14 19:30:292012-05-14 19:30:29fhttp://localhost:3000/
+ i11wtableevent_import_filesevent_import_files$CREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), uCindexindex_shelves_on_library_idshelvesCREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id") tableeventseventsCREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer DEFAULT 1 NOT NULL, "event_category_id" integer DEFAULT 1 NOT NULL, "name" varchar(255), "note" text, "start_at" datetime, "end_at" datetime, "all_day" boolean DEFAULT 'f' NOT NULL, "deleted_at" datetime, "display_name" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)qAindexindex_events_on_library_ideventsCREATE INDEX "index_events_on_library_id" ON "events" ("library_id")O1indexindex_events_on_event_category_ideventsCREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")--Wtableevent_categoriesevent_categoriesCREATE TABLE "event_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%%Otablepatron_typespatron_typesCREATE TABLE "patron_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]tablecountriescountriesCREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "alpha_2" varchar(255), "alpha_3" varchar(255), "numeric_3" varchar(255), "note" text, "position" integer)k; indexindex_countries_on_namecountriesCREATE INDEX "index_countries_on_name" ON "countries" ("name")tAindexindex_countries_on_alpha_2countriesCREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")tAindexindex_countries_on_alpha_3countriesCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")zEindexindex_countries_on_numeric_3countriesCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")'tablelanguageslanguagesCREATE TABLE "languages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "native_name" varchar(255), "display_name" text, "iso_639_1" varchar(255), "iso_639_2" varchar(255), "iso_639_3" varchar(255), "note" text, "position" integer)r;indexindex_languages_on_namelanguages CREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")zEindexindex_languages_on_iso_639_1languages!CREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")zEindexindex_languages_on_iso_639_2languages"CREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")z Eindexindex_languages_on_iso_639_3languages#CREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")%%%Etableparticipatesparticipates)CREATE TABLE "participates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "patron_id" integer NOT NULL, "event_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)&I%%indexindex_participates_on_event_idparticipates*CREATE INDEX "index_participates_on_event_id" ON "participates" ("event_id")'K%)indexindex_participates_on_patron_idparticipates+CREATE INDEX "index_participates_on_patron_id" ON "participates" ("patron_id")j(%%tabledelayed_jobsdelayed_jobs,CREATE TABLE "delayed_jobs" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "priority" integer DEFAULT 0, "attempts" integer DEFAULT 0, "handler" text, "last_error" text, "run_at" datetime, "locked_at" datetime, "failed_at" datetime, "locked_by" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
t t ? 33 9unknownunknownunknownnext-l@library.example.jp0.0.0.0/0mf2012-05-14 22:51:152012-05-14 22:51:15fhttp://localhost:3000/
unknown
$ U
`2$
AA AAtesttest2008-02-05 06:00:00.0000002008-02-05 06:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050
AA AAtesttest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050(
=
AA =AAなんとかかんとか2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000fなんとかかんとか2008-02-05 11:50:26.6513712008-02-05 14:52:06.315285
AA AAtest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 11:41:50.5331642008-02-05 11:41:50.533164"
=AA AAテストなんとかかんとか2008-02-04 15:00:00.0000002008-02-05 15:00:00.000000fテスト2008-02-05 06:43:42.6176702008-02-05 06:43:42.617670
1
AA 1AAミーティング2008-01-12 15:00:00.0000002008-02-04 15:00:00.000000fミーティング2008-01-12 17:51:10.6423952008-02-05 11:00:35.319131.
UAA AAテストテスト用のイベントです。2008-01-12 17:54:00.0000002008-01-13 17:54:00.000000fテスト2008-01-01 11:54:25.8032012008-01-12 17:54:21.134175(
%=AA %AA仕事始めなんとかかんとか2008-01-12 17:54:00.0000002008-01-13 17:54:00.000000f仕事始め2008-01-01 07:20:54.3727292008-01-12 17:54:43.764011
-
^ ^U S +
AAunknown(not specified)2008-01-01 07:17:12.5495652008-01-01 07:24:17.869192O
AA講演会講演会2008-01-01 07:25:04.2511412008-01-01 07:25:04.251141O
AA上映会上映会2008-01-01 07:18:08.8686802008-01-01 07:24:55.261682[ ++
AAおはなし会おはなし会2008-01-01 07:17:45.4154872008-01-01 07:24:45.267241L
AAclosed休館日2008-01-01 07:17:34.6424332008-01-01 07:24:32.561469
3 x3 C !! 33ConferenceConference2012-05-14 19:30:292012-05-14 19:30:29I ''