Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table 'im_1.scheduledactions #186

Open
JustMarcoQLF opened this issue Oct 18, 2020 · 1 comment
Open

Table 'im_1.scheduledactions #186

JustMarcoQLF opened this issue Oct 18, 2020 · 1 comment

Comments

@JustMarcoQLF
Copy link

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
Copy link

SyntaxDragon commented Dec 26, 2020

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;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants