# Recriação de tabela Files do Shinobi Docker

ChatGPT:

\- Acessar banco de dados do Shinobi em container docker:

<div id="bkmrk-use-ccio%3B">docker exec -ti shinobi_db bash</div><div id="bkmrk-"></div><div id="bkmrk---dentro-do-containe">- Dentro do container docker</div><div id="bkmrk-mysql--uroot--p-blub">**mysql -uroot -p blubsblawoot ccio;**</div><div id="bkmrk---aparecendo-o-promp">  
- Aparecendo o promp  **"MariaDB \[ccio\]&gt;"** , executar os comandos abaixo:  
</div><div id="bkmrk--1"></div><div id="bkmrk-drop-table-if-exists">DROP TABLE IF EXISTS `Files`;</div><div id="bkmrk--2">  
</div><div id="bkmrk-create-table-%60files%60">CREATE TABLE `Files` (</div><div id="bkmrk-%C2%A0-%60ke%60-varchar%2850%29-n"> `ke` varchar(50) NOT NULL,</div><div id="bkmrk-%C2%A0-%60mid%60-varchar%2850%29-"> `mid` varchar(50) NOT NULL,</div><div id="bkmrk-%C2%A0-%60name%60-varchar%28255"> `name` varchar(255) NOT NULL,</div><div id="bkmrk-%C2%A0-%60size%60-bigint%2820%29-"> `size` bigint(20) DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60details%60-longtext"> `details` longtext,</div><div id="bkmrk-%C2%A0-%60status%60-varchar%282"> `status` varchar(20) DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60end%60-datetime-def"> `end` datetime DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60time%60-datetime-de"> `time` datetime DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60timezone%60-varchar"> `timeZone` varchar(64) DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60deleteafterdays%60-"> `deleteAfterDays` int(11) DEFAULT NULL,</div><div id="bkmrk-%C2%A0-%60monname%60-varchar%28"> `monName` varchar(255) DEFAULT NULL,</div><div id="bkmrk-%C2%A0-key-%60ke%60-%28%60ke%60%29%2C"> KEY `ke` (`ke`),</div><div id="bkmrk-%C2%A0-key-%60mid%60-%28%60mid%60%29%2C"> KEY `mid` (`mid`),</div><div id="bkmrk-%C2%A0-key-%60time%60-%28%60time%60"> KEY `time` (`time`)</div><div id="bkmrk-%29-engine%3Dinnodb-defa">) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;</div><div id="bkmrk--3"></div><div id="bkmrk---sair-do-container-">- Sair do container com CTRL+p+q</div><div id="bkmrk--4"></div>