DROP TABLE IF EXISTS "sip_sip"."history_abroad2telecom_ip_data";
CREATE TABLE "sip_sip"."history_abroad2telecom_ip_data" (
"id" bigserial not null,
"sip_ip" varchar(32) COLLATE "default",
"dip_ip" varchar(32) COLLATE "default",
"to_info" varchar(128) COLLATE "default",
"r_time" TEXT DEFAULT to_char(CURRENT_TIMESTAMP,'YYYYMMDD')
)
bigserial 是实现ID自增 TEXT 实现当前时间日期。