aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--db/migrate/035_track_overdue_alerts.rb6
-rw-r--r--db/schema.rb6
2 files changed, 6 insertions, 6 deletions
diff --git a/db/migrate/035_track_overdue_alerts.rb b/db/migrate/035_track_overdue_alerts.rb
index 10e92b690..a97deeb6a 100644
--- a/db/migrate/035_track_overdue_alerts.rb
+++ b/db/migrate/035_track_overdue_alerts.rb
@@ -1,10 +1,10 @@
class TrackOverdueAlerts < ActiveRecord::Migration
def self.up
create_table :user_info_request_sent_alerts do |t|
- t.column :user_id, :integer
- t.column :info_request_id, :integer
+ t.column :user_id, :integer, :null => false
+ t.column :info_request_id, :integer, :null => false
- t.column :alert_type, :string
+ t.column :alert_type, :string, :null => false
end
execute "ALTER TABLE user_info_request_sent_alerts ADD CONSTRAINT fk_info_request_sent_alerts_user FOREIGN KEY (user_id) REFERENCES users(id)"
diff --git a/db/schema.rb b/db/schema.rb
index dfcc7e884..a247262dc 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -102,9 +102,9 @@ ActiveRecord::Schema.define(:version => 35) do
add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
create_table "user_info_request_sent_alerts", :force => true do |t|
- t.integer "user_id"
- t.integer "info_request_id"
- t.string "alert_type"
+ t.integer "user_id", :null => false
+ t.integer "info_request_id", :null => false
+ t.string "alert_type", :null => false
end
create_table "users", :force => true do |t|