Database

rcore_housing supports three database resources and creates its own tables on first boot.

🔎 Auto Detection

Config.Database = AUTO_DETECT

Override with Database.OX, Database.MYSQL_ASYNC, or Database.GHMATTI only when detection is wrong.

🧩 Supported Resources

Resource: oxmysql - recommended.

rcore_housing runs every query through oxmysql when this bridge is selected. Recent versions are required for EXPLAIN support, which the resource uses to auto-create missing indexes.

ensure oxmysql
ensure [housing]

Resource: mysql-async

The bridge wraps mysql-async calls in promises. The resource still auto-creates tables; index optimization is best-effort.

ensure mysql-async
ensure [housing]

🗄️ Auto-Created Tables

On first boot, the resource creates and indexes these tables (idempotent - CREATE TABLE IF NOT EXISTS):

Table	Purpose
rcore_housing_properties	Property definitions, owners, tenants, state, zones.
rcore_housing_players	Per-player housing state (last property, starter assignment).
rcore_housing_data_patches	Used for tracking any SQL patches for housing new features / bug fixes.
rcore_housing_property_accessories	Per-property upgrades and metadata.
rcore_housing_furniture	Furniture catalog (master list).
rcore_housing_furniture_variants	Color variants per furniture item.
rcore_housing_property_furniture	Furniture placed inside properties.
rcore_housing_property_furniture_stock	Furniture owned but unplaced.
rcore_housing_property_furniture_orders	Pending furniture deliveries.
rcore_housing_billing	Active rent / utilities bills.
rcore_housing_rent_ledger	Payment history.
rcore_housing_keys	Per-player access keys.
rcore_housing_accesses	Per-door access grants.
rcore_housing_marketplace_listings	Marketplace listings.
rcore_housing_marketplace_favorites	Player favourites.
rcore_housing_business_permissions	Per-grade business permissions.
rcore_housing_interior_catalog	Custom SHELLs and IPLs from the Interior Creator.