cafe-grader-web Commit - r822:f42556ce3209

cafe-grader-web

Commit `r822:f42556ce3209` public

parent | child

Description:

update migration

Commit status:

[Not Reviewed]

References:

upgrade_rails7

Diff options:

| | | |

Comments:

0 Commit comments 0 Inline Comments

Unresolved TODOs:

There are no unresolved TODOs

Add another comment

r822:f42556ce3209 - Sat, 15 Jan 2022 14:03:59 - 77 files changed: 120 inserted, 111 deleted

Gemfile.lock ¶ +1 -1

                     actionpack (>= 5.2)
                     activemodel (>= 5.2)
                   spring (2.1.1)
                   spring-watcher-listen (2.0.1)
                     listen (>= 2.7, < 4.0)
                     spring (>= 1.2, < 3.0)
                   sprockets (4.0.2)
                     concurrent-ruby (~> 1.0)
                     rack (> 1, < 3)
                   sprockets-rails (3.4.2)
                     actionpack (>= 5.2)
                     activesupport (>= 5.2)
                     sprockets (>= 3.0.0)
                   sqlite3 (1.4.2)
                   strscan (3.0.1)
                   temple (0.8.2)
                   thor (1.2.1)
                   tilt (2.0.10)
                   timeout (0.2.0)
                   tzinfo (2.0.4)
                     concurrent-ruby (~> 1.0)
                   uglifier (4.2.0)
                     execjs (>= 0.3.0, < 3)
                   web-console (4.2.0)
                     actionview (>= 6.0.0)
                     activemodel (>= 6.0.0)
                     bindex (>= 0.4.0)
                     railties (>= 6.0.0)
                   webdrivers (5.0.0)
                     nokogiri (~> 1.6)
                     rubyzip (>= 1.3.0)
                     selenium-webdriver (~> 4.0)
                   websocket-driver (0.7.5)
                     websocket-extensions (>= 0.1.0)
                   websocket-extensions (0.1.5)
                   xpath (3.2.0)
                     nokogiri (~> 1.8)
                   yaml_db (0.7.0)
                     rails (>= 3.0)
                     rake (>= 0.8.7)
                   zeitwerk (2.5.3)
               PLATFORMS
                 x86_64-linux
               DEPENDENCIES
                 ace-rails-ap
                 activerecord-session_store
                 autoprefixer-rails
                 best_in_place!
                 bootsnap
                 bootstrap-sass (~> 3.4.1)
                 bootstrap-switch-rails
                 bootstrap-toggle-rails
                 bootstrap3-datetimepicker-rails (~> 4.17.47)
                 capybara
                 coffee-rails
                 debug
                 dynamic_form
                 fuzzy-string-match
                 haml
                 haml-rails
                 in_place_editing
                 jbuilder
                 jquery-countdown-rails
                 jquery-rails
                 jquery-tablesorter
                 jquery-ui-rails
                 listen (>= 3.0.5, < 3.2)
                 mail
                 minitest-reporters
                 momentjs-rails (>= 2.9.0)
                 mysql2
                 puma
                 rails (~> 7.0)
                 rails-controller-testing
                 rails_bootstrap_sortable
                 rdiscount
                 rouge
                 sassc-rails
                 select2-rails
                 selenium-webdriver
                 simple_form
                 spring
                 spring-watcher-listen (~> 2.0.0)
                 sprockets-rails
                 sqlite3
                 uglifier
                 web-console (>= 3.3.0)
                 webdrivers
                 yaml_db
               RUBY VERSION
                  ruby 3.1.0p0
               BUNDLED WITH
-            -    2.3.5
+            +    2.3.3

README.rdoc ¶ +12 -2

               == Installation
               Installing cafe-grader can be done in the following steps.
 . Set up database. We need MySQL 5 database name, username and password.
 . Install RVM. cafe-grader runs on Ruby on Rails and the best way to install it is to use RVM.
 . Install necessary package for the system
 . Install cafe-grader from github
 . Deploy cafe-grader on apache with Phusion Passenger
               Very important!!! All commands should be run from a normal user.
               The detail of each step are provided as follows.
               === 1. Install MySQL 5
               Install MySQL server for the server.
                   cafe@grader:~$ sudo apt install mysql-server
               Next, we will connect to mysql as root and set up the database. You can choose your DATABASENAME, USERNAME and PASSWORD as you wish.
                   cafe@grader:~$ sudo mysql -u root
                   mysql> create database DATABASENAME;
                   Query OK, 1 row affected (0.00 sec)
                   mysql> grant all privileges on DATABASENAME.* to USERNAME@localhost identified by 'PASSWORD';
                   Query OK, 0 rows affected, 1 warning (0.00 sec)
                   mysql> flush privileges;
                   Query OK, 0 rows affected (0.00 sec)
               === 2. Install RVM
               Since Ubuntu has dedicated package for RVM we will use that. Just follow instruction given in https://github.com/rvm/ubuntu_rvm. For your convenience, the step are reproduced here.
               First, we install necessary package for installing RVM.
                   cafe@grader:~$ sudo apt install software-properties-common
               Second, we add the custom PPA, update the system and install RVM.
                   cafe@grader:~$ sudo apt-add-repository -y ppa:rael-gc/rvm
                   cafe@grader:~$ sudo apt-get update
                   cafe@grader:~$ sudo apt-get install rvm
               We also need to add our user to the rvm group
                   sudo usermod -a -G rvm $USER
               This is very important.
 . You have to reboot since RVM change a lots of system.
 . If you are using GUI version of Ubuntu, be sure to have Gnome Terminal (or any other terminal you are using) perform login every time. This can be done by mark the check box "Run command as a login shell" in Gnome terminal or by adding --login to bash.
