Advertisement
ghenzdeveloper

peepso_mayfly table

Jan 20th, 2023
1,083
1
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.68 KB | Source Code | 1 0
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. START TRANSACTION;
  3. SET time_zone = "+00:00";
  4.  
  5.  
  6. CREATE TABLE `gpv6KtQP_peepso_mayfly` (
  7.   `id` bigint(20) UNSIGNED NOT NULL,
  8.   `created` datetime DEFAULT CURRENT_TIMESTAMP,
  9.   `name` varchar(256) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  10.   `value` mediumtext COLLATE utf8mb4_unicode_520_ci,
  11.   `expires` datetime DEFAULT CURRENT_TIMESTAMP
  12. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
  13.  
  14. ALTER TABLE `gpv6KtQP_peepso_mayfly`
  15.   ADD PRIMARY KEY (`id`),
  16.   ADD UNIQUE KEY `id` (`id`),
  17.   ADD KEY `name` (`name`);
  18.  
  19. ALTER TABLE `gpv6KtQP_peepso_mayfly`
  20.   MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  21. COMMIT;
  22.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement