Contents

# encoding: UTF-8

Sequel.migration do
  up do
    adapter_scheme =  self.adapter_scheme

    add_column :content, :created_at,         DateTime
    add_column :content, :modified_at,        DateTime

    add_column :content, :first_published_at, DateTime
    add_column :content, :last_published_at,  DateTime

    add_column :content, :first_published_revision,  Integer

    # keeps track of publication dates
    create_table(:revisions, :engine => "INNODB", :charset => "UTF8", :collate => "utf8_general_ci") do
      primary_key :id
      integer     :revision
      timestamp   :published_at
    end

    # keeps track of all pages changed by a set of actions
    create_table(:changes, :engine => "INNODB", :charset => "UTF8", :collate => "utf8_general_ci") do
      primary_key :id
      varchar     :title
      timestamp   :created_at
      text        :modified_list
    end
  end

  down do
    drop_column :artists, :first_published_at
    drop_column :content, :created_at,         DateTime
    drop_column :content, :modified_at,        DateTime
    drop_column :content, :first_published_at, DateTime
    drop_column :content, :last_published_at,  DateTime
    drop_column :content, :first_published_revision,  Integer
    drop_table :revisions
    drop_table :changes
  end
end

Version data entries

17 entries across 17 versions & 1 rubygems

Version	Path
spontaneous-0.2.0.beta10	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta9	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta8	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta7	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta6	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta5	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta4	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta3	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta2	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.beta1	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha7	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha6	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha5	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha4	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha3	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha2	db/migrations/20101130104334_timestamps.rb
spontaneous-0.2.0.alpha1	db/migrations/20101130104334_timestamps.rb