spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre58 vs spec/dummy/db/test.sqlite3 in enju_biblio-0.1.0.pre59
- old
+ new
@@ -1,100 +1,101 @@
-SQLite format 3 @ @ -% ( ,
c)Yindexindex_manifestations_on_date_of_publicationmanifestationsCREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")Q)5indexindex_manifestations_on_updated_atmanifestations
CREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at");m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")
-Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")u ))%tablemanifestationsmanifestations
-CREATE 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 NOT NULL, "updated_at" datetime NOT NULL, "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, "price" integer, "fulltext" text, "volume_number_string" varchar(255), "issue_number_string" varchar(255), "serial_number_string" 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, "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_idagentsCREATE 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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)atableagentsagentsCREATE TABLE "agents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "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, "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, "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q// ! ށw Ձc ŁV H 9 - n
w ]b JQ =A (3
yrkd]VOHA:3,%|jXF4"
n
\
J
8
&
r`N<*vdR@.
-
-
-
-
-
-
-
-
-z
-h
-V
-D
-2
-
- ~ l Z H 6 $ mZG4!vcP=*lYF3
ubO<)~kXE2 B)20140817155043A)20140813182425@)20140811031145?)20140810091417>)20140810091231=)20140810061942<)20140802082007;)20140721151416:)201407201707359)201407201707148)201407201409167)201407091139056)201407091134135)201406280735354)201406280735243)201406280722172)201406141415001)201406140654040)20140610123439/)20140528045617.)20140528045600-)20140528045539,)20140528045518+)20140524074813*)20140524020735))20140519171220()20140519170214')20140518135713&)20140518111006%)20140518050147$)20140122054321#)20140110131010")20140110122216!)20130509185724 )20130506175834)20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130304015019)20130303124821)20130303104849)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932
)20120418081407)20120415164821)20120415060342
-)20120413170734 )20120413170720)20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851 )20120406020752)20120319120638~)20120129020544})20120129014038|)20120125152919{)20120125050502z)20120105101944y)20120105074911x)20111231145823w)20111218002349v)20111217234412u)20111201163718t)20111201155456s)20111201121844r)20111124112131q)20111124110355p)20111124110319o)20111124110059n)20110918162329m)20110916103953l)20110916091020k)20110913120629j)20110913115320i)20110627122938h)20110627035057g)20110627034940f)20110621093332e)20110620173525d)20110619064807c)20110603184217b)20110328130826a)20110318183304`)20110301134521_)20110301121550^)20110301035123])20110222073537\)20101212070145[)20100925074639Z)20100925074559Y)20100925043847X)20100814091104W)20100607044753V)20100606073747U)20100527113752T)20100525171356S)20100525124311R)20100321235924Q)20100223121519P)20100222124420O)20100211105551N)20100129142347M)20091214131723L)20091202124834K)20091025080447J)20091012101112I)20090831220301H)20090812151902G)20090720091429F)20090720091106E)20090719201843D)20090706125521C)20090705212043B)20090705133942A)20090519203307@)20090321130448?)20090208044541>)20081220034117=)20081220023628<)20081216190724;)20081216190517:)200812150949559)200812150943028)200812121518207)200812121516146)200812120800385)200812120755544)200811171434553)200811171431562)200810300236151)200810300235180)20081030023412/)20081028093607.)20081028083208-)20081028083142,)20081027150907+)20081025083905*)20081025083323))20081023092436()20080905191442')20080830172106&)20080830154109%)20080819181903$)20080606052544#154"149!146 145144142132131130129127125124121120117114113112807773
695955
+SQLite format 3 @ D -% ) ,
c)Yindexindex_manifestations_on_date_of_publicationmanifestationsCREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")Q)5indexindex_manifestations_on_updated_atmanifestations
CREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at");m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")
+Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address")M ))Utablemanifestationsmanifestations
+CREATE 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 NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "access_address" varchar(255), "language_id" integer DEFAULT 1 NOT NULL, "carrier_type_id" integer DEFAULT 1 NOT NULL, "start_page" integer, "end_page" integer, "height" integer, "width" integer, "depth" integer, "price" integer, "fulltext" text, "volume_number_string" varchar(255), "issue_number_string" varchar(255), "serial_number_string" 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, "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_idagentsCREATE 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")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)atableagentsagentsCREATE TABLE "agents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "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, "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, "email" text, "url" text)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q - !
y ցe ŁW I 8 . pv ]a JQ =A (3
w yrkd]VOHA:3,%n\J8&
r
`
N
<
*
vdR@.
+zhVD2
+
+
+
+
+
+
+
+~
+l
+Z
+H
+6
+$
+
+ p ^ L : ( p]J7$yfS@-o\I6#xeR?,n[H5"w F)20140823095740E)20140823094847D)20140823083524C)20140822114527B)20140813182425A)20140811031145@)20140810091417?)20140810091231>)20140810061942=)20140802082007<)20140721151416;)20140720170735:)201407201707149)201407201409168)201407091139057)201407091134136)201406280735355)201406280735244)201406280722173)201406141415002)201406140654041)201406101234390)20140528045617/)20140528045600.)20140528045539-)20140528045518,)20140524074813+)20140524020735*)20140519171220))20140519170214()20140518135713')20140518111006&)20140518050147%)20140122054321$)20140110131010#)20140110122216")20130509185724!)20130506175834 )20130506175303)20130504195916)20130504143515)20130504133816)20130429020822)20130421164124)20130421155019)20130421093852)20130416054135)20130304015019)20130303124821)20130303104849)20130221154434)20121116031206)20120602141129)20120511072422)20120510140958)20120424103932)20120418081407
)20120415164821)20120415060342)20120413170734
+)20120413170720 )20120413170705)20120413161403)20120413161340)20120413100431)20120413100352)20120413072700)20120413051535)20120410104851)20120406020752 )20120319120638)20120129020544~)20120129014038})20120125152919|)20120125050502{)20120105101944z)20120105074911y)20111231145823x)20111218002349w)20111217234412v)20111201163718u)20111201155456t)20111201121844s)20111124112131r)20111124110355q)20111124110319p)20111124110059o)20110918162329n)20110916103953m)20110916091020l)20110913120629k)20110913115320j)20110627122938i)20110627035057h)20110627034940g)20110621093332f)20110620173525e)20110619064807d)20110603184217c)20110328130826b)20110318183304a)20110301134521`)20110301121550_)20110301035123^)20110222073537])20101212070145\)20100925074639[)20100925074559Z)20100925043847Y)20100814091104X)20100607044753W)20100606073747V)20100527113752U)20100525171356T)20100525124311S)20100321235924R)20100223121519Q)20100222124420P)20100211105551O)20100129142347N)20091214131723M)20091202124834L)20091025080447K)20091012101112J)20090831220301I)20090812151902H)20090720091429G)20090720091106F)20090706125521E)20090705212043D)20090705133942C)20090519203307B)20090321130448A)20090208044541@)20081220034117?)20081220023628>)20081216190724=)20081216190517<)20081215094955;)20081215094302:)200812121518209)200812121516148)200812120800387)200812120755546)200811171434555)200811171431564)200810300236153)200810300235182)200810300234121)200810280936070)20081028083208/)20081028083142.)20081027150907-)20081025083905,)20081025083323+)20081023092436*)20080905191442))20080830172106()20080830154109')20080819181903&)20080606052544%154$149#146"145!144 142134133132131130129127125124121120117114113112807773
695955
47 353332291512651
- |tld\TLD<4,$wdQ>+
m
Z
G
4
!
vcP=*lYF3
-
-
-
-
-
-
-
-u
-b
-O
-<
-)
-
- ~ k X E 2 taN;( t`L8$p\H4 lXD0|hT@,xdP<( )20140817155043 )20140813182425 )20140811031145 )20140810091417 )20140810091231 )20140810061942 )20140802082007 )20140721151416 )20140720170735 )20140720170714 )20140720140916 )20140709113905 )20140709113413 )20140628073535 )20140628073524 )20140628072217 )20140614141500 )20140614065404 )20140610123439 )20140528045617 )20140528045600 )20140528045539 )20140528045518 )20140524074813 )20140524020735 )20140519171220 )20140519170214 )20140518135713 )20140518111006 )20140518050147 )20140122054321 )20140110131010 )20140110122216 )20130509185724 )20130506175834 )20130506175303 )20130504195916 )20130504143515 )20130504133816 )20130429020822 )20130421164124 )20130421155019 )20130421093852 )20130416054135 )20130304015019 )20130303124821 )20130303104849 )20130221154434 )20121116031206 )20120602141129 )20120511072422 )20120510140958 )20120424103932 )20120418081407 )20120415164821 )20120415060342 )20120413170734 )20120413170720 )20120413170705 )20120413161403 )20120413161340 )20120413100431 )20120413100352 )20120413072700 )20120413051535 )20120410104851 )20120406020752 )20120319120638)20120129020544~)20120129014038})20120125152919|)20120125050502{)20120105101944z)20120105074911y)20111231145823x)20111218002349w)20111217234412v)20111201163718u)20111201155456t)20111201121844s)20111124112131r)20111124110355q)20111124110319p)20111124110059o)20110918162329n)20110916103953m)20110916091020l)20110913120629k)20110913115320j)20110627122938i)20110627035057h)20110627034940g)20110621093332f)20110620173525e)20110619064807d)20110603184217c)20110328130826b)20110318183304a)20110301134521`)20110301121550_)20110301035123^)20110222073537])20101212070145\)20100925074639[)20100925074559Z)20100925043847Y)20100814091104X)20100607044753W)20100606073747V)20100527113752U)20100525171356T)20100525124311S)20100321235924R)20100223121519Q)20100222124420P)20100211105551O)20100129142347N)20091214131723M)20091202124834L)20091025080447K)20091012101112J)20090831220301I)20090812151902H)20090720091429G)20090720091106F)20090719201843E)20090706125521D)20090705212043C)20090705133942B)20090519203307A)20090321130448@)20090208044541?)20081220034117>)20081220023628=)20081216190724<)20081216190517;)20081215094955:)200812150943029)200812121518208)200812121516147)200812120800386)200812120755545)200811171434554)200811171431563)200810300236152)200810300235181)200810300234120)20081028093607/)20081028083208.)20081028083142-)20081027150907,)20081025083905+)20081025083323*)20081023092436))20080905191442()20080830172106')20080830154109&)20080819181903%)20080606052544$154#149"146!145 14414213213113012912712512412112011711411311280777369
595547
+ |tld\TLD<4,$zgTA.
p
]
J
7
$
yfS@-o\I6#
+
+
+
+
+
+
+
+x
+e
+R
+?
+,
+
+ n [ H 5 " wdQ>*vbN:&r^J6"nZF2
+~jVB.zfR>* )20140823095740 )20140823094847 )20140823083524 )20140822114527 )20140813182425 )20140811031145 )20140810091417 )20140810091231 )20140810061942 )20140802082007 )20140721151416 )20140720170735 )20140720170714 )20140720140916 )20140709113905 )20140709113413 )20140628073535 )20140628073524 )20140628072217 )20140614141500 )20140614065404 )20140610123439 )20140528045617 )20140528045600 )20140528045539 )20140528045518 )20140524074813 )20140524020735 )20140519171220 )20140519170214 )20140518135713 )20140518111006 )20140518050147 )20140122054321 )20140110131010 )20140110122216 )20130509185724 )20130506175834 )20130506175303 )20130504195916 )20130504143515 )20130504133816 )20130429020822 )20130421164124 )20130421155019 )20130421093852 )20130416054135 )20130304015019 )20130303124821 )20130303104849 )20130221154434 )20121116031206 )20120602141129 )20120511072422 )20120510140958 )20120424103932 )20120418081407 )20120415164821 )20120415060342 )20120413170734 )20120413170720 )20120413170705 )20120413161403 )20120413161340 )20120413100431 )20120413100352 )20120413072700 )20120413051535 )20120410104851 )20120406020752 )20120319120638 )20120129020544)20120129014038~)20120125152919})20120125050502|)20120105101944{)20120105074911z)20111231145823y)20111218002349x)20111217234412w)20111201163718v)20111201155456u)20111201121844t)20111124112131s)20111124110355r)20111124110319q)20111124110059p)20110918162329o)20110916103953n)20110916091020m)20110913120629l)20110913115320k)20110627122938j)20110627035057i)20110627034940h)20110621093332g)20110620173525f)20110619064807e)20110603184217d)20110328130826c)20110318183304b)20110301134521a)20110301121550`)20110301035123_)20110222073537^)20101212070145])20100925074639\)20100925074559[)20100925043847Z)20100814091104Y)20100607044753X)20100606073747W)20100527113752V)20100525171356U)20100525124311T)20100321235924S)20100223121519R)20100222124420Q)20100211105551P)20100129142347O)20091214131723N)20091202124834M)20091025080447L)20091012101112K)20090831220301J)20090812151902I)20090720091429H)20090720091106G)20090706125521F)20090705212043E)20090705133942D)20090519203307C)20090321130448B)20090208044541A)20081220034117@)20081220023628?)20081216190724>)20081216190517=)20081215094955<)20081215094302;)20081212151820:)200812121516149)200812120800388)200812120755547)200811171434556)200811171431565)200810300236154)200810300235183)200810300234122)200810280936071)200810280832080)20081028083142/)20081027150907.)20081025083905-)20081025083323,)20081023092436+)20080905191442*)20080830172106))20080830154109()20080819181903')20080606052544&154%149$146#145"144!142 13413313213113012912712512412112011711411311280777369
595547
35 333229151265 1
q vg
i]Q
R 8Pq jJ/ AA
Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396oI/ % AA
オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396rh/ + AA
試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396rg/ + AA
作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396uf/ 1 AA
出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396 e/ + + 7 AA
! テスト名字テスト名前テスト正式名称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01w/ AA
! User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01
-/ # # AA
! New agent 5New agent 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 / # # AA
! New agent 4New agent 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/ # # AA
! New agent 3New agent 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/ # # AA
! New agent 2New agent 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/ # # AA
! New agent 1New agent 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01x/ AA
! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01/ ! ! AA ! Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-01/ '