NokitaKaze icon

Untitled

NokitaKaze | PRO | 09/30/14 12:07:56 PM UTC | 0 ⭐ | 450 👁️ | Never ⏰ | []
SQL |

1.37 KB

|

None

|

0 👍

/

0 👎

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