6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
# File 'lib/generators/ruby_cms/templates/db/migrate/20260328000001_create_content_block_versions.rb', line 6
def change
create_table :content_block_versions, if_not_exists: true do |t|
t.references :content_block, null: false, foreign_key: true, index: true
t.references :user, null: true, foreign_key: true
t.integer :version_number, null: false
t.string :title, null: false
t.text :content
t.text :rich_content_html
t.string :content_type, null: false
t.boolean :published, null: false, default: true
t.string :event, null: false, default: "update"
RubyCms::MigrationHelpers.json_column(t, :metadata, default: {})
t.datetime :created_at, null: false
end
add_index :content_block_versions, %i[content_block_id version_number],
unique: true, name: "idx_cb_versions_on_block_and_number", if_not_exists: true
end
|