26 lines
1.3 KiB
SQL
26 lines
1.3 KiB
SQL
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
|
|
-- ----------------------------
|
|
-- Table structure for char_equip_saved
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS `char_equip_saved`;
|
|
CREATE TABLE IF NOT EXISTS `char_equip_saved` (
|
|
`charid` int(10) unsigned NOT NULL,
|
|
`jobid` tinyint(2) unsigned NOT NULL,
|
|
`main` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`sub` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ranged` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ammo` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`head` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`body` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`hands` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`legs` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`feet` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`neck` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`waist` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ear1` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ear2` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ring1` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`ring2` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`back` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`charid`, `jobid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AVG_ROW_LENGTH=20;
|