Dude this is not working for me. I followed your instructions. But when i wan't to install the sql file, I get following error.
* SQL Error (1452): Cannot add or update a child row: a foreign key constraint fails (`qbcoreframework_c0bb14`.`#sql-2cf8_1f`, CONSTRAINT `karma_clothing_ibfk_1` FOREIGN KEY (`id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) */
/* Affected rows: 12 Found rows: 0 Warnings: 0 Duration for 8 of 10 queries: 3,015 sec. */
I can't install your sql file.
well weird cause my sql doesnt even mess with the players group sql and messes with the Karma-Clothing and Karma-HeadClothing so your clearly doing soemthing wrong make sure to drop BOTH OF KARMAS SQLS BEFORE TRYING TO INSERT THE NEWEST ONE AND HERE IS THE ONE THAT WORKS AND YOU CAN CLEARLY SEE IT DOESNT HAVE ANY MENTION TO PLAYERS SO THAT ERROR YOU ARE SENDING IS FROM YOU DOING THE WRONG THING
CREATE TABLE `karma_clothing` (
`id` int(25) NOT NULL,
`model` varchar(50) NOT NULL DEFAULT '',
`drawables_texture` text NOT NULL,
`props_texture` text NOT NULL,
`hairColor` text NOT NULL,
`fadeLayer` text DEFAULT '0',
`customHeadModel` longtext DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `karma_clothing` (`id`, `model`, `drawables_texture`, `props_texture`, `hairColor`, `fadeLayer`, `customHeadModel`, `created_at`) VALUES
(15471, '1885233650', '{\"Face\":[0,0],\"Mask\":[0,0],\"Hair\":[138,0],\"Torso\":[11,0],\"Leg\":[230,0],\"Parachute\":[0,0],\"Shoes\":[12,6],\"Accessory\":[0,0],\"Undershirt\":[226,0],\"Kevlar\":[73,0],\"Badge\":[0,0],\"Jacket\":[570,0]}', '{\"Hat\":[-1,-1],\"Glasses\":[-1,-1],\"Ears\":[-1,-1],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[1,1]', '0', '\"\\\"\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"false\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\"\\\\\\\\\\\\\\\"\\\\\\\"\\\"\"', '2024-11-17 23:15:30'),
(16276, '1885233650', '{\"Face\":[0,0],\"Mask\":[0,0],\"Hair\":[45,0],\"Torso\":[96,0],\"Leg\":[234,0],\"Parachute\":[0,0],\"Shoes\":[10,0],\"Accessory\":[27,5],\"Undershirt\":[146,10],\"Kevlar\":[0,0],\"Badge\":[0,0],\"Jacket\":[641,0]}', '{\"Hat\":[-1,-1],\"Glasses\":[-1,-1],\"Ears\":[0,0],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[2,0]', 'null', '\"\\\"false\\\"\"', '2024-11-18 18:53:31'),
(17778, '1885233650', '{\"Face\":[0,0],\"Mask\":[0,0],\"Hair\":[173,0],\"Torso\":[0,0],\"Leg\":[0,0],\"Parachute\":[0,0],\"Shoes\":[1,2],\"Accessory\":[-1,0],\"Undershirt\":[15,0],\"Kevlar\":[0,0],\"Badge\":[0,0],\"Jacket\":[560,0]}', '{\"Hat\":[-1,-1],\"Glasses\":[-1,-1],\"Ears\":[-1,-1],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[7,15]', 'null', '\"\\\"false\\\"\"', '2024-12-08 17:38:10'),
(18004, '1885233650', '{\"Face\":[0,0],\"Mask\":[0,0],\"Hair\":[97,0],\"Torso\":[0,0],\"Leg\":[0,0],\"Parachute\":[0,0],\"Shoes\":[1,2],\"Accessory\":[0,0],\"Undershirt\":[0,1],\"Kevlar\":[0,0],\"Badge\":[0,0],\"Jacket\":[0,1]}', '{\"Hat\":[-1,-1],\"Glasses\":[-1,-1],\"Ears\":[-1,-1],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[1,1]', '0', '\"false\"', '2024-12-09 01:23:37'),
(18874, 'ig_derek', '{\"Face\":[0,0],\"Mask\":[0,0],\"Hair\":[5,1],\"Torso\":[0,0],\"Leg\":[0,0],\"Parachute\":[0,0],\"Shoes\":[0,0],\"Accessory\":[0,0],\"Undershirt\":[0,0],\"Kevlar\":[0,0],\"Badge\":[0,0],\"Jacket\":[4,0]}', '{\"Hat\":[-1,-1],\"Glasses\":[-1,-1],\"Ears\":[-1,-1],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[-1,-1]', '1', '\"false\"', '2024-11-27 23:06:26'),
(18906, '1885233650', '{\"Face\":[0,0],\"Mask\":[272,0],\"Hair\":[73,0],\"Torso\":[0,0],\"Leg\":[7,0],\"Parachute\":[0,0],\"Shoes\":[27,0],\"Accessory\":[-1,0],\"Undershirt\":[15,0],\"Kevlar\":[0,0],\"Badge\":[0,0],\"Jacket\":[22,0]}', '{\"Hat\":[245,0],\"Glasses\":[9,0],\"Ears\":[-1,-1],\"Watch\":[-1,-1],\"Bracelet\":[-1,-1]}', '[0,0]', 'null', 'false', '2024-11-28 00:41:50');
-- --------------------------------------------------------
--
-- Table structure for table `karma_head_clothing`
--
CREATE TABLE `karma_head_clothing` (
`id` int(25) NOT NULL,
`model` varchar(50) DEFAULT NULL,
`head_blend` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`head_blend`)),
`head_features` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`head_features`)),
`head_overlays` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`head_overlays`)),
`fade` longtext DEFAULT NULL,
`eye_color` int(11) NOT NULL DEFAULT 0,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `karma_head_clothing`
--
INSERT INTO `karma_head_clothing` (`id`, `model`, `head_blend`, `head_features`, `head_overlays`, `fade`, `eye_color`, `created_at`, `updated_at`) VALUES
(8669, '1885233650', '{\"ShapeFirst\":23,\"ShapeSecond\":1,\"ShapeThird\":43,\"SkinFirst\":13,\"SkinSecond\":13,\"SkinThird\":42,\"ShapeMix\":0.59,\"SkinMix\":0.4,\"ThirdMix\":0.58}', '{\"nose_width\":0,\"nose_peak\":0,\"nose_length\":0,\"nose_bone_curveness\":0,\"nose_tip\":0,\"nose_bone_twist\":0,\"eyebrow_up_down\":0,\"eyebrow_in_out\":0,\"cheek_bones\":0,\"cheek_sideways_bone_size\":0,\"cheek_bones_width\":0,\"eye_opening\":0,\"lip_thickness\":0,\"jaw_bone_width\":-0.51,\"jaw_bone_shape\":-0.4,\"chin_bone\":1,\"chin_bone_length\":0.58,\"chin_bone_shape\":-0.34,\"chin_hole\":0.26,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"FacialHair\":{\"value\":11,\"colorType\":1,\"firstColor\":29,\"secondColor\":0,\"opacity\":0.99},\"Eyebrows\":{\"value\":0,\"colorType\":1,\"firstColor\":29,\"secondColor\":0,\"opacity\":1},\"Ageing\":{\"value\":5,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Makeup\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Blush\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Complexion\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"SunDamage\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Lipstick\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"MolesFreckles\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"ChestHair\":{\"value\":255,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"BodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"AddBodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1}}', '[]', 1, '2024-11-20 01:48:42', '2024-12-08 00:05:53'),
(15471, '1885233650', '{\"ShapeFirst\":7,\"ShapeSecond\":15,\"ShapeThird\":0,\"SkinFirst\":9,\"SkinSecond\":27,\"SkinThird\":18,\"ShapeMix\":0.11,\"SkinMix\":0.7,\"ThirdMix\":0.17}', '{\"nose_width\":0,\"nose_peak\":0,\"nose_length\":0,\"nose_bone_curveness\":0,\"nose_tip\":0,\"nose_bone_twist\":0,\"eyebrow_up_down\":0,\"eyebrow_in_out\":0,\"cheek_bones\":0,\"cheek_sideways_bone_size\":0,\"cheek_bones_width\":0,\"eye_opening\":0,\"lip_thickness\":0,\"jaw_bone_width\":0,\"jaw_bone_shape\":0,\"chin_bone\":0,\"chin_bone_length\":0,\"chin_bone_shape\":0,\"chin_hole\":0,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"FacialHair\":{\"value\":2,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":0.94},\"Eyebrows\":{\"value\":0,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Ageing\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Makeup\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Blush\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Complexion\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"SunDamage\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Lipstick\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"MolesFreckles\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"ChestHair\":{\"value\":255,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"BodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"AddBodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1}}', '{\"collection\":598190139,\"overlay\":-1207367545,\"layer\":0}', 0, '2024-11-25 15:58:51', '2024-12-09 23:01:24'),
(18874, 'ig_derek', '{\"ShapeFirst\":0,\"ShapeSecond\":0,\"ShapeThird\":0,\"SkinFirst\":0,\"SkinSecond\":0,\"SkinThird\":0,\"ShapeMix\":0,\"SkinMix\":0,\"ThirdMix\":0}', '{\"nose_width\":0,\"nose_peak\":0,\"nose_length\":0,\"nose_bone_curveness\":0,\"nose_tip\":0,\"nose_bone_twist\":0,\"eyebrow_up_down\":0,\"eyebrow_in_out\":0,\"cheek_bones\":0,\"cheek_sideways_bone_size\":0,\"cheek_bones_width\":0,\"eye_opening\":0,\"lip_thickness\":0,\"jaw_bone_width\":0,\"jaw_bone_shape\":0,\"chin_bone\":0,\"chin_bone_length\":0,\"chin_bone_shape\":0,\"chin_hole\":0,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"FacialHair\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Eyebrows\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Ageing\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Makeup\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Blush\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Complexion\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"SunDamage\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"Lipstick\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"MolesFreckles\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"ChestHair\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"BodyBlemishes\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0},\"AddBodyBlemishes\":{\"value\":0,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":0}}', '[]', -1, '2024-11-27 23:06:26', '2024-12-03 07:13:45'),
(18906, '1885233650', '{\"ShapeFirst\":2,\"ShapeSecond\":2,\"ShapeThird\":44,\"SkinFirst\":2,\"SkinSecond\":2,\"SkinThird\":15,\"ShapeMix\":0.24,\"SkinMix\":0.41,\"ThirdMix\":0.43}', '{\"nose_width\":0,\"nose_peak\":0,\"nose_length\":0,\"nose_bone_curveness\":0,\"nose_tip\":0,\"nose_bone_twist\":0,\"eyebrow_up_down\":0.6,\"eyebrow_in_out\":0.23,\"cheek_bones\":-1,\"cheek_sideways_bone_size\":-0.15,\"cheek_bones_width\":0.4,\"eye_opening\":0,\"lip_thickness\":-1,\"jaw_bone_width\":0,\"jaw_bone_shape\":0,\"chin_bone\":0,\"chin_bone_length\":0,\"chin_bone_shape\":1,\"chin_hole\":0,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"FacialHair\":{\"value\":11,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Eyebrows\":{\"value\":2,\"colorType\":1,\"firstColor\":0,\"secondColor\":61,\"opacity\":1},\"Ageing\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Makeup\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Blush\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Complexion\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"SunDamage\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Lipstick\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"MolesFreckles\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"ChestHair\":{\"value\":255,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"BodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"AddBodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1}}', '[]', 5, '2024-11-28 00:41:50', '2024-12-03 07:13:45'),
(17778, '1885233650', '{\"ShapeFirst\":6,\"ShapeSecond\":14,\"ShapeThird\":0,\"SkinFirst\":13,\"SkinSecond\":41,\"SkinThird\":42,\"ShapeMix\":0.21,\"SkinMix\":0.21,\"ThirdMix\":0.47}', '{\"nose_width\":0,\"nose_peak\":0,\"nose_length\":0,\"nose_bone_curveness\":0,\"nose_tip\":0,\"nose_bone_twist\":0,\"eyebrow_up_down\":0,\"eyebrow_in_out\":0,\"cheek_bones\":0,\"cheek_sideways_bone_size\":0,\"cheek_bones_width\":0,\"eye_opening\":0,\"lip_thickness\":0,\"jaw_bone_width\":0,\"jaw_bone_shape\":0,\"chin_bone\":0,\"chin_bone_length\":0,\"chin_bone_shape\":0,\"chin_hole\":0,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"FacialHair\":{\"value\":1,\"colorType\":1,\"firstColor\":9,\"secondColor\":15,\"opacity\":1},\"Eyebrows\":{\"value\":21,\"colorType\":1,\"firstColor\":8,\"secondColor\":15,\"opacity\":1},\"Ageing\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Makeup\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Blush\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Complexion\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"SunDamage\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Lipstick\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"MolesFreckles\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"ChestHair\":{\"value\":255,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"BodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"AddBodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1}}', NULL, 0, '2024-12-08 17:38:10', '2024-12-08 17:38:10'),
(18004, '1885233650', '{\"ShapeFirst\":25,\"ShapeSecond\":21,\"ShapeThird\":29,\"SkinFirst\":36,\"SkinSecond\":38,\"SkinThird\":17,\"ShapeMix\":0.44,\"SkinMix\":0.96,\"ThirdMix\":0.95}', '{\"nose_width\":0,\"nose_peak\":0.82,\"nose_length\":1,\"nose_bone_curveness\":1,\"nose_tip\":0.54,\"nose_bone_twist\":0,\"eyebrow_up_down\":0,\"eyebrow_in_out\":0,\"cheek_bones\":0,\"cheek_sideways_bone_size\":0,\"cheek_bones_width\":0,\"eye_opening\":0,\"lip_thickness\":0,\"jaw_bone_width\":0,\"jaw_bone_shape\":0,\"chin_bone\":0,\"chin_bone_length\":0,\"chin_bone_shape\":0,\"chin_hole\":0,\"neck_thickness\":0}', '{\"Blemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"FacialHair\":{\"value\":1,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Eyebrows\":{\"value\":0,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":0.65},\"Ageing\":{\"value\":1,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Makeup\":{\"value\":255,\"colorType\":2,\"firstColor\":27,\"secondColor\":0,\"opacity\":0.61},\"Blush\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Complexion\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"SunDamage\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"Lipstick\":{\"value\":255,\"colorType\":2,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"MolesFreckles\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"ChestHair\":{\"value\":255,\"colorType\":1,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"BodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1},\"AddBodyBlemishes\":{\"value\":255,\"colorType\":0,\"firstColor\":0,\"secondColor\":0,\"opacity\":1}}', '{\"collection\":-2086773,\"overlay\":-131530830,\"layer\":0}', 0, '2024-12-09 01:23:37', '2024-12-09 01:53:24');
-- --------------------------------------------------------
--
-- Table structure for table `karma_outfits`
--
CREATE TABLE `karma_outfits` (
`id` int(11) NOT NULL,
`cid` int(11) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`tags` varchar(255) DEFAULT NULL,
`slot` int(11) DEFAULT NULL,
`model` varchar(255) DEFAULT NULL,
`drawables_texture` text DEFAULT NULL,
`props_texture` text DEFAULT NULL,
`hairColor` text DEFAULT NULL,
`fadeLayer` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '[]' CHECK (json_valid(`fadeLayer`)),
`customHeadModel` varchar(255) DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp(),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `karma_clothing`
--
ALTER TABLE `karma_clothing`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `karma_outfits`
--
ALTER TABLE `karma_outfits`
ADD PRIMARY KEY (`id`) USING BTREE,
ADD UNIQUE KEY `unique_cid_slot` (`cid`,`slot`) USING BTREE;
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `karma_outfits`
--
ALTER TABLE `karma_outfits`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- Constraints for dumped tables
--
--
-- Constraints for table `karma_clothing`
--
ALTER TABLE `karma_clothing`
ADD CONSTRAINT `karma_clothing_ibfk_1` FOREIGN KEY (`id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;
