SQLite format 3 @ 6 6 -â
Ð
Ú
ü8>£ÂHdÐ Ù))qtablelibrary_groupslibrary_groups
CREATE TABLE "library_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "display_name" Q)5indexindex_library_groups_on_short_namelibrary_groupsCREATE INDEX "index_library_groups_on_short_name" ON "library_groups" ("short_name")a))}tablelibrary_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, "email" varchar(255), "my_networks" text, "use_dsbl" boolean DEFAULT 'f' NOT NULL, "dsbl_list" text, "login_banner" text, "note" text, "country_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "url" varchar(255) DEFAULT 'http://localhost:3000/')w##
5tableuser_groupsuser_groupsCREATE TABLE "user_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "string" 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)^))wtableuser_has_rolesuser_has_rolesCREATE 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)
SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")
Aatableusersusers CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_group_id" integer, "required_role_id" integer, "username" varchar(255), "note" text, "locale" varchar(255), "user_number" varchar(255), "library_id" integer, "locked_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime 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))!!
ktablenews_postsnews_postsCREATE TABLE "news_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" text, "body" text, "user_id" integer, "start_date" datetime, "end_date" datetime, "required_role_id" integer DEFAULT 1 NOT NULL, "note" text, "position" integer, "draft" boolean DEFAULT 'f' NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "url" varchar(255))xC!indexindex_news_posts_on_user_idnews_postsCREATE INDEX "index_news_posts_on_user_id" ON "news_posts" ("user_id") 5!!
Ctablenews_postsnews_postsCREATE TABLE ] 5}indexindex_users_on_emailusers
CREATE INDEX "index_users_on_email" ON "users" ("email")h/tablerolesrolesCREATE TABLE "roles" ("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)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)&!!tablenews_feedsnews_feedsCREATE TABLE "news_feeds" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_group_id" integer DEFAULT 1 NOT NULL, "title" varchar(255), "url" varchar(255), "body" text, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//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)
R îÜÊžŠ|jdR )20110318183304
77 )2011022207353780)20111201163718)20111201155513)20111201155456)20111201121844)20110220103937)20090126071155)20081031033632
G íÚÇaGŽ¡{Zt )2011031818330477
)20110222073537 80)20111201163718)20111201155513)20111201155456)20111201121844)20110220103937)20090126071155)20081031033632
F €F ±
Yà[3ANDLhttp://iss.ndl.go.jp/information/feed/