2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# File 'lib/generators/reso/templates/create_listing_media.rb', line 2
def change
create_table :listing_media, options: 'DEFAULT CHARSET=latin1' do |t|
t.integer :media_order_number
t.string :media_url, null: false, limit: 512
t.string :media_caption
t.string :media_description
t.string :media_modification_timestamp
t.string :type, null: false
t.references :listing, index: true, null: false, foreign_key: true
t.timestamps
end
add_index :listing_media, :media_order_number
add_index :listing_media, :type
add_index :listing_media, [:media_url, :media_modification_timestamp, :media_order_number, :media_caption, :media_description], name: "on_url_and_timestamp"
end
|