PHPize Online / SQLize Online  /  SQLtest Online

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);