diff options
Diffstat (limited to 'mysql.dmp')
-rwxr-xr-x | mysql.dmp | 12 |
1 files changed, 12 insertions, 0 deletions
@@ -41,6 +41,18 @@ CREATE TABLE IF NOT EXISTS `users` ( KEY `federationId` (`federationId`(191)) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +DROP TABLE IF EXISTS `toVerify`; +CREATE TABLE IF NOT EXISTS `toVerify` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `userId` int(11) NOT NULL, + `storeId` int(11) NOT NULL, + `property` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `tries` int(11) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + + /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |