· 7 years ago · Jan 03, 2019, 08:30 AM
1CREATE TABLE IF NOT EXISTS `{PREFIX}_affiliatereferrers` (
2 `user_id` bigint(20) DEFAULT NULL,
3 `period` varchar(6) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
4 `url` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
5 `referred` bigint(20) DEFAULT '0',
6 UNIQUE KEY `user_period_url` (`user_id`,`period`),
7 KEY `user_id` (`user_id`),
8 KEY `period` (`period`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;