diff options
Diffstat (limited to 'db/migrate/20111106083400_create_voicemail_msgs.rb')
-rw-r--r-- | db/migrate/20111106083400_create_voicemail_msgs.rb | 30 |
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 |