Undo the param_name param_value merge

git-svn-id: https://reductivelabs.com/svn/puppet/trunk@2209 980ebf18-57e1-0310-9a29-db15c13687c0

1 files changed, 16 insertions, 6 deletions

diff --git a/lib/puppet/rails/database/schema.rb b/lib/puppet/rails/database/schema.rb
index 510c94a09..c7941184a 100644
--- a/lib/puppet/rails/database/schema.rb
+++ b/lib/puppet/rails/database/schema.rb
@@ -40,21 +40,31 @@ class Puppet::Rails::Schema
                     t.column :source_file_id, :integer
                 end
 
-                create_table :facts do |t| 
+                create_table :fact_names do |t| 
                     t.column :name, :string, :null => false
-                    t.column :value, :text, :null => false
                     t.column :host_id, :integer, :null => false
                     t.column :updated_at, :datetime
                 end
 
-                create_table :params do |t|
-                    t.column :name, :string, :null => false
+                create_table :fact_values do |t| 
+                    t.column :value, :text, :null => false
+                    t.column :fact_name_id, :integer, :null => false
+                    t.column :updated_at, :datetime
+                end 
+
+                create_table :param_values do |t|
                     t.column :value,  :text, :null => false
-                    t.column :line, :integer
+                    t.column :param_name_id, :integer, :null => false
                     t.column :updated_at, :datetime
-                    t.column :resource_id, :integer
                 end
          
+                create_table :param_names do |t| 
+                    t.column :name, :string, :null => false
+                    t.column :resource_id, :integer
+                    t.column :line, :integer
+                    t.column :updated_at, :datetime
+                end
+
                 create_table :tags do |t| 
                     t.column :name, :string
                     t.column :updated_at, :datetime