pdc9G91y

1-- phpMyAdmin SQL Dump
2-- version 4.8.5
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Nov 07, 2019 at 11:28 AM
7-- Server version: 5.7.26
8-- PHP Version: 7.2.18
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `izglitibas_iestade_isilins`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `maca`
29--
30
31DROP TABLE IF EXISTS `maca`;
32CREATE TABLE IF NOT EXISTS `maca` (
33  `semestris` int(11) DEFAULT NULL,
34  `p_stundas` int(11) DEFAULT NULL,
35  `t_stundas` int(11) DEFAULT NULL,
36  `grupa` int(11) NOT NULL,
37  `skolotajs` char(10) NOT NULL,
38  `prieksmets` int(11) NOT NULL,
39  PRIMARY KEY (`grupa`,`skolotajs`,`prieksmets`),
40  KEY `prieksmets` (`prieksmets`),
41  KEY `skolotajs` (`skolotajs`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1;
43
44--
45-- Dumping data for table `maca`
46--
47
48INSERT INTO `maca` (`semestris`, `p_stundas`, `t_stundas`, `grupa`, `skolotajs`, `prieksmets`) VALUES
49(7, 60, 60, 1, '11 111 111', 1),
50(7, 60, 60, 1, '22 222 222', 2),
51(7, 60, 60, 1, '33 333 333', 3),
52(7, 60, 60, 1, '33 333 333', 4),
53(7, 60, 60, 2, '11 111 111', 1),
54(7, 60, 60, 2, '22 222 222', 2),
55(7, 60, 60, 2, '33 333 333', 3),
56(7, 60, 60, 2, '33 333 333', 4),
57(7, 60, 60, 3, '11 111 111', 1),
58(7, 60, 60, 3, '22 222 222', 2),
59(7, 60, 60, 3, '33 333 333', 3),
60(7, 60, 60, 3, '33 333 333', 4),
61(7, 60, 60, 4, '11 111 111', 1),
62(7, 60, 60, 4, '22 222 222', 2),
63(7, 60, 60, 4, '33 333 333', 3),
64(7, 60, 60, 4, '33 333 333', 4);
65
66--
67-- Constraints for dumped tables
68--
69
70--
71-- Constraints for table `maca`
72--
73ALTER TABLE `maca`
74  ADD CONSTRAINT `maca_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
75  ADD CONSTRAINT `maca_ibfk_2` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`),
76  ADD CONSTRAINT `maca_ibfk_3` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
77COMMIT;
78
79/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
80/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
81/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;