Create your Gitee Account
Explore and code with more than 6 million developers,Free private repositories !:)
Sign up
Clone or download
v2_ddl.sql 2.08 KB
Copy Edit Web IDE Raw Blame History
zhangzhen authored 2020-05-31 16:35 . F 绑定服务器错误
ALTER TABLE `goploy`.`group`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`install_trace`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`package`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`project`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`project_server`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`project_user`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`publish_trace`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`server`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`template`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();
ALTER TABLE `goploy`.`user`
DROP COLUMN `create_time`,
DROP COLUMN `update_time`,
DROP COLUMN `last_login_time`,
ADD COLUMN `last_login_time` datetime DEFAULT NULL,
ADD COLUMN `insert_time` datetime NOT NULL DEFAULT now(),
ADD COLUMN `update_time` datetime NOT NULL DEFAULT now();

Comment ( 0 )

Sign in for post a comment