Skip to main content

Recriação de tabela Files do Shinobi Docker

ChatGPT:

USE ccio;

DROP TABLE IF EXISTS `Files`;

CREATE TABLE `Files` (
  `ke` varchar(50) NOT NULL,
  `mid` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `size` bigint(20) DEFAULT NULL,
  `details` longtext,
  `status` varchar(20) DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `timeZone` varchar(64) DEFAULT NULL,
  `deleteAfterDays` int(11) DEFAULT NULL,
  `monName` varchar(255) DEFAULT NULL,
  KEY `ke` (`ke`),
  KEY `mid` (`mid`),
  KEY `time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;