■Slony同期対象のテーブルに関する変更 -------------------------------------- ## delayed_jobsテーブルにpayloadカラム削除 ALTER TABLE delayed_jobs ADD COLUMN payload jsonb NOT NULL DEFAULT '{}'::jsonb; CREATE INDEX index_delayed_jobs_on_payload ON delayed_jobs USING gin (payload); ## bkeditor_blocksテーブル追加 CREATE TABLE bkeditor_blocks ( id serial primary key, blockable_type varchar, blockable_id integer, type varchar, sub_kind varchar, index integer, type_index integer, line_no integer, column_no integer, position integer, name text, title text, body text, data jsonb NOT NULL DEFAULT '{}'::jsonb, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL ); CREATE INDEX index_bkeditor_blocks_on_blockable_type_and_blockable_id ON bkeditor_blocks USING btree (blockable_type, blockable_id); ■Slony同期対象外のテーブルに関する変更 -------------------------------------- ## bkeditor_samplesテーブル追加 CREATE TABLE bkeditor_samples ( id serial primary key, site_id integer, title text, created_at timestamp without time zone NOT NULL, updated_at timestamp without time zone NOT NULL ); CREATE INDEX index_bkeditor_samples_on_site_id ON bkeditor_blocks USING btree (site_id);