From 60aa8fa77deaf9d4c90c1ede37caeeff13ee283d Mon Sep 17 00:00:00 2001
From: mo khan <mo@mokhan.ca>
Date: Fri, 21 Feb 2014 22:27:13 -0700
Subject: define well types table.

---
 db/migrate/20140222051253_create_well_types.rb |  8 ++++++++
 db/schema.rb                                   |  7 ++++++-
 db/seeds.rb                                    | 10 +++++-----
 3 files changed, 19 insertions(+), 6 deletions(-)
 create mode 100644 db/migrate/20140222051253_create_well_types.rb

(limited to 'db')

diff --git a/db/migrate/20140222051253_create_well_types.rb b/db/migrate/20140222051253_create_well_types.rb
new file mode 100644
index 0000000..aa22bca
--- /dev/null
+++ b/db/migrate/20140222051253_create_well_types.rb
@@ -0,0 +1,8 @@
+class CreateWellTypes < ActiveRecord::Migration
+  def change
+    create_table :well_types do |t|
+      t.string :name
+      t.string :acronym
+    end
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 453bf07..aa1c471 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20140222032401) do
+ActiveRecord::Schema.define(version: 20140222051253) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -32,4 +32,9 @@ ActiveRecord::Schema.define(version: 20140222032401) do
     t.boolean  "confidential", default: false
   end
 
+  create_table "well_types", force: true do |t|
+    t.string "name"
+    t.string "acronym"
+  end
+
 end
diff --git a/db/seeds.rb b/db/seeds.rb
index 4edb1e8..b9d9ff1 100644
--- a/db/seeds.rb
+++ b/db/seeds.rb
@@ -1,7 +1,7 @@
 # This file should contain all the record creation needed to seed the database with its default values.
 # The data can then be loaded with the rake db:seed (or created alongside the db with db:setup).
-#
-# Examples:
-#
-#   cities = City.create([{ name: 'Chicago' }, { name: 'Copenhagen' }])
-#   Mayor.create(name: 'Emanuel', city: cities.first)
+WellType.create(id: 1, acronym: "NFW", name: "New Field Wildcat") unless WellType.exists?(1)
+WellType.create(id: 2, acronym: "NPW", name: "New Pool Wildcat") unless WellType.exists?(2)
+WellType.create(id: 3, acronym: "DPT", name: "Deeper Pool Test") unless WellType.exists?(3)
+WellType.create(id: 4, acronym: "SPT", name: "Shallower Pool Test") unless WellType.exists?(4)
+WellType.create(id: 5, acronym: "DEV", name: "Development Well") unless WellType.exists?(5)
-- 
cgit v1.2.3