更新时间戳SQL.sql 1.1 KB

1234567891011121314
  1. ALTER TABLE `dcp`.`meeting_basic_info`
  2. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by` WHERE meeting_is_enroll = '02';
  3. ALTER TABLE `dcp`.`cms_information_view`
  4. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;
  5. ALTER TABLE `dcp`.`base_unit_view`
  6. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;
  7. ALTER TABLE `dcp`.`activity_info`
  8. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;
  9. ALTER TABLE `dcp`.`info_journal_view`
  10. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;
  11. ALTER TABLE `dcp`.`base_country_view`
  12. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;
  13. ALTER TABLE `dcp`.`base_project_info`
  14. MODIFY COLUMN `update_date` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间' AFTER `update_by`;