abirama62

init_m_log_partner_change_data

May 18th, 2020
244
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --table master log partner change data
  2. CREATE SEQUENCE m_log_partner_change_data_seq
  3.     INCREMENT 1
  4.     MINVALUE 1
  5.     MAXVALUE 9223372036854775807
  6.     START 10
  7. CACHE 1;
  8.  
  9. CREATE TABLE m_log_partner_change_data (
  10.     m_log_partner_change_data_id         bigint NOT NULL DEFAULT nextval('m_log_partner_change_data_seq'),
  11.     tenant_id     bigint DEFAULT '-99',
  12.     partner_id    bigint,
  13.     data_changed_type     character varying(50),
  14.     old_data      character varying(14),
  15.     new_data      character varying(14),
  16.     version bigint NOT NULL,
  17.     create_datetime character varying(14),
  18.     create_user_id bigint,
  19.     update_datetime character varying(14),
  20.     update_user_id bigint,
  21.     CONSTRAINT m_log_partner_change_data_pkey PRIMARY KEY (m_log_partner_change_data_id)
  22. )
  23. WITH (
  24.     OIDS = FALSE
  25. );
RAW Paste Data