Installation guide
Asset download
CREATE TABLE IF NOT EXISTS `gen_case_codes` ( `code` varchar(50) NOT NULL, `points` int(11) NOT NULL DEFAULT 0, `used` int(11) DEFAULT 0, `usedby` varchar(50) NOT NULL, PRIMARY KEY (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE IF NOT EXISTS `gen_case_recents` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `identifier` varchar(46) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `itemname` varchar(255) DEFAULT NULL, `itemimage` longtext DEFAULT NULL, `itemstate` varchar(255) DEFAULT NULL, `itemprice` int(255) DEFAULT NULL, `unix` bigint(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; CREATE TABLE IF NOT EXISTS `gen_case_users` ( `identifier` varchar(46) NOT NULL, `name` varchar(255) DEFAULT NULL, `points` int(11) DEFAULT NULL, `tasks` longtext DEFAULT '[]', `freeusedtime` bigint(255) DEFAULT 0, PRIMARY KEY (`identifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Last updated
