CREATE TABLE `debug_out` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `url` text COLLATE utf8_unicode_ci NOT NULL, `post_data` longtext COLLATE utf8_unicode_ci NOT NULL, `send` longtext COLLATE utf8_unicode_ci NOT NULL, `time` BIGINT(20) UNSIGNED NOT NULL, `duration` FLOAT NOT NULL, `ip` INT(10) UNSIGNED NOT NULL, PRIMARY KEY (`id`), KEY `part_of_url` (`url`(13)), KEY `time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `debug_sql` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `request_id` BIGINT(20) UNSIGNED NOT NULL, `time` BIGINT(20) UNSIGNED NOT NULL, `duration` FLOAT NOT NULL, `sql` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `request_id` (`request_id`), CONSTRAINT `debug_sql_ibfk_1` FOREIGN KEY (`request_id`) REFERENCES `debug_out` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; CREATE TABLE `debug_sql_error` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `sql_id` BIGINT(20) UNSIGNED NOT NULL, `text` text COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `sql_id` (`sql_id`), CONSTRAINT `debug_sql_error_ibfk_1` FOREIGN KEY (`sql_id`) REFERENCES `debug_sql` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Comments