postgresql 使用alter drop修改表结构.

–修改字段名
ALTER TABLE tbl_template_email RENAME template_language to template_language_code;

–添加字段
ALTER TABLE tbl_template_email ADD COLUMN template_country_code VARCHAR(10);
ALTER TABLE tbl_template_email ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_template_email ADD COLUMN template_attributes VARCHAR(255);

–修改字段名
ALTER TABLE tbl_template_sms RENAME template_language to template_language_code;

–添加字段
ALTER TABLE tbl_template_sms ADD COLUMN template_country_code VARCHAR(10);
ALTER TABLE tbl_template_sms ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_template_sms ADD COLUMN template_attributes VARCHAR(255);

–修改字段名
ALTER TABLE tbl_template_wechat RENAME template_language to template_language_code;

–添加字段
ALTER TABLE tbl_template_wechat ADD COLUMN template_country_code VARCHAR(10);
ALTER TABLE tbl_template_wechat ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_template_wechat ADD COLUMN template_attributes VARCHAR(255);

ALTER TABLE tbl_email_message ADD COLUMN message_contact_id VARCHAR(50);
ALTER TABLE tbl_email_message ADD COLUMN message_communication_id VARCHAR(50);
ALTER TABLE tbl_email_message ADD COLUMN message_country_code VARCHAR(10);
ALTER TABLE tbl_email_message ADD COLUMN message_language_code VARCHAR(10);
ALTER TABLE tbl_email_message ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_email_message ADD COLUMN message_application_name VARCHAR(30);
ALTER TABLE tbl_email_message ADD COLUMN message_event_date TIMESTAMP(6);
ALTER TABLE tbl_email_message ADD COLUMN message_send_date TIMESTAMP(6);
ALTER TABLE tbl_email_message ADD COLUMN message_communication_value VARCHAR(255);
ALTER TABLE tbl_email_message ADD COLUMN mobile_number VARCHAR(30);
ALTER TABLE tbl_email_message ADD COLUMN email_tracking VARCHAR(30);

ALTER TABLE tbl_email_message DROP COLUMN message_supplier;

ALTER TABLE tbl_sms_message ADD COLUMN message_contact_id VARCHAR(50);
ALTER TABLE tbl_sms_message ADD COLUMN message_communication_id VARCHAR(50);
ALTER TABLE tbl_sms_message ADD COLUMN message_country_code VARCHAR(10);
ALTER TABLE tbl_sms_message ADD COLUMN message_language_code VARCHAR(10);
ALTER TABLE tbl_sms_message ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_sms_message ADD COLUMN message_application_name VARCHAR(30);
ALTER TABLE tbl_sms_message ADD COLUMN message_event_date TIMESTAMP(6);
ALTER TABLE tbl_sms_message ADD COLUMN message_send_date TIMESTAMP(6);
ALTER TABLE tbl_sms_message ADD COLUMN message_communication_value VARCHAR(255);
ALTER TABLE tbl_sms_message ADD COLUMN mobile_number VARCHAR(30);
ALTER TABLE tbl_sms_message ADD COLUMN email_tracking VARCHAR(30);

ALTER TABLE tbl_sms_message DROP COLUMN message_supplier;

ALTER TABLE tbl_wechat_message ADD COLUMN message_contact_id VARCHAR(50);
ALTER TABLE tbl_wechat_message ADD COLUMN message_communication_id VARCHAR(50);
ALTER TABLE tbl_wechat_message ADD COLUMN message_country_code VARCHAR(10);
ALTER TABLE tbl_wechat_message ADD COLUMN message_language_code VARCHAR(10);
ALTER TABLE tbl_wechat_message ADD COLUMN communication_channel VARCHAR(10);
ALTER TABLE tbl_wechat_message ADD COLUMN message_application_name VARCHAR(30);
ALTER TABLE tbl_wechat_message ADD COLUMN message_event_date TIMESTAMP(6);
ALTER TABLE tbl_wechat_message ADD COLUMN message_send_date TIMESTAMP(6);
ALTER TABLE tbl_wechat_message ADD COLUMN message_communication_value VARCHAR(255);
ALTER TABLE tbl_wechat_message ADD COLUMN mobile_number VARCHAR(30);
ALTER TABLE tbl_wechat_message ADD COLUMN email_tracking VARCHAR(30);

ALTER TABLE tbl_wechat_message DROP COLUMN message_supplier;

Event
CREATE INDEX index_tbl_event_type_uuid on tbl_event_type(uuid);
CREATE INDEX index_tbl_event_type_event_code on tbl_event_type(event_code);
CREATE INDEX index_tbl_event_type_system_id on tbl_event_type(system_id);

Email
ALTER TABLE tbl_template_email RENAME event_type_uuid to event_code
ALTER TABLE tbl_template_email RENAME template_content to content
ALTER TABLE tbl_template_email RENAME template_subject to subject
ALTER TABLE tbl_template_email RENAME template_content to content
ALTER TABLE tbl_template_email RENAME template_language_code to language_code
ALTER TABLE tbl_template_email RENAME template_country_code to country_code
ALTER TABLE tbl_template_email RENAME template_attributes to attributes

CREATE INDEX index_tbl_template_email_uuid on tbl_template_email(uuid);
CREATE INDEX index_tbl_template_email_event_code on tbl_template_email(event_code);

Sms
ALTER TABLE tbl_template_sms RENAME event_type_uuid to event_code
ALTER TABLE tbl_template_sms RENAME template_content to content
ALTER TABLE tbl_template_sms RENAME template_country_code to country_code
ALTER TABLE tbl_template_sms RENAME template_language_code to language_code
ALTER TABLE tbl_template_sms RENAME template_attributes to attributes

CREATE INDEX index_tbl_template_sms_uuid on tbl_template_sms(uuid);
CREATE INDEX index_tbl_template_sms_event_code on tbl_template_sms(event_code);

wechat
ALTER TABLE tbl_template_wechat RENAME event_type_uuid to event_code
ALTER TABLE tbl_template_wechat RENAME template_content to content
ALTER TABLE tbl_template_wechat RENAME template_subject to subject
ALTER TABLE tbl_template_wechat RENAME template_content to content
ALTER TABLE tbl_template_wechat RENAME template_language_code to language_code
ALTER TABLE tbl_template_wechat RENAME template_country_code to country_code
ALTER TABLE tbl_template_wechat RENAME template_attributes to attributes

CREATE INDEX index_tbl_template_wechat_uuid on tbl_template_wechat(uuid);
CREATE INDEX index_tbl_template_wechat_event_code on tbl_template_wechat(event_code);

create index  tbl_bb_index  on  tbl_bb(id,name);
DROP INDEX index;

ALTER TABLE tbl_event_type ADD COLUMN sequence_id VARCHAR(30);

ALTER TABLE tbl_event_type ADD COLUMN system_id VARCHAR(30);