ChestShopDB records ChestShop shop information into either a MySQL or an SQLite database.
Please note: While it is needed for ChestShopDB to function, ChestShop is NOT bundled with ChestShopDB. Grab Chestshop here.
Table Structure
The current data recorded for shops is as follows:| Field | Data Type | Description |
|---|---|---|
| owner | varchar(16) | The shop owner's name. |
| adminShop | boolean | Whether the shop is an Admin shop or not. |
| itemId | int | The data value of the traded item. |
| stock | int | The remaining stock left in the shop's chest. |
| buyPrice | double | The price that the player has to <big>pay</big>. |
| sellPrice | double | The price that the player will <big>receive</big>. |
| quantity | int | The quantity that the shop buys and/or sells. |
| world | varchar(50) | The world that the shop's <big>sign</big> resides in. |
| x | double | The x coordinate of the shop's <big>sign</big>. |
| y | double | The y coordinate of the shop's <big>sign</big>. |
| z | double | The z coordinate of the shop's <big>sign</big>. |
Source
The source can be viewed here.