github.com/pingcap/br@v5.3.0-alpha.0.20220125034240-ec59c7b6ce30+incompatible/tests/lightning_tool_241/data/qyjc.q_report_circular_data-schema.sql (about)

     1  CREATE TABLE `q_report_circular_data` (
     2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     3  `group_id` int(11) unsigned NOT NULL DEFAULT '0',
     4  `handle_longest` varchar(255) NOT NULL DEFAULT '',
     5  `respond_longest` varchar(255) NOT NULL DEFAULT '',
     6  `circular_more` varchar(255) NOT NULL DEFAULT '',
     7  `circular_count` int(11) unsigned NOT NULL DEFAULT '0',
     8  `iscount_count` int(11) unsigned NOT NULL DEFAULT '0',
     9  `noman_count` int(11) unsigned NOT NULL DEFAULT '0',
    10  `end_time_avg` int(11) unsigned NOT NULL DEFAULT '0',
    11  `respond_time_ave` int(11) unsigned NOT NULL DEFAULT '0',
    12  `day` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    13  PRIMARY KEY (`id`),
    14  KEY `group_id` (`group_id`) USING BTREE,
    15  KEY `day` (`day`) USING BTREE
    16  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;