-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 13, 2022 at 04:28 AM -- Server version: 10.9.3-MariaDB -- PHP Version: 7.4.27 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `springbackend` -- -- -------------------------------------------------------- -- -- Table structure for table `tbl_workers` -- CREATE TABLE `tbl_workers` ( `id` bigint(20) NOT NULL, `status` varchar(255) DEFAULT NULL, `workerfname` varchar(255) DEFAULT NULL, `workerlname` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `tbl_workers` -- INSERT INTO `tbl_workers` (`id`, `status`, `workerfname`, `workerlname`) VALUES (1, 'Working', 'Ivan', 'Holicek'), (37, 'Vacation', 'Marko', 'Markovic'), (40, 'Working', 'Ivo', 'Ivica'), (41, 'Working', 'Luka', 'Lukovic'), (42, 'Working', 'Filip', 'Filipovic'); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbl_workers` -- ALTER TABLE `tbl_workers` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbl_workers` -- ALTER TABLE `tbl_workers` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;