source: DB/polnenje.sql@ 6791e89

Last change on this file since 6791e89 was 6da3d12, checked in by Jovana Mitrovic <jovanamitrovic038@…>, 2 years ago

final version

  • Property mode set to 100644
File size: 2.0 KB
Line 
1insert into PERSON(id_person, namee, surname, address, town, phone_num, birth, email, pass)
2 values (1,'Marija','Markovska','ul.Partizanski Odredi','Skopje','070555666', '2001-10-27', 'marija@gmail.com', 'marija5932'),
3 (2, 'Aleks','Aleksikj','ul.Oktomvriska Revolucija','Kumanovo','075855744', '2001-12-31', 'aleksa@hotmail.com', 'aleks8908');
4
5insert into LIBRARY_DB(id_library, names, city)
6 values (201,'Sv.Braka Miladinovci', 'Skopje'),
7 (202, 'Tane Georgievski','Kumanovo');
8
9insert into EMPLOYEE(id_person,id_library,positionn)
10 values (1,201,'bibliotekar');
11
12insert into SCHOOL_TYPE (id_school, school_type_name)
13 values (21,'Osnovno uciliste');
14
15insert into MEMBERSHIP_TYPE (id_membership, mem_type_name)
16 values(010, 'ucenik-clenstvo');
17
18insert into MEMBER_LIBRARY (id_person, id_school, id_membership, id_library, isPayedMemebership, isPayedBook)
19 values (1, 21, 010, 202, True, True);
20
21insert into PRICELIST (id_price , id_membership, price)
22 values (41,010,200);
23
24insert into ROOM (id_room, places, free_places, id_library)
25 values (2,60,10,202);
26
27insert into GENRE (id_genre, namee)
28 values (17,'novel');
29
30insert into BOOK (id_book, id_library, namee, book_num, if_free, book_price, book_price_late, id_genre)
31 values (1,201,'Game of Thrones',4,True, 30, 45,17);
32
33
34insert into REVIEW (id_review, rent_num, rate, id_book)
35 values (7,15,8,1);
36
37insert into WRITER (id_writer, namee, book_num)
38 values (5,'George R. R. Martin',60);
39
40insert into ONLINE_DOWNLOAD (id_onlineDown, id_book, id_member, downloaded)
41 values(21,1,1,1);
42
43insert into RESERVATION_BOOK (id_resBook, id_book, id_member, take_date, return_date, isReservedBook)
44 values (07, 1, 1, '2022-02-5', '2021-02-18', True);
45
46
47insert into RESERVATION_PLACE (id_resRoom, id_member, id_room, coming_date, comingTime, leavingTime)
48 values(205, 1, 2, '2022-02-15', '13:00', '10:00');
49
50insert into MEMBERSHIP_OF_SCHOOLTYPE (id_membership, id_school)
51 values (010,21);
52
53
54insert into WRITER_OF_BOOK (id_book,id_writer)
55 values(1,5);
Note: See TracBrowser for help on using the repository browser.