Contents

Sequel.migration do
  up do
    create_table(:groups) do
      primary_key :id
      String :name, :size=>255
      Integer :is_admin
      Integer :create_posts
      Integer :edit_posts
      Integer :delete_posts
    end
    
    create_table(:posts) do
      primary_key :id
      String :title, :size=>255
      String :slug, :size=>255
      String :body, :text=>true
      Integer :user_id
      Integer :published_at
      Integer :created_at
      Integer :updated_at, :default=>0
    end
    
    create_table(:settings) do
      String :setting, :size=>255
      String :value, :text=>true
    end
    
    create_table(:users) do
      primary_key :id
      String :username, :size=>255
      String :password, :size=>255
      String :email, :size=>255
      String :group_id, :size=>255
    end
  end
  
  down do
    drop_table(:groups, :posts, :schema_info, :settings, :users)
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
blogaze-0.2.0	lib/blogaze/db/migration/001_start.rb
blogaze-0.1.0	lib/blogaze/db/migration/001_start.rb
blogaze-0.0.3	lib/blogaze/db/migration/001_start.rb
blogaze-0.0.2	lib/blogaze/db/migration/001_start.rb
blogaze-0.0.1	lib/blogaze/db/migration/001_start.rb