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

## ad_banner_groupingsテーブルを作成

```
CREATE TABLE ad_banner_groupings (
id integer NOT NULL,
banner_id integer,
group_id integer,
created_at timestamp without time zone NOT NULL,
updated_at timestamp without time zone NOT NULL
);
CREATE INDEX index_ad_banner_groupings_on_banner_id ON ad_banner_groupings USING btree (banner_id);
CREATE INDEX index_ad_banner_groupings_on_group_id ON ad_banner_groupings USING btree (group_id);
```

## rank_totalsテーブルにINDEX追加

```
CREATE INDEX index_rank_totals_on_content_id_hostname_term_pageviews ON rank_totals USING btree (content_id, hostname, term, pageviews);
```

## survey_questionsテーブルにform_year_minカラムとform_year_maxカラム追加

```
ALTER TABLE survey_questions ADD COLUMN form_year_min integer, ADD COLUMN form_year_max integer;
```

## gp_category_template_modulesテーブルにorganization_content_idカラム追加

```
ALTER TABLE gp_category_template_modules ADD COLUMN organization_content_id integer;
CREATE INDEX index_gp_category_template_modules_on_organization_content_id ON public.gp_category_template_modules USING btree (organization_content_id);
```

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

## survey_form_answersテーブルにanswer_uuidカラム追加

```
ALTER TABLE survey_form_answers ADD COLUMN answer_uuid text;
```

## sys_operation_logsテーブルにcommitカラム追加

```
ALTER TABLE sys_operation_logs ADD COLUMN commit text;
```