Packages

thesis

0.0.20
0.3.4 0.3.3 0.3.2 0.3.1 0.3.0 0.2.0 0.1.0 0.0.30 0.0.29 0.0.28 0.0.27 0.0.26 0.0.25 0.0.24 0.0.23 0.0.22 0.0.21 0.0.20 0.0.19 0.0.18 0.0.17 0.0.16 0.0.15 0.0.14 0.0.13 0.0.12 0.0.11 0.0.10 0.0.9 0.0.8 0.0.7 0.0.6 0.0.5 0.0.4 0.0.3 0.0.2 0.0.1

Thesis is a lightweight bolt-on content editing system for Phoenix websites.

HexDocs

Current section

Files

Jump to
Readme
37 Versions
6 Dependencies
Dependants
Files
Activity
thesis priv templates thesis.install add_indexes_to_tables.exs
Raw

priv/templates/thesis.install/add_indexes_to_tables.exs 

defmodule <%= base %>.Repo.Migrations.AddIndexToTables do

  use Ecto.Migration



  def up do

    alter table(:thesis_pages) do

      modify :title,        :string, size: 512

      modify :description,  :string, size: 1024

    end



    # Index page slugs, since we're searching on those

    create index(:thesis_pages, [:slug])



    # Create foreign key constraint for page_contents -> page

    alter table(:thesis_page_contents) do

      modify :page_id, references(:thesis_pages, on_delete: :delete_all)

    end

  end



  def down do

    alter table(:thesis_pages) do

      modify :title,        :string

      modify :description,  :string

    end



    remove index(:thesis_pages, [:slug])

  end

end