SideProjectGuys / invite-manager-bot

A discord bot that tracks invites and much more
https://docs.invitemanager.co/
GNU General Public License v3.0
165 stars 135 forks source link

Table 'im_1.scheduledactions #186

Open JustMarcoQLF opened 3 years ago

JustMarcoQLF commented 3 years ago

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

SyntaxDragon commented 3 years ago

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;