シリコンバレー ２４時

% rake db:migrate RAILS_ENV="production"

今度は正常に動作しているようで

(in /usr/home/redmine/redmine-0.6.4)
== Setup: migrating ===========================================================
-- create_table("attachments", {:force=>true})
   -> 0.0192s
-- create_table("auth_sources", {:force=>true})
   -> 0.0207s
.
.
.
.
-- create_table("workflows", {:force=>true})
   -> 0.0161s
== Setup: migrated (2.4450s) ==================================================

== IssueMove: migrating =======================================================
== IssueMove: migrated (0.0311s) ==============================================
.
.
.
== AddCustomFieldsSearchable: migrating =======================================
-- add_column(:custom_fields, :searchable, :boolean, {:default=>false})
   -> 0.1585s
== AddCustomFieldsSearchable: migrated (0.1600s) ==============================

と、エラーメッセージもなく正常に終了したようだ。

確認のために

% ls -l db
total 118
drwxr-xr-x   2 yotumoto  skymerica   3584 Mar 12 11:23 migrate
-rw-r--r--   1 yotumoto  skymerica  90112 Apr 27 23:11 redmine.db
-rw-r--r--   1 yotumoto  skymerica  21330 Apr 27 23:11 schema.rb

のように データベース・ファイル「redmine.db」と 「schema.rb」が新たに作成されたのがわかる。

さらに確認してみると、

% sqlite3 db/redmine.db
SQLite version 3.5.8
Enter ".help" for instructions
sqlite> .database
seq  name             file
---  ---------------  ----------------------------------------------------------
0    main             /usr/home/redmine/redmine-0.6.4/db/redmine.db
sqlite> .table
attachments             issue_relations         time_entries
auth_sources            issue_statuses          tokens
boards                  issues                  trackers
changes                 journal_details         user_preferences
changesets              journals                users
changesets_issues       members                 versions
comments                messages                watchers
custom_fields           news                    wiki_content_versions
custom_fields_projects  projects                wiki_contents
custom_fields_trackers  projects_trackers       wiki_pages
custom_values           queries                 wiki_redirects
documents               repositories            wikis
enabled_modules         roles                   workflows
enumerations            schema_info
issue_categories        settings
sqlite> .quit

このように、SQLite3 の データベース・ファイルであることが 確認できた。