Sha256: cc3c6e63e457a1dc2047a64058ea81ba7bc086886730a559c82648605937ff1e
Contents?: true
Size: 1.35 KB
Versions: 16
Compression:
Stored size: 1.35 KB
Contents
Sequel.migration do
up do
create_table :category_groups do
primary_key :id
String :name, :null => false
String :description, :text => true
end
create_table :categories do
primary_key :id
Integer :parent_id, :index => true
String :name, :null => false
String :description, :text => true
String :slug, :null => false, :unique => true
foreign_key :category_group_id, :category_groups, :on_delete => :cascade,
:on_update => :cascade, :key => :id
end
create_table :categories_section_entries do
foreign_key :section_entry_id, :section_entries, :on_delete => :cascade, :on_update => :cascade, :key => :id
foreign_key :category_id, :categories, :on_delete => :cascade, :on_update => :cascade, :key => :id
end
create_table :category_groups_sections do
foreign_key :section_id, :sections, :on_delete => :cascade, :on_update => :cascade, :key => :id
foreign_key :category_group_id, :category_groups, :on_delete => :cascade, :on_update => :cascade, :key => :id
end
end
down do
drop_table :category_groups_sections
drop_table :categories_section_entries
drop_table :categories
drop_table :category_groups
end
end
Version data entries
16 entries across 16 versions & 1 rubygems