Consolidate down to a single schema file - warvox - VoIP based wardialing tool, forked from rapid7/warvox.
DIR Log
DIR Files
DIR Refs
DIR README
---
DIR commit 8fbbf361cb7ed35a8d7c9e12c1309a34183f3782
DIR parent 57cad5dc3589d4f93bbb90850a42430f5d17e0b2
HTML Author: HD Moore <hd_moore@rapid7.com>
Date: Wed, 26 Dec 2012 15:44:41 -0600
Consolidate down to a single schema file
Diffstat:
D web/db/migrate/20090228195925_crea… | 18 ------------------
D web/db/migrate/20090228200035_crea… | 20 --------------------
D web/db/migrate/20090228200141_crea… | 22 ----------------------
D web/db/migrate/20090301084459_add_… | 9 ---------
D web/db/migrate/20090303204859_add_… | 9 ---------
D web/db/migrate/20090303204917_add_… | 9 ---------
D web/db/migrate/20090303225838_add_… | 9 ---------
D web/db/migrate/20090304013815_add_… | 10 ----------
D web/db/migrate/20090304013839_add_… | 9 ---------
D web/db/migrate/20090304013909_add_… | 10 ----------
D web/db/migrate/20090304014018_add_… | 9 ---------
D web/db/migrate/20090304014033_add_… | 9 ---------
D web/db/migrate/20090522202032_add_… | 9 ---------
D web/db/migrate/20090526031826_add_… | 11 -----------
D web/db/migrate/20110801000001_add_… | 11 -----------
D web/db/migrate/20110801000002_add_… | 10 ----------
D web/db/migrate/20110801000003_add_… | 20 --------------------
M web/db/schema.rb | 3 +++
18 files changed, 3 insertions(+), 204 deletions(-)
---
DIR diff --git a/web/db/migrate/20090228195925_create_providers.rb b/web/db/migrate/20090228195925_create_providers.rb
@@ -1,18 +0,0 @@
-class CreateProviders < ActiveRecord::Migration
- def self.up
- create_table :providers do |t|
- t.text :name
- t.text :host
- t.integer :port
- t.text :user
- t.text :pass
- t.integer :lines
-
- t.timestamps
- end
- end
-
- def self.down
- drop_table :providers
- end
-end
DIR diff --git a/web/db/migrate/20090228200035_create_dial_jobs.rb b/web/db/migrate/20090228200035_create_dial_jobs.rb
@@ -1,20 +0,0 @@
-class CreateDialJobs < ActiveRecord::Migration
- def self.up
- create_table :dial_jobs do |t|
- t.text :range
- t.integer :seconds
- t.integer :lines
- t.text :status
- t.integer :progress
- t.datetime :started_at
- t.datetime :completed_at
- t.boolean :processed
-
- t.timestamps
- end
- end
-
- def self.down
- drop_table :dial_jobs
- end
-end
DIR diff --git a/web/db/migrate/20090228200141_create_dial_results.rb b/web/db/migrate/20090228200141_create_dial_results.rb
@@ -1,22 +0,0 @@
-class CreateDialResults < ActiveRecord::Migration
- def self.up
- create_table :dial_results do |t|
- t.text :number
- t.integer :dial_job_id
- t.integer :provider_id
- t.boolean :completed
- t.boolean :busy
- t.integer :seconds
- t.integer :ringtime
- t.text :rawfile
- t.boolean :processed
-
- t.timestamps
- end
- end
-
- def self.down
- drop_table :dial_results
- end
-end
-
DIR diff --git a/web/db/migrate/20090301084459_add_processed_at_to_dial_result.rb b/web/db/migrate/20090301084459_add_processed_at_to_dial_result.rb
@@ -1,9 +0,0 @@
-class AddProcessedAtToDialResult < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :processed_at, :datetime
- end
-
- def self.down
- remove_column :dial_results, :processed_at
- end
-end
DIR diff --git a/web/db/migrate/20090303204859_add_cid_mask_to_dial_jobs.rb b/web/db/migrate/20090303204859_add_cid_mask_to_dial_jobs.rb
@@ -1,9 +0,0 @@
-class AddCidMaskToDialJobs < ActiveRecord::Migration
- def self.up
- add_column :dial_jobs, :cid_mask, :text
- end
-
- def self.down
- remove_column :dial_jobs, :cid_mask
- end
-end
DIR diff --git a/web/db/migrate/20090303204917_add_cid_to_dial_results.rb b/web/db/migrate/20090303204917_add_cid_to_dial_results.rb
@@ -1,9 +0,0 @@
-class AddCidToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :cid, :text
- end
-
- def self.down
- remove_column :dial_results, :cid
- end
-end
DIR diff --git a/web/db/migrate/20090303225838_add_enabled_to_providers.rb b/web/db/migrate/20090303225838_add_enabled_to_providers.rb
@@ -1,9 +0,0 @@
-class AddEnabledToProviders < ActiveRecord::Migration
- def self.up
- add_column :providers, :enabled, :boolean
- end
-
- def self.down
- remove_column :providers, :enabled
- end
-end
DIR diff --git a/web/db/migrate/20090304013815_add_peak_freq_to_dial_results.rb b/web/db/migrate/20090304013815_add_peak_freq_to_dial_results.rb
@@ -1,10 +0,0 @@
-class AddPeakFreqToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :peak_freq, :float
- end
-
- def self.down
- remove_column :dial_results, :peak_freq
- end
-end
-
DIR diff --git a/web/db/migrate/20090304013839_add_peak_freq_data_to_dial_results.rb b/web/db/migrate/20090304013839_add_peak_freq_data_to_dial_results.rb
@@ -1,9 +0,0 @@
-class AddPeakFreqDataToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :peak_freq_data, :text
- end
-
- def self.down
- remove_column :dial_results, :peak_freq_data
- end
-end
DIR diff --git a/web/db/migrate/20090304013909_add_sig_data_to_dial_results.rb b/web/db/migrate/20090304013909_add_sig_data_to_dial_results.rb
@@ -1,10 +0,0 @@
-class AddSigDataToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :sig_data, :text
- end
-
- def self.down
- remove_column :dial_results, :sig_data
- end
-end
-
DIR diff --git a/web/db/migrate/20090304014018_add_line_type_to_dial_results.rb b/web/db/migrate/20090304014018_add_line_type_to_dial_results.rb
@@ -1,9 +0,0 @@
-class AddLineTypeToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :line_type, :text
- end
-
- def self.down
- remove_column :dial_results, :line_type
- end
-end
DIR diff --git a/web/db/migrate/20090304014033_add_notes_to_dial_results.rb b/web/db/migrate/20090304014033_add_notes_to_dial_results.rb
@@ -1,9 +0,0 @@
-class AddNotesToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :notes, :text
- end
-
- def self.down
- remove_column :dial_results, :notes
- end
-end
DIR diff --git a/web/db/migrate/20090522202032_add_signatures_to_dial_results.rb b/web/db/migrate/20090522202032_add_signatures_to_dial_results.rb
@@ -1,9 +0,0 @@
-class AddSignaturesToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :signatures, :text
- end
-
- def self.down
- remove_column :dial_results, :signatures
- end
-end
DIR diff --git a/web/db/migrate/20090526031826_add_mf_and_dtmf_to_dial_results.rb b/web/db/migrate/20090526031826_add_mf_and_dtmf_to_dial_results.rb
@@ -1,11 +0,0 @@
-class AddMfAndDtmfToDialResults < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :dtmf, :text
- add_column :dial_results, :mf, :text
- end
-
- def self.down
- remove_column :dial_results, :dtmf
- remove_column :dial_results, :mf
- end
-end
DIR diff --git a/web/db/migrate/20110801000001_add_fprint_to_dial_result.rb b/web/db/migrate/20110801000001_add_fprint_to_dial_result.rb
@@ -1,11 +0,0 @@
-class AddFprintToDialResult < ActiveRecord::Migration
- def self.up
- execute "CREATE EXTENSION intarray"
- add_column :dial_results, :fprint, 'int[]'
- end
-
- def self.down
- remove_column :dial_results, :fprint
- execute "DROP EXTENSION intarray"
- end
-end
DIR diff --git a/web/db/migrate/20110801000002_add_audio_to_dial_result.rb b/web/db/migrate/20110801000002_add_audio_to_dial_result.rb
@@ -1,10 +0,0 @@
-class AddAudioToDialResult < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :audio, :binary
- end
-
- def self.down
- remove_column :dial_results, :audio
- end
-end
-
DIR diff --git a/web/db/migrate/20110801000003_add_media_to_dial_result.rb b/web/db/migrate/20110801000003_add_media_to_dial_result.rb
@@ -1,20 +0,0 @@
-class AddMediaToDialResult < ActiveRecord::Migration
- def self.up
- add_column :dial_results, :mp3, :binary
- add_column :dial_results, :png_big, :binary
- add_column :dial_results, :png_big_dots, :binary
- add_column :dial_results, :png_big_freq, :binary
- add_column :dial_results, :png_sig, :binary
- add_column :dial_results, :png_sig_freq, :binary
- end
-
- def self.down
- remove_column :dial_results, :mp3
- remove_column :dial_results, :png_big
- remove_column :dial_results, :png_big_dots
- remove_column :dial_results, :png_big_freq
- remove_column :dial_results, :png_sig
- remove_column :dial_results, :png_sig_freq
- end
-end
-
DIR diff --git a/web/db/schema.rb b/web/db/schema.rb
@@ -13,6 +13,9 @@
ActiveRecord::Schema.define(:version => 20110801000003) do
+ # Require the intarray extension
+ execute "CREATE EXTENSION IF NOT EXISTS intarray"
+
create_table "dial_jobs", :force => true do |t|
t.text "range"
t.integer "seconds"