plugins/logs/share/db/sql/sys_log_csrf_errors.sql.php

Summary

Maintainability
A
0 mins
Test Coverage
<?php

return '
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `ip` varchar(16) NOT NULL DEFAULT \'\',
  `url` varchar(1024) NOT NULL DEFAULT \'\',
  `form_id` varchar(255) NOT NULL DEFAULT \'\',
  `ua` varchar(255) NOT NULL DEFAULT \'\',
  `referer` varchar(1024) NOT NULL DEFAULT \'\',
  `object` varchar(255) NOT NULL DEFAULT \'\',
  `action` varchar(255) NOT NULL DEFAULT \'\',
  `user_id` int(10) unsigned NOT NULL DEFAULT \'0\',
  `user_group` tinyint(3) unsigned NOT NULL DEFAULT \'0\',
  `site_id` tinyint(3) unsigned NOT NULL DEFAULT \'0\',
  `server_id` tinyint(3) unsigned NOT NULL DEFAULT \'0\',
  `is_admin` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_common_page` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_https` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_post` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_no_graphics` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_ajax` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_spider` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_redirect` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_console` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_unit_test` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_debug` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_banned` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_403` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_404` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_503` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_cache_on` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `is_mobile` tinyint(1) unsigned NOT NULL DEFAULT \'0\',
  `lang` char(2) NOT NULL DEFAULT \'\',
  `country` char(2) NOT NULL DEFAULT \'\',
  `utm_source` varchar(255) NOT NULL DEFAULT \'\',
  `post_data` text NOT NULL,
  `trace` varchar(1024) NOT NULL DEFAULT \'\',
  `memory` int(10) unsigned NOT NULL DEFAULT \'0\',
  `exec_time` float unsigned NOT NULL DEFAULT \'0\',
  `num_dbq` smallint(5) unsigned NOT NULL DEFAULT \'0\',
  `page_size` int(10) unsigned NOT NULL DEFAULT \'0\',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `ip` (`ip`),
  KEY `date` (`date`)
';