invite-manager-bot
invite-manager-bot copied to clipboard
Table 'im_1.scheduledactions
Good evening, I would like to know how we put and or the tables in mysql and I try to put them but always the same
(can you provide me screenshoots so that I can understand thank you very much)
https://prnt.sc/v1wlz6
Hope this helps
mysql -u root -p
use im_1;
CREATE TABLE `scheduledActions` (
`id` int(11) NOT NULL,
`actionType` enum('unmute') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`args` json DEFAULT NULL,
`date` datetime DEFAULT NULL,
`reason` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`guildId` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`createdAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
ALTER TABLE `scheduledActions`
ADD PRIMARY KEY (`id`),
ADD KEY `guildId` (`guildId`);
ALTER TABLE `scheduledActions`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;