diff options
Diffstat (limited to 'lib/puppet/rails/database')
4 files changed, 16 insertions, 16 deletions
diff --git a/lib/puppet/rails/database/001_add_created_at_to_all_tables.rb b/lib/puppet/rails/database/001_add_created_at_to_all_tables.rb index d1035b0db..138f9f151 100644 --- a/lib/puppet/rails/database/001_add_created_at_to_all_tables.rb +++ b/lib/puppet/rails/database/001_add_created_at_to_all_tables.rb @@ -2,16 +2,16 @@ class AddCreatedAtToAllTables < ActiveRecord::Migration def self.up ActiveRecord::Base.connection.tables.each do |t| unless ActiveRecord::Base.connection.columns(t).collect {|c| c.name}.include?("created_at") - add_column t.to_s, :created_at, :datetime - end - end + add_column t.to_s, :created_at, :datetime + end + end end def self.down ActiveRecord::Base.connection.tables.each do |t| unless ActiveRecord::Base.connection.columns(t).collect {|c| c.name}.include?("created_at") remove_column t.to_s, :created_at - end - end + end + end end end diff --git a/lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb b/lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb index 3873a13e2..050ca7f43 100644 --- a/lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb +++ b/lib/puppet/rails/database/002_remove_duplicated_index_on_all_tables.rb @@ -4,7 +4,7 @@ class RemoveDuplicatedIndexOnAllTables < ActiveRecord::Migration if ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id") remove_index t.to_s, :id end - end + end end def self.down @@ -12,6 +12,6 @@ class RemoveDuplicatedIndexOnAllTables < ActiveRecord::Migration unless ActiveRecord::Base.connection.indexes(t).collect {|c| c.columns}.include?("id") add_index t.to_s, :id, :integer => true end - end + end end end diff --git a/lib/puppet/rails/database/003_add_environment_to_host.rb b/lib/puppet/rails/database/003_add_environment_to_host.rb index 3ed10e946..4ab2fbc63 100644 --- a/lib/puppet/rails/database/003_add_environment_to_host.rb +++ b/lib/puppet/rails/database/003_add_environment_to_host.rb @@ -4,7 +4,7 @@ class AddEnvironmentToHost < ActiveRecord::Migration add_column :hosts, :environment, :string end end - + def self.down if ActiveRecord::Base.connection.columns(:hosts).collect {|c| c.name}.include?("environment") remove_column :hosts, :environment diff --git a/lib/puppet/rails/database/schema.rb b/lib/puppet/rails/database/schema.rb index 246bec482..d8fcbb418 100644 --- a/lib/puppet/rails/database/schema.rb +++ b/lib/puppet/rails/database/schema.rb @@ -27,7 +27,7 @@ class Puppet::Rails::Schema add_index :resources, [:title, :restype] end - create_table :source_files do |t| + create_table :source_files do |t| t.column :filename, :string t.column :path, :string t.column :updated_at, :datetime @@ -44,7 +44,7 @@ class Puppet::Rails::Schema add_index :resource_tags, :resource_id, :integer => true add_index :resource_tags, :puppet_tag_id, :integer => true - create_table :puppet_tags do |t| + create_table :puppet_tags do |t| t.column :name, :string t.column :updated_at, :datetime t.column :created_at, :datetime @@ -66,20 +66,20 @@ class Puppet::Rails::Schema add_index :hosts, :source_file_id, :integer => true add_index :hosts, :name - create_table :fact_names do |t| + create_table :fact_names do |t| t.column :name, :string, :null => false t.column :updated_at, :datetime t.column :created_at, :datetime end add_index :fact_names, :name - create_table :fact_values do |t| + create_table :fact_values do |t| t.column :value, :text, :null => false t.column :fact_name_id, :integer, :null => false t.column :host_id, :integer, :null => false t.column :updated_at, :datetime t.column :created_at, :datetime - end + end add_index :fact_values, :fact_name_id, :integer => true add_index :fact_values, :host_id, :integer => true @@ -93,14 +93,14 @@ class Puppet::Rails::Schema end add_index :param_values, :param_name_id, :integer => true add_index :param_values, :resource_id, :integer => true - - create_table :param_names do |t| + + create_table :param_names do |t| t.column :name, :string, :null => false t.column :updated_at, :datetime t.column :created_at, :datetime end add_index :param_names, :name - end + end end ensure $stdout.close |