static function createReadTableIfNotExist($table_name_prefix) { global $mysqli; if (!parent::tableExistByName($table_name_prefix . '_read')) { return $mysqli->query("\r\nCREATE TABLE IF NOT EXISTS `" . $table_name_prefix . "_read` (\r\n `id` INT NOT NULL AUTO_INCREMENT ,\r\n `article_id` INT ,\r\n `user_wechat_account_id` INT ,\r\n PRIMARY KEY (`id`)\r\n ,\r\nINDEX `fk-" . $table_name_prefix . "_read-article_id-idx` (`article_id` ASC),\r\nCONSTRAINT `fk-" . $table_name_prefix . "_read-article_id`\r\n FOREIGN KEY (`article_id`)\r\n REFERENCES `wechat_article` (`id`)\r\n ON DELETE CASCADE\r\n ON UPDATE CASCADE ,\r\nINDEX `fk-" . $table_name_prefix . "_read-user_wechat_account_id-idx` (`user_wechat_account_id` ASC),\r\nCONSTRAINT `fk-" . $table_name_prefix . "_read-user_wechat_account_id`\r\n FOREIGN KEY (`user_wechat_account_id`)\r\n REFERENCES `" . $table_name_prefix . "_account` (`id`)\r\n ON DELETE CASCADE\r\n ON UPDATE CASCADE)\r\nENGINE = InnoDB\r\nDEFAULT CHARACTER SET = utf8\r\nCOLLATE = utf8_general_ci;\r\n"); } }