-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Nov 21, 2024 at 12:32 AM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 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: `rb_kvalif_410` -- -- -------------------------------------------------------- -- -- Table structure for table `rb_kvalif_faq_410` -- CREATE TABLE `rb_kvalif_faq_410` ( `id` int(11) NOT NULL, `question` varchar(255) NOT NULL, `answer` text 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; -- -- Dumping data for table `rb_kvalif_faq_410` -- INSERT INTO `rb_kvalif_faq_410` (`id`, `question`, `answer`, `created_at`, `updated_at`) VALUES (3, 'kur', 'kad', '2024-11-18 16:34:31', '2024-11-18 16:34:31'); -- -------------------------------------------------------- -- -- Table structure for table `rb_kvalif_materialcount_410` -- CREATE TABLE `rb_kvalif_materialcount_410` ( `id` int(11) NOT NULL, `sku_code` varchar(50) NOT NULL, `material_type` varchar(100) NOT NULL, `material_size` varchar(50) NOT NULL, `material_count` int(11) NOT NULL, `status` enum('Pietiekami','Mazāk par normu','Beidzies') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `rb_kvalif_materialcount_410` -- INSERT INTO `rb_kvalif_materialcount_410` (`id`, `sku_code`, `material_type`, `material_size`, `material_count`, `status`) VALUES (7, '1003', 'Hole', '40mm', 1, 'Mazāk par normu'), (8, '1042', 'Rubber', '35mm', 0, 'Beidzies'); -- -------------------------------------------------------- -- -- Table structure for table `rb_kvalif_signup_410` -- CREATE TABLE `rb_kvalif_signup_410` ( `id` int(11) NOT NULL, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `area_code` varchar(10) DEFAULT NULL, `phone_number` varchar(20) DEFAULT NULL, `contract_number` varchar(20) NOT NULL, `work_position` varchar(50) DEFAULT NULL, `password` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `rb_kvalif_signup_410` -- INSERT INTO `rb_kvalif_signup_410` (`id`, `first_name`, `last_name`, `email`, `area_code`, `phone_number`, `contract_number`, `work_position`, `password`) VALUES (1, 'Roberts', 'Blite', 'robertsblite@yahoo.com', '+371', '20233456', '123', 'darbinieks', '$2y$10$xnUK/lK826lP547cckPY6.dKMER3QOYbT7K26RvUDzXf/xvSCS3Ty'), (7, 'Keitija', 'Berzina', 'kekozaurs@gmail.com', '+371', '20022351', 'plikasolas', 'darbinieks', '$2y$10$QXcPRXZ2jfyLUkMvKFUmRuQaARnkdt0DBce5WuBpinndkt3jqDG8y'), (9, 'Kačs', 'Valčs', 'kava@yahoo.com', '+371', '26666666', 'plikuolusaiets', 'valdes_loceklis', '$2y$10$82P/HSMH5IUn0pmT0YQhaO7wHg0k.RwzGs037ro.DaVCW8LnGBWDq'); -- -------------------------------------------------------- -- -- Table structure for table `rb_kvalif_workhours_410` -- CREATE TABLE `rb_kvalif_workhours_410` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `date` date NOT NULL, `clock_in_time` time NOT NULL, `clock_out_time` time DEFAULT NULL, `total_work_hours` decimal(5,2) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `rb_kvalif_workhours_410` -- INSERT INTO `rb_kvalif_workhours_410` (`id`, `user_id`, `date`, `clock_in_time`, `clock_out_time`, `total_work_hours`) VALUES (13, 1, '2024-11-17', '16:35:46', '16:35:50', 0.00), (14, 1, '2024-11-17', '16:36:07', '17:40:32', 1.07), (15, 7, '2024-11-17', '16:37:48', '16:38:01', 0.00), (16, 1, '2024-11-18', '17:34:09', '17:34:11', 0.00), (17, 1, '2024-11-20', '21:51:05', '21:51:11', 0.00), (18, 1, '2024-11-20', '22:07:38', '22:07:44', 0.00), (19, 1, '2024-11-20', '23:22:28', '23:22:31', 0.00), (20, 1, '2024-11-20', '23:22:34', '23:22:37', 0.00), (21, 1, '2024-11-20', '23:41:56', '23:42:01', 0.00), (22, 1, '2024-11-20', '23:59:37', '23:59:39', 0.00); -- -- Indexes for dumped tables -- -- -- Indexes for table `rb_kvalif_faq_410` -- ALTER TABLE `rb_kvalif_faq_410` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rb_kvalif_materialcount_410` -- ALTER TABLE `rb_kvalif_materialcount_410` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rb_kvalif_signup_410` -- ALTER TABLE `rb_kvalif_signup_410` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `contract_number` (`contract_number`), ADD UNIQUE KEY `unique_email` (`email`); -- -- Indexes for table `rb_kvalif_workhours_410` -- ALTER TABLE `rb_kvalif_workhours_410` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `rb_kvalif_faq_410` -- ALTER TABLE `rb_kvalif_faq_410` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `rb_kvalif_materialcount_410` -- ALTER TABLE `rb_kvalif_materialcount_410` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `rb_kvalif_signup_410` -- ALTER TABLE `rb_kvalif_signup_410` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT for table `rb_kvalif_workhours_410` -- ALTER TABLE `rb_kvalif_workhours_410` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- Constraints for dumped tables -- -- -- Constraints for table `rb_kvalif_workhours_410` -- ALTER TABLE `rb_kvalif_workhours_410` ADD CONSTRAINT `rb_kvalif_workhours_410_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `rb_kvalif_signup_410` (`id`); 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 */;