Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v esxlegacy_a3a893 addon_account
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v esxlegacy_a3a893 addon_account_data
* id : int(11)
* account_name : varchar(100)
* money : int(11)
* owner : varchar(60)
v esxlegacy_a3a893 addon_inventory
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v esxlegacy_a3a893 addon_inventory_items
* id : int(11)
* inventory_name : varchar(100)
* name : varchar(100)
* count : int(11)
* owner : varchar(60)
v esxlegacy_a3a893 banking
* identifier : varchar(46)
* type : varchar(50)
* amount : int(64)
* time : bigint(20)
* ID : int(11)
* balance : int(11)
* label : varchar(255)
v esxlegacy_a3a893 billing
* id : int(11)
* identifier : varchar(60)
* sender : varchar(60)
* target_type : varchar(50)
* target : varchar(40)
* label : varchar(255)
* amount : int(11)
v esxlegacy_a3a893 cardealer_vehicles
* id : int(11)
* vehicle : varchar(255)
* price : int(11)
v esxlegacy_a3a893 crafting_recipes
* id : int(11)
* name : varchar(50)
* result_items : longtext
* perfect_recipe_reward : longtext
* ingredients : longtext
* time : int(11)
v esxlegacy_a3a893 datastore
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v esxlegacy_a3a893 datastore_data
* id : int(11)
* name : varchar(60)
* owner : varchar(60)
* data : longtext
v esxlegacy_a3a893 dealerships_creator_classes
* id : varchar(50)
* label : varchar(100)
v esxlegacy_a3a893 dealerships_creator_dealerships
* id : int(11)
* label : varchar(50)
* type : varchar(50)
* data : longtext
* owner : varchar(46)
* stored_money : int(11)
* employees_data : longtext
* stock_vehicles : longtext
* models_prices : longtext
v esxlegacy_a3a893 dealerships_creator_loans
* id : int(11)
* identifier : varchar(46)
* dealership_id : int(11)
* vehicle_name : varchar(50)
* plate : varchar(50)
* installment : int(11)
* payment_dates : longtext
v esxlegacy_a3a893 dealerships_creator_vehicles
* spawn_name : varchar(50)
* label : varchar(100)
* class : varchar(50)
* type : varchar(50)
v esxlegacy_a3a893 dealership_balance
* id : int(11) unsigned
* dealership_id : varchar(50)
* user_id : varchar(50)
* description : varchar(255)
* name : varchar(50)
* amount : int(11) unsigned
* type : tinyint(3)
* isbuy : tinyint(3)
* show_on_chart : tinyint(3) unsigned
* date : int(11) unsigned
* hidden : tinyint(3) unsigned
v esxlegacy_a3a893 dealership_categories
* dealership_id : varchar(50)
* category : varchar(50)
v esxlegacy_a3a893 dealership_financed_vehicles
* id : int(11) unsigned
* dealership_id : varchar(50)
* plate : varchar(50)
v esxlegacy_a3a893 dealership_hired_players
* dealership_id : varchar(50)
* user_id : varchar(50)
* profile_img : varchar(255)
* banner_img : varchar(255)
* name : varchar(50)
* jobs_done : int(11) unsigned
* role : tinyint(3) unsigned
* timer : int(11) unsigned
v esxlegacy_a3a893 dealership_jobs
* id : int(10) unsigned
* dealership_id : varchar(50)
* name : varchar(50)
* reward : int(10) unsigned
* vehicle : varchar(50)
* amount : int(11)
* progress : tinyint(3) unsigned
* trucker_contract_id : int(10) unsigned
v esxlegacy_a3a893 dealership_owner
* dealership_id : varchar(50)
* user_id : varchar(50)
* name : varchar(50)
* profile_img : varchar(255)
* banner_img : varchar(255)
* stock : text
* stock_prices : longtext
* stock_sold : text
* stock_upgrade : tinyint(3) unsigned
* truck_upgrade : tinyint(3) unsigned
* relationship_upgrade : tinyint(3) unsigned
* money : int(11) unsigned
* total_money_spent : int(11) unsigned
* total_money_earned : int(11) unsigned
* goods_bought : int(10) unsigned
* distance_traveled : double unsigned
* total_visits : int(10) unsigned
* dealership_name : varchar(50)
* dealership_color : int(10) unsigned
* dealership_blip : int(10) unsigned
* timer : int(11) unsigned
v esxlegacy_a3a893 dealership_requests
* id : int(11)
* dealership_id : varchar(50)
* user_id : varchar(50)
* vehicle : varchar(50)
* plate : varchar(50)
* request_type : int(1) unsigned
* color : varchar(255)
* name : varchar(50)
* price : int(11) unsigned
* status : int(2) unsigned
v esxlegacy_a3a893 dealership_stock
* vehicle : varchar(100)
* amount : int(11) unsigned
v esxlegacy_a3a893 dealership_users_theme
* user_id : varchar(50)
* dark_theme : tinyint(3) unsigned
v esxlegacy_a3a893 doorscreator_buildings
* id : int(11)
* label : varchar(50)
* default_state : tinyint(4)
* allowed_jobs : longtext
* allowed_gangs : longtext
* required_item : varchar(50)
* required_item_remove_on_use : tinyint(4)
* requires_job_and_item : int(11)
* required_code : varchar(50)
* auto_closure_seconds : int(11)
* requires_identifier : int(11)
* allowed_identifiers : longtext
* time_rules : longtext
v esxlegacy_a3a893 doorscreator_doors
* id : int(11)
* label : varchar(50)
* doors : longtext
* default_state : tinyint(4)
* icon_coords : longtext
* max_distance : int(11)
* allowed_jobs : longtext
* allowed_gangs : longtext
* required_item : varchar(50)
* required_item_remove_on_use : tinyint(4)
* requires_job_and_item : int(11)
* required_code : varchar(50)
* auto_closure_seconds : int(11)
* parent_building : int(11)
* is_sliding : int(11)
* requires_identifier : int(11)
* allowed_identifiers : longtext
* vault : longtext
* can_be_lockpicked : int(11)
* alert_police_on_lockpick : int(11)
* shop_id : int(11)
* display_icon : tinyint(4)
* sounds_data : longtext
* time_rules : longtext
v esxlegacy_a3a893 drugs_creator_auctions
* id : int(11)
* label : varchar(100)
* config : longtext
v esxlegacy_a3a893 drugs_fields
* id : int(11)
* label : varchar(50)
* coords : longtext
* radius : int(11)
* object_model : varchar(50)
* max_objects : int(11)
* items : longtext
* time : int(11)
* blip_name : varchar(50)
* blip_sprite : int(11)
* blip_color : int(11)
* blip_scale : float
* required_item : longtext
v esxlegacy_a3a893 ecg
* ActiveECG : int(11)
* handle : varchar(50)
* prop : int(11)
v esxlegacy_a3a893 emd_alarmcodes
* id : int(11)
* job : text
* code : text
* vehicles : text
* speech : text
* bluelight : int(11)
* custom_gong : varchar(255)
* second : varchar(2000)
* schlagworte : varchar(2000)
* wachmonitor_bg : varchar(255)
* wachmonitor_header : varchar(255)
v esxlegacy_a3a893 emd_cooperation
* id : int(11)
* partner1 : text
* partner2 : text
v esxlegacy_a3a893 emd_departments
* id : int(11)
* department : text
* job : text
* coords : text
* radius : int(11)
* announcements : text
v esxlegacy_a3a893 emd_dispatchlist
* id : int(11)
* number : text
* dispatch : text
v esxlegacy_a3a893 emd_dispatchlog
* id : int(11)
* number : text
* date : text
* time : text
* sender : text
* type : text
* text : text
v esxlegacy_a3a893 emd_hospital
* id : int(11)
* hospital : varchar(255)
* fachbereiche : varchar(255)
* coords : varchar(255)
* webhook : varchar(255)
* poi : varchar(255)
v esxlegacy_a3a893 emd_jobs
* id : int(11)
* job : text
* value : text
* grade : int(11)
* statuscolor : text
* statustext : text
* image : text
* discordstatus : text
* discordemergency : text
* discordalarm : text
* controlname : text
* cooperation : text
* emergency : int(11)
* vpcid : int(11)
* emc_number : varchar(255)
* emc_background : varchar(255)
* emc_color : varchar(255)
* ctl_pos : varchar(255)
* gefwarn : int(11)
* discordleitstelle : varchar(255)
* panic : varchar(255)
* eh : int(11)
* ric : varchar(255)
v esxlegacy_a3a893 emd_log
* id : int(11)
* background : text
* identifier : text
* name : text
* nickname : text
* type : text
* part : text
* description : text
* date : text
* time : text
v esxlegacy_a3a893 emd_pager
* id : int(11)
* name : text
* config : text
* standard : int(11)
v esxlegacy_a3a893 emd_permissions
* id : int(11)
* identifier : text
* type : text
* job : text
* permissions : text
v esxlegacy_a3a893 emd_poi
* id : int(11)
* poi : varchar(255)
* postal : varchar(255)
* city : varchar(255)
v esxlegacy_a3a893 emd_ric
* id : int(11)
* identifier : varchar(255)
* playername : varchar(255)
* job : varchar(255)
* ric : varchar(255)
v esxlegacy_a3a893 emd_settings
* id : int(11)
* value : text
* setting : text
v esxlegacy_a3a893 emd_status
* id : int(11)
* vehicle : text
* job : text
* name : text
* date : text
* time : text
* status : text
* dispatch : text
v esxlegacy_a3a893 emd_translation
* id : int(11)
* translation : text
v esxlegacy_a3a893 emd_user_settings
* id : int(11)
* identifier : text
* dme : text
* volume : text
* sepurax : text
* sepuray : text
* melderx : text
* meldery : text
* dmex : text
* dmey : text
* lstx : text
* lsty : text
* lstsepurax : text
* lstsepuray : text
* bgtablet : text
* zoom : int(11)
* sepura : text
* tablet : varchar(255)
v esxlegacy_a3a893 emd_vehicles
* id : int(11)
* department : text
* value : text
* valuelong : text
* job : text
* grade : int(11)
* image : text
* type : text
* locked : text
* funkkanal : text
* ivena_anmeldung : int(11)
* ivena_monitor : int(11)
* springer : int(11)
* doorid : int(11)
v esxlegacy_a3a893 emd_vehicletypes
* id : int(11)
* job : text
* vehtype : text
v esxlegacy_a3a893 emd_voicechannel
* id : int(11)
* voiceid : int(11)
* voicename : text
* job : text
* onlyforjob : text
v esxlegacy_a3a893 emd_volunteering
* id : int(11)
* job : text
* value : text
* item : text
* discord_webhook : varchar(255)
* discord_ping : varchar(255)
* discord_ric : varchar(255)
v esxlegacy_a3a893 fine_types
* id : int(11)
* label : varchar(255)
* amount : int(11)
* category : int(11)
v esxlegacy_a3a893 harvestable_items
* id : int(11)
* name : varchar(50)
* time_to_harvest : int(11)
* min_quantity : int(11)
* max_quantity : int(11)
* icon_type : int(11)
* coords : longtext
* scale : longtext
* bounce : int(11)
* follow_camera : int(11)
* rotate : int(11)
* color : varchar(100)
* opacity : int(11)
* blip_name : varchar(50)
* blip_sprite : int(11)
* blip_color : int(11)
* blip_scale : float
v esxlegacy_a3a893 hex_4_hud
* id : int(11)
* identifier : varchar(100)
* settings : longtext
* positions : longtext
v esxlegacy_a3a893 items
* name : varchar(50)
* label : varchar(50)
* weight : int(11)
* rare : tinyint(4)
* can_remove : tinyint(4)
v esxlegacy_a3a893 jaksam_inventory
* id : varchar(100)
* label : varchar(100)
* type : varchar(50)
* options : longtext
* items : longtext
* last_update : timestamp
* metadata : longtext
v esxlegacy_a3a893 jaksam_inventory_ground_containers
* inventory_id : varchar(100)
* coords : longtext
v esxlegacy_a3a893 jaksam_inventory_shops
* id : varchar(50)
* label : varchar(50)
* config : longtext
v esxlegacy_a3a893 jaksam_inventory_stashes
* id : varchar(50)
* label : varchar(50)
* config : longtext
v esxlegacy_a3a893 jaksam_inventory_stats
* id : int(11)
* player_identifier : varchar(100)
* item_name : varchar(100)
* amount : int(11)
* source_script : varchar(100)
* timestamp : timestamp
v esxlegacy_a3a893 jc-postal
* data : text
v esxlegacy_a3a893 jobs
* name : varchar(50)
* label : varchar(50)
* type : varchar(50)
* whitelisted : tinyint(1)
* enable_billing : int(1)
* can_rob : int(1)
* can_handcuff : int(1)
* can_lockpick_cars : int(1)
* can_wash_vehicles : int(1)
* can_repair_vehicles : int(1)
* can_impound_vehicles : int(1)
* can_check_identity : int(1)
* can_check_vehicle_owner : int(1)
* can_check_driving_license : int(1)
* can_check_weapon_license : int(1)
* can_heal : int(1)
* can_revive : int(1)
* actions_menu_enabled : int(1)
* placeable_objects : longtext
* options : longtext
v esxlegacy_a3a893 jobs_armories
* id : int(11)
* weapon : varchar(50)
* components : longtext
* ammo : int(10) unsigned
* tint : int(11)
* marker_id : int(11)
* identifier : varchar(80)
v esxlegacy_a3a893 jobs_data
* id : int(11)
* job_name : varchar(50)
* type : varchar(50)
* coords : varchar(300)
* grades_type : varchar(20)
* specific_grades : longtext
* min_grade : smallint(6)
* data : longtext
* blip_id : int(11)
* blip_color : int(11)
* blip_scale : float
* label : varchar(50)
* marker_type : int(11)
* marker_scale_x : float
* marker_scale_y : float
* marker_scale_z : float
* marker_color_red : int(3)
* marker_color_green : int(3)
* marker_color_blue : int(3)
* marker_color_alpha : int(3)
* ped : varchar(50)
* ped_heading : float
* object : varchar(50)
* object_heading : float
v esxlegacy_a3a893 jobs_employee_hours
* job_name : varchar(50)
* char_identifier : varchar(100)
* total_minutes : int(11)
* date : date
v esxlegacy_a3a893 jobs_garages
* vehicle_id : int(11)
* identifier : varchar(100)
* marker_id : int(11)
* vehicle : varchar(50)
* vehicle_props : longtext
* plate : varchar(10)
v esxlegacy_a3a893 jobs_shops
* id : int(11)
* marker_id : int(11)
* item_name : varchar(50)
* item_type : varchar(50)
* item_quantity : int(11)
* price : int(11)
v esxlegacy_a3a893 jobs_wardrobes
* id : int(11)
* identifier : varchar(100)
* label : varchar(50)
* outfit : longtext
v esxlegacy_a3a893 job_grades
* id : int(11)
* job_name : varchar(50)
* grade : int(11)
* name : varchar(50)
* label : varchar(50)
* salary : int(11)
* skin_male : longtext
* skin_female : longtext
v esxlegacy_a3a893 jpr_emssystem_chat
* id : int(11)
* messageData : longtext
* date : timestamp
v esxlegacy_a3a893 jpr_emssystem_fines_list
* id : int(11)
* fineName : varchar(250)
* fineDesc : varchar(250)
* fineValue : int(11)
* createdBy : text
* date : timestamp
v esxlegacy_a3a893 jpr_emssystem_fine_sent
* id : int(11)
* fineReceiver : varchar(250)
* fineSender : varchar(250)
* fineID : varchar(50)
* payed : int(11)
v esxlegacy_a3a893 jpr_emssystem_logs
* id : int(11)
* logCreatorID : tinytext
* logCreator : tinytext
* logKey : tinytext
* logDesc : tinytext
* logDate : timestamp
v esxlegacy_a3a893 jpr_emssystem_profiles
* id : int(11)
* identifier : varchar(250)
* desc : text
* callsign : varchar(50)
* image : tinytext
v esxlegacy_a3a893 jpr_emssystem_reports
* id : int(11)
* creatorIdentifier : varchar(255)
* reportName : varchar(250)
* reportDesc : text
* emsInvolved : text
* imageList : text
* citizensInvolved : text
* injuriesList : text
* date : timestamp
* active : int(11)
v esxlegacy_a3a893 jpr_mdtsystem_chat
* id : int(11)
* messageData : longtext
* date : timestamp
v esxlegacy_a3a893 jpr_mdtsystem_fines_list
* id : int(11)
* fineName : varchar(250)
* fineDesc : varchar(250)
* fineValue : int(11)
* createdBy : text
* date : timestamp
v esxlegacy_a3a893 jpr_mdtsystem_fine_sent
* id : int(11)
* fineReceiver : varchar(250)
* fineSender : varchar(250)
* fineID : varchar(50)
* payed : int(11)
v esxlegacy_a3a893 jpr_mdtsystem_houses_profile
* id : int(11)
* identifier : varchar(250)
* image : tinytext
v esxlegacy_a3a893 jpr_mdtsystem_logs
* id : int(11)
* logCreatorID : tinytext
* logCreator : tinytext
* logKey : tinytext
* logDesc : tinytext
* logDate : timestamp
v esxlegacy_a3a893 jpr_mdtsystem_profiles
* id : int(11)
* identifier : varchar(250)
* desc : text
* callsign : varchar(50)
* image : tinytext
v esxlegacy_a3a893 jpr_mdtsystem_reports
* id : int(11)
* creatorIdentifier : varchar(255)
* reportName : varchar(250)
* reportDesc : text
* officersInvolved : text
* evidenceList : text
* vehiclesInvolved : text
* citizensInvolved : text
* housesInvolved : text
* date : timestamp
* active : int(11)
v esxlegacy_a3a893 jpr_mdtsystem_vehicle_profile
* id : int(11)
* plate : varchar(50)
* image : tinytext
v esxlegacy_a3a893 k5_documents
* id : int(11)
* data : longtext
* ownerId : varchar(50)
* isCopy : tinyint(4)
v esxlegacy_a3a893 k5_document_templates
* id : int(11)
* data : longtext
* job : varchar(50)
v esxlegacy_a3a893 laboratories
* id : int(11)
* name : varchar(50)
* coords : longtext
* allowed_recipes : longtext
* allowed_jobs : longtext
* icon_type : int(11)
* scale : longtext
* bounce : int(11)
* follow_camera : int(11)
* rotate : int(11)
* color : varchar(50)
* opacity : int(11)
* blip_name : varchar(50)
* blip_sprite : int(11)
* blip_color : int(11)
* blip_scale : float
v esxlegacy_a3a893 licenses
* type : varchar(60)
* label : varchar(60)
v esxlegacy_a3a893 luxucex_accounts
* id : int(10) unsigned
* char_id : varchar(255)
* balance : bigint(20)
* crypto : longtext
* address : varchar(255)
v esxlegacy_a3a893 luxucex_market_transactions
* id : int(10) unsigned
* identifier : varchar(100)
* type : enum('buy','sell')
* coin : varchar(50)
* amount : decimal(20,8) unsigned
* price : decimal(20,8) unsigned
* created_at : datetime
v esxlegacy_a3a893 luxucex_positions
* code : char(36)
* pair : varchar(100)
* type : varchar(100)
* contract_quantity : varchar(100)
* entry : float
* leverage : int(11)
* allocated_margin : float
* date : datetime
* liquidation : float
* owner : varchar(100)
v esxlegacy_a3a893 luxucex_tradinghistory
* key : int(11)
* pair : varchar(100)
* entry : varchar(100)
* margin : varchar(100)
* leverage : varchar(100)
* size : varchar(100)
* type : varchar(100)
* close : varchar(100)
* date : datetime
* action : varchar(100)
* pnl : varchar(100)
* owner : varchar(100)
v esxlegacy_a3a893 luxucex_transfers
* id : int(10) unsigned
* sender : varchar(255)
* receiver : varchar(255)
* coin : varchar(255)
* amount : decimal(20,8) unsigned
* created_at : datetime
v esxlegacy_a3a893 management_outfits
* id : int(11)
* job_name : varchar(50)
* type : varchar(50)
* minrank : int(11)
* name : varchar(50)
* gender : varchar(50)
* model : varchar(50)
* props : varchar(1000)
* components : varchar(1500)
v esxlegacy_a3a893 msk_bansystem
* id : int(10)
* ids : longtext
* time : text
* reason : text
* bannedby : varchar(80)
* tokens : longtext
v esxlegacy_a3a893 multicharacter_slots
* identifier : varchar(60)
* slots : int(11)
v esxlegacy_a3a893 multijobs
* citizenid : varchar(100)
* jobdata : text
v esxlegacy_a3a893 okokbilling
* id : int(11)
* ref_id : varchar(10)
* receiver_identifier : varchar(255)
* receiver_name : varchar(255)
* author_identifier : varchar(255)
* author_name : varchar(255)
* society : varchar(255)
* society_name : varchar(255)
* item : varchar(255)
* invoice_value : int(11)
* fees_amount : int(11)
* status : varchar(50)
* notes : longtext
* sent_date : varchar(255)
* limit_pay_date : varchar(255)
* paid_date : varchar(255)
v esxlegacy_a3a893 okokgarage_companies
* company_name : varchar(50)
* owner : varchar(255)
* owner_name : varchar(50)
* money : int(11)
* employees : longtext
* total_sales : int(11)
* sales_history : longtext
v esxlegacy_a3a893 okokgarage_pgarages
* garagename : varchar(250)
* coords : varchar(250)
* type : varchar(50)
* owners : varchar(250)
v esxlegacy_a3a893 okokgarage_sharedgarages
* owner : varchar(255)
* ownername : varchar(50)
* sharedwith : longtext
v esxlegacy_a3a893 okokgasstation_orders
* id : int(11)
* store_id : varchar(255)
* liters : varchar(255)
* vehicle : varchar(255)
* long_vehicle : varchar(255)
* reward : varchar(255)
* in_progress : varchar(255)
* employee_name : varchar(255)
* employee_id : varchar(255)
v esxlegacy_a3a893 okokgasstation_saleshistory
* store_id : varchar(255)
* buyer_id : varchar(255)
* buyer_name : varchar(255)
* liters : varchar(255)
* price : varchar(255)
* date : varchar(255)
v esxlegacy_a3a893 okokgasstation_stores
* store_name : varchar(255)
* store_id : varchar(255)
* owner : varchar(255)
* owner_name : varchar(255)
* money : varchar(255)
* business_price : varchar(255)
* gas_price : decimal(10,2)
* current_stock : varchar(255)
* max_stock : varchar(255)
* employees : longtext
* vehicles : longtext
* inactivity_date : varchar(255)
v esxlegacy_a3a893 okokmulticharacter_tebexids
* identifier : varchar(255)
* tebexids : longtext
v esxlegacy_a3a893 okokphone_backups
* owner : varchar(255)
* avatar : mediumtext
* name : varchar(255)
* phone_number : varchar(10)
* wallpaper : text
* ringtone : varchar(255)
* notification_sound : varchar(255)
* lockscreen : text
* homescreen : longtext
* gallery : longtext
* albums : longtext
* contacts : longtext
* notes : longtext
* settings : longtext
* flashlight_color : mediumtext
* last_location : mediumtext
* clock : longtext
* email : varchar(255)
* storage : longtext
* created_at : datetime
v esxlegacy_a3a893 okokphone_blocklist
* id : int(11) unsigned
* blocker_number : varchar(10)
* blocked_number : varchar(10)
v esxlegacy_a3a893 okokphone_call_logs
* id : varchar(36)
* caller : varchar(255)
* caller_imei : varchar(255)
* receiver : varchar(255)
* receiver_imei : varchar(255)
* type : varchar(50)
* duration : int(11)
* timestamp : datetime(3)
* caller_history : tinyint(4)
* receiver_history : tinyint(4)
v esxlegacy_a3a893 okokphone_chats
* app : varchar(100)
* id : varchar(36)
* author : longtext
* last_message : text
* timestamp : datetime(3)
v esxlegacy_a3a893 okokphone_chat_messages
* app : varchar(50)
* id : varchar(36)
* chat_id : varchar(36)
* author : longtext
* text : text
* media_src : varchar(512)
* media_type : varchar(10)
* audio : varchar(512)
* gps : text
* timestamp : datetime(3)
v esxlegacy_a3a893 okokphone_chat_participants
* chat_id : varchar(36)
* phone_number : varchar(10)
* active : tinyint(1)
v esxlegacy_a3a893 okokphone_media
* id : varchar(36)
* creator : varchar(255)
* type : enum('image','video')
* src : varchar(512)
* width : int(11)
* height : int(11)
* timestamp : datetime
v esxlegacy_a3a893 okokphone_notifications
* id : int(10) unsigned
* imei : varchar(255)
* app : varchar(255)
* title : varchar(255)
* message : varchar(255)
* img : text
* type : varchar(20)
* coords : varchar(255)
* created_at : datetime
v esxlegacy_a3a893 okokphone_phones
* imei : varchar(255)
* owner : varchar(255)
* avatar : mediumtext
* name : varchar(255)
* phone_number : varchar(10)
* pincode : varchar(10)
* wallpaper : text
* ringtone : varchar(255)
* notification_sound : varchar(255)
* lockscreen : text
* homescreen : longtext
* gallery : longtext
* albums : longtext
* contacts : longtext
* notes : longtext
* settings : longtext
* flashlight_color : mediumtext
* last_location : mediumtext
* clock : longtext
* email : varchar(255)
* storage : longtext
* created_at : datetime
v esxlegacy_a3a893 okp_cupid_accounts
* user_id : int(11)
* username : varchar(255)
* password : varchar(255)
* name : varchar(255)
* avatar : varchar(500)
* bio : text
* pictures : longtext
* gender : varchar(255)
* birthdate : date
* preference : varchar(255)
* created_at : datetime
v esxlegacy_a3a893 okp_cupid_likes
* liker_id : int(11)
* liked_id : int(11)
* status : enum('liked','disliked')
* liked_at : datetime
v esxlegacy_a3a893 okp_cupid_matches
* match_id : int(11)
* user1_id : int(11)
* user2_id : int(11)
* last_message : varchar(255)
* matched_at : datetime
v esxlegacy_a3a893 okp_darknet_accounts
* id : varchar(36)
* username : varchar(255)
* password : varchar(255)
* avatar : varchar(255)
* chats : longtext
* created_at : datetime(3)
v esxlegacy_a3a893 okp_darknet_chats
* id : varchar(36)
* author : varchar(255)
* partner : varchar(255)
* created_at : datetime(3)
v esxlegacy_a3a893 okp_darknet_listings
* id : varchar(36)
* author : varchar(255)
* title : varchar(255)
* description : varchar(255)
* thumbnail : mediumtext
* created_at : datetime(3)
v esxlegacy_a3a893 okp_email_accounts
* address : varchar(255)
* password : varchar(255)
* created_at : datetime
v esxlegacy_a3a893 okp_email_emails
* id : int(11)
* sender : varchar(255)
* recipients : longtext
* subject : varchar(255)
* body : text
* actions : longtext
* created_at : datetime
v esxlegacy_a3a893 okp_email_recipients
* id : int(11)
* email_id : int(11)
* recipient_email : varchar(255)
* read : tinyint(1)
v esxlegacy_a3a893 okp_marketplace_ads
* id : varchar(36)
* title : varchar(100)
* description : text
* price : int(11)
* img : varchar(255)
* phone_number : varchar(255)
* creator : varchar(255)
* expiration : datetime(3)
* created_at : datetime(3)
v esxlegacy_a3a893 okp_news_articles
* id : int(11)
* featured : tinyint(1)
* important : tinyint(1)
* title : varchar(500)
* body : text
* author : varchar(255)
* created_at : datetime
v esxlegacy_a3a893 okp_racing_participants
* raceId : int(11) unsigned
* userId : int(11) unsigned
* time : int(11) unsigned
v esxlegacy_a3a893 okp_racing_races
* id : int(10) unsigned
* type : enum('public','private')
* entry_fee : int(10) unsigned
* zone_name : varchar(255)
* winner_id : int(10) unsigned
* prize : int(10) unsigned
* winning_time : int(10) unsigned
* created_at : datetime
v esxlegacy_a3a893 okp_racing_routes
* id : int(10) unsigned
* title : varchar(255)
* zone_name : varchar(255)
* checkpoints : longtext
* creator_id : int(10) unsigned
v esxlegacy_a3a893 okp_racing_stats
* id : int(10) unsigned
* name : varchar(255)
* char_id : varchar(255)
* avatar : text
* elo : int(10) unsigned
* earnings : int(10) unsigned
* races : int(10) unsigned
* wins : int(10) unsigned
* losses : int(10) unsigned
* pending_balance : int(10) unsigned
v esxlegacy_a3a893 okp_v_accounts
* username : varchar(50)
* password : varchar(255)
* verified : tinyint(1)
* moderator : tinyint(1)
* avatar : varchar(255)
* name : varchar(50)
* bio : varchar(150)
* background : varchar(255)
* following : longtext
* followers : longtext
* creator_license : varchar(255)
* created_at : datetime(3)
v esxlegacy_a3a893 okp_v_chats
* id : varchar(36)
* author : varchar(255)
* partner : varchar(255)
* created_at : datetime(3)
v esxlegacy_a3a893 okp_v_comments
* id : varchar(36)
* post_id : varchar(36)
* author : varchar(255)
* text : varchar(255)
* likes : longtext
* media : longtext
* created_at : datetime(3)
v esxlegacy_a3a893 okp_v_posts
* id : varchar(36)
* author : varchar(255)
* text : varchar(300)
* likes : longtext
* comments : int(10) unsigned
* tags : longtext
* media : longtext
* timestamp : datetime(3)
v esxlegacy_a3a893 okp_v_shorts
* id : varchar(36)
* author : varchar(255)
* title : varchar(255)
* description : varchar(255)
* likes : longtext
* comments : int(11)
* src : mediumtext
* created_at : datetime(3)
v esxlegacy_a3a893 okp_v_stories
* id : int(10) unsigned
* username : varchar(50)
* media_src : text
* media_type : varchar(50)
* caption : varchar(255)
* metadata : longtext
* created_at : datetime
* expires_at : datetime
v esxlegacy_a3a893 okp_v_story_likes
* id : int(10) unsigned
* story_id : int(10) unsigned
* username : varchar(50)
* created_at : datetime
v esxlegacy_a3a893 okp_work_job_applications
* id : int(10) unsigned
* job : varchar(255)
* status : enum('pending','rejected','approved')
* author : varchar(255)
* author_char_id : varchar(255)
* author_phone_number : varchar(255)
* content : text
* created_at : datetime
v esxlegacy_a3a893 okp_work_news
* id : int(10) unsigned
* job_name : varchar(255)
* featured : tinyint(4)
* author : varchar(255)
* creator_license : varchar(255)
* title : varchar(255)
* content : text
* created_at : datetime
v esxlegacy_a3a893 owned_vehicles
* owner : varchar(60)
* plate : varchar(12)
* vehicle : longtext
* type : varchar(20)
* job : varchar(20)
* stored : tinyint(1)
* parking : varchar(60)
* doorcondition : varchar(255)
* windowcondition : varchar(255)
* tyrecondition : varchar(255)
* favourite : tinyint(1)
* impoundTime : varchar(255)
* location : varchar(255)
* reason : varchar(255)
* sharedwith : longtext
* balance : int(11)
* paymentamount : int(11)
* paymentsleft : int(11)
* financetime : int(11)
* vehiclemileage : int(11)
* vehiclestatus : longtext
* vehiclenitrouslevel : longtext
* vehiclestance : longtext
* vehicleengine : longtext
* vehicletuning : longtext
* vpcname : varchar(128)
* mileage : float
* glovebox : longtext
* trunk : longtext
v esxlegacy_a3a893 ox_inventory
* owner : varchar(60)
* name : varchar(100)
* data : longtext
* lastupdated : timestamp
v esxlegacy_a3a893 playerskins
* id : int(11)
* citizenid : varchar(255)
* model : varchar(255)
* skin : longtext
* active : tinyint(4)
v esxlegacy_a3a893 playerstattoos
* id : int(11)
* identifier : varchar(255)
* tattoos : varchar(255)
v esxlegacy_a3a893 player_outfits
* id : int(11)
* citizenid : varchar(50)
* outfitname : varchar(50)
* model : varchar(50)
* props : varchar(1000)
* components : varchar(1500)
v esxlegacy_a3a893 player_outfit_codes
* id : int(11)
* outfitid : int(11)
* code : varchar(50)
v esxlegacy_a3a893 rented_vehicles
* vehicle : varchar(60)
* plate : varchar(12)
* player_name : varchar(255)
* base_price : int(11)
* rent_price : int(11)
* owner : varchar(46)
v esxlegacy_a3a893 renzu_clothes_outfits
* id : int(11)
* identifier : varchar(64)
* outfits : longtext
v esxlegacy_a3a893 renzu_customs
* shop : varchar(64)
* inventory : longtext
v esxlegacy_a3a893 roadshop_accounts
* id : int(11)
* identifier : varchar(80)
* firstname : varchar(20)
* lastname : varchar(20)
* mail : varchar(80)
* birth : varchar(50)
* password : varchar(256)
* profile : varchar(265)
* created : timestamp
v esxlegacy_a3a893 roadshop_advertising
* id : int(11)
* identifier : varchar(80)
* number : varchar(50)
* title : varchar(20)
* text : varchar(120)
* image : varchar(800)
* date : timestamp
v esxlegacy_a3a893 roadshop_banktransfer
* id : int(11)
* sender : varchar(30)
* receiver : varchar(30)
* reason : varchar(50)
* amount : int(11)
* date : timestamp
v esxlegacy_a3a893 roadshop_blocked_numbers
* id : int(11)
* identifier : varchar(80)
* numbers : longtext
v esxlegacy_a3a893 roadshop_calls
* id : int(11)
* identifier : varchar(80)
* number : varchar(50)
* isincoming : int(2)
* anonym : int(2)
* date : timestamp
v esxlegacy_a3a893 roadshop_camera
* id : int(11)
* identifier : varchar(80)
* picture : longtext
* isFavourite : int(2)
* isDeleted : int(2)
* time : timestamp
v esxlegacy_a3a893 roadshop_connect_accounts
* id : int(11)
* firstname : varchar(50)
* lastname : varchar(50)
* username : varchar(30)
* password : longtext
* avatar_url : longtext
* follower : longtext
* follows : longtext
* verify : int(2)
* date : timestamp
v esxlegacy_a3a893 roadshop_connect_comment
* id : int(11)
* authorId : int(11)
* postid : int(11)
* message : varchar(500)
* date : timestamp
v esxlegacy_a3a893 roadshop_connect_likes
* id : int(11)
* authorId : int(11)
* post : int(11)
v esxlegacy_a3a893 roadshop_connect_posts
* id : int(11)
* authorId : int(11)
* identifier : varchar(80)
* message : longtext
* picture : longtext
* filter : varchar(80)
* date : timestamp
* likes : int(11)
v esxlegacy_a3a893 roadshop_connect_storys
* id : int(11)
* authorId : int(11)
* image : varchar(400)
* viewed : int(2)
* time : timestamp
v esxlegacy_a3a893 roadshop_contacts
* id : int(11)
* identifier : varchar(80)
* firstname : varchar(12)
* lastname : varchar(12)
* number : varchar(30)
* picture : varchar(512)
* company : varchar(20)
* note : varchar(256)
* mail : varchar(50)
* favourite : int(2)
v esxlegacy_a3a893 roadshop_darkchat_groups
* id : int(11)
* name : varchar(25)
* members : longtext
v esxlegacy_a3a893 roadshop_darkchat_group_messages
* id : int(11)
* groupname : varchar(25)
* sender : varchar(80)
* message : longtext
* members : longtext
* date : timestamp
v esxlegacy_a3a893 roadshop_data
* id : int(11)
* identifier : varchar(80)
* tabletsetup : int(2)
* phonesetup : int(2)
* crypto : varchar(512)
v esxlegacy_a3a893 roadshop_group_messages
* id : int(11)
* owner : varchar(80)
* identifier : varchar(80)
* name : varchar(25)
* image : varchar(255)
* members : longtext
v esxlegacy_a3a893 roadshop_jobs
* id : int(11)
* sender : varchar(50)
* job : varchar(30)
* message : varchar(120)
* date : timestamp
* gps : varchar(500)
* status : int(2)
v esxlegacy_a3a893 roadshop_livestream_accounts
* id : int(11)
* identifier : varchar(80)
* username : varchar(20)
* password : varchar(64)
* avatar_url : varchar(512)
* date : timestamp
v esxlegacy_a3a893 roadshop_mails
* id : int(11)
* sender : varchar(50)
* sendermail : varchar(80)
* receivermail : varchar(80)
* receiver : varchar(80)
* title : varchar(80)
* message : longtext
* image : varchar(120)
* button : text
* isSystem : int(2)
* read : int(2)
* date : timestamp
v esxlegacy_a3a893 roadshop_messages
* id : int(11)
* sender : varchar(50)
* receiver : varchar(50)
* message : longtext
* date : timestamp
* isOwner : int(11)
* isRead : int(11)
v esxlegacy_a3a893 roadshop_messages_groups_message
* id : int(11)
* groupid : int(11)
* sender : varchar(80)
* message : longtext
* members : longtext
* date : timestamp
v esxlegacy_a3a893 roadshop_music_playlists
* id : int(11)
* identifier : varchar(80)
* title : varchar(25)
* image : varchar(265)
v esxlegacy_a3a893 roadshop_music_playlists_songs
* id : int(11)
* playlistId : int(11)
* songid : varchar(50)
* song : varchar(200)
* artist : varchar(200)
* image : varchar(265)
* length : varchar(200)
v esxlegacy_a3a893 roadshop_news
* id : int(11)
* identifier : varchar(80)
* number : varchar(30)
* title : varchar(20)
* text : varchar(120)
* image : varchar(800)
* date : timestamp
v esxlegacy_a3a893 roadshop_notes
* id : int(11)
* identifier : varchar(80)
* title : varchar(30)
* text : longtext
* isPinned : tinyint(1)
* date : timestamp
v esxlegacy_a3a893 roadshop_notifications
* id : int(11)
* identifier : varchar(80)
* apptitle : varchar(80)
* title : varchar(80)
* message : longtext
* img : varchar(512)
v esxlegacy_a3a893 roadshop_service_messages
* id : int(11)
* sender : varchar(80)
* receiver : varchar(80)
* message : longtext
* date : timestamp
* isOwner : int(11)
* isRead : int(11)
* isDispatch : int(11)
* isAccepted : int(11)
* isFinished : int(11)
* isDeclined : int(11)
* isAnonym : int(11)
* image : longtext
* coords : varchar(512)
v esxlegacy_a3a893 roadshop_tellonym_accounts
* id : int(11)
* identifier : varchar(80)
* username : varchar(20)
* mail : varchar(80)
* password : varchar(64)
* avatar_url : varchar(512)
* date : timestamp
v esxlegacy_a3a893 roadshop_tellonym_tells
* id : int(11)
* senderId : int(11)
* receiverId : int(11)
* text : longtext
* date : timestamp
v esxlegacy_a3a893 roadshop_tellonym_tells_answered
* id : int(11)
* senderId : int(11)
* userId : int(11)
* question : longtext
* answer : longtext
* date : timestamp
* likes : int(11)
v esxlegacy_a3a893 roadshop_tweetwave_accounts
* id : int(11)
* username : varchar(50)
* password : varchar(64)
* avatar_url : longtext
* verify : int(2)
* date : timestamp
v esxlegacy_a3a893 roadshop_tweetwave_comment
* id : int(11)
* authorId : int(11)
* postid : int(11)
* message : varchar(500)
* date : timestamp
v esxlegacy_a3a893 roadshop_tweetwave_likes
* id : int(11)
* authorId : int(11)
* tweetId : int(11)
v esxlegacy_a3a893 roadshop_tweetwave_tweets
* id : int(11)
* authorId : int(11)
* realUser : varchar(50)
* message : varchar(256)
* image : longtext
* time : timestamp
* likes : int(11)
v esxlegacy_a3a893 roadshop_voice_memos
* id : int(11)
* identifier : varchar(80)
* name : varchar(30)
* text : varchar(255)
* date : timestamp
v esxlegacy_a3a893 robberies_creator_cargo_robberies
* id : int(11)
* label : varchar(50)
* blip_data : longtext
* data : longtext
v esxlegacy_a3a893 robberies_creator_heists
* id : int(11)
* label : varchar(100)
* minimum_police : int(11)
* timeout_minutes : int(11)
* minutes_before_reset : int(11)
* time_limit_minutes : int(11)
* stages : longtext
v esxlegacy_a3a893 robberies_creator_plannings
* id : int(11)
* label : varchar(50)
* data : longtext
* cargo_robbery_id : int(11)
* minimum_police : int(11)
v esxlegacy_a3a893 shops_creator_admin_shops
* id : int(11)
* label : varchar(50)
* data : longtext
v esxlegacy_a3a893 shops_creator_players_shops
* id : int(11)
* label : varchar(50)
* price : int(11)
* data : longtext
* owner : varchar(100)
* employees_data : longtext
* stored_money : int(11)
* owner_label : varchar(100)
* is_open : tinyint(4)
* last_robbed : int(11)
v esxlegacy_a3a893 shops_creator_players_shops_objects
* id : int(11)
* name : varchar(100)
* type : varchar(50)
* quantity : int(11)
* price : int(11)
* method : varchar(50)
* shop_id : int(11)
v esxlegacy_a3a893 shops_creator_players_shops_storages
* id : int(11)
* name : varchar(100)
* type : varchar(50)
* quantity : int(11)
* shop_id : int(11)
v esxlegacy_a3a893 society_moneywash
* id : int(11)
* identifier : varchar(60)
* society : varchar(60)
* amount : int(11)
v esxlegacy_a3a893 tuning_upgrades
* id : int(11)
* zone : varchar(32)
* name : varchar(64)
* cost : int(11)
* created_at : timestamp
v esxlegacy_a3a893 users
* identifier : varchar(100)
* accounts : longtext
* group : varchar(50)
* inventory : longtext
* job : varchar(20)
* job_grade : int(11)
* loadout : longtext
* position : varchar(255)
* firstname : varchar(50)
* lastname : varchar(50)
* dateofbirth : varchar(25)
* sex : varchar(10)
* height : varchar(5)
* skin : longtext
* ssn : varchar(50)
* metadata : longtext
* woundData : text
* last_property : longtext
* status : longtext
* is_dead : tinyint(1)
* callsign : varchar(250)
* pincode : int(11)
v esxlegacy_a3a893 user_jobs
* id : int(11)
* identifier : varchar(60)
* job_name : varchar(50)
* job_grade : int(11)
v esxlegacy_a3a893 user_licenses
* id : int(11)
* type : varchar(60)
* owner : varchar(60)
v esxlegacy_a3a893 vehicles
* name : varchar(60)
* model : varchar(60)
* price : int(11)
* category : varchar(60)
v esxlegacy_a3a893 vehicle_categories
* name : varchar(60)
* label : varchar(60)
v esxlegacy_a3a893 vehicle_sold
* id : int(11)
* client : varchar(50)
* model : varchar(50)
* plate : varchar(50)
* soldby : varchar(50)
* date : varchar(50)
v esxlegacy_a3a893 vehicle_tuning
* id : int(11)
* plate : varchar(32)
* mods : text
* created_at : timestamp
* nitrous : int(3)
* hasNitrous : int(1)
v esxlegacy_a3a893 vpcls
* playerId : varchar(80)
* coordsx : varchar(25)
* coordsy : varchar(25)
* NET : varchar(10)
v esxlegacy_a3a893 whitelist
* identifier : varchar(60)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship