CREATE TABLE IF NOT EXISTS `include_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 `include_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 `include_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;
Add ensure command to your server cfg file. Its important that it comes after your framework script!