eAWW0Xuc

1--
2-- Table structure for table `column_stats`
3--
4
5DROP TABLE IF EXISTS `column_stats`;
6/*!40101 SET @saved_cs_client     = @@character_set_client */;
7/*!40101 SET character_set_client = utf8 */;
8CREATE TABLE `column_stats` (
9  `db_name` varchar(64) COLLATE utf8_bin NOT NULL,
10  `table_name` varchar(64) COLLATE utf8_bin NOT NULL,
11  `column_name` varchar(64) COLLATE utf8_bin NOT NULL,
12  `min_value` varbinary(255) DEFAULT NULL,
13  `max_value` varbinary(255) DEFAULT NULL,
14  `nulls_ratio` decimal(12,4) DEFAULT NULL,
15  `avg_length` decimal(12,4) DEFAULT NULL,
16  `avg_frequency` decimal(12,4) DEFAULT NULL,
17  `hist_size` tinyint(3) unsigned DEFAULT NULL,
18  `hist_type` enum('SINGLE_PREC_HB','DOUBLE_PREC_HB') COLLATE utf8_bin DEFAULT NULL,
19  `histogram` varbinary(255) DEFAULT NULL,
20  PRIMARY KEY (`db_name`,`table_name`,`column_name`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Statistics on Columns';
22/*!40101 SET character_set_client = @saved_cs_client */;
23
24--
25-- Dumping data for table `column_stats`
26--