Sha256: 5b96d94c5a8754a5ca360d345c952dabab0136a6fc185e9f9b9a99f47482da5e
Contents?: true
Size: 1.89 KB
Versions: 6
Compression:
Stored size: 1.89 KB
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
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
6 entries across 6 versions & 1 rubygems