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

     1  CREATE TABLE `q_report_desc` (
     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  `vul_count` int(11) unsigned NOT NULL DEFAULT '0',
     6  `hight_num` int(11) unsigned NOT NULL DEFAULT '0',
     7  `mid_num` int(11) unsigned NOT NULL DEFAULT '0',
     8  `low_num` int(11) unsigned NOT NULL DEFAULT '0',
     9  `notice_num` int(11) unsigned NOT NULL DEFAULT '0',
    10  `day` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    11  `time_bucket` tinyint(1) NOT NULL DEFAULT '1',
    12  `created_at` timestamp NULL DEFAULT NULL,
    13  PRIMARY KEY (`id`),
    14  KEY `group_id` (`group_id`) USING BTREE,
    15  KEY `day` (`day`) USING BTREE
    16  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;