-            - === 3. Install necessary package
+            + === 3. Install necessary package and nodejs
+            +
+            + First, we install required package via apt.
+            +
+            +     cafe@grader:~$ sudo apt install libmysqlclient-dev default-jdk unzip php-cli apache2 dirmngr gnupg apache2-dev
-            -     cafe@grader:~$ sudo apt install libmysqlclient-dev default-jdk unzip nodejs php-cli apache2 dirmngr gnupg apache2-dev
+            + Since nodejs that comes with ubuntu 18.04 is very outdated, we need to install it manually. This follow the method outlined in https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-18-04 under *Installing Node.js with Apt Using a NodeSource PPA*
+            +
+            +     cd ~
+            +     curl -sL https://deb.nodesource.com/setup_17.x -o nodesource_setup.sh
+            +     sudo bash nodesource_setup.sh
+            +     sudo apt install nodejs
+            +
               === 4. Install cafe-grader
               First, ensure that RVM is installed correctly.
                   cafe@grader:~$ rvm
               If you get a result similar to this.
                   Command 'rvm' not found, but there are 21 similar ones.
               It is very likely that you have not re-login or you are using bash without --login. Please do so and re-read the installation of RVM on Ubuntu https://github.com/rvm/ubuntu_rvm again.
               Next, we will let the install script do the work of installing cafe-grader. Please prepare the DATABASENAME, USERNAME and PASSWORD as the script will ask for that. Make sure that you run the script from the home directory of the user.
                   cafe@grader:~$ wget https://github.com/cafe-grader-team/cafe-grader-judge-scripts/raw/master/installer/install.sh
                   cafe@grader:~$ . ./install.sh
               After installation is finished, grader is ready to run in development mode via WEBrick. We will try that by the following command which will start a grader accessible via http://localhost:3000/. You can try logging in to the system and verify that it is actually work.
               cafe@grader:~/cafe_grader/web$ rails s
               If Everything is OK, stop the WEBrick by Ctrl-C.
               We are almost done. The last step is to set up apache and Phusion so that cafe-grader is served by apache.
               === 5. Deploy cafe-grader on Phusion passenger via apache
               This will install a Passenger mod for apache. You can start by visiting https://www.phusionpassenger.com/library/walkthroughs/deploy/ruby/ownserver/apache/oss/install_passenger_main.html and fllow through the guide. We have reproduce the step here for Ubuntu 18.04. For other version, please select the appropriate one on the previous link.
               The deploy is divided into two parts: Installing Passenger and deploying the app.
               ==== 5.1. Installing Passenger as a mod for apache via PPA and enable it.
                   cafe@grader:~$ sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv-keys 561F9B9CAC40B2F7
                   cafe@grader:~$ sudo apt-get install -y apt-transport-https ca-certificates
                   cafe@grader:~$ sudo sh -c 'echo deb https://oss-binaries.phusionpassenger.com/apt/passenger bionic main > /etc/apt/sources.list.d/passenger.list'
                   cafe@grader:~$ sudo apt-get update
                   cafe@grader:~$ sudo apt-get install -y libapache2-mod-passenger
                   cafe@grader:~$ sudo a2enmod passenger
                   cafe@grader:~$ sudo apache2ctl restart
                   Finally, we should check that passenger is installed correctly. Run the following command and fix anything as suggested by the command.
                   cafe@grader:~$ sudo /usr/bin/passenger-config validate-install
               ==== 5.2. Deploying the app. First, we determine the exact location of our ruby that is installed via RVM.
                   cafe@grader:~$ passenger-config about ruby-command
               passenger-config was invoked through the following Ruby interpreter:
                 Command: /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby
                 Version: ruby 2.3.7p456 (2018-03-28 revision 63024) [x86_64-linux]
                 To use in Apache: PassengerRuby /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby
                 To use in Nginx : passenger_ruby /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby
                 To use with Standalone: /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby /usr/bin/passenger start
               Then, take note of the path after "Command". For this guide, it is /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby
               Assuming that cafe-grader is installed at /home/cafe/cafe_grader, we will edit the Apache's site config file /etc/apache2/site-enabled/000-default.conf as follow.
                   <VirtualHost *:80>
                       #ServerName www.example.com
                       ServerAdmin webmaster@localhost
                       # dont forget to change the document root
                       DocumentRoot /home/cafe/cafe_grader/web/public
                       ErrorLog ${APACHE_LOG_DIR}/error.log
                       CustomLog ${APACHE_LOG_DIR}/access.log combined
                       # add Passenger
                       PassengerRuby /home/cafe/.rvm/gems/ruby-2.3.7/wrappers/ruby
                       # our cafe-grader app
                       <Directory /home/cafe/cafe_grader/web/public>
                               Allow from all
                               Options -MultiViews
                               Require all granted
                       </Directory>
                   </VirtualHost>
               Be noted that we make 3 modifications: 1) change DocumentRoot, 2) add PassengerRuby option and add 3) Directory directive
               As the last step, we restart apache again and the site is ready to be used.
                   cafe@grader:~$ sudo apache2ctl restart
               Now it is done, you can login to the grader with user 'root' and password 'ioionrails'

db/migrate/001_create_users.rb ¶ +2 -2

