-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3308:3308
-- Generation Time: Mar 22, 2026 at 09:53 AM
-- 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: `km_trenesanas_eksamenam_1`
--

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

--
-- Structure for view `km_resultat_1`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`kaznovska_m`@`localhost` SQL SECURITY DEFINER VIEW `km_resultat_1`  AS SELECT `l`.`numurs` AS `ligums`, `ld`.`darba_nr` AS `darba_nr`, `ld`.`nosaukums` AS `darbs`, `t`.`daudzums` AS `daudzums`, `m`.`isais` AS `mervieniba`, `ld`.`ligumcena` AS `cena`, (`t`.`daudzums` * `ld`.`ligumcena`) AS `kopa`, date_format(`r`.`datums`,'%d.%m') AS `datums`, concat(`p`.`vards`,' ',`p`.`uzvards`) AS `persona`, `v`.`nosaukums` AS `vieta`, `dt`.`nosaukums` AS `darba_tips` FROM (((((((`tame` `t` join `liguma_darbi` `ld` on((`t`.`lig_darb_id` = `ld`.`id`))) join `ligums` `l` on((`ld`.`liguma_id` = `l`.`id`))) join `mervienibas` `m` on((`ld`.`merv_id` = `m`.`id`))) join `persona` `p` on((`t`.`pers_id` = `p`.`id`))) join `vieta` `v` on((`t`.`vieta_id` = `v`.`id`))) join `darba_tipi` `dt` on((`t`.`darba_tips_id` = `dt`.`id`))) join `rekins` `r` on((`r`.`tame_id` = `t`.`id`))) ORDER BY `r`.`datums` ASC, `v`.`nosaukums` ASC ;

--
-- VIEW `km_resultat_1`
-- 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 */;