SQL

CREATE TABLE IF NOT EXISTS `origen_darkmarket_stock` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
  `type` VARCHAR(255) NOT NULL, -- weapon, masks
  `object` VARCHAR(255) NOT NULL,
  `camo` VARCHAR(255),
  `rarity` VARCHAR(255),
  `stock` INTEGER NOT NULL,
  `available` INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS `origen_darkmarket_camos` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
  `citizenid` VARCHAR(255) NOT NULL,
  `camos` LONGTEXT
);

CREATE TABLE IF NOT EXISTS `origen_darkmarket_items` (
  `id` INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
  `citizenid` VARCHAR(255) NOT NULL,
  `items` LONGTEXT
);

Last updated