-            - class CreateUsers < ActiveRecord::Migration
+            + class CreateUsers < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :users do |t|
+            +     create_table :users, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :login, :string, :limit => 10
                     t.column :full_name, :string
                     t.column :hashed_password, :string
                     t.column :salt, :string, :limit => 5
                     t.column :alias, :string
                   end
                   # force unique name
                   add_index :users, :login, :unique => true
                 end
                 def self.down
                   drop_table :users
                 end
               end

db/migrate/002_create_problems.rb ¶ +2 -2

-            - class CreateProblems < ActiveRecord::Migration
+            + class CreateProblems < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :problems do |t|
+            +     create_table :problems, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string, :limit => 30
                     t.column :full_name, :string
                     t.column :full_score, :integer
                     t.column :date_added, :date
                     t.column :available, :boolean
                   end
                 end
                 def self.down
                   drop_table :problems
                 end
               end

db/migrate/003_create_submissions.rb ¶ +2 -2

-            - class CreateSubmissions < ActiveRecord::Migration
+            + class CreateSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :submissions do |t|
+            +     create_table :submissions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :user_id, :integer
                     t.column :problem_id, :integer
                     t.column :language_id, :integer
                     t.column :source, :text
                     t.column :binary, :binary
                     t.column :submitted_at, :datetime
                     t.column :compiled_at, :datetime
                     t.column :compiler_message, :text
                     t.column :graded_at, :datetime
                     t.column :points, :integer
                     t.column :grader_comment, :text
                   end
                 end
                 def self.down
                   drop_table :submissions
                 end
               end

db/migrate/004_create_languages.rb ¶ +2 -2

-            - class CreateLanguages < ActiveRecord::Migration
+            + class CreateLanguages < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :languages do |t|
+            +     create_table :languages, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string, :limit => 10
                     t.column :pretty_name, :string
                   end
                   Language.create(:name => "c", :pretty_name => "C")
                   Language.create(:name => "cpp", :pretty_name => "C++")
                   Language.create(:name => "pas", :pretty_name => "Pascal")
                 end
                 def self.down
                   drop_table :languages
                 end
               end

db/migrate/005_add_index_to_submissions.rb ¶ +1 -1

-            - class AddIndexToSubmissions < ActiveRecord::Migration
+            + class AddIndexToSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
                   add_index :submissions, [:user_id, :problem_id]
                 end
                 def self.down
                   remove_index :submissions, :column => [:user_id, :problem_id]
                 end
               end

db/migrate/006_create_roles.rb ¶ +3 -3

-            - class CreateRoles < ActiveRecord::Migration
+            + class CreateRoles < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :roles do |t|
+            +     create_table :roles, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'name', :string
                   end
-            -     create_table :roles_users, :id => false do |t|
+            +     create_table :roles_users, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'role_id', :integer
                     t.column 'user_id', :integer
                   end
                   add_index :roles_users, :user_id
                 end
                 def self.down
                   drop_table :roles_users
                   drop_table :roles
                 end
               end

db/migrate/007_create_rights.rb ¶ +3 -3

-            - class CreateRights < ActiveRecord::Migration
+            + class CreateRights < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :rights do |t|
+            +     create_table :rights, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'name', :string
                     t.column 'controller', :string
                     t.column 'action', :string
                   end
-            -     create_table :rights_roles, :id => false do |t|
+            +     create_table :rights_roles, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'right_id', :integer
                     t.column 'role_id', :integer
                   end
                   add_index :rights_roles, :role_id
                 end
                 def self.down
                   drop_table :rights_roles
                   drop_table :rights
                 end
               end

db/migrate/008_create_tasks.rb ¶ +2 -2

-            - class CreateTasks < ActiveRecord::Migration
+            + class CreateTasks < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :tasks do |t|
+            +     create_table :tasks, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'submission_id', :integer
                     t.column 'created_at', :datetime
                   end
                 end
                 def self.down
                   drop_table :tasks
                 end
               end

db/migrate/009_add_sessions.rb ¶ +2 -2

-            - class AddSessions < ActiveRecord::Migration
+            + class AddSessions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :sessions do |t|
+            +     create_table :sessions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :session_id, :string
                     t.column :data, :text
                     t.column :updated_at, :datetime
                   end
                   add_index :sessions, :session_id
                   add_index :sessions, :updated_at
                 end
                 def self.down
                   drop_table :sessions
                 end
               end

db/migrate/011_add_language_ext.rb ¶ +1 -1

-            - class AddLanguageExt < ActiveRecord::Migration
+            + class AddLanguageExt < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :languages, :ext, :string, :limit => 10
                   Language.reset_column_information
                   langs = Language.all
                   langs.each do |l|
                     l.ext = l.name
                     l.save
                   end
                 end
                 def self.down
                   remove_column :languages, :ext
                 end
               end

db/migrate/012_add_email_to_users.rb ¶ +1 -1

-            - class AddEmailToUsers < ActiveRecord::Migration
+            + class AddEmailToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :users, :email, :string
                 end
                 def self.down
                   remove_column :users, :email
                 end
               end

db/migrate/013_add_url_to_problem.rb ¶ +1 -1

-            - class AddUrlToProblem < ActiveRecord::Migration
+            + class AddUrlToProblem < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :url, :string
                 end
                 def self.down
                   remove_column :problems, :url
                 end
               end

db/migrate/014_create_grader_processes.rb ¶ +2 -2

-            - class CreateGraderProcesses < ActiveRecord::Migration
+            + class CreateGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :grader_processes do |t|
+            +     create_table :grader_processes, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :ip, :string, :limit => 20
                     t.column :pid, :integer
                     t.column :mode, :string
                     t.column :active, :boolean
                     t.timestamps
                   end
                   add_index :grader_processes, ["ip","pid"]
                 end
                 def self.down
                   drop_table :grader_processes
                 end
               end

