# Slony同期対象のテーブルに関する変更

## gp_article_docsテーブルにbktemplate_idカラム追加

```
ALTER TABLE gp_article_docs ADD COLUMN bktemplate_id integer;
CREATE INDEX index_gp_article_docs_on_bktemplate_id ON gp_article_docs USING btree (bktemplate_id);
```

## bkeditor_blocksテーブルにtemplate_block_idカラム追加

```
ALTER TABLE bkeditor_blocks ADD COLUMN template_block_id integer;
CREATE INDEX index_bkeditor_blocks_on_template_block_id ON bkeditor_blocks USING btree (template_block_id);
```

## sys_filesテーブルにmetadataカラム追加

```
ALTER TABLE sys_files ADD COLUMN metadata jsonb NOT NULL DEFAULT '{}'::jsonb;
CREATE INDEX index_sys_files_on_metadata ON sys_files USING gin (metadata);
```

## cms_data_filesテーブルにmetadataカラム追加

```
ALTER TABLE cms_data_files ADD COLUMN metadata jsonb NOT NULL DEFAULT '{}'::jsonb;
CREATE INDEX index_cms_data_files_on_metadata ON cms_data_files USING gin (metadata);
```

## ad_banner_bannersテーブルにmetadataカラム追加

```
ALTER TABLE ad_banner_banners ADD COLUMN metadata jsonb NOT NULL DEFAULT '{}'::jsonb;
CREATE INDEX index_ad_banner_banners_on_metadata ON ad_banner_banners USING gin (metadata);
```

## survey_attachmentsテーブルにmetadataカラム追加

```
ALTER TABLE survey_attachments ADD COLUMN metadata jsonb NOT NULL DEFAULT '{}'::jsonb;
CREATE INDEX index_survey_attachments_on_metadata ON survey_attachments USING gin (metadata);
```

## cms_nodesテーブルにsitemap_xml_stateカラム追加

```
ALTER TABLE cms_nodes ADD COLUMN sitemap_xml_state text;
```

## gp_calendar_holiday_categoriesテーブルにclass_attributeカラム追加

```
ALTER TABLE gp_calendar_holiday_categories ADD COLUMN sitemap_xml_state character varying;
```

# Slony同期対象外のテーブルに関する変更

## gp_article_bktemplatesテーブル追加

```
CREATE TABLE gp_article_bktemplates (
    id integer NOT NULL,
    content_id integer,
    state text,
    title text,
    sort_no integer,
    serial_no integer,
    default_flag boolean DEFAULT false NOT NULL,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);
CREATE INDEX index_gp_article_bktemplates_on_content_id ON gp_article_bktemplates USING btree (content_id);
```

## bkeditor_sample_templatesテーブル追加

```
CREATE TABLE bkeditor_sample_templates (
    id integer NOT NULL,
    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_sample_templates_on_site_id ON bkeditor_sample_templates USING btree (site_id);
```

## bkeditor_samplesテーブルのテーブル名をbkeditor_sample_docsに変更

```
ALTER TABLE bkeditor_samples RENAME TO bkeditor_sample_docs;
```

## bkeditor_sample_docsテーブルにtemplate_idカラム追加

```
ALTER TABLE gp_article_docs ADD COLUMN template_id INTEGER;
CREATE INDEX index_bkeditor_sample_docs_on_template_id ON bkeditor_sample_docs USING btree (template_id);
```