cwdYhQ9e

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 21, 2019 at 10:27 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: `audzekni`
23--
24CREATE DATABASE IF NOT EXISTS `audzekni` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
25USE `audzekni`;
26--
27-- Database: `ivkins_traskovs_lidosta`
28--
29CREATE DATABASE IF NOT EXISTS `ivkins_traskovs_lidosta` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
30USE `ivkins_traskovs_lidosta`;
31
32-- --------------------------------------------------------
33
34--
35-- Table structure for table `biletes`
36--
37
38DROP TABLE IF EXISTS `biletes`;
39CREATE TABLE IF NOT EXISTS `biletes` (
40  `ID` int(11) NOT NULL AUTO_INCREMENT,
41  `Klients` char(12) DEFAULT NULL,
42  `Reiss` int(11) DEFAULT NULL,
43  `cena` double(10,2) DEFAULT NULL,
44  PRIMARY KEY (`ID`),
45  KEY `Klients` (`Klients`),
46  KEY `Reiss` (`Reiss`)
47) ENGINE=MyISAM DEFAULT CHARSET=latin1;
48
49-- --------------------------------------------------------
50
51--
52-- Table structure for table `errors`
53--
54
55DROP TABLE IF EXISTS `errors`;
56CREATE TABLE IF NOT EXISTS `errors` (
57  `ID` int(11) NOT NULL AUTO_INCREMENT,
58  `message` char(200) DEFAULT NULL,
59  `datums` datetime DEFAULT NULL,
60  PRIMARY KEY (`ID`)
61) ENGINE=MyISAM DEFAULT CHARSET=latin1;
62
63-- --------------------------------------------------------
64
65--
66-- Table structure for table `klienti`
67--
68
69DROP TABLE IF EXISTS `klienti`;
70CREATE TABLE IF NOT EXISTS `klienti` (
71  `Pers_kods` char(12) NOT NULL,
72  `Pases_nr` char(9) DEFAULT NULL,
73  `Vards` char(30) DEFAULT NULL,
74  `Uzvards` char(30) DEFAULT NULL,
75  `Termins` date DEFAULT NULL,
76  `dzimdat` date DEFAULT NULL,
77  PRIMARY KEY (`Pers_kods`)
78) ENGINE=MyISAM DEFAULT CHARSET=latin1;
79
80--
81-- Dumping data for table `klienti`
82--
83
84INSERT INTO `klienti` (`Pers_kods`, `Pases_nr`, `Vards`, `Uzvards`, `Termins`, `dzimdat`) VALUES
85('111111-11111', 'LV1234567', 'Mihails', 'Ivkins', '2020-10-10', '2000-10-10'),
86('111111-11122', 'LV1234569', 'Vladislavs', 'Traskovs', '2020-10-10', '2006-10-10'),
87('111111-13333', 'LV1234532', 'Dmitrijs', 'Pavlovics', '2021-10-10', '1942-02-10');
88
89--
90-- Triggers `klienti`
91--
92DROP TRIGGER IF EXISTS `addingKlients`;
93DELIMITER $$
94CREATE TRIGGER `addingKlients` BEFORE INSERT ON `klienti` FOR EACH ROW begin
95IF isValidCode(new.pers_kods)=0 THEN set new.pers_kods = "??";
96insert into kludas(message, datums) values ("Pievienots lietotajs ar nepareizo personas kodu!", now());
97END IF;
98end
99$$
100DELIMITER ;
101
102-- --------------------------------------------------------
103
104--
105-- Table structure for table `pilsetas`
106--
107
108DROP TABLE IF EXISTS `pilsetas`;
109CREATE TABLE IF NOT EXISTS `pilsetas` (
110  `ID` int(11) NOT NULL AUTO_INCREMENT,
111  `Nosaukums` char(30) DEFAULT NULL,
112  PRIMARY KEY (`ID`)
113) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
114
115--
116-- Dumping data for table `pilsetas`
117--
118
119INSERT INTO `pilsetas` (`ID`, `Nosaukums`) VALUES
120(1, 'Kiev'),
121(2, 'New York'),
122(3, 'Tallin');
123
124-- --------------------------------------------------------
125
126--
127-- Table structure for table `reisi`
128--
129
130DROP TABLE IF EXISTS `reisi`;
131CREATE TABLE IF NOT EXISTS `reisi` (
132  `ID` int(11) NOT NULL AUTO_INCREMENT,
133  `Cena` double(10,2) DEFAULT NULL,
134  `Datums` date DEFAULT NULL,
135  `Laiks` time DEFAULT NULL,
136  `pilseta` int(11) DEFAULT NULL,
137  PRIMARY KEY (`ID`),
138  KEY `pilseta` (`pilseta`)
139) ENGINE=MyISAM DEFAULT CHARSET=latin1;
140--
141-- Database: `izglitibas_iestade_rberzins`
142--
143CREATE DATABASE IF NOT EXISTS `izglitibas_iestade_rberzins` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
144USE `izglitibas_iestade_rberzins`;
145
146-- --------------------------------------------------------
147
148--
149-- Table structure for table `audzekni`
150--
151
152DROP TABLE IF EXISTS `audzekni`;
153CREATE TABLE IF NOT EXISTS `audzekni` (
154  `id` int(11) NOT NULL AUTO_INCREMENT,
155  `vards` char(30) DEFAULT NULL,
156  `uzvards` char(50) DEFAULT NULL,
157  `dzimdiena` date DEFAULT NULL,
158  `grupa` int(11) DEFAULT NULL,
159  PRIMARY KEY (`id`),
160  KEY `grupa` (`grupa`)
161) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
162
163--
164-- Dumping data for table `audzekni`
165--
166
167INSERT INTO `audzekni` (`id`, `vards`, `uzvards`, `dzimdiena`, `grupa`) VALUES
168(1, 'Peteris', 'Rutkovskis', '2000-12-02', 5),
169(2, 'Aleksis', 'Kozlovskis', '2000-01-01', 5),
170(3, 'Niks', 'Busalovs', '2000-07-24', 5),
171(4, 'Peteris', 'antonovs', '2000-09-13', 6),
172(5, 'Peteris', 'Rutkovskis', '2000-10-04', 6),
173(6, 'Peteris', 'mutkovskis', '2000-11-02', 6),
174(7, 'Peteris', 'kalnins', '2000-11-03', 7),
175(8, 'Peteris', 'galnins', '2000-11-14', 7),
176(9, 'Peteris', 'malnins', '2000-11-06', 7),
177(10, 'Beteris', 'alnins', '2000-01-18', 8),
178(11, 'meteris', 'valnins', '2000-08-08', 8),
179(12, 'veteris', 'salnins', '2000-06-28', 8);
180
181-- --------------------------------------------------------
182
183--
184-- Table structure for table `grupas`
185--
186
187DROP TABLE IF EXISTS `grupas`;
188CREATE TABLE IF NOT EXISTS `grupas` (
189  `id` int(11) NOT NULL AUTO_INCREMENT,
190  `nosaukums` char(5) DEFAULT NULL,
191  `kvalifikacija` int(11) DEFAULT NULL,
192  PRIMARY KEY (`id`),
193  KEY `kvalifikacija` (`kvalifikacija`)
194) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
195
196--
197-- Dumping data for table `grupas`
198--
199
200INSERT INTO `grupas` (`id`, `nosaukums`, `kvalifikacija`) VALUES
201(5, 'D4-1', 1),
202(6, 'd4-2', 1),
203(7, 'd4-3', 2),
204(8, 'd4-4', 2);
205
206-- --------------------------------------------------------
207
208--
209-- Table structure for table `komisijas`
210--
211
212DROP TABLE IF EXISTS `komisijas`;
213CREATE TABLE IF NOT EXISTS `komisijas` (
214  `id` int(11) NOT NULL AUTO_INCREMENT,
215  `nosaukums` char(100) DEFAULT NULL,
216  PRIMARY KEY (`id`)
217) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
218
219--
220-- Dumping data for table `komisijas`
221--
222
223INSERT INTO `komisijas` (`id`, `nosaukums`) VALUES
224(1, 'IKT');
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `kvalifikacijas`
230--
231
232DROP TABLE IF EXISTS `kvalifikacijas`;
233CREATE TABLE IF NOT EXISTS `kvalifikacijas` (
234  `id` int(11) NOT NULL AUTO_INCREMENT,
235  `nosaukums` char(50) DEFAULT NULL,
236  PRIMARY KEY (`id`)
237) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
238
239--
240-- Dumping data for table `kvalifikacijas`
241--
242
243INSERT INTO `kvalifikacijas` (`id`, `nosaukums`) VALUES
244(1, 'Programm??anas tehni?is'),
245(2, 'Datorsist?mu tehni?is');
246
247-- --------------------------------------------------------
248
249--
250-- Table structure for table `maca`
251--
252
253DROP TABLE IF EXISTS `maca`;
254CREATE TABLE IF NOT EXISTS `maca` (
255  `semestris` int(11) DEFAULT NULL,
256  `p_stundas` int(11) DEFAULT NULL,
257  `t_stundas` int(11) DEFAULT NULL,
258  `grupa` int(11) NOT NULL,
259  `skolotajs` char(10) NOT NULL,
260  `prieksmets` int(11) NOT NULL,
261  PRIMARY KEY (`grupa`,`skolotajs`,`prieksmets`),
262  KEY `prieksmets` (`prieksmets`),
263  KEY `skolotajs` (`skolotajs`)
264) ENGINE=InnoDB DEFAULT CHARSET=latin1;
265
266--
267-- Dumping data for table `maca`
268--
269
270INSERT INTO `maca` (`semestris`, `p_stundas`, `t_stundas`, `grupa`, `skolotajs`, `prieksmets`) VALUES
271(7, 34, 34, 5, '11 111 111', 1),
272(7, 34, 34, 5, '22 222 222', 2),
273(7, 34, 34, 5, '33 333 333', 3),
274(7, 34, 34, 5, '33 333 333', 4),
275(7, 34, 34, 6, '11 111 111', 1),
276(7, 34, 34, 6, '22 222 222', 2),
277(7, 34, 34, 6, '33 333 333', 3),
278(7, 34, 34, 6, '33 333 333', 4),
279(7, 34, 34, 7, '11 111 111', 1),
280(7, 34, 34, 7, '22 222 222', 2),
281(7, 34, 34, 7, '33 333 333', 3),
282(7, 34, 34, 7, '33 333 333', 4),
283(7, 34, 34, 8, '11 111 111', 1),
284(7, 34, 34, 8, '22 222 222', 2),
285(7, 34, 34, 8, '33 333 333', 3),
286(7, 34, 34, 8, '33 333 333', 4);
287
288-- --------------------------------------------------------
289
290--
291-- Table structure for table `macas`
292--
293
294DROP TABLE IF EXISTS `macas`;
295CREATE TABLE IF NOT EXISTS `macas` (
296  `vertejums` int(11) DEFAULT NULL,
297  `skolens` int(11) NOT NULL,
298  `prieksmets` int(11) NOT NULL,
299  PRIMARY KEY (`skolens`,`prieksmets`),
300  KEY `prieksmets` (`prieksmets`)
301) ENGINE=InnoDB DEFAULT CHARSET=latin1;
302
303--
304-- Dumping data for table `macas`
305--
306
307INSERT INTO `macas` (`vertejums`, `skolens`, `prieksmets`) VALUES
308(8, 1, 1),
309(8, 1, 2),
310(8, 1, 3),
311(8, 1, 4),
312(8, 2, 1),
313(8, 2, 2),
314(8, 2, 3),
315(8, 2, 4),
316(8, 3, 1),
317(8, 3, 2),
318(8, 3, 3),
319(8, 3, 4),
320(8, 4, 1),
321(8, 4, 2),
322(8, 4, 3),
323(8, 4, 4),
324(8, 5, 1),
325(8, 5, 2),
326(8, 5, 3),
327(8, 5, 4),
328(8, 6, 1),
329(8, 6, 2),
330(8, 6, 3),
331(8, 6, 4),
332(8, 7, 1),
333(8, 7, 2),
334(8, 7, 3),
335(8, 7, 4),
336(8, 8, 1),
337(8, 8, 2),
338(8, 8, 3),
339(8, 8, 4),
340(8, 9, 1),
341(8, 9, 2),
342(8, 9, 3),
343(8, 9, 4),
344(8, 10, 1),
345(8, 10, 2),
346(8, 10, 3),
347(8, 10, 4),
348(8, 11, 1),
349(8, 11, 2),
350(8, 11, 3),
351(8, 11, 4),
352(8, 12, 1),
353(8, 12, 2),
354(8, 12, 3),
355(8, 12, 4);
356
357-- --------------------------------------------------------
358
359--
360-- Table structure for table `pasniedz`
361--
362
363DROP TABLE IF EXISTS `pasniedz`;
364CREATE TABLE IF NOT EXISTS `pasniedz` (
365  `prieksmets` int(11) NOT NULL,
366  `skolotajs` char(10) NOT NULL,
367  PRIMARY KEY (`prieksmets`,`skolotajs`),
368  KEY `skolotajs` (`skolotajs`)
369) ENGINE=InnoDB DEFAULT CHARSET=latin1;
370
371--
372-- Dumping data for table `pasniedz`
373--
374
375INSERT INTO `pasniedz` (`prieksmets`, `skolotajs`) VALUES
376(1, '11 111 111'),
377(1, '22 222 222'),
378(2, '22 222 222'),
379(3, '33 333 333'),
380(4, '33 333 333');
381
382-- --------------------------------------------------------
383
384--
385-- Table structure for table `prieksmeti`
386--
387
388DROP TABLE IF EXISTS `prieksmeti`;
389CREATE TABLE IF NOT EXISTS `prieksmeti` (
390  `id` int(11) NOT NULL AUTO_INCREMENT,
391  `nosaukums` char(50) DEFAULT NULL,
392  PRIMARY KEY (`id`)
393) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
394
395--
396-- Dumping data for table `prieksmeti`
397--
398
399INSERT INTO `prieksmeti` (`id`, `nosaukums`) VALUES
400(1, 'datu bazes'),
401(2, 'operetajsistemas'),
402(3, 'datorsistemu_uzbuve'),
403(4, 'Datortikli');
404
405-- --------------------------------------------------------
406
407--
408-- Table structure for table `skolotaji`
409--
410
411DROP TABLE IF EXISTS `skolotaji`;
412CREATE TABLE IF NOT EXISTS `skolotaji` (
413  `talrunis` char(10) NOT NULL,
414  `vards` char(30) DEFAULT NULL,
415  `uzvards` char(50) DEFAULT NULL,
416  `stazs` int(11) DEFAULT NULL,
417  `komisija` int(11) DEFAULT NULL,
418  PRIMARY KEY (`talrunis`),
419  KEY `komisija` (`komisija`)
420) ENGINE=InnoDB DEFAULT CHARSET=latin1;
421
422--
423-- Dumping data for table `skolotaji`
424--
425
426INSERT INTO `skolotaji` (`talrunis`, `vards`, `uzvards`, `stazs`, `komisija`) VALUES
427('11 111 111', 'Jelena', 'Matvejeva', 15, 1),
428('22 222 222', 'Jurijs', 'Kudrins', 25, 1),
429('33 333 333', 'Vitalijs', 'Sabanskis', 10, 1);
430
431--
432-- Constraints for dumped tables
433--
434
435--
436-- Constraints for table `audzekni`
437--
438ALTER TABLE `audzekni`
439  ADD CONSTRAINT `audzekni_ibfk_1` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
440
441--
442-- Constraints for table `grupas`
443--
444ALTER TABLE `grupas`
445  ADD CONSTRAINT `grupas_ibfk_1` FOREIGN KEY (`kvalifikacija`) REFERENCES `kvalifikacijas` (`id`);
446
447--
448-- Constraints for table `maca`
449--
450ALTER TABLE `maca`
451  ADD CONSTRAINT `maca_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
452  ADD CONSTRAINT `maca_ibfk_2` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`),
453  ADD CONSTRAINT `maca_ibfk_3` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
454
455--
456-- Constraints for table `macas`
457--
458ALTER TABLE `macas`
459  ADD CONSTRAINT `macas_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
460  ADD CONSTRAINT `macas_ibfk_2` FOREIGN KEY (`skolens`) REFERENCES `audzekni` (`id`);
461
462--
463-- Constraints for table `pasniedz`
464--
465ALTER TABLE `pasniedz`
466  ADD CONSTRAINT `pasniedz_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
467  ADD CONSTRAINT `pasniedz_ibfk_2` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
468
469--
470-- Constraints for table `skolotaji`
471--
472ALTER TABLE `skolotaji`
473  ADD CONSTRAINT `skolotaji_ibfk_1` FOREIGN KEY (`komisija`) REFERENCES `komisijas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
474--
475-- Database: `kvalifikacijas`
476--
477CREATE DATABASE IF NOT EXISTS `kvalifikacijas` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
478USE `kvalifikacijas`;
479--
480-- Database: `name`
481--
482CREATE DATABASE IF NOT EXISTS `name` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
483USE `name`;
484
485-- --------------------------------------------------------
486
487--
488-- Table structure for table `info`
489--
490
491DROP TABLE IF EXISTS `info`;
492CREATE TABLE IF NOT EXISTS `info` (
493  `Izdevejs` char(50) NOT NULL,
494  `gads` year(4) DEFAULT NULL,
495  `Zanrs` char(50) NOT NULL,
496  `Albums` char(50) NOT NULL,
497  `Izpilditajs` char(50) NOT NULL,
498  `Prece` int(11) DEFAULT NULL,
499  UNIQUE KEY `Prece` (`Prece`)
500) ENGINE=InnoDB DEFAULT CHARSET=latin1;
501
502-- --------------------------------------------------------
503
504--
505-- Table structure for table `kategorija`
506--
507
508DROP TABLE IF EXISTS `kategorija`;
509CREATE TABLE IF NOT EXISTS `kategorija` (
510  `ID` int(11) NOT NULL AUTO_INCREMENT,
511  `Nosaukums` char(50) NOT NULL,
512  `Apraksts` text,
513  `Skaits` int(11) DEFAULT NULL,
514  PRIMARY KEY (`ID`)
515) ENGINE=InnoDB DEFAULT CHARSET=latin1;
516
517-- --------------------------------------------------------
518
519--
520-- Table structure for table `preces`
521--
522
523DROP TABLE IF EXISTS `preces`;
524CREATE TABLE IF NOT EXISTS `preces` (
525  `Kods` int(11) NOT NULL AUTO_INCREMENT,
526  `Nosaukums` char(50) NOT NULL,
527  `Bilde` blob,
528  `Skaits` int(11) DEFAULT NULL,
529  `Kategorija` int(11) DEFAULT NULL,
530  PRIMARY KEY (`Kods`),
531  KEY `Kategorija` (`Kategorija`)
532) ENGINE=InnoDB DEFAULT CHARSET=latin1;
533
534--
535-- Constraints for dumped tables
536--
537
538--
539-- Constraints for table `info`
540--
541ALTER TABLE `info`
542  ADD CONSTRAINT `info_ibfk_1` FOREIGN KEY (`Prece`) REFERENCES `preces` (`Kods`);
543
544--
545-- Constraints for table `preces`
546--
547ALTER TABLE `preces`
548  ADD CONSTRAINT `preces_ibfk_1` FOREIGN KEY (`Kategorija`) REFERENCES `kategorija` (`ID`);
549--
550-- Database: `preces`
551--
552CREATE DATABASE IF NOT EXISTS `preces` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
553USE `preces`;
554--
555-- Database: `restorans`
556--
557CREATE DATABASE IF NOT EXISTS `restorans` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
558USE `restorans`;
559
560-- --------------------------------------------------------
561
562--
563-- Table structure for table `galdini`
564--
565
566DROP TABLE IF EXISTS `galdini`;
567CREATE TABLE IF NOT EXISTS `galdini` (
568  `numurs` int(11) NOT NULL AUTO_INCREMENT,
569  `skaits` int(11) DEFAULT NULL,
570  `smeket` enum('Y','N') DEFAULT NULL,
571  PRIMARY KEY (`numurs`)
572) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
573
574--
575-- Dumping data for table `galdini`
576--
577
578INSERT INTO `galdini` (`numurs`, `skaits`, `smeket`) VALUES
579(1, 2, 'Y'),
580(2, 1, NULL),
581(3, 4, 'Y'),
582(4, 4, 'Y'),
583(5, 3, 'N'),
584(6, 4, 'Y'),
585(8, 4, 'N'),
586(9, 4, 'Y'),
587(10, 4, 'Y'),
588(12, 4, 'Y'),
589(13, 1, 'Y'),
590(14, 31, 'Y'),
591(16, 2, 'N');
592
593-- --------------------------------------------------------
594
595--
596-- Table structure for table `klienti`
597--
598
599DROP TABLE IF EXISTS `klienti`;
600CREATE TABLE IF NOT EXISTS `klienti` (
601  `talrunis` char(15) NOT NULL,
602  `epasts` char(50) DEFAULT NULL,
603  `vards` char(30) DEFAULT NULL,
604  `uzvards` char(50) DEFAULT NULL,
605  PRIMARY KEY (`talrunis`)
606) ENGINE=MyISAM DEFAULT CHARSET=latin1;
607
608-- --------------------------------------------------------
609
610--
611-- Table structure for table `pasutijumi`
612--
613
614DROP TABLE IF EXISTS `pasutijumi`;
615CREATE TABLE IF NOT EXISTS `pasutijumi` (
616  `datums` date DEFAULT NULL,
617  `summa` float DEFAULT NULL,
618  `pvn` float DEFAULT NULL,
619  `id` int(11) NOT NULL AUTO_INCREMENT,
620  `klients` char(15) DEFAULT NULL,
621  PRIMARY KEY (`id`),
622  KEY `klients` (`klients`)
623) ENGINE=MyISAM DEFAULT CHARSET=latin1;
624
625-- --------------------------------------------------------
626
627--
628-- Table structure for table `rezerve`
629--
630
631DROP TABLE IF EXISTS `rezerve`;
632CREATE TABLE IF NOT EXISTS `rezerve` (
633  `laiks` time NOT NULL,
634  `datums` date NOT NULL,
635  `stundas` int(11) DEFAULT NULL,
636  `klients` char(15) DEFAULT NULL,
637  `galdins` int(11) DEFAULT NULL,
638  PRIMARY KEY (`laiks`,`datums`),
639  KEY `klients` (`klients`),
640  KEY `galdins` (`galdins`)
641) ENGINE=MyISAM DEFAULT CHARSET=latin1;
642--
643-- Database: `restorans1`
644--
645CREATE DATABASE IF NOT EXISTS `restorans1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
646USE `restorans1`;
647
648-- --------------------------------------------------------
649
650--
651-- Table structure for table `galdini`
652--
653
654DROP TABLE IF EXISTS `galdini`;
655CREATE TABLE IF NOT EXISTS `galdini` (
656  `Nosaukums` char(50) NOT NULL,
657  `Vietu_skaits` int(11) NOT NULL,
658  `Smeketaju` tinyint(1) DEFAULT NULL,
659  PRIMARY KEY (`Nosaukums`)
660) ENGINE=InnoDB DEFAULT CHARSET=latin1;
661
662-- --------------------------------------------------------
663
664--
665-- Table structure for table `klienti`
666--
667
668DROP TABLE IF EXISTS `klienti`;
669CREATE TABLE IF NOT EXISTS `klienti` (
670  `Talrunis` int(11) NOT NULL,
671  `Epasts` char(50) NOT NULL,
672  `vards` char(50) NOT NULL,
673  `Uzvards` char(50) NOT NULL,
674  PRIMARY KEY (`Talrunis`)
675) ENGINE=InnoDB DEFAULT CHARSET=latin1;
676
677-- --------------------------------------------------------
678
679--
680-- Table structure for table `pasutijumi`
681--
682
683DROP TABLE IF EXISTS `pasutijumi`;
684CREATE TABLE IF NOT EXISTS `pasutijumi` (
685  `ID` int(11) NOT NULL AUTO_INCREMENT,
686  `datums` date DEFAULT NULL,
687  `summa` float DEFAULT NULL,
688  `PVN` float DEFAULT NULL,
689  `Klienti` int(11) DEFAULT NULL,
690  PRIMARY KEY (`ID`),
691  UNIQUE KEY `Klienti` (`Klienti`)
692) ENGINE=InnoDB DEFAULT CHARSET=latin1;
693
694-- --------------------------------------------------------
695
696--
697-- Table structure for table `starptabula`
698--
699
700DROP TABLE IF EXISTS `starptabula`;
701CREATE TABLE IF NOT EXISTS `starptabula` (
702  `Laiks` time NOT NULL,
703  `datums` date NOT NULL,
704  `stundas` int(11) NOT NULL,
705  `Klienti` int(11) NOT NULL,
706  `Galdini` char(50) NOT NULL,
707  KEY `Klienti` (`Klienti`),
708  KEY `Galdini` (`Galdini`)
709) ENGINE=InnoDB DEFAULT CHARSET=latin1;
710
711--
712-- Constraints for dumped tables
713--
714
715--
716-- Constraints for table `pasutijumi`
717--
718ALTER TABLE `pasutijumi`
719  ADD CONSTRAINT `pasutijumi_ibfk_1` FOREIGN KEY (`Klienti`) REFERENCES `klienti` (`Talrunis`);
720
721--
722-- Constraints for table `starptabula`
723--
724ALTER TABLE `starptabula`
725  ADD CONSTRAINT `starptabula_ibfk_1` FOREIGN KEY (`Klienti`) REFERENCES `klienti` (`Talrunis`),
726  ADD CONSTRAINT `starptabula_ibfk_2` FOREIGN KEY (`Galdini`) REFERENCES `galdini` (`Nosaukums`);
727--
728-- Database: `restorans2`
729--
730CREATE DATABASE IF NOT EXISTS `restorans2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
731USE `restorans2`;
732--
733-- Database: `skola`
734--
735CREATE DATABASE IF NOT EXISTS `skola` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
736USE `skola`;
737
738-- --------------------------------------------------------
739
740--
741-- Table structure for table `audzekni`
742--
743
744DROP TABLE IF EXISTS `audzekni`;
745CREATE TABLE IF NOT EXISTS `audzekni` (
746  `personas_kods` char(12) NOT NULL,
747  `vards_uzvards` char(100) NOT NULL,
748  `talrunis` char(12) NOT NULL,
749  `bilde` blob,
750  `dzimsanas_datums` date NOT NULL,
751  `vecums` int(11) NOT NULL,
752  `kvalifikacijas_nosaukums` char(50) NOT NULL,
753  `Grupa` char(20) NOT NULL,
754  PRIMARY KEY (`personas_kods`)
755) ENGINE=InnoDB DEFAULT CHARSET=latin1;
756
757-- --------------------------------------------------------
758
759--
760-- Table structure for table `grupas`
761--
762
763DROP TABLE IF EXISTS `grupas`;
764CREATE TABLE IF NOT EXISTS `grupas` (
765  `ID` int(11) NOT NULL AUTO_INCREMENT,
766  `grupas` char(20) DEFAULT NULL,
767  `kvalifikacija` int(10) DEFAULT NULL,
768  PRIMARY KEY (`ID`)
769) ENGINE=InnoDB DEFAULT CHARSET=latin1;
770
771-- --------------------------------------------------------
772
773--
774-- Table structure for table `kvalifikacija`
775--
776
777DROP TABLE IF EXISTS `kvalifikacija`;
778CREATE TABLE IF NOT EXISTS `kvalifikacija` (
779  `ID` int(11) NOT NULL AUTO_INCREMENT,
780  `nosaukums` char(40) DEFAULT NULL,
781  PRIMARY KEY (`ID`)
782) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
783
784--
785-- Dumping data for table `kvalifikacija`
786--
787
788INSERT INTO `kvalifikacija` (`ID`, `nosaukums`) VALUES
789(1, 'programmesanas tehnikis'),
790(2, 'datorsistemu tehnikis');
791
792-- --------------------------------------------------------
793
794--
795-- Table structure for table `macibu_plans`
796--
797
798DROP TABLE IF EXISTS `macibu_plans`;
799CREATE TABLE IF NOT EXISTS `macibu_plans` (
800  `semestris` int(11) NOT NULL,
801  `teorija` int(11) NOT NULL,
802  `praktika` int(11) NOT NULL,
803  `audzekni` char(12) DEFAULT NULL,
804  `skolotaji` int(11) DEFAULT NULL,
805  KEY `audzekni` (`audzekni`)
806) ENGINE=InnoDB DEFAULT CHARSET=latin1;
807
808-- --------------------------------------------------------
809
810--
811-- Table structure for table `macibu_prieksmeti`
812--
813
814DROP TABLE IF EXISTS `macibu_prieksmeti`;
815CREATE TABLE IF NOT EXISTS `macibu_prieksmeti` (
816  `Nosaukums` char(50) NOT NULL,
817  PRIMARY KEY (`Nosaukums`)
818) ENGINE=InnoDB DEFAULT CHARSET=latin1;
819
820-- --------------------------------------------------------
821
822--
823-- Table structure for table `pr_sk`
824--
825
826DROP TABLE IF EXISTS `pr_sk`;
827CREATE TABLE IF NOT EXISTS `pr_sk` (
828  `macibu_prieksmeti` char(50) DEFAULT NULL,
829  `skolotaji` int(11) DEFAULT NULL,
830  KEY `macibu_prieksmeti` (`macibu_prieksmeti`),
831  KEY `skolotaji` (`skolotaji`)
832) ENGINE=InnoDB DEFAULT CHARSET=latin1;
833
834-- --------------------------------------------------------
835
836--
837-- Table structure for table `skolotaji`
838--
839
840DROP TABLE IF EXISTS `skolotaji`;
841CREATE TABLE IF NOT EXISTS `skolotaji` (
842  `vards_uzvards` char(50) NOT NULL,
843  `talrunis` int(11) NOT NULL,
844  `stazs` int(50) NOT NULL,
845  `komisija` char(50) NOT NULL,
846  PRIMARY KEY (`talrunis`)
847) ENGINE=InnoDB DEFAULT CHARSET=latin1;
848
849-- --------------------------------------------------------
850
851--
852-- Table structure for table `vertejumi`
853--
854
855DROP TABLE IF EXISTS `vertejumi`;
856CREATE TABLE IF NOT EXISTS `vertejumi` (
857  `vertejumi` int(11) NOT NULL,
858  `audzekni` char(12) DEFAULT NULL,
859  `macibu_prieksmeti` char(50) DEFAULT NULL,
860  KEY `audzekni` (`audzekni`),
861  KEY `macibu_prieksmeti` (`macibu_prieksmeti`)
862) ENGINE=InnoDB DEFAULT CHARSET=latin1;
863
864--
865-- Constraints for dumped tables
866--
867
868--
869-- Constraints for table `macibu_plans`
870--
871ALTER TABLE `macibu_plans`
872  ADD CONSTRAINT `macibu_plans_ibfk_1` FOREIGN KEY (`audzekni`) REFERENCES `audzekni` (`personas_kods`);
873
874--
875-- Constraints for table `pr_sk`
876--
877ALTER TABLE `pr_sk`
878  ADD CONSTRAINT `pr_sk_ibfk_1` FOREIGN KEY (`macibu_prieksmeti`) REFERENCES `macibu_prieksmeti` (`Nosaukums`),
879  ADD CONSTRAINT `pr_sk_ibfk_2` FOREIGN KEY (`skolotaji`) REFERENCES `skolotaji` (`talrunis`);
880
881--
882-- Constraints for table `vertejumi`
883--
884ALTER TABLE `vertejumi`
885  ADD CONSTRAINT `vertejumi_ibfk_1` FOREIGN KEY (`audzekni`) REFERENCES `audzekni` (`personas_kods`),
886  ADD CONSTRAINT `vertejumi_ibfk_2` FOREIGN KEY (`macibu_prieksmeti`) REFERENCES `macibu_prieksmeti` (`Nosaukums`);
887--
888-- Database: `skola1`
889--
890CREATE DATABASE IF NOT EXISTS `skola1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
891USE `skola1`;
892
893-- --------------------------------------------------------
894
895--
896-- Table structure for table `audzekni`
897--
898
899DROP TABLE IF EXISTS `audzekni`;
900CREATE TABLE IF NOT EXISTS `audzekni` (
901  `personas_kods` char(12) NOT NULL,
902  `vards` char(50) NOT NULL,
903  `uzvards` char(50) NOT NULL,
904  `talrunis` char(12) NOT NULL,
905  `bilde` blob,
906  `dzimsanas_datums` date NOT NULL,
907  `vecums` int(11) NOT NULL,
908  `grupa` int(11) NOT NULL,
909  PRIMARY KEY (`personas_kods`),
910  KEY `grupa` (`grupa`)
911) ENGINE=InnoDB DEFAULT CHARSET=latin1;
912
913-- --------------------------------------------------------
914
915--
916-- Table structure for table `grupa`
917--
918
919DROP TABLE IF EXISTS `grupa`;
920CREATE TABLE IF NOT EXISTS `grupa` (
921  `ID` int(11) NOT NULL,
922  `nosaukums` char(50) NOT NULL,
923  `kvalifikacija` int(11) NOT NULL,
924  PRIMARY KEY (`ID`),
925  KEY `kvalifikacija` (`kvalifikacija`)
926) ENGINE=InnoDB DEFAULT CHARSET=latin1;
927
928--
929-- Dumping data for table `grupa`
930--
931
932INSERT INTO `grupa` (`ID`, `nosaukums`, `kvalifikacija`) VALUES
933(1, 'D4-1', 1),
934(2, 'D4-2', 1),
935(3, 'D4-3', 2),
936(4, 'D4-4', 2),
937(5, 'D3-1', 1),
938(6, 'D3-4', 2);
939
940-- --------------------------------------------------------
941
942--
943-- Table structure for table `komisija`
944--
945
946DROP TABLE IF EXISTS `komisija`;
947CREATE TABLE IF NOT EXISTS `komisija` (
948  `ID` int(11) NOT NULL,
949  `nosaukums` char(50) NOT NULL,
950  PRIMARY KEY (`ID`)
951) ENGINE=InnoDB DEFAULT CHARSET=latin1;
952
953--
954-- Dumping data for table `komisija`
955--
956
957INSERT INTO `komisija` (`ID`, `nosaukums`) VALUES
958(1, 'Informacijas un komunikacijas tehnologijas'),
959(2, 'Latviesu valodas un literaturas'),
960(3, 'matematikas un dabaszinatnes');
961
962-- --------------------------------------------------------
963
964--
965-- Table structure for table `kvalifikacija`
966--
967
968DROP TABLE IF EXISTS `kvalifikacija`;
969CREATE TABLE IF NOT EXISTS `kvalifikacija` (
970  `ID` int(11) NOT NULL,
971  `nosaukums` char(50) NOT NULL,
972  PRIMARY KEY (`ID`)
973) ENGINE=InnoDB DEFAULT CHARSET=latin1;
974
975--
976-- Dumping data for table `kvalifikacija`
977--
978
979INSERT INTO `kvalifikacija` (`ID`, `nosaukums`) VALUES
980(1, 'Programmesanas tehnikis'),
981(2, 'Datorsistemu tehnikis');
982
983-- --------------------------------------------------------
984
985--
986-- Table structure for table `macibu_plans`
987--
988
989DROP TABLE IF EXISTS `macibu_plans`;
990CREATE TABLE IF NOT EXISTS `macibu_plans` (
991  `semestris` int(11) NOT NULL,
992  `teorija` int(11) NOT NULL,
993  `praktika` int(11) NOT NULL,
994  `audzekni` char(12) NOT NULL,
995  `macibu_prieksmeti` int(11) NOT NULL,
996  KEY `audzekni` (`audzekni`),
997  KEY `macibu_prieksmeti` (`macibu_prieksmeti`)
998) ENGINE=InnoDB DEFAULT CHARSET=latin1;
999
1000-- --------------------------------------------------------
1001
1002--
1003-- Table structure for table `macibu_prieksmeti`
1004--
1005
1006DROP TABLE IF EXISTS `macibu_prieksmeti`;
1007CREATE TABLE IF NOT EXISTS `macibu_prieksmeti` (
1008  `ID` int(11) NOT NULL,
1009  `nosaukums` char(50) NOT NULL,
1010  PRIMARY KEY (`ID`)
1011) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1012
1013--
1014-- Dumping data for table `macibu_prieksmeti`
1015--
1016
1017INSERT INTO `macibu_prieksmeti` (`ID`, `nosaukums`) VALUES
1018(1, 'Datu bazes'),
1019(2, 'Operatajsistemas'),
1020(3, 'Datorsistemu uzbuve'),
1021(4, 'Datortikli'),
1022(5, 'Informatika'),
1023(6, 'Matematika'),
1024(7, 'Latviesu valoda'),
1025(8, 'Programmesanas valodas');
1026
1027-- --------------------------------------------------------
1028
1029--
1030-- Table structure for table `skolotaji`
1031--
1032
1033DROP TABLE IF EXISTS `skolotaji`;
1034CREATE TABLE IF NOT EXISTS `skolotaji` (
1035  `vards` char(50) NOT NULL,
1036  `uzvards` char(50) NOT NULL,
1037  `talrunis` char(12) NOT NULL,
1038  `stazs` int(11) NOT NULL,
1039  `komisija` int(11) NOT NULL,
1040  PRIMARY KEY (`talrunis`),
1041  KEY `komisija` (`komisija`)
1042) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1043
1044--
1045-- Dumping data for table `skolotaji`
1046--
1047
1048INSERT INTO `skolotaji` (`vards`, `uzvards`, `talrunis`, `stazs`, `komisija`) VALUES
1049('Jelena', 'Matvejeva', '11111111', 15, 1),
1050('Jurijs', 'Kudrins', '22222222', 25, 1),
1051('Vitalijs', 'Sabanskis', '33333333', 10, 1),
1052('Igors', 'Litvjakovs', '44444444', 20, 1),
1053('Olga', 'Sabanska', '55555555', 40, 1),
1054('Ingrida', 'Lasincka', '66666666', 20, 2),
1055('Rudolfs', 'Pavulens', '77777777', 5, 3),
1056('Edgars', 'Olehnovics', '88888888', 5, 1);
1057
1058-- --------------------------------------------------------
1059
1060--
1061-- Table structure for table `skolotaji_prieksmeti`
1062--
1063
1064DROP TABLE IF EXISTS `skolotaji_prieksmeti`;
1065CREATE TABLE IF NOT EXISTS `skolotaji_prieksmeti` (
1066  `skolotaji` char(12) NOT NULL,
1067  `macibu_prieksmeti` int(11) NOT NULL,
1068  KEY `skolotaji` (`skolotaji`),
1069  KEY `macibu_prieksmeti` (`macibu_prieksmeti`)
1070) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1071
1072-- --------------------------------------------------------
1073
1074--
1075-- Table structure for table `vertejumi`
1076--
1077
1078DROP TABLE IF EXISTS `vertejumi`;
1079CREATE TABLE IF NOT EXISTS `vertejumi` (
1080  `vertejums` int(11) NOT NULL,
1081  `audzekni` char(12) NOT NULL,
1082  `macibu_prieksmets` int(11) NOT NULL,
1083  PRIMARY KEY (`vertejums`),
1084  KEY `audzekni` (`audzekni`),
1085  KEY `macibu_prieksmets` (`macibu_prieksmets`)
1086) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1087
1088--
1089-- Constraints for dumped tables
1090--
1091
1092--
1093-- Constraints for table `audzekni`
1094--
1095ALTER TABLE `audzekni`
1096  ADD CONSTRAINT `audzekni_ibfk_1` FOREIGN KEY (`grupa`) REFERENCES `grupa` (`ID`);
1097
1098--
1099-- Constraints for table `grupa`
1100--
1101ALTER TABLE `grupa`
1102  ADD CONSTRAINT `grupa_ibfk_1` FOREIGN KEY (`kvalifikacija`) REFERENCES `kvalifikacija` (`ID`);
1103
1104--
1105-- Constraints for table `macibu_plans`
1106--
1107ALTER TABLE `macibu_plans`
1108  ADD CONSTRAINT `macibu_plans_ibfk_1` FOREIGN KEY (`audzekni`) REFERENCES `audzekni` (`personas_kods`),
1109  ADD CONSTRAINT `macibu_plans_ibfk_2` FOREIGN KEY (`macibu_prieksmeti`) REFERENCES `macibu_prieksmeti` (`ID`);
1110
1111--
1112-- Constraints for table `skolotaji`
1113--
1114ALTER TABLE `skolotaji`
1115  ADD CONSTRAINT `skolotaji_ibfk_1` FOREIGN KEY (`komisija`) REFERENCES `komisija` (`ID`);
1116
1117--
1118-- Constraints for table `skolotaji_prieksmeti`
1119--
1120ALTER TABLE `skolotaji_prieksmeti`
1121  ADD CONSTRAINT `skolotaji_prieksmeti_ibfk_1` FOREIGN KEY (`skolotaji`) REFERENCES `skolotaji` (`talrunis`),
1122  ADD CONSTRAINT `skolotaji_prieksmeti_ibfk_2` FOREIGN KEY (`macibu_prieksmeti`) REFERENCES `macibu_prieksmeti` (`ID`);
1123
1124--
1125-- Constraints for table `vertejumi`
1126--
1127ALTER TABLE `vertejumi`
1128  ADD CONSTRAINT `vertejumi_ibfk_1` FOREIGN KEY (`audzekni`) REFERENCES `audzekni` (`personas_kods`),
1129  ADD CONSTRAINT `vertejumi_ibfk_2` FOREIGN KEY (`macibu_prieksmets`) REFERENCES `macibu_prieksmeti` (`ID`);
1130--
1131-- Database: `striptizklubs`
1132--
1133CREATE DATABASE IF NOT EXISTS `striptizklubs` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1134USE `striptizklubs`;
1135
1136-- --------------------------------------------------------
1137
1138--
1139-- Table structure for table `galdini`
1140--
1141
1142DROP TABLE IF EXISTS `galdini`;
1143CREATE TABLE IF NOT EXISTS `galdini` (
1144  `numurs` int(11) NOT NULL AUTO_INCREMENT,
1145  `skaits` int(11) DEFAULT NULL,
1146  `smeket` enum('Y','N') DEFAULT NULL,
1147  PRIMARY KEY (`numurs`)
1148) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1149
1150-- --------------------------------------------------------
1151
1152--
1153-- Table structure for table `klienti`
1154--
1155
1156DROP TABLE IF EXISTS `klienti`;
1157CREATE TABLE IF NOT EXISTS `klienti` (
1158  `talrunis` char(15) NOT NULL,
1159  `epasts` char(50) DEFAULT NULL,
1160  `vards` char(30) DEFAULT NULL,
1161  `uzvards` char(50) DEFAULT NULL,
1162  PRIMARY KEY (`talrunis`)
1163) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1164
1165-- --------------------------------------------------------
1166
1167--
1168-- Table structure for table `pasutijumi`
1169--
1170
1171DROP TABLE IF EXISTS `pasutijumi`;
1172CREATE TABLE IF NOT EXISTS `pasutijumi` (
1173  `datums` date DEFAULT NULL,
1174  `summa` float DEFAULT NULL,
1175  `pvn` float DEFAULT NULL,
1176  `id` int(11) NOT NULL AUTO_INCREMENT,
1177  `klients` char(15) DEFAULT NULL,
1178  PRIMARY KEY (`id`),
1179  KEY `klients` (`klients`)
1180) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1181
1182-- --------------------------------------------------------
1183
1184--
1185-- Table structure for table `rezerve`
1186--
1187
1188DROP TABLE IF EXISTS `rezerve`;
1189CREATE TABLE IF NOT EXISTS `rezerve` (
1190  `laiks` time NOT NULL,
1191  `datums` date NOT NULL,
1192  `stundas` int(11) DEFAULT NULL,
1193  `klients` char(15) DEFAULT NULL,
1194  `galdins` int(11) DEFAULT NULL,
1195  PRIMARY KEY (`laiks`,`datums`),
1196  KEY `klients` (`klients`),
1197  KEY `galdins` (`galdins`)
1198) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1199
1200--
1201-- Constraints for dumped tables
1202--
1203
1204--
1205-- Constraints for table `pasutijumi`
1206--
1207ALTER TABLE `pasutijumi`
1208  ADD CONSTRAINT `pasutijumi_ibfk_1` FOREIGN KEY (`klients`) REFERENCES `klienti` (`talrunis`);
1209
1210--
1211-- Constraints for table `rezerve`
1212--
1213ALTER TABLE `rezerve`
1214  ADD CONSTRAINT `rezerve_ibfk_1` FOREIGN KEY (`klients`) REFERENCES `klienti` (`talrunis`),
1215  ADD CONSTRAINT `rezerve_ibfk_2` FOREIGN KEY (`galdins`) REFERENCES `galdini` (`numurs`);
1216--
1217-- Database: `stunda`
1218--
1219CREATE DATABASE IF NOT EXISTS `stunda` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1220USE `stunda`;
1221
1222-- --------------------------------------------------------
1223
1224--
1225-- Table structure for table `tabula`
1226--
1227
1228DROP TABLE IF EXISTS `tabula`;
1229CREATE TABLE IF NOT EXISTS `tabula` (
1230  `lauks1` char(20) DEFAULT NULL,
1231  `lauks2` int(11) NOT NULL AUTO_INCREMENT,
1232  `lauks3` enum('1','2') DEFAULT NULL,
1233  `lauks4` blob,
1234  PRIMARY KEY (`lauks2`)
1235) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1236--
1237-- Database: `test`
1238--
1239CREATE DATABASE IF NOT EXISTS `test` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1240USE `test`;
1241--
1242-- Database: `turisms`
1243--
1244CREATE DATABASE IF NOT EXISTS `turisms` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1245USE `turisms`;
1246
1247-- --------------------------------------------------------
1248
1249--
1250-- Table structure for table `celojumi`
1251--
1252
1253DROP TABLE IF EXISTS `celojumi`;
1254CREATE TABLE IF NOT EXISTS `celojumi` (
1255  `edinasanas_tips` char(50) NOT NULL,
1256  `cena` float NOT NULL,
1257  `valsts` char(50) NOT NULL,
1258  `pilseta` char(50) NOT NULL
1259) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1260
1261-- --------------------------------------------------------
1262
1263--
1264-- Table structure for table `dalibnieki`
1265--
1266
1267DROP TABLE IF EXISTS `dalibnieki`;
1268CREATE TABLE IF NOT EXISTS `dalibnieki` (
1269  `personas_kods` char(12) NOT NULL,
1270  `termins` date NOT NULL,
1271  PRIMARY KEY (`personas_kods`)
1272) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1273
1274-- --------------------------------------------------------
1275
1276--
1277-- Table structure for table `klienti`
1278--
1279
1280DROP TABLE IF EXISTS `klienti`;
1281CREATE TABLE IF NOT EXISTS `klienti` (
1282  `personas_kods` char(12) NOT NULL,
1283  `vards` char(50) NOT NULL,
1284  `uzvards` char(50) NOT NULL,
1285  `dekl_adrese` char(50) NOT NULL,
1286  PRIMARY KEY (`personas_kods`)
1287) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1288
1289-- --------------------------------------------------------
1290
1291--
1292-- Table structure for table `pasutijumi`
1293--
1294
1295DROP TABLE IF EXISTS `pasutijumi`;
1296CREATE TABLE IF NOT EXISTS `pasutijumi` (
1297  `Summa` float NOT NULL,
1298  `pasutijuma_id` int(11) NOT NULL,
1299  `datums` date NOT NULL
1300) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1301
1302-- --------------------------------------------------------
1303
1304--
1305-- Table structure for table `viesnica`
1306--
1307
1308DROP TABLE IF EXISTS `viesnica`;
1309CREATE TABLE IF NOT EXISTS `viesnica` (
1310  `nosaukums` char(50) NOT NULL,
1311  `reitings` float NOT NULL,
1312  `attels` blob NOT NULL
1313) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1314--
1315-- Database: `veikalu_tikla`
1316--
1317CREATE DATABASE IF NOT EXISTS `veikalu_tikla` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
1318USE `veikalu_tikla`;
1319
1320-- --------------------------------------------------------
1321
1322--
1323-- Table structure for table `kasieris`
1324--
1325
1326DROP TABLE IF EXISTS `kasieris`;
1327CREATE TABLE IF NOT EXISTS `kasieris` (
1328  `nr` int(11) NOT NULL AUTO_INCREMENT,
1329  `vards` char(20) DEFAULT NULL,
1330  `uzvards` char(20) DEFAULT NULL,
1331  PRIMARY KEY (`nr`),
1332  KEY `vards` (`vards`),
1333  KEY `uzvards` (`uzvards`)
1334) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
1335
1336--
1337-- Dumping data for table `kasieris`
1338--
1339
1340INSERT INTO `kasieris` (`nr`, `vards`, `uzvards`) VALUES
1341(1, 'John', 'Koppisch'),
1342(2, 'Nathan', 'Vardi'),
1343(3, 'Grace', 'Chung'),
1344(4, 'Merrilee', 'Barton'),
1345(5, 'Gail', 'Toivanen');
1346
1347-- --------------------------------------------------------
1348
1349--
1350-- Table structure for table `noliktava`
1351--
1352
1353DROP TABLE IF EXISTS `noliktava`;
1354CREATE TABLE IF NOT EXISTS `noliktava` (
1355  `prece` int(11) NOT NULL,
1356  `atlikums` int(11) DEFAULT NULL,
1357  `cena` int(11) DEFAULT NULL,
1358  `veikals` int(11) NOT NULL,
1359  PRIMARY KEY (`prece`,`veikals`),
1360  KEY `veikals` (`veikals`),
1361  KEY `cena` (`cena`),
1362  KEY `cena_2` (`cena`)
1363) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1364
1365--
1366-- Dumping data for table `noliktava`
1367--
1368
1369INSERT INTO `noliktava` (`prece`, `atlikums`, `cena`, `veikals`) VALUES
1370(1, 200, 2, 1),
1371(5, 150, 8, 2),
1372(9, 500, 1, 1),
1373(3, 300, 2, 3),
1374(8, 300, 1, 3),
1375(2, 200, 4, 2),
1376(4, 300, 2, 1),
1377(6, 400, 3, 1),
1378(6, 400, 3, 2),
1379(2, 350, 4, 1),
1380(5, 150, 8, 3);
1381
1382-- --------------------------------------------------------
1383
1384--
1385-- Table structure for table `pardevumi`
1386--
1387
1388DROP TABLE IF EXISTS `pardevumi`;
1389CREATE TABLE IF NOT EXISTS `pardevumi` (
1390  `ID` int(11) NOT NULL AUTO_INCREMENT,
1391  `kasieris` int(11) DEFAULT NULL,
1392  `pircejs` int(11) DEFAULT NULL,
1393  `datums` date DEFAULT NULL,
1394  `veikals` int(11) DEFAULT NULL,
1395  PRIMARY KEY (`ID`),
1396  KEY `kasieris` (`kasieris`),
1397  KEY `pircejs` (`pircejs`),
1398  KEY `veikals` (`veikals`),
1399  KEY `datums` (`datums`),
1400  KEY `datums_2` (`datums`)
1401) ENGINE=MyISAM AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
1402
1403--
1404-- Dumping data for table `pardevumi`
1405--
1406
1407INSERT INTO `pardevumi` (`ID`, `kasieris`, `pircejs`, `datums`, `veikals`) VALUES
1408(1, 4, 8, '2019-01-04', 1),
1409(2, 1, 9, '2019-02-08', 2),
1410(3, 2, 3, '2019-03-11', 1),
1411(4, 5, 7, '2019-07-01', 3),
1412(5, 3, 4, '2019-06-12', 3),
1413(6, 1, 8, '2019-05-22', 2),
1414(7, 1, 1, '2019-07-26', 1),
1415(8, 4, 5, '2019-02-08', 2),
1416(9, 4, 3, '2019-08-18', 2),
1417(10, 5, 8, '2019-02-14', 1),
1418(11, 3, 9, '2019-04-11', 3),
1419(12, 1, 4, '2019-08-05', 3),
1420(13, 2, 5, '2019-03-19', 3),
1421(14, 3, 6, '2019-09-05', 2),
1422(15, 4, 2, '2019-01-09', 1),
1423(16, 4, 8, '2019-01-04', 1),
1424(17, 1, 9, '2019-02-08', 2),
1425(18, 2, 3, '2019-03-11', 1),
1426(19, 5, 7, '2019-07-01', 3),
1427(20, 3, 4, '2019-06-12', 3),
1428(21, 1, 8, '2019-05-22', 2),
1429(22, 1, 1, '2019-07-26', 1),
1430(23, 4, 5, '2019-02-08', 2),
1431(24, 4, 3, '2019-08-18', 2),
1432(25, 5, 8, '2019-02-14', 1),
1433(26, 3, 9, '2019-04-11', 3),
1434(27, 1, 4, '2019-08-05', 3),
1435(28, 2, 5, '2019-03-19', 3),
1436(29, 3, 6, '2019-09-05', 2),
1437(30, 4, 2, '2019-01-09', 1),
1438(31, 2, 5, '2019-03-19', 3),
1439(32, 3, 6, '2019-09-05', 2),
1440(33, 4, 2, '2019-01-09', 1),
1441(34, 4, 8, '2019-01-04', 1),
1442(35, 1, 9, '2019-02-08', 2),
1443(36, 2, 3, '2019-03-11', 1),
1444(37, 5, 7, '2019-07-01', 3),
1445(38, 3, 4, '2019-06-12', 3),
1446(39, 1, 8, '2019-05-22', 2),
1447(40, 1, 1, '2019-07-26', 1),
1448(41, 4, 8, '2019-01-04', 1),
1449(42, 1, 9, '2019-02-08', 2),
1450(43, 2, 3, '2019-03-11', 1),
1451(44, 5, 7, '2019-07-01', 3),
1452(45, 3, 4, '2019-06-12', 3),
1453(46, 4, 8, '2019-01-04', 1),
1454(47, 1, 9, '2019-02-08', 2),
1455(48, 2, 3, '2019-03-11', 1),
1456(49, 5, 7, '2019-07-01', 3),
1457(50, 3, 4, '2019-06-12', 3),
1458(51, 1, 9, '2019-02-08', 2),
1459(52, 2, 3, '2019-03-11', 1),
1460(53, 5, 7, '2019-07-01', 3),
1461(54, 3, 4, '2019-06-12', 3),
1462(55, 1, 8, '2019-05-22', 2),
1463(56, 1, 1, '2019-07-26', 1),
1464(57, 4, 5, '2019-02-08', 2),
1465(58, 4, 3, '2019-08-18', 2),
1466(59, 5, 8, '2019-02-14', 1),
1467(60, 3, 9, '2019-04-11', 3),
1468(61, 1, 4, '2019-08-05', 3),
1469(62, 2, 5, '2019-03-19', 3),
1470(63, 3, 6, '2019-09-05', 2),
1471(64, 4, 2, '2019-01-09', 1),
1472(65, 2, 5, '2019-03-19', 3),
1473(66, 3, 6, '2019-09-05', 2),
1474(67, 4, 2, '2019-01-09', 1),
1475(68, 4, 8, '2019-01-04', 1),
1476(69, 1, 9, '2019-02-08', 2),
1477(70, 2, 3, '2019-03-11', 1),
1478(71, 5, 7, '2019-07-01', 3),
1479(72, 3, 4, '2019-06-12', 3),
1480(73, 1, 8, '2019-05-22', 2),
1481(74, 1, 1, '2019-07-26', 1),
1482(75, 4, 8, '2019-01-04', 1),
1483(76, 1, 9, '2019-02-08', 2),
1484(77, 2, 3, '2019-03-11', 1),
1485(78, 5, 7, '2019-07-01', 3),
1486(79, 3, 4, '2019-06-12', 3),
1487(80, 4, 8, '2019-01-04', 1),
1488(81, 1, 9, '2019-02-08', 2),
1489(82, 2, 3, '2019-03-11', 1),
1490(83, 5, 7, '2019-07-01', 3),
1491(84, 3, 4, '2019-06-12', 3),
1492(85, 1, 9, '2019-02-08', 2),
1493(86, 2, 3, '2019-03-11', 1),
1494(87, 5, 7, '2019-07-01', 3),
1495(88, 3, 4, '2019-06-12', 3),
1496(89, 1, 8, '2019-05-22', 2),
1497(90, 1, 1, '2019-07-26', 1),
1498(91, 4, 5, '2019-02-08', 2),
1499(92, 3, 4, '2019-06-12', 3),
1500(93, 1, 9, '2019-02-08', 2),
1501(94, 2, 3, '2019-03-11', 1),
1502(95, 5, 7, '2019-07-01', 3),
1503(96, 3, 4, '2019-06-12', 3),
1504(97, 1, 8, '2019-05-22', 2),
1505(98, 1, 1, '2019-07-26', 1),
1506(99, 4, 5, '2019-02-08', 2),
1507(100, 4, 3, '2019-08-18', 2),
1508(101, 5, 8, '2019-02-14', 1),
1509(102, 3, 9, '2019-04-11', 3),
1510(103, 1, 4, '2019-08-05', 3),
1511(104, 2, 5, '2019-03-19', 3),
1512(105, 3, 6, '2019-09-05', 2),
1513(106, 4, 2, '2019-01-09', 1),
1514(107, 2, 5, '2019-03-19', 3),
1515(108, 3, 6, '2019-09-05', 2),
1516(109, 4, 2, '2019-01-09', 1),
1517(110, 4, 8, '2019-01-04', 1),
1518(111, 1, 9, '2019-02-08', 2),
1519(112, 2, 3, '2019-03-11', 1),
1520(113, 5, 7, '2019-07-01', 3),
1521(114, 3, 4, '2019-06-12', 3),
1522(115, 1, 8, '2019-05-22', 2),
1523(116, 1, 1, '2019-07-26', 1),
1524(117, 5, 7, '2019-07-01', 3),
1525(118, 3, 4, '2019-06-12', 3),
1526(119, 4, 8, '2019-01-04', 1),
1527(120, 1, 9, '2019-02-08', 2),
1528(121, 2, 3, '2019-03-11', 1),
1529(122, 5, 7, '2019-07-01', 3),
1530(123, 3, 4, '2019-06-12', 3),
1531(124, 1, 9, '2019-02-08', 2),
1532(125, 2, 3, '2019-03-11', 1),
1533(126, 5, 7, '2019-07-01', 3),
1534(127, 3, 4, '2019-06-12', 3),
1535(128, 1, 8, '2019-05-22', 2),
1536(129, 1, 1, '2019-07-26', 1),
1537(130, 4, 5, '2019-02-08', 2),
1538(131, 3, 4, '2019-06-12', 3),
1539(132, 1, 9, '2019-02-08', 2),
1540(133, 2, 3, '2019-03-11', 1),
1541(134, 5, 7, '2019-07-01', 3),
1542(135, 3, 4, '2019-06-12', 3),
1543(136, 1, 8, '2019-05-22', 2),
1544(137, 1, 1, '2019-07-26', 1),
1545(138, 4, 5, '2019-02-08', 2),
1546(139, 4, 3, '2019-08-18', 2),
1547(140, 5, 8, '2019-02-14', 1),
1548(141, 3, 9, '2019-04-11', 3),
1549(142, 1, 4, '2019-08-05', 3),
1550(143, 2, 5, '2019-03-19', 3),
1551(144, 3, 6, '2019-09-05', 2),
1552(145, 4, 2, '2019-01-09', 1),
1553(146, 2, 5, '2019-03-19', 3),
1554(147, 3, 6, '2019-09-05', 2),
1555(148, 4, 2, '2019-01-09', 1),
1556(149, 4, 8, '2019-01-04', 1),
1557(150, 1, 9, '2019-02-08', 2),
1558(151, 1, 9, '2019-02-08', 2),
1559(152, 2, 3, '2019-03-11', 1),
1560(153, 5, 7, '2019-07-01', 3),
1561(154, 3, 4, '2019-06-12', 3),
1562(155, 1, 8, '2019-05-22', 2),
1563(156, 1, 1, '2019-07-26', 1),
1564(157, 4, 5, '2019-02-08', 2),
1565(158, 4, 3, '2019-08-18', 2),
1566(159, 5, 8, '2019-02-14', 1),
1567(160, 3, 9, '2019-04-11', 3),
1568(161, 1, 4, '2019-08-05', 3),
1569(162, 2, 5, '2019-03-19', 3),
1570(163, 3, 6, '2019-09-05', 2),
1571(164, 4, 2, '2019-01-09', 1),
1572(165, 2, 5, '2019-03-19', 3),
1573(166, 3, 6, '2019-09-05', 2),
1574(167, 4, 2, '2019-01-09', 1),
1575(168, 3, 4, '2019-06-12', 3),
1576(169, 1, 8, '2019-05-22', 2),
1577(170, 1, 1, '2019-07-26', 1),
1578(171, 4, 5, '2019-02-08', 2),
1579(172, 3, 4, '2019-06-12', 3),
1580(173, 1, 9, '2019-02-08', 2),
1581(174, 2, 3, '2019-03-11', 1),
1582(175, 5, 7, '2019-07-01', 3),
1583(176, 3, 4, '2019-06-12', 3),
1584(177, 1, 8, '2019-05-22', 2),
1585(178, 1, 1, '2019-07-26', 1),
1586(179, 4, 5, '2019-02-08', 2),
1587(180, 4, 3, '2019-08-18', 2),
1588(181, 5, 8, '2019-02-14', 1),
1589(182, 3, 9, '2019-04-11', 3),
1590(183, 1, 4, '2019-08-05', 3),
1591(184, 2, 5, '2019-03-19', 3),
1592(185, 3, 6, '2019-09-05', 2),
1593(186, 4, 2, '2019-01-09', 1),
1594(187, 2, 5, '2019-03-19', 3),
1595(188, 3, 6, '2019-09-05', 2),
1596(189, 4, 2, '2019-01-09', 1),
1597(190, 4, 8, '2019-01-04', 1),
1598(191, 1, 9, '2019-02-08', 2),
1599(192, 1, 9, '2019-02-08', 2),
1600(193, 2, 3, '2019-03-11', 1),
1601(194, 5, 7, '2019-07-01', 3),
1602(195, 4, 2, '2019-01-09', 1),
1603(196, 4, 8, '2019-01-04', 1),
1604(197, 1, 9, '2019-02-08', 2),
1605(198, 2, 3, '2019-03-11', 1),
1606(199, 5, 7, '2019-07-01', 3),
1607(200, 3, 4, '2019-06-12', 3);
1608
1609-- --------------------------------------------------------
1610
1611--
1612-- Table structure for table `piegadataji`
1613--
1614
1615DROP TABLE IF EXISTS `piegadataji`;
1616CREATE TABLE IF NOT EXISTS `piegadataji` (
1617  `ID` int(11) NOT NULL AUTO_INCREMENT,
1618  `nosaukums` char(20) DEFAULT NULL,
1619  `atr_vieta` char(20) DEFAULT NULL,
1620  PRIMARY KEY (`ID`)
1621) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
1622
1623--
1624-- Dumping data for table `piegadataji`
1625--
1626
1627INSERT INTO `piegadataji` (`ID`, `nosaukums`, `atr_vieta`) VALUES
1628(1, 'KRIMELTE', 'Riga'),
1629(2, '4WORK', 'Ventspils'),
1630(3, 'JUMA', 'Salaspils'),
1631(4, 'ALUOJA', 'Ogre'),
1632(5, 'FOBOSS', 'Kegums');
1633
1634-- --------------------------------------------------------
1635
1636--
1637-- Table structure for table `piegade`
1638--
1639
1640DROP TABLE IF EXISTS `piegade`;
1641CREATE TABLE IF NOT EXISTS `piegade` (
1642  `piegadesID` int(11) NOT NULL AUTO_INCREMENT,
1643  `datums` date DEFAULT NULL,
1644  `veikals` int(11) DEFAULT NULL,
1645  `piegadatajs` int(11) DEFAULT NULL,
1646  PRIMARY KEY (`piegadesID`),
1647  KEY `veikals` (`veikals`),
1648  KEY `piegadatajs` (`piegadatajs`),
1649  KEY `datums` (`datums`),
1650  KEY `datums_2` (`datums`)
1651) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
1652
1653--
1654-- Dumping data for table `piegade`
1655--
1656
1657INSERT INTO `piegade` (`piegadesID`, `datums`, `veikals`, `piegadatajs`) VALUES
1658(1, '2019-08-19', 1, 5),
1659(2, '2019-04-18', 2, 3),
1660(3, '2019-03-15', 1, 2),
1661(4, '2019-05-12', 3, 4),
1662(5, '2019-05-16', 3, 1),
1663(6, '2019-01-11', 3, 3),
1664(7, '2019-07-06', 2, 4),
1665(8, '2019-03-03', 1, 5),
1666(9, '2019-01-01', 2, 3),
1667(10, '2019-09-13', 3, 2),
1668(11, '2019-04-22', 2, 1),
1669(12, '2019-01-26', 1, 2),
1670(13, '2019-04-15', 2, 3),
1671(14, '2019-09-01', 1, 4),
1672(15, '2019-09-07', 2, 1),
1673(16, '2019-01-11', 1, 2),
1674(17, '2019-05-17', 2, 1),
1675(18, '2019-07-12', 2, 4),
1676(19, '2019-07-10', 2, 5),
1677(20, '2019-03-01', 3, 5),
1678(21, '2019-02-02', 2, 2),
1679(22, '2019-02-18', 3, 3),
1680(23, '2019-09-21', 1, 2),
1681(24, '2019-05-19', 2, 1),
1682(25, '2019-01-10', 1, 2),
1683(26, '2019-07-17', 3, 3),
1684(27, '2019-09-01', 2, 2),
1685(28, '2019-09-07', 1, 1),
1686(29, '2019-04-15', 2, 2),
1687(30, '2019-09-01', 3, 2),
1688(31, '2019-04-18', 2, 2),
1689(32, '2019-03-15', 1, 3),
1690(33, '2019-05-12', 2, 3),
1691(34, '2019-05-16', 2, 3),
1692(35, '2019-09-01', 1, 4),
1693(36, '2019-09-07', 3, 4),
1694(37, '2019-04-18', 3, 4),
1695(38, '2019-03-15', 1, 5),
1696(39, '2019-05-12', 2, 1),
1697(40, '2019-05-17', 1, 2),
1698(41, '2019-07-12', 2, 1),
1699(42, '2019-07-10', 3, 3),
1700(43, '2019-03-01', 1, 4),
1701(44, '2019-02-02', 2, 1),
1702(45, '2019-09-07', 1, 5),
1703(46, '2019-01-11', 1, 2),
1704(47, '2019-05-17', 2, 1),
1705(48, '2019-07-12', 3, 2),
1706(49, '2019-02-18', 2, 2),
1707(50, '2019-09-21', 1, 2),
1708(51, '2019-05-19', 2, 2),
1709(52, '2019-09-07', 3, 2),
1710(53, '2019-04-15', 2, 3),
1711(54, '2019-09-01', 1, 1),
1712(55, '2019-04-18', 2, 5),
1713(56, '2019-03-15', 1, 5),
1714(57, '2019-05-12', 1, 5),
1715(58, '2019-05-16', 1, 4),
1716(59, '2019-09-01', 1, 4),
1717(60, '2019-09-07', 2, 4),
1718(61, '2019-04-18', 2, 3),
1719(62, '2019-07-06', 3, 3),
1720(63, '2019-03-03', 3, 2),
1721(64, '2019-01-01', 3, 3),
1722(65, '2019-09-13', 1, 5),
1723(66, '2019-04-22', 2, 1),
1724(67, '2019-01-26', 1, 2),
1725(68, '2019-04-15', 2, 3),
1726(69, '2019-09-01', 2, 2),
1727(70, '2019-01-11', 2, 1),
1728(71, '2019-07-06', 2, 2),
1729(72, '2019-03-03', 3, 4),
1730(73, '2019-01-01', 3, 3),
1731(74, '2019-09-13', 3, 5),
1732(75, '2019-04-22', 1, 2),
1733(76, '2019-01-26', 2, 2),
1734(77, '2019-09-13', 1, 1),
1735(78, '2019-04-22', 1, 1),
1736(79, '2019-01-26', 2, 1),
1737(80, '2019-04-15', 1, 2),
1738(81, '2019-08-19', 1, 5),
1739(82, '2019-04-18', 2, 3),
1740(83, '2019-03-15', 1, 2),
1741(84, '2019-05-12', 3, 4),
1742(85, '2019-05-16', 3, 1),
1743(86, '2019-01-11', 3, 3),
1744(87, '2019-07-06', 2, 4),
1745(88, '2019-03-03', 1, 5),
1746(89, '2019-01-01', 2, 3),
1747(90, '2019-09-13', 3, 2),
1748(91, '2019-04-22', 2, 1),
1749(92, '2019-01-26', 1, 2),
1750(93, '2019-04-15', 2, 3),
1751(94, '2019-09-01', 1, 4),
1752(95, '2019-09-07', 2, 1),
1753(96, '2019-01-11', 1, 2),
1754(97, '2019-05-17', 2, 1),
1755(98, '2019-07-12', 2, 4),
1756(99, '2019-07-10', 2, 5),
1757(100, '2019-03-01', 3, 5);
1758
1759-- --------------------------------------------------------
1760
1761--
1762-- Table structure for table `pircejs`
1763--
1764
1765DROP TABLE IF EXISTS `pircejs`;
1766CREATE TABLE IF NOT EXISTS `pircejs` (
1767  `atl_kartes_kods` int(11) NOT NULL AUTO_INCREMENT,
1768  `vards` char(20) DEFAULT NULL,
1769  `uzvards` char(20) DEFAULT NULL,
1770  `atl_kartes_numurs` int(11) DEFAULT NULL,
1771  PRIMARY KEY (`atl_kartes_kods`)
1772) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
1773
1774--
1775-- Dumping data for table `pircejs`
1776--
1777
1778INSERT INTO `pircejs` (`atl_kartes_kods`, `vards`, `uzvards`, `atl_kartes_numurs`) VALUES
1779(1, 'Chloe', 'Trump', 1),
1780(2, 'Deborah', 'Wells', 2),
1781(3, 'Kristin', 'Lindsay', 3),
1782(4, 'Jeff', 'Sharf', 4),
1783(5, ' Laureen', 'Nam', 5),
1784(6, ' Suzanne', 'Tan', 6),
1785(7, ' James', 'Schmidt', 7),
1786(8, ' Kylie', 'Raghunathan', 8),
1787(9, ' Donald', 'Toppin', 9),
1788(10, ' David', 'Steward', 10);
1789
1790-- --------------------------------------------------------
1791
1792--
1793-- Table structure for table `pirkums`
1794--
1795
1796DROP TABLE IF EXISTS `pirkums`;
1797CREATE TABLE IF NOT EXISTS `pirkums` (
1798  `kods` int(11) NOT NULL AUTO_INCREMENT,
1799  `precu_daudzums` int(11) DEFAULT NULL,
1800  `preces_kods` int(11) DEFAULT NULL,
1801  `veikals` int(11) DEFAULT NULL,
1802  `cena` int(11) DEFAULT NULL,
1803  `pardevums` int(11) DEFAULT NULL,
1804  PRIMARY KEY (`kods`),
1805  KEY `preces_kods` (`preces_kods`),
1806  KEY `veikals` (`veikals`),
1807  KEY `pardevums` (`pardevums`)
1808) ENGINE=MyISAM AUTO_INCREMENT=201 DEFAULT CHARSET=latin1;
1809
1810--
1811-- Dumping data for table `pirkums`
1812--
1813
1814INSERT INTO `pirkums` (`kods`, `precu_daudzums`, `preces_kods`, `veikals`, `cena`, `pardevums`) VALUES
1815(1, 5, 1, 1, 3, 99),
1816(2, 3, 2, 2, 4, 87),
1817(3, 15, 3, 3, 5, 18),
1818(4, 16, 4, 2, 2, 37),
1819(5, 20, 6, 3, 6, 165),
1820(6, 7, 5, 1, 2, 182),
1821(7, 1, 9, 2, 7, 3),
1822(8, 8, 2, 2, 2, 195),
1823(9, 60, 9, 3, 1, 6),
1824(10, 13, 3, 1, 4, 10),
1825(11, 5, 1, 1, 3, 65),
1826(12, 3, 2, 2, 4, 36),
1827(13, 15, 3, 3, 5, 88),
1828(14, 16, 4, 2, 2, 41),
1829(15, 20, 6, 3, 6, 139),
1830(16, 7, 5, 1, 2, 139),
1831(17, 1, 9, 2, 7, 33),
1832(18, 8, 2, 2, 2, 118),
1833(19, 60, 9, 3, 1, 69),
1834(20, 13, 3, 1, 4, 161),
1835(21, 20, 6, 3, 6, 165),
1836(22, 7, 5, 1, 2, 182),
1837(23, 1, 9, 2, 7, 3),
1838(24, 8, 2, 2, 2, 195),
1839(25, 60, 9, 3, 1, 6),
1840(26, 13, 3, 1, 4, 10),
1841(27, 5, 1, 1, 3, 65),
1842(28, 3, 2, 2, 4, 36),
1843(29, 15, 3, 3, 5, 88),
1844(30, 16, 4, 2, 2, 41),
1845(31, 20, 6, 3, 6, 139),
1846(32, 7, 5, 1, 2, 139),
1847(33, 1, 9, 2, 7, 3),
1848(34, 8, 2, 2, 2, 195),
1849(35, 60, 9, 3, 1, 6),
1850(36, 13, 3, 1, 4, 10),
1851(37, 5, 1, 1, 3, 65),
1852(38, 3, 2, 2, 4, 36),
1853(39, 15, 3, 3, 5, 88),
1854(40, 16, 4, 2, 2, 41),
1855(41, 20, 6, 3, 6, 139),
1856(42, 7, 5, 1, 2, 139),
1857(43, 1, 9, 2, 7, 33),
1858(44, 8, 2, 2, 2, 118),
1859(45, 60, 9, 3, 1, 69),
1860(46, 13, 3, 1, 4, 161),
1861(47, 20, 6, 3, 6, 165),
1862(48, 7, 5, 1, 2, 182),
1863(49, 1, 9, 2, 7, 3),
1864(50, 8, 2, 2, 2, 195),
1865(51, 60, 9, 3, 1, 6),
1866(52, 13, 3, 1, 4, 10),
1867(53, 13, 3, 1, 4, 10),
1868(54, 5, 1, 1, 3, 65),
1869(55, 3, 2, 2, 4, 36),
1870(56, 15, 3, 3, 5, 88),
1871(57, 16, 4, 2, 2, 41),
1872(58, 20, 6, 3, 6, 139),
1873(59, 7, 5, 1, 2, 139),
1874(60, 1, 9, 2, 7, 3),
1875(61, 8, 2, 2, 2, 195),
1876(62, 60, 9, 3, 1, 6),
1877(63, 13, 3, 1, 4, 10),
1878(64, 5, 1, 1, 3, 65),
1879(65, 3, 2, 2, 4, 36),
1880(66, 15, 3, 3, 5, 88),
1881(67, 16, 4, 2, 2, 41),
1882(68, 20, 6, 3, 6, 139),
1883(69, 7, 5, 1, 2, 139),
1884(70, 1, 9, 2, 7, 33),
1885(71, 8, 2, 2, 2, 118),
1886(72, 60, 9, 3, 1, 69),
1887(73, 13, 3, 1, 4, 161),
1888(74, 20, 6, 3, 6, 165),
1889(75, 7, 5, 1, 2, 182),
1890(76, 1, 9, 2, 7, 3),
1891(77, 8, 2, 2, 2, 195),
1892(78, 60, 9, 3, 1, 6),
1893(79, 13, 3, 1, 4, 10),
1894(80, 13, 3, 1, 4, 10),
1895(81, 5, 1, 1, 3, 65),
1896(82, 3, 2, 2, 4, 36),
1897(83, 15, 3, 3, 5, 88),
1898(84, 16, 4, 2, 2, 41),
1899(85, 20, 6, 3, 6, 139),
1900(86, 7, 5, 1, 2, 139),
1901(87, 1, 9, 2, 7, 3),
1902(88, 8, 2, 2, 2, 195),
1903(89, 60, 9, 3, 1, 6),
1904(90, 13, 3, 1, 4, 10),
1905(91, 5, 1, 1, 3, 65),
1906(92, 5, 1, 1, 3, 65),
1907(93, 3, 2, 2, 4, 36),
1908(94, 15, 3, 3, 5, 88),
1909(95, 16, 4, 2, 2, 41),
1910(96, 20, 6, 3, 6, 139),
1911(97, 7, 5, 1, 2, 139),
1912(98, 1, 9, 2, 7, 33),
1913(99, 8, 2, 2, 2, 118),
1914(100, 60, 9, 3, 1, 69),
1915(101, 13, 3, 1, 4, 161),
1916(102, 20, 6, 3, 6, 165),
1917(103, 7, 5, 1, 2, 182),
1918(104, 1, 9, 2, 7, 3),
1919(105, 8, 2, 2, 2, 195),
1920(106, 60, 9, 3, 1, 6),
1921(107, 13, 3, 1, 4, 10),
1922(108, 13, 3, 1, 4, 10),
1923(109, 5, 1, 1, 3, 65),
1924(110, 3, 2, 2, 4, 36),
1925(111, 7, 5, 1, 2, 139),
1926(112, 1, 9, 2, 7, 3),
1927(113, 8, 2, 2, 2, 195),
1928(114, 60, 9, 3, 1, 6),
1929(115, 13, 3, 1, 4, 10),
1930(116, 5, 1, 1, 3, 65),
1931(117, 5, 1, 1, 3, 65),
1932(118, 3, 2, 2, 4, 36),
1933(119, 15, 3, 3, 5, 88),
1934(120, 16, 4, 2, 2, 41),
1935(121, 20, 6, 3, 6, 139),
1936(122, 7, 5, 1, 2, 139),
1937(123, 1, 9, 2, 7, 33),
1938(124, 8, 2, 2, 2, 118),
1939(125, 60, 9, 3, 1, 69),
1940(126, 13, 3, 1, 4, 161),
1941(127, 20, 6, 3, 6, 165),
1942(128, 7, 5, 1, 2, 182),
1943(129, 1, 9, 2, 7, 3),
1944(130, 8, 2, 2, 2, 195),
1945(131, 15, 3, 3, 5, 18),
1946(132, 16, 4, 2, 2, 37),
1947(133, 20, 6, 3, 6, 165),
1948(134, 7, 5, 1, 2, 182),
1949(135, 1, 9, 2, 7, 3),
1950(136, 8, 2, 2, 2, 195),
1951(137, 60, 9, 3, 1, 6),
1952(138, 13, 3, 1, 4, 10),
1953(139, 5, 1, 1, 3, 65),
1954(140, 3, 2, 2, 4, 36),
1955(141, 15, 3, 3, 5, 88),
1956(142, 16, 4, 2, 2, 41),
1957(143, 20, 6, 3, 6, 139),
1958(144, 7, 5, 1, 2, 139),
1959(145, 1, 9, 2, 7, 33),
1960(146, 8, 2, 2, 2, 118),
1961(147, 60, 9, 3, 1, 69),
1962(148, 13, 3, 1, 4, 161),
1963(149, 20, 6, 3, 6, 165),
1964(150, 7, 5, 1, 2, 182),
1965(151, 8, 2, 2, 2, 118),
1966(152, 60, 9, 3, 1, 69),
1967(153, 13, 3, 1, 4, 161),
1968(154, 20, 6, 3, 6, 165),
1969(155, 7, 5, 1, 2, 182),
1970(156, 1, 9, 2, 7, 3),
1971(157, 8, 2, 2, 2, 195),
1972(158, 15, 3, 3, 5, 18),
1973(159, 16, 4, 2, 2, 37),
1974(160, 20, 6, 3, 6, 165),
1975(161, 7, 5, 1, 2, 182),
1976(162, 1, 9, 2, 7, 3),
1977(163, 8, 2, 2, 2, 195),
1978(164, 60, 9, 3, 1, 6),
1979(165, 13, 3, 1, 4, 10),
1980(166, 5, 1, 1, 3, 65),
1981(167, 3, 2, 2, 4, 36),
1982(168, 15, 3, 3, 5, 88),
1983(169, 16, 4, 2, 2, 41),
1984(170, 20, 6, 3, 6, 139),
1985(171, 7, 5, 1, 2, 139),
1986(172, 1, 9, 2, 7, 33),
1987(173, 8, 2, 2, 2, 118),
1988(174, 13, 3, 1, 4, 161),
1989(175, 20, 6, 3, 6, 165),
1990(176, 7, 5, 1, 2, 182),
1991(177, 8, 2, 2, 2, 118),
1992(178, 60, 9, 3, 1, 69),
1993(179, 13, 3, 1, 4, 161),
1994(180, 20, 6, 3, 6, 165),
1995(181, 7, 5, 1, 2, 182),
1996(182, 1, 9, 2, 7, 3),
1997(183, 8, 2, 2, 2, 195),
1998(184, 15, 3, 3, 5, 18),
1999(185, 16, 4, 2, 2, 37),
2000(186, 20, 6, 3, 6, 165),
2001(187, 7, 5, 1, 2, 182),
2002(188, 1, 9, 2, 7, 3),
2003(189, 8, 2, 2, 2, 195),
2004(190, 60, 9, 3, 1, 6),
2005(191, 13, 3, 1, 4, 10),
2006(192, 5, 1, 1, 3, 65),
2007(193, 3, 2, 2, 4, 36),
2008(194, 15, 3, 3, 5, 88),
2009(195, 16, 4, 2, 2, 41),
2010(196, 16, 4, 2, 2, 41),
2011(197, 20, 6, 3, 6, 139),
2012(198, 7, 5, 1, 2, 139),
2013(199, 1, 9, 2, 7, 33),
2014(200, 8, 2, 2, 2, 118);
2015
2016-- --------------------------------------------------------
2017
2018--
2019-- Table structure for table `preces`
2020--
2021
2022DROP TABLE IF EXISTS `preces`;
2023CREATE TABLE IF NOT EXISTS `preces` (
2024  `kods` int(11) NOT NULL AUTO_INCREMENT,
2025  `nosaukums` char(20) DEFAULT NULL,
2026  PRIMARY KEY (`kods`),
2027  KEY `nosaukums_2` (`nosaukums`)
2028) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
2029
2030--
2031-- Dumping data for table `preces`
2032--
2033
2034INSERT INTO `preces` (`kods`, `nosaukums`) VALUES
2035(1, 'Banani'),
2036(2, 'Apelsini'),
2037(3, 'Mandarini'),
2038(4, 'Aboli'),
2039(5, 'Galja'),
2040(6, 'Olas'),
2041(7, 'Maize'),
2042(8, 'Sierins'),
2043(9, 'Piens'),
2044(10, 'Biezpiens');
2045
2046-- --------------------------------------------------------
2047
2048--
2049-- Table structure for table `preces_piegadei`
2050--
2051
2052DROP TABLE IF EXISTS `preces_piegadei`;
2053CREATE TABLE IF NOT EXISTS `preces_piegadei` (
2054  `ID` int(11) NOT NULL AUTO_INCREMENT,
2055  `daudzums` int(11) DEFAULT NULL,
2056  `piegade` int(11) DEFAULT NULL,
2057  `preces_kods` int(11) DEFAULT NULL,
2058  PRIMARY KEY (`ID`),
2059  KEY `piegade` (`piegade`),
2060  KEY `preces_kods` (`preces_kods`)
2061) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
2062
2063--
2064-- Dumping data for table `preces_piegadei`
2065--
2066
2067INSERT INTO `preces_piegadei` (`ID`, `daudzums`, `piegade`, `preces_kods`) VALUES
2068(1, 10, 13, 1),
2069(2, 36, 18, 7),
2070(3, 5, 2, 4),
2071(4, 13, 50, 8),
2072(5, 10, 61, 9),
2073(6, 15, 88, 3),
2074(7, 5, 13, 2),
2075(8, 17, 29, 5),
2076(9, 20, 22, 6),
2077(10, 9, 36, 7),
2078(11, 5, 47, 3),
2079(12, 2, 75, 5),
2080(13, 18, 7, 7),
2081(14, 13, 92, 3),
2082(15, 10, 46, 8);
2083
2084-- --------------------------------------------------------
2085
2086--
2087-- Table structure for table `veikals`
2088--
2089
2090DROP TABLE IF EXISTS `veikals`;
2091CREATE TABLE IF NOT EXISTS `veikals` (
2092  `ID` int(11) NOT NULL AUTO_INCREMENT,
2093  `nosaukums` char(20) DEFAULT NULL,
2094  `vieta` char(20) DEFAULT NULL,
2095  `direktors` char(20) DEFAULT NULL,
2096  PRIMARY KEY (`ID`)
2097) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
2098
2099--
2100-- Dumping data for table `veikals`
2101--
2102
2103INSERT INTO `veikals` (`ID`, `nosaukums`, `vieta`, `direktors`) VALUES
2104(1, 'Rimi', 'Rusonu_iela_32', 'JamesBond'),
2105(2, 'Maxima', 'Prusu_iela_22', 'DzekiChan'),
2106(3, 'Mego', 'Aglonas_iela_5', 'NikolajsSinn');
2107--
2108-- Database: `vingr1`
2109--
2110CREATE DATABASE IF NOT EXISTS `vingr1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2111USE `vingr1`;
2112
2113-- --------------------------------------------------------
2114
2115--
2116-- Table structure for table `info`
2117--
2118
2119DROP TABLE IF EXISTS `info`;
2120CREATE TABLE IF NOT EXISTS `info` (
2121  `Izpilditajs` char(50) DEFAULT NULL,
2122  `Augums` char(50) DEFAULT NULL,
2123  `Zanrs` char(50) DEFAULT NULL,
2124  `Izdosanas_gads` char(4) DEFAULT NULL,
2125  `Izdevejs` char(50) DEFAULT NULL,
2126  `ID` int(11) NOT NULL AUTO_INCREMENT,
2127  `Prece` int(11) DEFAULT NULL,
2128  PRIMARY KEY (`ID`),
2129  UNIQUE KEY `Prece` (`Prece`)
2130) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2131
2132-- --------------------------------------------------------
2133
2134--
2135-- Table structure for table `kategorija`
2136--
2137
2138DROP TABLE IF EXISTS `kategorija`;
2139CREATE TABLE IF NOT EXISTS `kategorija` (
2140  `Nosaukums` char(50) DEFAULT NULL,
2141  `Apraksts` text,
2142  `Skaits` int(11) DEFAULT NULL,
2143  `ID` int(11) NOT NULL AUTO_INCREMENT,
2144  PRIMARY KEY (`ID`)
2145) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2146
2147-- --------------------------------------------------------
2148
2149--
2150-- Table structure for table `preces`
2151--
2152
2153DROP TABLE IF EXISTS `preces`;
2154CREATE TABLE IF NOT EXISTS `preces` (
2155  `Nosaukums` char(50) DEFAULT NULL,
2156  `Cena` float DEFAULT NULL,
2157  `Bilde` blob,
2158  `Skaits` int(11) DEFAULT NULL,
2159  `ID` int(11) NOT NULL AUTO_INCREMENT,
2160  `Kategorija` int(11) DEFAULT NULL,
2161  PRIMARY KEY (`ID`),
2162  KEY `Kategorija` (`Kategorija`)
2163) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2164
2165--
2166-- Constraints for dumped tables
2167--
2168
2169--
2170-- Constraints for table `info`
2171--
2172ALTER TABLE `info`
2173  ADD CONSTRAINT `info_ibfk_1` FOREIGN KEY (`Prece`) REFERENCES `preces` (`ID`);
2174
2175--
2176-- Constraints for table `preces`
2177--
2178ALTER TABLE `preces`
2179  ADD CONSTRAINT `preces_ibfk_1` FOREIGN KEY (`Kategorija`) REFERENCES `kategorija` (`ID`);
2180--
2181-- Database: `vingr1_rihards`
2182--
2183CREATE DATABASE IF NOT EXISTS `vingr1_rihards` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2184USE `vingr1_rihards`;
2185
2186-- --------------------------------------------------------
2187
2188--
2189-- Table structure for table `galdini`
2190--
2191
2192DROP TABLE IF EXISTS `galdini`;
2193CREATE TABLE IF NOT EXISTS `galdini` (
2194  `Numurs` int(11) NOT NULL AUTO_INCREMENT,
2195  `Vietu_Skaits` int(11) NOT NULL,
2196  `Smeketaju` enum('Y','N') DEFAULT NULL,
2197  PRIMARY KEY (`Numurs`)
2198) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2199
2200-- --------------------------------------------------------
2201
2202--
2203-- Table structure for table `klienti`
2204--
2205
2206DROP TABLE IF EXISTS `klienti`;
2207CREATE TABLE IF NOT EXISTS `klienti` (
2208  `Talrunis` char(12) NOT NULL,
2209  `E_pasts` char(24) DEFAULT NULL,
2210  `vards` char(12) DEFAULT NULL,
2211  `uzvards` char(20) DEFAULT NULL,
2212  PRIMARY KEY (`Talrunis`)
2213) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2214
2215-- --------------------------------------------------------
2216
2217--
2218-- Table structure for table `pasutijumi`
2219--
2220
2221DROP TABLE IF EXISTS `pasutijumi`;
2222CREATE TABLE IF NOT EXISTS `pasutijumi` (
2223  `Datums` date DEFAULT NULL,
2224  `Summa` float DEFAULT NULL,
2225  `VPN` float DEFAULT NULL,
2226  `ID` int(11) NOT NULL AUTO_INCREMENT,
2227  `klienti` char(20) DEFAULT NULL,
2228  PRIMARY KEY (`ID`),
2229  KEY `klienti` (`klienti`)
2230) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2231
2232-- --------------------------------------------------------
2233
2234--
2235-- Table structure for table `rezerve`
2236--
2237
2238DROP TABLE IF EXISTS `rezerve`;
2239CREATE TABLE IF NOT EXISTS `rezerve` (
2240  `Laiks` time NOT NULL,
2241  `Datums` date NOT NULL,
2242  `Stundas` int(11) DEFAULT NULL,
2243  `Klients` char(12) DEFAULT NULL,
2244  `galdini` int(11) NOT NULL,
2245  PRIMARY KEY (`Laiks`,`Datums`,`galdini`),
2246  KEY `Klients` (`Klients`),
2247  KEY `galdini` (`galdini`)
2248) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2249
2250--
2251-- Constraints for dumped tables
2252--
2253
2254--
2255-- Constraints for table `pasutijumi`
2256--
2257ALTER TABLE `pasutijumi`
2258  ADD CONSTRAINT `pasutijumi_ibfk_1` FOREIGN KEY (`klienti`) REFERENCES `klienti` (`Talrunis`);
2259
2260--
2261-- Constraints for table `rezerve`
2262--
2263ALTER TABLE `rezerve`
2264  ADD CONSTRAINT `rezerve_ibfk_1` FOREIGN KEY (`Klients`) REFERENCES `klienti` (`Talrunis`),
2265  ADD CONSTRAINT `rezerve_ibfk_2` FOREIGN KEY (`galdini`) REFERENCES `galdini` (`Numurs`);
2266--
2267-- Database: `vingr2`
2268--
2269CREATE DATABASE IF NOT EXISTS `vingr2` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2270USE `vingr2`;
2271
2272-- --------------------------------------------------------
2273
2274--
2275-- Table structure for table `galdini`
2276--
2277
2278DROP TABLE IF EXISTS `galdini`;
2279CREATE TABLE IF NOT EXISTS `galdini` (
2280  `Numurs` char(50) NOT NULL,
2281  `Vietu_skaits` int(20) DEFAULT NULL,
2282  `Pipe` set('Ja','Ne') DEFAULT NULL,
2283  PRIMARY KEY (`Numurs`)
2284) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2285
2286-- --------------------------------------------------------
2287
2288--
2289-- Table structure for table `klienti`
2290--
2291
2292DROP TABLE IF EXISTS `klienti`;
2293CREATE TABLE IF NOT EXISTS `klienti` (
2294  `Talrunis` char(15) NOT NULL,
2295  `Epasts` char(50) DEFAULT NULL,
2296  `Vards` char(20) DEFAULT NULL,
2297  `Uzvards` char(20) DEFAULT NULL,
2298  PRIMARY KEY (`Talrunis`)
2299) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2300
2301-- --------------------------------------------------------
2302
2303--
2304-- Table structure for table `pasutijums`
2305--
2306
2307DROP TABLE IF EXISTS `pasutijums`;
2308CREATE TABLE IF NOT EXISTS `pasutijums` (
2309  `Datums` datetime(6) DEFAULT NULL,
2310  `Summa` int(50) DEFAULT NULL,
2311  `Pvn` float DEFAULT NULL,
2312  `klienta_numurs` char(15) DEFAULT NULL,
2313  `id` int(11) NOT NULL AUTO_INCREMENT,
2314  PRIMARY KEY (`id`),
2315  KEY `klienta_numurs` (`klienta_numurs`)
2316) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2317
2318-- --------------------------------------------------------
2319
2320--
2321-- Table structure for table `rezerve`
2322--
2323
2324DROP TABLE IF EXISTS `rezerve`;
2325CREATE TABLE IF NOT EXISTS `rezerve` (
2326  `Laiks` time DEFAULT NULL,
2327  `Datums` date DEFAULT NULL,
2328  `Stundu_skaits` float DEFAULT NULL,
2329  `Galdina_nr` char(50) DEFAULT NULL,
2330  `Talrunis` char(50) DEFAULT NULL,
2331  `Rezerves_nr` int(20) NOT NULL AUTO_INCREMENT,
2332  PRIMARY KEY (`Rezerves_nr`),
2333  UNIQUE KEY `Laiks` (`Laiks`),
2334  UNIQUE KEY `Datums` (`Datums`),
2335  KEY `Galdina_nr` (`Galdina_nr`),
2336  KEY `Talrunis` (`Talrunis`)
2337) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2338
2339--
2340-- Constraints for dumped tables
2341--
2342
2343--
2344-- Constraints for table `pasutijums`
2345--
2346ALTER TABLE `pasutijums`
2347  ADD CONSTRAINT `pasutijums_ibfk_1` FOREIGN KEY (`klienta_numurs`) REFERENCES `klienti` (`Talrunis`);
2348
2349--
2350-- Constraints for table `rezerve`
2351--
2352ALTER TABLE `rezerve`
2353  ADD CONSTRAINT `rezerve_ibfk_1` FOREIGN KEY (`Galdina_nr`) REFERENCES `galdini` (`Numurs`),
2354  ADD CONSTRAINT `rezerve_ibfk_2` FOREIGN KEY (`Talrunis`) REFERENCES `klienti` (`Talrunis`);
2355--
2356-- Database: `vingr2_rihards`
2357--
2358CREATE DATABASE IF NOT EXISTS `vingr2_rihards` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2359USE `vingr2_rihards`;
2360
2361-- --------------------------------------------------------
2362
2363--
2364-- Table structure for table `prece`
2365--
2366
2367DROP TABLE IF EXISTS `prece`;
2368CREATE TABLE IF NOT EXISTS `prece` (
2369  `ID` int(11) NOT NULL AUTO_INCREMENT,
2370  `Nosaukums` char(20) DEFAULT NULL,
2371  `Cena` int(11) DEFAULT NULL,
2372  `Bilde` blob,
2373  `Precu_Skaits` int(11) DEFAULT NULL,
2374  `Kategorija` int(11) DEFAULT NULL,
2375  PRIMARY KEY (`ID`),
2376  KEY `Kategorija` (`Kategorija`)
2377) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2378
2379-- --------------------------------------------------------
2380
2381--
2382-- Table structure for table `precu_info`
2383--
2384
2385DROP TABLE IF EXISTS `precu_info`;
2386CREATE TABLE IF NOT EXISTS `precu_info` (
2387  `ID` int(11) NOT NULL AUTO_INCREMENT,
2388  `Izpilditajs` char(20) DEFAULT NULL,
2389  `Albums` char(20) DEFAULT NULL,
2390  `Zanrs` char(20) DEFAULT NULL,
2391  `Izdosanas_Gads` int(11) DEFAULT NULL,
2392  `Izdevejs` char(20) DEFAULT NULL,
2393  PRIMARY KEY (`ID`)
2394) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2395
2396-- --------------------------------------------------------
2397
2398--
2399-- Table structure for table `precu_kategorija`
2400--
2401
2402DROP TABLE IF EXISTS `precu_kategorija`;
2403CREATE TABLE IF NOT EXISTS `precu_kategorija` (
2404  `ID` int(11) NOT NULL AUTO_INCREMENT,
2405  `Nosaukums` char(20) DEFAULT NULL,
2406  `Apraksts` char(100) DEFAULT NULL,
2407  `Precu_skaits` int(11) DEFAULT NULL,
2408  PRIMARY KEY (`ID`)
2409) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2410
2411--
2412-- Constraints for dumped tables
2413--
2414
2415--
2416-- Constraints for table `prece`
2417--
2418ALTER TABLE `prece`
2419  ADD CONSTRAINT `prece_ibfk_1` FOREIGN KEY (`Kategorija`) REFERENCES `precu_kategorija` (`ID`);
2420
2421--
2422-- Constraints for table `precu_info`
2423--
2424ALTER TABLE `precu_info`
2425  ADD CONSTRAINT `precu_info_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `prece` (`ID`);
2426--
2427-- Database: `vingr3`
2428--
2429CREATE DATABASE IF NOT EXISTS `vingr3` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2430USE `vingr3`;
2431
2432-- --------------------------------------------------------
2433
2434--
2435-- Table structure for table `audzekni`
2436--
2437
2438DROP TABLE IF EXISTS `audzekni`;
2439CREATE TABLE IF NOT EXISTS `audzekni` (
2440  `Personas_Kods` char(20) NOT NULL,
2441  `Vards` char(20) DEFAULT NULL,
2442  `Uzvards` char(20) DEFAULT NULL,
2443  `bilde` blob,
2444  `talrunis` char(20) DEFAULT NULL,
2445  `grupa` int(10) DEFAULT NULL,
2446  `dzimsanas_diena` date DEFAULT NULL,
2447  PRIMARY KEY (`Personas_Kods`),
2448  KEY `grupa` (`grupa`)
2449) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2450
2451-- --------------------------------------------------------
2452
2453--
2454-- Table structure for table `grupas`
2455--
2456
2457DROP TABLE IF EXISTS `grupas`;
2458CREATE TABLE IF NOT EXISTS `grupas` (
2459  `Nosaukums` char(10) DEFAULT NULL,
2460  `ID` int(10) NOT NULL AUTO_INCREMENT,
2461  `Kvalifikacija` int(10) DEFAULT NULL,
2462  PRIMARY KEY (`ID`),
2463  UNIQUE KEY `Nosaukums` (`Nosaukums`),
2464  KEY `Kvalifikacija` (`Kvalifikacija`)
2465) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
2466
2467--
2468-- Dumping data for table `grupas`
2469--
2470
2471INSERT INTO `grupas` (`Nosaukums`, `ID`, `Kvalifikacija`) VALUES
2472('D4-1', 1, 1),
2473('D4-2', 2, 1),
2474('D4-3', 3, 2),
2475('D4-4', 4, 2);
2476
2477-- --------------------------------------------------------
2478
2479--
2480-- Table structure for table `komisijas`
2481--
2482
2483DROP TABLE IF EXISTS `komisijas`;
2484CREATE TABLE IF NOT EXISTS `komisijas` (
2485  `ID` int(10) NOT NULL AUTO_INCREMENT,
2486  `Nosaukums` char(30) DEFAULT NULL,
2487  PRIMARY KEY (`ID`)
2488) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
2489
2490--
2491-- Dumping data for table `komisijas`
2492--
2493
2494INSERT INTO `komisijas` (`ID`, `Nosaukums`) VALUES
2495(1, 'Info. un komunik. tehnologijas');
2496
2497-- --------------------------------------------------------
2498
2499--
2500-- Table structure for table `kvalifikacija`
2501--
2502
2503DROP TABLE IF EXISTS `kvalifikacija`;
2504CREATE TABLE IF NOT EXISTS `kvalifikacija` (
2505  `Nosaukums` char(30) DEFAULT NULL,
2506  `ID` int(10) NOT NULL AUTO_INCREMENT,
2507  PRIMARY KEY (`ID`)
2508) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2509
2510--
2511-- Dumping data for table `kvalifikacija`
2512--
2513
2514INSERT INTO `kvalifikacija` (`Nosaukums`, `ID`) VALUES
2515('Programmesanas tehnikis', 1),
2516('Datorsistemas tehnikis', 2);
2517
2518-- --------------------------------------------------------
2519
2520--
2521-- Table structure for table `macas`
2522--
2523
2524DROP TABLE IF EXISTS `macas`;
2525CREATE TABLE IF NOT EXISTS `macas` (
2526  `audzeknis` char(20) DEFAULT NULL,
2527  `Macibu_Prieksmets` char(10) NOT NULL,
2528  `Vertejums` int(2) NOT NULL,
2529  `id` int(10) NOT NULL,
2530  PRIMARY KEY (`Macibu_Prieksmets`,`Vertejums`),
2531  KEY `audzeknis` (`audzeknis`)
2532) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2533
2534-- --------------------------------------------------------
2535
2536--
2537-- Table structure for table `macibu_plans`
2538--
2539
2540DROP TABLE IF EXISTS `macibu_plans`;
2541CREATE TABLE IF NOT EXISTS `macibu_plans` (
2542  `Semestris` int(10) NOT NULL,
2543  `Grupa` char(10) DEFAULT NULL,
2544  `Prieksmets` char(40) DEFAULT NULL,
2545  `Teorijas_stundusk` int(10) DEFAULT NULL,
2546  `Praktisko_stundusk` int(10) DEFAULT NULL,
2547  PRIMARY KEY (`Semestris`),
2548  KEY `Prieksmets` (`Prieksmets`),
2549  KEY `Grupa` (`Grupa`)
2550) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2551
2552-- --------------------------------------------------------
2553
2554--
2555-- Table structure for table `macibu_prieksmets`
2556--
2557
2558DROP TABLE IF EXISTS `macibu_prieksmets`;
2559CREATE TABLE IF NOT EXISTS `macibu_prieksmets` (
2560  `Nosaukums` char(35) NOT NULL,
2561  `Pasniedzejs` char(12) DEFAULT NULL,
2562  PRIMARY KEY (`Nosaukums`),
2563  KEY `Pasniedzejs` (`Pasniedzejs`)
2564) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2565
2566-- --------------------------------------------------------
2567
2568--
2569-- Table structure for table `pasniedz`
2570--
2571
2572DROP TABLE IF EXISTS `pasniedz`;
2573CREATE TABLE IF NOT EXISTS `pasniedz` (
2574  `prieksmets` char(35) DEFAULT NULL,
2575  `skolotajs` char(20) DEFAULT NULL,
2576  KEY `prieksmets_fk` (`prieksmets`),
2577  KEY `skolotajs_fk` (`skolotajs`)
2578) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2579
2580-- --------------------------------------------------------
2581
2582--
2583-- Table structure for table `skolotajs`
2584--
2585
2586DROP TABLE IF EXISTS `skolotajs`;
2587CREATE TABLE IF NOT EXISTS `skolotajs` (
2588  `Vards` char(20) DEFAULT NULL,
2589  `Uzvards` char(20) DEFAULT NULL,
2590  `Stazs` int(10) DEFAULT NULL,
2591  `Talrunis` char(20) NOT NULL,
2592  `Komisija` int(10) DEFAULT NULL,
2593  PRIMARY KEY (`Talrunis`),
2594  KEY `Komisija` (`Komisija`)
2595) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2596
2597--
2598-- Dumping data for table `skolotajs`
2599--
2600
2601INSERT INTO `skolotajs` (`Vards`, `Uzvards`, `Stazs`, `Talrunis`, `Komisija`) VALUES
2602('Jelena', 'Matvejeva', 15, '11111111', 1),
2603('Jurijs', 'Kudrins', 25, '2222222', 1),
2604('Vitalijs', 'Sabanskis', 10, '33333333', 1);
2605
2606--
2607-- Constraints for dumped tables
2608--
2609
2610--
2611-- Constraints for table `audzekni`
2612--
2613ALTER TABLE `audzekni`
2614  ADD CONSTRAINT `audzekni_ibfk_1` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`ID`);
2615
2616--
2617-- Constraints for table `grupas`
2618--
2619ALTER TABLE `grupas`
2620  ADD CONSTRAINT `grupas_ibfk_1` FOREIGN KEY (`Kvalifikacija`) REFERENCES `kvalifikacija` (`ID`);
2621
2622--
2623-- Constraints for table `macas`
2624--
2625ALTER TABLE `macas`
2626  ADD CONSTRAINT `macas_ibfk_1` FOREIGN KEY (`audzeknis`) REFERENCES `audzekni` (`Personas_Kods`);
2627
2628--
2629-- Constraints for table `macibu_plans`
2630--
2631ALTER TABLE `macibu_plans`
2632  ADD CONSTRAINT `macibu_plans_ibfk_1` FOREIGN KEY (`Prieksmets`) REFERENCES `macibu_prieksmets` (`Nosaukums`),
2633  ADD CONSTRAINT `macibu_plans_ibfk_2` FOREIGN KEY (`Grupa`) REFERENCES `grupas` (`Nosaukums`);
2634
2635--
2636-- Constraints for table `macibu_prieksmets`
2637--
2638ALTER TABLE `macibu_prieksmets`
2639  ADD CONSTRAINT `macibu_prieksmeti_ibfk_1` FOREIGN KEY (`Pasniedzejs`) REFERENCES `skolotajs` (`Talrunis`);
2640
2641--
2642-- Constraints for table `pasniedz`
2643--
2644ALTER TABLE `pasniedz`
2645  ADD CONSTRAINT `prieksmets_fk` FOREIGN KEY (`prieksmets`) REFERENCES `macibu_prieksmets` (`Nosaukums`),
2646  ADD CONSTRAINT `skolotajs_fk` FOREIGN KEY (`skolotajs`) REFERENCES `skolotajs` (`Talrunis`);
2647
2648--
2649-- Constraints for table `skolotajs`
2650--
2651ALTER TABLE `skolotajs`
2652  ADD CONSTRAINT `skolotajs_ibfk_1` FOREIGN KEY (`Komisija`) REFERENCES `komisijas` (`ID`);
2653--
2654-- Database: `vingr3_rihardss`
2655--
2656CREATE DATABASE IF NOT EXISTS `vingr3_rihardss` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2657USE `vingr3_rihardss`;
2658
2659-- --------------------------------------------------------
2660
2661--
2662-- Table structure for table `audzekni`
2663--
2664
2665DROP TABLE IF EXISTS `audzekni`;
2666CREATE TABLE IF NOT EXISTS `audzekni` (
2667  `id` int(11) NOT NULL AUTO_INCREMENT,
2668  `vards` char(30) DEFAULT NULL,
2669  `uzvards` char(50) DEFAULT NULL,
2670  `dzimdiena` date DEFAULT NULL,
2671  `grupa` int(11) DEFAULT NULL,
2672  PRIMARY KEY (`id`),
2673  KEY `grupa` (`grupa`)
2674) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
2675
2676-- --------------------------------------------------------
2677
2678--
2679-- Table structure for table `grupas`
2680--
2681
2682DROP TABLE IF EXISTS `grupas`;
2683CREATE TABLE IF NOT EXISTS `grupas` (
2684  `id` int(11) NOT NULL AUTO_INCREMENT,
2685  `nosaukums` char(5) DEFAULT NULL,
2686  `kvalifikacija` int(11) DEFAULT NULL,
2687  PRIMARY KEY (`id`),
2688  KEY `kvalifikacija` (`kvalifikacija`)
2689) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
2690
2691--
2692-- Dumping data for table `grupas`
2693--
2694
2695INSERT INTO `grupas` (`id`, `nosaukums`, `kvalifikacija`) VALUES
2696(5, 'D4-1', 1),
2697(6, 'D4-2', 1),
2698(7, 'D4-3', 2),
2699(8, 'D4-4', 2),
2700(9, 'D3-1', 1),
2701(10, 'D3-4', 1);
2702
2703-- --------------------------------------------------------
2704
2705--
2706-- Table structure for table `komisijas`
2707--
2708
2709DROP TABLE IF EXISTS `komisijas`;
2710CREATE TABLE IF NOT EXISTS `komisijas` (
2711  `id` int(11) NOT NULL AUTO_INCREMENT,
2712  `nosaukums` char(100) DEFAULT NULL,
2713  PRIMARY KEY (`id`)
2714) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
2715
2716--
2717-- Dumping data for table `komisijas`
2718--
2719
2720INSERT INTO `komisijas` (`id`, `nosaukums`) VALUES
2721(1, 'IKT'),
2722(2, 'Matematika un dabaszinibas'),
2723(3, 'Latviesu valoda un dabas zinibas');
2724
2725-- --------------------------------------------------------
2726
2727--
2728-- Table structure for table `kvalifikacijas`
2729--
2730
2731DROP TABLE IF EXISTS `kvalifikacijas`;
2732CREATE TABLE IF NOT EXISTS `kvalifikacijas` (
2733  `id` int(11) NOT NULL AUTO_INCREMENT,
2734  `nosaukums` char(50) DEFAULT NULL,
2735  PRIMARY KEY (`id`)
2736) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
2737
2738--
2739-- Dumping data for table `kvalifikacijas`
2740--
2741
2742INSERT INTO `kvalifikacijas` (`id`, `nosaukums`) VALUES
2743(1, 'Programm??anas tehni?is'),
2744(2, 'Datorsist?mu tehni?is');
2745
2746-- --------------------------------------------------------
2747
2748--
2749-- Table structure for table `maca`
2750--
2751
2752DROP TABLE IF EXISTS `maca`;
2753CREATE TABLE IF NOT EXISTS `maca` (
2754  `semestris` int(11) DEFAULT NULL,
2755  `p_stundas` int(11) DEFAULT NULL,
2756  `t_stundas` int(11) DEFAULT NULL,
2757  `grupa` int(11) NOT NULL,
2758  `skolotajs` char(10) NOT NULL,
2759  `prieksmets` int(11) NOT NULL,
2760  PRIMARY KEY (`grupa`,`skolotajs`,`prieksmets`),
2761  KEY `prieksmets` (`prieksmets`),
2762  KEY `skolotajs` (`skolotajs`)
2763) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2764
2765-- --------------------------------------------------------
2766
2767--
2768-- Table structure for table `macas`
2769--
2770
2771DROP TABLE IF EXISTS `macas`;
2772CREATE TABLE IF NOT EXISTS `macas` (
2773  `vertejums` int(11) DEFAULT NULL,
2774  `skolens` int(11) NOT NULL,
2775  `prieksmets` int(11) NOT NULL,
2776  PRIMARY KEY (`skolens`,`prieksmets`),
2777  KEY `prieksmets` (`prieksmets`)
2778) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2779
2780-- --------------------------------------------------------
2781
2782--
2783-- Table structure for table `pasniedz`
2784--
2785
2786DROP TABLE IF EXISTS `pasniedz`;
2787CREATE TABLE IF NOT EXISTS `pasniedz` (
2788  `prieksmets` int(11) NOT NULL,
2789  `skolotajs` char(10) NOT NULL,
2790  PRIMARY KEY (`prieksmets`,`skolotajs`),
2791  KEY `skolotajs` (`skolotajs`)
2792) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2793
2794-- --------------------------------------------------------
2795
2796--
2797-- Table structure for table `prieksmeti`
2798--
2799
2800DROP TABLE IF EXISTS `prieksmeti`;
2801CREATE TABLE IF NOT EXISTS `prieksmeti` (
2802  `id` int(11) NOT NULL AUTO_INCREMENT,
2803  `nosaukums` char(50) DEFAULT NULL,
2804  PRIMARY KEY (`id`)
2805) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
2806
2807--
2808-- Dumping data for table `prieksmeti`
2809--
2810
2811INSERT INTO `prieksmeti` (`id`, `nosaukums`) VALUES
2812(5, 'Informatika'),
2813(6, 'matekatika'),
2814(7, 'latviesu valoda'),
2815(8, 'programmesanas valodas');
2816
2817-- --------------------------------------------------------
2818
2819--
2820-- Table structure for table `skolotaji`
2821--
2822
2823DROP TABLE IF EXISTS `skolotaji`;
2824CREATE TABLE IF NOT EXISTS `skolotaji` (
2825  `talrunis` char(10) NOT NULL,
2826  `vards` char(30) DEFAULT NULL,
2827  `uzvards` char(50) DEFAULT NULL,
2828  `stazs` int(11) DEFAULT NULL,
2829  `komisija` int(11) DEFAULT NULL,
2830  PRIMARY KEY (`talrunis`),
2831  KEY `komisija` (`komisija`)
2832) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2833
2834--
2835-- Dumping data for table `skolotaji`
2836--
2837
2838INSERT INTO `skolotaji` (`talrunis`, `vards`, `uzvards`, `stazs`, `komisija`) VALUES
2839('11 111 111', 'Jelena', 'Matvejeva', 15, 1),
2840('21 533 381', 'Liene', 'Lane', 21, 3),
2841('21 540 321', 'marija', 'Jaunzeme', 23, 2),
2842('22 000 221', 'Maris', 'danne', 12, 1),
2843('22 222 222', 'Jurijs', 'Kudrins', 25, 1),
2844('33 333 333', 'Vitalijs', 'Sabanskis', 10, 1),
2845('55 040 321', 'Igors', 'Litvjakovs', 999, 1),
2846('55 040 351', 'Armands', 'Jaunzemis', 5, 1);
2847
2848--
2849-- Constraints for dumped tables
2850--
2851
2852--
2853-- Constraints for table `audzekni`
2854--
2855ALTER TABLE `audzekni`
2856  ADD CONSTRAINT `audzekni_ibfk_1` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
2857
2858--
2859-- Constraints for table `grupas`
2860--
2861ALTER TABLE `grupas`
2862  ADD CONSTRAINT `grupas_ibfk_1` FOREIGN KEY (`kvalifikacija`) REFERENCES `kvalifikacijas` (`id`);
2863
2864--
2865-- Constraints for table `maca`
2866--
2867ALTER TABLE `maca`
2868  ADD CONSTRAINT `maca_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
2869  ADD CONSTRAINT `maca_ibfk_2` FOREIGN KEY (`grupa`) REFERENCES `grupas` (`id`),
2870  ADD CONSTRAINT `maca_ibfk_3` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
2871
2872--
2873-- Constraints for table `macas`
2874--
2875ALTER TABLE `macas`
2876  ADD CONSTRAINT `macas_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
2877  ADD CONSTRAINT `macas_ibfk_2` FOREIGN KEY (`skolens`) REFERENCES `audzekni` (`id`);
2878
2879--
2880-- Constraints for table `pasniedz`
2881--
2882ALTER TABLE `pasniedz`
2883  ADD CONSTRAINT `pasniedz_ibfk_1` FOREIGN KEY (`prieksmets`) REFERENCES `prieksmeti` (`id`),
2884  ADD CONSTRAINT `pasniedz_ibfk_2` FOREIGN KEY (`skolotajs`) REFERENCES `skolotaji` (`talrunis`);
2885
2886--
2887-- Constraints for table `skolotaji`
2888--
2889ALTER TABLE `skolotaji`
2890  ADD CONSTRAINT `skolotaji_ibfk_1` FOREIGN KEY (`komisija`) REFERENCES `komisijas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
2891--
2892-- Database: `vingr4`
2893--
2894CREATE DATABASE IF NOT EXISTS `vingr4` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2895USE `vingr4`;
2896
2897-- --------------------------------------------------------
2898
2899--
2900-- Table structure for table `celojumi`
2901--
2902
2903DROP TABLE IF EXISTS `celojumi`;
2904CREATE TABLE IF NOT EXISTS `celojumi` (
2905  `ID` int(11) NOT NULL AUTO_INCREMENT,
2906  `cena` int(11) DEFAULT NULL,
2907  `Viesnica` int(11) DEFAULT NULL,
2908  `valsts` int(11) DEFAULT NULL,
2909  `ediena_Tips` int(11) DEFAULT NULL,
2910  PRIMARY KEY (`ID`),
2911  KEY `Viesnica` (`Viesnica`),
2912  KEY `valsts` (`valsts`),
2913  KEY `ediena_Tips` (`ediena_Tips`)
2914) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2915
2916-- --------------------------------------------------------
2917
2918--
2919-- Table structure for table `dalibnieki`
2920--
2921
2922DROP TABLE IF EXISTS `dalibnieki`;
2923CREATE TABLE IF NOT EXISTS `dalibnieki` (
2924  `Pases_numurs` char(20) NOT NULL,
2925  `Termins` date DEFAULT NULL,
2926  `Klienti` char(20) DEFAULT NULL,
2927  PRIMARY KEY (`Pases_numurs`),
2928  KEY `Klienti` (`Klienti`)
2929) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2930
2931-- --------------------------------------------------------
2932
2933--
2934-- Table structure for table `ediena_tips`
2935--
2936
2937DROP TABLE IF EXISTS `ediena_tips`;
2938CREATE TABLE IF NOT EXISTS `ediena_tips` (
2939  `ID` int(11) NOT NULL AUTO_INCREMENT,
2940  `Nosaukums` char(20) DEFAULT NULL,
2941  PRIMARY KEY (`ID`)
2942) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2943
2944-- --------------------------------------------------------
2945
2946--
2947-- Table structure for table `klienti`
2948--
2949
2950DROP TABLE IF EXISTS `klienti`;
2951CREATE TABLE IF NOT EXISTS `klienti` (
2952  `Personas_kods` char(20) NOT NULL,
2953  `Vards` char(20) DEFAULT NULL,
2954  `Uzvards` char(20) DEFAULT NULL,
2955  `Deklaracijas_adrese` char(20) DEFAULT NULL,
2956  PRIMARY KEY (`Personas_kods`)
2957) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2958
2959-- --------------------------------------------------------
2960
2961--
2962-- Table structure for table `pilseta`
2963--
2964
2965DROP TABLE IF EXISTS `pilseta`;
2966CREATE TABLE IF NOT EXISTS `pilseta` (
2967  `ID` int(11) NOT NULL AUTO_INCREMENT,
2968  `Nosaukums` char(50) DEFAULT NULL,
2969  `valsts` int(11) DEFAULT NULL,
2970  PRIMARY KEY (`ID`),
2971  KEY `valsts` (`valsts`)
2972) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2973
2974-- --------------------------------------------------------
2975
2976--
2977-- Table structure for table `valsts`
2978--
2979
2980DROP TABLE IF EXISTS `valsts`;
2981CREATE TABLE IF NOT EXISTS `valsts` (
2982  `ID` int(11) NOT NULL AUTO_INCREMENT,
2983  `Nosaukums` char(50) DEFAULT NULL,
2984  PRIMARY KEY (`ID`)
2985) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2986
2987-- --------------------------------------------------------
2988
2989--
2990-- Table structure for table `viesnica`
2991--
2992
2993DROP TABLE IF EXISTS `viesnica`;
2994CREATE TABLE IF NOT EXISTS `viesnica` (
2995  `ID` int(11) NOT NULL AUTO_INCREMENT,
2996  `Nosaukums` int(50) DEFAULT NULL,
2997  `Attels` blob,
2998  `Reitings` int(11) DEFAULT NULL,
2999  PRIMARY KEY (`ID`)
3000) ENGINE=InnoDB DEFAULT CHARSET=latin1;
3001
3002--
3003-- Constraints for dumped tables
3004--
3005
3006--
3007-- Constraints for table `celojumi`
3008--
3009ALTER TABLE `celojumi`
3010  ADD CONSTRAINT `celojumi_ibfk_1` FOREIGN KEY (`Viesnica`) REFERENCES `viesnica` (`ID`),
3011  ADD CONSTRAINT `celojumi_ibfk_2` FOREIGN KEY (`valsts`) REFERENCES `valsts` (`ID`),
3012  ADD CONSTRAINT `celojumi_ibfk_3` FOREIGN KEY (`ediena_Tips`) REFERENCES `ediena_tips` (`ID`);
3013
3014--
3015-- Constraints for table `dalibnieki`
3016--
3017ALTER TABLE `dalibnieki`
3018  ADD CONSTRAINT `dalibnieki_ibfk_1` FOREIGN KEY (`Klienti`) REFERENCES `klienti` (`Personas_kods`);
3019
3020--
3021-- Constraints for table `pilseta`
3022--
3023ALTER TABLE `pilseta`
3024  ADD CONSTRAINT `pilseta_ibfk_1` FOREIGN KEY (`valsts`) REFERENCES `valsts` (`ID`);
3025COMMIT;
3026
3027/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
3028/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
3029/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;