Changes to generate.sh

11 files changed, 53 insertions, 41 deletions

diff --git a/db/migrate/20140304014722_create_servers.rb b/db/migrate/20140304014738_create_servers.rb
index f33241a..f33241a 100644
--- a/db/migrate/20140304014722_create_servers.rb
+++ b/db/migrate/20140304014738_create_servers.rb
diff --git a/db/migrate/20140304014725_create_tournaments.rb b/db/migrate/20140304014740_create_tournaments.rb
index 2095590..2095590 100644
--- a/db/migrate/20140304014725_create_tournaments.rb
+++ b/db/migrate/20140304014740_create_tournaments.rb
diff --git a/db/migrate/20140304014727_create_matches.rb b/db/migrate/20140304014742_create_matches.rb
index 1478e75..288ce6a 100644
--- a/db/migrate/20140304014727_create_matches.rb
+++ b/db/migrate/20140304014742_create_matches.rb
@@ -1,6 +1,7 @@
 class CreateMatches < ActiveRecord::Migration
   def change
     create_table :matches do |t|
+      t.reference :tournament
 
       t.timestamps
     end
diff --git a/db/migrate/20140304014729_create_teams.rb b/db/migrate/20140304014745_create_teams.rb
index dd8397d..dd8397d 100644
--- a/db/migrate/20140304014729_create_teams.rb
+++ b/db/migrate/20140304014745_create_teams.rb
diff --git a/db/migrate/20140304014731_create_users.rb b/db/migrate/20140304014747_create_users.rb
index 163109f..3723908 100644
--- a/db/migrate/20140304014731_create_users.rb
+++ b/db/migrate/20140304014747_create_users.rb
@@ -1,6 +1,9 @@
 class CreateUsers < ActiveRecord::Migration
   def change
     create_table :users do |t|
+      t.text :name
+      t.varchar :pw_hash
+      t.int :groups
 
       t.timestamps
     end
diff --git a/db/migrate/20140304014749_create_user_team_pairs.rb b/db/migrate/20140304014749_create_user_team_pairs.rb
new file mode 100644
index 0000000..3b60212
--- /dev/null
+++ b/db/migrate/20140304014749_create_user_team_pairs.rb
@@ -0,0 +1,10 @@
+class CreateUserTeamPairs < ActiveRecord::Migration
+  def change
+    create_table :user_team_pairs do |t|
+      t.reference :user
+      t.reference :team
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140304014751_create_team_match_pairs.rb b/db/migrate/20140304014751_create_team_match_pairs.rb
new file mode 100644
index 0000000..c489495
--- /dev/null
+++ b/db/migrate/20140304014751_create_team_match_pairs.rb
@@ -0,0 +1,10 @@
+class CreateTeamMatchPairs < ActiveRecord::Migration
+  def change
+    create_table :team_match_pairs do |t|
+      t.reference :team
+      t.reference :match
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140304014753_create_alerts.rb b/db/migrate/20140304014753_create_alerts.rb
new file mode 100644
index 0000000..6167f33
--- /dev/null
+++ b/db/migrate/20140304014753_create_alerts.rb
@@ -0,0 +1,10 @@
+class CreateAlerts < ActiveRecord::Migration
+  def change
+    create_table :alerts do |t|
+      t.reference :author
+      t.text :message
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140304014755_create_pms.rb b/db/migrate/20140304014755_create_pms.rb
new file mode 100644
index 0000000..f3b27fb
--- /dev/null
+++ b/db/migrate/20140304014755_create_pms.rb
@@ -0,0 +1,11 @@
+class CreatePms < ActiveRecord::Migration
+  def change
+    create_table :pms do |t|
+      t.reference :author
+      t.reference :recipient
+      t.text :message
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/migrate/20140304014757_create_server_settings.rb b/db/migrate/20140304014757_create_server_settings.rb
new file mode 100644
index 0000000..dfdd91b
--- /dev/null
+++ b/db/migrate/20140304014757_create_server_settings.rb
@@ -0,0 +1,8 @@
+class CreateServerSettings < ActiveRecord::Migration
+  def change
+    create_table :server_settings do |t|
+
+      t.timestamps
+    end
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
deleted file mode 100644
index 1f34ab7..0000000
--- a/db/schema.rb
+++ /dev/null
@@ -1,41 +0,0 @@
-# encoding: UTF-8
-# This file is auto-generated from the current state of the database. Instead
-# of editing this file, please use the migrations feature of Active Record to
-# incrementally modify your database, and then regenerate this schema definition.
-#
-# Note that this schema.rb definition is the authoritative source for your
-# database schema. If you need to create the application database on another
-# system, you should be using db:schema:load, not running all the migrations
-# from scratch. The latter is a flawed and unsustainable approach (the more migrations
-# you'll amass, the slower it'll run and the greater likelihood for issues).
-#
-# It's strongly recommended that you check this file into your version control system.
-
-ActiveRecord::Schema.define(version: 20140304014731) do
-
-  create_table "matches", force: true do |t|
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "servers", force: true do |t|
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "teams", force: true do |t|
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "tournaments", force: true do |t|
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-  create_table "users", force: true do |t|
-    t.datetime "created_at"
-    t.datetime "updated_at"
-  end
-
-end