3kJ641HT

1-- phpMyAdmin SQL Dump
2-- version 5.0.3
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Generation Time: Dec 02, 2020 at 02:49 PM
7-- Server version: 10.4.14-MariaDB
8-- PHP Version: 7.4.11
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11START TRANSACTION;
12SET time_zone = "+00:00";
13
14--
15-- Database: `uev`
16--
17CREATE DATABASE IF NOT EXISTS `uev` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
18USE `uev`;
19
20-- --------------------------------------------------------
21
22--
23-- Table structure for table `predmeti`
24--
25
26CREATE TABLE `predmeti` (
27  `id` int(4) NOT NULL,
28  `ime` varchar(60) NOT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
30
31--
32-- Dumping data for table `predmeti`
33--
34
35INSERT INTO `predmeti` (`id`, `ime`) VALUES
36(1, 'Бази от данни'),
37(2, 'Сървърно програмиране');
38
39-- --------------------------------------------------------
40
41--
42-- Table structure for table `temi`
43--
44
45CREATE TABLE `temi` (
46  `id` int(4) NOT NULL,
47  `predmet_id` int(4) NOT NULL,
48  `ime` varchar(60) NOT NULL
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
50
51--
52-- Dumping data for table `temi`
53--
54
55INSERT INTO `temi` (`id`, `predmet_id`, `ime`) VALUES
56(1, 1, 'ANSI/SPARC'),
57(2, 1, 'Групиране в SQL'),
58(3, 2, 'Сесийност'),
59(4, 2, 'Връзка с бази от данни');
60
61--
62-- Indexes for dumped tables
63--
64
65--
66-- Indexes for table `predmeti`
67--
68ALTER TABLE `predmeti`
69  ADD PRIMARY KEY (`id`);
70
71--
72-- Indexes for table `temi`
73--
74ALTER TABLE `temi`
75  ADD PRIMARY KEY (`id`);
76
77--
78-- AUTO_INCREMENT for dumped tables
79--
80
81--
82-- AUTO_INCREMENT for table `predmeti`
83--
84ALTER TABLE `predmeti`
85  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
86
87--
88-- AUTO_INCREMENT for table `temi`
89--
90ALTER TABLE `temi`
91  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
92COMMIT;
93