-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

