diff options
Diffstat (limited to 'lib/puppet/rails/database/schema.rb')
| -rw-r--r-- | lib/puppet/rails/database/schema.rb | 198 |
1 files changed, 99 insertions, 99 deletions
diff --git a/lib/puppet/rails/database/schema.rb b/lib/puppet/rails/database/schema.rb index 8cb7350eb..8b389d773 100644 --- a/lib/puppet/rails/database/schema.rb +++ b/lib/puppet/rails/database/schema.rb @@ -1,114 +1,114 @@ class Puppet::Rails::Schema - def self.init - oldout = nil - Puppet::Util.benchmark(Puppet, :notice, "Initialized database") do - # We want to rewrite stdout, so we don't get migration messages. - oldout = $stdout - $stdout = File.open("/dev/null", "w") - ActiveRecord::Schema.define do - create_table :resources do |t| - t.column :title, :text, :null => false - t.column :restype, :string, :null => false - t.column :host_id, :integer - t.column :source_file_id, :integer - t.column :exported, :boolean - t.column :line, :integer - t.column :updated_at, :datetime - t.column :created_at, :datetime - end - add_index :resources, :host_id, :integer => true - add_index :resources, :source_file_id, :integer => true + def self.init + oldout = nil + Puppet::Util.benchmark(Puppet, :notice, "Initialized database") do + # We want to rewrite stdout, so we don't get migration messages. + oldout = $stdout + $stdout = File.open("/dev/null", "w") + ActiveRecord::Schema.define do + create_table :resources do |t| + t.column :title, :text, :null => false + t.column :restype, :string, :null => false + t.column :host_id, :integer + t.column :source_file_id, :integer + t.column :exported, :boolean + t.column :line, :integer + t.column :updated_at, :datetime + t.column :created_at, :datetime + end + add_index :resources, :host_id, :integer => true + add_index :resources, :source_file_id, :integer => true - # Thanks, mysql! MySQL requires a length on indexes in text fields. - # So, we provide them for mysql and handle everything else specially. - # Oracle doesn't index on CLOB fields, so we skip it - if Puppet[:dbadapter] == "mysql" - execute "CREATE INDEX typentitle ON resources (restype,title(50));" - elsif Puppet[:dbadapter] != "oracle_enhanced" - add_index :resources, [:title, :restype] - end + # Thanks, mysql! MySQL requires a length on indexes in text fields. + # So, we provide them for mysql and handle everything else specially. + # Oracle doesn't index on CLOB fields, so we skip it + if Puppet[:dbadapter] == "mysql" + execute "CREATE INDEX typentitle ON resources (restype,title(50));" + elsif Puppet[:dbadapter] != "oracle_enhanced" + add_index :resources, [:title, :restype] + end - create_table :source_files do |t| - t.column :filename, :string - t.column :path, :string - t.column :updated_at, :datetime - t.column :created_at, :datetime - end - add_index :source_files, :filename + create_table :source_files do |t| + t.column :filename, :string + t.column :path, :string + t.column :updated_at, :datetime + t.column :created_at, :datetime + end + add_index :source_files, :filename - create_table :resource_tags do |t| - t.column :resource_id, :integer - t.column :puppet_tag_id, :integer - t.column :updated_at, :datetime - t.column :created_at, :datetime - end - add_index :resource_tags, :resource_id, :integer => true - add_index :resource_tags, :puppet_tag_id, :integer => true + create_table :resource_tags do |t| + t.column :resource_id, :integer + t.column :puppet_tag_id, :integer + t.column :updated_at, :datetime + t.column :created_at, :datetime + end + add_index :resource_tags, :resource_id, :integer => true + add_index :resource_tags, :puppet_tag_id, :integer => true - create_table :puppet_tags do |t| - t.column :name, :string - t.column :updated_at, :datetime - t.column :created_at, :datetime - end + create_table :puppet_tags do |t| + t.column :name, :string + t.column :updated_at, :datetime + t.column :created_at, :datetime + end - # Oracle automatically creates a primary key index - add_index :puppet_tags, :id, :integer => true if Puppet[:dbadapter] != "oracle_enhanced" + # Oracle automatically creates a primary key index + add_index :puppet_tags, :id, :integer => true if Puppet[:dbadapter] != "oracle_enhanced" - create_table :hosts do |t| - t.column :name, :string, :null => false - t.column :ip, :string - t.column :environment, :text - t.column :last_compile, :datetime - t.column :last_freshcheck, :datetime - t.column :last_report, :datetime - #Use updated_at to automatically add timestamp on save. - t.column :updated_at, :datetime - t.column :source_file_id, :integer - t.column :created_at, :datetime - end - add_index :hosts, :source_file_id, :integer => true - add_index :hosts, :name + create_table :hosts do |t| + t.column :name, :string, :null => false + t.column :ip, :string + t.column :environment, :text + t.column :last_compile, :datetime + t.column :last_freshcheck, :datetime + t.column :last_report, :datetime + #Use updated_at to automatically add timestamp on save. + t.column :updated_at, :datetime + t.column :source_file_id, :integer + t.column :created_at, :datetime + end + add_index :hosts, :source_file_id, :integer => true + add_index :hosts, :name - 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_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| - 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 - add_index :fact_values, :fact_name_id, :integer => true - add_index :fact_values, :host_id, :integer => true + 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 + add_index :fact_values, :fact_name_id, :integer => true + add_index :fact_values, :host_id, :integer => true - create_table :param_values do |t| - t.column :value, :text, :null => false - t.column :param_name_id, :integer, :null => false - t.column :line, :integer - t.column :resource_id, :integer - t.column :updated_at, :datetime - t.column :created_at, :datetime - end - add_index :param_values, :param_name_id, :integer => true - add_index :param_values, :resource_id, :integer => true + create_table :param_values do |t| + t.column :value, :text, :null => false + t.column :param_name_id, :integer, :null => false + t.column :line, :integer + t.column :resource_id, :integer + t.column :updated_at, :datetime + t.column :created_at, :datetime + end + add_index :param_values, :param_name_id, :integer => true + add_index :param_values, :resource_id, :integer => true - 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 + create_table :param_names do |t| + t.column :name, :string, :null => false + t.column :updated_at, :datetime + t.column :created_at, :datetime end - ensure - $stdout.close - $stdout = oldout if oldout - oldout = nil + add_index :param_names, :name + end end + ensure + $stdout.close + $stdout = oldout if oldout + oldout = nil + end end |