1
0

schema.sql 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.6deb1+deb.cihar.com~xenial.2
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jul 24, 2017 at 08:23 PM
  7. -- Server version: 10.0.29-MariaDB-0ubuntu0.16.04.1
  8. -- PHP Version: 7.0.18-0ubuntu0.16.04.1
  9. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  10. SET time_zone = "+00:00";
  11. --
  12. -- Database: `gobot`
  13. --
  14. CREATE DATABASE IF NOT EXISTS `gobot` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  15. USE `gobot`;
  16. -- --------------------------------------------------------
  17. --
  18. -- Table structure for table `Agents`
  19. --
  20. CREATE TABLE IF NOT EXISTS `Agents` (
  21. `UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  22. `Name` varchar(256) DEFAULT NULL,
  23. `OwnerName` varchar(256) DEFAULT NULL,
  24. `OwnerKey` char(36) DEFAULT '00000000-0000-0000-0000-000000000000',
  25. `Location` varchar(256) DEFAULT NULL,
  26. `Position` varchar(256) DEFAULT NULL,
  27. `Rotation` varchar(256) DEFAULT NULL,
  28. `Velocity` varchar(256) DEFAULT NULL,
  29. `Energy` varchar(256) DEFAULT NULL,
  30. `Money` varchar(256) DEFAULT NULL,
  31. `Happiness` varchar(256) DEFAULT NULL,
  32. `Class` varchar(256) DEFAULT NULL,
  33. `SubType` varchar(256) DEFAULT NULL,
  34. `PermURL` varchar(256) DEFAULT NULL,
  35. `LastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  36. `BestPath` varchar(256) DEFAULT NULL,
  37. `SecondBestPath` varchar(256) DEFAULT NULL,
  38. `CurrentTarget` varchar(256) DEFAULT NULL,
  39. PRIMARY KEY (`UUID`),
  40. UNIQUE KEY `AgentsIndex` (`OwnerKey`)
  41. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  42. -- --------------------------------------------------------
  43. --
  44. -- Table structure for table `Inventory`
  45. --
  46. CREATE TABLE IF NOT EXISTS `Inventory` (
  47. `UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  48. `Name` varchar(256) DEFAULT NULL,
  49. `Type` varchar(256) DEFAULT NULL,
  50. `LastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  51. `Permissions` varchar(256) DEFAULT NULL,
  52. PRIMARY KEY (`UUID`)
  53. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  54. -- --------------------------------------------------------
  55. --
  56. -- Table structure for table `Obstacles`
  57. --
  58. CREATE TABLE IF NOT EXISTS `Obstacles` (
  59. `UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  60. `Name` varchar(256) DEFAULT NULL,
  61. `BotKey` char(36) DEFAULT '00000000-0000-0000-0000-000000000000',
  62. `BotName` varchar(256) DEFAULT NULL,
  63. `Type` int(11) DEFAULT NULL,
  64. `Position` varchar(256) DEFAULT NULL,
  65. `Rotation` varchar(256) DEFAULT NULL,
  66. `Velocity` varchar(256) DEFAULT NULL,
  67. `LastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  68. `Origin` varchar(256) DEFAULT NULL,
  69. `Phantom` int(11) DEFAULT NULL,
  70. `Prims` int(11) DEFAULT NULL,
  71. `BBHi` varchar(256) DEFAULT NULL,
  72. `BBLo` varchar(256) DEFAULT NULL,
  73. PRIMARY KEY (`UUID`),
  74. KEY `PositionIndex` (`Position`(255))
  75. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  76. -- --------------------------------------------------------
  77. --
  78. -- Table structure for table `Positions`
  79. --
  80. CREATE TABLE IF NOT EXISTS `Positions` (
  81. `PermURL` varchar(256) DEFAULT NULL,
  82. `UUID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000',
  83. `Name` varchar(256) DEFAULT NULL,
  84. `OwnerName` varchar(256) DEFAULT NULL,
  85. `Location` varchar(256) DEFAULT NULL,
  86. `Position` varchar(256) DEFAULT NULL,
  87. `Rotation` varchar(256) DEFAULT NULL,
  88. `Velocity` varchar(256) DEFAULT NULL,
  89. `LastUpdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  90. `OwnerKey` char(36) DEFAULT '00000000-0000-0000-0000-000000000000',
  91. `ObjectType` varchar(256) DEFAULT NULL,
  92. `ObjectClass` varchar(256) DEFAULT NULL,
  93. `RateEnergy` varchar(256) DEFAULT NULL,
  94. `RateMoney` varchar(256) DEFAULT NULL,
  95. `RateHappiness` varchar(256) DEFAULT NULL,
  96. PRIMARY KEY (`UUID`)
  97. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  98. -- --------------------------------------------------------
  99. --
  100. -- Table structure for table `Users`
  101. --
  102. CREATE TABLE IF NOT EXISTS `Users` (
  103. `Email` varchar(128) NOT NULL DEFAULT '',
  104. `Password` varchar(256) DEFAULT NULL,
  105. PRIMARY KEY (`Email`)
  106. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;