点击量后台都看不到了 - JEECMS官方论坛|开源java cms,jsp cms,jsp bbs

tyroka

级别: 贡士

UID: 75689
积分:554 加为好友
威望: 4 精华: 0
主题:43 回复:272
注册时间:2015-05-19
在线时长:0

41# 发表于:2019-08-15 16:20:20 IP:61.165.*.*

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

USE `xyxww_v9`;
/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerCommentDelete` AFTER DELETE ON `jc_comment`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value-1 where attr_name="commentTotal" and site_id=old.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerCommentInsert` AFTER INSERT ON `jc_comment`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value+1 where attr_name="commentTotal" and site_id=new.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerContentDelete` AFTER DELETE ON `jc_content`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value-1 where attr_name="contentTotal" and site_id=old.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerContentInsert` AFTER INSERT ON `jc_content`
    FOR EACH ROW     update jc_site_attr set attr_value=attr_value+1 where attr_name="contentTotal" and site_id=new.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerGuestbookDelete` AFTER DELETE ON `jc_guestbook`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value-1 where attr_name="guestbookTotal" and site_id=old.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerGuestbookInsert` AFTER INSERT ON `jc_guestbook`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value+1 where attr_name="guestbookTotal" and site_id=new.site_id;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerMemberDelete` AFTER DELETE ON `jc_user`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value-1 where attr_name="memberTotal" and site_id=1 and old.is_admin=0;
$$
DELIMITER ;

/* Create Trigger in target */

DELIMITER $$
CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `triggerMemberInsert` AFTER INSERT ON `jc_user`
    FOR EACH ROW    update jc_site_attr set attr_value=attr_value+1 where attr_name="memberTotal" and site_id=1 and new.is_admin=0;
$$
DELIMITER ;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

这个有影响不

来自v9.3商业授权版的问题，~