Copy CREATE TABLE `jobs_ems_category` (
`id` int(11) NOT NULL,
`name` varchar(64) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `jobs_ems_otherdata` (
`lastTreatments` text NOT NULL DEFAULT('[]')
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `jobs_ems_otherdata` (`lastTreatments`) VALUES
('[]');
CREATE TABLE `jobs_ems_players` (
`id` int(11) NOT NULL,
`cid` varchar(64) NOT NULL,
`notes` text NOT NULL DEFAULT('[]'),
`recipes` text NOT NULL DEFAULT('[]'),
`historyJudgments` text NOT NULL DEFAULT('[]'),
`isDead` int(1) NOT NULL DEFAULT 0,
`hp` int(4) NOT NULL DEFAULT 200,
`playerDamages` text NOT NULL DEFAULT('[]'),
`playerDamagesInfo` text NOT NULL DEFAULT('[]')
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `jobs_ems_regulations` (
`id` int(11) NOT NULL,
`name` varchar(128) NOT NULL,
`category` int(11) NOT NULL,
`money` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
ALTER TABLE `jobs_ems_category` ADD PRIMARY KEY (`id`);
ALTER TABLE `jobs_ems_players` ADD PRIMARY KEY (`id`);
ALTER TABLE `jobs_ems_regulations` ADD PRIMARY KEY (`id`);
ALTER TABLE `jobs_ems_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `jobs_ems_players` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
ALTER TABLE `jobs_ems_regulations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;