Sha256: 0fbbb1b99719f3a2208515a34b7ed4aacc972a718086471e588b514fa7a941b8
Contents?: true
Size: 861 Bytes
Versions: 16
Compression:
Stored size: 861 Bytes
Contents
class CreateSocialNetworkingProfileAnswers < ActiveRecord::Migration
def change
create_table :social_networking_profile_answers do |t|
t.integer :social_networking_profile_question_id, null: false
t.integer :order, null: true
t.string :answer_text, null: false
t.timestamps
end
reversible do |dir|
dir.up do
execute <<-SQL
ALTER TABLE social_networking_profile_answers
ADD CONSTRAINT fk_profile_answers_profile_questions
FOREIGN KEY (social_networking_profile_question_id)
REFERENCES social_networking_profile_questions(id)
SQL
end
dir.down do
execute <<-SQL
ALTER TABLE social_networking_profile_answers
DROP CONSTRAINT IF EXISTS fk_profile_answers_profile_questions
SQL
end
end
end
end
Version data entries
16 entries across 16 versions & 1 rubygems