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 Bookmark 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
Number of tables: 0
v rsgcore address_book
* id : int(11)
* citizenid : varchar(50)
* name : varchar(50)
* owner : varchar(50)
v rsgcore bank_statements
* record_id : bigint(255)
* citizenid : varchar(50)
* account : varchar(50)
* deposited : int(11)
* withdraw : int(11)
* balance : int(11)
* date : varchar(50)
* type : varchar(255)
v rsgcore bans
* id : int(11)
* name : varchar(50)
* license : varchar(50)
* discord : varchar(50)
* ip : varchar(50)
* reason : text
* expire : int(11)
* bannedby : varchar(255)
v rsgcore beekeepershop_stock
* id : int(11)
* shopid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
v rsgcore beekeeper_shop
* shopid : varchar(255)
* jobaccess : varchar(255)
* displayname : varchar(255)
* money : double(11,2)
v rsgcore beekeeper_stock
* id : int(11)
* beekeeper : varchar(50)
* item : varchar(50)
* stock : int(11)
v rsgcore blacksmithshop_stock
* id : int(11)
* shopid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
v rsgcore blacksmith_shop
* shopid : varchar(255)
* jobaccess : varchar(255)
* displayname : varchar(255)
* money : double(11,2)
v rsgcore blacksmith_stock
* id : int(11)
* blacksmith : varchar(50)
* item : varchar(50)
* stock : int(11)
v rsgcore doors
* id : int(11)
* doorid : varchar(11)
* doorstate : int(1)
v rsgcore hunting_inventory
* id : int(11)
* animalhash : int(25)
* animallabel : varchar(50)
* animallooted : int(11)
* citizenid : varchar(50)
* plate : varchar(255)
v rsgcore hunting_wagons
* id : int(11)
* citizenid : varchar(50)
* plate : varchar(255)
* huntingcamp : varchar(50)
* damaged : tinyint(4)
* active : tinyint(4)
v rsgcore indian_plants
* id : int(11)
* properties : text
* plantid : int(11)
v rsgcore job_wagons
* id : int(11)
* job : varchar(50)
* plate : varchar(255)
* active : tinyint(4)
v rsgcore management_funds
* id : int(11)
* job_name : varchar(50)
* amount : int(100)
* type : enum('boss','gang')
v rsgcore market_items
* id : int(11)
* marketid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
v rsgcore market_owner
* marketid : varchar(255)
* citizenid : varchar(255)
* displayname : varchar(255)
* owned : int(3)
* money : double(11,2)
* robbery : int(1)
v rsgcore moonshiner_props
* id : int(11)
* citizenid : varchar(50)
* gang : varchar(50)
* properties : text
* propid : int(11)
* proptype : varchar(50)
* credit : int(11)
v rsgcore playerclothe
* citizenid : varchar(255)
* license : varchar(255)
* clothes : varchar(5000)
v rsgcore playeroutfit
* id : int(11)
* citizenid : varchar(50)
* license : varchar(255)
* name : varchar(255)
* clothes : longtext
v rsgcore players
* id : int(11)
* citizenid : varchar(255)
* cid : int(11)
* license : varchar(255)
* name : varchar(255)
* money : text
* charinfo : text
* job : text
* gang : text
* position : text
* metadata : text
* inventory : longtext
* last_updated : timestamp
v rsgcore playerskins
* citizenid : varchar(255)
* license : varchar(255)
* skin : varchar(8000)
v rsgcore player_bills
* id : int(10)
* citizenid : varchar(50)
* amount : int(11)
* society : tinytext
* sender : varchar(50)
* sendercitizenid : varchar(50)
v rsgcore player_horses
* id : int(11)
* citizenid : varchar(50)
* horseid : varchar(11)
* name : varchar(255)
* horse : varchar(50)
* horsexp : int(11)
* saddle : varchar(50)
* blanket : varchar(50)
* saddlebag : varchar(50)
* bedroll : varchar(50)
* horn : varchar(50)
* stirrup : varchar(50)
* mane : varchar(50)
* tail : varchar(50)
* mask : varchar(50)
* mustache : varchar(50)
* gender : varchar(11)
* wild : varchar(11)
* active : tinyint(4)
v rsgcore player_housekeys
* id : int(11)
* houseid : varchar(7)
* citizenid : varchar(50)
* guest : int(1)
v rsgcore player_houses
* id : int(11)
* agent : varchar(30)
* houseid : varchar(7)
* citizenid : varchar(50)
* fullname : varchar(255)
* owned : tinyint(4)
* price : int(11)
* credit : int(11)
v rsgcore player_plants
* id : int(11)
* citizenid : varchar(50)
* properties : text
* plantid : int(11)
v rsgcore player_props
* id : int(11)
* citizenid : varchar(50)
* gang : varchar(50)
* properties : text
* propid : int(11)
* proptype : varchar(50)
* credit : int(11)
v rsgcore player_rooms
* id : int(11)
* citizenid : varchar(255)
* fullname : varchar(255)
* location : varchar(30)
* credit : int(11)
* roomid : int(11)
* active : int(1)
v rsgcore player_weapons
* id : int(11)
* serial : varchar(16)
* citizenid : varchar(9)
* components : varchar(4096)
v rsgcore ranch_animals
* id : int(11)
* ranchid : varchar(50)
* animalid : varchar(50)
* animals : text
v rsgcore ranch_shop
* shopid : varchar(255)
* jobaccess : varchar(255)
* displayname : varchar(255)
* money : double(11,2)
v rsgcore ranch_shop_stock
* id : int(11)
* shopid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
v rsgcore ranch_stock
* id : int(11)
* jobaccess : varchar(50)
* item : varchar(50)
* stock : int(11)
v rsgcore saloontendershop_stock
* id : int(11)
* shopid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
v rsgcore saloontender_shop
* shopid : varchar(255)
* jobaccess : varchar(255)
* displayname : varchar(255)
* money : double(11,2)
v rsgcore saloontender_stock
* id : int(11)
* saloontender : varchar(50)
* item : varchar(50)
* stock : int(11)
v rsgcore stashitems
* id : int(11)
* stash : varchar(255)
* items : longtext
v rsgcore telegrams
* id : int(11)
* citizenid : varchar(255)
* recipient : varchar(255)
* sender : varchar(255)
* sendername : varchar(255)
* subject : varchar(255)
* sentDate : varchar(25)
* message : varchar(455)
* status : varchar(1)
* birdstatus : tinyint(2)
v rsgcore weaponsmith_stock
* id : int(11)
* weaponsmith : varchar(50)
* item : varchar(50)
* stock : int(11)
v rsgcore weapon_shop
* shopid : varchar(255)
* jobaccess : varchar(255)
* displayname : varchar(255)
* money : double(11,2)
v rsgcore weapon_stock
* id : int(11)
* shopid : varchar(50)
* items : varchar(50)
* stock : int(11)
* price : double(11,2)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship