Consolidate down to a single schema file - warvox - Unnamed repository; edit th… | |
Log | |
Files | |
Refs | |
README | |
--- | |
commit 8fbbf361cb7ed35a8d7c9e12c1309a34183f3782 | |
parent 57cad5dc3589d4f93bbb90850a42430f5d17e0b2 | |
Author: HD Moore <[email protected]> | |
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(-) | |
--- | |
diff --git a/web/db/migrate/20090228195925_create_providers.rb b/web/db/migrate… | |
@@ -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 | |
diff --git a/web/db/migrate/20090228200035_create_dial_jobs.rb b/web/db/migrate… | |
@@ -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 | |
diff --git a/web/db/migrate/20090228200141_create_dial_results.rb b/web/db/migr… | |
@@ -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 | |
- | |
diff --git a/web/db/migrate/20090301084459_add_processed_at_to_dial_result.rb b… | |
@@ -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 | |
diff --git a/web/db/migrate/20090303204859_add_cid_mask_to_dial_jobs.rb b/web/d… | |
@@ -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 | |
diff --git a/web/db/migrate/20090303204917_add_cid_to_dial_results.rb b/web/db/… | |
@@ -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 | |
diff --git a/web/db/migrate/20090303225838_add_enabled_to_providers.rb b/web/db… | |
@@ -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 | |
diff --git a/web/db/migrate/20090304013815_add_peak_freq_to_dial_results.rb b/w… | |
@@ -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 | |
- | |
diff --git a/web/db/migrate/20090304013839_add_peak_freq_data_to_dial_results.r… | |
@@ -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 | |
diff --git a/web/db/migrate/20090304013909_add_sig_data_to_dial_results.rb b/we… | |
@@ -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 | |
- | |
diff --git a/web/db/migrate/20090304014018_add_line_type_to_dial_results.rb b/w… | |
@@ -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 | |
diff --git a/web/db/migrate/20090304014033_add_notes_to_dial_results.rb b/web/d… | |
@@ -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 | |
diff --git a/web/db/migrate/20090522202032_add_signatures_to_dial_results.rb b/… | |
@@ -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 | |
diff --git a/web/db/migrate/20090526031826_add_mf_and_dtmf_to_dial_results.rb b… | |
@@ -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 | |
diff --git a/web/db/migrate/20110801000001_add_fprint_to_dial_result.rb b/web/d… | |
@@ -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 | |
diff --git a/web/db/migrate/20110801000002_add_audio_to_dial_result.rb b/web/db… | |
@@ -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 | |
- | |
diff --git a/web/db/migrate/20110801000003_add_media_to_dial_result.rb b/web/db… | |
@@ -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 | |
- | |
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" |