summaryrefslogtreecommitdiff
path: root/db/migrate/20111106083400_create_voicemail_msgs.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20111106083400_create_voicemail_msgs.rb')
-rw-r--r--db/migrate/20111106083400_create_voicemail_msgs.rb30
1 files changed, 30 insertions, 0 deletions
diff --git a/db/migrate/20111106083400_create_voicemail_msgs.rb b/db/migrate/20111106083400_create_voicemail_msgs.rb
new file mode 100644
index 0000000..9b78430
--- /dev/null
+++ b/db/migrate/20111106083400_create_voicemail_msgs.rb
@@ -0,0 +1,30 @@
+class CreateVoicemailMsgs < ActiveRecord::Migration
+ def self.up
+ create_table :voicemail_msgs, :id => false do |t|
+ t.integer :created_epoch
+ t.integer :read_epoch
+ t.string :username, :limit => '255'
+ t.string :domain, :limit => '255'
+ t.string :uuid, :limit => '255'
+ t.string :cid_name, :limit => '255'
+ t.string :cid_number, :limit => '255'
+ t.string :in_folder, :limit => '255'
+ t.string :file_path, :limit => '255'
+ t.integer :message_len
+ t.string :flags, :limit => '255'
+ t.string :read_flags, :limit => '255'
+ t.string :forwarded_by, :limit => '255'
+ end
+ add_index :voicemail_msgs, [ :created_epoch ], :unique => false, :name => 'voicemail_msgs_idx1'
+ add_index :voicemail_msgs, [ :username ], :unique => false, :name => 'voicemail_msgs_idx2'
+ add_index :voicemail_msgs, [ :domain ], :unique => false, :name => 'voicemail_msgs_idx3'
+ add_index :voicemail_msgs, [ :uuid ], :unique => false, :name => 'voicemail_msgs_idx4'
+ add_index :voicemail_msgs, [ :in_folder ], :unique => false, :name => 'voicemail_msgs_idx5'
+ add_index :voicemail_msgs, [ :read_flags ], :unique => false, :name => 'voicemail_msgs_idx6'
+ add_index :voicemail_msgs, [ :forwarded_by ], :unique => false, :name => 'voicemail_msgs_idx7'
+ end
+
+ def self.down
+ drop_table :voicemail_msgs
+ end
+end