/
20131106162900_base_schema.rb
73 lines (64 loc) · 2.6 KB
/
20131106162900_base_schema.rb
1
2
3
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
class BaseSchema < ActiveRecord::Migration
def up
create_table "applications", :force => true do |t|
t.integer "user_id"
t.string "name", :null => false
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "deleted_at"
t.string "ancestry"
t.string "description"
end
add_index "applications", ["ancestry"], :name => "index_applications_on_ancestry"
add_index "applications", ["user_id"], :name => "user_id"
create_table "job_data", :force => true do |t|
t.integer "job_id", :default => 0, :null => false
t.datetime "created_at"
t.datetime "updated_at"
t.text "data", :limit => 1073741823, :null => false
end
create_table "job_errors", :force => true do |t|
t.integer "job_id"
t.datetime "created_at"
t.text "message", :limit => 1073741823
t.string "status"
t.datetime "last_alerted_at"
t.datetime "updated_at"
end
add_index "job_errors", ["job_id"], :name => "job_id"
create_table "jobs", :force => true do |t|
t.datetime "created_at"
t.datetime "updated_at"
t.string "name", :null => false
t.boolean "active", :default => true, :null => false
t.datetime "last_run"
t.string "cron_expr", :limit => 1024, :null => false
t.string "status"
t.integer "user_id"
t.text "alert_keys"
t.datetime "deleted_at"
t.integer "error_timeout", :default => 60, :null => false
t.datetime "next_run"
t.text "description"
t.integer "app_id", :null => false
t.text "metrics", :null => false
t.text "monitor_expr"
t.integer "minutes"
t.text "to_date"
end
add_index "jobs", ["app_id"], :name => "app_id"
add_index "jobs", ["id", "name"], :name => "id_name_version_key", :unique => true
add_index "jobs", ["user_id"], :name => "jobs_ibfk_1"
create_table "users", :force => true do |t|
t.datetime "created_at"
t.datetime "updated_at"
t.string "encrypted_password", :null => false, :default => ""
t.string "email", :null => false
t.string "first_name"
t.string "last_name"
t.datetime "last_login"
t.text "preferences"
end
add_index "users", ["email"], :name => "email", :unique => true
end
end