Home › Documentation › Installation · origen_propplacer

Installation · origen_propplacer

1. SQL

Run the following SQL against your database before starting the resource.

The resource will also create and migrate these tables automatically on startup via oxmysql. Running the SQL manually is recommended to ensure a clean initial state.

`propplacer_props`

Stores every placed prop with its position, rotation, category, and metadata.

sql

CREATE TABLE IF NOT EXISTS `propplacer_props` (
    `id`         INT AUTO_INCREMENT PRIMARY KEY,
    `model`      VARCHAR(100) NOT NULL,
    `label`      VARCHAR(150) DEFAULT NULL,
    `notes`      TEXT         DEFAULT NULL,
    `x`          FLOAT NOT NULL,
    `y`          FLOAT NOT NULL,
    `z`          FLOAT NOT NULL,
    `rx`         FLOAT NOT NULL DEFAULT 0,
    `ry`         FLOAT NOT NULL DEFAULT 0,
    `rz`         FLOAT NOT NULL DEFAULT 0,
    `category`   VARCHAR(80)  DEFAULT 'General',
    `placed_by`  VARCHAR(100) NOT NULL DEFAULT 'admin',
    `locked`     TINYINT(1)   DEFAULT 0,
    `ghost`      TINYINT(1)   DEFAULT 0,
    `tags`       VARCHAR(200) DEFAULT NULL,
    `placed_at`  TIMESTAMP    DEFAULT CURRENT_TIMESTAMP
);

`propplacer_permissions`

Stores manually granted player permissions.

sql

CREATE TABLE IF NOT EXISTS `propplacer_permissions` (
    `identifier` VARCHAR(100) PRIMARY KEY,
    `name`       VARCHAR(100) NOT NULL,
    `level`      VARCHAR(20)  NOT NULL DEFAULT 'editor',
    `granted_by` VARCHAR(100) NOT NULL DEFAULT 'console',
    `granted_at` TIMESTAMP    DEFAULT CURRENT_TIMESTAMP
);

Runtime migrations

On every resource start, the server automatically runs ALTER TABLE … ADD COLUMN IF NOT EXISTS migrations for backward compatibility with older installs (pre-2.2.0). No manual action needed if upgrading from a previous version.

2. server.cfg

text

ensure origen_propplacer

oxmysql must be ensured before origen_propplacer in your server.cfg.