Advertisement
NokitaKaze

Untitled

Sep 30th, 2014
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.37 KB | None | 0 0
  1. CREATE TABLE `debug_out` (
  2.   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  3.   `url` text COLLATE utf8_unicode_ci NOT NULL,
  4.   `post_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  5.   `send` longtext COLLATE utf8_unicode_ci NOT NULL,
  6.   `time` BIGINT(20) UNSIGNED NOT NULL,
  7.   `duration` FLOAT NOT NULL,
  8.   `ip` INT(10) UNSIGNED NOT NULL,
  9.   PRIMARY KEY (`id`),
  10.   KEY `part_of_url` (`url`(13)),
  11.   KEY `time` (`time`)
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  13. CREATE TABLE `debug_sql` (
  14.   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  15.   `request_id` BIGINT(20) UNSIGNED NOT NULL,
  16.   `time` BIGINT(20) UNSIGNED NOT NULL,
  17.   `duration` FLOAT NOT NULL,
  18.   `sql` text COLLATE utf8_unicode_ci NOT NULL,
  19.   PRIMARY KEY (`id`),
  20.   KEY `request_id` (`request_id`),
  21.   CONSTRAINT `debug_sql_ibfk_1` FOREIGN KEY (`request_id`) REFERENCES `debug_out` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  22. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  23.  
  24. CREATE TABLE `debug_sql_error` (
  25.   `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  26.   `sql_id` BIGINT(20) UNSIGNED NOT NULL,
  27.   `text` text COLLATE utf8_unicode_ci NOT NULL,
  28.   PRIMARY KEY (`id`),
  29.   KEY `sql_id` (`sql_id`),
  30.   CONSTRAINT `debug_sql_error_ibfk_1` FOREIGN KEY (`sql_id`) REFERENCES `debug_sql` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  31. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement