cafe-grader-web Commit - r268:5fffb74cc182

cafe-grader-web

parent | child

Description:

created join tables for contests and users and problems

Commit status:

[Not Reviewed]

References:

default

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r268:5fffb74cc182 - Tue, 16 Feb 2010 17:51:02 - 6 files changed: 42 inserted, 1 deleted

db/migrate/20100216162324_create_contests_users_join_table.rb created 644 ¶ +12

@@ -0,0 +1,12
	1	+ class CreateContestsUsersJoinTable < ActiveRecord::Migration
	2	+ def self.up
	3	+ create_table :contests_users, :id => false do \|t\|
	4	+ t.integer :contest_id
	5	+ t.integer :user_id
	6	+ end
	7	+ end
	8	+
	9	+ def self.down
	10	+ drop_table :contests_users
	11	+ end
	12	+ end

db/migrate/20100216162940_create_contests_problems_join_table.rb created 644 ¶ +12

@@ -0,0 +1,12
	1	+ class CreateContestsProblemsJoinTable < ActiveRecord::Migration
	2	+ def self.up
	3	+ create_table :contests_problems, :id => false do \|t\|
	4	+ t.integer :contest_id
	5	+ t.integer :problem_id
	6	+ end
	7	+ end
	8	+
	9	+ def self.down
	10	+ drop_table :contests_problems
	11	+ end
	12	+ end

app/models/contest.rb ¶ +4

@@ -1,2 +1,6
1	class Contest < ActiveRecord::Base	1	class Contest < ActiveRecord::Base
		2	+
		3	+ has_and_belongs_to_many :users
		4	+ has_and_belongs_to_many :problems
		5	+
2	end	6	end

app/models/problem.rb ¶ +1

               class Problem < ActiveRecord::Base
                 belongs_to :description
+            +   has_and_belongs_to_many :contests
                 has_many :test_pairs, :dependent => :delete_all
                 validates_presence_of :name

app/models/user.rb ¶ +2

                 belongs_to :site
                 belongs_to :country
+            +   has_and_belongs_to_many :contests
+            +
                 named_scope :activated_users, :conditions => {:activated => true}
                 validates_presence_of :login

db/schema.rb ¶ +11 -1

               #
               # It's strongly recommended to check this file into your version control system.
-            - ActiveRecord::Schema.define(:version => 20100216105730) do
+            + ActiveRecord::Schema.define(:version => 20100216162940) do
                 create_table "announcements", :force => true do |t|
                   t.string   "author"
                   t.datetime "updated_at"
                 end
+            +   create_table "contests_problems", :id => false, :force => true do |t|
+            +     t.integer "contest_id"
+            +     t.integer "problem_id"
+            +   end
+            +
+            +   create_table "contests_users", :id => false, :force => true do |t|
+            +     t.integer "contest_id"
+            +     t.integer "user_id"
+            +   end
+            +
                 create_table "countries", :force => true do |t|
                   t.string   "name"
                   t.datetime "created_at"

You need to be logged in to leave comments. Login now

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository permissions settings