db/migrate/015_add_status_to_tasks.rb ¶ +1 -1

-            - class AddStatusToTasks < ActiveRecord::Migration
+            + class AddStatusToTasks < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :tasks, :status, :integer
                   add_column :tasks, :updated_at, :datetime
                   Task.reset_column_information
                   Task.all.each do |task|
                     task.status_complete
                     task.save
                   end
                 end
                 def self.down
                   remove_column :tasks, :updated_at
                   remove_column :tasks, :status
                 end
               end

db/migrate/016_add_task_to_grader_process.rb ¶ +1 -1

-            - class AddTaskToGraderProcess < ActiveRecord::Migration
+            + class AddTaskToGraderProcess < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :grader_processes, :task_id, :integer
                 end
                 def self.down
                   remove_column :grader_processes, :task_id
                 end
               end

db/migrate/017_rename_grader_process_column_ip_to_host.rb ¶ +1 -1

-            - class RenameGraderProcessColumnIpToHost < ActiveRecord::Migration
+            + class RenameGraderProcessColumnIpToHost < ActiveRecord::Migration[4.2]
                 def self.up
                   rename_column :grader_processes, :ip, :host
                 end
                 def self.down
                   rename_column :grader_processes, :host, :ip
                 end
               end

db/migrate/018_add_number_to_submissions.rb ¶ +1 -1

-            - class AddNumberToSubmissions < ActiveRecord::Migration
+            + class AddNumberToSubmissions < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :submissions, :number, :integer
                   # add number field for all records
                   Submission.reset_column_information
                   last_user_id = nil
                   last_problem_id = nil
                   current_number = 0
                   Submission.order('user_id, problem_id, submitted_at').each do |submission|
                     if submission.user_id==last_user_id and submission.problem_id==last_problem_id
                       current_number += 1
                     else
                       current_number = 1
                     end
                     submission.number = current_number
                     submission.save
                     last_user_id = submission.user_id
                     last_problem_id = submission.problem_id
                   end
                   add_index :submissions, [:user_id, :problem_id, :number], :unique => true
                 end
                 def self.down
                   remove_index :submissions, :column => [:user_id, :problem_id, :number]
                   remove_column :submissions, :number
                 end
               end

db/migrate/019_create_test_requests.rb ¶ +2 -3

-            - class CreateTestRequests < ActiveRecord::Migration
+            + class CreateTestRequests < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :test_requests do |t|
+            +     create_table :test_requests, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :user_id, :integer
                     t.column :problem_id, :integer
                     t.column :submission_id, :integer
                     t.column :input_file_name, :string
                     t.column :output_file_name, :string
                     t.column :running_stat, :string
                     # these are similar to tasks
                     t.column :status, :integer
-            -       t.column :updated_at, :datetime
                     # these are intentionally similar to submissions
                     t.column :submitted_at, :datetime
                     t.column :compiled_at, :datetime
                     t.column :compiler_message, :string
                     t.column :graded_at, :datetime
                     t.column :grader_comment, :string
                     t.timestamps
                   end
                   add_index :test_requests, [:user_id, :problem_id]
                 end
                 def self.down
                   remove_index :test_requests, :column => [:user_id, :problem_id]
                   drop_table :test_requests
                 end
               end

db/migrate/021_change_compiler_message_type_test_request.rb ¶ +1 -1

-            - class ChangeCompilerMessageTypeTestRequest < ActiveRecord::Migration
+            + class ChangeCompilerMessageTypeTestRequest < ActiveRecord::Migration[4.2]
                 def self.up
                   change_column :test_requests, :compiler_message, :text
                 end
                 def self.down
                   change_column :test_requests, :compiler_message, :string
                 end
               end

db/migrate/022_create_configurations.rb ¶ +2 -2

-            - class CreateConfigurations < ActiveRecord::Migration
+            + class CreateConfigurations < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :configurations do |t|
+            +     create_table :configurations, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :key, :string
                     t.column :value_type, :string
                     t.column :value, :string
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :configurations
                 end
               end

db/migrate/023_add_runstat_columns_to_test_request.rb ¶ +1 -1

-            - class AddRunstatColumnsToTestRequest < ActiveRecord::Migration
+            + class AddRunstatColumnsToTestRequest < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :test_requests, :running_time, :float
                   add_column :test_requests, :exit_status, :string
                   add_column :test_requests, :memory_usage, :integer
                 end
                 def self.down
                   remove_column :test_requests, :running_time
                   remove_column :test_requests, :exit_status
                   remove_column :test_requests, :memory_usage
                 end
               end

db/migrate/024_create_sites.rb ¶ +2 -2

-            - class CreateSites < ActiveRecord::Migration
+            + class CreateSites < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :sites do |t|
+            +     create_table :sites, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name
                     t.boolean :started
                     t.datetime :start_time
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :sites
                 end
               end

db/migrate/025_add_site_to_user_and_add_default_site.rb ¶ +1 -1

-            - class AddSiteToUserAndAddDefaultSite < ActiveRecord::Migration
+            + class AddSiteToUserAndAddDefaultSite < ActiveRecord::Migration[4.2]
                 def self.up
                   default_site = Site.new({:name => 'default',
                                             :started => false})
                   default_site.save!
                   add_column :users, :site_id, :integer
                   User.reset_column_information
                   User.all.each do |user|
                     class << user
                       def valid?
                         true
                       end
                     end
                     user.site_id = default_site.id
                     user.save
                   end
                 end
                 def self.down
                   remove_column :users, :site_id
                   default_site = Site.find_by_name('default')
                   default_site.destroy if default_site
                 end
               end

