4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
# File 'lib/generators/omnitrack/install/templates/create_omnitrack_dashboard_tables.rb', line 4
def change
create_table :omnitrack_visit_events do |t|
t.string :operation
t.string :event_name
t.string :request_path
t.string :request_method
t.string :ip
t.string :user_agent
t.string :session_id
t.string :visitor_token
t.string :locale
t.json :payload_json
t.json :context_json
t.datetime :started_at
t.datetime :completed_at
t.string :overall_status
t.timestamps
end
add_index :omnitrack_visit_events, :started_at
add_index :omnitrack_visit_events, :visitor_token
add_index :omnitrack_visit_events, :overall_status
create_table :omnitrack_delivery_statuses do |t|
t.references :visit_event, null: false, foreign_key: { to_table: :omnitrack_visit_events }
t.string :adapter_name
t.string :status
t.string :error_message
t.json :response_json
t.json :metadata_json
t.datetime :sent_at
t.timestamps
end
add_index :omnitrack_delivery_statuses, :status
add_index :omnitrack_delivery_statuses, :sent_at
end
|