spec/dummy/db/test.sqlite3 in enju_event-0.1.17.pre20 vs spec/dummy/db/test.sqlite3 in enju_event-0.1.17.pre21

- old
+ new

@@ -1,8 +1,8 @@ -SQLite format 3@ ·”·-â%œûöñìçâÝØÒÌÆÀº´®¨¢œ SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")„ +SQLite format 3@ ÀŸÀ-â%œûöñìçâÝØÒÌÆÀº´®¨¢œ SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e 5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")„ ‡mtableusersusers CREATE TABLE "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)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 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//tables‚ ûísÞfÍX°Eœ5&.~ lqX`IN6@"6% µyûöñìæàÚÔÎȼ¶°ª¤–ˆzsle^WPIB;)óáϽ«™‡ucQ?- ÷ å Ó Á ¯ ‹ y g U C 1  û é × Å ³ ¡ } k Y G 5 #  ÿ í Û É · ¥ “ o ] K 9 '   +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 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//tables‚û‚ísÞfÍX°Eœ5+.~ lqX`IN6@"6% ºûöñìæàÚÔÎȼ¶°ª¤–ˆzsle^WPIB;)óáϽ«™‡ucQ?- ÷ å Ó Á ¯ ‹ y g U C 1  û é × Å ³ ¡ } k Y G 5 #  ÿ í Û É · ¥ “ o ] K 9 '   ñ ß Í » © @@ -12,14 +12,14 @@ a O = +  - õ ã Ñ ¿ ­ › ‰ w e S A /  ùçÕñŸ{hUB/ öãнª—„q^K8%ÿìÙƳ zgTA.õâϼ©–ƒp]J7$þëØŲŸŒy5)201408140708544)201408121531373)201408121523482)201408110311451)201408100914170)20140810091231/)20140810061942.)20140802082007-)20140721151416,)20140720192418+)20140720170735*)20140720170714))20140720140916()20140709113905')20140709113413&)20140628073535%)20140628073524$)20140628072217#)20140628071719")20140614141500!)20140614065404 )20140610123439)20140528045617)20140528045600)20140528045539)20140528045518)20140524074813)20140524020735)20140523171309)20140519171220)20140519170214)20140518135713)20140518111006)20140122054321)20140110131010)20140110122216)20130519065837)20130519065638)20130509185724)20130506175834 )20130506175303 )20130429020822 )20130421164124 + õ ã Ñ ¿ ­ › ‰ w e S A /  ùçÕñŸ{hUB/ öãнª—„q^K8%ÿìÙƳ zgTA.õâϼ©–ƒp]J7$þëØŲŸŒyfS@-:)201408230957409)201408230948478)201408230835247)201408221145276)201408140708545)201408131824254)201408121531373)201408121523482)201408110311451)201408100914170)20140810091231/)20140810061942.)20140802082007-)20140721151416,)20140720192418+)20140720170735*)20140720170714))20140720140916()20140709113905')20140709113413&)20140628073535%)20140628073524$)20140628072217#)20140628071719")20140614141500!)20140614065404 )20140610123439)20140528045617)20140528045600)20140528045539)20140528045518)20140524074813)20140524020735)20140523171309)20140519171220)20140519170214)20140518135713)20140518111006)20140122054321)20140110131010)20140110122216)20130519065837)20130519065638)20130509185724)20130506175834 )20130506175303 )20130429020822 )20130421164124 )20130421155019 )20130421093852)20130416054135)20130412083556)20130304015019)20130303124821)20130303104849)20130221154434)20121116033446)20121116031206)20120602141129)20120511072422~)20120510140958})20120424103932|)20120418081407{)20120415164821z)20120415060342y)20120413170734x)20120413170720w)20120413170705v)20120413161403u)20120413161340t)20120413100352s)20120413072700r)20120413051535q)20120410104851p)20120319173203o)20120319120638n)20120129020544m)20120129014038l)20120125152919k)20120125050502j)20120105074911i)20111218002349h)20111217234412g)20111124112131f)20111124110355e)20111124110319d)20111124110059c)20110918162329b)20110916103953a)20110916091020`)20110913115320_)20110627122938^)20110627035057])20110627034940\)20110621093332[)20110620173525Z)20110619064807Y)20110603184217X)20110328130826W)20110318183304V)20110301134521U)20110301121550T)20110301035123S)20110222073537R)20101212070145Q)20100925074639P)20100925074559O)20100925043847N)20100814091104M)20100607044753L)20100606073747K)20100606065209J)20100525124311I)20100321235924H)20100314190054G)20100223121519F)20100211105551E)20100129142347D)20091214131723C)20091202124834B)20091025080447A)20091012101112@)20090831220301?)20090812151902>)20090720091429=)20090720091106<)20090719201843;)20090705212043:)200907051339429)200905192033078)200903211304487)200812200341176)200812200236285)200812161907244)200812161905173)200812150949552)200812150943021)200812120800380)20081212075554/)20081030023615.)20081030023518-)20081030023412,)20081028093607+)20081028083208*)20081028083142))20081027150907()20081025083905')20081025083323&)20081023092436%)20081006093246$)20081006090811#)20080905191442")20080830172106!)20080830154109 )20080819181903154149132131130129127125124121120117114113112807773 69 59 47 41 35333215126521 -µÅû…}uâme]UME=5-%Ûõ +ºaû…}uâme]UME=5-%Ûõ ÷äѾ«˜…r_L9& í Ú Ç ´ ¡ Ž { h U B /  ö ã Ð ½ ª — „ q ^ K 8 %  ÿ ì Ù Æ ³   z g T A .   õ â Ï ¼ @@ -29,19 +29,31 @@ p ] J 7 $ - þ ë Ø Å ² Ÿ Œ y f S @ -  ôá먕‚o\I6#ýéÕÁ­™…q]I5! ùåѽ©•mYE1 õá͹¥‘}iUA-ñÝɵ¡yeQ=)íÙÅÔÍÆ¿¸ï±éª£œ•)20140814070854µ)20140812153137´)20140812152348³)20140811031145²)20140810091417±)20140810091231°)20140810061942¯)20140802082007®)20140721151416­)20140720192418¬)20140720170735«)20140720170714ª)20140720140916©)20140709113905¨)20140709113413§)20140628073535¦)20140628073524¥)20140628072217¤)20140628071719£)20140614141500¢)20140614065404¡)20140610123439 )20140528045617Ÿ)20140528045600ž)20140528045539)20140528045518œ)20140524074813›)20140524020735š)20140523171309™)20140519171220˜)20140519170214—)20140518135713–)20140518111006•)20140122054321”)20140110131010“)20140110122216’)20130519065837‘)20130519065638)20130509185724)20130506175834Ž)20130506175303)20130429020822Œ)20130421164124‹)20130421155019Š)20130421093852‰)20130416054135ˆ)20130412083556‡)20130304015019†)20130303124821…)20130303104849„)20130221154434ƒ)20121116033446‚)20121116031206)20120602141129€)20120511072422)20120510140958~)20120424103932})20120418081407|)20120415164821{)20120415060342z)20120413170734y)20120413170720x)20120413170705w)20120413161403v)20120413161340u)20120413100352t)20120413072700s)20120413051535r)20120410104851q)20120319173203p)20120319120638o)20120129020544n)20120129014038m)20120125152919l)20120125050502k)20120105074911j)20111218002349i)20111217234412h)20111124112131g)20111124110355f)20111124110319e)20111124110059d)20110918162329c)20110916103953b)20110916091020a)20110913115320`)20110627122938_)20110627035057^)20110627034940])20110621093332\)20110620173525[)20110619064807Z)20110603184217Y)20110328130826X)20110318183304W)20110301134521V)20110301121550U)20110301035123T)20110222073537S)20101212070145R)20100925074639Q)20100925074559P)20100925043847O)20100814091104N)20100607044753M)20100606073747L)20100606065209K)20100525124311J)20100321235924I)20100314190054H)20100223121519G)20100211105551F)20100129142347E)20091214131723D)20091202124834C)20091025080447B)20091012101112A)20090831220301@)20090812151902?)20090720091429>)20090720091106=)20090719201843<)20090705212043;)20090705133942:)200905192033079)200903211304488)200812200341177)200812200236286)200812161907245)200812161905174)200812150949553)200812150943022)200812120800381)200812120755540)20081030023615/)20081030023518.)20081030023412-)20081028093607,)20081028083208+)20081028083142*)20081027150907))20081025083905()20081025083323')20081023092436&)20081006093246%)20081006090811$)20080905191442#)20080830172106")20080830154109!)20080819181903 15414913213113012912712512412112011711411311280777369 59 47 41 -35 33321512652 1   - - - - -  - -  ‘ ?`±@ Ê W Ñ a?üü† + þ ë Ø Å ² Ÿ Œ y f S @ -  ôá먕‚o\I6#ýéÕÁ­™…q]I5! ùåѽ©•mYE1 õá͹¥‘}iUA-ñÝɵ¡yeQ=)íÙű‰uaÔÍÆ¿¸ï±éª£œ•)20140823095740º)20140823094847¹)20140823083524¸)20140822114527·)20140814070854¶)20140813182425µ)20140812153137´)20140812152348³)20140811031145²)20140810091417±)20140810091231°)20140810061942¯)20140802082007®)20140721151416­)20140720192418¬)20140720170735«)20140720170714ª)20140720140916©)20140709113905¨)20140709113413§)20140628073535¦)20140628073524¥)20140628072217¤)20140628071719£)20140614141500¢)20140614065404¡)20140610123439 )20140528045617Ÿ)20140528045600ž)20140528045539)20140528045518œ)20140524074813›)20140524020735š)20140523171309™)20140519171220˜)20140519170214—)20140518135713–)20140518111006•)20140122054321”)20140110131010“)20140110122216’)20130519065837‘)20130519065638)20130509185724)20130506175834Ž)20130506175303)20130429020822Œ)20130421164124‹)20130421155019Š)20130421093852‰)20130416054135ˆ)20130412083556‡)20130304015019†)20130303124821…)20130303104849„)20130221154434ƒ)20121116033446‚)20121116031206)20120602141129€)20120511072422)20120510140958~)20120424103932})20120418081407|)20120415164821{)20120415060342z)20120413170734y)20120413170720x)20120413170705w)20120413161403v)20120413161340u)20120413100352t)20120413072700s)20120413051535r)20120410104851q)20120319173203p)20120319120638o)20120129020544n)20120129014038m)20120125152919l)20120125050502k)20120105074911j)20111218002349i)20111217234412h)20111124112131g)20111124110355f)20111124110319e)20111124110059d)20110918162329c)20110916103953b)20110916091020a)20110913115320`)20110627122938_)20110627035057^)20110627034940])20110621093332\)20110620173525[)20110619064807Z)20110603184217Y)20110328130826X)20110318183304W)20110301134521V)20110301121550U)20110301035123T)20110222073537S)20101212070145R)20100925074639Q)20100925074559P)20100925043847O)20100814091104N)20100607044753M)20100606073747L)20100606065209K)20100525124311J)20100321235924I)20100314190054H)20100223121519G)20100211105551F)20100129142347E)20091214131723D)20091202124834C)20091025080447B)20091012101112A)20090831220301@)20090812151902?)20090720091429>)20090720091106=)20090719201843<)20090705212043;)20090705133942:)200905192033079)200903211304488)200812200341177)200812200236286)200812161907245)200812161905174)200812150949553)200812150943022)200812120800381)200812120755540)20081030023615/)20081030023518.)20081030023412-)20081028093607,)20081028083208+)20081028083142*)20081027150907))20081025083905()20081025083323')20081023092436&)20081006093246%)20081006090811$)20080905191442#)20080830172106")20080830154109!)20080819181903 15414913213113012912712512412112011711411311280777369 59 47 41 +35 33321512652 1 `uïd ß d Ý V Ï H +G £ +¶AÎ`kJ0kJ0AA  Ruby社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396pI0%AA  オーム社2010-03-15 08:00:00.5793962010-03-15 08:00:00.579396sh0+AA  試験用会社2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396sg0+AA  作者ダミー2010-03-16 10:00:00.5793962010-03-16 10:00:00.579396vf01AA  出版社テスト2010-03-03 08:00:00.5793962010-03-03 08:00:00.579396!e0++7AA !  テストå字テストåå‰ãƒ†ã‚¹ãƒˆæ­£å¼å称2010-03-03 08:00:00.5793962010-03-03 08:00:00.5793962000-01-01x 0AA !  User3User32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 +0##AA !  New agent 5New agent 52007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01 0##AA !  New agent 4New agent 42007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-010##AA !  New agent 3New agent 32007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-010##AA !  New agent 2New agent 22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-010##AA !  New agent 1New agent 12007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-01y0AA ! User2User22007-11-19 08:24:50.1534172007-11-21 13:02:35.5793962000-01-010!!AA!  Librarian2Librarian22007-12-04 07:25:01.7850272007-12-04 07:25:01.7850272000-01-010'AA! KosukeTanabeKosuke Tanabe2007-12-04 07:25:01.5236182007-12-04 07:25:01.5236182000-01-010!!AA ! Librarian1Librarian12007-11-19 08:06:07.7245172007-11-21 13:02:10.3597932000-01-010''AA !  AdministratorAdministrator2007-11-19 08:06:06.5072372007-11-21 13:01:56.1374092000-01-01 ¯ïâÒ¼¤ŒrfVG4úïâѺ¯ users)user_has_roles<;qÝ#user_groups shelves roles profiles %participates:l†ò /message_templates ) library_groups +libraries languages¼ +events5event_import_results1event_import_files1event_export_files-event_categoriescountriesã agentsÊ#agent_types +ªü÷òíèãÞÙÔÏÊÅÀ»¶°ªÊÉhgfe  +  +ªü÷òíèãÞÙÔÏÊÅÀ»¶°ª Ê É h g f e    +          +ªü÷òíèãÞÙÔÏÊÅÀ»¶°ª Ê É h g f e    +          +§üëàÛÖÑÌǽ¸³­§åðö Ê É h g f e    +       +ãïÎà¿¥•…ueãµ[ðA* Ruby社Ê%オーム社É+試験用会社h+作者ダミーg1出版社テストf7テスト正å¼å称e User3 #New agent 5 +#New agent 4 #New agent 3#New agent 2#New agent 1 User2!Librarian2'Kosuke Tanabe!Librarian1' Administrator  +£TŸ ô A ˜ © +£‚A‚ AA;user4@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fuser42014-09-15 13:20:21 UTClA‚ AAuser3@kamata.lib.teu.ac.jpcc53de0c2d9a1a228daa9a673ec824473747e17507a6c3c4f7e5eff8821f531d4b9e23616b3ddc66fe17006b2298a556fbd567ac080e87f00f37eef8cee6c4172007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fuser3&=AAuser2@library.example.jp$2a$10$i7UjJhLVrJM/J7qaTwW39OXw1NiwowUEbtNHVDV0sqMLjX9.UO9ca2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117fuser20GAA!librarian2@library.example.jp$2a$10$YmmTGrYQ1Ir6oc7wXnp.GuNeO1eYLoP3sv8wMSIrTdaGw2BPwRrpS2008-01-18 03:24:04.2223442008-05-31 03:42:23.340575flibrarian2(AAAuser1@kamata.lib.teu.ac.jp$2a$10$JthS59A0BNkDOoFpCXM0V.GhhffKaoWKbzpPahYp/vTFrOyM7h/uW2007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fuser12KAA!librarian1@kamata.lib.teu.ac.jp$2a$10$9O2VuTccN4gHq36ARg0QReSrb1D7WrBBhZZ759RM9moHbB0W5zCzS2007-11-19 07:58:33.1724412008-05-31 03:41:16.337474flibrarian1)CAAtanabe@kamata.lib.teu.ac.jp$2a$10$vHohD1WflnTIqAa8zMkF9evwAgIZRw3XuR4d3bi29M.jph/MB/AJi2007-11-19 07:58:32.1119412008-05-31 04:16:30.163731fadmin +!½|áž_@!Auser4@kamata.lib.teu.ac.jpAuser3@kamata.lib.teu.ac.jp=user2@library.example.jp!Glibrarian2@library.example.jpAuser1@kamata.lib.teu.ac.jp#Klibrarian1@kamata.lib.teu.ac.jpC tanabe@kamata.lib.teu.ac.jp +Þü÷òíèãÞ  ‘ ?`±@ Ê W Ñ a?üü† Œtableusersusers CREATE TABLE "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, "save_checkout_history" boolean DEFAULT 'f' NOT NULL, "checkout_icalendar_token" varchar(255), "username" varchar(255), "deleted_at" datetime, "expired_at" datetime, "failed_attempts" integer DEFAULT 0, "unlock_token" varchar(255), "locked_at" datetime, "confirmed_at" datetime)‹– 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 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, "full_name_alternative_transcription" text, "birth_date" varchar(255), "death_date" varchar(255), "agent_identifier" varchar(255)) SGindexindex_users_on_reset_password_tokenusers CREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")Ð5 indexindex_users_on_emailusers CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email")i‰+tableusersusers CREATE TABLE "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, "save_checkout_history" boolean DEFAULT 'f' NOT NULL, "checkout_icalendar_token" varchar(255))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)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) —˜ ® I ç Ú i û Þ lësàjôxÑK†/Œ=tableitemsitemsCREATE TABLE "items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "call_number" varchar(255), "item_identifier" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "shelf_id" integer DEFAULT 1 NOT NULL, "include_supplements" boolean DEFAULT 'f' NOT NULL, "note" text, "url" varchar(255), "price" integer, "lock_version" integer DEFAULT 0 NOT NULL, "required_role_id" integer DEFAULT 1 NOT NULL, "required_score" integer DEFAULT 0 NOT NULL, "acquired_at" datetime, "bookstore_id" integer, "budget_type_id" integer, "circulation_status_id" integer DEFAULT 5 NOT NULL, "checkout_type_id" integer DEFAULT 1 NOT NULL, "binding_item_identifier" varchar(255), "binding_call_number" varchar(255), "binded_at" datetime, "manifestation_id" integer)%K)indexindex_checkouts_on_librarian_idcheckouts)CREATE INDEX "index_checkouts_on_librarian_id" ON "checkouts" ("librarian_id")$$]Yindexindex_checkouts_on_item_id_and_basket_idcheckouts(CREATE UNIQUE INDEX "index_checkouts_on_item_id_and_basket_id" ON "checkouts" ("item_id", "basket_id")z#Eindexindex_checkouts_on_basket_idcheckouts'CREATE INDEX "index_checkouts_on_basket_id" ON "checkouts" ("basket_id")t"Aindexindex_checkouts_on_item_idcheckouts&CREATE INDEX "index_checkouts_on_item_id" ON "checkouts" ("item_id")t!Aindexindex_checkouts_on_user_idcheckouts%CREATE INDEX "index_checkouts_on_user_id" ON "checkouts" ("user_id")ƒ …otablecheckoutscheckouts$CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "item_id" integer NOT NULL, "checkin_id" integer, "librarian_id" integer, "basket_id" integer, "due_date" datetime, "checkout_renewal_count" integer DEFAULT 0 NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)vCindexindex_checkins_on_basket_idcheckins#CREATE INDEX "index_checkins_on_basket_id" ON "checkins" ("basket_id")I%indexindex_checkins_on_librarian_idcheckins!CREATE INDEX "index_checkins_on_librarian_id" ON "checkins" ("librarian_id")p?indexindex_checkins_on_item_idcheckins CREATE INDEX "index_checkins_on_item_id" ON "checkins" ("item_id")‚„tablecheckinscheckinsCREATE TABLE "checkins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "librarian_id" integer, "basket_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lock_version" integer DEFAULT 0 NOT NULL)l= indexindex_creates_on_work_idcreatesCREATE INDEX "index_creates_on_work_id" ON "creates" ("work_id")o?indexindex_creates_on_agent_idcreatesCREATE INDEX "index_creates_on_agent_id" ON "creates" ("agent_id")‚ ƒktablecreatescreatesCREATE TABLE "creates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "work_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "create_type_id" integer)`7indexindex_owns_on_item_idownsCREATE INDEX "index_owns_on_item_id" ON "owns" ("item_id")c9indexindex_owns_on_agent_idownsCREATE INDEX "index_owns_on_agent_id" ON "owns" ("agent_id")gƒ1tableownsownsCREATE TABLE "owns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "item_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)K)indexindex_items_on_required_role_iditemsCREATE INDEX "index_items_on_required_role_id" ON "items" ("required_role_id")|I%indexindex_items_on_item_identifieritemsCREATE INDEX "index_items_on_item_identifier" ON "items" ("item_identifier")g; indexindex_items_on_shelf_iditemsCREATE INDEX "index_items_on_shelf_id" ON "items" ("shelf_id")  @@ -64,163 +76,853 @@       - ÔóS‡[ •  - B P /‚A11„+tableuser_reserve_statsuser_reserve_stats˜CREATE TABLE "user_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)CC„tablemanifestation_reserve_statsmanifestation_reserve_stats—CREATE TABLE "manifestation_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "‚\ CC„=tablemanifestation_reserve_statsmanifestation_reserve_stats—CREATE TABLE "manifestation_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)‚099ƒytablereserve_stat_has_usersreserve_stat_has_users™CREATE TABLE "reserve_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_reserve_stat_id" integer NOT NULL, "user_id" integer NOT NULL, "reserves_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Pu9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_usersšCREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users" ("user_reserve_stat_id"))[9Iindexindex_reserve_stat_has_users_on_user_idreserve_stat_has_users›CREATE INDEX "index_reserve_stat_has_users_on_user_id" ON "reserve_stat_has_users" ("user_id")‚%%ƒCtableparticipatesparticipatesCREATE TABLE "participates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_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")I%%indexindex_participates_on_agent_idparticipatesŸCREATE INDEX "index_participates_on_agent_id" ON "participates" ("agent_id")xƒEtableextentsextents CREATE TABLE "extents" ("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)‚%99ƒctablemedium_of_performancesmedium_of_performances¡CREATE TABLE "medium_of_performances" ("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)‚ -''ƒQtablecontent_typescontent_types¢CREATE TABLE "content_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)‚+==ƒgtableagent_relationship_typesagent_relationship_types£CREATE TABLE "agent_relationship_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)ƒ,--† tablelending_policieslending_policies¤CREATE TABLE "lending_policies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "user_group_id" integer NOT NULL, "loan_period" integer DEFAULT 0 NOT NULL, "fixed_due_date" datetime, "renewal" integer DEFAULT 0 NOT NULL, "fine" integer DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Ms-‚indexindex_lending_policies_on_item_id_and_user_group_idlending_policies¥CREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id") ---,+   + ß$X,ÙÞ f î +ê  !P/‚A11„+tableuser_reserve_statsuser_reserve_stats˜CREATE TABLE "user_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)CC„tablemanifestation_reserve_statsmanifestation_reserve_stats—CREATE TABLE "manifestation_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start‚\ CC„=tablemanifestation_reserve_statsmanifestation_reserve_stats—CREATE TABLE "manifestation_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)‚A11„+tableuser_reserve_statsuser_reserve_stats˜CREATE TABLE "user_reserve_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)‚099ƒytablereserve_stat_has_usersreserve_stat_has_users™CREATE TABLE "reserve_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_reserve_stat_id" integer NOT NULL, "user_id" integer NOT NULL, "reserves_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Pu9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_usersšCREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users" ("user_reserve_stat_id"))[9Iindexindex_reserve_stat_has_users_on_user_idreserve_stat_has_users›CREATE INDEX "index_reserve_stat_has_users_on_user_id" ON "reserve_stat_has_users" ("user_id")‚%%ƒCtableparticipatesparticipatesCREATE TABLE "participates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_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")I%%indexindex_participates_on_agent_idparticipatesŸCREATE INDEX "index_participates_on_agent_id" ON "participates" ("agent_id")xƒEtableextentsextents CREATE TABLE "extents" ("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)‚%99ƒctablemedium_of_performancesmedium_of_performances¡CREATE TABLE "medium_of_performances" ("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)‚ +''ƒQtablecontent_typescontent_types¢CREATE TABLE "content_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)‚+==ƒgtableagent_relationship_typesagent_relationship_types£CREATE TABLE "agent_relationship_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)ƒ,--† tablelending_policieslending_policies¤CREATE TABLE "lending_policies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "user_group_id" integer NOT NULL, "loan_period" integer DEFAULT 0 NOT NULL, "fixed_due_date" datetime, "renewal" integer DEFAULT 0 NOT NULL, "fine" integer DEFAULT 0 NOT NULL, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +--,+ þÅŒIþI ''33AdministratorAdministrator2014-09-16 13:20:212014-09-16 13:20:21A 33LibrarianLibrarian2014-09-16 13:20:212014-09-16 13:20:217 33UserUser2014-09-16 13:20:212014-09-16 13:20:219 33GuestGuest2014-09-16 13:20:212014-09-16 13:20:21   +  í› h íy%  AAmitaMita Library三田108-8345MinatoTokyo|2007-08-23 10:51:00.0000002007-08-30 15:18:20.043951-% %  AAhachiojiHachioji 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-0000000c)   AAwebWorld Wide WebWeb|2007-08-13 09:10:00.0000002007-08-30 15:18:06.662349 +íü÷òí    +’’Pä ê „ ÷ € •¡’ •¡’6à##‡tableuser_groupsuser_groups;CREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL)‚=--ƒWtableevent_categoriesevent_categoriesBCREATE TABLE "event_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "noteu4Cindexindex_shelves_on_library_idshelves9CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")‚ 5''ƒQtablecarrier_typescarrier_types:CREATE TABLE "carrier_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)„6##‡tableuser_groupsuser_groups;CREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL)ƒ;7))†1tablelibrary_groupslibrary_groups<CREATE TABLE "library_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_name" varchar(255) NOT NULL, "my_networks" text, "login_banner" text, "note" text, "country_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "admin_networks" text, "url" varchar(255) DEFAULT 'http://localhost:3000/')8Q)5indexindex_library_groups_on_short_namelibrary_groups=CREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")‚9##ƒMtablefrequenciesfrequencies>CREATE TABLE "frequencies" ("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)ƒ:† tableeventsevents?CREATE 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)q;Aindexindex_events_on_library_idevents@CREATE INDEX "index_events_on_library_id" ON "events" ("library_id")<O1indexindex_events_on_event_category_ideventsACREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")‚=--ƒWtableevent_categoriesevent_categoriesBCREATE 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)‚ >''ƒQtableform_of_worksform_of_worksCCREATE TABLE "form_of_works" ("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)n?ƒ3tablebasketsbasketsDCREATE TABLE "baskets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l@= indexindex_baskets_on_user_idbasketsECREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id") +ØáîØùmita hachioji +kamata web ϸkÏK ##33third_shelfThird shelf2014-09-16 13:20:212014-09-16 13:20:21fM %%33second_shelfSecond shelf2014-09-16 13:20:212014-09-16 13:20:21fK ##33first_shelfFirst shelf2014-09-16 13:20:212014-09-16 13:20:21fF -  33webLibrary bookmark2014-09-16 13:20:212014-09-16 13:20:21f +êüöðê  úžOúS AA facultyFaculty2007-12-22 18:15:05.1264572007-12-22 18:15:05.134351M AA userUser2007-12-22 18:14:40.1739542007-12-22 18:14:56.836548`'+ AA not_specified(not specified)2007-12-13 12:00:01.6749762007-12-13 12:00:51.564542 ––h339unknownunknownunknown0.0.0.0/02014-09-16 13:20:212014-09-16 13:20:21http://localhost:3000/ +õõ + unknown   *V¥ b á 6 ° *  AAAAtesttest2008-02-05 06:00:00.0000002008-02-05 06:00:00.000000ftest2008-02-05 12:00:53.9260502008-02-05 12:00:53.926050  AAAAtesttest2008-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   AAAAtest2008-02-04 15:00:00.0000002008-02-07 15:00:00.000000ftest2008-02-05 11:41:50.5331642008-02-05 11:41:50.533164" =AAAAテストãªã‚“ã¨ã‹ã‹ã‚“ã¨ã‹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 AA1AAミーティング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. UAAAAテストテスト用ã®ã‚¤ãƒ™ãƒ³ãƒˆã§ã™ã€‚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 +ÑûõïãÝ×Ñé  +ÖüñæÛÖöàë     `¬^²`P! AAtalk_event講演会2008-01-01 07:25:04.2511412008-01-01 07:25:04.251141S' AAmovie_theater上映会2008-01-01 07:18:08.8686802008-01-01 07:24:55.261682U+ AAbook_talkãŠã¯ãªã—会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.561469R+ AAunknown(not specified)2008-01-01 07:17:12.5495652008-01-01 07:24:17.869192     - -¦¦dø þ „ ÷ € •¡’ •¡’J„6##‡tableuser_groupsuser_groups;CREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL)‚=--ƒWtableevent_categoriesevent_categoriesBCREATE TABLE "event_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "noteu4Cindexindex_shelves_on_library_idshelves9CREATE INDEX "index_shelves_on_library_id" ON "shelves" ("library_id")‚ 5''ƒQtablecarrier_typescarrier_types:CREATE TABLE "carrier_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)„6##‡tableuser_groupsuser_groups;CREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "deleted_at" datetime, "valid_period_for_new_user" integer DEFAULT 0 NOT NULL, "expired_at" datetime, "number_of_day_to_notify_overdue" integer DEFAULT 1 NOT NULL, "number_of_day_to_notify_due_date" integer DEFAULT 7 NOT NULL, "number_of_time_to_notify_overdue" integer DEFAULT 3 NOT NULL)ƒ;7))†1tablelibrary_groupslibrary_groups<CREATE TABLE "library_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "short_name" varchar(255) NOT NULL, "my_networks" text, "login_banner" text, "note" text, "country_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "admin_networks" text, "url" varchar(255) DEFAULT 'http://localhost:3000/')8Q)5indexindex_library_groups_on_short_namelibrary_groups=CREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")‚9##ƒMtablefrequenciesfrequencies>CREATE TABLE "frequencies" ("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)ƒ:…atableeventsevents?CREATE TABLE "events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_id" integer NOT NULL, "event_category_id" integer 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)q;Aindexindex_events_on_library_idevents@CREATE INDEX "index_events_on_library_id" ON "events" ("library_id")<O1indexindex_events_on_event_category_ideventsACREATE INDEX "index_events_on_event_category_id" ON "events" ("event_category_id")‚=--ƒWtableevent_categoriesevent_categoriesBCREATE 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)‚ >''ƒQtableform_of_worksform_of_worksCCREATE TABLE "form_of_works" ("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)n?ƒ3tablebasketsbasketsDCREATE TABLE "baskets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l@= indexindex_baskets_on_user_idbasketsECREATE INDEX "index_baskets_on_user_id" ON "baskets" ("user_id") -  -    -    -    -  -  §.»1ï  # Ú ² Óß ² ÓßTP8‚ M''ƒQtablerequePO/?indexindex_message_templates_on_statusmessage_templatesVCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status")n?ƒ3tablebasketsbasketsDCREATE TABLE "baskets" ("id" IN‚ >''ƒQtableform_of_worksform_of_worksCCREATE TABLE "form_of_works" ("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)n?ƒ3tablebasketsbasketsDCREATE TABLE "baskets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "lock_version" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l@= indexindex_baskets_on_user_idbasketsECREATE INDEX "index_baskets_on_user_id" ‚%A''„ tablechecked_itemschecked_itemsFCREATE TABLE "checked_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "basket_id" integer NOT NULL, "due_date" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "librarian_id" integer)BI'%indexindex_checked_items_on_item_idchecked_itemsGCREATE INDEX "index_checked_items_on_item_id" ON "checked_items" ("item_id") CM'-indexindex_checked_items_on_basket_idchecked_itemsHCREATE INDEX "index_checked_items_on_basket_id" ON "checked_items" ("basket_id")‚sD!!…1tablebookstoresbookstoresJCREATE TABLE "bookstores" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" text NOT NULL, "zip_code" varchar(255), "address" text, "note" text, "telephone_number" varchar(255), "fax_number" varchar(255), "url" varchar(255), "position" integer, "deleted_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)\EƒtabledonatesdonatesKCREATE TABLE "donates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "item_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)oF?indexindex_donates_on_agent_iddonatesLCREATE INDEX "index_donates_on_agent_id" ON "donates" ("agent_id")lG= indexindex_donates_on_item_iddonatesMCREATE INDEX "index_donates_on_item_id" ON "donates" ("item_id")‚H--ƒWtableuse_restrictionsuse_restrictionsNCREATE TABLE "use_restrictions" ("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)‚I??ƒGtableitem_has_use_restrictionsitem_has_use_restrictionsOCREATE TABLE "item_has_use_restrictions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_id" integer NOT NULL, "use_restriction_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)4Ja?Uindexindex_item_has_use_restrictions_on_item_iditem_has_use_restrictionsPCREATE INDEX "index_item_has_use_restrictions_on_item_id" ON "item_has_use_restrictions" ("item_id")UKw?‚indexindex_item_has_use_restrictions_on_use_restriction_iditem_has_use_restrictionsQCREATE INDEX "index_item_has_use_restrictions_on_use_restriction_id" ON "item_has_use_restrictions" ("use_restriction_id")‚L55ƒ_tablerequest_status_typesrequest_status_typesRCREATE TABLE "request_status_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)‚ M''ƒQtablerequest_typesrequest_typesSCREATE TABLE "request_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)‚N55ƒ_tablecirculation_statusescirculation_statusesTCREATE TABLE "circulation_statuses" ("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)        -     -  ß‚ûD‚)¡³+ k à +    ñnèP · $ ; Î : +% – ‡ñ -[a33export_completedエクスãƒãƒ¼ãƒˆãŒå®Œäº†ã—ã¾ã—ãŸã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå®Œäº†ã—ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21} 1CI33counting_completed集計ãŒå®Œäº†ã—ã¾ã—ãŸé›†è¨ˆãŒå®Œäº†ã—ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 -U[33import_completedインãƒãƒ¼ãƒˆãŒå®Œäº†ã—ã¾ã—ãŸã‚¤ãƒ³ãƒãƒ¼ãƒˆãŒå®Œäº†ã—ã¾ã—ãŸã€‚ ja2014-09-16 13:20:212014-09-16 13:20:21 OCI33reservation_postponed_for_library予約を延期ã—ã¾ã—ãŸäºˆç´„を延期ã—ã¾ã—ãŸã€‚ ja2014-09-16 13:20:212014-09-16 13:20:21 MCI33reservation_postponed_for_patron予約を延期ã—ã¾ã—ãŸäºˆç´„を延期ã—ã¾ã—ãŸã€‚ ja2014-09-16 13:20:212014-09-16 13:20:21 + ?CI33item_received_for_library資料を確ä¿ã—ã¾ã—ãŸè³‡æ–™ã‚’確ä¿ã—ã¾ã—ãŸã€‚ +ja2014-09-16 13:20:212014-09-16 13:20:21 MIO33reservation_accepted_for_library予約をå—ã‘付ã‘ã¾ã—ãŸäºˆç´„ã‚’å—ã‘付ã‘ã¾ã—ãŸã€‚ ja2014-09-16 13:20:212014-09-16 13:20:21k 33333recall_overdue_itemRecall overdue itemRecall overdue itemja2014-09-16 13:20:212014-09-16 13:20:21S ###33recall_itemRecall itemRecall itemja2014-09-16 13:20:212014-09-16 13:20:21 MIO33reservation_canceled_for_library予約をå–り消ã—ã¾ã—ãŸäºˆç´„ã‚’å–り消ã—ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 KIO33reservation_canceled_for_patron予約をå–り消ã—ã¾ã—ãŸäºˆç´„ã‚’å–り消ã—ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 KOU33reservation_expired_for_library予約ã®æœŸé™ãŒåˆ‡ã‚Œã¾ã—ãŸäºˆç´„ã®æœŸé™ãŒåˆ‡ã‚Œã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 IOU33reservation_expired_for_patron予約ã®æœŸé™ãŒåˆ‡ã‚Œã¾ã—ãŸäºˆç´„ã®æœŸé™ãŒåˆ‡ã‚Œã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 =CI33item_received_for_patron資料を確ä¿ã—ã¾ã—ãŸè³‡æ–™ã‚’確ä¿ã—ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 KIO 33reservation_accepted_for_patron予約をå—ã‘付ã‘ã¾ã—ãŸäºˆç´„ã‚’å—ã‘付ã‘ã¾ã—ãŸã€‚ja2014-09-16 13:20:212014-09-16 13:20:21 +9N9eÅÀ ãÝ0Uyz -export_completed1counting_completed-import_completed %Oreservation_postponed_for_library $Mreservation_postponed_for_patron ?item_received_for_library +$Mreservation_accepted_for_library 3recall_overdue_item#recall_item$Mreservation_canceled_for_library#Kreservation_canceled_for_patron#Kreservation_expired_for_library"Ireservation_expired_for_patron=item_received_for_patron"K reservation_accepted_for_patron  ß‚ûD‚)¡³+ k à e l  Œ ’àgDm ‚FO//„;tablemessage_templatesmessage_templatesUCREATE TABLE "mes‚vQ…?tablemessagesmessagesWCREATE TABLE "messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "read_at" datetime, "receiver_id" integer, "sender_id" integer, "subject" varchar(255) NOT NULL, "body" text, "message_request_id" integer, "parent_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "lft" integer, "rgt" integer, "depth" integer)‚FO//„;tablemessage_templatesmessage_templatesUCREATE TABLE "message_templates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "status" varchar(255) NOT NULL, "title" text NOT NULL, "body" text NOT NULL, "position" integer, "locale" varchar(255) DEFAULT 'en', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)PO/?indexindex_message_templates_on_statusmessage_templatesVCREATE UNIQUE INDEX "index_message_templates_on_status" ON "message_templates" ("status")o3„atablemessagesmessagesWCREATE TABLE "messa‚Wƒ{tablerealizesrealizes^CREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "realize_type_id" integer)vRCindexindex_messages_on_sender_idmessagesYCREATE INDEX "index_messages_on_sender_id" ON "messages" ("sender_id")|SG!indexindex_messages_on_receiver_idmessagesZCREATE INDEX "index_messages_on_receiver_id" ON "messages" ("receiver_id")TU=indexindex_messages_on_message_request_idmessages[CREATE INDEX "index_messages_on_message_request_id" ON "messages" ("message_request_id")vUCindexindex_messages_on_parent_idmessages\CREATE INDEX "index_messages_on_parent_id" ON "messages" ("parent_id")‚AV--„5tablemessage_requestsmessage_requests]CREATE TABLE "message_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender_id" integer, "receiver_id" integer, "message_template_id" integer, "sent_at" datetime, "deleted_at" datetime, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)üƒEtablerealizesrealizes^CREATE TABLE "realizes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_id" integer NOT NULL, "expression_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)sXAindexindex_realizes_on_agent_idrealizes_CREATE INDEX "index_realizes_on_agent_id" ON "realizes" ("agent_id")YK)indexindex_realizes_on_expression_idrealizes`CREATE INDEX "index_realizes_on_expression_id" ON "realizes" ("expression_id")‚Z##ƒOtableexemplifiesexemplifiesaCREATE TABLE "exemplifies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer NOT NULL, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)[W#Aindexindex_exemplifies_on_manifestation_idexemplifiesbCREATE INDEX "index_exemplifies_on_manifestation_id" ON "exemplifies" ("manifestation_id")\E#+indexindex_exemplifies_on_item_idexemplifiescCREATE UNIQUE INDEX "index_exemplifies_on_item_id" ON "exemplifies" ("item_id")‚]##ƒMtableagent_typesagent_typesdCREATE TABLE "agent_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)‚K^''„UtablesubscriptionssubscriptionseCREATE TABLE "subscriptions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" text NOT NULL, "note" text, "user_id" integer, "order_list_id" integer, "deleted_at" datetime, "subscribes_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)_I'%indexindex_subscriptions_on_user_idsubscriptionsfCREATE INDEX "index_subscriptions_on_user_id" ON "subscriptions" ("user_id")`U'=indexindex_subscriptions_on_order_list_idsubscriptionsgCREATE INDEX "index_subscriptions_on_order_list_id" ON "subscriptions" ("order_list_id")           -   + 4Äy4C!!33ConferenceConference2014-09-16 13:20:212014-09-16 13:20:21I''33CorporateBodyCorporateBody2014-09-16 13:20:212014-09-16 13:20:21: 33PersonPerson2014-09-16 13:20:212014-09-16 13:20:21        ý×D Ê 1 ' º -D Î R(´8¼@*Lý„Lq11ˆCtableagent_import_filesagent_import_filesyCREATE TABLE "agent_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "agent_import_file_name" varchar(255), "agent_import_content_type" varchar(255), "agent_import_file_size" integer, "agent_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "agent_import_fingerprint" varchar(255), "error_message" text, "edit_mode" varchar(255), "user_encoding" varchar(255))[pw'‚%indexindex_picture_files_on_picture_attachable_id_and_typepicture_filesxCREATE INDEX "index_picture_files_on_picture_attachable_id_and_type" ON "picture_files" ("picture_attachable_id", "picture_attachable_type")„o''‡etablepicture_filespicture_fileswCREATE TABLE "picture_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "picture_attachable_id" integer, "picture_attachable_type" varchar(255), "content_type" varchar(255), "title" text, "thumbnail" varchar(255), "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "picture_file_name" varchar(255), "picture_content_type" varchar(255), "picture_file_size" integer, "picture_updated_at" datetime, "picture_meta" text, "picture_fingerprint" varchar(255))znEindexindex_languages_on_iso_639_3languagesvCREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")zmEindexindex_languages_on_iso_639_2languagesuCREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")zlEindexindex_languages_on_iso_639_1languagestCREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")rk;indexindex_languages_on_namelanguagessCREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")‚'j„tablelanguageslanguagesrCREATE 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)ziEindexindex_countries_on_numeric_3countriesqCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")thAindexindex_countries_on_alpha_3countriespCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")tgAindexindex_countries_on_alpha_2countriesoCREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")kf; indexindex_countries_on_namecountriesnCREATE INDEX "index_countries_on_name" ON "countries" ("name")‚eƒ]tablecountriescountriesmCREATE 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)ƒd))…gtablesearch_enginessearch_engineskCREATE TABLE "search_engines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "url" varchar(255) NOT NULL, "base_url" text NOT NULL, "http_method" text NOT NULL, "query_param" text NOT NULL, "additional_param" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xcC!indexindex_subscribes_on_work_idsubscribesjCREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")bS!9indexindex_subscribes_on_subscription_idsubscribesiCREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")‚&a!!„tablesubscribessubscribeshCREATE TABLE "subscribes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subscription_id" integer NOT NULL, "work_id" integer NOT NULL, "start_at" datetime NOT NULL, "end_at" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  - - - +D Î R(´8¼@*Lý„Lq11ˆCtableagent_import_filesagent_import_filesyCREATE TABLE "agent_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "agent_import_file_name" varchar(255), "agent_import_content_type" varchar(255), "agent_import_file_size" integer, "agent_import_updated_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "agent_import_fingerprint" varchar(255), "error_message" text, "edit_mode" varchar(255), "user_encoding" varchar(255))[pw'‚%indexindex_picture_files_on_picture_attachable_id_and_typepicture_filesxCREATE INDEX "index_picture_files_on_picture_attachable_id_and_type" ON "picture_files" ("picture_attachable_id", "picture_attachable_type")„o''‡etablepicture_filespicture_fileswCREATE TABLE "picture_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "picture_attachable_id" integer, "picture_attachable_type" varchar(255), "content_type" varchar(255), "title" text, "thumbnail" varchar(255), "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "picture_file_name" varchar(255), "picture_content_type" varchar(255), "picture_file_size" integer, "picture_updated_at" datetime, "picture_meta" text, "picture_fingerprint" varchar(255))znEindexindex_languages_on_iso_639_3languagesvCREATE INDEX "index_languages_on_iso_639_3" ON "languages" ("iso_639_3")zmEindexindex_languages_on_iso_639_2languagesuCREATE INDEX "index_languages_on_iso_639_2" ON "languages" ("iso_639_2")zlEindexindex_languages_on_iso_639_1languagestCREATE INDEX "index_languages_on_iso_639_1" ON "languages" ("iso_639_1")rk;indexindex_languages_on_namelanguagessCREATE UNIQUE INDEX "index_languages_on_name" ON "languages" ("name")‚'j„tablelanguageslanguagesrCREATE 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)ziEindexindex_countries_on_numeric_3countriesqCREATE INDEX "index_countries_on_numeric_3" ON "countries" ("numeric_3")thAindexindex_countries_on_alpha_3countriespCREATE INDEX "index_countries_on_alpha_3" ON "countries" ("alpha_3")tgAindexindex_countries_on_alpha_2countriesoCREATE INDEX "index_countries_on_alpha_2" ON "countries" ("alpha_2")kf; indexindex_countries_on_namecountriesnCREATE INDEX "index_countries_on_name" ON "countries" ("name")‚eƒ]tablecountriescountriesmCREATE 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)ƒd))…gtablesearch_enginessearch_engineskCREATE TABLE "search_engines" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" text, "url" varchar(255) NOT NULL, "base_url" text NOT NULL, "http_method" text NOT NULL, "query_param" text NOT NULL, "additional_param" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)xcC!indexindex_subscribes_on_work_idsubscribesjCREATE INDEX "index_subscribes_on_work_id" ON "subscribes" ("work_id")bS!9indexindex_subscribes_on_subscription_idsubscribesiCREATE INDEX "index_subscribes_on_subscription_id" ON "subscribes" ("subscription_id")‚&a!!„tablesubscribessubscribeshCREATE TABLE "subscribes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "subscription_id" integer NOT NULL, "work_id" integer NOT NULL, "start_at" datetime NOT NULL, "end_at" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)õûõtƲÌÜ𠀆R–¬¬Îè.hÖ\< | ê B ‚ŠÀB: Z Ì  < +T + æ ¦ d Ü.d^Œ¦´  jd|îì 2 ¬ øL8VžÈ° Ð  d ¢  +t +&vøú’èÒî,R Ê ª : EcuadorEcuadorECECU218:? SudanSudanSDSDN736¿' + !!MozambiqueMozambiqueMZMOZ508Š$S GuatemalaGuatemalaGTGTM320S69 11Dominican RepublicDominican RepublicDODOM2149%[ VenezuelaVenezuelaVEVEN862Û#$ PortugalPortugalPTPRT620¤! MoroccoMoroccoMAMAR504‰R GuamGuamGUGUM316R"8 DominicaDominicaDMDMA2128!Z VanuatuVanuatuVUVUT548Ú%> Sri LankaSri LankaLKLKA144¾# PolandPolandPLPOL616£&Q !!GuadeloupeGuadeloupeGPGLP312Q"7 DjiboutiDjiboutiDJDJI2627 BrazilBrazilBRBRA062'Y !!UzbekistanUzbekistanUZUZB860Ù#" PitcairnPitcairnPNPCN612¢' !!MontserratMontserratMSMSR500ˆ&m !!KyrgyzstanKyrgyzstanKGKGZ417m 6 DenmarkDenmarkDKDNK2086" BotswanaBotswanaBWBWA058!X UruguayUruguayUYURY858Ø)! ##PhilippinesPhilippinesPHPHL608¡# MongoliaMongoliaMNMNG496‡ P GrenadaGrenadaGDGRD308P.5 ))Czech RepublicCzech RepublicCZCZE2035> 99Bosnia and HerzegovinaBosnia and HerzegovinaBABIH056-W ''United StatesUnited StatesUSUSA840× PeruPeruPEPER604  MonacoMonacoMCMCO492†l KuwaitKuwaitKWKWT414l4 CyprusCyprusCYCYP1964  BoliviaBoliviaBOBOL068/V ))United KingdomUnited KingdomGBGBR826Ö; 55Moldova, Republic ofMoldova, Republic ofMDMDA498…6k 11Korea, Republic ofKorea, Republic ofKRKOR410k3 CubaCubaCUCUB1923 BhutanBhutanBTBTN052;U 55United Arab EmiratesUnited Arab EmiratesAEARE784ÕQ KKMicronesia, Federated States ofMicronesia, Federated States ofFMFSM583„`j [[Korea, Democratic People\'s Republic ofKorea, Democratic People\'s Republic ofKPPRK408j  BermudaBermudaBMBMU048!T UkraineUkraineUAUKR804Ô MexicoMexicoMXMEX484ƒ"i KiribatiKiribatiKIKIR296i 2 CroatiaCroatiaHRHRV1912 BeninBeninBJBEN204S UgandaUgandaUGUGA800Ó% MauritiusMauritiusMUMUS480‚h KenyaKenyaKEKEN404hR TuvaluTuvaluTVTUV798Ò&g !!KazakhstanKazakhstanKZKAZ398g BelizeBelizeBZBLZ084f JordanJordanJOJOR400f  BelgiumBelgiumBEBEL046e JapanJapanJPJPN392e  BelarusBelarusBYBLR112 d JamaicaJamaicaJMJAM388dc ItalyItalyITITA380c+3 %%Saudi ArabiaSaudi ArabiaSASAU682³b IsraelIsraelILISR376b=2 77Sao Tome and PrincipeSao Tome and PrincipeSTSTP678² a IrelandIrelandIEIRL372a'1 !!San MarinoSan MarinoSMSMR674±` IraqIraqIQIRQ368`0 SamoaSamoaWSWSM882°D_ ??Iran, Islamic Republic ofIran, Islamic Republic ofIRIRN364_E FranceFranceFRFRA250ES/ MMSaint Vincent and the GrenadinesSaint Vincent and the GrenadinesVCVCT670¯! NigeriaNigeriaNGNGA566•$^ IndonesiaIndonesiaIDIDN360^ D FinlandFinlandFIFIN246DE. ??Saint Pierre and MiquelonSaint Pierre and MiquelonPMSPM666® NigerNigerNENER562”] IndiaIndiaININD356]C FijiFijiFJFJI242C)- ##Saint LuciaSaint LuciaLCLCA662­% NicaraguaNicaraguaNINIC558“ \ IcelandIcelandISISL352\,B ''Faroe IslandsFaroe IslandsFOFRO234B#c ZimbabweZimbabweZWZWE716ã=, 77Saint Kitts and NevisSaint Kitts and NevisKNKNA659¬) ##New ZealandNew ZealandNZNZL554’HA CCFalkland Islands (Malvinas)Falkland Islands (Malvinas)FKFLK238AB' ==Central African RepublicCentral African RepublicCFCAF140'b ZambiaZambiaZMZMB894â- ''New CaledoniaNew CaledoniaNCNCL540‘w MacaoMacaoMOMAC446w [ HungaryHungaryHUHUN348["@ EthiopiaEthiopiaETETH231@.& ))Cayman IslandsCayman IslandsKYCYM136&++ %%Saint HelenaSaint HelenaSHSHN654«   unknownunkno1_ +ãü—‹Y%Ê{Ïù‰@á³g œ † p & è r  ¾ f Cï¾nù¤.Ðq7צ[•Gè›  i « Z  +w +B +^ã˜"ÃQÐDIó‹<Üh?æ Ÿ +i +7 ï Ù ¦ h 7=·ùÆ‚& ö Ð ´ ¨ ’ { a K ¼ R  Ke8 ã²CÑŠK­Z(úÊ™@év,Ì <  — 8 ö ‘ ; +Y +*¥8Æyš@ê»u,Ëj"¾„\) ì € - + + ä Ì ™ Püã%ÙœO Û ¾®rMôÑIJ§ +N + ° Š D & íÝ—Lí¿v¿X÷ U 0 ô } $ Ù s  +ŽÕˆ¯eZŽõ Rwandaª5Netherlands Antilles Estonia?!Cape Verde% Hong KongZ!Luxembourgv +Yemená)Western Saharaà#Netherlands Lithuaniau Eritrea> +Canada$/Wallis and Futunaß +NepalŽ'Liechtensteint/Equatorial Guinea= Cameroon#3Antigua and Barbuda 5Virgin Islands, U.S.Þ +Nauru9Libyan Arab Jamahiriyas#El Salvador< Cambodia" Anguilla;Virgin Islands, BritishÝ NamibiaŒ Liberiar Burundi! +Angola Viet NamÜ Lesothoq%Burkina Faso Andorra Lebanonp Bulgaria)American Samoa +Latviao/Brunei Darussalam Algeria%OLao People\'s Democratic Republicn Albania#Afghanistan +Spain½%South Africa¼ Somalia»+Solomon Islandsº GreenlandO Slovenia¹ ParaguayŸ +GreeceN Slovakia¸-Papua New Guineaž GibraltarMSingapore· Panama GhanaL%Sierra Leone¶ +Palauœ GermanyK)Cote D\'Ivoire1!Seychellesµ Pakistan›!Mauritania GeorgiaJ!Costa Rica0=Turks and Caicos IslandsÑ Senegal´ Omanš!Martinique€ +GambiaI%Cook Islands/%TurkmenistanÐ Norway™-Marshall Islands GabonH)WCongo, the Democratic Republic of the. TurkeyÏ=Northern Mariana Islands˜ Malta~-French PolynesiaG Congo- Barbados TunisiaÎ)Norfolk Island—Mali}'French GuianaF Comoros,!Bangladesh3Trinidad and TobagoÍ Niue– Maldives| Colombia+ Bahrain +TongaÌ Malaysia{ China* Bahamas TokelauË +Malawiz Chile)!Azerbaijan TogoÊ!MadagascaryChad( Austria ThailandÉ.aMacedonia, the Former Yugoslav Republic ofx Australia !ETanzania, United Republic ofÈ Aruba Armenia Argentina +!TajikistanÇ?Taiwan, Province of ChinaÆ5Syrian Arab RepublicÅ#SwitzerlandÄ HondurasY SwedenÃ1Russian Federation©!GHoly See (Vatican City State)XSwaziland Romania¨ HaitiW9Svalbard and Jan MayenÁ Reunion§ +GuyanaV +Qatar¦'Guinea-BissauU Egypt; SurinameÀ#Puerto Rico¥ Myanmar‹ +GuineaT Ecuador: +Sudan¿!MozambiqueŠ GuatemalaS1Dominican Republic9VenezuelaÛ Portugal¤ Morocco‰GuamR Dominica8 VanuatuÚSri Lanka¾ Poland£!GuadeloupeQ Djibouti7 +Brazil!UzbekistanÙ Pitcairn¢!Montserratˆ!Kyrgyzstanm Denmark6 Botswana UruguayØ#Philippines¡ Mongolia‡ GrenadaP)Czech Republic59Bosnia and Herzegovina'United States× Peru  Monaco† +Kuwaitl +Cyprus4 Bolivia)United KingdomÖ5Moldova, Republic of…1Korea, Republic ofkCuba3 +Bhutan5United Arab EmiratesÕ$KMicronesia, Federated States of„+[Korea, Democratic People\'s Republic ofj Bermuda UkraineÔ Mexicoƒ Kiribatii Croatia2 Benin UgandaÓMauritius‚ Kenyah TuvaluÒ!Kazakhstang +Belize +Jordanf Belgium Japane Belarus Jamaicad Italyc%Saudi Arabia³ +Israelb7Sao Tome and Principe² Irelanda!San Marino±Iraq` +Samoa°?Iran, Islamic Republic of_ +FranceE%MSaint Vincent and the Grenadines¯ Nigeria• Indonesia^ FinlandD?Saint Pierre and Miquelon® +Niger” India]FijiC#Saint Lucia­Nicaragua“ Iceland\'Faroe IslandsB Zimbabweã7Saint Kitts and Nevis¬#New Zealand’CFalkland Islands (Malvinas)A=Central African Republic' Zambiaâ'New Caledonia‘ Macaow Hungary[ Ethiopia@)Cayman Islands&%Saint Helena« + unknown +ã hù +Th +“ æ + +Œ • p +7 œ +i i  Ž L Á íß +M +b  +0¤ +w< µ /a âíÑ º •¾ º »  q E ß ( CZ 5  ® Û ˆ b +~ D x  œ ³ +šã\z·p˜> ŽC < ß +ÿ +º j = § Ø +Ñ [   † à ñÜU +s(7‘ûôØæ» Ô + – æ§xS.êÊ +… +[ Ñ — +) +F ¬ +p ý y&K [ ‡ x Ø 5 ùÕ ¤ b 4 Ì ¬³  >Ž ! S +!Ík ÐM‰ ¤ É õ ü¯ Z +÷ ³ +à ñ , Ÿc Ä - q  +É  é Ò h +² $ K Ê +ïñ +Á ø +Ø  R +ª % + ³ á J b S p £ 6 x È  œ ô « ††« é ¼ ÚE i + í +> Á/ ” +¢ÅŸ €RWªANEE?CV%HKZLUvYEáEHàNLLTuER>CA$WFßNPŽLItGQ=CM#AG VIÞNRLYsSV<KH"AIVGÝNAŒLRrBI!AOVNÜLSqBF ADLBpBGASLVoBNDZLAnALAFES½ZA¼SO»SBºGLOSI¹PYŸGRNSK¸PGžGIMSG·PAGHLSL¶PWœDEKCI1SCµPK›MRGEJCR0TCÑSN´OMšMQ€GMICK/TMÐf™MHGAHCD.TRÏMP˜MT~PFGCG-BBTNÎNF—ML}GFFKM,BDTTÍNU–MV|CO+BHTOÌMY{CN*BSTKËMWzCL)AZTGÊMGyTD(ATTHÉMKxAU TZÈAW AM AR +TJÇTWÆSYÅCHÄHNYSEÃRU©VAXSZÂRO¨HTWSJÁRE§GYVQA¦GWUEG;SRÀPR¥MM‹GNTEC:SD¿MZŠGTSDO9VEÛPT¤MA‰GURDM8VUÚLK¾PL£GPQDJ7BRUZÙPN¢MSˆKGmDK6BWUYØPH¡MN‡GDPCZ5BAUS×PE MC†KWlCY4BOGBÖMD…KRkCU3BTAEÕFM„KPjBMUAÔMXƒKIiHR2BJUGÓMU‚KEhTVÒKZgBZJOfBEJPeBYJMdITcSA³ILbST²IEaSM±IQ`WS°IR_FREVC¯NG•ID^FIDPM®NE”IN]FJCLC­NI“IS\FOBZWãKN¬NZ’FKACF'ZMâNC‘MOwHU[ET@KY&SH« 000 +ã…ù  Ù p F Ñ ‘Ž2 ) ! ©   ï Î h¹v ‰ b ¡ Œ ­ ÍÉ©L g 0 ¹* š¶â L Æ ¥ +u +þ ( +Ô „ ZŸ + "è ø Å +m _ 4 ’ Á ç ¼ÚÀ á—àGi®%‹; +ö +S +9 ß W +Ì ´  + ½ +  R , £§ Un ‰Ø?aû ƒêÙѱÁ¡ Š >fœ ð É ™ ` .qü E Ò¯ ±Ð # ç ß |] +î J  Ö ´  ø + +Ç ¾ WÇX A6z sÉ +åó %¥ +† +J x Þ « +d +0 N ÍD  + « š € f…á ï +Að ‘ ü +[ 6 óOò Ä +' + ] w +} C +¨ ç Ö ÷ 1 µ +Ü ” j 8 ˜ : ~T ¢ Õ o o-  N  x <ê· ê¾“RWAªANTEST?CPV%HKGZLUXvYEMáESHàNLDLTUuERI>CAN$WLFßNPLŽLIEtGNQ=CMR#ATG VIRÞNRULBYsSLV<KHM"AIAVGBÝNAMŒLBRrBDI!AGOVNMÜLSOqBFA ANDLBNpBGRASMLVAoBRNDZALAOnALBAFGESP½ZAF¼SOM»SLBºGRLOSVN¹PRYŸGRCNSVK¸PNGžGIBMSGP·PANGHALSLE¶PLWœDEUKCIV1SYCµPAK›MRTGEOJCRI0TCAÑSEN´OMNšMTQ€GMBICOK/TKMÐNOR™MHLGABHCOD.TURÏMNP˜MLT~PYFGCOG-BRBTUNÎNFK—MLI}GUFFCOM,BGDTTOÍNIU–MDV|COL+BHRTONÌMYS{CHN*BHSTKLËMWIzCHL)AZETGOÊMDGyTCD(AUTTHAÉMKDxAUS TZAÈABW ARM ARG +TJKÇTWNÆSYRÅCHEÄHNDYSWEÃRUS©VATXSWZÂROM¨HTIWSJMÁREU§GUYVQAT¦GNBUEGY;SURÀPRI¥MMR‹GINTECU:SDN¿MOZŠGTMSDOM9VENÛPRT¤MAR‰GUMRDMA8VUTÚLKA¾POL£GLPQDJI7BRAUZBÙPCN¢MSRˆKGZmDNK6BWAURYØPHL¡MNG‡GRDPCZE5BIHUSA×PER MCO†KWTlCYP4BOLGBRÖMDA…KORkCUB3BTNAREÕFSM„PRKjBMUUKRÔMEXƒKIRiHRV2BENUGAÓMUS‚KENhTUVÒKAZgBLZJORfBELJPNeBLRJAMdITAcSAU³ISRbSTP²IRLaSMR±IRQ`WSM°IRN_FRAEVCT¯NGA•IDN^FINDSPM®NER”IND]FJICLCA­NIC“ISL\FROBZWEãKNA¬NZL’FLKACAF'ZMBâNCL‘MACwHUN[ETH@CYM&SHN« 000 +ã…ù Ù Ñ Á © ‘ p Î )   ï ­ b ! 0¹ ŒL* Í š g© ü N ¹ ¡ Ö hÉ > âŸè¶ E ç Æ ¥ : „ Z ( + n" ø Åv ’ 4 ç 6 àÚ—‹®iG% R _ +m +S +9f + + ½ W ,  ß £ ‰ o U§Øƒa? ûêÙ +uÑÁ¡±D ð Š É ™ ± ` .üÒ¯Ð ß ¾ | J  +‡] ç ´ # ø +º W %óÉŽ Ç <¥zX6 s A +å ; +d +† +J +0 + Þ « x N  ´ Í « š € f…ðœ FqO-òá +} +[ +A +' x + ó ê“ áÀ ï Ä ‘ w ] L C 1 ÷ Ö µ ” j2 8  +¨˜~T ¼  Õ  ‰ ¢ o ê·¾646ª530233?132%344Z442v887á732à528440u232>124$876ß524Ž438t226=120#028 850Þ520434s222<116"660092Ý516Œ430r108!020704Ü426q854 016422p100014428o096010418n008004724½710¼706»090º304O705¹600Ÿ300N703¸598ž292M702·591288L694¶585œ276K3841690µ586›478268J1880796Ñ686´512š474€270I184/795Ð578™584266H180.792Ï580˜470~258G178-042788Î574—466}254F174,040780Í570–462|170+048776Ì458{156*036772Ë454z152)025768Ê450y148(032764É807x030 834È533 041 026 +762Ç158Æ760Å756Ä340Y752Ã643©336X748Â642¨332W744Á638§328V634¦624U818;740À630¥104‹324T218:736¿508Š320S2149862Û620¤504‰316R2128548Ú144¾616£312Q2627062860Ù612¢500ˆ417m2086058858Ø608¡496‡308P2035056840×604 492†414l1964068826Ö498…410k1923052784Õ583„408j048804Ô484ƒ296i1912204800Ó480‚404h798Ò398g084400f046392e112388d380c682³376b678²372a674±368`882°364_250E670¯566•360^246D666®562”356]242C662­558“352\234B716ã659¬554’238A140'894â540‘446w348[231@136&654« 000ûû +Š Ý bf¹&y«ã ! G v +% WƒÄ>™Áí3:® Î  +i Ë‚|œ‚˜øE  ¾ê?A©¸Xp ñ c ñ -Ýã_Û]ïV3cÓ « Ù S + .ü—Þ3GœÌh Ì F j ¥ +H | ²8{ºà]) +##AzerbaijaniAzerbaijaniazazeaze" +SwedishSwedishsvsweswe(+ +EnglishEnglishEnglishenengeng+"9 +YiddishYiddishyiyidyid¹'F +!!IndonesianIndonesianidindindF +AymaraAymaraayaymaym +SwatiSwatisssswsswœ#* +DzongkhaDzongkhadzdzodzo*8 +XhosaXhosaxhxhoxho¸ +PashtoPashtopspuspus€! +PanjabiPanjabipapanpan! +AvestanAvestanaeaveave " +SwahiliSwahiliswswaswa›) +DutchDutchnldutnld)7 +WolofWolofwowolwol·#~ +OssetianOssetianosossoss~ +AvaricAvaricavavaava & +SundaneseSundanesesusunsunš'c +!!LithuanianLithuanianltlitlitc( +DivehiDivehidvdivdiv(26 +++Western FrisianWestern Frisianfyfryfry¶} +OromoOromoomormorm}# +AssameseAssameseasasmasm " +SpanishSpanishesspaspa™!b +LingalaLingalalnlinlinb5 +WelshWelshcywelcymµE +IgboIgboigiboiboE# + +ArmenianArmenianhyarmhye +. +''South NdebeleSouth Ndebelenrnblnbl˜'a +!!LimburgishLimburgishlilimlima"4 +WalloonWalloonwawlnwln´| +OriyaOriyaororiori|D +IdoIdoioidoidoD +SothoSothostsotsot—!` +LatvianLatvianlvlavlav`{ +OjibwaOjibwaojojioji{  +SomaliSomalisosomsom–_ +LatinLatinlalatlat_' +DanishDanishdadandan'!z +OccitanOccitanocociociz%C +IcelandicIcelandicisiceislC^ +LaoLaololaolao^& +CzechCzechcsczeces&5y +//Norwegian NynorskNorwegian Nynorsknnnnonnoy%B +HungarianHungarianhuhunhunB#] +KwanyamaKwanyamakjkuakua]% +AragoneseAragoneseanargarg #% +CroatianCroatianhrhrvhrv%(3 +!!VolapükVolapükvovolvol³9x +33Norwegian BokmÃ¥lNorwegian BokmÃ¥lnbnobnobx%A +Hiri MotuHiri MotuhohmohmoA!\ +KurdishKurdishkukurkur\ +ArabicArabicararaara$ +CreeCreecrcrecre$(2 +!!VietnameseVietnamesevivievie²@ +HindiHindihihinhin@[ +KoreanKoreankokorkor[! +AmharicAmharicamamhamh& +SlovenianSlovenianslslvslv•## +CorsicanCorsicancocoscos#1 +VendaVendavevenven±? +HereroHererohzherher?Z +KongoKongokgkonkonZ# +AlbanianAlbaniansqalbsqi  +SlovakSlovaksksloslk”!" +CornishCornishkwcorcor"0 +UzbekUzbekuzuzbuzb°> +HebrewHebrewhehebheb> +AkanAkanakakaaka" +SinhalaSinhalasisinsin“!! +ChuvashChuvashcvchvchv!/ +UrduUrduururdurd¯= +HausaHausahahauhau=$w +NorwegianNorwegianfnornorw  +SindhiSindhisdsndsnd’- +''Church SlavicChurch Slaviccuchuchu &. +UkrainianUkrainianukukrukr®!< +HaitianHaitianhthathat<-v +''Northern SamiNorthern Samisesmesmev% +AfrikaansAfrikaansafafrafr! +ChineseChinesezhchizho - +UighurUighuruguiguig­-u +''North NdebeleNorth Ndebelendndendeu +AfarAfaraaaaraar( +!!Sichuan YiSichuan Yiiiiiiiii‘Y +KomiKomikvkomkomY# +ChichewaChichewanynyanya, +TwiTwitwtwitwi¬t +NepaliNepalinenepnept% +AbkhazianAbkhazianababkabk +ShonaShonasnsnasna"+ +TurkmenTurkmentktuktuk«s +NdongaNdongangndondos0 +))Serbo-CroatianSerbo-CroatianshXXXhbs!X +KirundiKirundirnrunrunX"* +TurkishTurkishtrturturªr +NavajoNavajonvnavnavr#; +GujaratiGujaratigugujguj;" +SerbianSerbiansrsrpsrpŽ!W +KirghizKirghizkykirkirWq +NauruNaurunanaunauq': +!!GuaraníGuaranígngrngrn:2 +++Scottish GaelicScottish Gaelicgdglagla)V +##KinyarwandaKinyarwandarwkinkinV; +7 unknownen:unknown +ja:ä¸æ˜Žunknownunknownunb +¼»(å­ ã › b   Ý Š O +t +X 㠣φpÛÃc1õÊ»n4 ü ¶ m  Ê ³ h  + +1 î ™ d -d4Ñ|H áÁ‘J Î † H ê ´ ]  +d + × Á } 8ú¿æ’o=Öå«mþ Ù V ø  “ p 7 ÷ ¤ + ö ² p Z î«ëX U·†NÓ›T 0 Ô ¨ | S Ó } P C 7 +· Ë ‰ Û‘K?òµ»ÐžY6îb' ð § ‡ e $ ê • [  +€ +J E ´Ÿ|'ýª†%yAÇ€@ à v F  ¾ r , +› +> +õSardinianŒ Chechen +KikuyuU Greek9 Maorip Chamorro KhmerT +German8 Mongoliano Tswana© Catalan +KazakhS Georgian7 Moldaviann Burmese KashmiriR Ganda6 Tsonga¨ +KanuriQ Galician5 +Tonga§ Sanskrit‹ Bulgarian Fulah4 +Breton KannadaP +SangoŠ Tigrinya¦#Marshallesem Bosnian Tibetan¥ +French3 Samoan‰ Russianˆ Marathil Finnish2 Bislama Thai¤ +Bihari Romanian‡ Telugu£Manxk +Tatar¢#KalaallisutO Bengali'Raeto-Romance† Maltesej JavaneseN +Tamil¡ Malayalami Quechua… +Fijian1 JapaneseM +Tajik  Pali„ Malayh Faroese0 Malagasyg ItalianL!Portugueseƒ Fanti/!Belarusian!Macedonianf IrishK Polish‚ InupiaqJ +BasqueEwe.'Luxembourgishe Zulu¼ InuktitutI%Luba-Katangad Estonian- Zhuang» TahitianŸ Bashkir#InterlingueH Bambara Tagalogž Esperanto, Yorubaº#InterlinguaG Persian#Azerbaijani Swedish English+ Yiddish¹!IndonesianF +Aymara +Swatiœ Dzongkha* +Xhosa¸ Pashto€ Panjabi Avestan Swahili› Dutch) +Wolof· Ossetian~ +Avaric Sundaneseš!Lithuanianc +Divehi(+Western Frisian¶ Oromo} Assamese Spanish™ Lingalab +WelshµIgboE Armenian +'South Ndebele˜!Limburgisha Walloon´ Oriya|IdoD +Sotho— Latvian` +Ojibwa{ Somali– Latin_ +Danish' Occitanz IcelandicCLao^ Czech&/Norwegian Nynorsky HungarianB Kwanyama] Aragonese Croatian%!Volapük³3Norwegian BokmÃ¥lx Hiri MotuA Kurdish\ +ArabicCree$!Vietnamese² Hindi@ +Korean[ AmharicSlovenian• Corsican# +Venda± +Herero? KongoZ Albanian Slovak” Cornish" +Uzbek° +Hebrew>Akan Sinhala“ Chuvash! Urdu¯ Hausa= Norwegianw Sindhi’'Church Slavic Ukrainian® Haitian<'Northern Samiv Afrikaans Chinese Uighur­'North NdebeleuAfar!Sichuan Yi‘KomiY ChichewaTwi¬ +Nepalit Abkhazian +Shona Turkmen« +Ndongas)Serbo-Croatian KirundiX Turkishª +Navajor Gujarati; SerbianŽ KirghizW Nauruq!Guaraní:+Scottish Gaelic#KinyarwandaV + unknown +œZ† N=í TœMx Ÿ s ! ü Á [ ; ± ¢ Ï Þ u I n +À«1 ü µ +Î ‰ 0 † +² Þ ¦ ª  ô B ›  7 } iæ $ß È æŽjT/? ĺ í  È ½a x é# E œ  ô +òÁ +«F +ë × +Ç P•  qi×Ñ  Ó ®* ‚ £ ø > g +¹ b  +ù ” 0 í ØcS ]8 Ë»p ÿ ˜ â l G ( p ? L + å¬ ¸ Œî 3 +œ6 W¤ôÏ£ „ÈÉ ( ð z  U û À © _• Ö +Ü +³  Ïw ¹K'õÞ²†[ Ú d 7  å ±D ”scŒcekiUel9mipchkmTde8mnotn©cakkSka7monmyksRlg6ts¨krQgl5to§sa‹bgff4brknPsgŠti¦mhmbsbo¥fr3sm‰ruˆmrlfi2bith¤bhro‡te£gvktt¢klObnrm†mtjjvNta¡mliqu…fj1jaMtg pi„mshfo0mggitLptƒak/bemkfgaKpl‚ikJeuee.lbezu¼iuIludet-za»tyŸbaieHbmtlžeo,yoºiaGfaazsven+yi¹idFayssœdz*xh¸ps€paae sw›nl)wo·os~av sušltcdv(fy¶om}as es™lnbcyµigEhy +nr˜liawa´or|ioDst—lv`oj{so–la_da'oczisClo^cs&nnyhuBkj]an hr%vo³nbxhoAku\arcr$vi²hi@ko[amsl•co#ve±hz?kgZsqsk”kw"uz°he>aksi“cv!ur¯ha=fwsd’cu uk®ht<sevafzhug­nduaaii‘kvYnytw¬netabsntk«ngsshrnXtrªnvrgu;srŽkyWnaqgn:gdrwV + unknown +¼ à™Ew$È ÔžlC v L  ð ½ “ P `  Ü N  + +• +R +2 + é,Ù¯}K ò Ò 3  Î ¤ q 6 ³ ‰  +à ; + +B +ä ì +{ 5 ùÜ»êÀŽ\3 n â  M & X ‚ µ ý à g ‘ F +Z +s +: + ñíÌV–d +; ê Ê ± ‡ ] +  . +b ä +Ç x + +ú « » _ +J +!Ô³ ~=‘o ú+ò^ Ú ¹ ˜ D  è Š ¢ ô Ë ß € V #¢ +ŒÐ¦t +èú Á ¨ T àà Š" ø › G o = , ™ h  +) +jˆªf4 õá·…S" e Ö ¬ y > srdŒchekikUgre9maopchakhmTger8monotsn©catkazSgeo7molnburkasRlug6tso¨kauQglg5ton§san‹bulful4brekanPsagŠtir¦mahmbostib¥fre3smo‰rusˆmarlfin2bistha¤bihrum‡tel£glvktat¢kalObenroh†mltjjavNtam¡malique…fij1jpnMtgk pli„mayhfao0mlggitaLporƒaka/belmacfgleKpol‚ipkJbaqewe.ltzezul¼ikuIlubdest-zha»tahŸbakileHbamtglžepo,yorºinaGperazesweeng+yid¹indFaymsswœdzo*xho¸pus€panave swa›dut)wol·oss~ava sunšlitcdiv(fry¶orm}asm spa™linbwelµiboEarm +nbl˜limawln´ori|idoDsot—lav`oji{som–lat_dan'ociziceClao^cze&nnoyhunBkua]arg hrv%vol³nobxhmoAkur\aracre$vie²hin@kor[amhslv•cos#ven±her?konZalbslo”cor"uzb°heb>akasin“chv!urd¯hau=norwsnd’chu ukr®hat<smevafrchiuig­ndeuaariii‘komYnyatwi¬neptabksnatuk«ndosXXXrunXturªnavrguj;srpŽkirWnauqgrn:glakinV + unknown +¼ à Ew$ÈlC L  ð ½ “ P ` Ü N + +• +2 ò + éÙ¯}K e Ò + 3 Î ù ¤ q 6  ³ Š Ô ‰  +à ; +ä ì +{ 5Ü»ê™ÀŽ\3 v n  M & X ‚ µ ý â à g ‘ F +Z +B +s +: + ñíÌV–d +; ê Ê ± ‡ ] +  . +b +Ç x +ú ä » _ +J +! + « +RÔ³ ~=‘o  ú+ò^ Ú ¹ ˜ D  è ¢ ô Ë ß € V #¢ +ŒÐ¦t +èú Á ¨ Tž àà Š" ø › G o = , ™ h  +) +jˆªf4 õá·…S" Ö ¬ y >, srdŒchekikUell9mripchakhmTdeu8monotsn©catkazSkat7molnmyakasRlug6tso¨kauQglg5ton§san‹bulful4brekanPsagŠtir¦mahmbosbod¥fra3smo‰rusˆmarlfin2bistha¤XXXron‡tel£glvktat¢kalObenroh†mltjjavNtam¡malique…fij1jpnMtgk pli„msahfao0mlggitaLporƒfat/belmkdfgleKpol‚ipkJeusewe.ltzezul¼ikuIlubdest-zha»tahŸbakileHbamtglžepo,yorºinaGfasazesweeng+yid¹indFaymsswœdzo*xho¸pus€panave swa›nld)wol·oss~ava sunšlitcdiv(fry¶orm}asm spa™linbcymµiboEhye +nbl˜limawln´ori|idoDsot—lav`oji{som–lat_dan'ocizislClao^ces&nnoyhunBkua]arg hrv%vol³nobxhmoAkur\aracre$vie²hin@kor[amhslv•cos#ven±her?konZsqislk”cor"uzb°heb>akasin“chv!urd¯hau=norwsnd’chu ukr®hat<smevafrzhouig­ndeuaariii‘komYnyatwi¬neptabksnatuk«ndoshbsrunXturªnavrguj;srpŽkirWnauqgrn:glakinV + unknown     - -   -  - -   Z ó;ji|ó ß +  ·³#rW1Aindexindex_agent_import_files_on_parent_idagent_import_fileszCREATE INDEX "index_agent_import_files_on_parent_id" ON "agent_import_files" ("parent_id")sS19indexindex_agent_import_fileY‚D33„-tableuser_checkout_statsuser_checkout_statsCREATE TABLE "user_checkout_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)YqK‚indexindex_carrier_type_has_checkout_types_on_m_form_idcarrier_type_has_checkout_types‰CREATE INDEX "index_carrier_type_has_checkout_types_on_m_form_id" ON "carrier_type_has_checkout_types" ("carrier_type_id")hK‚indexindex_carrier_type_has_checkout_types_on_checkout_type_idcarrier_type_has_checkout_typesŠCREATE INDEX "index_carrier_type_has_checkout_types_on_checkout_type_id" ON "carrier_type_has_checkout_types" ("checkout_type_id")‚bMM„5tablecheckout_stat_has_manifestationscheckout_stat_has_manifestations‹CREATE TABLE "checkout_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_checkout_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "checkouts_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL){M‚1indexindex_checkout_stat_has_manifestations_on_checkout_stat_idcheckout_stat_has_manifestationsŒCREATE INDEX "index_checkout_stat_has_manifestations_on_checkout_stat_id" ON "checkout_stat_has_manifestations" ("manifestation_checkout_stat_id")mM‚indexindex_checkout_stat_has_manifestations_on_manifestation_idcheckout_stat_has_manifestationsŽCREATE INDEX "index_checkout_stat_has_manifestations_on_manifestation_id" ON "checkout_stat_has_manifestations" ("manifestation_id")"EE„tablemanifestation_checkout_statsmanifestation_checkout_statsCREATE TABLE "manifestation_checkout_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "‚_EE„?tablemanifestation_checkout_statsmanifestation_checkout_statsCREATE TABLE "manifestation_checkout_stats" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start_date" datetime, "end_date" datetime, "note" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "started_at" datetime, "completed_at" datetime, "user_id" integer)‚H;;„%tablecheckout_stat_has_userscheckout_stat_has_users‘CREATE TABLE "checkout_stat_has_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_checkout_stat_id" integer NOT NULL, "user_id" integer NOT NULL, "checkouts_count" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Wy;‚indexindex_checkout_stat_has_users_on_user_checkout_stat_idcheckout_stat_has_users’CREATE INDEX "index_checkout_stat_has_users_on_user_checkout_stat_id" ON "checkout_stat_has_users" ("user_checkout_stat_id")- ];Mindexindex_checkout_stat_has_users_on_user_idcheckout_stat_has_users“CREATE INDEX "index_checkout_stat_has_users_on_user_id" ON "checkout_stat_has_users" ("user_id")‚] KK„/tablereserve_stat_has_manifestationsreserve_stat_has_manifestations”CREATE TABLE "reserve_stat_has_manifestations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "manifestation_reserve_stat_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "reserves_count" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x K‚-indexindex_reserve_stat_has_manifestations_on_m_reserve_stat_idreserve_stat_has_manifestations•CREATE INDEX "index_reserve_stat_has_manifestations_on_m_reserve_stat_id" ON "reserve_stat_has_manifestations" ("manifestation_reserve_stat_id")h K‚indexindex_reserve_stat_has_manifestations_on_manifestation_idreserve_stat_has_manifestations–CREATE INDEX "index_reserve_stat_has_manifestations_on_manifestation_id" ON "reserve_stat_has_manifestations" ("manifestation_id") + ´hJ  33MyStringtext/csv2014-09-16 13:20:212014-09-16 13:20:21J  33MyStringtext/csv2014-09-16 13:20:212014-09-16 13:20:21J  33MyStringtext/csv2014-09-16 13:20:212014-09-16 13:20:21 +òü÷ò +òü÷ò€       -€       - -  - 44t  Ô -i  ! * ÈÌTo /=xPu9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_usersšCREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users" ("user_reserve_stat_id")‚bMM„5tablecheckout_stat_has_mŽ<))œ3tablemanifestationsmanifestationsCREATE 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, "date_copyrighted" 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, "attachment_file_name" varchar(255), "attachment_content_type" varchar(255), "attachment_file_size" integer, "attachment_updated_at" datetime, "title_alternative_transcription" text, "description" text, "abstract" text, "available_at" datetime, "valid_until" datetime, "date_submitted" datetime, "date_accepted" datetime, "date_caputured" datetime, "pub_date" varchar(255), "edition_string" varchar(255), "volume_number" integer, "issue_number" integer, "serial_number" integer, "content_type_id" integer DEFAULT 1, "year_of_publication" integer, "attachment_meta" text, "month_of_publication" integer, "fulltext_content" boolean, "doi" varchar(255), "periodical" boolean, "statement_of_responsibility" text)Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address");m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")Q)5indexindex_manifestations_on_updated_atmanifestationsCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")-c)Yindexindex_manifestations_on_date_of_publicationmanifestations¦CREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")‚ ƒWtablelicenseslicenses§CREATE TABLE "licenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚!ƒ[tableversionsversions¨CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime)"[Gindexindex_versions_on_item_type_and_item_idversions©CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")‚$++ƒ5tableimport_requestsimport_requests«CREATE TABLE "import_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar(255), "manifestation_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%G+!indexindex_import_requests_on_isbnimport_requests¬CREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")(&_+Qindexindex_import_requests_on_manifestation_idimport_requests­CREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id") + LL$-ËÏ W + +”  ê9 /=xPu9}indexindex_reserve_stat_has_users_on_user_reserve_stat_idreserve_stat_has_usersšCREATE INDEX "index_reserve_stat_has_users_on_user_reserve_stat_id" ON "reserve_stat_has_users"|))+tablemanifestationsmanifestationsCREATE 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, "date_copyrighted" 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" integerMs-‚indexindex_lending_policies_on_item_id_and_user_group_idlending_policies¥CREATE UNIQUE INDEX "index_lending_policies_on_item_id_and_user_group_id" ON "lending_policies" ("item_id", "user_group_id")‚ ƒWtablelicenseslicenses§CREATE TABLE "licenses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" varchar(255), "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚!ƒ[tableversionsversions¨CREATE TABLE "versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "item_type" varchar(255) NOT NULL, "item_id" integer NOT NULL, "event" varchar(255) NOT NULL, "whodunnit" varchar(255), "object" text, "created_at" datetime)"[Gindexindex_versions_on_item_type_and_item_idversions©CREATE INDEX "index_versions_on_item_type_and_item_id" ON "versions" ("item_type", "item_id")‚$++ƒ5tableimport_requestsimport_requests«CREATE TABLE "import_requests" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "isbn" varchar(255), "manifestation_id" integer, "user_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%G+!indexindex_import_requests_on_isbnimport_requests¬CREATE INDEX "index_import_requests_on_isbn" ON "import_requests" ("isbn")(&_+Qindexindex_import_requests_on_manifestation_idimport_requests­CREATE INDEX "index_import_requests_on_manifestation_id" ON "import_requests" ("manifestation_id") 'M+-indexindex_import_requests_on_user_idimport_requests®CREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")„}(//‰'tableseries_statementsseries_statementsªCREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "manifestation_id" integer, "note" text, "title_subseries_transcription" text, "creator_string" text, "volume_number_string" text, "volume_number_transcription_string" text, "series_master" boolean, "root_manifestation_id" integer)Q)y/‚indexindex_series_statements_on_series_statement_identifierseries_statements¯CREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")‚K*CC„tablemanifestation_relationshipsmanifestation_relationships±CREATE TABLE "manifestation_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "manifestation_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)C+iCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationships²CREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")              - iiú{PŸf* š -' V ý ¡ è4 'M+-indexindex_import_requests_on_user_idimport_requests®CREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")„}(//‰'tableseries_statementsseries_statementsªCREATE 'M+-indexindex_import_requests_on_user_idimport_requests®CREATE INDEX "index_import_requests_on_user_id" ON "import_requests" ("user_id")„}(//‰'tableseries_statementsseries_statementsªCREATE TABLE "series_statements" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_title" text, "numbering" text, "title_subseries" text, "numbering_subseries" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "title_transcription" text, "title_alternative" text, "series_statement_identifier" varchar(255), "manifestation_id" integer, "note" text, "title_subseries_transcription" text, "creator_string" text, "volume_number_string" text, "volume_number_transcription_string" text, "series_master" boolean, "root_manifestation_id" integer)Q)y/‚indexindex_series_statements_on_series_statement_identifierseries_statements¯CREATE INDEX "index_series_statements_on_series_statement_identifier" ON "series_statements" ("series_statement_identifier")‚K*CC„tablemanifestation_relationshipsmanifestation_relationships±CREATE TABLE "manifestation_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "manifestation_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)C+iCeindexindex_manifestation_relationships_on_parent_idmanifestation_relationships²CREATE INDEX "index_manifestation_relationships_on_parent_id" ON "manifestation_relationships" ("parent_id")@,gCaindexindex_manifestation_relationships_on_child_idmanifestation_relationships³CREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")_-))‚wtableuser_has_rolesuser_has_roles´CREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) .K))indexindex_user_has_roles_on_user_iduser_has_rolesµCREATE INDEX "index_user_has_roles_on_user_id" ON "user_has_roles" ("user_id") /K))indexindex_user_has_roles_on_role_iduser_has_roles¶CREATE INDEX "index_user_has_roles_on_role_id" ON "user_has_roles" ("role_id")‚+033ƒ{tableagent_relationshipsagent_relationships·CREATE TABLE "agent_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "agent_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)#1Y3Eindexindex_agent_relationships_on_parent_idagent_relationships¸CREATE INDEX "index_agent_relationships_on_parent_id" ON "agent_relationships" ("parent_id") 2W3Aindexindex_agent_relationships_on_child_idagent_relationships¹CREATE INDEX "index_agent_relationships_on_child_id" ON "agent_relationships" ("child_id")‚C3MMƒwtablemanifestation_relationship_typesmanifestation_relationship_typesºCREATE TABLE "manifestation_relationship_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)‚34;;ƒ{tableresource_import_resultsresource_import_results»CREATE TABLE "resource_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)]5};‚ indexindex_resource_import_results_on_resource_import_file_idresource_import_results¼CREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")  + +PP÷ „ + @ ç ‹ ÒlÈS ‚I4;;„'tableresource_import_resultsresource_import_results»CREATE TABLE "resource_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "error_message" text)]5};‚ indexindex_resource_import_results_on_resource_import_file_idresource_import_results¼CREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id")‚C3MMƒwtablemanifestation_relationship_typesmanifestation_relationship_typesºCREATE TABLE "manifestation_relationship_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) 2W3Aindexindex_agent_relationships_on_child_idagent_relationships¹CREATE INDEX "index_agent_relationships_on_child_id" ON "agent_relationships" ("child_id")#1Y3Eindexindex_agent_relationships_on_parent_idagent_relationships¸CREATE INDEX "index_agent_relationships_on_parent_id" ON "agent_relationships" ("parent_id")‚+033ƒ{tableagent_relationshipsagent_relationships·CREATE TABLE "agent_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "agent_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer) /K))ind@,gCaindexindex_manifestation_relationships_on_child_idmanifestation_relationships³CREATE INDEX "index_manifestation_relationships_on_child_id" ON "manifestation_relationships" ("child_id")_-))‚wtableuser_has_rolesuser_has_roles´CREATE TABLE "user_has_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) .K))indexindex_user_has_roles_on_user_iduser_has_rolesµCREATE INDEX "index_user_has_roles_on_user_id" ON "user_has_roles" ("user_id") /K))indexindex_user_has_roles_on_role_iduser_has_roles¶CREATE INDEX "index_user_has_roles_on_role_id" ON "user_has_roles" ("role_id")‚+033ƒ{tableagent_relationshipsagent_relationships·CREATE TABLE "agent_relationships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "child_id" integer, "agent_relationship_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "position" integer)#1Y3Eindexindex_agent_relationships_on_parent_idagent_relationships¸CREATE INDEX "index_agent_relationships_on_parent_id" ON "agent_relationships" ("parent_id") 2W3Aindexindex_agent_relationships_on_child_idagent_relationships¹CREATE INDEX "index_agent_relationships_on_child_id" ON "agent_relationships" ("child_id")‚C3MMƒwtablemanifestation_relationship_typesmanifestation_relationship_typesºCREATE TABLE "manifestation_relationship_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)‚I4;;„'tableresource_import_resultsresource_import_results»CREATE TABLE "resource_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_import_file_id" integer, "manifestation_id" integer, "item_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "error_message" text)]5};‚ indexindex_resource_import_results_on_resource_import_file_idresource_import_results¼CREATE INDEX "index_resource_import_results_on_resource_import_file_id" ON "resource_import_results" ("resource_import_file_id") ˜˜Í/Žª”f 332014-09-16 13:20:212014-09-16 13:20:21-ƒÓ²r 332014-09-16 13:20:212014-09-16 13:20:21 +ððø ÊŠf :l†ò +ïøïÊŠf :l†ò       -      -           ­­y*M]Ô7ª 9 ¬ N K ~ SJþû„_;‰tablereservesreserves+CREATE TABLE "reserves" H6o;qindexindex_resource_import_results_on_manifestation_idresource_import_results½CREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-7];Mindexindex_resource_import_results_on_item_idrH6o;qindexindex_resource_import_results_on_manifestation_idresource_import_results½CREATE INDEX "index_resource_import_results_on_manifestation_id" ON "resource_import_results" ("manifestation_id")-7];Mindexindex_resource_import_results_on_item_idresource_import_results¾CREATE INDEX "index_resource_import_results_on_item_id" ON "resource_import_results" ("item_id")‚855ƒ_tableagent_import_resultsagent_import_results¿CREATE TABLE "agent_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "agent_import_file_id" integer, "agent_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚ 955ƒ9tableevent_import_resultsevent_import_resultsÀCREATE TABLE "event_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "event_import_file_id" integer, "event_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)t:Cindexindex_items_on_bookstore_iditemsÁCREATE INDEX "index_items_on_bookstore_id" ON "items" ("bookstore_id")„_;‰tablereservesreserves+CREATE TABLE "reserves" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer NOT NULL, "manifestation_id" integer NOT NULL, "item_id" integer, "request_status_type_id" integer NOT NULL, "checked_out_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "canceled_at" datetime, "expired_at" datetime, "deleted_at" datetime, "state" varchar(255), "expiration_notice_to_patron" boolean DEFAULT 'f', "expiration_notice_to_library" boolean DEFAULT 'f', "retained_at" datetime, "postponed_at" datetime, "lock_version" integer DEFAULT 0 NOT NULL)p<?indexindex_reserves_on_user_idreserves,CREATE INDEX "index_reserves_on_user_id" ON "reserves" ("user_id") =Q5indexindex_reserves_on_manifestation_idreserves-CREATE INDEX "index_reserves_on_manifestation_id" ON "reserves" ("manifestation_id")p>?indexindex_reserves_on_item_idreserves/CREATE INDEX "index_reserves_on_item_id" ON "reserves" ("item_id")?]Mindexindex_reserves_on_request_status_type_idreservesÂCREATE INDEX "index_reserves_on_request_status_type_id" ON "reserves" ("request_status_type_id")y@EE‚stableseries_statement_merge_listsseries_statement_merge_listsÃCREATE TABLE "series_statement_merge_lists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚/A;;ƒstableseries_statement_mergesseries_statement_mergesÄCREATE TABLE "series_statement_merges" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "series_statement_id" integer NOT NULL, "series_statement_merge_list_id" integer NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)QBu;}indexindex_series_statement_merges_on_series_statement_idseries_statement_mergesÅCREATE INDEX "index_series_statement_merges_on_series_statement_id" ON "series_statement_merges" ("series_statement_id")sC ;‚)indexindex_series_statement_merges_on_series_statement_merge_list_idseries_statement_mergesÆCREATE INDEX "index_series_statement_merges_on_series_statement_merge_list_id" ON "series_statement_merges" ("series_statement_merge_list_id")0Dc/Yindexindex_series_statements_on_manifestation_idseries_statementsÇCREATE INDEX "index_series_statements_on_manifestation_id" ON "series_statements" ("manifestation_id")~E%%ƒ=tablecreate_typescreate_typesÈCREATE TABLE "create_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   -  + ˜Îg4šÌ˜.ƒáíã]332014-09-16 13:20:212014-09-16 13:20:21.‚’ÿÈz332014-09-16 13:20:212014-09-16 13:20:21.ªã©o332014-09-16 13:20:212014-09-16 13:20:21.ì‚ùU332014-09-16 13:20:212014-09-16 13:20:21.âÆŠW332014-09-16 13:20:212014-09-16 13:20:21.¤§Úq332014-09-16 13:20:212014-09-16 13:20:21-À¸šx 332014-09-16 13:20:212014-09-16 13:20:21 +ÂøïæÝÔËÂ<;qÝ"_äzXÔï €¼Õ Q…W‰íq  x +ÁåÓÊÁÜî÷<;qÝ"_äzXÔï €¼Õ Q…W‰íq x   -  -      -   +  •Ë•4 33MyText2014-09-16 13:20:212014-09-16 13:20:213 33MyText2014-09-16 13:20:212014-09-16 13:20:21           -  aû ö S Q i +Þü÷òíèãÞ  ;aû ö S Q i ó -ƒa à C»;ÉKÝJÆõ…M11‰Itableevent_import_filesevent_import_files€CREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "event_import_file_name" varchar(255), "event_import_content_type" varchar(255), "event_import_file_size" integer, "event_import_updated_at" datetime, "edit_mode" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "event_import_fingerprint" varchar(255), "error_message" text, "user_encoding" varchar(255), "default_library_id" integer, "default_event_category_id" integer)‚ -X--ƒEtableidentifier_typesidentifier_typesÙCREATE TABLE "identifier_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?Wm/mindexindex_series_statements_on_root_manifestation_idseries_statementsØCREATE INDEX "index_series_statements_on_root_manifestation_id" ON "series_statements" ("root_manifestation_id")VK)indexindex_items_on_checkout_type_iditems×CREATE INDEX "index_items_on_checkout_type_id" ON "items" ("checkout_type_id")UU=indexindex_items_on_circulation_status_iditemsÖCREATE INDEX "index_items_on_circulation_status_id" ON "items" ("circulation_status_id")kT; indexindex_reserves_on_statereservesÕCREATE INDEX "index_reserves_on_state" ON "reserves" ("state"){SC'indexindex_users_on_unlock_tokenusersÔCREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")oR;indexindex_users_on_usernameusersÓCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")}QC)indexindex_manifestations_on_doimanifestationsÒCREATE INDEX "index_manifestations_on_doi" ON "manifestations" ("doi")PM-indexindex_agents_on_agent_identifieragentsÑCREATE INDEX "index_agents_on_agent_identifier" ON "agents" ("agent_identifier")OS19indexindex_event_import_files_on_user_idevent_import_files‚CREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")NW1Aindexindex_event_import_files_on_parent_idevent_import_filesCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id")mL= indexindex_accepts_on_item_idacceptsÐCREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")sKAindexindex_accepts_on_basket_idacceptsÏCREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")dJƒtableacceptsacceptsÎCREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~I%%ƒ=tablebudget_typesbudget_typesÌCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)H[Windexindex_users_on_checkout_icalendar_tokenusersËCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")‚G''ƒ?tableproduce_typesproduce_typesÊCREATE TABLE "produce_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚F''ƒ?tablerealize_typesrealize_typesÉCREATE TABLE "realize_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)  +ƒa à C»ÉKÝJÆõõ…M11‰Itableevent_import_filesevent_import_files€CREATE TABLE "event_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "content_type" varchar(255), "size" integer, "user_id" integer, "note" text, "executed_at" datetime, "event_import_file_name" varchar(255), "event_import_content_type" varchar(255), "event_import_file_size" integer, "event_import_updated_at" datetime, "edit_mode" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "event_import_fingerprint" varchar(255), "error_message" text, "user_encoding" varchar(255), "default_library_id" integer, "default_event_category_id" integer)‚ +X--ƒEtableidentifier_typesidentifier_typesÙCREATE TABLE "identifier_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)?Wm/mindexindex_series_statements_on_root_manifestation_idseries_statementsØCREATE INDEX "index_series_statements_on_root_manifestation_id" ON "series_statements" ("root_manifestation_id")VK)indexindex_items_on_checkout_type_iditems×CREATE INDEX "index_items_on_checkout_type_id" ON "items" ("checkout_type_id")UU=indexindex_items_on_circulation_status_iditemsÖCREATE INDEX "index_items_on_circulation_status_id" ON "items" ("circulation_status_id")kT; indexindex_reserves_on_statereservesÕCREATE INDEX "index_reserves_on_state" ON "reserves" ("state"){SC'indexindex_users_on_unlock_tokenusersÔCREATE UNIQUE INDEX "index_users_on_unlock_token" ON "users" ("unlock_token")oR;indexindex_users_on_usernameusersÓCREATE UNIQUE INDEX "index_users_on_username" ON "users" ("username")€C)indexindex_manifestations_on_doimanifestationsÒCREATE INDEX "index_manifestations_on_doi" ON "manifestations" ("doi")PM-indexindex_agents_on_agent_identifieragentsÑCREATE INDEX "index_agents_on_agent_identifier" ON "agents" ("agent_identifier")OS19indexindex_event_import_files_on_user_idevent_import_files‚CREATE INDEX "index_event_import_files_on_user_id" ON "event_import_files" ("user_id")NW1Aindexindex_event_import_files_on_parent_idevent_import_filesCREATE INDEX "index_event_import_files_on_parent_id" ON "event_import_files" ("parent_id")mL= indexindex_accepts_on_item_idacceptsÐCREATE INDEX "index_accepts_on_item_id" ON "accepts" ("item_id")sKAindexindex_accepts_on_basket_idacceptsÏCREATE INDEX "index_accepts_on_basket_id" ON "accepts" ("basket_id")dJƒtableacceptsacceptsÎCREATE TABLE "accepts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "basket_id" integer, "item_id" integer, "librarian_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)~I%%ƒ=tablebudget_typesbudget_typesÌCREATE TABLE "budget_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)H[Windexindex_users_on_checkout_icalendar_tokenusersËCREATE UNIQUE INDEX "index_users_on_checkout_icalendar_token" ON "users" ("checkout_icalendar_token")‚G''ƒ?tableproduce_typesproduce_typesÊCREATE TABLE "produce_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚F''ƒ?tablerealize_typesrealize_typesÉCREATE TABLE "realize_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "display_name" text, "note" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)    +ªü÷òíèãÞÙÔÏÊÅÀ»¶°ªÊÉhgfe  +  +¦ +±÷èÏÞÅ»± user4 user3 user2!librarian2 user1!librarian1 admin +Þü÷òíèãÞ    - - - -       WÄ l ! -W ¢ íCl==ƒb^‡tableprofilesprofilesàCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "library_id" integer, "locale" varchar(255), "user_number" varchar(255), "full_name" text, "note" text, "keyword_list" text, "required_role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "checkout_icalendar_token" varchar(255), "save_checkout_history" boolean DEFAULT 'f' NOT NULL, "expired_at" datetime)|fC‚9indexindex_message_request_transitions_on_sort_key_and_request_idmessage_request_transitionsèCREATE UNIQUE INDEX "index_message_request_transitions_on_sort_key_and_request_id" ON "message_request_transitions" ("sort_key", "message_request_id")^e{C‚ indexindex_message_request_transitions_on_message_request_idmessage_request_transitionsçCREATE INDEX "index_message_request_transitions_on_message_request_id" ON "message_request_transitions" ("message_request_id")‚IdCC„tablemessage_request_transitionsmessage_request_transitionsæCREATE TABLE "message_request_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_request_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Scu3‚ indexindex_message_transitions_on_sort_key_and_message_idmessage_transitionsåCREATE UNIQUE INDEX "index_message_transitions_on_sort_key_and_message_id" ON "message_transitions" ("sort_key", "message_id")&b[3Iindexindex_message_transitions_on_message_idmessage_transitionsäCREATE INDEX "index_message_transitions_on_message_id" ON "message_transitions" ("message_id")‚)a33ƒwtablemessage_transitionsmessage_transitionsãCREATE TABLE "message_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)`G/indexindex_profiles_on_user_numberprofilesâCREATE UNIQUE INDEX "index_profiles_on_user_number" ON "profiles" ("user_number")q_?indexindex_profiles_on_user_idprofilesáCREATE INDEX "index_profiles_on_user_id" ON "profiles" ("user_id")‚]33ƒ3tableuser_import_resultsuser_import_resultsßCREATE TABLE "user_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_import_file_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)„G\//ˆ;tableuser_import_filesuser_import_filesÝCREATE TABLE "user_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "executed_at" datetime, "user_import_file_name" varchar(255), "user_import_content_type" varchar(255), "user_import_file_size" varchar(255), "user_import_updated_at" datetime, "user_import_fingerprint" varchar(255), "edit_mode" varchar(255), "error_message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_encoding" varchar(255), "default_library_id" integer, "default_user_group_id" integer)[W#Aindexindex_identifiers_on_manifestation_ididentifiersÜCREATE INDEX "index_identifiers_on_manifestation_id" ON "identifiers" ("manifestation_id")8Zm#kindexindex_identifiers_on_body_and_identifier_type_ididentifiersÛCREATE INDEX "index_identifiers_on_body_and_identifier_type_id" ON "identifiers" ("body", "identifier_type_id")‚8Y##„5tableidentifiersidentifiersÚCREATE TABLE "identifiers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255) NOT NULL, "identifier_type_id" integer NOT NULL, "manifestation_id" integer, "primary" boolean, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   +W ¢ íCl==ƒb^‡tableprofilesprofilesàCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_group_id" integer, "library_id" integer, "locale" varchar(255), "user_number" varchar(255), "full_name" text, "note" text, "keyword_list" text, "required_role_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "checkout_icalendar_token" varchar(255), "save_checkout_history" boolean DEFAULT 'f' NOT NULL, "expired_at" datetime)|fC‚9indexindex_message_request_transitions_on_sort_key_and_request_idmessage_request_transitionsèCREATE UNIQUE INDEX "index_message_request_transitions_on_sort_key_and_request_id" ON "message_request_transitions" ("sort_key", "message_request_id")^e{C‚ indexindex_message_request_transitions_on_message_request_idmessage_request_transitionsçCREATE INDEX "index_message_request_transitions_on_message_request_id" ON "message_request_transitions" ("message_request_id")‚IdCC„tablemessage_request_transitionsmessage_request_transitionsæCREATE TABLE "message_request_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_request_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)Scu3‚ indexindex_message_transitions_on_sort_key_and_message_idmessage_transitionsåCREATE UNIQUE INDEX "index_message_transitions_on_sort_key_and_message_id" ON "message_transitions" ("sort_key", "message_id")&b[3Iindexindex_message_transitions_on_message_idmessage_transitionsäCREATE INDEX "index_message_transitions_on_message_id" ON "message_transitions" ("message_id")‚)a33ƒwtablemessage_transitionsmessage_transitionsãCREATE TABLE "message_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "message_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)`G/indexindex_profiles_on_user_numberprofilesâCREATE UNIQUE INDEX "index_profiles_on_user_number" ON "profiles" ("user_number")q_?indexindex_profiles_on_user_idprofilesáCREATE INDEX "index_profiles_on_user_id" ON "profiles" ("user_id")‚]33ƒ3tableuser_import_resultsuser_import_resultsßCREATE TABLE "user_import_results" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_import_file_id" integer, "user_id" integer, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)„G\//ˆ;tableuser_import_filesuser_import_filesÝCREATE TABLE "user_import_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "note" text, "executed_at" datetime, "user_import_file_name" varchar(255), "user_import_content_type" varchar(255), "user_import_file_size" varchar(255), "user_import_updated_at" datetime, "user_import_fingerprint" varchar(255), "edit_mode" varchar(255), "error_message" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "user_encoding" varchar(255), "default_library_id" integer, "default_user_group_id" integer)[W#Aindexindex_identifiers_on_manifestation_ididentifiersÜCREATE INDEX "index_identifiers_on_manifestation_id" ON "identifiers" ("manifestation_id")8Zm#kindexindex_identifiers_on_body_and_identifier_type_ididentifiersÛCREATE INDEX "index_identifiers_on_body_and_identifier_type_id" ON "identifiers" ("body", "identifier_type_id")‚8Y##„5tableidentifiersidentifiersÚCREATE TABLE "identifiers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" varchar(255) NOT NULL, "identifier_type_id" integer NOT NULL, "manifestation_id" integer, "primary" boolean, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)   Ò¯`¿t# ÒO AAja000072007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fO AAja000062007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fI AAja2008-01-18 04:29:06.9227282008-05-31 03:42:44.711117fN  AAja000042008-01-18 03:24:04.2223442008-05-31 03:42:23.340575fO AAja000032007-11-19 07:58:34.6374132008-05-31 04:02:25.101261fM  AAja000022007-11-19 07:58:33.1724412008-05-31 03:41:16.337474fO AAen000012007-11-19 07:58:32.1119412008-05-31 04:16:30.163731f +ØüöðêäÞØ +ÀÔ÷íãÙÊÀ 00007 00006 00004 00003 00002 00001         -  -   ££éüE  p a e º «¯‚i M‚Qindexi‚]gMM„+tableresource_import_file_transitionsresource_import_file_transitionséCREATE TABLE "resource_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}'‚]gMM„+tableresource_import_file_transitionsresource_import_file_transitionséCREATE TABLE "resource_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "resource_import_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)ahoM‚indexindex_resource_import_file_transitions_on_file_idresource_import_file_transitionsêCREATE INDEX "index_resource_import_file_transitions_on_file_id" ON "resource_import_file_transitions" ("resource_import_file_id")‚i M‚Qindexindex_resource_import_file_transitions_on_sort_key_and_file_idresource_import_file_transitionsëCREATE UNIQUE INDEX "index_resource_import_file_transitions_on_sort_key_and_file_id" ON "resource_import_file_transitions" ("sort_key", "resource_import_file_id")‚EjAA„tableimport_request_transitionsimport_request_transitionsìCREATE TABLE "import_request_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "import_request_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)WkwA‚indexindex_import_request_transitions_on_import_request_idimport_request_transitionsîCREATE INDEX "index_import_request_transitions_on_import_request_id" ON "import_request_transitions" ("import_request_id")wlA‚3indexindex_import_request_transitions_on_sort_key_and_request_idimport_request_transitionsïCREATE UNIQUE INDEX "index_import_request_transitions_on_sort_key_and_request_id" ON "import_request_transitions" ("sort_key", "import_request_id")‚QmGG„tableevent_import_file_transitionsevent_import_file_transitionsðCREATE TABLE "event_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "event_import_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mnG‚indexindex_event_import_file_transitions_on_event_import_file_idevent_import_file_transitionsñCREATE INDEX "index_event_import_file_transitions_on_event_import_file_id" ON "event_import_file_transitions" ("event_import_file_id")‚oG‚?indexindex_event_import_file_transitions_on_sort_key_and_file_idevent_import_file_transitionsòCREATE UNIQUE INDEX "index_event_import_file_transitions_on_sort_key_and_file_id" ON "event_import_file_transitions" ("sort_key", "event_import_file_id")‚QpGG„tableagent_import_file_transitionsagent_import_file_transitionsóCREATE TABLE "agent_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "agent_import_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mqG‚indexindex_agent_import_file_transitions_on_agent_import_file_idagent_import_file_transitionsôCREATE INDEX "index_agent_import_file_transitions_on_agent_import_file_id" ON "agent_import_file_transitions" ("agent_import_file_id")‚rG‚?indexindex_agent_import_file_transitions_on_sort_key_and_file_idagent_import_file_transitionsõCREATE UNIQUE INDEX "index_agent_import_file_transitions_on_sort_key_and_file_id" ON "agent_import_file_transitions" ("sort_key", "agent_import_file_id")‚MsEE„tableuser_import_file_transitionsuser_import_file_transitionsöCREATE TABLE "user_import_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_import_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)             - TT=<•–ë Ü -à ] e‡ƒ ¹‚~[‚gindexindex_manifestation_checkout_stat{uE‚9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitionsøCREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")‚UvII„#tableuser_checkout_stat_transitionsuser_checkout_stat_transitionsùCREATE TABLE "user_checkout_stat_transitions" ("id" INTEGER PRIMARY KEY AUetE‚indexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions÷CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id"){uE‚9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitionsøCREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")‚UvII„#tableuser_checkout_stat_transitionsuser_checkout_stat_transitionsùCREATE TABLE "user_checkout_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_checkout_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)twI‚!indexindex_user_checkout_stat_transitions_on_user_checkout_stat_iduser_checkout_stat_transitionsúCREATE INDEX "index_user_checkout_stat_transitions_on_user_checkout_stat_id" ON "user_checkout_stat_transitions" ("user_checkout_stat_id")‚xI‚Eindexindex_user_checkout_stat_transitions_on_sort_key_and_stat_iduser_checkout_stat_transitionsüCREATE UNIQUE INDEX "index_user_checkout_stat_transitions_on_sort_key_and_stat_id" ON "user_checkout_stat_transitions" ("sort_key", "user_checkout_stat_id")‚QyGG„tableuser_reserve_stat_transitionsuser_reserve_stat_transitionsýCREATE TABLE "user_reserve_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_reserve_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mzG‚indexindex_user_reserve_stat_transitions_on_user_reserve_stat_iduser_reserve_stat_transitionsþCREATE INDEX "index_user_reserve_stat_transitions_on_user_reserve_stat_id" ON "user_reserve_stat_transitions" ("user_reserve_stat_id")‚{G‚?indexindex_user_reserve_stat_transitions_on_sort_key_and_stat_iduser_reserve_stat_transitionsÿCREATE UNIQUE INDEX "index_user_reserve_stat_transitions_on_sort_key_and_stat_id" ON "user_reserve_stat_transitions" ("sort_key", "user_reserve_stat_id")‚y|[[„Gtablemanifestation_checkout_stat_transitionsmanifestation_checkout_stat_transitionsCREATE TABLE "manifestation_checkout_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "manifestation_checkout_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚}}[‚;indexindex_manifestation_checkout_stat_transitions_on_stat_idmanifestation_checkout_stat_transitionsCREATE INDEX "index_manifestation_checkout_stat_transitions_on_stat_id" ON "manifestation_checkout_stat_transitions" ("manifestation_checkout_stat_id")‚~[‚gindexindex_manifestation_checkout_stat_transitions_on_transitionmanifestation_checkout_stat_transitionsCREATE UNIQUE INDEX "index_manifestation_checkout_stat_transitions_on_transition" ON "manifestation_checkout_stat_transitions" ("sort_key", "manifestation_checkout_stat_id")‚uYY„Ctablemanifestation_reserve_stat_transitionsmanifestation_reserve_stat_transitionsCREATE TABLE "manifestation_reserve_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "manifestation_reserve_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) + 44umv˼À += E g àã¹etE‚indexindex_user_import_file_transitions_on_user_import_file_iduser_import_file_transitions÷CREATE INDEX "index_user_import_file_transitions_on_user_import_file_id" ON "user_import_file_transitions" ("user_import_file_id"){uE‚9indexindex_user_import_file_transitions_on_sort_key_and_file_iduser_import_file_transitionsøCREATE UNIQUE INDEX "index_user_import_file_transitions_on_sort_key_and_file_id" ON "user_import_file_transitions" ("sort_key", "user_import_file_id")‚UvII„#tableuser_checkout_stat_transitionsuser_checkout_stat_transitionsùCREATE TABLE "user_checkout_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_checkout_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)twI‚!indexindex_user_checkout_stat_transitions_on_user_checkout_stat_iduser_checkout_stat_transitionsúCREATE INDEX "index_user_checkout_stat_transitions_on_user_checkout_stat_id" ON "user_checkout_stat_transitions" ("user_checkout_stat_id")‚xI‚Eindexindex_user_checkout_stat_transitions_on_sort_key_and_stat_iduser_checkout_stat_transitionsüCREATE UNIQUE INDEX "index_user_checkout_stat_transitions_on_sort_key_and_stat_id" ON "user_checkout_stat_transitions" ("sort_key", "user_checkout_stat_id")‚QyGG„tableuser_reserve_stat_transitionsuser_reserve_stat_transitionsýCREATE TABLE "user_reserve_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_reserve_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)mzG‚indexindex_user_reserve_stat_transitions_on_user_reserve_stat_iduser_reserve_stat_transitionsþCREATE INDEX "index_user_reserve_stat_transitions_on_user_reserve_stat_id" ON "user_reserve_stat_transitions" ("user_reserve_stat_id")‚{G‚?indexindex_user_reserve_stat_transitions_on_sort_key_and_stat_iduser_reserve_stat_transitionsÿCREATE UNIQUE INDEX "index_user_reserve_stat_transitions_on_sort_key_and_stat_id" ON "user_reserve_stat_transitions" ("sort_key", "user_reserve_stat_id")‚y|[[„Gtablemanifestation_checkout_stat_transitionsmanifestation_checkout_stat_transitionsCREATE TABLE "manifestation_checkout_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "manifestation_checkout_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚}}[‚;indexindex_manifestation_checkout_stat_transitions_on_stat_idmanifestation_checkout_stat_transitionsCREATE INDEX "index_manifestation_checkout_stat_transitions_on_stat_id" ON "manifestation_checkout_stat_transitions" ("manifestation_checkout_stat_id")‚~[‚gindexindex_manifestation_checkout_stat_transitions_on_transitionmanifestation_checkout_stat_transitionsCREATE UNIQUE INDEX "index_manifestation_checkout_stat_transitions_on_transition" ON "manifestation_checkout_stat_transitions" ("sort_key", "manifestation_checkout_stat_id")‚uYY„Ctablemanifestation_reserve_stat_transitionsmanifestation_reserve_stat_transitionsCREATE TABLE "manifestation_reserve_stat_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "manifestation_reserve_stat_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚{Y‚5indexindex_manifestation_reserve_stat_transitions_on_stat_idmanifestation_reserve_stat_transitionsCREATE INDEX "index_manifestation_reserve_stat_transitions_on_stat_id" ON "manifestation_reserve_stat_transitions" ("manifestation_reserve_stat_id")‚‚Y‚aindexindex_manifestation_reserve_stat_transitions_on_transitionmanifestation_reserve_stat_transitionsCREATE UNIQUE INDEX "index_manifestation_reserve_stat_transitions_on_transition" ON "manifestation_reserve_stat_transitions" ("sort_key", "manifestation_reserve_stat_id")          -  -ááäa  -b G Z Þ/  £ @  ÆuC{‚ -ƒ‚77…Utableresource_export_filesresource_export_filesCREATE TABLE "resource_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "resource_export_file_name" varchar(255), "resource_export_content_type" varchar(255), "resource_export_file_size" integer, "resource_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚]‚MM„+tableresource_export_file_transitionsresource_export_file_transitionsCREATE TABLE "resource_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "resource_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)a‚oM‚indexindex_resource_export_file_transitions_on_file_idresource_export_file_transitions CREATE INDEX "index_resource_export_file_transitions_on_file_id" ON "resource_export_file_transitions" ("resource_export_file_id")‚‚ M‚Qindexindex_resource_export_file_transitions_on_sort_key_and_file_idresource_export_file_transitions -CREATE UNIQUE INDEX "index_resource_export_file_transitions_on_sort‚{Y‚5indexindex_manifestation_reserve_stat_transitions_on_stat_idmanifestation_reserve_stat_transitionsCREATE INDEX "index_manifestation_reserve_stat_transitions_on_stat_id" ON "manifestation_reserve_stat_transitions" ("manifestation_reserve_stat_id")‚‚Y‚aindexindex_manifestation_reserve_stat_transitions_on_transitionmanifestation_reserve_stat_transitionsCREATE UNIQUE INDEX "index_manifestation_reserve_stat_transitions_on_transition" ON "manifestation_reserve_stat_transitions" ("sort_key", "manifestation_reserve_stat_id")]‚5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email")ƒ‚77…Utableresource_export_filesresource_export_filesCREATE TABLE "resource_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "resource_export_file_name" varchar(255), "resource_export_content_type" varchar(255), "resource_export_file_size" integer, "resource_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚]‚MM„+tableresource_export_file_transitionsresource_export_file_transitionsCREATE TABLE "resource_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "resource_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)a‚oM‚indexindex_resource_export_file_transitions_on_file_idresource_export_file_transitions CREATE INDEX "index_resource_export_file_transitions_on_file_id" ON "resource_export_file_transitions" ("resource_export_file_id")‚‚ M‚Qindexindex_resource_export_file_transitions_on_sort_key_and_file_idresource_export_file_transitions -CREATE UNIQUE INDEX "index_resource_export_file_transitions_on_sort_key_and_file_id" ON "resource_export_file_transitions" ("sort_key", "resource_export_file_id")ƒ‚//…-tableuser_export_filesuser_export_files CREATE TABLE "user_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_export_file_name" varchar(255), "user_export_content_type" varchar(255), "user_export_file_size" integer, "user_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚M‚EE„tableuser_export_file_transitionsuser_export_file_transitions CREATE TABLE "user_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M‚ gEyindexindex_user_export_file_transitions_on_file_iduser_export_file_transitions CREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id")  +  rrÒrÓ¸ËO   +q p . ËQC{‚ +ƒ‚77…Utableresource_export_filesresource_export_filesCREATE TABLE "resource_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "resource_export_file_name" varchar(255), "resource_export_content_type" varchar(255), "resource_export_file_size" integer, "resource]‚5}indexindex_users_on_emailusers CREATE INDEX "index_users_on_email" ON "users" ("email")ƒ‚77…Utableresource_export_filesresource_export_filesCREATE TABLE "resource_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "resource_export_file_name" varchar(255), "resource_export_content_type" varchar(255), "resource_export_file_size" integer, "resource_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚]‚MM„+tableresource_export_file_transitionsresource_export_file_transitionsCREATE TABLE "resource_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "resource_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)a‚oM‚indexindex_resource_export_file_transitions_on_file_idresource_export_file_transitions CREATE INDEX "index_resource_export_file_transitions_on_file_id" ON "resource_export_file_transitions" ("resource_export_file_id")‚‚ M‚Qindexindex_resource_export_file_transitions_on_sort_key_and_file_idresource_export_file_transitions +CREATE UNIQUE INDEX "index_resource_export_file_transitions_on_sort_key_and_file_id" ON "resource_export_file_transitions" ("sort_key", "resource_export_file_id")ƒ‚//…-tableuser_export_filesuser_export_files CREATE TABLE "user_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "user_export_file_name" varchar(255), "user_export_content_type" varchar(255), "user_export_file_size" integer, "user_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚M‚EE„tableuser_export_file_transitionsuser_export_file_transitions CREATE TABLE "user_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "user_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M‚ gEyindexindex_user_export_file_transitions_on_file_iduser_export_file_transitions CREATE INDEX "index_user_export_file_transitions_on_file_id" ON "user_export_file_transitions" ("user_export_file_id"){‚ +E‚9indexindex_user_export_file_transitions_on_sort_key_and_file_iduser_export_file_transitionsCREATE UNIQUE INDEX "index_user_export_file_transitions_on_sort_key_and_file_id" ON "user_export_file_transitions" ("sort_key", "user_export_file_id")‚ YEindexindex_items_on_binding_item_identifieritemsCREATE INDEX "index_items_on_binding_item_identifier" ON "items" ("binding_item_identifier")‚ K)indexindex_items_on_manifestation_iditemsCREATE INDEX "index_items_on_manifestation_id" ON "items" ("manifestation_id")‚ U3=indexindex_user_checkout_stats_on_user_iduser_checkout_statsCREATE INDEX "index_user_checkout_stats_on_user_id" ON "user_checkout_stats" ("user_id")‚S19indexindex_user_reserve_stats_on_user_iduser_reserve_statsCREATE INDEX "index_user_reserve_stats_on_user_id" ON "user_reserve_stats" ("user_id")A‚gEaindexindex_manifestation_checkout_stats_on_user_idmanifestation_checkout_statsCREATE INDEX "index_manifestation_checkout_stats_on_user_id" ON "manifestation_checkout_stats" ("user_id")=‚eC]indexindex_manifestation_reserve_stats_on_user_idmanifestation_reserve_statsCREATE INDEX "index_manifestation_reserve_stats_on_user_id" ON "manifestation_reserve_stats" ("user_id")+‚acindexindex_profiles_on_checkout_icalendar_tokenprofilesCREATE UNIQUE INDEX "index_profiles_on_checkout_icalendar_token" ON "profiles" ("checkout_icalendar_token")              -   ·‘ ) ­ -N -ë ° q «»·‚‚G‚?indexindex_event_export_file_transitions_on_sort_key_and_file_idevent_export_file_transitionsCREATE UNIQUE INDEX "index_event_export_file_transitions_on_sort_key_and_file_id" ON "event_export_file_transitions" ("sort_key", "event_export_file_id")R‚iGindexindex_event_export_file_transitions_on_file_idevent_export_file_transitionsCREATE INDEX "index_event_export_file_transitions_on_file_id" ON "event_export_file_transitions" ("event_export_file_id"){‚ -E‚9indexindex_user_export_file_transitions_on_sort_key_and_file_iduser_export_file_transitionsCREATE UNIQUE INDEX "index_user_export_file_transitions_on_sort_key_and_file_id" ON "user_export_file_transitions" ("sort_key", "user_export_file_id")‚ YEindexindex_items_on_binding_item_identifieritemsCREATE INDEX "index_items_on_binding_item_identifier" ON "items" ("binding_item_identifier")‚ K)indexindex_items_on_manifestation_iditemsCREATE INDEX "index_items_on_manifestation_id" ON "items" ("manifestation_id")‚ U3=indexindex_user_checkout_stats_on_user_iduser_checkout_statsCREATE INDEX "index_user_checkout_stats_on_user_id" ON "user_checkout_stats" ("user_id")‚S19indexindex_user_reserve_stats_on_user_iduser_reserve_statsCREATE INDEX "index_user_reserve_stats_on_user_id" ON "user_reserve_stats" ("user_id")A‚gEaindexindex_manifestation_checkout_stats_on_user_idmanifestation_checkout_statsCREATE INDEX "index_manifestation_checkout_stats_on_user_id" ON "manifestation_checkout_stats" ("user_id")=‚eC]indexindex_manifestation_reserve_stats_on_user_idmanifestation_reserve_statsCREATE INDEX "index_manifestation_reserve_stats_on_user_id" ON "manifestation_reserve_stats" ("user_id")+‚acindexindex_profiles_on_checkout_icalendar_tokenprofilesCREATE UNIQUE INDEX "index_profiles_on_checkout_icalendar_token" ON "profiles" ("checkout_icalendar_token")ƒ‚11…7tableevent_export_filesevent_export_filesCREATE TABLE "event_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "event_export_file_name" varchar(255), "event_export_content_type" varchar(255), "event_export_file_size" integer, "event_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚Q‚GG„tableevent_export_file_transitionsevent_export_file_transitionsCREATE TABLE "event_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "event_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) +Þü÷òíèãÞ jÎœj0 + 332014-09-16 13:20:212014-09-16 13:20:210 + 332014-09-16 13:20:212014-09-16 13:20:210 + 332014-09-16 13:20:212014-09-16 13:20:21  +¨¨3ˆ^b Ú {:Ï€»·³-‚c)Yindexindex_manifestations_on_date_ofƒ‚11…7tableevent_export_filesevent_export_filesCREATE TABLE "event_export_files" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "event_export_file_name" varchar(255), "event_export_content_type" varchar(255), "event_export_file_size" integer, "event_export_updated_at" datetime, "executed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)‚Q‚GG„tableevent_export_file_transitionsevent_export_file_transitionsCREATE TABLE "event_export_file_transitions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "to_state" varchar(255), "metadata" text DEFAULT '{}', "sort_key" integer, "event_export_file_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)R‚iGindexindex_event_export_file_transitions_on_file_idevent_export_file_transitionsCREATE INDEX "index_event_export_file_transitions_on_file_id" ON "event_export_file_transitions" ("event_export_file_id")‚‚G‚?indexindex_event_export_file_transitions_on_sort_key_and_file_idevent_export_file_transitionsCREATE UNIQUE INDEX "index_event_export_file_transitions_on_sort_key_and_file_id" ON "event_export_file_transitions" ("sort_key", "event_export_file_id")Žt‚))#tablemanifestationsmanifestationsCREATE 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, "date_copyrighted" 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, "attachment_file_name" varchar(255), "attachment_content_type" varchar(255), "attachment_file_size" integer, "attachment_updated_at" datetime, "title_alternative_transcription" text, "description" text, "abstract" text, "available_at" datetime, "valid_until" datetime, "date_submitted" datetime, "date_accepted" datetime, "date_caputured" datetime, "pub_date" varchar(255), "edition_string" varchar(255), "volume_number" integer, "issue_number" integer, "serial_number" integer, "content_type_id" integer DEFAULT 1, "year_of_publication" integer, "attachment_meta" text, "month_of_publication" integer, "fulltext_content" boolean, "doi" varchar(255), "serial" boolean, "statement_of_responsibility" text, "publication_place" text, "extent" text, "dimensions" text)‚Y)Eindexindex_manifestations_on_access_addressmanifestationsCREATE INDEX "index_manifestations_on_access_address" ON "manifestations" ("access_address");‚m)mindexindex_manifestations_on_manifestation_identifiermanifestationsCREATE INDEX "index_manifestations_on_manifestation_identifier" ON "manifestations" ("manifestation_identifier")‚Q)5indexindex_manifestations_on_updated_atmanifestationsCREATE INDEX "index_manifestations_on_updated_at" ON "manifestations" ("updated_at")-‚c)Yindexindex_manifestations_on_date_of_publicationmanifestations¦CREATE INDEX "index_manifestations_on_date_of_publication" ON "manifestations" ("date_of_publication")}‚C)indexindex_manifestations_on_doimanifestationsÒCREATE INDEX "index_manifestations_on_doi" ON "manifestations" ("doi")  - + _Œ€¢Ì^ø²f ˜î6TzœÄæ0Tv˜¸Öø:zž(Ô†Düt®¾î2NlŠ®Ðî L x   Ð ò + +. +^ +€ +È "Ò>üŒ @ d ® Ü ø  : h œ º Ú ü  < b ‚ ¨ Ê ò4T‚¢ÀÖ2Tv”ºn’®Ì  AlbaniaAlbaniaALALB008( ##AfghanistanAfghanistanAFAFG004   unknownunknown000000000$ + ArgentinaArgentinaARARG026 + ArmeniaArmeniaAMARM041  ? EstoniaEstoniaEEEST233?&% !!Cape VerdeCape VerdeCVCPV132%$Z Hong KongHong KongHKHKG344Z > EritreaEritreaERERI232>$ CanadaCanadaCACAN124$4= //Equatorial GuineaEquatorial GuineaGQGNQ226="# CameroonCameroonCMCMR120#8 33Antigua and BarbudaAntigua and BarbudaAGATG028 (< ##El SalvadorEl SalvadorSVSLV222<"" CambodiaCambodiaKHKHM116"" AnguillaAnguillaAIAIA660 ! BurundiBurundiBIBDI108! AngolaAngolaAOAGO020* %%Burkina FasoBurkina FasoBFBFA854  AndorraAndorraADAND016" BulgariaBulgariaBGBGR100. ))American SamoaAmerican SamoaASASM0144 //Brunei DarussalamBrunei DarussalamBNBRN096  AlgeriaAlgeriaDZDZA010   unknownunknown000000000( ##AfghanistanAfghanistanAFAFG004  AlbaniaAlbaniaALALB008$ + ArgentinaArgentinaARARG026 + ArmeniaArmeniaAMARM041  ArubaArubaAWABW533 $ AustraliaAustraliaAUAUS030  AustriaAustriaATAUT032& !!AzerbaijanAzerbaijanAZAZE025  BahamasBahamasBSBHS036  BahrainBahrainBHBHR048& !!BangladeshBangladeshBDBGD040" BarbadosBarbadosBBBRB042  BelarusBelarusBYBLR112  BelgiumBelgiumBEBEL046 BelizeBelizeBZBLZ084 BeninBeninBJBEN204  BermudaBermudaBMBMU048 BhutanBhutanBTBTN052  BoliviaBoliviaBOBOL068> 99Bosnia and HerzegovinaBosnia and HerzegovinaBABIH056" BotswanaBotswanaBWBWA058 BrazilBrazilBRBRA062.& ))Cayman IslandsCayman IslandsKYCYM136&B' ==Central African RepublicCentral African RepublicCFCAF140'( ChadChadTDTCD148() ChileChileCLCHL152)* ChinaChinaCNCHN156*"+ ColombiaColombiaCOCOL170+ , ComorosComorosKMCOM174,- CongoCongoCGCOG178-\. WWCongo, the Democratic Republic of theCongo, the Democratic Republic of theCDCOD180.*/ %%Cook IslandsCook IslandsCKCOK184/&0 !!Costa RicaCosta RicaCRCRI1880.1 ))Cote D\'IvoireCote D\'IvoireCICIV3841 2 CroatiaCroatiaHRHRV19123 CubaCubaCUCUB19234 CyprusCyprusCYCYP1964.5 ))Czech RepublicCzech RepublicCZCZE2035 6 DenmarkDenmarkDKDNK2086"7 DjiboutiDjiboutiDJDJI2627"8 DominicaDominicaDMDMA212869 11Dominican RepublicDominican RepublicDODOM2149 : EcuadorEcuadorECECU218:; EgyptEgyptEGEGY818;"@ EthiopiaEthiopiaETETH231@HA CCFalkland Islands (Malvinas)Falkland Islands (Malvinas)FKFLK238A,B ''Faroe IslandsFaroe IslandsFOFRO234BC FijiFijiFJFJI242C D FinlandFinlandFIFIN246DE FranceFranceFRFRA250E,F ''French GuianaFrench GuianaGFGUF254F2G --French PolynesiaFrench PolynesiaPFPYF258GH GabonGabonGAGAB266HI GambiaGambiaGMGMB270I J GeorgiaGeorgiaGEGEO268J K GermanyGermanyDEDEU276KL GhanaGhanaGHGHA288L$M GibraltarGibraltarGIGIB292MN GreeceGreeceGRGRC300N$O GreenlandGreenlandGLGRL304O P GrenadaGrenadaGDGRD308P&Q !!GuadeloupeGuadeloupeGPGLP312QR GuamGuamGUGUM316R$S GuatemalaGuatemalaGTGTM320ST GuineaGuineaGNGIN324T,U ''Guinea-BissauGuinea-BissauGWGNB624UV GuyanaGuyanaGYGUY328VW HaitiHaitiHTHTI332WLX GGHoly See (Vatican City State)Holy See (Vatican City State)VAVAT336X"Y HondurasHondurasHNHND340Y [ HungaryHungaryHUHUN348[ \ IcelandIcelandISISL352\] IndiaIndiaININD356]$^ IndonesiaIndonesiaIDIDN360^D_ ??Iran, Islamic Republic ofIran, Islamic Republic ofIRIRN364_ RO¿ßý=]…£Ç)a©a?û—I¯ÿ…­Íñ1Oƒ­×ÿ ! u ³ Õ û +% +I +s×w)×q +— +ó  ; _ } ¯ õ  4 Z z œ Ò ø  B h Š ° Ü ü DO~¬ì`¶Ö  0 X v š ü4T|š*Jn’®Ìrra L!  AlbaniaAlbaniaALALB008( ##AfghanistanAfghanistanAFAFG004   unknownunknown000000000$ + ArgentinaArgentinaARARG026 + ArmeniaArmeniaAMARM041  ArubaArubaAWABW533 $ AustraliaAustraliaAUAUS030  AustriaAustriaATAUT032& !!AzerbaijanAzerbaijanAZAZE025  BahamasBahamasBSBHS036  BahrainBah* RwandaRwandaRWRWA646ª; 55Netherlands AntillesNetherlands AntillesANANT530&v !!LuxembourgLuxembourgLULUX442v) ##NetherlandsNetherlandsNLNLD528$u LithuaniaLithuaniaLTLTU440u NepalNepalNPNPL524Ž,t ''LiechtensteinLiechtensteinLILIE438t NauruNauruNRNRU520>s 99Libyan Arab JamahiriyaLibyan Arab JamahiriyaLYLBY434s! NamibiaNamibiaNANAM516Œ r LiberiaLiberiaLRLBR430r q LesothoLesothoLSLSO426q p LebanonLebanonLBLBN422po LatviaLatviaLVLVA428o` IraqIraqIQIRQ368` a IrelandIrelandIEIRL372ab IsraelIsraelILISR376bc ItalyItalyITITA380c d JamaicaJamaicaJMJAM388de JapanJapanJPJPN392ef JordanJordanJOJOR400f&g !!KazakhstanKazakhstanKZKAZ398gh KenyaKenyaKEKEN404h"i KiribatiKiribatiKIKIR296i`j [[Korea, Democratic People\'s Republic ofKorea, Democratic People\'s Republic ofKPPRK408j6k 11Korea, Republic ofKorea, Republic ofKRKOR410kl KuwaitKuwaitKWKWT414l&m !!KyrgyzstanKyrgyzstanKGKGZ417mTn OOLao People\'s Democratic RepublicLao People\'s Democratic RepublicLALAO418nw MacaoMacaoMOMAC446wfx aaMacedonia, the Former Yugoslav Republic ofMacedonia, the Former Yugoslav Republic ofMKMKD807x&y !!MadagascarMadagascarMGMDG450yz MalawiMalawiMWMWI454z"{ MalaysiaMalaysiaMYMYS458{"| MaldivesMaldivesMVMDV462|} MaliMaliMLMLI466}~ MaltaMaltaMTMLT470~2 --Marshall IslandsMarshall IslandsMHMHL584' !!MartiniqueMartiniqueMQMTQ474€' !!MauritaniaMauritaniaMRMRT478% MauritiusMauritiusMUMUS480‚ MexicoMexicoMXMEX484ƒQ KKMicronesia, Federated States ofMicronesia, Federated States ofFMFSM583„; 55Moldova, Republic ofMoldova, Republic ofMDMDA498… MonacoMonacoMCMCO492†# MongoliaMongoliaMNMNG496‡' !!MontserratMontserratMSMSR500ˆ! MoroccoMoroccoMAMAR504‰' + !!MozambiqueMozambiqueMZMOZ508Š! MyanmarMyanmarMMMMR104‹- ''New CaledoniaNew CaledoniaNCNCL540‘) ##New ZealandNew ZealandNZNZL554’% NicaraguaNicaraguaNINIC558“ NigerNigerNENER562”! NigeriaNigeriaNGNGA566• NiueNiueNUNIU570–/ ))Norfolk IslandNorfolk IslandNFNFK574—C ==Northern Mariana IslandsNorthern Mariana IslandsMPMNP580˜ NorwayNorwayfNOR578™ OmanOmanOMOMN512š# PakistanPakistanPKPAK586› PalauPalauPWPLW585œ PanamaPanamaPAPAN5913 --Papua New GuineaPapua New GuineaPGPNG598ž# ParaguayParaguayPYPRY600Ÿ PeruPeruPEPER604 )! ##PhilippinesPhilippinesPHPHL608¡#" PitcairnPitcairnPNPCN612¢# PolandPolandPLPOL616£#$ PortugalPortugalPTPRT620¤)% ##Puerto RicoPuerto RicoPRPRI630¥& QatarQatarQAQAT634¦!' ReunionReunionREREU638§!( RomaniaRomaniaROROM642¨7) 11Russian FederationRussian FederationRURUS643©++ %%Saint HelenaSaint HelenaSHSHN654«=, 77Saint Kitts and NevisSaint Kitts and NevisKNKNA659¬)- ##Saint LuciaSaint LuciaLCLCA662­E. ??Saint Pierre and MiquelonSaint Pierre and MiquelonPMSPM666®S/ MMSaint Vincent and the GrenadinesSaint Vincent and the GrenadinesVCVCT670¯0 SamoaSamoaWSWSM882°'1 !!San MarinoSan MarinoSMSMR674± 2>p°Þ  , Z ‚ ¨ Î + +& +T +t +â $ L n š Ø J ˜ ¾ Ü \ € ¢ Ð8Z~¼îBlJÈ^>¸Ú ¢ È î +" +Fó +t +â $ L n š Ø J ˜ ¾ Ü \ € ¢ Ð8Z~¼îBl¸ÚÚ+6 %%Sierra L!; SomaliaSomaliaSOSOM7= SpainSpainESESP724½' !!MartiniqueMartiniqueMQMTQ474€' !!MauritaniaMauritaniaMRMRT478% MauritiusMauritiusMUMUS480‚ MexicoMexicoMXMEX484ƒQ KKMicronesia, Federated States ofMicronesia, Federated States ofFMFSM583„; 55Moldova, Republic ofMoldova, Republic ofMDMDA498… MonacoMonacoMCMCO492†# MongoliaMongoliaMNMNG496‡' !!MontserratMontserratMSMSR500ˆ! MoroccoMoroccoMAMAR504‰' + !!MozambiqueMozambiqueMZMOZ508Š! MyanmarMyanmarMMMMR104‹- ''New CaledoniaNew CaledoniaNCNCL540‘) ##New ZealandNew ZealandNZNZL554’% NicaraguaNicaraguaNINIC558“ NigerNigerNENER562”! NigeriaNigeriaNGNGA566• NiueNiueNUNIU570–/ ))Norfolk IslandNorfolk IslandNFNFK574—C ==Northern Mariana IslandsNorthern Mariana IslandsMPMNP580˜ NorwayNorwayfNOR578™ OmanOmanOMOMN512š# PakistanPakistanPKPAK586› PalauPalauPWPLW585œ PanamaPanamaPAPAN5913 --Papua New GuineaPapua New GuineaPGPNG598ž# ParaguayParaguayPYPRY600Ÿ PeruPeruPEPER604 )! ##PhilippinesPhilippinesPHPHL608¡#" PitcairnPitcairnPNPCN612¢# PolandPolandPLPOL616£#$ PortugalPortugalPTPRT620¤)% ##Puerto RicoPuerto RicoPRPRI630¥& QatarQatarQAQAT634¦!' ReunionReunionREREU638§!( RomaniaRomaniaROROM642¨7) 11Russian FederationRussian FederationRURUS643©++ %%Saint HelenaSaint HelenaSHSHN654«=a YemenYemenYEYEM887á/` ))Western SaharaWestern SaharaEHESH732à5_ //Wallis and FutunaWallis and FutunaWFWLF876ß;^ 55Virgin Islands, U.S.Virgin Islands, U.S.VIVIR850ÞA] ;;Virgin Islands, BritishVirgin Islands, BritishVGVGB092Ý#\ Viet NamViet NamVNVNM704Ü=2 77Sao Tome and PrincipeSao Tome and PrincipeSTSTP678²+3 %%Saudi ArabiaSaudi ArabiaSASAU682³!4 SenegalSenegalSNSEN686´'5 !!SeychellesSeychellesSCSYC690µ+6 %%Sierra LeoneSierra LeoneSLSLE694¶%7 SingaporeSingaporeSGSGP702·#8 SlovakiaSlovakiaSKSVK703¸#9 SloveniaSloveniaSISVN705¹1: ++Solomon IslandsSolomon IslandsSBSLB090º!; SomaliaSomaliaSOSOM706»+< %%South AfricaSouth AfricaZAZAF710¼= SpainSpainESESP724½%> Sri LankaSri LankaLKLKA144¾? SudanSudanSDSDN736¿#@ SurinameSurinameSRSUR740À?A 99Svalbard and Jan MayenSvalbard and Jan MayenSJSJM744Á%B SwazilandSwazilandSZSWZ748ÂC SwedenSwedenSESWE752Ã)D ##SwitzerlandSwitzerlandCHCHE756Ä;E 55Syrian Arab RepublicSyrian Arab RepublicSYSYR760ÅEF ??Taiwan, Province of ChinaTaiwan, Province of ChinaTWTWN158Æ'G !!TajikistanTajikistanTJTJK762ÇKH EETanzania, United Republic ofTanzania, United Republic ofTZTZA834È#I ThailandThailandTHTHA764ÉJ TogoTogoTGTGO768Ê!K TokelauTokelauTKTKL772ËL TongaTongaTOTON776Ì9M 33Trinidad and TobagoTrinidad and TobagoTTTTO780Í!N TunisiaTunisiaTNTUN788ÎO TurkeyTurkeyTRTUR792Ï+P %%TurkmenistanTurkmenistanTMTKM795ÐCQ ==Turks and Caicos IslandsTurks and Caicos IslandsTCTCA796ÑR TuvaluTuvaluTVTUV798ÒS UgandaUgandaUGUGA800Ó!T UkraineUkraineUAUKR804Ô;U 55United Arab EmiratesUnited Arab EmiratesAEARE784Õ/V ))United KingdomUnited KingdomGBGBR826Ö-W ''United StatesUnited StatesUSUSA840×!X UruguayUruguayUYURY858Ø'Y !!UzbekistanUzbekistanUZUZB860Ù!Z VanuatuVanuatuVUVUT548Ú%[ VenezuelaVenezuelaVEVEN862Ûb ZambiaZambiaZMZMB894â#c ZimbabweZimbabweZWZWE716ã bWX•¼Ù  B e † ­ Ò ÷ + +; +\ã• ¢•I&¿{5ˆºW +‡ +þ ! D i † « Ê ë + Pp.ƒ=Ýâ\Ðcþ› z £ È ë + + L k ’ ¹ à û-¸IêË`þ¸jœï«BßzAl²Ïî2Wr‘´Ý²8{ºà]) +##AzerbaijaniAzerbaijaniazazeaze" +SwedishSwedishsvsweswe(+ +EnglishEnglishEnglishenengeng+"9 +YiddishYiddishyiyidyid¹'F +!!IndonesianIndonesianidindindF +AymaraAymaraayaymaym +SwatiSwatisssswsswœ#* +DzongkhaDzongkhadzdzodzo*8 +XhosaXhosaxhxhoxho¸ +PashtoPashtopspuspus€!! +ChechenChechencechecheU +KikuyuKikuyukikikkikU9 +GreekGreekelgreell9# +ChamorroChamorrochchachaT +KhmerKhmerkmkhmkhmT8 +GermanGermandegerdeu8! +CatalanCatalancacatcatS +KazakhKazakhkkkazkazS#7 +GeorgianGeorgiankageokat7! +BurmeseBurmesemyburmya#R +KashmiriKashmirikskaskasR6 +GandaGandalgluglug6Q +KanuriKanurikrkaukauQ#5 +GalicianGalicianglglgglg5% +BulgarianBulgarianbgbulbul4 +FulahFulahfffulful4 +BretonBretonbrbrebre!P +KannadaKannadaknkankanP! +BosnianBosnianbsbosbos3 +FrenchFrenchfrfrefra3!2 +FinnishFinnishfifinfin2! +BislamaBislamabibisbis +BihariBiharibhbihXXX)O +##KalaallisutKalaallisutklkalkalO! +BengaliBengalibnbenben#N +JavaneseJavanesejvjavjavN1 +FijianFijianfjfijfij1=M +?Japanese日本語en:Japanese +ja:日本語jajpnjpnM!0 +FaroeseFaroesefofaofao0!L +ItalianItalianititaitaL/ +FantiFantiakakafat/' +!!BelarusianBelarusianbebelbelK +IrishIrishgaglegleK!J +InupiaqInupiaqikipkipkJ +BasqueBasqueeubaqeus. +EweEweeeeweewe.%I +InuktitutInuktitutiuikuikuI#- +EstonianEstonianetestest-! +BashkirBashkirbabakbak)H +##InterlingueInterlingueieileileH! +BambaraBambarabmbambam%, +EsperantoEsperantoeoepoepo,)G +##InterlinguaInterlinguaiainainaG; +7 unknownen:unknown +ja:ä¸æ˜Žunknownunknownunknown% +AbkhazianAbkhazianababkabk +AfarAfaraaaaraar% +AfrikaansAfrikaansafafrafr +AkanAkanakakaaka# +AlbanianAlbaniansqalbsqi! +AmharicAmharicamamhamh +ArabicArabicararaara% +AragoneseAragoneseanargarg # + +ArmenianArmenianhyarmhye +# +AssameseAssameseasasmasm  +AvaricAvaricavavaava ! +AvestanAvestanaeaveave  +AymaraAymaraayaymaym) +##AzerbaijaniAzerbaijaniazazeaze# +ChichewaChichewanynyanya! +ChineseChinesezhchizho- +''Church SlavicChurch Slaviccuchuchu !! +ChuvashChuvashcvchvchv!!" +CornishCornishkwcorcor"## +CorsicanCorsicancocoscos#$ +CreeCreecrcrecre$#% +CroatianCroatianhrhrvhrv%& +CzechCzechcsczeces&' +DanishDanishdadandan'( +DivehiDivehidvdivdiv() +DutchDutchnldutnld)#* +DzongkhaDzongkhadzdzodzo*(+ +EnglishEnglishEnglishenengeng+': +!!GuaraníGuaranígngrngrn:#; +GujaratiGujaratigugujguj;!< +HaitianHaitianhthathat<= +HausaHausahahauhau=> +HebrewHebrewhehebheb>? +HereroHererohzherher?@ +HindiHindihihinhin@%A +Hiri MotuHiri MotuhohmohmoA%B +HungarianHungarianhuhunhunB%C +IcelandicIcelandicisiceislCD +IdoIdoioidoidoDE +IgboIgboigiboiboE'F +!!IndonesianIndonesianidindindF)V +##KinyarwandaKinyarwandarwkinkinV!W +KirghizKirghizkykirkirW!X +KirundiKirundirnrunrunXY +KomiKomikvkomkomYZ +KongoKongokgkonkonZ[ +KoreanKoreankokorkor[!\ +KurdishKurdishkukurkur\#] +KwanyamaKwanyamakjkuakua]^ +LaoLaololaolao^_ +LatinLatinlalatlat_!` +LatvianLatvianlvlavlav`'a +!!LimburgishLimburgishlilimlima!b +LingalaLingalalnlinlinb ZÌf§Y ½žÍ^Ò:`õ®Ïð  @ o • Ð + +* +K +j +‰ +ô6â~8œ­ŠòËÌ  N s ¦ Ç ò  : ] † © Ê û I n ÷]ð{;õeª‡= ´ Ù þ>g†§ÈóCd™ºÛCÔˆ Ì F j ¥ +H | ²8{ºà]) +##AzerbaijaniAzerbaijaniazazeaze" +SwedishSwedishsvsweswe(+ +EnglishEnglishEnglishenengeng+"9 +YiddishYiddishyiyidyid¹'F +!!IndonesianIndonesianidindindF +AymaraAymaraayaymaym +SwatiSwatisssswsswœ#* +DzongkhaDzongkhadzdzodzo*8 +XhosaXhosaxhxhoxho¸ +PashtoPashtopspuspus€! +PanjabiPanjabipapanpan! +AvestanAvestanaeaveave " +SwahiliSwahiliswswaswa›) +& +SardinianSardinianscsrdsrdŒp +MaoriMÄoriimimaomrip%o +MongolianMongolianmnmonmono ) +TswanaTswanatntsntsn©%n +MoldavianMoldavianmomolmoln ( +TsongaTsongatstsotso¨' +TongaTongatotonton§$ +SanskritSanskritsasansan‹ + +SangoSangosgsagsagŠ$& +TigrinyaTigrinyatitirtir¦)m +##MarshalleseMarshallesemhmahmahm"% +TibetanTibetanbotibbod¥ +SamoanSamoansmsmosmo‰" +RussianRussianrurusrusˆ!l +MarathiMarathimrmarmarl$ +ThaiThaiththatha¤$ +RomanianRomanianrorumron‡ # +TeluguTeluguteteltel£k +ManxManxgvglvglvk" +TatarTatartttattat¢. +''Raeto-RomanceRaeto-Romancermrohroh†!j +MalteseMaltesemtmltmltj! +TamilTamiltatamtam¡%i +MalayalamMalayalammlmalmali" +QuechuaQuechuaququeque… +TajikTajiktgtgktgk  +PaliPÄlipiplipli„h +MalayMalaymsmaymsah#g +MalagasyMalagasymgmlgmlgg( +!!PortuguesePortugueseptporporƒ'f +!!MacedonianMacedonianmkmacmkdf  +PolishPolishplpolpol‚-e +''LuxembourgishLuxembourgishlbltzltze< +ZuluZuluzuzulzul¼+d +%%Luba-KatangaLuba-Katangalulublubd ; +ZhuangZhuangzazhazha»$ +TahitianTahitiantytahtahŸ" +TagalogTagalogtltgltglž : +YorubaYorubayoyoryorº'c +!!LithuanianLithuanianltlitlitcq +NauruNaurunanaunauqr +NavajoNavajonvnavnavrs +NdongaNdongangndondost +NepaliNepalinenepnept-u +''North NdebeleNorth Ndebelendndendeu-v +''Northern SamiNorthern Samisesmesmev$w +NorwegianNorwegianfnornorw9x +33Norwegian BokmÃ¥lNorwegian BokmÃ¥lnbnobnobx5y +//Norwegian NynorskNorwegian Nynorsknnnnonnoy!z +OccitanOccitanocociociz{ +OjibwaOjibwaojojioji{| +OriyaOriyaororiori|} +OromoOromoomormorm}#~ +OssetianOssetianosossoss~! +PanjabiPanjabipapanpan +PashtoPashtopspuspus€" +PersianPersianfaperfas2 +++Scottish GaelicScottish Gaelicgdglagla" +SerbianSerbiansrsrpsrpŽ0 +))Serbo-CroatianSerbo-CroatianshXXXhbs +ShonaShonasnsnasna( +!!Sichuan YiSichuan Yiiiiiiiii‘  +SindhiSindhisdsndsnd’" +SinhalaSinhalasisinsin“  +SlovakSlovaksksloslk”& +SlovenianSlovenianslslvslv•  +SomaliSomalisosomsom– +SothoSothostsotsot—. +''South NdebeleSouth Ndebelenrnblnbl˜" +SpanishSpanishesspaspa™& +SundaneseSundanesesusunsunš" +SwahiliSwahiliswswaswa› +SwatiSwatisssswsswœ" +SwedishSwedishsvsweswe"* +TurkishTurkishtrturturª"+ +TurkmenTurkmentktuktuk«, +TwiTwitwtwitwi¬ - +UighurUighuruguiguig­&. +UkrainianUkrainianukukrukr®/ +UrduUrduururdurd¯0 +UzbekUzbekuzuzbuzb°1 +VendaVendavevenven±(2 +!!VietnameseVietnamesevivievie²(3 +!!VolapükVolapükvovolvol³"4 +WalloonWalloonwawlnwln´5 +WelshWelshcywelcymµ26 +++Western FrisianWestern Frisianfyfryfry¶7 +WolofWolofwowolwol·8 +XhosaXhosaxhxhoxho¸"9 +YiddishYiddishyiyidyid¹ \ No newline at end of file