API tools faq
paste
Advertisement
Guest User

Tabellen AOF+ADmin v2

a guest
Feb 14th, 2012
808
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 13.95 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. Navicat MySQL Data Transfer
  3.  
  4. Source Server         : TEstMYSQL
  5. Source Server Version : 50516
  6. Source Host           : localhost:3306
  7. Source Database       : samp
  8.  
  9. Target Server Type    : MYSQL
  10. Target Server Version : 50516
  11. File Encoding         : 65001
  12.  
  13. Date: 2012-02-14 19:20:15
  14. */
  15.  
  16. SET FOREIGN_KEY_CHECKS=0;
  17.  
  18. -- ----------------------------
  19. -- Table structure for `accounts`
  20. -- ----------------------------
  21. DROP TABLE IF EXISTS `accounts`;
  22. CREATE TABLE `accounts` (
  23.   `id` int(11) NOT NULL AUTO_INCREMENT,
  24.   `Name` varchar(24) NOT NULL,
  25.   `Passwort` varchar(128) NOT NULL,
  26.   `Score` int(11) NOT NULL DEFAULT '1',
  27.   `Money` int(11) NOT NULL DEFAULT '0',
  28.   `Kills` int(11) NOT NULL DEFAULT '0',
  29.   `Deaths` int(11) NOT NULL DEFAULT '0',
  30.   `Health` float NOT NULL DEFAULT '100',
  31.   `AdminLevel` int(11) NOT NULL,
  32.   `Moderator` int(11) NOT NULL,
  33.   `WantedLevel` int(11) NOT NULL,
  34.   `Jailed` int(11) NOT NULL,
  35.   `JailTime` int(11) NOT NULL,
  36.   `Skin` int(11) NOT NULL,
  37.   `Team` int(11) NOT NULL,
  38.   `Leader` int(11) NOT NULL,
  39.   `fRank` int(11) NOT NULL,
  40.   `fLohn` int(11) NOT NULL,
  41.   `Tutorial` int(11) NOT NULL,
  42.   `Job` int(11) NOT NULL,
  43.   `Geschlecht` int(11) NOT NULL,
  44.   `Alter` int(11) NOT NULL,
  45.   `Fuehrerschein` int(11) NOT NULL,
  46.   `Bootsschein` int(11) NOT NULL,
  47.   `Motoradschein` int(11) NOT NULL,
  48.   `Flugschein` int(11) NOT NULL,
  49.   `WantedDeaths` int(11) NOT NULL,
  50.   `PayDay` int(128) NOT NULL,
  51.   `RespektPunkte` int(11) NOT NULL,
  52.   `PersoArbeit` int(11) NOT NULL,
  53.   `Personalausweis` int(11) NOT NULL,
  54.   `Drugs` int(11) NOT NULL,
  55.   `PhoneBook` int(11) NOT NULL,
  56.   `Bank` int(11) NOT NULL,
  57.   `Gun1` int(11) NOT NULL,
  58.   `Gun2` int(11) NOT NULL,
  59.   `Gun3` int(11) NOT NULL,
  60.   `Gun4` int(11) NOT NULL,
  61.   `Handy` int(11) NOT NULL,
  62.   `Calling` int(11) NOT NULL,
  63.   `HandyCash` int(11) NOT NULL,
  64.   `CallPlayerid` int(11) NOT NULL,
  65.   `Handynr` int(11) NOT NULL,
  66.   `HandyFlat` int(11) NOT NULL,
  67.   `Gehalt` int(11) NOT NULL,
  68.   `mjobtime` int(11) NOT NULL,
  69.   `Friedhof` int(11) NOT NULL,
  70.   `FightStyle` int(11) NOT NULL,
  71.   `Bann` int(11) NOT NULL,
  72.   `HausKey` int(11) NOT NULL,
  73.   `SpawnChanger` int(11) NOT NULL,
  74.   `HausOwner` int(11) NOT NULL,
  75.   PRIMARY KEY (`id`)
  76. ) ENGINE=MyISAM AUTO_INCREMENT=302 DEFAULT CHARSET=latin1;
  77.  
  78. -- ----------------------------
  79. -- Records of accounts
  80. -- ----------------------------
  81.  
  82. -- ----------------------------
  83. -- Table structure for `autohaus`
  84. -- ----------------------------
  85. DROP TABLE IF EXISTS `autohaus`;
  86. CREATE TABLE `autohaus` (
  87.   `ID` int(11) NOT NULL AUTO_INCREMENT,
  88.   `AH_Name` varchar(32) CHARACTER SET latin1 COLLATE latin1_german1_ci NOT NULL DEFAULT '-1',
  89.   `AH_Typ` int(11) NOT NULL DEFAULT '-1',
  90.   `AH_X` float NOT NULL DEFAULT '-1',
  91.   `AH_Y` float NOT NULL DEFAULT '-1',
  92.   `AH_Z` float NOT NULL DEFAULT '-1',
  93.   `AH_Rot` float NOT NULL DEFAULT '-1',
  94.   `AH_Status` int(11) NOT NULL DEFAULT '-1',
  95.   `AH_Lock` int(11) NOT NULL DEFAULT '-1',
  96.   `AH_Paintjob` int(11) NOT NULL DEFAULT '-1',
  97.   `AH_Farbe1` int(11) NOT NULL DEFAULT '-1',
  98.   `AH_Farbe2` int(11) NOT NULL DEFAULT '-1',
  99.   `AH_mod1` int(11) NOT NULL DEFAULT '-1',
  100.   `AH_mod2` int(11) NOT NULL DEFAULT '-1',
  101.   `AH_mod3` int(11) NOT NULL DEFAULT '-1',
  102.   `AH_mod4` int(11) NOT NULL DEFAULT '-1',
  103.   `AH_mod5` int(11) NOT NULL DEFAULT '-1',
  104.   `AH_mod6` int(11) NOT NULL DEFAULT '-1',
  105.   `AH_mod7` int(11) NOT NULL DEFAULT '-1',
  106.   `AH_mod8` int(11) NOT NULL DEFAULT '-1',
  107.   `AH_mod9` int(11) NOT NULL DEFAULT '-1',
  108.   `AH_mod10` int(11) NOT NULL DEFAULT '-1',
  109.   `AH_mod11` int(11) NOT NULL DEFAULT '-1',
  110.   `AH_mod12` int(11) NOT NULL DEFAULT '-1',
  111.   `AH_mod13` int(11) NOT NULL DEFAULT '-1',
  112.   `AH_mod14` int(11) NOT NULL DEFAULT '-1',
  113.   `AH_Neon` int(11) NOT NULL DEFAULT '-1',
  114.   `AH_Blau` int(11) NOT NULL DEFAULT '-1',
  115.   `AH_Green` int(11) NOT NULL DEFAULT '-1',
  116.   `AH_Rot2` int(11) NOT NULL,
  117.   `AH_Gelb` int(11) NOT NULL,
  118.   `AH_Weiss` int(11) NOT NULL,
  119.   `AH_Pink` int(11) NOT NULL,
  120.   `AH_Nummernschild` varchar(11) NOT NULL,
  121.   PRIMARY KEY (`ID`)
  122. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  123.  
  124. -- ----------------------------
  125. -- Records of autohaus
  126. -- ----------------------------
  127.  
  128. -- ----------------------------
  129. -- Table structure for `fraktionskassse`
  130. -- ----------------------------
  131. DROP TABLE IF EXISTS `fraktionskassse`;
  132. CREATE TABLE `fraktionskassse` (
  133.   `Name` int(11) NOT NULL,
  134.   `Mats` int(11) NOT NULL,
  135.   `Kasse` int(14) NOT NULL,
  136.   `Weed` int(11) NOT NULL,
  137.   `Heroin` int(11) NOT NULL,
  138.   `Kokain` int(11) NOT NULL,
  139.   `LSD` int(11) NOT NULL,
  140.   `Amphetamine` int(11) NOT NULL,
  141.   `Metamphetamine` int(11) NOT NULL,
  142.   `Cannabis` int(11) NOT NULL
  143. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  144.  
  145. -- ----------------------------
  146. -- Records of fraktionskassse
  147. -- ----------------------------
  148. INSERT INTO `fraktionskassse` VALUES ('2', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  149. INSERT INTO `fraktionskassse` VALUES ('3', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  150. INSERT INTO `fraktionskassse` VALUES ('4', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  151. INSERT INTO `fraktionskassse` VALUES ('5', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  152. INSERT INTO `fraktionskassse` VALUES ('6', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  153. INSERT INTO `fraktionskassse` VALUES ('7', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  154. INSERT INTO `fraktionskassse` VALUES ('8', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  155. INSERT INTO `fraktionskassse` VALUES ('9', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  156. INSERT INTO `fraktionskassse` VALUES ('10', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  157. INSERT INTO `fraktionskassse` VALUES ('11', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  158. INSERT INTO `fraktionskassse` VALUES ('12', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  159. INSERT INTO `fraktionskassse` VALUES ('13', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  160. INSERT INTO `fraktionskassse` VALUES ('14', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  161. INSERT INTO `fraktionskassse` VALUES ('15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  162. INSERT INTO `fraktionskassse` VALUES ('15', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  163. INSERT INTO `fraktionskassse` VALUES ('17', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  164. INSERT INTO `fraktionskassse` VALUES ('18', '651', '6666', '666', '6666', '6666', '6666', '6666', '666666', '6666666');
  165. INSERT INTO `fraktionskassse` VALUES ('19', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  166. INSERT INTO `fraktionskassse` VALUES ('20', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  167. INSERT INTO `fraktionskassse` VALUES ('21', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  168. INSERT INTO `fraktionskassse` VALUES ('22', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  169. INSERT INTO `fraktionskassse` VALUES ('23', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  170. INSERT INTO `fraktionskassse` VALUES ('24', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  171. INSERT INTO `fraktionskassse` VALUES ('1', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  172. INSERT INTO `fraktionskassse` VALUES ('0', '-1', '0', '0', '0', '0', '0', '0', '0', '0');
  173.  
  174. -- ----------------------------
  175. -- Table structure for `hauser`
  176. -- ----------------------------
  177. DROP TABLE IF EXISTS `hauser`;
  178. CREATE TABLE `hauser` (
  179.   `ID` int(11) NOT NULL DEFAULT '0',
  180.   `Besitzer` varchar(128) NOT NULL,
  181.   `ax` float(128,0) NOT NULL,
  182.   `ay` float(128,0) NOT NULL,
  183.   `az` float(128,0) NOT NULL,
  184.   `ix` float(128,0) NOT NULL,
  185.   `iy` float(128,0) NOT NULL,
  186.   `iz` float(128,0) NOT NULL,
  187.   `interior` int(128) NOT NULL,
  188.   `virtual_world` int(128) NOT NULL,
  189.   `kosten` int(128) NOT NULL,
  190.   `kosten2` int(128) NOT NULL,
  191.   `nicht_zum_kauf` int(128) NOT NULL,
  192.   `verschlossen` int(128) NOT NULL,
  193.   `Heal` int(128) NOT NULL,
  194.   `Armour` int(128) NOT NULL,
  195.   `Type` int(128) NOT NULL,
  196.   `Miete` int(128) NOT NULL,
  197.   `Mietbar` int(128) NOT NULL,
  198.   PRIMARY KEY (`ID`)
  199. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  200.  
  201. -- ----------------------------
  202. -- Records of hauser
  203. -- ----------------------------
  204. INSERT INTO `hauser` VALUES ('0', 'Keiner', '1497', '-688', '95', '226', '1022', '1084', '7', '100', '100000', '2', '0', '1', '1', '1', '12', '0', '0');
  205. INSERT INTO `hauser` VALUES ('1', 'Keiner', '2460', '-1690', '13', '2196', '-1205', '1049', '6', '101', '10000', '8', '0', '1', '0', '0', '8', '0', '0');
  206. INSERT INTO `hauser` VALUES ('2', 'Keiner', '2514', '-1691', '14', '261', '1238', '1084', '9', '102', '10000', '5', '0', '1', '0', '0', '2', '0', '0');
  207. INSERT INTO `hauser` VALUES ('3', 'Keiner', '2523', '-1679', '15', '295', '1473', '1080', '15', '103', '230000', '2', '0', '1', '0', '0', '4', '0', '0');
  208. INSERT INTO `hauser` VALUES ('4', 'Keiner', '2525', '-1659', '16', '447', '1398', '1084', '2', '104', '230000', '10', '0', '1', '0', '0', '7', '0', '0');
  209. INSERT INTO `hauser` VALUES ('5', 'Keiner', '2514', '-1650', '14', '377', '1417', '1081', '15', '105', '150000', '4', '0', '1', '0', '0', '3', '0', '0');
  210. INSERT INTO `hauser` VALUES ('6', 'Keiner', '2499', '-1643', '14', '328', '1478', '1084', '15', '106', '150000', '7', '0', '1', '0', '0', '5', '0', '0');
  211. INSERT INTO `hauser` VALUES ('7', 'Keiner', '2486', '-1645', '14', '377', '1417', '1081', '15', '107', '1000000', '3', '0', '1', '0', '0', '3', '0', '0');
  212. INSERT INTO `hauser` VALUES ('8', 'Keiner', '2469', '-1646', '14', '261', '1285', '1080', '4', '108', '1500000', '2', '0', '1', '0', '0', '1', '0', '0');
  213. INSERT INTO `hauser` VALUES ('9', 'Keiner', '2452', '-1642', '14', '377', '1417', '1081', '15', '109', '120000', '7', '0', '1', '0', '0', '3', '0', '0');
  214. INSERT INTO `hauser` VALUES ('10', 'Keiner', '2414', '-1647', '14', '295', '1473', '1080', '15', '110', '150000', '7', '0', '1', '0', '0', '4', '0', '0');
  215. INSERT INTO `hauser` VALUES ('11', 'Keiner', '2393', '-1646', '14', '491', '1399', '1080', '2', '111', '1000000', '13', '0', '1', '0', '0', '10', '0', '0');
  216. INSERT INTO `hauser` VALUES ('12', 'Keiner', '2409', '-1675', '14', '261', '1238', '1084', '9', '112', '1000000', '2', '0', '1', '0', '0', '2', '0', '0');
  217. INSERT INTO `hauser` VALUES ('13', 'Keiner', '2385', '-1676', '15', '377', '1417', '1081', '15', '113', '500000', '5', '0', '1', '0', '0', '3', '0', '0');
  218. INSERT INTO `hauser` VALUES ('14', 'Keiner', '2363', '-1643', '14', '261', '1238', '1084', '9', '114', '500000', '5', '0', '1', '0', '0', '2', '0', '0');
  219. INSERT INTO `hauser` VALUES ('15', 'Keiner', '2368', '-1675', '14', '328', '1478', '1084', '15', '115', '500000', '5', '0', '1', '0', '0', '5', '0', '0');
  220. INSERT INTO `hauser` VALUES ('16', 'Keiner', '2327', '-1682', '15', '2270', '-1210', '1047', '10', '116', '200000', '12', '0', '1', '0', '0', '6', '0', '0');
  221. INSERT INTO `hauser` VALUES ('17', 'Keiner', '2307', '-1679', '14', '261', '1285', '1080', '4', '117', '200000', '4', '0', '1', '0', '0', '1', '0', '0');
  222. INSERT INTO `hauser` VALUES ('18', 'Keiner', '2282', '-1641', '16', '377', '1417', '1081', '15', '118', '100000', '3', '0', '1', '0', '0', '3', '0', '0');
  223. INSERT INTO `hauser` VALUES ('19', 'Keiner', '2257', '-1644', '16', '377', '1417', '1081', '15', '119', '100000', '3', '0', '1', '0', '0', '3', '0', '0');
  224. INSERT INTO `hauser` VALUES ('20', 'Keiner', '2244', '-1638', '16', '377', '1417', '1081', '15', '120', '100000', '3', '0', '1', '0', '0', '3', '0', '0');
  225. INSERT INTO `hauser` VALUES ('21', 'Keiner', '2309', '-1714', '15', '377', '1417', '1081', '15', '121', '3000', '5', '0', '1', '0', '0', '3', '0', '0');
  226. INSERT INTO `hauser` VALUES ('22', 'Keiner', '2327', '-1717', '14', '328', '1478', '1084', '15', '122', '6000', '12', '0', '1', '0', '0', '5', '0', '0');
  227. INSERT INTO `hauser` VALUES ('23', 'Keiner', '2385', '-1712', '14', '295', '1473', '1080', '15', '123', '10000', '4', '0', '1', '0', '0', '4', '0', '0');
  228. INSERT INTO `hauser` VALUES ('24', 'Keiner', '2402', '-1715', '14', '295', '1473', '1080', '15', '124', '10000', '4', '0', '1', '0', '0', '4', '0', '0');
  229. INSERT INTO `hauser` VALUES ('25', 'Keiner', '2065', '-1703', '14', '2196', '-1205', '1049', '6', '125', '100000', '10', '0', '1', '0', '0', '8', '0', '0');
  230. INSERT INTO `hauser` VALUES ('26', 'Keiner', '2066', '-1717', '14', '295', '1473', '1080', '15', '126', '30000', '10', '0', '1', '0', '0', '4', '0', '0');
  231. INSERT INTO `hauser` VALUES ('27', 'Keiner', '2067', '-1732', '14', '261', '1238', '1084', '9', '127', '30000', '10', '0', '1', '0', '0', '2', '0', '0');
  232. INSERT INTO `hauser` VALUES ('28', 'Keiner', '2067', '-1657', '14', '295', '1473', '1080', '15', '128', '30000', '8', '0', '1', '0', '0', '4', '0', '0');
  233. INSERT INTO `hauser` VALUES ('29', 'Keiner', '2067', '-1644', '14', '377', '1417', '1081', '15', '129', '30000', '8', '0', '1', '0', '0', '3', '0', '0');
  234. INSERT INTO `hauser` VALUES ('30', 'Keiner', '2068', '-1629', '14', '328', '1478', '1084', '15', '130', '30000', '8', '0', '1', '0', '0', '5', '0', '0');
  235. INSERT INTO `hauser` VALUES ('31', 'Keiner', '2018', '-1630', '14', '261', '1285', '1080', '4', '131', '30000', '2', '0', '1', '0', '0', '1', '0', '0');
  236. INSERT INTO `hauser` VALUES ('32', 'Keiner', '2016', '-1642', '14', '261', '1238', '1084', '9', '132', '25000', '5', '0', '1', '0', '0', '2', '0', '0');
  237. INSERT INTO `hauser` VALUES ('33', 'Keiner', '2013', '-1656', '14', '377', '1417', '1081', '15', '133', '25000', '10', '0', '1', '0', '0', '3', '0', '0');
  238. INSERT INTO `hauser` VALUES ('34', 'Keiner', '1981', '-1683', '17', '491', '1399', '1080', '2', '134', '205000', '15', '0', '1', '0', '0', '10', '0', '0');
  239. INSERT INTO `hauser` VALUES ('35', 'Keiner', '2018', '-1703', '14', '261', '1285', '1080', '4', '135', '1', '25', '0', '1', '0', '0', '1', '0', '0');
  240. INSERT INTO `hauser` VALUES ('36', 'Keiner', '2016', '-1717', '14', '261', '1238', '1084', '9', '136', '20000', '3', '0', '1', '0', '0', '2', '0', '0');
  241. INSERT INTO `hauser` VALUES ('37', 'Keiner', '2015', '-1733', '14', '261', '1238', '1084', '9', '137', '20000', '4', '0', '1', '0', '0', '2', '0', '0');
  242. INSERT INTO `hauser` VALUES ('38', 'Keiner', '1980', '-1719', '17', '2270', '-1210', '1047', '10', '138', '267000', '4', '0', '1', '0', '0', '6', '0', '0');
  243. INSERT INTO `hauser` VALUES ('39', 'Keiner', '2011', '-1595', '13', '226', '1022', '1084', '7', '139', '267000', '7', '0', '1', '0', '0', '12', '0', '0');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!