ALTER TABLE cd_site_info ADD COLUMN "remark" varchar(512);

CREATE TABLE "cd_group"
(
  "id"          bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY NOT NULL,
  "user_id"     bigint      NOT NULL,
  "name"        varchar(100) NOT NULL,
  "icon"        varchar(100),
  "favorite"    boolean      NOT NULL DEFAULT (false),
  "type"        varchar(512),
  "create_time" timestamp     NOT NULL DEFAULT (CURRENT_TIMESTAMP),
  "update_time" timestamp     NOT NULL DEFAULT (CURRENT_TIMESTAMP)
);

ALTER TABLE cd_site_info ADD COLUMN "group_id" bigint;

ALTER TABLE pi_pipeline ADD COLUMN "valid_time" bigint;