schema.rb - warvox - VoIP based wardialing tool, forked from rapid7/warvox.
(HTM) git clone git://jay.scot/warvox
(DIR) Log
(DIR) Files
(DIR) Refs
(DIR) README
---
schema.rb (7856B)
---
1 # This file is auto-generated from the current state of the database. Instead
2 # of editing this file, please use the migrations feature of Active Record to
3 # incrementally modify your database, and then regenerate this schema definition.
4 #
5 # Note that this schema.rb definition is the authoritative source for your
6 # database schema. If you need to create the application database on another
7 # system, you should be using db:schema:load, not running all the migrations
8 # from scratch. The latter is a flawed and unsustainable approach (the more migrations
9 # you'll amass, the slower it'll run and the greater likelihood for issues).
10 #
11 # It's strongly recommended that you check this file into your version control system.
12
13 ActiveRecord::Schema.define(version: 20130113004653) do
14
15 # These are extensions that must be enabled in order to support this database
16 enable_extension "plpgsql"
17 enable_extension "intarray"
18
19 create_table "call_media", force: :cascade do |t|
20 t.integer "call_id", null: false
21 t.integer "project_id", null: false
22 t.binary "audio"
23 t.binary "mp3"
24 t.binary "png_big"
25 t.binary "png_big_dots"
26 t.binary "png_big_freq"
27 t.binary "png_sig"
28 t.binary "png_sig_freq"
29 t.index ["call_id"], name: "index_call_media_on_call_id", using: :btree
30 t.index ["project_id"], name: "index_call_media_on_project_id", using: :btree
31 end
32
33 create_table "calls", force: :cascade do |t|
34 t.datetime "created_at", null: false
35 t.datetime "updated_at", null: false
36 t.text "number", null: false
37 t.integer "project_id", null: false
38 t.integer "job_id", null: false
39 t.integer "provider_id", null: false
40 t.boolean "answered"
41 t.boolean "busy"
42 t.text "error"
43 t.integer "audio_length"
44 t.integer "ring_length"
45 t.text "caller_id"
46 t.integer "analysis_job_id"
47 t.datetime "analysis_started_at"
48 t.datetime "analysis_completed_at"
49 t.float "peak_freq"
50 t.text "peak_freq_data"
51 t.text "line_type"
52 t.integer "fprint", array: true
53 t.index ["job_id"], name: "index_calls_on_job_id", using: :btree
54 t.index ["number"], name: "index_calls_on_number", using: :btree
55 t.index ["provider_id"], name: "index_calls_on_provider_id", using: :btree
56 end
57
58 create_table "jobs", force: :cascade do |t|
59 t.datetime "created_at", null: false
60 t.datetime "updated_at", null: false
61 t.integer "project_id", null: false
62 t.string "locked_by"
63 t.datetime "locked_at"
64 t.datetime "started_at"
65 t.datetime "completed_at"
66 t.string "created_by"
67 t.string "task", null: false
68 t.binary "args"
69 t.string "status"
70 t.text "error"
71 t.integer "progress", default: 0
72 t.index ["project_id"], name: "index_jobs_on_project_id", using: :btree
73 end
74
75 create_table "line_attributes", force: :cascade do |t|
76 t.datetime "created_at", null: false
77 t.datetime "updated_at", null: false
78 t.integer "line_id", null: false
79 t.integer "project_id", null: false
80 t.text "name", null: false
81 t.binary "value", null: false
82 t.string "content_type", default: "text"
83 t.index ["line_id"], name: "index_line_attributes_on_line_id", using: :btree
84 t.index ["project_id"], name: "index_line_attributes_on_project_id", using: :btree
85 end
86
87 create_table "lines", force: :cascade do |t|
88 t.datetime "created_at", null: false
89 t.datetime "updated_at", null: false
90 t.text "number", null: false
91 t.integer "project_id", null: false
92 t.text "line_type"
93 t.text "notes"
94 t.index ["number"], name: "index_lines_on_number", using: :btree
95 t.index ["project_id"], name: "index_lines_on_project_id", using: :btree
96 end
97
98 create_table "projects", force: :cascade do |t|
99 t.datetime "created_at", null: false
100 t.datetime "updated_at", null: false
101 t.text "name", null: false
102 t.text "description"
103 t.text "included"
104 t.text "excluded"
105 t.string "created_by"
106 end
107
108 create_table "providers", force: :cascade do |t|
109 t.datetime "created_at", null: false
110 t.datetime "updated_at", null: false
111 t.text "name", null: false
112 t.text "host", null: false
113 t.integer "port", null: false
114 t.text "user"
115 t.text "pass"
116 t.integer "lines", default: 1, null: false
117 t.boolean "enabled", default: true
118 end
119
120 create_table "reportable_cache", force: :cascade do |t|
121 t.string "model_name", limit: 100, null: false
122 t.string "report_name", limit: 100, null: false
123 t.string "grouping", limit: 10, null: false
124 t.string "aggregation", limit: 10, null: false
125 t.string "conditions", limit: 100, null: false
126 t.float "value", default: 0.0, null: false
127 t.datetime "reporting_period", null: false
128 t.datetime "created_at", null: false
129 t.datetime "updated_at", null: false
130 t.index ["model_name", "report_name", "grouping", "aggregation", "conditions", "reporting_period"], name: "name_model_grouping_aggregation_period", unique: true, using: :btree
131 t.index ["model_name", "report_name", "grouping", "aggregation", "conditions"], name: "name_model_grouping_agregation", using: :btree
132 end
133
134 create_table "settings", force: :cascade do |t|
135 t.string "var", null: false
136 t.text "value"
137 t.integer "thing_id"
138 t.string "thing_type", limit: 30
139 t.datetime "created_at", null: false
140 t.datetime "updated_at", null: false
141 t.index ["thing_type", "thing_id", "var"], name: "index_settings_on_thing_type_and_thing_id_and_var", unique: true, using: :btree
142 end
143
144 create_table "signature_fp", force: :cascade do |t|
145 t.integer "signature_id", null: false
146 t.integer "fprint", array: true
147 t.index ["signature_id"], name: "index_signature_fp_on_signature_id", using: :btree
148 end
149
150 create_table "signatures", force: :cascade do |t|
151 t.datetime "created_at", null: false
152 t.datetime "updated_at", null: false
153 t.text "name", null: false
154 t.string "source"
155 t.text "description"
156 t.string "category"
157 t.string "line_type"
158 t.integer "risk"
159 end
160
161 create_table "users", force: :cascade do |t|
162 t.string "login", null: false
163 t.string "email"
164 t.string "crypted_password", null: false
165 t.string "password_salt", null: false
166 t.string "persistence_token", null: false
167 t.string "single_access_token", null: false
168 t.string "perishable_token", null: false
169 t.integer "login_count", default: 0, null: false
170 t.integer "failed_login_count", default: 0, null: false
171 t.datetime "last_request_at"
172 t.datetime "current_login_at"
173 t.datetime "last_login_at"
174 t.string "current_login_ip"
175 t.string "last_login_ip"
176 t.datetime "created_at", null: false
177 t.datetime "updated_at", null: false
178 t.boolean "enabled", default: true
179 t.boolean "admin", default: true
180 end
181
182 end