SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CREATE TABLE IF NOT EXISTS `single_affiliatereferrers` ( |
| 1 | + | CREATE 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; |
