define relationship between company and licenses and return active licenses.

3 files changed, 25 insertions, 1 deletions

diff --git a/db/migrate/20140221134937_create_companies.rb b/db/migrate/20140221134937_create_companies.rb
new file mode 100644
index 0000000..b2fc820
--- /dev/null
+++ b/db/migrate/20140221134937_create_companies.rb
@@ -0,0 +1,8 @@
+class CreateCompanies < ActiveRecord::Migration
+  def change
+    create_table :companies, id: :uuid do |t|
+      t.string :name
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140221135224_add_active_range_to_licenses.rb b/db/migrate/20140221135224_add_active_range_to_licenses.rb
new file mode 100644
index 0000000..6342f61
--- /dev/null
+++ b/db/migrate/20140221135224_add_active_range_to_licenses.rb
@@ -0,0 +1,7 @@
+class AddActiveRangeToLicenses < ActiveRecord::Migration
+  def change
+    add_column :licenses, :issued_at, :datetime, default: nil
+    add_column :licenses, :expired_at, :datetime, default: nil
+    add_column :licenses, :company_id, :uuid
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index ace9922..b359b4b 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,15 +11,24 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20140221025310) do
+ActiveRecord::Schema.define(version: 20140221135224) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
   enable_extension "uuid-ossp"
 
+  create_table "companies", id: :uuid, default: "uuid_generate_v4()", force: true do |t|
+    t.string   "name"
+    t.datetime "created_at"
+    t.datetime "updated_at"
+  end
+
   create_table "licenses", id: :uuid, default: "uuid_generate_v4()", force: true do |t|
     t.datetime "created_at"
     t.datetime "updated_at"
+    t.datetime "issued_at"
+    t.datetime "expired_at"
+    t.uuid     "company_id"
   end
 
 end