Sha256: 8fa896cc4b3c99e89c8213e2892fdf65a0ae9847fa791ea7bc5596bd891780bb

Contents?: true

Size: 1.16 KB

Versions: 16

Compression:

Stored size: 1.16 KB

Contents

Sequel.migration do

  up do
    create_table :sections do
      primary_key :id
      
      String    :name,                    :null => false
      String    :slug,                    :null => false, :unique => true
      String    :description,             :text => true
      TrueClass :comment_allow,           :null => false, :default => true
      TrueClass :comment_require_account, :null => false, :default => false
      TrueClass :comment_moderate,        :null => false, :default => false
      String    :comment_format,          :null => false, :default => 'plain'
    end
    
    create_table :section_entries do
      primary_key :id
      
      String  :title   , :default => 'Untitled'
      String  :slug    , :null => false, :index   => true
      String  :status  , :null => false, :default => 'draft'
      Time    :created_at
      Time    :updated_at
      
      foreign_key :section_id, :sections, :on_delete => :cascade, :on_update => :cascade, :key => :id
      foreign_key :user_id   , :users   , :on_delete => :cascade, :on_update => :cascade, :key => :id 
    end
  end
  
  down do
    drop_table :section_entries
    drop_table :sections
  end

end

Version data entries

16 entries across 16 versions & 1 rubygems

Version Path
zen-0.4.3 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.4.2 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.4.1 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.4 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.3 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.3b1 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.3b lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.8 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.7 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.6.1 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.6 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.5 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.4.1 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.4 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2.3 lib/zen/package/sections/migrations/1295251836_create_schema.rb
zen-0.2 lib/zen/package/sections/migrations/1295251836_create_schema.rb