summaryrefslogtreecommitdiff
path: root/db/migrate
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20140304014738_create_servers.rb (renamed from db/migrate/20140304014722_create_servers.rb)0
-rw-r--r--db/migrate/20140304014740_create_tournaments.rb (renamed from db/migrate/20140304014725_create_tournaments.rb)0
-rw-r--r--db/migrate/20140304014742_create_matches.rb (renamed from db/migrate/20140304014727_create_matches.rb)1
-rw-r--r--db/migrate/20140304014745_create_teams.rb (renamed from db/migrate/20140304014729_create_teams.rb)0
-rw-r--r--db/migrate/20140304014747_create_users.rb (renamed from db/migrate/20140304014731_create_users.rb)3
-rw-r--r--db/migrate/20140304014749_create_user_team_pairs.rb10
-rw-r--r--db/migrate/20140304014751_create_team_match_pairs.rb10
-rw-r--r--db/migrate/20140304014753_create_alerts.rb10
-rw-r--r--db/migrate/20140304014755_create_pms.rb11
-rw-r--r--db/migrate/20140304014757_create_server_settings.rb8
10 files changed, 53 insertions, 0 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