aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.rb
diff options
context:
space:
mode:
authorfrancis <francis>2008-04-01 16:40:37 +0000
committerfrancis <francis>2008-04-01 16:40:37 +0000
commitbaa530c0c8f5fb1e12173fbfde8f722ebeffe5be (patch)
treed80dd72953de39723d3208f78247052352e85fb1 /db/schema.rb
parent708480da65908e38e00cfa1eaef9b7f04cc9a4a6 (diff)
Skeleton of tracking / alerting / email.
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb18
1 files changed, 17 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 7083fbfd6..e800b916d 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -9,7 +9,7 @@
#
# It's strongly recommended to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 48) do
+ActiveRecord::Schema.define(:version => 49) do
create_table "incoming_messages", :force => true do |t|
t.integer "info_request_id", :null => false
@@ -117,6 +117,22 @@ ActiveRecord::Schema.define(:version => 48) do
add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
+ create_table "track_things", :force => true do |t|
+ t.integer "tracking_user_id", :null => false
+ t.string "track_query", :null => false
+ t.integer "info_request_id"
+ t.integer "tracked_user_id"
+ t.integer "public_body_id"
+ t.string "track_medium", :null => false
+ end
+
+ create_table "track_things_sent_emails", :force => true do |t|
+ t.integer "track_thing_id", :null => false
+ t.integer "info_request_event_id"
+ t.integer "user_id"
+ t.integer "public_body_id"
+ end
+
create_table "user_info_request_sent_alerts", :force => true do |t|
t.integer "user_id", :null => false
t.integer "info_request_id", :null => false