■Slony同期対象のテーブルに関する変更
--------------------------------------
## gp_article_docsテーブルへfile_href,organization_stateカラム追加

ALTER TABLE gp_article_docs ADD COLUMN file_href varchar;
ALTER TABLE gp_article_docs ADD COLUMN organization_state varchar;

## cms_site_urisテーブル追加

CREATE TABLE cms_site_uris (
    id serial,
    site_id integer,
    full_uri text,
    uri_type varchar,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);
CREATE INDEX index_cms_site_uris_on_site_id ON cms_site_uris USING btree (site_id);


## gp_category_categorizationsテーブルへis_approved,approved_atカラム追加

ALTER TABLE gp_category_categorizations ADD COLUMN is_approved BOOLEAN DEFAULT FALSE;
ALTER TABLE gp_category_categorizations ADD COLUMN approved_at timestamp without time zone;

## gp_template_itemsテーブルへform_text_max_length,description,lower_description,default_valueカラム追加

ALTER TABLE gp_category_categorizations ADD COLUMN form_text_max_length integer;
ALTER TABLE gp_category_categorizations ADD COLUMN adescription text;
ALTER TABLE gp_category_categorizations ADD COLUMN lower_description text;
ALTER TABLE gp_category_categorizations ADD COLUMN default_value text;

## organization_groupsテーブルへdocs_number,layerカラム追加

ALTER TABLE organization_groups ADD COLUMN docs_number integer;
ALTER TABLE organization_groups ADD COLUMN layer varchar;

## organization_reorg_groupsテーブルへdocs_number,layerカラム追加

ALTER TABLE organization_reorg_groups ADD COLUMN docs_number integer;
ALTER TABLE organization_reorg_groups ADD COLUMN layer varchar;

## survey_questionsテーブルへplaceholder,source_question_id,source_optionカラム追加

ALTER TABLE survey_questions ADD COLUMN placeholder text;
ALTER TABLE survey_questions ADD COLUMN source_question_id integer;
ALTER TABLE survey_questions ADD COLUMN source_option text;

## rank_ranksテーブルからvisitorsカラム削除

ALTER TABLE rank_ranks DROP COLUMN visitors;

## rank_totalsテーブルからvisitorsカラム削除

ALTER TABLE rank_totals DROP COLUMN visitors;

## cms_linksテーブルへtag_nameカラム追加

ALTER TABLE cms_links ADD COLUMN tag_name text;

## cms_stylesheetsテーブルを削除後、再作成

drop table cms_stylesheets;
CREATE TABLE cms_stylesheets (
    id serial,
    site_id bigint,
    concept_id bigint,
    parent_id bigint,
    state text,
    name varchar,
    body text,
    mime_type text,
    directory integer,
    size integer,
    serial_no integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);
CREATE INDEX index_cms_stylesheets_on_concept_id ON cms_stylesheets USING btree (concept_id);
CREATE INDEX index_cms_stylesheets_on_parent_id ON cms_stylesheets USING btree (parent_id);
CREATE INDEX index_cms_stylesheets_on_site_id ON cms_stylesheets USING btree (site_id);

## cms_sitesテーブルからfull_uriカラム削除

ALTER TABLE cms_sites DROP COLUMN full_uri;

## sys_storage_filesテーブルにインデックスを追加

CREATE INDEX index_sys_storage_files_on_site_id_and_directory ON sys_storage_files USING btree (site_id, directory);



■Slony同期対象外のテーブルに関する変更
--------------------------------------
## approval_approval_flow_targetsテーブル追加

CREATE TABLE approval_approval_flow_targets (
    id serial,
    approval_flow_id bigint,
    target_type varchar,
    target_content_id bigint,
    category_id bigint,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);
CREATE INDEX index_approval_approval_flow_targets_on_approval_flow_id ON approval_approval_flow_targets USING btree (approval_flow_id);
CREATE INDEX index_approval_approval_flow_targets_on_category_id ON approval_approval_flow_targets USING btree (category_id);
CREATE INDEX index_approval_approval_flow_targets_on_target_content_id ON approval_approval_flow_targets USING btree (target_content_id);


## approval_approval_flowsテーブルへlayer,publish_priorityカラム追加

ALTER TABLE approval_approval_flows ADD COLUMN layer varchar;
ALTER TABLE approval_approval_flows ADD COLUMN publish_priority varchar;

## approval_approval_requestsテーブルへlayer,publish_priorityカラム追加

ALTER TABLE approval_approval_requests ADD COLUMN target varchar;
ALTER TABLE approval_approval_requests ADD COLUMN targetable_id integer;
CREATE INDEX index_approval_approval_requests_on_targetable_type_and_id ON approval_approval_requests USING btree (targetable_type, targetable_id);

# テーブル名をcms_publicationsからcms_publicatorsに変更

ATER TABLE cms_publications RENAME TO cms_publicators;

## mailin_filtersテーブルへinclude_bcctカラム追加

ALTER TABLE mailin_filters ADD COLUMN include_bcc BOOLEAN;
ALTER TABLE mailin_filters ADD COLUMN from_address varchar;

## sys_login_logsテーブルへrequest_uri,x_forwarded_forカラム追加

ALTER TABLE sys_login_logs ADD COLUMN request_uri varchar;
ALTER TABLE sys_login_logs ADD COLUMN x_forwarded_for varchar;

## sys_recognitionsテーブルへcommentカラム追加

ALTER TABLE sys_recognitions ADD COLUMN comment text;