SQL

CREATE TABLE IF NOT EXISTS `propplacer_props` (
    `id`         INT AUTO_INCREMENT PRIMARY KEY,
    `model`      VARCHAR(100) NOT 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,
    `placed_by`  VARCHAR(60) NOT NULL DEFAULT 'admin',
    `placed_at`  TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Last updated