yapay zeka shop

-- ============================================================
-- Fliege Offline Shop - Tablo Yapilari
-- MariaDB 11.x
-- Kullanim: Bu dosyayi calistirmadan once veritabanlarinin
--           (player, log) var oldugunu kontrol et.
-- ============================================================

-- ------------------------------------------------------------
-- player.offline_shop_item
-- Her offline shop'un icindeki itemleri tutar
-- ------------------------------------------------------------
USE player;

DROP TABLE IF EXISTS `offline_shop_item`;
CREATE TABLE `offline_shop_item` (
  `owner_id`   int(10) unsigned NOT NULL,
  `pos`        smallint(6)      NOT NULL,
  `count`      int(10) unsigned NOT NULL DEFAULT 1,
  `price`      bigint(20)       NOT NULL DEFAULT 0,
  `vnum`       int(10) unsigned NOT NULL,
  `socket0`    int(11)          NOT NULL DEFAULT 0,
  `socket1`    int(11)          NOT NULL DEFAULT 0,
  `socket2`    int(11)          NOT NULL DEFAULT 0,
  `attrtype0`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue0` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype1`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue1` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype2`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue2` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype3`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue3` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype4`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue4` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype5`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue5` smallint(6)      NOT NULL DEFAULT 0,
  `attrtype6`  smallint(6)      NOT NULL DEFAULT 0,
  `attrvalue6` smallint(6)      NOT NULL DEFAULT 0,
  PRIMARY KEY (`owner_id`, `pos`),
  KEY `idx_owner` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- ------------------------------------------------------------
-- player.offline_shop_spawn
-- Sunucu yeniden basladiginda hangi offline shop NPC'sinin
-- nerede spawn edecegini tutar
-- ------------------------------------------------------------
DROP TABLE IF EXISTS `offline_shop_spawn`;
CREATE TABLE `offline_shop_spawn` (
  `owner_id`  int(10) unsigned    NOT NULL,
  `account_id` int(10) unsigned   NOT NULL,
  `empire`    tinyint(3) unsigned NOT NULL DEFAULT 0,
  `channel`   tinyint(3) unsigned NOT NULL DEFAULT 1,
  `map_index` smallint(6)         NOT NULL,
  `x`         int(11)             NOT NULL,
  `y`         int(11)             NOT NULL,
  `z`         int(11)             NOT NULL,
  `rotation`  smallint(6)         NOT NULL DEFAULT 0,
  `sign`      varchar(32)         NOT NULL DEFAULT '',
  PRIMARY KEY (`owner_id`),
  KEY `idx_channel` (`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ------------------------------------------------------------
-- player.offline_shop_item_backup
-- Satilan itemlerin yedegi (opsiyonel, silme)
-- ------------------------------------------------------------
DROP TABLE IF EXISTS `offline_shop_item_backup`;
CREATE TABLE `offline_shop_item_backup` (
  `owner_id`      int(11)      NOT NULL DEFAULT 0,
  `pos`           tinyint(3) unsigned NOT NULL DEFAULT 0,
  `count`         smallint(4) unsigned NOT NULL DEFAULT 1,
  `price`         bigint(18)   NOT NULL DEFAULT 0,
  `vnum`          int(11)      NOT NULL DEFAULT 0,
  `aAttr`         text         DEFAULT NULL,
  `buyerName`     varchar(24)  NOT NULL DEFAULT '',
  `bIsSold`       tinyint(1)   NOT NULL DEFAULT 0,
  `cheque`        int(11)      NOT NULL DEFAULT 0,
  `transmutation` int(11)      NOT NULL DEFAULT 0,
  `price_type`    int(11)      NOT NULL DEFAULT 1,
  `price_vnum`    int(11)      NOT NULL DEFAULT 0,
  `socket0`       bigint(20)   NOT NULL DEFAULT 0,
  `socket1`       bigint(20)   NOT NULL DEFAULT 0,
  `socket2`       bigint(20)   NOT NULL DEFAULT 0,
  `attrtype0`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue0`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype1`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue1`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype2`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue2`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype3`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue3`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype4`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue4`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype5`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue5`    smallint(6)  NOT NULL DEFAULT 0,
  `attrtype6`     smallint(6)  NOT NULL DEFAULT 0,
  `attrvalue6`    smallint(6)  NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- ------------------------------------------------------------
-- player.player kolonlari (offline shop para icin)
-- Eger yoksa ekle, varsa hata verir - normal
-- ------------------------------------------------------------
ALTER TABLE `player`
  ADD COLUMN IF NOT EXISTS `gold_offlineshop`   bigint(20) NOT NULL DEFAULT 0,
  ADD COLUMN IF NOT EXISTS `cheque_offlineshop` int(11)    NOT NULL DEFAULT 0;

-- ------------------------------------------------------------
-- log.offlineshop_log
-- Offline shop islem loglari (sat, al, koy vs.)
-- ------------------------------------------------------------
USE log;

DROP TABLE IF EXISTS `offlineshop_log`;
CREATE TABLE `offlineshop_log` (
  `id`         int(11)      NOT NULL AUTO_INCREMENT,
  `account_id` int(11)      NOT NULL DEFAULT 0,
  `action`     varchar(32)  NOT NULL DEFAULT '',
  `item`       varchar(255) NOT NULL DEFAULT '',
  `time`       datetime     NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `account_id_idx` (`account_id`),
  KEY `action_idx` (`action`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- ============================================================
-- Bitti. Kontrol:
--   USE player; SHOW TABLES LIKE 'offline%';
--   USE log;    SHOW TABLES LIKE 'offline%';
-- ============================================================