CREATE TABLE `short_links` (
                               `l_id` int(11) NOT NULL,
                               `l_code` varchar(25) NOT NULL,
                               `l_target` varchar(255) NOT NULL,
                               `l_created` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `short_links`
    ADD PRIMARY KEY (`l_id`);

ALTER TABLE `short_links`
    MODIFY `l_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;


INSERT INTO `short_links` (`l_id`, `l_code`, `l_target`, `l_created`) VALUES
                                                                          (1, '123', 'https://tuxtorials.de', '2025-04-23 11:27:08'),
                                                                          (2, 'abc', 'https://elznir-games.de', '2025-04-23 11:27:08');