Contents

Sequel.migration do

  up do
    create_table :custom_field_groups do
      primary_key :id
      
      String :name,         :null => false
      String :description,  :text => true
    end
    
    create_table :custom_fields do
      primary_key :id

      String    :name,                :null => false
      String    :slug,                :null => false, :unique => true
      String    :description,         :text => true
      Integer   :sort_order,          :default  => 0
      String    :type,                :null => false, :default => 'textbox'
      String    :format,              :null => false, :default => 'plain'
      String    :possible_values,     :text => true
      
      # Custom field settings
      TrueClass :required,            :null => false, :default => false
      TrueClass :visual_editor,       :null => false, :default => true
      Integer   :textarea_rows,       :default => 10
      Integer   :text_limit,          :default => 1
      
      foreign_key :custom_field_group_id, :custom_field_groups, :on_delete => :cascade,
        :on_update => :cascade, :key => :id
    end
    
    create_table :custom_field_groups_sections do
      foreign_key :custom_field_group_id, :custom_field_groups, :on_delete => :cascade, :on_update => :cascade, :key => :id
      foreign_key :section_id,            :sections,            :on_delete => :cascade, :on_update => :cascade, :key => :id
    end
    
    create_table :custom_field_values do
      primary_key :id
    
      String  :value, :text  => true
      
      foreign_key :custom_field_id,  :custom_fields,   :on_delete => :cascade, :on_update => :cascade, :key => :id
      foreign_key :section_entry_id, :section_entries, :on_delete => :cascade, :on_update => :cascade, :key => :id
    end
  end
  
  down do
    drop_table :custom_field_values
    drop_table :custom_field_groups_sections
    drop_table :custom_fields
    drop_table :custom_field_groups
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
zen-0.2.3	lib/zen/package/custom_fields/migrations/1295255665_create_schema.rb
zen-0.2	lib/zen/package/custom_fields/migrations/1295255665_create_schema.rb