db/migrate/026_add_body_to_problems.rb ¶ +1 -1

-            - class AddBodyToProblems < ActiveRecord::Migration
+            + class AddBodyToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :body, :text
                 end
                 def self.down
                   remove_column :problems, :body
                 end
               end

db/migrate/027_create_descriptions.rb ¶ +2 -2

-            - class CreateDescriptions < ActiveRecord::Migration
+            + class CreateDescriptions < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :descriptions do |t|
+            +     create_table :descriptions, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :body, :text
                     t.column :markdowned, :boolean
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :descriptions
                 end
               end

db/migrate/028_refactor_problem_body_to_description.rb ¶ +1 -1

-            - class RefactorProblemBodyToDescription < ActiveRecord::Migration
+            + class RefactorProblemBodyToDescription < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :description_id, :integer
                   Problem.reset_column_information
                   Problem.all.each do |problem|
                     if problem.body!=nil
                       description = Description.new
                       description.body = problem.body
                       description.markdowned = false
                       description.save
                       problem.description_id = description.id
                       problem.save
                     end
                   end
                   remove_column :problems, :body
                 end
                 def self.down
                   add_column :problems, :body, :text
                   Problem.reset_column_information
                   Problem.all.each do |problem|
                     if problem.description_id != nil
                       problem.body = Description.find(problem.description_id).body
                       problem.save
                     end
                   end
                   remove_column :problems, :description_id
                 end
               end

db/migrate/029_add_test_allowed_to_problems.rb ¶ +1 -1

-            - class AddTestAllowedToProblems < ActiveRecord::Migration
+            + class AddTestAllowedToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :test_allowed, :boolean
                   Problem.reset_column_information
                   Problem.all.each do |problem|
                     problem.test_allowed = true
                     problem.save
                   end
                 end
                 def self.down
                   remove_column :problems, :test_allowed
                 end
               end

db/migrate/030_create_announcements.rb ¶ +2 -2

-            - class CreateAnnouncements < ActiveRecord::Migration
+            + class CreateAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :announcements do |t|
+            +     create_table :announcements, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :author
                     t.text :body
                     t.boolean :published
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :announcements
                 end
               end

db/migrate/031_add_supports_for_output_only_problems.rb ¶ +1 -1

-            - class AddSupportsForOutputOnlyProblems < ActiveRecord::Migration
+            + class AddSupportsForOutputOnlyProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :submissions, :source_filename, :string
                   add_column :problems, :output_only, :boolean
                 end
                 def self.down
                   remove_column :submissions, :source_filename
                   remove_column :problems, :output_only
                 end
               end

db/migrate/032_create_messages.rb ¶ +2 -2

-            - class CreateMessages < ActiveRecord::Migration
+            + class CreateMessages < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :messages do |t|
+            +     create_table :messages, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column "sender_id", :integer
                     t.column "receiver_id", :integer
                     t.column "replying_message_id", :integer
                     t.column "body", :text
                     t.column "replied", :boolean   # this is for efficiency
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :messages
                 end
               end

db/migrate/033_add_task_type_to_grader_processes.rb ¶ +1 -1

-            - class AddTaskTypeToGraderProcesses < ActiveRecord::Migration
+            + class AddTaskTypeToGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column 'grader_processes', 'task_type', :string
                 end
                 def self.down
                   remove_column 'grader_processes', 'task_type'
                 end
               end

db/migrate/034_create_countries.rb ¶ +2 -2

-            - class CreateCountries < ActiveRecord::Migration
+            + class CreateCountries < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :countries do |t|
+            +     create_table :countries, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column :name, :string
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :countries
                 end
               end

db/migrate/035_add_country_to_sites_and_users.rb ¶ +1 -1

-            - class AddCountryToSitesAndUsers < ActiveRecord::Migration
+            + class AddCountryToSitesAndUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column 'sites', 'country_id', :integer
                   add_column 'sites', 'password', :string
                   add_column 'users', 'country_id', :integer
                 end
                 def self.down
                   remove_column 'users', 'country_id'
                   remove_column 'sites', 'country_id'
                   remove_column 'sites', 'password'
                 end
               end

db/migrate/20081107145815_add_frontpage_flag_to_announcement.rb ¶ +1 -1

-            - class AddFrontpageFlagToAnnouncement < ActiveRecord::Migration
+            + class AddFrontpageFlagToAnnouncement < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, "frontpage", :boolean, :default => 0
                 end
                 def self.down
                   remove_column :announcements, "frontpage"
                 end
               end

db/migrate/20081204122651_add_activated_to_users.rb ¶ +1 -1

-            - class AddActivatedToUsers < ActiveRecord::Migration
+            + class AddActivatedToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :users, :activated, :boolean, :default => 0
                   User.reset_column_information
                   User.all.each do |user|
                     # disable validation
                     class <<user
                       def valid?
                         return true
                       end
                     end
                     user.activated = true
                     user.save
                   end
                 end
                 def self.down
                   remove_column :users, :activated
                 end
               end

db/migrate/20081210021333_add_timestamps_to_users.rb ¶ +1 -1

-            - class AddTimestampsToUsers < ActiveRecord::Migration
+            + class AddTimestampsToUsers < ActiveRecord::Migration[4.2]
                 def self.up
                   add_timestamps :users
                 end
                 def self.down
                   remove_timestamps :users
                 end
               end

