kTPFkHHy

1CREATE TABLE IF NOT EXISTS `scratch_card_log`( `id` bigint(19) NOT NULL AUTO_INCREMENT, `table_id` int(10) NOT NULL DEFAULT '0', `log_code` tinyint(3) NOT NULL DEFAULT '0', `acc_id` int(10) NOT NULL DEFAULT '0', `account` varchar(32) DEFAULT NULL, `nickname` varchar(32) DEFAULT NULL, `card` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `price` INT(19) UNSIGNED NOT NULL DEFAULT '0', `award` INT(10) UNSIGNED NOT NULL DEFAULT '0', `multiple` varchar(30) NOT NULL, `errNo` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', `pattern` LONGTEXT NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), INDEX `log_code` (`log_code`) ) ENGINE=InnoDB DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_unicode_ci