invite-manager-bot icon indicating copy to clipboard operation
invite-manager-bot copied to clipboard

Table 'im_1.scheduledactions

Open JustMarcoQLF opened this issue 4 years ago • 1 comments

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

JustMarcoQLF avatar Oct 18 '20 21:10 JustMarcoQLF

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;

SyntaxDragon avatar Dec 26 '20 19:12 SyntaxDragon