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;
