# Apollo RP SQL Prebuilt configuration for "mecklenburgv5_a5"
# Apply using in-game tool or any SQL editor

CREATE TABLE IF NOT EXISTS arp_doors (targetname VARCHAR(36),internalname VARCHAR(66),UNIQUE KEY (targetname))

INSERT INTO `arp_doors` VALUES ('t|md_doors2', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|md_doors1', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|md_doors3', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|md_doors4', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|md_backroom', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|md_chief', 'mcmd')
INSERT INTO `arp_doors` VALUES ('e|336', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|inn_lock2', 'mcmd')
INSERT INTO `arp_doors` VALUES ('t|donator_room', 'adminlounge')
INSERT INTO `arp_doors` VALUES ('t|711ownerplace', 'seveneleven')
INSERT INTO `arp_doors` VALUES ('t|711mngdor2', 'seveneleven')
INSERT INTO `arp_doors` VALUES ('t|armory_door1', 'gunshop')
INSERT INTO `arp_doors` VALUES ('t|armory_door2', 'gunshop')
INSERT INTO `arp_doors` VALUES ('t|backdoordclun', 'stripclub')
INSERT INTO `arp_doors` VALUES ('t|dancebackward', 'stripclub')
INSERT INTO `arp_doors` VALUES ('e|526', 'storageroom')
INSERT INTO `arp_doors` VALUES ('t|ricksofficedoors', '1337tower')
INSERT INTO `arp_doors` VALUES ('t|rick_esc', '1337tower')
INSERT INTO `arp_doors` VALUES ('t|diner_doorup1', 'diner')
INSERT INTO `arp_doors` VALUES ('t|diner_doorup2', 'diner')
INSERT INTO `arp_doors` VALUES ('t|hotelfrtdskdoor', 'hotel')
INSERT INTO `arp_doors` VALUES ('t|hotel_door_a', 'hotel_a')
INSERT INTO `arp_doors` VALUES ('t|hotel_b', 'hotel_b')
INSERT INTO `arp_doors` VALUES ('t|hotel_door_c', 'hotel_c')
INSERT INTO `arp_doors` VALUES ('t|hotel_door_d', 'hotel_d')
INSERT INTO `arp_doors` VALUES ('t|bank_door_1', 'bank')
INSERT INTO `arp_doors` VALUES ('t|bank_safedoor', 'bank')
INSERT INTO `arp_doors` VALUES ('t|bardoor1', 'bar')
INSERT INTO `arp_doors` VALUES ('t|bar_door5', 'bar')
INSERT INTO `arp_doors` VALUES ('t|bar_door2', 'bar')
INSERT INTO `arp_doors` VALUES ('t|bar_door3', 'bar')
INSERT INTO `arp_doors` VALUES ('t|window_hideout_1_door', 'hideout_1')
INSERT INTO `arp_doors` VALUES ('t|apartmentE', 'apartment_e')
INSERT INTO `arp_doors` VALUES ('e|830', 'apartment_g')
INSERT INTO `arp_doors` VALUES ('t|apartdoora', 'apartment_a')
INSERT INTO `arp_doors` VALUES ('t|apartdoorb', 'apartment_b')
INSERT INTO `arp_doors` VALUES ('t|prison_door_main2', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_main', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|interigation_door', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_3', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_2', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_1', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_4', 'mcpd')
INSERT INTO `arp_doors` VALUES ('e|142', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|prison_door_hele', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|pd_garage', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|ahideout_mcpd_door', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|hideout_4', 'hideout_4')
INSERT INTO `arp_doors` VALUES ('t|trapdor', 'hideout_4')
INSERT INTO `arp_doors` VALUES ('t|neo_nazi_1', 'hideout_4')
INSERT INTO `arp_doors` VALUES ('t|neo_nazi_2', 'hideout_4')
INSERT INTO `arp_doors` VALUES ('t|mall_donn', 'mcdonalds')
INSERT INTO `arp_doors` VALUES ('t|mall_security', 'mcpd')
INSERT INTO `arp_doors` VALUES ('t|Office_C', 'office_c')
INSERT INTO `arp_doors` VALUES ('t|office_b', 'office_b')
INSERT INTO `arp_doors` VALUES ('t|office_a_door', 'office_a')
INSERT INTO `arp_doors` VALUES ('t|apartdoorh', 'apartment_h')
INSERT INTO `arp_doors` VALUES ('t|apartdoord', 'apartment_d')
INSERT INTO `arp_doors` VALUES ('t|apartdoorc', 'apartment_c')
INSERT INTO `arp_doors` VALUES ('t|hideout_3', 'hideout_3')
INSERT INTO `arp_doors` VALUES ('t|house1', 'house_1')
INSERT INTO `arp_doors` VALUES ('t|ghousea', 'house_1')
INSERT INTO `arp_doors` VALUES ('t|apartdoorj', 'apartment_j')
INSERT INTO `arp_doors` VALUES ('t|apartdoorI', 'apartment_j')
INSERT INTO `arp_doors` VALUES ('t|housedoor1', 'house_1')
INSERT INTO `arp_doors` VALUES ('e|155', 'hotel_c')
INSERT INTO `arp_doors` VALUES ('e|480', 'hotel_b')
INSERT INTO `arp_doors` VALUES ('e|481', 'hotel_b')
INSERT INTO `arp_doors` VALUES ('e|145', 'hotel_a')
INSERT INTO `arp_doors` VALUES ('e|146', 'hotel_a')
INSERT INTO `arp_doors` VALUES ('e|645', 'seveneleven')
INSERT INTO `arp_doors` VALUES ('e|156', 'hotel_c')
INSERT INTO `arp_doors` VALUES ('e|102', 'apartment_a')
INSERT INTO `arp_doors` VALUES ('e|103', 'apartment_a')
INSERT INTO `arp_doors` VALUES ('e|101', 'apartment_b')
INSERT INTO `arp_doors` VALUES ('e|100', 'apartment_b')
INSERT INTO `arp_doors` VALUES ('e|366', 'mcmd')
INSERT INTO `arp_doors` VALUES ('e|310', 'apartment_c')
INSERT INTO `arp_doors` VALUES ('e|311', 'apartment_c')
INSERT INTO `arp_doors` VALUES ('t|apart_c_arms', 'apartment_c')
INSERT INTO `arp_doors` VALUES ('e|537', 'office_a')
INSERT INTO `arp_doors` VALUES ('e|399', 'office_a')
INSERT INTO `arp_doors` VALUES ('t|chur_confes', 'church')
INSERT INTO `arp_doors` VALUES ('e|881', 'apartment_g')

CREATE TABLE IF NOT EXISTS arp_jobs (name VARCHAR(32),salary INT(11),access VARCHAR(27),UNIQUE KEY (name))

INSERT INTO `arp_jobs` VALUES ('7/11 Employee', 20, 'td')
INSERT INTO `arp_jobs` VALUES ('7/11 Guard', 20, 'td')
INSERT INTO `arp_jobs` VALUES ('Advertiser', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Bank Clerk', 20, 'tl')
INSERT INTO `arp_jobs` VALUES ('Bank Guard', 20, 'tl')
INSERT INTO `arp_jobs` VALUES ('Bank Manager', 30, 'l')
INSERT INTO `arp_jobs` VALUES ('Bar Bartender', 30, 'mt')
INSERT INTO `arp_jobs` VALUES ('Bar Bouncer', 25, 'mt')
INSERT INTO `arp_jobs` VALUES ('Bar Manager', 30, 'm')
INSERT INTO `arp_jobs` VALUES ('Bodyguard', 30, 't')
INSERT INTO `arp_jobs` VALUES ('Chaffeur', 30, 't')
INSERT INTO `arp_jobs` VALUES ('City Judge', 30, 't')
INSERT INTO `arp_jobs` VALUES ('Drug Dealer', 20, 't')
INSERT INTO `arp_jobs` VALUES ('Economist', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Gunshop Worker', 20, 'el')
INSERT INTO `arp_jobs` VALUES ('Hitman', 25, 't')
INSERT INTO `arp_jobs` VALUES ('Hobo', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Hotel Bellboy', 15, 'it')
INSERT INTO `arp_jobs` VALUES ('Hotel Clerk', 20, 'it')
INSERT INTO `arp_jobs` VALUES ('Hotel Manager', 30, 'i')
INSERT INTO `arp_jobs` VALUES ('Lawyer', 20, 't')
INSERT INTO `arp_jobs` VALUES ('McDonalds Cashier', 15, 'nt')
INSERT INTO `arp_jobs` VALUES ('McDonalds Cook', 20, 'nt')
INSERT INTO `arp_jobs` VALUES ('McDonalds Manager', 30, 'n')
INSERT INTO `arp_jobs` VALUES ('MCMD Advanced Brain Surgeon', 80, 'b')
INSERT INTO `arp_jobs` VALUES ('MCMD Doctor', 55, 'b')
INSERT INTO `arp_jobs` VALUES ('MCMD Head Doctor', 65, 'b')
INSERT INTO `arp_jobs` VALUES ('MCMD Medic', 45, 'b')
INSERT INTO `arp_jobs` VALUES ('MCMD Nurse', 25, 'b')
INSERT INTO `arp_jobs` VALUES ('MCMD Paramedic', 35, 'b')
INSERT INTO `arp_jobs` VALUES ('MCPD Captain', 60, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Chief', 80, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Deputy Chief', 70, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Explorer', 20, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Jail Guard', 15, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Lieutenant', 50, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Officer', 30, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Senior Officer', 35, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Sergeant', 45, 'a')
INSERT INTO `arp_jobs` VALUES ('MCPD Trainer', 40, 'a')
INSERT INTO `arp_jobs` VALUES ('Photographer', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Pizzaboy', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Porn Star', 20, 't')
INSERT INTO `arp_jobs` VALUES ('Postman', 15, 't')
INSERT INTO `arp_jobs` VALUES ('Professor', 15, 't')
INSERT INTO `arp_jobs` VALUES ('PxRP Daddy', 1337, 'abcdefghijklmnopqrstuvwxyz')
INSERT INTO `arp_jobs` VALUES ('Reporter', 15, 't')
INSERT INTO `arp_jobs` VALUES ('S.W.A.T Experienced', 60, 'a')
INSERT INTO `arp_jobs` VALUES ('S.W.A.T Leader', 70, 'a')
INSERT INTO `arp_jobs` VALUES ('S.W.A.T Member', 55, 'a')
INSERT INTO `arp_jobs` VALUES ('S.W.A.T Rookie', 50, 'a')
INSERT INTO `arp_jobs` VALUES ('Salesman', 20, 't')
INSERT INTO `arp_jobs` VALUES ('Spy', 30, 't')
INSERT INTO `arp_jobs` VALUES ('Stripper', 25, 'ft')
INSERT INTO `arp_jobs` VALUES ('Taxi Driver', 10, 't')
INSERT INTO `arp_jobs` VALUES ('Thief', 20, 't')
INSERT INTO `arp_jobs` VALUES ('Tower Guard', 25, 'gt')
INSERT INTO `arp_jobs` VALUES ('Tower Manager', 35, 'g')
INSERT INTO `arp_jobs` VALUES ('Weapons Dealer', 15, 't')

CREATE TABLE IF NOT EXISTS arp_properties (internalname VARCHAR(66),externalname VARCHAR(66),ownername VARCHAR(40),ownerauth VARCHAR(36),price INT(11),locked INT(11),access VARCHAR(27),profit INT(11),UNIQUE KEY (internalname))

INSERT INTO `arp_properties` VALUES ('mcmd', 'Mecklenburg Medical Department', '', '', 0, 1, 'b', 0)
INSERT INTO `arp_properties` VALUES ('adminlounge', 'Admin Lounge', '', '', 0, 1, 'z', 0)
INSERT INTO `arp_properties` VALUES ('seveneleven', '7/11', '', '', 500000, 1, 'd', 0)
INSERT INTO `arp_properties` VALUES ('gunshop', 'Gun Shop', '', '', 750000, 1, 'e', 0)
INSERT INTO `arp_properties` VALUES ('stripclub', 'Strip Club', '', '', 400000, 1, 'f', 0)
INSERT INTO `arp_properties` VALUES ('storageroom', 'Storage Room', '', '', 200000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('1337tower', '1337 Tower', '', '', 1000000, 1, 'g', 0)
INSERT INTO `arp_properties` VALUES ('diner', 'Diner', '', '', 500000, 1, 'h', 0)
INSERT INTO `arp_properties` VALUES ('hotel', 'Hotel', '', '', 1250000, 1, 'i', 0)
INSERT INTO `arp_properties` VALUES ('hotel_a', 'Hotel A', '', '', 200000, 1, 'i', 0)
INSERT INTO `arp_properties` VALUES ('hotel_b', 'Hotel B', '', '', 200000, 1, 'i', 0)
INSERT INTO `arp_properties` VALUES ('hotel_c', 'Hotel C', '', '', 200000, 1, 'i', 0)
INSERT INTO `arp_properties` VALUES ('hotel_d', 'Hotel D', '', '', 200000, 1, 'i', 0)
INSERT INTO `arp_properties` VALUES ('bank', 'Bank', '', '', 1500000, 1, 'l', 0)
INSERT INTO `arp_properties` VALUES ('bar', 'Bar', '', '', 400000, 1, 'm', 0)
INSERT INTO `arp_properties` VALUES ('hideout_1', 'Hideout 1', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_e', 'Apartment E', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_g', 'Apartment G', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_a', 'Apartment A', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_c', 'Apartment C', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('mcpd', 'Mecklenburg Police Department', '', '', 0, 1, 'a', 0)
INSERT INTO `arp_properties` VALUES ('hideout_4', 'Hideout 4', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('mcdonalds', 'McDonalds', '', '', 300000, 1, 'n', 0)
INSERT INTO `arp_properties` VALUES ('office_c', 'Office C', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('office_b', 'Office B', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('office_a', 'Office A', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_h', 'Apartment H', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_d', 'Apartment D', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('hideout_3', 'Hideout 3', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('house_1', 'House 1', '', '', 500000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_j', 'Apartment J', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('apartment_i', 'Apartment I', '', '', 350000, 1, '', 0)
INSERT INTO `arp_properties` VALUES ('church', 'Church', '', '', 0, 1, '', 0)
