Created
May 14, 2021 02:33
-
-
Save ka215/478ef44ba94d0ffe7ea7cafcbf48a3c0 to your computer and use it in GitHub Desktop.
MHRise Skill Simulator Database Tables v1.0.1: Create Table Queries
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE `weapons` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '武器ID', | |
`name` varchar(255) NOT NULL COMMENT '武器名', | |
`ruby_name` varchar(255) NOT NULL COMMENT '武器名ルビ', | |
`type` tinyint(4) unsigned NOT NULL COMMENT '武器種', | |
`tree` varchar(255) NOT NULL COMMENT '派生名', | |
`rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度', | |
`rank` tinyint(4) unsigned NOT NULL COMMENT 'ランク', | |
`attack` int(11) unsigned NOT NULL COMMENT '攻撃力', | |
`affinity` tinyint(4) NOT NULL COMMENT '会心率', | |
`defense_bonus` int(11) NOT NULL COMMENT '防御力', | |
`element1` tinyint(4) unsigned NOT NULL COMMENT '属性1', | |
`element2` tinyint(4) unsigned NOT NULL COMMENT '属性2', | |
`elem1_value` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '属性値1', | |
`elem2_value` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '属性値2', | |
`slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1', | |
`slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2', | |
`slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3', | |
PRIMARY KEY (`id`), | |
KEY `name` (`name`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='武器マスター' | |
; | |
CREATE TABLE `weapon_meta` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '武器メタID', | |
`weapon_id` int(11) unsigned NOT NULL COMMENT '武器ID', | |
`sharpness` json DEFAULT NULL COMMENT '切れ味', | |
`shelling_type` tinyint(4) unsigned DEFAULT NULL COMMENT '砲撃タイプ', | |
`shelling_level` tinyint(4) unsigned DEFAULT NULL COMMENT '砲撃レベル', | |
`melody_effects` json DEFAULT NULL COMMENT '旋律効果', | |
`phial_type` tinyint(4) unsigned DEFAULT NULL COMMENT '装着ビン', | |
`phial_element` tinyint(4) unsigned DEFAULT NULL COMMENT 'ビン属性', | |
`phial_element_value` int(11) unsigned DEFAULT NULL COMMENT 'ビン属性値', | |
`kinsect_level` tinyint(4) unsigned DEFAULT NULL COMMENT '猟虫レベル', | |
`deviation` tinyint(4) unsigned DEFAULT NULL COMMENT 'ブレ', | |
`recoil` tinyint(4) unsigned DEFAULT NULL COMMENT '反動', | |
`reload` tinyint(4) unsigned DEFAULT NULL COMMENT 'リロード', | |
`mods` tinyint(4) unsigned DEFAULT NULL COMMENT 'パーツ', | |
`cluster_bomb_type` tinyint(4) unsigned DEFAULT NULL COMMENT '拡散弾タイプ', | |
`special_ammo` tinyint(4) unsigned DEFAULT NULL COMMENT '特殊弾', | |
`arc_shot` tinyint(4) unsigned DEFAULT NULL COMMENT '曲射', | |
`charge_shot` json DEFAULT NULL COMMENT '溜め攻撃', | |
`forging_materials` json DEFAULT NULL COMMENT '生産素材', | |
`upgrade_materials` json DEFAULT NULL COMMENT '強化素材', | |
`forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用', | |
`forge_with_money` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '購入費用', | |
`upgrade_funds` int(11) unsigned NOT NULL COMMENT '強化費用', | |
`rampage_skills` json DEFAULT NULL COMMENT '百竜スキル', | |
`rollbackable` bit(1) NOT NULL DEFAULT b'1' COMMENT 'ロールバック可否', | |
PRIMARY KEY (`id`), | |
KEY `weapon_id` (`weapon_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='武器メタ' | |
; | |
CREATE TABLE `ammo` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '弾薬管理ID', | |
`weapon_id` int(11) unsigned NOT NULL COMMENT '武器ID', | |
`capacity` json NOT NULL COMMENT '弾数(初期値)', | |
`capacity_lv1` json NOT NULL COMMENT '弾数(装填拡張Lv1)', | |
`capacity_lv2` json NOT NULL COMMENT '弾数(装填拡張Lv2)', | |
`capacity_lv3` json NOT NULL COMMENT '弾数(装填拡張Lv3)', | |
`recoil` json NOT NULL COMMENT '反動(初期値)', | |
`recoil_lv1` json NOT NULL COMMENT '反動(反動軽減Lv1)', | |
`recoil_lv2` json NOT NULL COMMENT '反動(反動軽減Lv2)', | |
`recoil_lv3` json NOT NULL COMMENT '反動(反動軽減Lv3)', | |
`reload` json NOT NULL COMMENT 'リロード(初期値)', | |
`reload_lv1` json NOT NULL COMMENT 'リロード(装填速度Lv1)', | |
`reload_lv2` json NOT NULL COMMENT 'リロード(装填速度Lv2)', | |
`reload_lv3` json NOT NULL COMMENT 'リロード(装填速度Lv3)', | |
`moving_shot` json DEFAULT NULL COMMENT '移動射撃可', | |
`moving_reload` json DEFAULT NULL COMMENT '移動リロード可', | |
`single_fire_auto_reload` json DEFAULT NULL COMMENT '単発自動装填', | |
`for_rapid_fire` json DEFAULT NULL COMMENT '速射対応', | |
PRIMARY KEY (`id`), | |
KEY `weapon_id` (`weapon_id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='弾薬管理' | |
; | |
CREATE TABLE `armors` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '防具ID', | |
`name_male` varchar(255) NOT NULL COMMENT '防具名(男性用)', | |
`name_female` varchar(255) NOT NULL COMMENT '防具名(女性用)', | |
`ruby_name_male` varchar(255) NOT NULL COMMENT '防具名ルビ(男性用)', | |
`ruby_name_female` varchar(255) NOT NULL COMMENT '防具名ルビ(女性用)', | |
`series` varchar(255) NOT NULL COMMENT 'シリーズ名', | |
`part` tinyint(4) unsigned NOT NULL COMMENT '部位', | |
`rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度', | |
`rank` tinyint(4) unsigned NOT NULL COMMENT 'ランク', | |
`defense` int(11) unsigned NOT NULL COMMENT '防御力', | |
`max_level` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '最大レベル', | |
`fire_resistance` tinyint(4) NOT NULL COMMENT '火耐性', | |
`water_resistance` tinyint(4) NOT NULL COMMENT '水耐性', | |
`thunder_resistance` tinyint(4) NOT NULL COMMENT '雷耐性', | |
`ice_resistance` tinyint(4) NOT NULL COMMENT '氷耐性', | |
`dragon_resistance` tinyint(4) NOT NULL COMMENT '龍耐性', | |
`slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1', | |
`slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2', | |
`slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3', | |
`skills` json DEFAULT NULL COMMENT 'スキル', | |
`forging_materials` json DEFAULT NULL COMMENT '生産素材', | |
`forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用', | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='防具マスター' | |
; | |
CREATE TABLE `talismans` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '護石ID', | |
`name` varchar(255) NOT NULL COMMENT '護石名', | |
`rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度', | |
`slot1` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット1', | |
`slot2` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット2', | |
`slot3` tinyint(4) unsigned NOT NULL DEFAULT 0 COMMENT 'スロット3', | |
`skills` json DEFAULT NULL COMMENT 'スキル', | |
`emission_type` tinyint(4) unsigned DEFAULT NULL COMMENT '排出タイプ', | |
`emissions` int(11) unsigned NOT NULL DEFAULT 0 COMMENT '排出数', | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='護石マスター' | |
; | |
CREATE TABLE `decorations` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '装飾品ID', | |
`name` varchar(255) NOT NULL COMMENT '装飾品名', | |
`ruby_name` varchar(255) NOT NULL COMMENT '装飾品名ルビ', | |
`rarity` tinyint(4) unsigned NOT NULL COMMENT 'レア度', | |
`slot` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT 'スロット', | |
`skills` json DEFAULT NULL COMMENT 'スキル', | |
`forging_materials` json DEFAULT NULL COMMENT '生産素材', | |
`forge_funds` int(11) unsigned NOT NULL COMMENT '生産費用', | |
PRIMARY KEY (`id`), | |
KEY `name` (`name`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='装飾品マスター' | |
; | |
CREATE TABLE `skills` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'スキルID', | |
`name` varchar(255) NOT NULL COMMENT 'スキル名', | |
`ruby_name` varchar(255) NOT NULL COMMENT 'スキル名ルビ', | |
`description` text NOT NULL COMMENT 'スキル概要', | |
`max_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '最大レベル', | |
`status` json DEFAULT NULL COMMENT 'ステータス', | |
PRIMARY KEY (`id`), | |
KEY `name` (`name`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='スキルマスター' | |
; |
Author
ka215
commented
Jun 15, 2021
CREATE TABLE `loadouts` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'マイセットID',
`name` varchar(255) DEFAULT NULL COMMENT 'マイセット名',
`weapon_id` int(11) unsigned NOT NULL COMMENT '装備武器ID',
`weapon_slots` json DEFAULT NULL COMMENT '装備武器スロット内容',
`head_id` int(11) unsigned NOT NULL COMMENT '装備頭部防具ID',
`head_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '装備頭部防具レベル',
`head_slots` json DEFAULT NULL COMMENT '装備頭部防具スロット内容',
`chest_id` int(11) unsigned NOT NULL COMMENT '装備胸部防具ID',
`chest_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '装備胸部防具レベル',
`chest_slots` json DEFAULT NULL COMMENT '装備胸部防具スロット内容',
`arms_id` int(11) unsigned NOT NULL COMMENT '装備腕部防具ID',
`arms_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '装備腕部防具レベル',
`arms_slots` json DEFAULT NULL COMMENT '装備腕部防具スロット内容',
`waist_id` int(11) unsigned NOT NULL COMMENT '装備腰部防具ID',
`waist_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '装備腰部防具レベル',
`waist_slots` json DEFAULT NULL COMMENT '装備腰部防具スロット内容',
`legs_id` int(11) unsigned NOT NULL COMMENT '装備脚部防具ID',
`legs_lv` tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT '装備脚部防具レベル',
`legs_slots` json DEFAULT NULL COMMENT '装備脚部防具スロット内容',
`talisman_id` int(11) unsigned NOT NULL COMMENT '装備護石ID',
`talisman_slots` json DEFAULT NULL COMMENT '装備護石スロット内容',
`skills` json DEFAULT NULL COMMENT '発動スキル',
`disabled` bit(1) NOT NULL DEFAULT b'0' COMMENT '無効フラグ',
`user_info` json DEFAULT NULL COMMENT 'ユーザ識別情報',
`created_at` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '登録日時',
`updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新日時',
PRIMARY KEY (`id`),
KEY `created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='マイセット管理'
;
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment