lua offlineshop 1

mistikaptal · 24 May 2025

SQL:

CREATE TABLE IF NOT EXISTS `offshops` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `owner_id` INT NOT NULL,
    `shop_name` VARCHAR(60) NOT NULL,
    `map_index` INT NOT NULL,
    `x` INT NOT NULL,
    `y` INT NOT NULL,
    PRIMARY KEY (`id`),
    INDEX (`owner_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

SQL:

CREATE TABLE IF NOT EXISTS `offshop_items` (
    `id` INT NOT NULL AUTO_INCREMENT,
    `offshop_id` INT NOT NULL,
    `item_vnum` INT NOT NULL,
    `count` INT NOT NULL,
    `price` BIGINT NOT NULL,
    `item_pos` TINYINT NOT NULL,
    PRIMARY KEY (`id`),
    INDEX (`offshop_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;