SoundSoftware Code Site

class CreateAuthors < ActiveRecord::Migration

  def self.up

    create_table :authors do |t|

      t.column :user_id, :integer

      t.column :name, :string

    end

  end

  def self.down

    drop_table :authors

  end

end

class CreatePublications < ActiveRecord::Migration

  def self.up

    create_table :publications do |t|

      t.column :title, :string

      t.column :reviewed, :boolean, :default => false

    end

  end

  def self.down

    drop_table :publications

  end

end

class CreateAuthorships < ActiveRecord::Migration

  def self.up

    create_table :authorships do |t|

      t.column :author_id, :integer

      t.column :publication_id, :integer

      t.column :name_on_paper, :string

      t.column :auth_order, :integer

      t.column :institution, :string

      t.column :email, :string

    end

  end

  def self.down

    drop_table :authorships

  end

end

class CreateBibtexEntries < ActiveRecord::Migration

  def self.up

    create_table :bibtex_entries do |t|

      t.column :publication_id, :integer

      t.column :entry_type, :integer

      t.column :address, :string

      t.column :annote, :string

      t.column :booktitle, :string

      t.column :chapter, :string

      t.column :crossref, :string

      t.column :edition, :string

      t.column :editor, :string

      t.column :eprint, :string

      t.column :howpublished, :string

      t.column :journal, :string

      t.column :key, :string

      t.column :month, :string

      t.column :note, :text

      t.column :number, :string

      t.column :organization, :string

      t.column :pages, :string

      t.column :publisher, :string

      t.column :school, :string

      t.column :series, :string

      t.column :type, :string

      t.column :url, :string

      t.column :volume, :integer

      t.column :year, :integer

    end

  end

  def self.down

    drop_table :bibtex_entries

  end

end

class CreateProjectsPublicationsJoinTable < ActiveRecord::Migration

  def self.up

    create_table :projects_publications, :id => false do |t|

      t.integer :project_id

      t.integer :publication_id

    end

  end

  def self.down

    drop_table :projects_publications

  end

end

class CreateBibtexEntryTypes < ActiveRecord::Migration

  def self.up

    create_table :bibtex_entry_types do |t|

      t.string :name

      t.timestamps

    end

  end

  def self.down

    drop_table :bibtex_entry_types

  end

end

class AddExternalUrlColumnToPublications < ActiveRecord::Migration

  def self.up

    add_column :publications, :external_url, :string

  end

  def self.down

    remove_column :publications, :external_url

  end

end

inproceedings

conference

article

masterthesis

phdthesis

book

booklet

inbook

incollection

manual

techreport

proceedings

unpublished

misc