mirror of https://github.com/certd/certd
18 lines
583 B
SQL
18 lines
583 B
SQL
ALTER TABLE cd_site_info ADD COLUMN `remark` varchar(512);
|
|
|
|
CREATE TABLE `cd_group`
|
|
(
|
|
`id` bigint PRIMARY KEY AUTO_INCREMENT 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;
|