CREATE TABLE IF NOT EXISTS `weaponstickers1` (
`id` INT NOT NULL AUTO_INCREMENT,
`steamid` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
`weaponindex` int(11) NOT NULL DEFAULT '0',
`slot0` int(11) NOT NULL DEFAULT '0',
`slot1` int(11) NOT NULL DEFAULT '0',
`slot2` int(11) NOT NULL DEFAULT '0',
`slot3` int(11) NOT NULL DEFAULT '0',
`slot4` int(11) NOT NULL DEFAULT '0',
`slot5` int(11) NOT NULL DEFAULT '0',
`wear0` float4 NOT NULL DEFAULT '0.000000',
`wear1` float4 NOT NULL DEFAULT '0.000000',
`wear2` float4 NOT NULL DEFAULT '0.000000',
`wear3` float4 NOT NULL DEFAULT '0.000000',
`wear4` float4 NOT NULL DEFAULT '0.000000',
`wear5` float4 NOT NULL DEFAULT '0.000000',
`rotation0` float4 NOT NULL DEFAULT '0.000',
`rotation1` float4 NOT NULL DEFAULT '0.000',
`rotation2` float4 NOT NULL DEFAULT '0.000',
`rotation3` float4 NOT NULL DEFAULT '0.000',
`rotation4` float4 NOT NULL DEFAULT '0.000',
`rotation5` float4 NOT NULL DEFAULT '0.000',
`last_seen` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY (`steamid`, `weaponindex`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;