File indexing completed on 2024-04-21 06:00:36 

0001 
0002 
0003 DROP TABLE IF EXISTS `spam_keywords`;
0004 
0005 CREATE TABLE `spam_keywords`
0006 (
0007     `spam_key_id`         INT         NOT NULL AUTO_INCREMENT,
0008     `spam_key_word`       VARCHAR(45) NOT NULL,
0009     `spam_key_created_at` DATETIME    NULL,
0010     `spam_key_is_deleted` INT(1)      NULL DEFAULT 0,
0011     `spam_key_is_active`  INT(1)      NULL DEFAULT 1,
0012     PRIMARY KEY (`spam_key_id`)
0013 )
0014     ENGINE = InnoDB;
0015 
0016 DROP TRIGGER IF EXISTS `spam_keywords_BEFORE_INSERT`;
0017 
0018 DELIMITER $$
0019 CREATE DEFINER = CURRENT_USER TRIGGER `spam_keywords_BEFORE_INSERT`
0020     BEFORE INSERT
0021     ON `spam_keywords`
0022     FOR EACH ROW
0023 BEGIN
0024     IF `NEW`.`spam_key_created_at` IS NULL THEN
0025         SET `NEW`.`spam_key_created_at` = NOW();
0026     END IF;
0027 END$$
0028 DELIMITER ;
0029 
0030 
0031 INSERT INTO `spam_keywords` (`spam_key_word`)
0032 VALUES ('keto');
0033 INSERT INTO `spam_keywords` (`spam_key_word`)
0034 VALUES ('spartan');
0035 INSERT INTO `spam_keywords` (`spam_key_word`)
0036 VALUES ('ingredient');
0037 INSERT INTO `spam_keywords` (`spam_key_word`)
0038 VALUES ('rdx surge');
0039 INSERT INTO `spam_keywords` (`spam_key_word`)
0040 VALUES ('vashikaran');
0041 INSERT INTO `spam_keywords` (`spam_key_word`)
0042 VALUES ('muscles');
0043 INSERT INTO `spam_keywords` (`spam_key_word`)
0044 VALUES ('viagra');
0045 INSERT INTO `spam_keywords` (`spam_key_word`)
0046 VALUES ('s3xual');
0047 INSERT INTO `spam_keywords` (`spam_key_word`)
0048 VALUES ('erection');
0049 INSERT INTO `spam_keywords` (`spam_key_word`)
0050 VALUES ('praltrix');
0051 INSERT INTO `spam_keywords` (`spam_key_word`)
0052 VALUES ('s3x');
0053 INSERT INTO `spam_keywords` (`spam_key_word`)
0054 VALUES ('herpes');
0055 INSERT INTO `spam_keywords` (`spam_key_word`)
0056 VALUES ('male enhancement');
0057 INSERT INTO `spam_keywords` (`spam_key_word`)
0058 VALUES ('astrology');
0059 INSERT INTO `spam_keywords` (`spam_key_word`)
0060 VALUES ('megashare');
0061 INSERT INTO `spam_keywords` (`spam_key_word`)
0062 VALUES ('body weight');
0063 INSERT INTO `spam_keywords` (`spam_key_word`)
0064 VALUES ('diet');
0065 INSERT INTO `spam_keywords` (`spam_key_word`)
0066 VALUES ('foreskin');
0067 INSERT INTO `spam_keywords` (`spam_key_word`)
0068 VALUES ('fat loss');
0069 INSERT INTO `spam_keywords` (`spam_key_word`)
0070 VALUES ('cream');
0071 INSERT INTO `spam_keywords` (`spam_key_word`)
0072 VALUES ('healthy');