[sql] a
Viewer
- CREATE TABLE `Dota2Users` (
- `ID` INT NOT NULL AUTO_INCREMENT,
- `user_id32` BIGINT(255) NOT NULL,
- `user_id64` BIGINT(255) NOT NULL,
- `user_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
- `user_avatar` VARCHAR(255) DEFAULT NULL,
- `lvl_user` VARCHAR(255) NOT NULL,
- `soul_user_in_game_user` VARCHAR(255) DEFAULT NULL,
- `liberum_ingenium_puncta_user` VARCHAR(255) DEFAULT NULL,
- `attributum_puncta_user` VARCHAR(255) DEFAULT NULL,
- `strength_user` VARCHAR(255) NOT NULL,
- `agility_user` VARCHAR(255) NOT NULL,
- `intelligence_user` VARCHAR(255) NOT NULL,
- `equipment_on_the_user` LONGTEXT DEFAULT NULL,
- `user_inventory` LONGTEXT DEFAULT NULL,
- `user_warehouse` LONGTEXT DEFAULT NULL,
- `user_location` TEXT NOT NULL,
- `user_coordinates` VARCHAR NOT NULL,
- `user_achievements` LONGTEXT DEFAULT NULL,
- `user_gold` VARCHAR(255) DEFAULT NULL,
- `user_gold_warehouse` VARCHAR(255) DEFAULT NULL,
- `user_donation_currency` VARCHAR(255) DEFAULT NULL,
- `door` LONGTEXT NOT NULL,
- `caches` LONGTEXT NOT NULL,
- `donat_cosmetics` LONGTEXT DEFAULT NULL,
- `donat_sammons` LONGTEXT DEFAULT NULL,
- `donat_weapons` LONGTEXT DEFAULT NULL,
- `gems_inside_forge` LONGTEXT DEFAULT NULL,
- `plot_tasks` LONGTEXT NOT NULL,
- `presence_aganim` VARCHAR(255) DEFAULT NULL,
- `presence_aganim_shard` VARCHAR(255) DEFAULT NULL,
- `battle_pass` VARCHAR(255) DEFAULT NULL,
- `battle_pass_lvl` VARCHAR(255) DEFAULT NULL,
- `battle_pass_nagrada` LONGTEXT DEFAULT NULL,
- PRIMARY KEY (`ID`,`user_id32`,`user_id64`)
- );
Editor
You can edit this paste and save as new: