summaryrefslogtreecommitdiff
path: root/db/migrate
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate')
-rw-r--r--db/migrate/20130212120729_create_parking_stalls.rb16
-rw-r--r--db/migrate/20130213082703_add_language_to_sip_account.rb5
-rw-r--r--db/migrate/20130213110000_add_sounds_to_parameters.rb10
-rw-r--r--db/migrate/20130215111526_create_sim_card_providers.rb20
-rw-r--r--db/migrate/20130215112028_create_sim_cards.rb18
-rw-r--r--db/migrate/20130215133749_add_sim_card_gs_parameter.rb9
6 files changed, 78 insertions, 0 deletions
diff --git a/db/migrate/20130212120729_create_parking_stalls.rb b/db/migrate/20130212120729_create_parking_stalls.rb
new file mode 100644
index 0000000..7620942
--- /dev/null
+++ b/db/migrate/20130212120729_create_parking_stalls.rb
@@ -0,0 +1,16 @@
+class CreateParkingStalls < ActiveRecord::Migration
+ def self.up
+ create_table :parking_stalls do |t|
+ t.string :name
+ t.string :lot
+ t.integer :parking_stallable_id
+ t.string :parking_stallable_type
+ t.string :comment
+ t.timestamps
+ end
+ end
+
+ def self.down
+ drop_table :parking_stalls
+ end
+end
diff --git a/db/migrate/20130213082703_add_language_to_sip_account.rb b/db/migrate/20130213082703_add_language_to_sip_account.rb
new file mode 100644
index 0000000..24343ef
--- /dev/null
+++ b/db/migrate/20130213082703_add_language_to_sip_account.rb
@@ -0,0 +1,5 @@
+class AddLanguageToSipAccount < ActiveRecord::Migration
+ def change
+ add_column :sip_accounts, :language_code, :string
+ end
+end
diff --git a/db/migrate/20130213110000_add_sounds_to_parameters.rb b/db/migrate/20130213110000_add_sounds_to_parameters.rb
new file mode 100644
index 0000000..8c4cd94
--- /dev/null
+++ b/db/migrate/20130213110000_add_sounds_to_parameters.rb
@@ -0,0 +1,10 @@
+class AddSoundsToParameters < ActiveRecord::Migration
+ def up
+ GsParameter.create(:entity => 'dialplan', :section => 'sounds', :name => 'en', :value => '/opt/freeswitch/sounds/en/us/callie', :class_type => 'String')
+ GsParameter.create(:entity => 'dialplan', :section => 'sounds', :name => 'de', :value => '/opt/freeswitch/sounds/de/de/callie', :class_type => 'String')
+ end
+
+ def down
+ GsParameter.where(:entity => 'dialplan', :section => 'sounds').destroy_all
+ end
+end
diff --git a/db/migrate/20130215111526_create_sim_card_providers.rb b/db/migrate/20130215111526_create_sim_card_providers.rb
new file mode 100644
index 0000000..b4e0f0e
--- /dev/null
+++ b/db/migrate/20130215111526_create_sim_card_providers.rb
@@ -0,0 +1,20 @@
+class CreateSimCardProviders < ActiveRecord::Migration
+ def self.up
+ create_table :sim_card_providers do |t|
+ t.string :name
+ t.string :homepage_url
+ t.string :docu_url
+ t.string :api_server_url
+ t.string :api_username
+ t.string :api_password
+ t.string :ref
+ t.string :sip_server
+ t.boolean :include_order_card_function
+ t.timestamps
+ end
+ end
+
+ def self.down
+ drop_table :sim_card_providers
+ end
+end
diff --git a/db/migrate/20130215112028_create_sim_cards.rb b/db/migrate/20130215112028_create_sim_cards.rb
new file mode 100644
index 0000000..8962a1f
--- /dev/null
+++ b/db/migrate/20130215112028_create_sim_cards.rb
@@ -0,0 +1,18 @@
+class CreateSimCards < ActiveRecord::Migration
+ def self.up
+ create_table :sim_cards do |t|
+ t.integer :sim_card_provider_id
+ t.string :sim_number
+ t.boolean :auto_order_card
+ t.integer :sip_account_id
+ t.string :auth_key
+ t.string :state
+ t.text :log
+ t.timestamps
+ end
+ end
+
+ def self.down
+ drop_table :sim_cards
+ end
+end
diff --git a/db/migrate/20130215133749_add_sim_card_gs_parameter.rb b/db/migrate/20130215133749_add_sim_card_gs_parameter.rb
new file mode 100644
index 0000000..9b0bbba
--- /dev/null
+++ b/db/migrate/20130215133749_add_sim_card_gs_parameter.rb
@@ -0,0 +1,9 @@
+class AddSimCardGsParameter < ActiveRecord::Migration
+ def up
+ GsParameter.create(:name => 'SIM_CARDS', :section => 'System defaults', :value => 'false', :class_type => 'Boolean', :description => 'Should it be possible to use SIM cards as SIP account users.')
+ end
+
+ def down
+ GsParameter.where(:name => 'SIM_CARDS').destroy_all
+ end
+end