db/migrate/20081215012843_change_user_login_string_limit.rb ¶ +1 -1

-            - class ChangeUserLoginStringLimit < ActiveRecord::Migration
+            + class ChangeUserLoginStringLimit < ActiveRecord::Migration[4.2]
                 def self.up
                   execute "ALTER TABLE `users` CHANGE `login` `login` VARCHAR( 50 )"
                 end
                 def self.down
                   # don't have to revert
                 end
               end

db/migrate/20090206145016_add_contest_flag_to_announcements.rb ¶ +1 -1

-            - class AddContestFlagToAnnouncements < ActiveRecord::Migration
+            + class AddContestFlagToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :contest_only, :boolean, :default => false
                 end
                 def self.down
                   remove_column :announcements, :contest_only
                 end
               end

db/migrate/20090416235658_add_common_ext_to_languages.rb ¶ +1 -1

-            - class AddCommonExtToLanguages < ActiveRecord::Migration
+            + class AddCommonExtToLanguages < ActiveRecord::Migration[4.2]
                 def self.up
                   # language.common_ext is a comma-separated list of common file
                   # extensions.
                   add_column :languages, :common_ext, :string
                   # updating table information
                   Language.reset_column_information
                   common_ext = {
                     'c' => 'c',
                     'cpp' => 'cpp,cc',
                     'pas' => 'pas'
                   }
                   Language.all.each do |lang|
                     lang.common_ext = common_ext[lang.name]
                     lang.save
                   end
                 end
                 def self.down
                   remove_column :languages, :common_ext
                 end
               end

db/migrate/20090426131044_add_terminated_to_grader_processes.rb ¶ +1 -1

-            - class AddTerminatedToGraderProcesses < ActiveRecord::Migration
+            + class AddTerminatedToGraderProcesses < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :grader_processes, :terminated, :boolean
                 end
                 def self.down
                   remove_column :grader_processes, :terminated
                 end
               end

db/migrate/20090815171610_add_title_to_announcements.rb ¶ +1 -1

-            - class AddTitleToAnnouncements < ActiveRecord::Migration
+            + class AddTitleToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :title, :string
                 end
                 def self.down
                   remove_column :announcements, :title
                 end
               end

db/migrate/20100113094740_create_test_pairs.rb ¶ +2 -2

-            - class CreateTestPairs < ActiveRecord::Migration
+            + class CreateTestPairs < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :test_pairs do |t|
+            +     create_table :test_pairs, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :problem_id
                     t.text :input
                     t.text :solution
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :test_pairs
                 end
               end

db/migrate/20100124040107_add_description_to_config.rb ¶ +1 -1

-            - class AddDescriptionToConfig < ActiveRecord::Migration
+            + class AddDescriptionToConfig < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :configurations, :description, :text
                 end
                 def self.down
                   remove_column :configurations, :description
                 end
               end

db/migrate/20100124054458_create_user_contest_stats.rb ¶ +2 -2

-            - class CreateUserContestStats < ActiveRecord::Migration
+            + class CreateUserContestStats < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :user_contest_stats do |t|
+            +     create_table :user_contest_stats, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :user_id
                     t.timestamp :started_at
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :user_contest_stats
                 end
               end

db/migrate/20100129041917_change_input_solution_field_limit_in_test_pair.rb ¶ +1 -1

-            - class ChangeInputSolutionFieldLimitInTestPair < ActiveRecord::Migration
+            + class ChangeInputSolutionFieldLimitInTestPair < ActiveRecord::Migration[4.2]
                 def self.up
                   change_column :test_pairs, :input, :text, :limit => 1.megabytes
                   change_column :test_pairs, :solution, :text, :limit => 1.megabytes
                 end
                 def self.down
                   change_column :test_pairs, :input, :text
                   change_column :test_pairs, :solution, :text
                 end
               end

db/migrate/20100216105730_create_contests.rb ¶ +2 -2

-            - class CreateContests < ActiveRecord::Migration
+            + class CreateContests < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests do |t|
+            +     create_table :contests, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :title
                     t.boolean :enabled
                     t.timestamps
                   end
                 end
                 def self.down
                   drop_table :contests
                 end
               end

db/migrate/20100216162324_create_contests_users_join_table.rb ¶ +2 -2

-            - class CreateContestsUsersJoinTable < ActiveRecord::Migration
+            + class CreateContestsUsersJoinTable < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests_users, :id => false do |t|
+            +     create_table :contests_users, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :contest_id
                     t.integer :user_id
                   end
                 end
                 def self.down
                   drop_table :contests_users
                 end
               end

db/migrate/20100216162940_create_contests_problems_join_table.rb ¶ +2 -2

-            - class CreateContestsProblemsJoinTable < ActiveRecord::Migration
+            + class CreateContestsProblemsJoinTable < ActiveRecord::Migration[4.2]
                 def self.up
-            -     create_table :contests_problems, :id => false do |t|
+            +     create_table :contests_problems, :id => false, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :contest_id
                     t.integer :problem_id
                   end
                 end
                 def self.down
                   drop_table :contests_problems
                 end
               end

db/migrate/20100219014840_add_description_filename_to_problems.rb ¶ +1 -1

-            - class AddDescriptionFilenameToProblems < ActiveRecord::Migration
+            + class AddDescriptionFilenameToProblems < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :problems, :description_filename, :string
                 end
                 def self.down
                   remove_column :problems, :description_filename
                 end
               end

db/migrate/20100303095700_add_name_to_contests.rb ¶ +1 -1

