From b80bd744ad873f6fc43018bc4bfb90677de167bd Mon Sep 17 00:00:00 2001 From: Stefan Wintermeyer Date: Mon, 17 Dec 2012 12:01:45 +0100 Subject: Start of GS5. --- db/migrate/20111106083400_create_voicemail_msgs.rb | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 db/migrate/20111106083400_create_voicemail_msgs.rb (limited to 'db/migrate/20111106083400_create_voicemail_msgs.rb') 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 -- cgit v1.2.3