[T.P.]

Note for the Developer:

PHP Code:

                $db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_log`(
                                    `date` DATETIME NOT NULL,
                                    `ip` VARCHAR(15) NOT NULL,
                                    `email` VARCHAR(255) NOT NULL,
                                    `username` VARCHAR(255) NOT NULL,
                                    `message` VARCHAR(255) NOT NULL,
                                    `is_blocked` TINYINT NOT NULL DEFAULT "0",
                                    `user_hash` VARCHAR(50) NOT NULL,
                                    `user_id` INT NOT NULL
                                 ) TYPE=MyISAM; ');


                 $db->query_write('CREATE TABLE IF NOT EXISTS `'.TABLE_PREFIX.'glowhostspamomatic_remotecache`(
                                    `date` DATETIME NOT NULL,
                                    `field` VARCHAR(20) NOT NULL,
                                    `is_spambot` INT NOT NULL,
                                    `data` VARCHAR(255) NOT NULL
                                 ) TYPE=MyISAM; '); 


Please use instead only "ENGINE" not TYPE !!!

The older TYPE option was synonymous with ENGINE. TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you must convert existing applications that rely on TYPE to use ENGINE instead.

http://stackoverflow.com/questions/1...le-type-myisam