· 6 years ago · Jan 12, 2020, 06:42 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.10
3-- https://www.phpmyadmin.net
4--
5-- Хост: localhost
6-- Время создания: Янв 12 2020 г., 20:38
7-- Версия сервера: 10.2.25-MariaDB
8-- Версия PHP: 5.6.40
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- База данных: `if19_raamatukogu_ABproj`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `Authors`
27--
28
29CREATE TABLE IF NOT EXISTS `Authors` (
30 `ID` int(11) NOT NULL,
31 `PublishingHouseID` int(11) NOT NULL,
32 `AFirstName` varchar(30) NOT NULL,
33 `ALastName` varchar(30) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Дамп данных таблицы `Authors`
38--
39
40INSERT INTO `Authors` (`ID`, `PublishingHouseID`, `AFirstName`, `ALastName`) VALUES
41(1, 1, 'Teet', 'Evartson');
42
43-- --------------------------------------------------------
44
45--
46-- Структура таблицы `BookDetails`
47--
48
49CREATE TABLE IF NOT EXISTS `BookDetails` (
50 `ID` int(11) NOT NULL,
51 `BookID` int(11) NOT NULL,
52 `BookDescription` varchar(2000) NOT NULL,
53 `PageCount` int(10) NOT NULL,
54 `BookRating` int(10) NOT NULL
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57--
58-- Дамп данных таблицы `BookDetails`
59--
60
61INSERT INTO `BookDetails` (`ID`, `BookID`, `BookDescription`, `PageCount`, `BookRating`) VALUES
62(1, 1, 'Õpik annab ülevaate arvutitehnika riistvara funktsioneerimise alustest ja koosneb on järgmistest osadest: sissejuhatus, digitaalloogika, protsessor, mälud, käsustik ja adresseerimisviisid, andmevahetus mikroarvutis, sisend-väljundseadmed ja eririistvara.', 360, 5);
63
64-- --------------------------------------------------------
65
66--
67-- Структура таблицы `Books`
68--
69
70CREATE TABLE IF NOT EXISTS `Books` (
71 `ID` int(11) NOT NULL,
72 `AuthorID` int(11) NOT NULL,
73 `GenreID` int(11) NOT NULL,
74 `BookName` varchar(50) NOT NULL,
75 `LanguageID` int(11) NOT NULL,
76 `Year` date NOT NULL,
77 `Quantity` int(11) NOT NULL
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80--
81-- Дамп данных таблицы `Books`
82--
83
84INSERT INTO `Books` (`ID`, `AuthorID`, `GenreID`, `BookName`, `LanguageID`, `Year`, `Quantity`) VALUES
85(1, 1, 1, 'Arvutitehnika riistvara', 1, '2015-04-30', 10);
86
87-- --------------------------------------------------------
88
89--
90-- Структура таблицы `Genres`
91--
92
93CREATE TABLE IF NOT EXISTS `Genres` (
94 `ID` int(11) NOT NULL,
95 `GName` varchar(50) NOT NULL
96) ENGINE=InnoDB DEFAULT CHARSET=latin1;
97
98--
99-- Дамп данных таблицы `Genres`
100--
101
102INSERT INTO `Genres` (`ID`, `GName`) VALUES
103(1, 'Arvuti ja internet');
104
105-- --------------------------------------------------------
106
107--
108-- Структура таблицы `Languages`
109--
110
111CREATE TABLE IF NOT EXISTS `Languages` (
112 `ID` int(11) NOT NULL,
113 `LName` varchar(50) NOT NULL
114) ENGINE=InnoDB DEFAULT CHARSET=latin1;
115
116--
117-- Дамп данных таблицы `Languages`
118--
119
120INSERT INTO `Languages` (`ID`, `LName`) VALUES
121(1, 'Eesti'),
122(2, 'Vene');
123
124-- --------------------------------------------------------
125
126--
127-- Структура таблицы `PublishingHouse`
128--
129
130CREATE TABLE IF NOT EXISTS `PublishingHouse` (
131 `ID` int(11) NOT NULL,
132 `PHName` varchar(70) NOT NULL,
133 `PHCity` varchar(35) NOT NULL,
134 `PHCountry` varchar(35) NOT NULL
135) ENGINE=InnoDB DEFAULT CHARSET=latin1;
136
137--
138-- Дамп данных таблицы `PublishingHouse`
139--
140
141INSERT INTO `PublishingHouse` (`ID`, `PHName`, `PHCity`, `PHCountry`) VALUES
142(1, 'Tallinna Tehnikaülikooli Kirjastus', 'Tallinn', 'Eesti');
143
144-- --------------------------------------------------------
145
146--
147-- Структура таблицы `Students`
148--
149
150CREATE TABLE IF NOT EXISTS `Students` (
151 `ID` int(11) NOT NULL,
152 `StudentID` int(11) NOT NULL,
153 `STTeacherID` int(11) NOT NULL,
154 `StudentFirstName` varchar(30) NOT NULL,
155 `StudentLastName` varchar(30) NOT NULL,
156 `StudentFaculty` varchar(30) NOT NULL
157) ENGINE=InnoDB DEFAULT CHARSET=latin1;
158
159--
160-- Дамп данных таблицы `Students`
161--
162
163INSERT INTO `Students` (`ID`, `StudentID`, `STTeacherID`, `StudentFirstName`, `StudentLastName`, `StudentFaculty`) VALUES
164(77, 78785642, 99482, 'Maksim', 'Sitkin', 'Infotehnoloogia teaduskond');
165
166-- --------------------------------------------------------
167
168--
169-- Структура таблицы `StudentsData`
170--
171
172CREATE TABLE IF NOT EXISTS `StudentsData` (
173 `ID` int(11) NOT NULL,
174 `DataStudentID` int(11) NOT NULL,
175 `Adress` varchar(90) NOT NULL,
176 `Email` varchar(30) NOT NULL,
177 `PhoneNumber` varchar(10) NOT NULL
178) ENGINE=InnoDB DEFAULT CHARSET=latin1;
179
180--
181-- Дамп данных таблицы `StudentsData`
182--
183
184INSERT INTO `StudentsData` (`ID`, `DataStudentID`, `Adress`, `Email`, `PhoneNumber`) VALUES
185(1, 78785642, 'Uus 26, Pärnu', 'sitkin@tlu.ee', '372512517');
186
187-- --------------------------------------------------------
188
189--
190-- Структура таблицы `Subscription`
191--
192
193CREATE TABLE IF NOT EXISTS `Subscription` (
194 `ID` int(11) NOT NULL,
195 `SubStudentID` int(11) NOT NULL,
196 `SubBookID` int(11) NOT NULL,
197 `Status` varchar(20) NOT NULL,
198 `Date` date NOT NULL,
199 `DateEnd` date NOT NULL
200) ENGINE=InnoDB DEFAULT CHARSET=latin1;
201
202--
203-- Дамп данных таблицы `Subscription`
204--
205
206INSERT INTO `Subscription` (`ID`, `SubStudentID`, `SubBookID`, `Status`, `Date`, `DateEnd`) VALUES
207(1, 78785642, 1, 'Kehtiv', '2019-12-19', '2020-02-07');
208
209-- --------------------------------------------------------
210
211--
212-- Структура таблицы `Teachers`
213--
214
215CREATE TABLE IF NOT EXISTS `Teachers` (
216 `ID` int(11) NOT NULL,
217 `TeacherID` int(11) NOT NULL,
218 `TeacherFirstName` varchar(30) NOT NULL,
219 `TeacherLastName` varchar(30) NOT NULL,
220 `TeacherFaculty` varchar(30) NOT NULL
221) ENGINE=InnoDB DEFAULT CHARSET=latin1;
222
223--
224-- Дамп данных таблицы `Teachers`
225--
226
227INSERT INTO `Teachers` (`ID`, `TeacherID`, `TeacherFirstName`, `TeacherLastName`, `TeacherFaculty`) VALUES
228(12, 99482, 'Helle', 'Nurmsalu', 'Infotehnoloogia teaduskond');
229
230--
231-- Индексы сохранённых таблиц
232--
233
234--
235-- Индексы таблицы `Authors`
236--
237ALTER TABLE `Authors`
238 ADD PRIMARY KEY (`ID`),
239 ADD KEY `PHID` (`PublishingHouseID`),
240 ADD KEY `PHID_2` (`PublishingHouseID`);
241
242--
243-- Индексы таблицы `BookDetails`
244--
245ALTER TABLE `BookDetails`
246 ADD PRIMARY KEY (`ID`);
247
248--
249-- Индексы таблицы `Books`
250--
251ALTER TABLE `Books`
252 ADD PRIMARY KEY (`ID`);
253
254--
255-- Индексы таблицы `Genres`
256--
257ALTER TABLE `Genres`
258 ADD PRIMARY KEY (`ID`);
259
260--
261-- Индексы таблицы `Languages`
262--
263ALTER TABLE `Languages`
264 ADD PRIMARY KEY (`ID`);
265
266--
267-- Индексы таблицы `PublishingHouse`
268--
269ALTER TABLE `PublishingHouse`
270 ADD PRIMARY KEY (`ID`);
271
272--
273-- Индексы таблицы `Students`
274--
275ALTER TABLE `Students`
276 ADD PRIMARY KEY (`ID`),
277 ADD UNIQUE KEY `StudentID` (`StudentID`);
278
279--
280-- Индексы таблицы `StudentsData`
281--
282ALTER TABLE `StudentsData`
283 ADD PRIMARY KEY (`ID`);
284
285--
286-- Индексы таблицы `Subscription`
287--
288ALTER TABLE `Subscription`
289 ADD PRIMARY KEY (`ID`);
290
291--
292-- Индексы таблицы `Teachers`
293--
294ALTER TABLE `Teachers`
295 ADD PRIMARY KEY (`ID`),
296 ADD UNIQUE KEY `TeacherID` (`TeacherID`);
297
298/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
299/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
300/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;