DROP DATABASE IF EXISTS `test011`;
CREATE DATABASE `test011`;
USE `test011`;

--
-- Host: localhost    Database: test
-- ------------------------------------------------------


--
-- Table structure for table `test011`
--

CREATE TABLE `test011` (
  `id` int(11) NOT NULL,
  `hash` char(32) CHARACTER SET ascii COLLATE ascii_bin GENERATED ALWAYS AS (md5(`id`)) STORED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `test011`
--

INSERT INTO `test011` (`id`) VALUES (159413),(294775);

