CREATE TABLE `mod_emailverification_cemails` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `mod_emailverification_cemails`
ADD PRIMARY KEY (`id`);
ALTER TABLE `mod_emailverification_cemails`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;
CREATE TABLE `ws_emailtwofa` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(10) UNSIGNED NOT NULL,
`subuserid` int(11) NOT NULL DEFAULT '0',
`type` text COLLATE utf8_unicode_ci,
`status` text COLLATE utf8_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `ws_emailverification_bans` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) NOT NULL,
`type` text COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci NOT NULL,
`relid` text COLLATE utf8_unicode_ci,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `ws_emailverification_subs` (
`id` int(10) UNSIGNED NOT NULL,
`userid` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `ws_emailtwofa`
ADD PRIMARY KEY (`id`);
ALTER TABLE `ws_emailverification_bans`
ADD PRIMARY KEY (`id`);
ALTER TABLE `ws_emailverification_subs`
ADD PRIMARY KEY (`id`);
ALTER TABLE `ws_emailtwofa`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ws_emailverification_bans`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ws_emailverification_subs`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;