25 lines
1.2 KiB
SQL
25 lines
1.2 KiB
SQL
--
|
|
-- Table structure for table `char_job_points`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `char_job_points`;
|
|
CREATE TABLE `char_job_points` (
|
|
`charid` int(10) unsigned NOT NULL,
|
|
`jobid` tinyint(2) unsigned NOT NULL,
|
|
`capacity_points` smallint(5) unsigned NOT NULL DEFAULT '0',
|
|
`job_points` smallint(3) unsigned NOT NULL DEFAULT '0',
|
|
`job_points_spent` smallint(4) unsigned NOT NULL DEFAULT '0',
|
|
`jptype0` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype1` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype2` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype3` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype4` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype5` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype6` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype7` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype8` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
`jptype9` tinyint(2) unsigned NOT NULL DEFAULT '0',
|
|
INDEX `char_job_points_charid_index` (`charid`),
|
|
INDEX `char_job_points_charid_jobid_index` (`charid`, `jobid`),
|
|
UNIQUE KEY `idx_char_job_points_charid_jobid` (`charid`,`jobid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|