Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.91 KB | None | 0 0
  1. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  2. SET time_zone = "+00:00";
  3.  
  4.  
  5. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  6. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  7. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  8. /*!40101 SET NAMES utf8 */;
  9.  
  10. --
  11. -- Database: `db6522`
  12. -- Default Schema
  13. --
  14. CREATE DATABASE IF NOT EXISTS `db7522` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  15. USE `db7522`;
  16.  
  17. DELIMITER $$
  18. --
  19. -- Procedures
  20. -- Edit arma3 and root to match a user in MySQL
  21. --
  22. CREATE DEFINER=`arma3`@`localhost` PROCEDURE `resetLifeVehicles`()
  23. BEGIN
  24. UPDATE vehicles SET `active`= 0;
  25. END$$
  26.  
  27. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
  28. BEGIN
  29. DELETE FROM `vehicles` WHERE `alive` = 0;
  30. END$$
  31.  
  32. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
  33. BEGIN
  34. DELETE FROM `houses` WHERE `owned` = 0;
  35. END$$
  36.  
  37. CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
  38. BEGIN
  39. DELETE FROM `gangs` WHERE `active` = 0;
  40. END$$
  41.  
  42. DELIMITER ;
  43.  
  44. -- --------------------------------------------------------
  45.  
  46. --
  47. -- Table structure for table `players`
  48. --
  49.  
  50. CREATE TABLE IF NOT EXISTS `players` (
  51. `uid` int(12) NOT NULL AUTO_INCREMENT,
  52. `name` varchar(32) NOT NULL,
  53. `playerid` varchar(50) NOT NULL,
  54. `cash` int(100) NOT NULL DEFAULT '0',
  55. `bankacc` int(100) NOT NULL DEFAULT '0',
  56. `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
  57. `cop_licenses` text,
  58. `civ_licenses` text,
  59. `med_licenses` text,
  60. `cop_gear` text NOT NULL,
  61. `med_gear` text NOT NULL,
  62. `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  63. `arrested` tinyint(1) NOT NULL DEFAULT '0',
  64. `aliases` text NOT NULL,
  65. `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
  66. `donatorlvl` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  67. `civ_gear` text NOT NULL,
  68. `blacklist` tinyint(1) NOT NULL DEFAULT '0',
  69. PRIMARY KEY (`uid`),
  70. UNIQUE KEY `playerid` (`playerid`),
  71. KEY `name` (`name`),
  72. KEY `blacklist` (`blacklist`)
  73. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
  74.  
  75. -- --------------------------------------------------------
  76.  
  77. --
  78. -- Table structure for table `vehicles`
  79. --
  80.  
  81. CREATE TABLE IF NOT EXISTS `vehicles` (
  82. `id` int(12) NOT NULL AUTO_INCREMENT,
  83. `side` varchar(15) NOT NULL,
  84. `classname` varchar(32) NOT NULL,
  85. `type` varchar(12) NOT NULL,
  86. `pid` varchar(32) NOT NULL,
  87. `alive` tinyint(1) NOT NULL DEFAULT '1',
  88. `active` tinyint(1) NOT NULL DEFAULT '0',
  89. `plate` int(20) NOT NULL,
  90. `color` int(20) NOT NULL,
  91. `inventory` varchar(500) NOT NULL,
  92. PRIMARY KEY (`id`),
  93. KEY `side` (`side`),
  94. KEY `pid` (`pid`),
  95. KEY `type` (`type`)
  96. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  97.  
  98. -- --------------------------------------------------------
  99.  
  100. --
  101. -- Table structure for table `houses`
  102. -- Needed for extDB latest update on git
  103. --
  104.  
  105. CREATE TABLE IF NOT EXISTS `houses` (
  106. `id` int(11) NOT NULL AUTO_INCREMENT,
  107. `pid` varchar(32) NOT NULL,
  108. `pos` varchar(64) DEFAULT NULL,
  109. `inventory` text,
  110. `containers` text,
  111. `owned` tinyint(4) DEFAULT '0',
  112. PRIMARY KEY (`id`,`pid`)
  113. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
  114.  
  115. -- --------------------------------------------------------
  116.  
  117. --
  118. -- Table structure for table `gangs`
  119. -- Needed for extDB latest update on git
  120. --
  121.  
  122. CREATE TABLE IF NOT EXISTS `gangs` (
  123. `id` int(11) NOT NULL AUTO_INCREMENT,
  124. `owner` varchar(32) DEFAULT NULL,
  125. `name` varchar(32) DEFAULT NULL,
  126. `members` text,
  127. `maxmembers` int(2) DEFAULT '8',
  128. `bank` int(100) DEFAULT '0',
  129. `active` tinyint(4) DEFAULT '1',
  130. PRIMARY KEY (`id`),
  131. UNIQUE KEY `name_UNIQUE` (`name`)
  132. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  133.  
  134. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  135. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  136. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement