Sha256: eaf7abf8726a10ffe4ece174d746ab995d426a6e3827ae570d3ad449318bbc30

Contents?: true

Size: 972 Bytes

Versions: 10

Compression:

Stored size: 972 Bytes

Contents

class CreateMediaFolders < ActiveRecord::Migration[5.1]
  def up
    unless MediaFolder.table_exists?
      create_table :media_folders do |t|
        t.timestamps
        t.references :user, foreign_key: { on_update: :cascade, on_delete: :nullify }
        t.references :agent, foreign_key: { on_update: :cascade, on_delete: :nullify }
        t.inet :ip
        t.integer :parent_id
        t.integer :media_files_count, default: 0, null: false
        t.integer :depth, limit: 2, default: 0, null: false
        t.string :uuid, null: false
        t.string :snapshot
        t.string :parents_cache, default: '', null: false
        t.string :name, null: false
        t.integer :children_cache, array: true, default: [], null: false
      end

      add_foreign_key :media_folders, :media_folders, column: :parent_id, on_update: :cascade, on_delete: :cascade
    end
  end

  def down
    if MediaFolder.table_exists?
      drop_table :media_folders
    end
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version Path
biovision-base-0.22.180920.0 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.21.180812.0 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.20.180731.0 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.19.180703.1 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.17.180619 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.15.180502 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.15.180415 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.14.180326 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.11.180127 db/migrate/20171202000000_create_media_folders.rb
biovision-base-0.9.171227 db/migrate/20171202000000_create_media_folders.rb