Guest User

Untitled

a guest
Sep 5th, 2021
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.68 KB | None | 0 0
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET AUTOCOMMIT = 0;
  3. START TRANSACTION;
  4. SET time_zone = "+00:00";
  5.  
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8mb4 */;
  11.  
  12. --
  13. -- Database: `DATABASE NAME CHANGEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE ME`
  14. --
  15.  
  16. -- --------------------------------------------------------
  17.  
  18. --
  19. -- Tabelstructuur voor tabel `KillRecords`
  20. --
  21.  
  22. CREATE TABLE `KillRecords` (
  23.   `Pcorpse` VARCHAR(255) DEFAULT NULL,
  24.   `Chicken` VARCHAR(255) DEFAULT NULL,
  25.   `Boar` VARCHAR(255) DEFAULT NULL,
  26.   `Stag` VARCHAR(255) DEFAULT NULL,
  27.   `Wolf` VARCHAR(255) DEFAULT NULL,
  28.   `Bear` INT(100) DEFAULT NULL,
  29.   `Scientist` VARCHAR(255) DEFAULT NULL,
  30.   `TunnelDweller` VARCHAR(255) DEFAULT NULL,
  31.   `LootContainer` VARCHAR(255) NOT NULL,
  32.   `Deaths` VARCHAR(255) DEFAULT NULL,
  33.   `steamid` VARCHAR(255) NOT NULL,
  34.   `Name` VARCHAR(255) DEFAULT NULL,
  35.   `Player` VARCHAR(255) NOT NULL,
  36.   `Corpse` VARCHAR(255) DEFAULT NULL,
  37.   `Shark` VARCHAR(255) NOT NULL,
  38.   `Dweller` VARCHAR(255) NOT NULL,
  39.   `UnderwaterLoot` VARCHAR(255) DEFAULT NULL,
  40.   `BradHeliCrate` VARCHAR(255) DEFAULT NULL,
  41.   `HackableCrate` VARCHAR(255) DEFAULT NULL,
  42.   `Suicides` VARCHAR(255) NOT NULL
  43. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  44.  
  45.  
  46. --
  47. -- Indexen voor tabel `KillRecords`
  48. --
  49. ALTER TABLE `KillRecords`
  50.   ADD UNIQUE KEY `steamid` (`Name`);
  51. COMMIT;
  52.  
  53. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  54. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  55. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  56.  
Advertisement
Add Comment
Please, Sign In to add comment