CREATE TABLE `user` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`uuid` varchar(50) NOT NULL,
`email` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`pwd` varchar(255) NOT NULL,
`data` longtext DEFAULT NULL,
`geloescht` tinyint(4) NOT NULL DEFAULT 0,
`role` varchar(10) NOT NULL,
`allowed_pet_owner_uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
`reset_password` longtext DEFAULT NULL,
`temp_token` varchar(255) DEFAULT NULL,
`reset_password_uuid` varchar(100) DEFAULT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;
INSERT INTO `user` (`uuid`, `email`, `pwd`, `data`, `geloescht`, `role`, `allowed_pet_owner_uuid`, `reset_password`, `temp_token`, `reset_password_uuid`)
VALUES
('123e4567-e89b-12d3-a456-426614174000', 'user@example.com', 'hashed_password_here', NULL, 0, 'admin', NULL, NULL, NULL, NULL);