CREATE TABLE `htmlcontent` (
  `id` INTEGER NOT NULL AUTO_INCREMENT UNIQUE,
  `guid` CHAR(36) NOT NULL,
  `cdate` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `cuser` CHAR(32) NOT NULL,
  `lang` char(8) DEFAULT NULL ,
  `name` varchar(128) DEFAULT NULL ,
  `machinename` varchar(128) DEFAULT NULL ,
  `contentfile` varchar(128) DEFAULT NULL ,
  `author` varchar(64) DEFAULT NULL ,
  `created` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `published` boolean DEFAULT 0,
  `params` text DEFAULT NULL ,
  `seq` int DEFAULT NULL ,

  PRIMARY KEY (id) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
