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

     1  CREATE TABLE `q_report_summary` (
     2  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
     3  `group_id` int(11) unsigned NOT NULL DEFAULT '0',
     4  `host_count` int(11) unsigned NOT NULL DEFAULT '0',
     5  `circular_count` int(11) unsigned NOT NULL DEFAULT '0',
     6  `active_count` int(11) unsigned NOT NULL DEFAULT '0',
     7  `security_num` int(11) unsigned NOT NULL DEFAULT '0',
     8  `hole_num` int(11) unsigned NOT NULL DEFAULT '0',
     9  `day` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    10  `created_at` timestamp NULL DEFAULT NULL,
    11  PRIMARY KEY (`id`),
    12  KEY `group_id` (`group_id`) USING BTREE,
    13  KEY `day` (`day`) USING BTREE
    14  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;