spec/dummy/db/test.sqlite3 in enju_bookmark-0.1.2.pre13 vs spec/dummy/db/test.sqlite3 in enju_bookmark-0.1.2.pre14
- old
+ new
@@ -1,9 +1,9 @@
-SQLite format 3 @ -% #])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") [)Iindexindex_manifestations_on_carrier_type_idmanifestationsCREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")
+SQLite format 3 @ -% #])Mindexindex_manifestations_on_required_role_idmanifestations
CREATE INDEX "index_manifestations_on_required_role_id" ON "manifestations" ("required_role_id") [)Iindexindex_manifestations_on_carrier_type_idmanifestationsCREATE INDEX "index_manifestations_on_carrier_type_id" ON "manifestations" ("carrier_type_id")
))ctablemanifestationsmanifestationsCREATE TABLE "manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text NOT NULL, "title_alternative" text, "title_transcription" text, "classification_number" varchar(255), "manifestation_identifier" varchar(255), "date_of_publication" datetime, "copyright_date" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "access_address" varchar(255), "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "extent_id" integer DEFAULT 1 NOT NULL, "start_page" integer, "end_page" integer, "height" integer, "width" integer, "depth" integer, "isbn" varchar(255), "isbn10" varchar(255), "wrong_isbn" varchar(255), "nbn" varchar(255), "lccn" varchar(255), "oclc_number" varchar(255), "issn" varchar(255), "price" integer, "fulltext" text, "volume_number_list" varchar(255), "issue_number_list" varchar(255), "serial_number_list" varchar(255), "edition" integer, "note" text, "repository_content" boolean DEFAULT 'f' NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "state" varchar(255), "required_score" integer DEFAULT 0 NOT NULL, "frequency_id" integer DEFAULT 1 NOT NULL, "subscription_master" boolean DEFAULT 'f' NOT NULL)n ?indexindex_agents_on_full_nameagents
-CREATE INDEX "index_agents_on_full_name" ON "agents" ("full_name")M-indexindex_agents_on_required_role_idagents CREATE INDEX "index_agents_on_required_role_id" ON "agents" ("required_role_id")qAindexindex_agents_on_country_idagentsCREATE INDEX "index_agents_on_country_id" ON "agents" ("country_id")tCindexindex_agents_on_language_idagentsCREATE INDEX "index_agents_on_language_id" ON "agents" ("language_id")o;indexindex_agents_on_user_idagentsCREATE UNIQUE INDEX "index_agents_on_user_id" ON "agents" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tableagentsagentsCREATE TABLE "agents" ("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, "agent_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "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_ _ T zI D7 3 tv `i QU ?D *5
-
xqjc\J8&r`N<*
v
d
R
@
.
+CREATE INDEX "index_agents_on_full_name" ON "agents" ("full_name")M-indexindex_agents_on_required_role_idagents CREATE INDEX "index_agents_on_required_role_id" ON "agents" ("required_role_id")qAindexindex_agents_on_country_idagentsCREATE INDEX "index_agents_on_country_id" ON "agents" ("country_id")tCindexindex_agents_on_language_idagentsCREATE INDEX "index_agents_on_language_id" ON "agents" ("language_id")o;indexindex_agents_on_user_idagentsCREATE UNIQUE INDEX "index_agents_on_user_id" ON "agents" ("user_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)tableagentsagentsCREATE TABLE "agents" ("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, "agent_type_id" integer DEFAULT 1 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "note" text, "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_ c V zI D7 3 tv `i QU ?D *5
+
xqjc\J8&r`N<*
v
d
R
@
.
zhVD2 ~lZH6$
@@ -14,13 +14,13 @@
^
L
:
(
- t b P > , xfTB/ )20130421093852)20130221154434)20121119153944 )20120728204337)20120602141129~)20120511072422})20120510140958|)20120424103932{)20120418081407z)20120415164821y)20120415060308x)20120413170720w)20120413170705v)20120413161403u)20120413161340t)20120413100352s)20120413072700r)20120410104851q)20120319173203p)20120319120638o)20120129020544n)20120129014038m)20120125152919l)20120105074911k)20111231145823j)20111218002349i)20111217234412h)20111201163718g)20111201155513f)20111201155456e)20111201121844d)20111124112131c)20111124110355b)20111124110319a)20111124110059`)20111020063828_)20111009183423^)20110918162329])20110916103953\)20110916091020[)20110916053430Z)20110820131417Y)20110627122938X)20110621093332W)20110620173525V)20110619064807U)20110618091240T)20110603184217S)20110425133109R)20110328130826Q)20110318183304P)20110301134521O)20110301121550N)20110301035123M)20110222073537L)20110115022329K)20101212070145J)20100925074559I)20100925043847H)20100814091104G)20100607044753F)20100606073747E)20100525171356D)20100525124311C)20100321235924B)20100223121519A)20100222124420@)20100211105551?)20100129142347>)20091214131723=)20091202124834<)20091025080447;)20091012101112:)200908312203019)200908121519028)200907200914297)200907200911066)200907192018435)200907052120434)200907051339423)200903211304482)200812200341171)200812200236280)20081216190724/)20081216190517.)20081215094955-)20081215094302,)20081212151820+)20081212151614*)20081212080038))20081212075554()20081030023615')20081030023518&)20081030023412%)20081028083208$)20081028083142#)20081027150907")20081025083905!)20081025083323 )20081023092436)20081006093246)20081006090811)20080905191442)20080830172106)200808301541091321311301291271251241211201171128077
736959
+ t b P > , xfTB/ )20140524142813)20140524135607)20130421093852)20130221154434)20121119153944 )20120728204337)20120602141129~)20120511072422})20120510140958|)20120424103932{)20120418081407z)20120415164821y)20120415060308x)20120413170720w)20120413170705v)20120413161403u)20120413161340t)20120413100352s)20120413072700r)20120410104851q)20120319173203p)20120319120638o)20120129020544n)20120129014038m)20120125152919l)20120105074911k)20111231145823j)20111218002349i)20111217234412h)20111201163718g)20111201155513f)20111201155456e)20111201121844d)20111124112131c)20111124110355b)20111124110319a)20111124110059`)20111020063828_)20111009183423^)20110918162329])20110916103953\)20110916091020[)20110916053430Z)20110820131417Y)20110627122938X)20110621093332W)20110620173525V)20110619064807U)20110618091240T)20110603184217S)20110425133109R)20110328130826Q)20110318183304P)20110301134521O)20110301121550N)20110301035123M)20110222073537L)20110115022329K)20101212070145J)20100925074559I)20100925043847H)20100814091104G)20100607044753F)20100606073747E)20100525171356D)20100525124311C)20100321235924B)20100223121519A)20100222124420@)20100211105551?)20100129142347>)20091214131723=)20091202124834<)20091025080447;)20091012101112:)200908312203019)200908121519028)200907200914297)200907200911066)200907192018435)200907052120434)200907051339423)200903211304482)200812200341171)200812200236280)20081216190724/)20081216190517.)20081215094955-)20081215094302,)20081212151820+)20081212151614*)20081212080038))20081212075554()20081030023615')20081030023518&)20081030023412%)20081028083208$)20081028083142#)20081027150907")20081025083905!)20081025083323 )20081023092436)20081006093246)20081006090811)20080905191442)20080830172106)200808301541091321311301291271251241211201171128077
736959
55 473533321512651
- t {skc[SKC0
+ L {skc[SKC0
r_L9&
{
h
U
B
/
q^K8%zgTA.
@@ -30,45 +30,45 @@
p
]
J
7
$
- y f S @ - o\I6#t )20130421093852 )20130221154434 )20121119153944 )20120728204337 )20120602141129)20120511072422~)20120510140958})20120424103932|)20120418081407{)20120415164821z)20120415060308y)20120413170720x)20120413170705w)20120413161403v)20120413161340u)20120413100352t)20120413072700s)20120410104851r)20120319173203q)20120319120638p)20120129020544o)20120129014038n)20120125152919m)20120105074911l)20111231145823k)20111218002349j)20111217234412i)20111201163718h)20111201155513g)20111201155456f)20111201121844e)20111124112131d)20111124110355c)20111124110319b)20111124110059a)20111020063828`)20111009183423_)20110918162329^)20110916103953])20110916091020\)20110916053430[)20110820131417Z)20110627122938Y)20110621093332X)20110620173525W)20110619064807V)20110618091240U)20110603184217T)20110425133109S)20110328130826R)20110318183304Q)20110301134521P)20110301121550O)20110301035123N)20110222073537M)20110115022329L)20101212070145K)20100925074559J)20100925043847I)20100814091104H)20100607044753G)20100606073747F)20100525171356E)20100525124311D)20100321235924C)20100223121519B)20100222124420A)20100211105551@)20100129142347?)20091214131723>)20091202124834=)20091025080447<)20091012101112;)20090831220301:)200908121519029)200907200914298)200907200911067)200907192018436)200907052120435)200907051339424)200903211304483)200812200341172)200812200236281)200812161907240)20081216190517/)20081215094955.)20081215094302-)20081212151820,)20081212151614+)20081212080038*)20081212075554))20081030023615()20081030023518')20081030023412&)20081028083208%)20081028083142$)20081027150907#)20081025083905")20081025083323!)20081023092436 )20081006093246)20081006090811)20080905191442)20080830172106)20080830154109132131130129127125124121120117112807773
695955
+ y f S @ - o\I6#t`L )20140524142813 )20140524135607 )20130421093852 )20130221154434 )20121119153944 )20120728204337 )20120602141129)20120511072422~)20120510140958})20120424103932|)20120418081407{)20120415164821z)20120415060308y)20120413170720x)20120413170705w)20120413161403v)20120413161340u)20120413100352t)20120413072700s)20120410104851r)20120319173203q)20120319120638p)20120129020544o)20120129014038n)20120125152919m)20120105074911l)20111231145823k)20111218002349j)20111217234412i)20111201163718h)20111201155513g)20111201155456f)20111201121844e)20111124112131d)20111124110355c)20111124110319b)20111124110059a)20111020063828`)20111009183423_)20110918162329^)20110916103953])20110916091020\)20110916053430[)20110820131417Z)20110627122938Y)20110621093332X)20110620173525W)20110619064807V)20110618091240U)20110603184217T)20110425133109S)20110328130826R)20110318183304Q)20110301134521P)20110301121550O)20110301035123N)20110222073537M)20110115022329L)20101212070145K)20100925074559J)20100925043847I)20100814091104H)20100607044753G)20100606073747F)20100525171356E)20100525124311D)20100321235924C)20100223121519B)20100222124420A)20100211105551@)20100129142347?)20091214131723>)20091202124834=)20091025080447<)20091012101112;)20090831220301:)200908121519029)200907200914298)200907200911067)200907192018436)200907052120435)200907051339424)200903211304483)200812200341172)200812200236281)200812161907240)20081216190517/)20081215094955.)20081215094302-)20081212151820,)20081212151614+)20081212080038*)20081212075554))20081030023615()20081030023518')20081030023412&)20081028083208%)20081028083142$)20081027150907#)20081025083905")20081025083323!)20081023092436 )20081006093246)20081006090811)20080905191442)20080830172106)20080830154109132131130129127125124121120117112807773
695955
47 353332151265 1
J t_
[K;
7 -J lJ1 AA
Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396qI1 % AA
オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396th1 + AA
試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396tg1 + AA
作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396wf1 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-01z1 AA
! User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01
1 # # AA
! New agent 5New agent 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 1 # # AA
! New agent 4New agent 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-011 # # AA
! New agent 3New agent 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-011 # # AA
! New agent 2New agent 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-011 # # AA
! New agent 1New agent 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-011 ! ! AA ! Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01
1 '