-            - class AddNameToContests < ActiveRecord::Migration
+            + class AddNameToContests < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :contests, :name, :string
                 end
                 def self.down
                   remove_column :contests, :name
                 end
               end

db/migrate/20100328123325_add_forced_logout_to_user_contest_stat.rb ¶ +1 -1

-            - class AddForcedLogoutToUserContestStat < ActiveRecord::Migration
+            + class AddForcedLogoutToUserContestStat < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :user_contest_stats, :forced_logout, :boolean
                 end
                 def self.down
                   remove_column :user_contest_stats, :forced_logout, :boolean
                 end
               end

db/migrate/20100506163112_add_notes_to_announcements.rb ¶ +1 -1

-            - class AddNotesToAnnouncements < ActiveRecord::Migration
+            + class AddNotesToAnnouncements < ActiveRecord::Migration[4.2]
                 def self.up
                   add_column :announcements, :notes, :string
                 end
                 def self.down
                   remove_column :announcements, :notes
                 end
               end

db/migrate/20121001033508_rename_configurations_to_grader_configurations.rb ¶ +1 -1

-            - class RenameConfigurationsToGraderConfigurations < ActiveRecord::Migration
+            + class RenameConfigurationsToGraderConfigurations < ActiveRecord::Migration[4.2]
                 def change
                   rename_table 'configurations', 'grader_configurations'
                 end
               end

db/migrate/20140823031747_add_more_detail_to_submission.rb ¶ +1 -1

-            - class AddMoreDetailToSubmission < ActiveRecord::Migration
+            + class AddMoreDetailToSubmission < ActiveRecord::Migration[4.2]
                 def change
                   add_column :submissions, :max_runtime, :float
                   add_column :submissions, :peak_memory, :integer
                   add_column :submissions, :effective_code_length, :integer
                 end
               end

db/migrate/20140826095949_create_logins.rb ¶ +2 -2

-            - class CreateLogins < ActiveRecord::Migration
+            + class CreateLogins < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :logins do |t|
+            +     create_table :logins, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :user_id
                     t.string :ip_address
                     t.timestamps
                   end
                 end
               end

db/migrate/20140913060729_add_section_to_users.rb ¶ +1 -1

-            - class AddSectionToUsers < ActiveRecord::Migration
+            + class AddSectionToUsers < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :section, :string
                 end
               end

db/migrate/20140917150629_add_ip_to_submissions.rb ¶ +1 -1

-            - class AddIpToSubmissions < ActiveRecord::Migration
+            + class AddIpToSubmissions < ActiveRecord::Migration[4.2]
                 def change
                   add_column :submissions, :ip_address, :string
                 end
               end

db/migrate/20150203153534_add_more_to_users.rb ¶ +1 -1

-            - class AddMoreToUsers < ActiveRecord::Migration
+            + class AddMoreToUsers < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :enabled, :boolean, default: 1
                   add_column :users, :remark, :string
                 end
               end

db/migrate/20150503164846_change_userid_on_login.rb ¶ +1 -1

-            - class ChangeUseridOnLogin < ActiveRecord::Migration
+            + class ChangeUseridOnLogin < ActiveRecord::Migration[4.2]
                 def up
                   change_column :logins, :user_id, :integer
                 end
                 def down
                   change_column :logins, :user_id, :string
                 end
               end

db/migrate/20150827131927_create_submission_view_logs.rb ¶ +2 -2

-            - class CreateSubmissionViewLogs < ActiveRecord::Migration
+            + class CreateSubmissionViewLogs < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :submission_view_logs do |t|
+            +     create_table :submission_view_logs, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.integer :user_id
                     t.integer :submission_id
                     t.timestamps
                   end
                 end
               end

db/migrate/20150827133841_add_last_ip_to_user.rb ¶ +1 -1

-            - class AddLastIpToUser < ActiveRecord::Migration
+            + class AddLastIpToUser < ActiveRecord::Migration[4.2]
                 def change
                   add_column :users, :last_ip, :string
                 end
               end

db/migrate/20150914090545_create_heart_beats.rb ¶ +2 -2

-            - class CreateHeartBeats < ActiveRecord::Migration
+            + class CreateHeartBeats < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :heart_beats do |t|
+            +     create_table :heart_beats, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.column 'user_id',:integer
                     t.column 'ip_address',:string
                     t.timestamps
                   end
                 end
               end

db/migrate/20150914155101_add_status_to_heart_beat.rb ¶ +1 -1

-            - class AddStatusToHeartBeat < ActiveRecord::Migration
+            + class AddStatusToHeartBeat < ActiveRecord::Migration[4.2]
                 def change
                   add_column :heart_beats, :status, :string
                 end
               end

db/migrate/20150914223258_add_more_config.rb ¶ +1 -1

-            - class AddMoreConfig < ActiveRecord::Migration
+            + class AddMoreConfig < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.bypass_agreement', value_type: 'boolean', value:'true', description:'When false, a check box to accept license agreement appear at login and the user must click accept'
                 end
                 def down
                 end
               end

db/migrate/20150916054105_update_heart_beat.rb ¶ +1 -1

-            - class UpdateHeartBeat < ActiveRecord::Migration
+            + class UpdateHeartBeat < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.heartbeat_response', value_type: 'string', value:'OK', description:'Heart beat response text'
                   add_index :heart_beats, :updated_at
                 end
                 def down
                   remove_index :heart_beats, :updated_at
                 end
               end

db/migrate/20161008050135_modify_grader_process.rb ¶ +1 -1

