[Projects] [ranch] 35: Add more fields to the systems table.

https://svn.lrde.epita.fr/svn/ranch/trunk Index: ChangeLog from Nicolas Desprès <nicolas.despres(a)lrde.epita.fr> Add more fields to the systems table. * web/ranch/db/schema.rb: Add more fields to the systems table. * web/ranch/test/fixtures/systems.yml: Update accordingly. db/schema.rb | 17 +++++++++++++++-- test/fixtures/systems.yml | 8 ++++++++ 2 files changed, 23 insertions(+), 2 deletions(-) Index: web/ranch/db/schema.rb --- web/ranch/db/schema.rb (revision 34) +++ web/ranch/db/schema.rb (working copy) @@ -5,7 +5,7 @@ ActiveRecord::Schema.define() do create_table "benches", :force => true do |t| - t.column "name", :string, :default => "noname", :null => false + t.column "name", :string, :limit => 255, :default => "noname", :null => false t.column "project_id", :integer, :default => 1, :null => false t.column "revision", :integer, :default => 1, :null => false end @@ -34,7 +34,7 @@ add_index "outputs", ["bench_id"], :name => "bench_id" create_table "projects", :force => true do |t| - t.column "name", :string, :default => "noname", :null => false + t.column "name", :string, :limit => 128, :default => "noname", :null => false t.column "head_revision", :integer, :default => 1, :null => false end @@ -43,4 +43,17 @@ t.column "info", :text, :default => "", :null => false end + create_table "systems", :force => true do |t| + t.column "hostname", :string, :limit => 128, :default => "localhost", :null => false + t.column "kernel_name", :string, :limit => 64 + t.column "kernel_version", :string, :limit => 64 + t.column "host_type", :string, :limit => 64 + t.column "os_name", :string, :limit => 64 + t.column "os_version", :string, :limit => 64 + t.column "comp_name", :string, :limit => 64 + t.column "comp_version", :string, :limit => 64 + t.column "comp_flags", :string, :limit => 64 + t.column "info", :text + end + end Index: web/ranch/test/fixtures/systems.yml --- web/ranch/test/fixtures/systems.yml (revision 34) +++ web/ranch/test/fixtures/systems.yml (working copy) @@ -1,6 +1,14 @@ ouagadougou: id: 1 hostname: ouagadougou.lrde.epita.fr + kernel_name: Linux + kernel_version: "2.4.27-2-k7 #1 Tue Aug 16 17:30:14" + host_type: i686 + os_name: GNU/Linux + os_version: + comp_name: g++ + comp_version: 4.0.3 + comp_flags: -02 -W -Wall info: | Running action system SYSTEM UNAME: CYGWIN_NT-5.1 pau 1.5.18(0.132/4/2) 2005-07-02 20:30 i686 unknown unknown Cygwin