Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
v v
Número de tablas: 0
v ale1 2na_casino
* identifier : varchar(50)
* balance : double
v ale1 5s_migrations
* id : int(11)
* resourceName : varchar(255)
* migrationVersion : varchar(255)
* insertDate : timestamp
v ale1 addon_account
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v ale1 addon_account_data
* id : int(11)
* account_name : varchar(100)
* money : int(11)
* owner : varchar(60)
v ale1 addon_inventory
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v ale1 addon_inventory_items
* id : int(11)
* inventory_name : varchar(100)
* name : varchar(100)
* count : int(11)
* owner : varchar(60)
v ale1 ale_benefits_state
* identifier : varchar(60)
* vip_last_granted : tinyint(4)
* vip_last_granted_at : datetime
* boost_last_granted : tinyint(4)
* boost_last_granted_at : datetime
v ale1 ale_boosts
* identifier : varchar(60)
* level : tinyint(4)
* added_by : varchar(60)
* added_at : datetime
v ale1 ale_camion_leaderboard
* gang : varchar(64)
* points : int(11)
* last_update : timestamp
v ale1 ale_drug_leaderboard
* gang : varchar(64)
* mari : int(11)
* coca : int(11)
* meta : int(11)
* global : int(11)
* updated_at : timestamp
v ale1 ale_duty_hours
* id : int(11)
* faction : varchar(50)
* identifier : varchar(64)
* firstname : varchar(50)
* lastname : varchar(50)
* playerName : varchar(100)
* grade : int(11)
* grade_label : varchar(80)
* hours_seconds : bigint(20)
* updated_at : timestamp
v ale1 ale_faction_garages
* id : int(11)
* owner_type : enum('gang','job')
* owner_key : varchar(64)
* label : varchar(64)
* zones : longtext
* vehicles : longtext
* color : longtext
* enabled : tinyint(1)
* updated_by : varchar(64)
* updated_at : timestamp
v ale1 ale_facturas_points
* id : int(11)
* job_name : varchar(64)
* label : varchar(60)
* x : double
* y : double
* z : double
* heading : float
* enabled : tinyint(1)
* invoice_enabled : tinyint(1)
* withdraw_enabled : tinyint(1)
* created_by : varchar(64)
* created_at : timestamp
v ale1 ale_gangs
* identifier : varchar(60)
* gang : varchar(32)
* updated_by : varchar(60)
* updated_at : datetime
v ale1 ale_gang_bases
* gang : varchar(64)
* label : varchar(64)
* coords : longtext
* sprite : int(11)
* color : int(11)
* scale : float
* enabled : tinyint(1)
* updated_by : varchar(64)
* updated_at : timestamp
v ale1 ale_gang_defs
* gang : varchar(64)
* label : varchar(64)
* f6_enabled : tinyint(1)
* search_enabled : tinyint(1)
* confiscation_enabled : tinyint(1)
* cuff_item : varchar(64)
* created_at : timestamp
* updated_at : timestamp
* boss_enabled : tinyint(1)
* hq_enabled : tinyint(1)
* hq_actions_enabled : tinyint(1)
* hq_bossstash_enabled : tinyint(1)
* hq_sharedstash_enabled : tinyint(1)
* hq_accessories_enabled : tinyint(1)
* hq_garage_enabled : tinyint(1)
v ale1 ale_gang_drop_points
* gang : varchar(64)
* points : int(11)
* updated_at : timestamp
v ale1 ale_gang_members
* identifier : varchar(128)
* gang : varchar(64)
* updated_by : varchar(64)
* updated_at : timestamp
* last_name : varchar(64)
* last_fivem : varchar(64)
* rank : tinyint(2)
v ale1 ale_gang_stashes
* id : int(11)
* gang : varchar(64)
* stash_code : varchar(128)
* label : varchar(64)
* owner : tinyint(1)
* slots : int(11)
* max_weight : int(11)
* coords : longtext
* radius : float
* enabled : tinyint(1)
* created_at : timestamp
* min_rank : tinyint(1)
v ale1 ale_gang_webhooks
* gang : varchar(64)
* stash_enabled : tinyint(1)
* stash_url : varchar(255)
* updated_by : varchar(64)
* updated_at : timestamp
v ale1 ale_garbage_players
* id : int(11)
* identifier : varchar(255)
* characterName : varchar(255)
* exp : int(11)
* photo : int(11)
* created_at : timestamp
* updated_at : timestamp
v ale1 ale_logs
* id : int(11)
* event_type : varchar(64)
* author : varchar(128)
* message : text
* created_at : datetime
v ale1 ale_mdt_arananlar
* citizenid : varchar(50)
* sebep : longtext
* baslangic : varchar(255)
* bitis : varchar(255)
* isim : varchar(255)
* img : longtext
v ale1 ale_mdt_cezalar
* id : int(11)
* citizenid : varchar(50)
* aciklama : longtext
* ceza : varchar(255)
* polis : mediumtext
* zanli : mediumtext
* cezalar : longtext
* olayid : int(11)
v ale1 ale_mdt_olaylar
* id : int(11)
* aciklama : longtext
* polis : mediumtext
* zanli : mediumtext
* zaman : varchar(50)
* esyalar : mediumtext
v ale1 ale_metadata
* id : varchar(255)
* data : longtext
v ale1 ale_org_ranking
* gang : varchar(64)
* label : varchar(100)
* robos : int(11)
* lavados : int(11)
* camion : int(11)
* drops : int(11)
* territorios : int(11)
* drogas : int(11)
* drogas_mari : int(11)
* drogas_coca : int(11)
* drogas_meta : int(11)
* total : int(11)
* updated_at : timestamp
v ale1 ale_org_ranking_logs
* id : bigint(20) unsigned
* gang : varchar(64)
* label : varchar(100)
* category : varchar(32)
* subtype : varchar(64)
* action : varchar(120)
* points : int(11)
* amount : int(11)
* player_identifier : varchar(100)
* player_name : varchar(100)
* source_id : int(11)
* description : text
* created_at : timestamp
v ale1 ale_pasebatalla
* owner : varchar(72)
* battlepass : longtext
* lastupdated : timestamp
v ale1 ale_peds
* identifier : varchar(50)
* peds : longtext
v ale1 ale_racing
* identifier : varchar(50)
* routes : longtext
* racehistory : longtext
* win : int(11)
* lose : int(11)
* favouritecar : longtext
* distance : bigint(20)
* charname : varchar(50)
* incomingrace : int(11)
* lastrace : varchar(50)
* playerphoto : longtext
v ale1 ale_robos_leaderboard
* gang : varchar(64)
* points : int(11)
* updated_at : timestamp
v ale1 ale_roles_audit
* id : int(11)
* action : varchar(32)
* staff_identifier : varchar(60)
* staff_group : varchar(50)
* target_identifier : varchar(60)
* payload : longtext
* created_at : datetime
v ale1 ale_staff
* identifier : varchar(80)
* name : varchar(100)
* fivem_name : varchar(100)
* staff_group : varchar(30)
* active : tinyint(1)
* join_skip : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v ale1 ale_streamers
* identifier : varchar(60)
* enabled : tinyint(1)
* added_by : varchar(60)
* added_at : datetime
* name : varchar(100)
v ale1 ale_vips
* identifier : varchar(60)
* level : tinyint(4)
* expires_at : datetime
* added_by : varchar(60)
* added_at : datetime
v ale1 animation_menu_players
* id : int(11)
* identifier : varchar(255)
* walkstyle : varchar(255)
* expression : varchar(255)
v ale1 banking
* identifier : varchar(46)
* type : varchar(50)
* amount : int(64)
* time : bigint(20)
* ID : int(11)
* balance : int(11)
* label : varchar(255)
v ale1 bansys_security
* identifier : varchar(100)
* count : int(11)
* lastOffense : int(11)
* warnings : text
* createdAt : timestamp
* updatedAt : timestamp
v ale1 ban_system
* id : int(11)
* ban_id : varchar(12)
* identifiers : text
* target_name : varchar(255)
* reason : text
* admin_name : varchar(255)
* admin_identifier : varchar(100)
* ban_date : timestamp
* unban_date : timestamp
* is_active : tinyint(1)
* duration : varchar(50)
v ale1 billing
* id : int(11)
* identifier : varchar(60)
* sender : varchar(60)
* target_type : varchar(50)
* target : varchar(40)
* label : varchar(255)
* amount : int(11)
v ale1 cardealer_vehicles
* id : int(11)
* vehicle : varchar(255)
* price : int(11)
v ale1 casino_blocked_players
* id : int(11)
* identifier : varchar(90)
* reason : text
v ale1 casino_inside
* identifier : varchar(80)
* inside : varchar(64)
v ale1 casino_jackpot_screens
* id : int(11)
* x : double
* y : double
* z : double
* heading : double
v ale1 casino_jackpot_winners
* id : int(11)
* identifier : varchar(80)
* name : varchar(80)
* amount : bigint(20)
* won_at : timestamp
v ale1 casino_memberships
* id : int(11)
* identifier : varchar(90)
* chips : int(11)
* vip : tinyint(1)
* luckywheel_date : timestamp
* chip_buy_date : timestamp
v ale1 casino_store
* name : varchar(64)
* data : longtext
v ale1 communityservice
* identifier : varchar(100)
* actions_remaining : int(10)
v ale1 datastore
* name : varchar(60)
* label : varchar(100)
* shared : int(11)
v ale1 datastore_data
* id : int(11)
* name : varchar(60)
* owner : varchar(60)
* data : longtext
v ale1 electus_pets
* identifier : varchar(46)
* model : varchar(25)
* name : varchar(50)
* status : varchar(100)
* skills : varchar(100)
* abilities : varchar(255)
* variation : varchar(50)
* accessories : varchar(255)
* sniffedItems : varchar(255)
* bagLock : varchar(100)
* sex : varchar(1)
* breedingSeed : int(11)
* numOfBreedings : int(2)
* deadAt : int(11)
* stored : int(11)
* bornAt : int(11)
* growthPausedAt : int(11)
v ale1 electus_pets_daily_data
* lastReset : int(11) unsigned
v ale1 electus_pets_daily_tasks
* identifier : varchar(46)
* name : varchar(50)
* dailyTasks : longtext
v ale1 electus_pets_friends
* identifier : varchar(46)
* friends : longtext
* jobs : longtext
v ale1 electus_pets_houses
* id : int(11)
* identifier : varchar(46)
* houseType : varchar(50)
* coords : varchar(100)
v ale1 esx_mechanicjob_tuneo_resets
* id : int(11)
* job : varchar(50)
* reset_by_identifier : varchar(60)
* reset_by_name : varchar(100)
* snapshot_json : longtext
* created_at : timestamp
v ale1 esx_mechanicjob_tuneo_totals
* job : varchar(50)
* identifier : varchar(60)
* name : varchar(100)
* total : int(11)
* count : int(11)
* updated_at : timestamp
v ale1 fine_types
* id : int(11)
* label : varchar(255)
* amount : int(11)
* category : int(11)
v ale1 fyac_ban
* player : varchar(50)
* license : varchar(50)
* identifier : varchar(46)
* liveid : varchar(21)
* xblid : varchar(21)
* discord : varchar(30)
* playerip : varchar(25)
* reason : varchar(255)
v ale1 fyac_info
* hex : varchar(50)
* job : varchar(50)
* event : varchar(50)
* sebep : varchar(50)
* zaman : varchar(50)
v ale1 graffiti
* id : int(11)
* x : float
* y : float
* z : float
* banda : varchar(50)
v ale1 items
* name : varchar(50)
* label : varchar(50)
* weight : int(11)
* rare : tinyint(4)
* can_remove : tinyint(4)
v ale1 jobs
* name : varchar(50)
* label : varchar(50)
* type : varchar(50)
* whitelisted : tinyint(1)
* handyservice : varchar(2)
* hasapp : int(2)
* onlyboss : int(2)
v ale1 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
* type : varchar(50)
v ale1 lbracing_accounts
* id : varchar(100)
* username : varchar(100)
* avatar : varchar(500)
* public_profile : tinyint(1)
* rating : int(10) unsigned
* races_won : int(10) unsigned
* races_played : int(10) unsigned
* money_won : int(10) unsigned
* last_race : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
v ale1 lbracing_converted_scripts
* script_name : varchar(100)
v ale1 lbracing_liked_tracks
* track_id : int(10) unsigned
* player_id : varchar(100)
v ale1 lbracing_races
* id : int(10) unsigned
* host : varchar(100)
* race_name : varchar(100)
* track_id : int(10) unsigned
* vehicle_tiers : text
* vehicle_class : varchar(100)
* vehicle_model : int(11)
* laps : tinyint(3) unsigned
* starting_prize : int(10) unsigned
* entry_fee : int(10) unsigned
* payment_method : varchar(50)
* commission : tinyint(3) unsigned
* prize_distribution : text
* participants : tinyint(3) unsigned
* min_participants : tinyint(3) unsigned
* max_participants : tinyint(3) unsigned
* require_sign_up : tinyint(1)
* invite_only : tinyint(1)
* collision : tinyint(1)
* first_person_only : tinyint(1)
* personal_vehicle : tinyint(1)
* disable_npc_traffic : tinyint(1)
* assign_vehicle : tinyint(1)
* ranked : tinyint(1)
* min_rating : int(10) unsigned
* max_rating : int(10) unsigned
* finished : tinyint(1)
* canceled : tinyint(1)
* deleted : tinyint(1)
* start_date : datetime
* created_at : datetime
v ale1 lbracing_race_invites
* race_id : int(10) unsigned
* invitee_id : varchar(100)
* inviter_id : varchar(100)
* invite_date : datetime
v ale1 lbracing_race_participants
* race_id : int(10) unsigned
* participant_id : varchar(100)
* vehicle_tier : varchar(100)
* vehicle_model : int(11)
* placing : tinyint(3) unsigned
* rating_change : tinyint(4)
* finish_time : int(10) unsigned
v ale1 lbracing_repeating_races
* id : int(10) unsigned
* creator : varchar(100)
* original_race_id : int(10) unsigned
* latest_race_id : int(10) unsigned
* tracks : varchar(5000)
* repeat_minute_interval : mediumint(8) unsigned
* next_race_date : datetime
* start_time : smallint(5) unsigned
* created_at : datetime
v ale1 lbracing_tracks
* id : int(10) unsigned
* creator : varchar(100)
* track_name : varchar(100)
* vehicle_type : varchar(100)
* track_type : varchar(15)
* track_length : int(10) unsigned
* start_position : longtext
* checkpoints : longtext
* barriers : longtext
* uses : int(10) unsigned
* likes : int(10) unsigned
* created_at : timestamp
v ale1 lbracing_track_times
* id : int(10) unsigned
* track_id : int(10) unsigned
* race_id : int(10) unsigned
* player_id : varchar(100)
* lap_number : tinyint(3) unsigned
* lap_time : int(10) unsigned
* vehicle_tier : varchar(100)
* vehicle_model : int(11)
v ale1 licenses
* type : varchar(60)
* label : varchar(60)
v ale1 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 ale1 multicharacter_slots
* identifier : varchar(60)
* slots : int(11)
v ale1 noclip_permissions
* id : int(11)
* license : varchar(50)
* player_name : varchar(100)
* added_by : varchar(100)
* added_date : timestamp
* is_active : tinyint(1)
v ale1 origen_metadata
* id : varchar(255)
* data : longtext
v ale1 origen_police_alerts
* id : int(11)
* x : int(11)
* y : int(11)
* job : varchar(50)
v ale1 origen_police_ankle
* citizenid : varchar(50)
* policeOwner : varchar(50)
* date : timestamp
* lastShock : timestamp
v ale1 origen_police_bills
* id : int(11)
* citizenid : varchar(50)
* title : varchar(255)
* concepts : text
* price : int(11)
* job : varchar(50)
* author : varchar(255)
* payed : int(1)
* date : timestamp
* months : int(11)
* reportid : int(11)
v ale1 origen_police_clocks
* id : int(11)
* citizenid : varchar(60)
* name : varchar(50)
* clockin : varchar(50)
* clockout : varchar(50)
* minutes : int(11)
* job : varchar(50)
v ale1 origen_police_federal
* citizenid : varchar(50)
* time : int(11)
* initial : int(11)
* name : varchar(50)
* date : timestamp
* danger : varchar(50)
* joinedfrom : varchar(50)
* image : varchar(255)
v ale1 origen_police_notes
* id : int(11)
* citizenid : varchar(60)
* title : varchar(255)
* description : text
* author : varchar(255)
* date : timestamp
* fixed : int(1)
v ale1 origen_police_penalc
* id : int(11)
* title : varchar(255)
* description : varchar(255)
* price : int(11)
* month : int(11)
* cap : int(1)
* job : varchar(50)
v ale1 origen_police_reports
* id : int(11)
* title : varchar(255)
* description : text
* author : varchar(255)
* cops : text
* implicated : text
* date : timestamp
* evidences : text
* tags : text
* location : varchar(255)
* victims : mediumtext
* vehicles : mediumtext
* job : varchar(50)
v ale1 origen_police_shapes
* id : int(11)
* type : varchar(50)
* title : varchar(100)
* data : text
* radius : float
v ale1 outfits
* id : int(11)
* identifier : varchar(60)
* name : longtext
* ped : longtext
* components : longtext
* props : longtext
v ale1 owned_properties
* id : int(11)
* owner : varchar(60)
* name : varchar(255)
* address : varchar(255)
* coords : text
* created_at : timestamp
v ale1 owned_vehicles
* owner : varchar(60)
* plate : varchar(12)
* vehicle : longtext
* type : varchar(20)
* job : varchar(20)
* stored : tinyint(1)
* glovebox : longtext
* trunk : longtext
* carseller : int(11)
* wanted : int(1)
* billPrice : int(6)
* description : longtext
* parking : varchar(50)
v ale1 ox_doorlock
* id : int(11) unsigned
* name : varchar(50)
* data : longtext
v ale1 ox_inventory
* owner : varchar(60)
* name : varchar(100)
* data : longtext
* lastupdated : timestamp
v ale1 phone_backups
* id : varchar(100)
* phone_number : varchar(15)
v ale1 phone_clock_alarms
* id : int(10) unsigned
* phone_number : varchar(15)
* hours : int(2)
* minutes : int(2)
* label : varchar(50)
* enabled : tinyint(1)
v ale1 phone_crypto
* id : varchar(100)
* coin : varchar(15)
* amount : double
* invested : int(11)
v ale1 phone_crypto_coins
* coin : varchar(15)
* coin_value : double unsigned
v ale1 phone_darkchat_accounts
* phone_number : varchar(15)
* username : varchar(20)
* password : varchar(100)
v ale1 phone_darkchat_channels
* name : varchar(50)
* password : varchar(100)
v ale1 phone_darkchat_members
* channel_name : varchar(50)
* username : varchar(20)
v ale1 phone_darkchat_messages
* id : int(11)
* channel : varchar(50)
* sender : varchar(20)
* content : varchar(1000)
* timestamp : timestamp
v ale1 phone_instagram_accounts
* display_name : varchar(30)
* username : varchar(20)
* password : varchar(100)
* profile_image : varchar(500)
* bio : varchar(100)
* post_count : int(11)
* story_count : int(11)
* follower_count : int(11)
* following_count : int(11)
* phone_number : varchar(15)
* private : tinyint(1)
* verified : tinyint(1)
* date_joined : timestamp
v ale1 phone_instagram_comments
* id : varchar(10)
* post_id : varchar(50)
* username : varchar(20)
* comment : varchar(500)
* like_count : int(11)
* timestamp : timestamp
v ale1 phone_instagram_follows
* followed : varchar(20)
* follower : varchar(20)
v ale1 phone_instagram_follow_requests
* requester : varchar(20)
* requestee : varchar(20)
* timestamp : timestamp
v ale1 phone_instagram_likes
* id : varchar(10)
* username : varchar(20)
* is_comment : tinyint(1)
v ale1 phone_instagram_messages
* id : varchar(10)
* sender : varchar(20)
* recipient : varchar(20)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v ale1 phone_instagram_notifications
* id : varchar(10)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* post_id : varchar(50)
* timestamp : timestamp
v ale1 phone_instagram_posts
* id : varchar(10)
* media : text
* caption : varchar(500)
* location : varchar(50)
* like_count : int(11)
* comment_count : int(11)
* username : varchar(20)
* timestamp : timestamp
v ale1 phone_instagram_stories
* id : varchar(10)
* username : varchar(20)
* image : varchar(500)
* metadata : longtext
* timestamp : timestamp
v ale1 phone_instagram_stories_views
* story_id : varchar(50)
* viewer : varchar(20)
* timestamp : timestamp
v ale1 phone_last_phone
* id : varchar(100)
* phone_number : varchar(15)
v ale1 phone_logged_in_accounts
* phone_number : varchar(15)
* app : varchar(50)
* username : varchar(100)
* active : tinyint(1)
v ale1 phone_mail_accounts
* address : varchar(100)
* password : varchar(100)
v ale1 phone_mail_deleted
* message_id : int(10) unsigned
* address : varchar(100)
v ale1 phone_mail_messages
* id : int(10) unsigned
* recipient : varchar(100)
* sender : varchar(100)
* subject : varchar(100)
* content : text
* attachments : longtext
* actions : longtext
* read : tinyint(1)
* timestamp : timestamp
v ale1 phone_maps_locations
* id : int(10) unsigned
* phone_number : varchar(15)
* name : varchar(50)
* x_pos : float
* y_pos : float
v ale1 phone_marketplace_posts
* id : int(11)
* phone_number : varchar(15)
* title : varchar(50)
* description : varchar(1000)
* attachments : text
* price : int(11)
* timestamp : timestamp
v ale1 phone_message_channels
* id : int(11)
* is_group : tinyint(1)
* name : varchar(50)
* last_message : varchar(50)
* last_message_timestamp : timestamp
v ale1 phone_message_members
* channel_id : int(11)
* phone_number : varchar(15)
* is_owner : tinyint(1)
* deleted : tinyint(1)
* unread : int(11)
v ale1 phone_message_messages
* id : int(11)
* channel_id : int(11)
* sender : varchar(15)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v ale1 phone_message_reactions
* message_id : int(11)
* phone_number : varchar(15)
* reaction : varchar(50)
v ale1 phone_music_playlists
* id : int(10) unsigned
* phone_number : varchar(15)
* name : varchar(50)
* cover : varchar(500)
v ale1 phone_music_saved_playlists
* playlist_id : int(10) unsigned
* phone_number : varchar(15)
v ale1 phone_music_songs
* song_id : varchar(100)
* playlist_id : int(10) unsigned
v ale1 phone_notes
* id : int(10) unsigned
* phone_number : varchar(15)
* title : varchar(50)
* content : longtext
* timestamp : timestamp
v ale1 phone_notifications
* id : int(11)
* phone_number : varchar(15)
* app : varchar(50)
* title : varchar(50)
* content : varchar(500)
* thumbnail : varchar(500)
* avatar : varchar(500)
* show_avatar : tinyint(1)
* custom_data : text
* timestamp : timestamp
v ale1 phone_phones
* id : varchar(100)
* owner_id : varchar(100)
* phone_number : varchar(15)
* name : varchar(50)
* pin : varchar(4)
* face_id : varchar(100)
* settings : longtext
* is_setup : tinyint(1)
* assigned : tinyint(1)
* battery : int(11)
* last_seen : timestamp
v ale1 phone_phone_blocked_numbers
* phone_number : varchar(15)
* blocked_number : varchar(15)
v ale1 phone_phone_calls
* id : int(10) unsigned
* caller : varchar(15)
* callee : varchar(15)
* duration : int(11)
* answered : tinyint(1)
* hide_caller_id : tinyint(1)
* timestamp : timestamp
v ale1 phone_phone_contacts
* contact_phone_number : varchar(15)
* firstname : varchar(50)
* lastname : varchar(50)
* profile_image : varchar(500)
* email : varchar(50)
* address : varchar(50)
* favourite : tinyint(1)
* phone_number : varchar(15)
v ale1 phone_phone_voicemail
* id : int(10) unsigned
* caller : varchar(15)
* callee : varchar(15)
* url : varchar(500)
* duration : int(11)
* hide_caller_id : tinyint(1)
* timestamp : timestamp
v ale1 phone_photos
* id : int(11)
* phone_number : varchar(15)
* is_video : tinyint(1)
* size : float
* metadata : varchar(20)
* is_favourite : tinyint(1)
* timestamp : timestamp
v ale1 phone_photo_albums
* id : int(11)
* phone_number : varchar(15)
* title : varchar(100)
* shared : tinyint(1)
v ale1 phone_photo_album_members
* album_id : int(11)
* phone_number : varchar(15)
v ale1 phone_photo_album_photos
* album_id : int(11)
* photo_id : int(11)
v ale1 phone_services_channels
* id : int(10) unsigned
* phone_number : varchar(15)
* company : varchar(50)
* last_message : varchar(100)
* timestamp : timestamp
v ale1 phone_services_messages
* id : int(10) unsigned
* channel_id : int(10) unsigned
* sender : varchar(15)
* message : varchar(1000)
* x_pos : int(11)
* y_pos : int(11)
* timestamp : timestamp
v ale1 phone_tiktok_accounts
* name : varchar(30)
* bio : varchar(100)
* avatar : varchar(500)
* username : varchar(20)
* password : varchar(100)
* verified : tinyint(1)
* follower_count : int(11)
* following_count : int(11)
* like_count : int(11)
* video_count : int(11)
* twitter : varchar(20)
* instagram : varchar(20)
* show_likes : tinyint(1)
* phone_number : varchar(15)
* date_joined : timestamp
v ale1 phone_tiktok_channels
* id : varchar(10)
* last_message : varchar(50)
* member_1 : varchar(20)
* member_2 : varchar(20)
* timestamp : timestamp
v ale1 phone_tiktok_comments
* id : varchar(10)
* reply_to : varchar(10)
* video_id : varchar(10)
* username : varchar(20)
* comment : varchar(550)
* likes : int(11)
* replies : int(11)
* timestamp : timestamp
v ale1 phone_tiktok_comments_likes
* username : varchar(20)
* comment_id : varchar(10)
v ale1 phone_tiktok_follows
* followed : varchar(20)
* follower : varchar(20)
v ale1 phone_tiktok_likes
* username : varchar(20)
* video_id : varchar(10)
v ale1 phone_tiktok_messages
* id : varchar(10)
* channel_id : varchar(10)
* sender : varchar(20)
* content : varchar(500)
* timestamp : timestamp
v ale1 phone_tiktok_notifications
* id : int(11)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* video_id : varchar(10)
* comment_id : varchar(10)
* timestamp : timestamp
v ale1 phone_tiktok_pinned_videos
* username : varchar(20)
* video_id : varchar(10)
v ale1 phone_tiktok_saves
* username : varchar(20)
* video_id : varchar(10)
v ale1 phone_tiktok_unread_messages
* username : varchar(20)
* channel_id : varchar(10)
* amount : int(11)
v ale1 phone_tiktok_videos
* id : varchar(10)
* username : varchar(20)
* src : varchar(500)
* caption : varchar(100)
* metadata : longtext
* music : text
* likes : int(11)
* comments : int(11)
* views : int(11)
* saves : int(11)
* pinned_comment : varchar(10)
* timestamp : timestamp
v ale1 phone_tiktok_views
* username : varchar(20)
* video_id : varchar(10)
v ale1 phone_tinder_accounts
* name : varchar(50)
* phone_number : varchar(15)
* photos : text
* bio : varchar(500)
* dob : date
* is_male : tinyint(1)
* interested_men : tinyint(1)
* interested_women : tinyint(1)
* active : tinyint(1)
* last_seen : datetime
v ale1 phone_tinder_matches
* phone_number_1 : varchar(15)
* phone_number_2 : varchar(15)
* latest_sender : varchar(15)
* latest_message : varchar(1000)
* latest_message_timestamp : timestamp
* phone_number_1_has_unread : tinyint(1)
* phone_number_2_has_unread : tinyint(1)
v ale1 phone_tinder_messages
* id : int(11)
* sender : varchar(15)
* recipient : varchar(15)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v ale1 phone_tinder_swipes
* swiper : varchar(15)
* swipee : varchar(15)
* liked : tinyint(1)
v ale1 phone_twitter_accounts
* display_name : varchar(30)
* username : varchar(20)
* password : varchar(100)
* phone_number : varchar(15)
* bio : varchar(100)
* profile_image : varchar(500)
* profile_header : varchar(500)
* pinned_tweet : varchar(50)
* verified : tinyint(1)
* follower_count : int(11)
* following_count : int(11)
* private : tinyint(1)
* date_joined : timestamp
v ale1 phone_twitter_follows
* followed : varchar(20)
* follower : varchar(20)
* notifications : tinyint(1)
v ale1 phone_twitter_follow_requests
* requester : varchar(20)
* requestee : varchar(20)
* timestamp : timestamp
v ale1 phone_twitter_hashtags
* hashtag : varchar(50)
* amount : int(11)
* last_used : timestamp
v ale1 phone_twitter_likes
* tweet_id : varchar(50)
* username : varchar(20)
* timestamp : timestamp
v ale1 phone_twitter_messages
* id : varchar(10)
* sender : varchar(20)
* recipient : varchar(20)
* content : varchar(1000)
* attachments : text
* timestamp : timestamp
v ale1 phone_twitter_notifications
* id : varchar(10)
* username : varchar(20)
* from : varchar(20)
* type : varchar(20)
* tweet_id : varchar(50)
* timestamp : timestamp
v ale1 phone_twitter_promoted
* tweet_id : varchar(50)
* promotions : int(11)
* views : int(11)
v ale1 phone_twitter_retweets
* tweet_id : varchar(50)
* username : varchar(20)
* timestamp : timestamp
v ale1 phone_twitter_tweets
* id : varchar(10)
* username : varchar(20)
* content : varchar(280)
* attachments : text
* reply_to : varchar(50)
* like_count : int(11)
* reply_count : int(11)
* retweet_count : int(11)
* timestamp : timestamp
v ale1 phone_voice_memos_recordings
* id : int(11)
* phone_number : varchar(15)
* file_name : varchar(50)
* file_url : varchar(500)
* file_length : int(11)
* created_at : timestamp
v ale1 phone_wallet_transactions
* id : int(11)
* phone_number : varchar(15)
* amount : int(11)
* company : varchar(50)
* timestamp : timestamp
v ale1 phone_yellow_pages_posts
* id : int(10) unsigned
* phone_number : varchar(15)
* title : varchar(50)
* description : varchar(1000)
* attachment : varchar(500)
* price : int(11)
* timestamp : timestamp
v ale1 playerskins
* id : int(11)
* citizenid : varchar(255)
* model : varchar(255)
* skin : text
* active : tinyint(4)
v ale1 players_identifiers
* id : int(11)
* license : varchar(255)
* steam : varchar(255)
* discord : varchar(255)
* ip : varchar(255)
* xbl : varchar(255)
* live : varchar(255)
* fivem : varchar(255)
* other_identifiers : longtext
* raw_identifiers : text
* last_seen : timestamp
v ale1 player_outfits
* id : int(11)
* citizenid : varchar(50)
* outfitname : varchar(50)
* model : varchar(50)
* props : varchar(1000)
* components : varchar(1500)
v ale1 player_outfit_codes
* id : int(11)
* outfitid : int(11)
* code : varchar(50)
v ale1 props
* id : int(11)
* setName : varchar(64)
* type : varchar(32)
* model : varchar(128)
* x : double
* y : double
* z : double
* heading : double
v ale1 qs_busdriverjob
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_busdriverjob_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_busdriverjob_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_busdriverjob_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_dog_walker
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_dog_walker_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_dog_walker_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_dog_walker_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_fisher
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_fisher_achievements
* identifier : varchar(46)
* achievement : varchar(64)
* unlocked_at : datetime
* claimed_at : datetime
v ale1 qs_fisher_config
* path : varchar(191)
* value : longtext
* updated_by : varchar(64)
* updated_at : datetime
v ale1 qs_fisher_crabtraps
* id : int(10) unsigned
* identifier : varchar(46)
* x : float
* y : float
* sea_z : float
* water_z : float
* band : varchar(16)
* placed_at : int(10) unsigned
v ale1 qs_fisher_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_fisher_records
* identifier : varchar(46)
* fish : varchar(64)
* caught : int(10) unsigned
* released : int(10) unsigned
* best_weight : decimal(8,2)
* best_quality : decimal(4,3)
* best_at : datetime
* trophies : int(10) unsigned
v ale1 qs_fisher_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_fisher_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_fisher_tournaments
* identifier : varchar(46)
* wins_heaviest : int(10) unsigned
* wins_most : int(10) unsigned
* wins_total : int(10) unsigned
* last_win : datetime
v ale1 qs_garbagejob
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_garbagejob_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_garbagejob_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_garbagejob_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_hunter
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_hunter_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_hunter_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_hunter_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_lumberjack
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_lumberjack_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_lumberjack_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_lumberjack_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_mechanics
* id : varchar(64)
* job : varchar(64)
* jobGrade : int(11)
* bossGrade : int(11)
* managerGrade : int(11)
* shopConfig : longtext
* created_at : varchar(32)
* balance : int(11)
v ale1 qs_mechanic_config
* id : varchar(64)
* config : longtext
v ale1 qs_mechanic_estock
* id : int(11)
* mechanicId : varchar(64)
* engineId : int(11)
* engineName : varchar(128)
* enginePower : varchar(32)
* engineTorque : varchar(32)
* engineData : longtext
* purchasePrice : int(11)
* onPallet : tinyint(1)
* purchased_at : timestamp
v ale1 qs_mechanic_evehicles
* plate : varchar(50)
* engine_sound : varchar(100)
* handling_json : longtext
* engine_type : longtext
v ale1 qs_mechanic_orders
* id : int(11)
* mechanicId : varchar(64)
* customerLicense : varchar(64)
* customerName : varchar(128)
* vehicleModel : varchar(64)
* vehiclePlate : varchar(16)
* vehicleProperties : longtext
* modificationsList : longtext
* totalCost : int(11)
* status : enum('pending','in_progress','completed','cancelled')
* created_at : timestamp
* completed_at : timestamp
* paid_upfront : tinyint(1)
v ale1 qs_mechanic_wheeldamage
* plate : varchar(50)
* wheels : longtext
* updated_at : timestamp
v ale1 qs_miner
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_miner_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_miner_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_miner_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_multijob
* identifier : varchar(46)
* job : varchar(100)
* grade : int(10)
* badges : text
v ale1 qs_newspaper
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_newspaper_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_newspaper_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_newspaper_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_taxijob
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
v ale1 qs_treasure_hunter
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_treasure_hunter_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_treasure_hunter_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_treasure_hunter_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 qs_truckdriverjob
* identifier : varchar(46)
* level : int(10) unsigned
* experience : int(10) unsigned
* total_experience : int(10) unsigned
* total_earnings : int(10) unsigned
* season_experience : int(10) unsigned
* season_earnings : int(10) unsigned
* daily_experience : int(10) unsigned
* daily_earnings : int(10) unsigned
v ale1 qs_truckdriverjob_leaderboard_winners
* id : int(11)
* position : int(11)
* identifier : varchar(255)
* reward_amount : int(11)
* reward_type : varchar(10)
v ale1 qs_truckdriverjob_resets
* identifier : varchar(46)
* last_daily_reset : datetime
* last_season_reset : datetime
v ale1 qs_truckdriverjob_rewards
* id : int(11)
* identifier : varchar(255)
* reward_type : varchar(50)
* reward_amount : int(11)
v ale1 races
* owner : varchar(50)
* name : varchar(50)
* reward : int(11)
* date : longtext
* maxplayers : int(11)
* route : longtext
* id : bigint(20)
* players : longtext
* luadate : longtext
v ale1 rented_vehicles
* vehicle : varchar(60)
* plate : varchar(12)
* player_name : varchar(255)
* base_price : int(11)
* rent_price : int(11)
* owner : varchar(46)
v ale1 renzu_motels
* id : int(11)
* motel : varchar(64)
* hour_rate : int(11)
* revenue : int(11)
* employees : longtext
* rooms : longtext
* owned : varchar(64)
v ale1 renzu_stancer
* plate : varchar(128)
* setting : longtext
v ale1 renzu_tuner
* id : int(11)
* plate : varchar(60)
* mileages : int(11)
* vehiclestats : longtext
* defaulthandling : longtext
* vehicleupgrades : longtext
* vehicletires : longtext
* drivetrain : varchar(60)
* advancedflags : longtext
* ecu : longtext
* nodegrade : int(11)
* currentengine : varchar(60)
v ale1 robbery_zones_logs
* id : int(11)
* zone_id : varchar(64)
* identifier : varchar(64)
* xplayer_source : int(11)
* rewards : text
* created_at : timestamp
v ale1 society_moneywash
* id : int(11)
* identifier : varchar(60)
* society : varchar(60)
* amount : int(11)
v ale1 sprays
* id : int(11)
* x : float(8,4)
* y : float(8,4)
* z : float(8,4)
* rx : float(8,4)
* ry : float(8,4)
* rz : float(8,4)
* scale : float(8,4)
* text : varchar(32)
* font : varchar(32)
* color : int(3)
* interior : int(3)
* created_at : timestamp
v ale1 tor_accounts
* id : int(11)
* creator : varchar(50)
* username : varchar(50)
* password : varchar(50)
* avatar : longtext
v ale1 twitter_accounts
* id : int(11)
* creator : text
* username : varchar(50)
* password : varchar(50)
* avatar : text
v ale1 users
* identifier : varchar(60)
* ssn : varchar(11)
* accounts : longtext
* group : varchar(50)
* inventory : longtext
* job : varchar(20)
* job_grade : int(11)
* loadout : longtext
* metadata : longtext
* position : longtext
* firstname : varchar(16)
* lastname : varchar(16)
* dateofbirth : varchar(10)
* sex : varchar(1)
* height : int(11)
* skin : longtext
* status : longtext
* is_dead : tinyint(1)
* id : int(11)
* disabled : tinyint(1)
* last_property : varchar(255)
* created_at : timestamp
* last_seen : timestamp
* phone_number : varchar(20)
* pincode : int(11)
* jail_time : int(11)
* aranma : mediumtext
* photo : mediumtext
* job2 : varchar(32)
* job2_grade : varchar(32)
* tattoos : longtext
* image : varchar(250)
* dangerous : tinyint(4)
* wanted : tinyint(4) unsigned
* skills : longtext
* skillpoint : varchar(50)
v ale1 user_identifiers
* id : int(11)
* identifier : varchar(255)
* name : varchar(255)
* license : varchar(255)
* xbl : varchar(255)
* live : varchar(255)
* discord : varchar(255)
* fivem : varchar(255)
* ip : varchar(255)
* date : datetime
v ale1 user_licenses
* id : int(11)
* type : varchar(60)
* owner : varchar(60)
v ale1 user_outfits
* id : int(11)
* identifier : varchar(60)
* name : varchar(50)
* skin : longtext
v ale1 vehicles
* name : varchar(60)
* model : varchar(60)
* price : int(11)
* category : varchar(60)
v ale1 vehicle_categories
* name : varchar(60)
* label : varchar(60)
v ale1 vehicle_sold
* id : int(11)
* client : varchar(50)
* model : varchar(50)
* plate : varchar(50)
* soldby : varchar(50)
* date : varchar(50)
v ale1 weedplants
* id : int(11)
* coords : longtext
* time : datetime
* fertilizer : longtext
* water : longtext
* gender : varchar(45)
v ale1 welcome_vehicles
* identifier : varchar(60)
* given_at : timestamp
v ale1 whitelist
* identifier : varchar(60)
v ale1 zonas
* id : int(11)
* nombre : varchar(64)
* dueno : varchar(64)
* ultima_captura : timestamp
v ale1 zonas_recompensas
* zona_id : int(11)
* item : varchar(64)
* cantidad : int(11)
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación