New rails stuff redux.

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

1 files changed, 64 insertions, 0 deletions

diff --git a/lib/puppet/rails/database/schema.rb b/lib/puppet/rails/database/schema.rb
new file mode 100644
index 000000000..9151bee46
--- /dev/null
+++ b/lib/puppet/rails/database/schema.rb
@@ -0,0 +1,64 @@
+class Puppet::Rails::Schema
+
+def self.init
+    ActiveRecord::Schema.define do
+        create_table :resources do |t|
+            t.column :title, :string, :null => false
+            t.column :type,  :string
+            t.column :host_id, :integer
+            t.column :source_file_id, :integer
+            t.column :exported, :boolean
+        end
+
+        create_table :source_files do |t| 
+            t.column :filename, :string
+            t.column :path, :string
+        end
+
+        create_table :puppet_classes do |t| 
+            t.column :name, :string
+            t.column :host_id, :integer
+            t.column :source_file_id, :integer
+        end
+
+        create_table :hosts do |t|
+            t.column :name, :string, :null => false
+            t.column :ip, :string
+            t.column :connect, :date
+            #Use updated_at to automatically add timestamp on save.
+            t.column :updated_at, :date
+            t.column :source_file_id, :integer
+        end
+
+        create_table :fact_names do |t| 
+            t.column :name, :string, :null => false
+            t.column :host_id, :integer, :null => false
+        end
+
+        create_table :fact_values do |t| 
+            t.column :value, :string, :null => false
+            t.column :fact_name_id, :integer, :null => false
+        end 
+
+        create_table :param_values do |t|
+            t.column :value,  :string, :null => false
+            t.column :param_name_id, :integer, :null => false
+        end
+ 
+        create_table :param_names do |t| 
+            t.column :name, :string, :null => false
+            t.column :resource_id, :integer
+        end
+
+        create_table :tags do |t| 
+            t.column :name, :string
+        end 
+
+        create_table :taggings do |t| 
+            t.column :tag_id, :integer
+            t.column :taggable_id, :integer
+            t.column :taggable_type, :string
+        end
+    end
+end
+end