CREATE TABLE `my_table` (
  `e_uid` int(11) NOT NULL AUTO_INCREMENT,
  `field_a` varchar(200) NOT NULL,
  `w_uid` int(7) unsigned zerofill NOT NULL,
  `field_b` varchar(30) DEFAULT NULL,
  `field_c` int(11) DEFAULT NULL,
  `field_d` varchar(200) NOT NULL,
  `field_e` varchar(200) DEFAULT NULL,
  `field_f` varchar(200) DEFAULT NULL,
  `field_g` varchar(200) DEFAULT NULL,
  `field_h` varchar(40) NOT NULL DEFAULT 'CHANGED',
  `field_i` varchar(40) NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `type` varchar(100) NOT NULL,
  `enum` varchar(100) NOT NULL,
  `info` varchar(500) DEFAULT NULL,
  `ordernum` int(11) NOT NULL DEFAULT 99999,
  `cr_date` datetime NOT NULL DEFAULT current_timestamp(),
  `upd_date` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `cr_user` varchar(50) NOT NULL DEFAULT 'myuser',
  `upd_user` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`e_uid`),
  KEY `field_c` (`field_c`),
  KEY `ordernum_e_uid` (`ordernum`,`e_uid`),
  KEY `w_uid_ordernum` (`w_uid`,`ordernum`),
  KEY `field_a` (`field_a`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
