aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/048_add_calculated_state_at.rb10
-rw-r--r--db/schema.rb11
2 files changed, 16 insertions, 5 deletions
diff --git a/db/migrate/048_add_calculated_state_at.rb b/db/migrate/048_add_calculated_state_at.rb
new file mode 100644
index 000000000..63f7e996d
--- /dev/null
+++ b/db/migrate/048_add_calculated_state_at.rb
@@ -0,0 +1,10 @@
+class AddCalculatedStateAt < ActiveRecord::Migration
+ def self.up
+ # This is for use in RSS feeds
+ add_column :info_request_events, :last_described_at, :datetime
+ end
+
+ def self.down
+ remove_column :info_request_events, :last_described_at
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 6f4c975ae..7083fbfd6 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 => 47) do
+ActiveRecord::Schema.define(:version => 48) do
create_table "incoming_messages", :force => true do |t|
t.integer "info_request_id", :null => false
@@ -19,12 +19,13 @@ ActiveRecord::Schema.define(:version => 47) do
end
create_table "info_request_events", :force => true do |t|
- t.integer "info_request_id", :null => false
- t.text "event_type", :null => false
- t.text "params_yaml", :null => false
- t.datetime "created_at", :null => false
+ t.integer "info_request_id", :null => false
+ t.text "event_type", :null => false
+ t.text "params_yaml", :null => false
+ t.datetime "created_at", :null => false
t.string "described_state"
t.string "calculated_state"
+ t.datetime "last_described_at"
end
create_table "info_requests", :force => true do |t|