-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3308:3308
-- Generation Time: Mar 22, 2026 at 09:59 PM
-- Server version: 8.0.45-0ubuntu0.22.04.1
-- PHP Version: 8.1.2-1ubuntu2.23

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: `sr_trenesanas_eksamenam_1`
--

-- --------------------------------------------------------

--
-- Structure for view `excel_atskaite`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`staskevics_r`@`localhost` SQL SECURITY DEFINER VIEW `excel_atskaite`  AS SELECT `i`.`id_ieraksti` AS `Nr.`, `i`.`datums_no` AS `Datums No`, `i`.`laiks_no` AS `Laiks No`, `dt`.`darba_tips` AS `Darba tips`, `v`.`vieta` AS `Vieta`, `i`.`kludu_apraksts` AS `Kļūdu apraksts`, `i`.`datums_lidz` AS `Datums Līdz`, `i`.`laiks_lidz` AS `Laiks Līdz`, `izp`.`darba_veicejs` AS `Izpildītājs`, `d`.`nosaukums` AS `Darba nosaukums`, `d`.`cena` AS `Cena`, `d`.`daudzums` AS `Daudzums`, (`d`.`cena` * `d`.`daudzums`) AS `Kopā` FROM ((((`ieraksti` `i` left join `darba_tips` `dt` on((`i`.`id_darba_tips` = `dt`.`id_darba_tips`))) left join `vieta` `v` on((`i`.`id_vieta` = `v`.`id_vieta`))) left join `izpilditajs` `izp` on((`i`.`id_izpilditajs` = `izp`.`id_izpilditajs`))) left join `darbi` `d` on((`i`.`id_darbi` = `d`.`id_darbi`))) ;

--
-- VIEW `excel_atskaite`
-- Data: None
--

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 */;