 |
schema.rb - warvox - VoIP based wardialing tool, forked from rapid7/warvox. |
 |
git clone git://jay.scot/warvox |
 |
Log |
|
Files |
|
Refs |
|
README |
|
--- |
|
schema.rb (7856B) |
|
--- |
|
1 # This file is auto-generated from the current state of the database. In… |
|
2 # of editing this file, please use the migrations feature of Active Reco… |
|
3 # incrementally modify your database, and then regenerate this schema de… |
|
4 # |
|
5 # Note that this schema.rb definition is the authoritative source for yo… |
|
6 # database schema. If you need to create the application database on ano… |
|
7 # system, you should be using db:schema:load, not running all the migrat… |
|
8 # from scratch. The latter is a flawed and unsustainable approach (the m… |
|
9 # you'll amass, the slower it'll run and the greater likelihood for issu… |
|
10 # |
|
11 # It's strongly recommended that you check this file into your version c… |
|
12 |
|
13 ActiveRecord::Schema.define(version: 20130113004653) do |
|
14 |
|
15 # These are extensions that must be enabled in order to support this d… |
|
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: :bt… |
|
30 t.index ["project_id"], name: "index_call_media_on_project_id", usin… |
|
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: … |
|
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: :bt… |
|
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… |
|
84 t.index ["project_id"], name: "index_line_attributes_on_project_id",… |
|
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: :b… |
|
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", "co… |
|
131 t.index ["model_name", "report_name", "grouping", "aggregation", "co… |
|
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_… |
|
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"… |
|
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 |