-            - class ModifyGraderProcess < ActiveRecord::Migration
+            + class ModifyGraderProcess < ActiveRecord::Migration[4.2]
                 def up
                   change_column :grader_processes, :host, :string
                 end
                 def down
                   change_column :grader_processes, :host, :string, limit: 20
                 end
               end

db/migrate/20161014091417_create_testcases.rb ¶ +2 -2

-            - class CreateTestcases < ActiveRecord::Migration
+            + class CreateTestcases < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :testcases do |t|
+            +     create_table :testcases, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.references :problem
                     t.integer :num
                     t.integer :group
                     t.integer :score
                     t.text :input
                     t.text :sol
                     t.timestamps
                   end
                   add_index :testcases, :problem_id
                 end
               end

db/migrate/20161031063337_add_config_view_test.rb ¶ +1 -1

-            - class AddConfigViewTest < ActiveRecord::Migration
+            + class AddConfigViewTest < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.view_testcase', value_type: 'boolean', value:'true', description:'When true, any user can view/download test data'
                   #uglily and dirtily and shamelessly check other config and inifialize
                   GraderConfiguration.where(key: 'right.user_hall_of_fame').first_or_create(value_type: 'boolean', value: 'false',
                                                                                             description: 'If true, any user can access hall of fame page.')
                   GraderConfiguration.where(key: 'right.multiple_ip_login').first_or_create(value_type: 'boolean', value: 'false',
                                                                                             description: 'When change from true to false, a user can login from the first IP they logged into afterward.')
                   GraderConfiguration.where(key: 'right.user_view_submission').first_or_create(value_type: 'boolean', value: 'false',
                                                                                                description: 'If true, any user can view submissions of every one.')
                 end
                 def down
                   GraderConfiguration.where(key: 'right.view_testcase').destroy_all;
                 end
               end

db/migrate/20170123162543_change_testcase_size.rb ¶ +1 -1

-            - class ChangeTestcaseSize < ActiveRecord::Migration
+            + class ChangeTestcaseSize < ActiveRecord::Migration[4.2]
                 def change
                   change_column :testcases, :input, :text, :limit => 4294967295
                   change_column :testcases, :sol, :text, :limit => 4294967295
                 end
               end

db/migrate/20170124024527_add_view_testcase_to_problem.rb ¶ +1 -1

-            - class AddViewTestcaseToProblem < ActiveRecord::Migration
+            + class AddViewTestcaseToProblem < ActiveRecord::Migration[4.2]
                 def change
                   add_column :problems, :view_testcase, :bool
                 end
               end

db/migrate/20170310110146_add_index_to_task.rb ¶ +1 -1

-            - class AddIndexToTask < ActiveRecord::Migration
+            + class AddIndexToTask < ActiveRecord::Migration[4.2]
                 def change
                   add_index :tasks, :submission_id
                 end
               end

db/migrate/20170427070345_add_heart_beat_full.rb ¶ +1 -1

-            - class AddHeartBeatFull < ActiveRecord::Migration
+            + class AddHeartBeatFull < ActiveRecord::Migration[4.2]
                 def up
                   GraderConfiguration.create key: 'right.heartbeat_response_full', value_type: 'string', value:'RESTART', description:'Heart beat response text when user got full score (set this value to the empty string to disable this feature)'
                 end
                 def down
                 end
               end

db/migrate/20170911091143_create_groups.rb ¶ +4 -4

-            - class CreateGroups < ActiveRecord::Migration
+            + class CreateGroups < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :groups do |t|
+            +     create_table :groups, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name
                     t.string :description
                   end
-            -     create_join_table :groups, :users do |t|
+            +     create_join_table :groups, :users, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     # t.index [:group_id, :user_id]
                     t.index [:user_id, :group_id]
                   end
-            -     create_join_table :problems, :groups do |t|
+            +     create_join_table :problems, :groups, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     # t.index [:problem_id, :group_id]
                     t.index [:group_id, :problem_id]
                   end
                   reversible do |change|
                     change.up do
                       GraderConfiguration.where(key: 'system.use_problem_group').first_or_create(value_type: 'boolean', value: 'false',
                                                                                                  description: 'If true, available problem to the user will be only ones associated with the group of the user');
                     end
                     change.down do
                       GraderConfiguration.where(key: 'system.use_problem_group').destroy_all
                     end
                   end
                 end
               end

db/migrate/20170914150545_create_tags.rb ¶ +2 -2

-            - class CreateTags < ActiveRecord::Migration
+            + class CreateTags < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :tags do |t|
+            +     create_table :tags, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.string :name, null: false
                     t.text :description
                     t.boolean :public
                     t.timestamps null: false
                   end
                 end
               end

db/migrate/20170914150742_create_problem_tags.rb ¶ +2 -2

-            - class CreateProblemTags < ActiveRecord::Migration
+            + class CreateProblemTags < ActiveRecord::Migration[4.2]
                 def change
-            -     create_table :problems_tags do |t|
+            +     create_table :problems_tags, options: "ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" do |t|
                     t.references :problem, index: true, foreign_key: true
                     t.references :tag, index: true, foreign_key: true
                     t.index [:problem_id,:tag_id], unique: true
                   end
                 end
               end

Write
Preview

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

Sign in to your account

Author

r822:f42556ce3209 - Sat, 15 Jan 2022 14:03:59 - 77 files changed: 120 inserted, 111 deleted

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
n r	New repository page
n g	New gist page

	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

Sign in to your account

Commit r822:f42556ce3209 public

Author

r822:f42556ce3209 - Sat, 15 Jan 2022 14:03:59 - 77 files changed: 120 inserted, 111 deleted

Commit `r822:f42556ce3209` public