-- --------------------------------------------------------
-- Host:                         153.92.1.116
-- Server version:               8.0.45-0ubuntu0.22.04.1 - (Ubuntu)
-- Server OS:                    Linux
-- HeidiSQL Version:             12.12.0.7122
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for el_trenesanas_eksamenam_1
CREATE DATABASE IF NOT EXISTS `el_trenesanas_eksamenam_1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `el_trenesanas_eksamenam_1`;

-- Dumping structure for table el_trenesanas_eksamenam_1.date
CREATE TABLE IF NOT EXISTS `date` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Unikāls numurs',
  `week_day` tinyint DEFAULT NULL COMMENT 'Nedēļas diena',
  `date` date DEFAULT NULL COMMENT 'Datums katrai dienai',
  `time` time DEFAULT NULL COMMENT 'Stundas laiks',
  `start_time` datetime DEFAULT NULL COMMENT 'Sākuma laiks',
  `end_time` datetime DEFAULT NULL COMMENT 'Beigu laiks',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Datumu un laiku tabula';

-- Dumping data for table el_trenesanas_eksamenam_1.date: ~0 rows (approximately)
INSERT INTO `date` (`id`, `week_day`, `date`, `time`, `start_time`, `end_time`) VALUES
	(1, 1, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(2, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(3, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(4, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(5, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(6, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(7, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(8, 2, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(9, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(10, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(11, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(12, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(13, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(14, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(15, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(16, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(17, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(18, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(19, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(20, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(21, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(22, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(23, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(24, 3, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(25, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(26, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(27, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(28, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(29, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(30, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(31, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(32, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(33, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(34, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(35, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(36, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(37, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(38, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(39, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(40, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(41, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(42, 4, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(43, 5, '0000-00-00', '00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- Dumping structure for table el_trenesanas_eksamenam_1.funds_info
CREATE TABLE IF NOT EXISTS `funds_info` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Unikāls numurs',
  `price` decimal(20,0) DEFAULT NULL COMMENT 'Cena par darbu',
  `amount` decimal(20,0) DEFAULT NULL COMMENT 'Daudzums cik nepieciešams',
  `sum` decimal(20,0) DEFAULT NULL COMMENT 'Kopējā summa',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Finanšu informācijas tabula';

-- Dumping data for table el_trenesanas_eksamenam_1.funds_info: ~0 rows (approximately)

-- Dumping structure for table el_trenesanas_eksamenam_1.work
CREATE TABLE IF NOT EXISTS `work` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Unikālais numurs',
  `work_type` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Darba nosaukums',
  `work_problem` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Darba kļūdu apraksts',
  `work_nr` decimal(5,2) DEFAULT NULL COMMENT 'Darba numurs',
  `follow_nr` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Apsekojuma numurs',
  `unit` int DEFAULT NULL COMMENT 'Mērvienības norādes skaitlis',
  `measurement` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Mērvienības nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Darbu tabula';

-- Dumping data for table el_trenesanas_eksamenam_1.work: ~0 rows (approximately)

-- Dumping structure for table el_trenesanas_eksamenam_1.worker
CREATE TABLE IF NOT EXISTS `worker` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Unikāls numurs',
  `worker_name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Darbinieka vārds',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Darbinieku tabula';

-- Dumping data for table el_trenesanas_eksamenam_1.worker: ~0 rows (approximately)

-- Dumping structure for table el_trenesanas_eksamenam_1.work_place
CREATE TABLE IF NOT EXISTS `work_place` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'Unikāls numurs',
  `work_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Darba vietas nosaukums',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Darba vietu tabula';

-- Dumping data for table el_trenesanas_eksamenam_1.work_place: ~0 rows (approximately)

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
