diff options
| author | shizhendong <[email protected]> | 2021-04-07 16:58:08 +0800 |
|---|---|---|
| committer | shizhendong <[email protected]> | 2021-04-07 16:58:08 +0800 |
| commit | d65dd262167d06ec838009ad694ef52760a8b984 (patch) | |
| tree | a34d601d851da1914ed7b168c31169ba08e68ec9 /nz-admin/db/2020-05-06.sql | |
| parent | 82503bb72ce5d35c51d3b1dbe54f3dc9810924c7 (diff) | |
remove: 移除无用文件develop
Diffstat (limited to 'nz-admin/db/2020-05-06.sql')
| -rw-r--r-- | nz-admin/db/2020-05-06.sql | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/nz-admin/db/2020-05-06.sql b/nz-admin/db/2020-05-06.sql deleted file mode 100644 index 276e2b79..00000000 --- a/nz-admin/db/2020-05-06.sql +++ /dev/null @@ -1,51 +0,0 @@ -/* - alert_rule表结构变更 - 1. 结构变更字段如下: receiver - - conf_event表新增traffic数据 - - idc_traffic表增加 insert,update,delete 触发器,修改 conf_event 表 value值加一 -*/ - - --- 结构变更 -alter table alert_rule modify column receiver varchar(64); - --- conf_event 新增数据 -INSERT INTO `conf_event` VALUES ('idc_traffic', 0); - - --- idc_traffic表新增 insert,update,delete 触发器 - --- ---------------------------- --- Triggers structure for table idc_traffic --- ---------------------------- -DROP TRIGGER IF EXISTS `tri_idc_traffic_insert`; -delimiter ;; -CREATE TRIGGER `tri_idc_traffic_insert` AFTER INSERT ON `idc_traffic` FOR EACH ROW begin - update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic'; -end -;; -delimiter ; - --- ---------------------------- --- Triggers structure for table idc_traffic --- ---------------------------- -DROP TRIGGER IF EXISTS `tri_idc_traffic_update`; -delimiter ;; -CREATE TRIGGER `tri_idc_traffic_update` AFTER UPDATE ON `idc_traffic` FOR EACH ROW begin - update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic'; -end -;; -delimiter ; - --- ---------------------------- --- Triggers structure for table idc_traffic --- ---------------------------- -DROP TRIGGER IF EXISTS `tri_idc_traffic_delete`; -delimiter ;; -CREATE TRIGGER `tri_idc_traffic_delete` AFTER DELETE ON `idc_traffic` FOR EACH ROW begin - update conf_event t set t.value = t.value +1 where t.table = 'idc_traffic'; -end -;; -delimiter ;
\ No newline at end of file |
