SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

CREATE TABLE `userdatastats` (
`idu` int(11) NOT NULL,
`steamid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`steamname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`skin` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`loadout` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`firstname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`lastname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dateofbirth` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dateandtime` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `taskstats` (
`id` int(11) NOT NULL,
`idfromuser` int(11) NOT NULL,
`task01` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task02` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task03` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task04` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task05` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task06` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task07` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task08` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task09` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task10` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task11` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`task12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


ALTER TABLE `userdatastats`
    ADD PRIMARY KEY (`idu`);

ALTER TABLE `taskstats`
    ADD PRIMARY KEY (`id`);

ALTER TABLE `taskstats`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

ALTER TABLE `userdatastats`
    MODIFY `idu` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

