-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathlibraryInsertFile_MySQL.sql
More file actions
153 lines (144 loc) · 9.33 KB
/
libraryInsertFile_MySQL.sql
File metadata and controls
153 lines (144 loc) · 9.33 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
use library;
SET SQL_SAFE_UPDATES = 0;
delete from book_author;
delete from borrow;
delete from copy;
delete from author;
delete from book;
delete from member;
delete from genre;
-- https://reference.yourdictionary.com/books-literature/different-types-of-books.html
insert into GENRE values (0, 'Action and adventure', 0);
insert into GENRE values (1, 'Alternate history', 0);
insert into GENRE values (2, 'Anthology', 0);
insert into GENRE values (3, 'Chick lit', 0);
insert into GENRE values (4, 'Children\'s', 0);
insert into GENRE values (5, 'Classic', 0);
insert into GENRE values (6, 'Comic book', 0);
insert into GENRE values (7, 'Coming-of-age', 0);
insert into GENRE values (8, 'Crime', 0);
insert into GENRE values (9, 'Drama', 0);
insert into GENRE values (10, 'Fairytale', 0);
insert into GENRE values (11, 'Fantasy', 0);
insert into GENRE values (12, 'Graphic novel', 0);
insert into GENRE values (13, 'Historical fiction', 0);
insert into GENRE values (14, 'Horror', 0);
insert into GENRE values (15, 'Mystery', 0);
insert into GENRE values (16, 'Paranormal romance', 0);
insert into GENRE values (17, 'Picture book', 0);
insert into GENRE values (18, 'Poetry', 0);
insert into GENRE values (19, 'Political thriller', 0);
insert into GENRE values (20, 'Romance', 0);
insert into GENRE values (21, 'Satire', 0);
insert into GENRE values (22, 'Science fiction', 0);
insert into GENRE values (23, 'Short story', 0);
insert into GENRE values (24, 'Suspense', 0);
insert into GENRE values (25, 'Thriller', 0);
insert into GENRE values (26, 'Western', 0);
insert into GENRE values (27, 'Young adult', 0);
insert into GENRE values (28, 'Art/architecture', 1);
insert into GENRE values (29, 'Autobiography', 1);
insert into GENRE values (30, 'Biography', 1);
insert into GENRE values (31, 'Business/economics', 1);
insert into GENRE values (32, 'Crafts/hobbies', 1);
insert into GENRE values (33, 'Cookbook', 1);
insert into GENRE values (34, 'Diary', 1);
insert into GENRE values (35, 'Dictionary', 1);
insert into GENRE values (36, 'Encyclopedia', 1);
insert into GENRE values (37, 'Guide', 1);
insert into GENRE values (38, 'Health/fitness', 1);
insert into GENRE values (39, 'History', 1);
insert into GENRE values (40, 'Home and garden', 1);
insert into GENRE values (41, 'Humor', 1);
insert into GENRE values (42, 'Journal', 1);
insert into GENRE values (43, 'Math', 1);
insert into GENRE values (44, 'Memoir', 1);
insert into GENRE values (45, 'Philosophy', 1);
insert into GENRE values (46, 'Prayer', 1);
insert into GENRE values (47, 'Religion, spirituality, and new age', 1);
insert into GENRE values (48, 'Textbook', 1);
insert into GENRE values (49, 'True crime', 1);
insert into GENRE values (50, 'Review', 1);
insert into GENRE values (51, 'Science', 1);
insert into GENRE values (52, 'Self help', 1);
insert into GENRE values (53, 'Sports and leisure', 1);
insert into GENRE values (54, 'Travel', 1);
insert into GENRE values (55, 'True crime', 1);
insert into BOOK values ('Discrete Mathematics', 48, '978-1-57766-730-8', '2011-01-01', 'Waveland Press, Inc.', 1, 'Textbook for the "Discrete Structures of the CS" college level course.');
insert into BOOK values ('Alice in Wonderland', 4, '979-8749522310', '2021-05-06', 'Independently published', 1, 'This edition of the book includes original illustrations.');
insert into BOOK values ('Green Eggs and Ham', 4, '978-0375810886', '2001-01-01', 'Random House Books for Young Readers', 1, 'One of the most famous books by Dr. Seuss.');
insert into BOOK values ('The Body Keeps the Score', null, '978-0143127741', '2015-09-08', 'Penguin Publishing Group', 1, 'A book on trauma.');
insert into BOOK values ('Little Women', null, '978-1950435098', '2019-03-02', 'SeaWolf Press', 1, 'A coming-of-age novel written in 1868.');
insert into BOOK values ('Introduction to Automata Theory, Languages, and Computation', 48, '978-0321455369', '2006-06-29', 'Pearson', 3, 'Book on formal languages, automata theory, and computational complexity.');
insert into BOOK values ('Database Systems: A Practical Approach to Design, Implementation, and Management', 48, '978-0132943260', '2014-01-08', 'Pearson', 6, 'Ideal for a one or two term course in database management or database design in an undergraduate or graduate level.');
insert into BOOK values ('Oregon Archaeology', 39, '978-0870716065', '2011-10-01', 'Oregon State University Press', 1, 'Recent archeological findings on the history of Oregon.');
insert into BOOK values ('Compilers: Principles, Techniques, and Tools', 48, '978-0321486813', '2006-08-31', 'Addison Wesley', 2, 'On software engineering, programming languages, and computer architecture.');
insert into BOOK values ('Moon USA National Parks: The Complete Guide to All 62 Parks', 54, '978-1640499188', '2020-10-13', 'Moon Travel', 2, 'Comprehensive guide with wonderful pictures.');
insert into AUTHOR values (0, 'Gary', null, 'Chartrand');
insert into AUTHOR values (1, 'Ping', null, 'Zhang');
insert into AUTHOR values (2, 'Levis', null, 'Carroll');
insert into AUTHOR values (3, 'Theodor', null, 'Seuss');
insert into AUTHOR values (4, 'Bessel', null, 'van der Kolk');
insert into AUTHOR values (5, 'Louisa', 'May', 'Alcott');
insert into AUTHOR values (6, 'John', 'E.', 'Hopcroft');
insert into AUTHOR values (7, 'Rajeev', null, 'Motwani');
insert into AUTHOR values (8, 'Jeffrey', 'D.', 'Ullman');
insert into AUTHOR values (9, 'Thomas', 'M.', 'Connolly');
insert into AUTHOR values (10, 'Carolyn', 'E.', 'Begg');
insert into AUTHOR values (11, 'Melvin', 'C.', 'Aikens');
insert into AUTHOR values (12, 'Thomas', 'J.', 'Connolly');
insert into AUTHOR values (13, 'Dennis', 'L.', 'Jenkins');
insert into AUTHOR values (14, 'Alfred', 'V.', 'Aho');
insert into AUTHOR values (15, 'Monica', 'S.', 'Lam');
insert into AUTHOR values (16, 'Ravi', null, 'Sethi');
insert into AUTHOR values (17, 'Bugs', null, 'Bunny');
insert into BOOK_AUTHOR values ('978-1-57766-730-8', 0);
insert into BOOK_AUTHOR values ('978-1-57766-730-8', 1);
insert into BOOK_AUTHOR values ('979-8749522310', 2);
insert into BOOK_AUTHOR values ('978-0375810886', 3);
insert into BOOK_AUTHOR values ('978-0143127741', 4);
insert into BOOK_AUTHOR values ('978-1950435098', 5);
insert into BOOK_AUTHOR values ('978-0321455369', 6);
insert into BOOK_AUTHOR values ('978-0321455369', 7);
insert into BOOK_AUTHOR values ('978-0321455369', 8);
insert into BOOK_AUTHOR values ('978-0132943260', 9);
insert into BOOK_AUTHOR values ('978-0132943260', 10);
insert into BOOK_AUTHOR values ('978-0870716065', 11);
insert into BOOK_AUTHOR values ('978-0870716065', 12);
insert into BOOK_AUTHOR values ('978-0870716065', 13);
insert into BOOK_AUTHOR values ('978-0321486813', 8);
insert into BOOK_AUTHOR values ('978-0321486813', 14);
insert into BOOK_AUTHOR values ('978-0321486813', 15);
insert into BOOK_AUTHOR values ('978-0321486813', 16);
insert into copy values (1100, '978-1-57766-730-8', null);
insert into copy values (1101, '978-0132943260', null);
insert into copy values (1102, '978-0132943260', null);
insert into copy values (1103, '978-0132943260', 'Pencil on about 10 pages.');
insert into copy values (1104, '978-0132943260', null);
insert into copy values (1105, '978-1950435098', null);
insert into copy values (1106, '978-1950435098', null);
insert into copy values (1107, '978-1950435098', null);
insert into copy values (1108, '978-1950435098', null);
insert into copy values (1109, '978-0870716065', null);
insert into copy values (1110, '978-0870716065', null);
insert into copy values (1111, '979-8749522310', null);
insert into copy values (1112, '978-0375810886', null);
insert into copy values (1113, '978-0143127741', null);
insert into copy values (1114, '978-0321455369', null);
insert into copy values (1115, '978-0321486813', null);
insert into MEMBER values (330, 'Anna', null, 'Green', 'Broad', 'Cookeville', 'TN', 4, 38501, 9311234567, 'annagreen@tntech.edu', '2022-08-08');
insert into MEMBER values (331, 'Ben', 'Leo', 'Brown', 'Broad', 'Cookeville', 'TN', 124, 38501, 9312023030, 'benlbrown@tntech.edu', '2022-10-21');
insert into MEMBER values (332, 'Paul', null, 'Smith', 'Spring', 'Cookeville', 'TN', 23, 38506, 9313321314, 'paulsmith@tntech.edu', '2023-03-11');
insert into MEMBER values (333, 'Evan', 'David', 'Bailey', 'Jefferson', 'Cookeville', 'TN', 901, 38501, 9311234567, 'annagreen@tntech.edu', '2022-08-08');
insert into MEMBER values (334, 'Keith', 'Logan', 'Bailey', 'Jefferson', 'Cookeville', 'TN', 901, 38501, 9311234567, null, '2024-12-29');
insert into BORROW values (330, 1111, '2022-08-25 10:10:01', null, 0, null);
insert into BORROW values (331, 1105, '2022-09-03 17:56', null, 0, null);
insert into BORROW values (330, 1112, '2022-06-01 9:05:00', '2022-06-01 11:36:00', 0, null);
insert into BORROW values (331, 1105, '2022-08-15 12:07:13', '2022-08-25 18:30:30', 0, null);
insert into BORROW values (332, 1114, '2022-09-03 8:01:48', null, 0, null);
insert into BORROW values (333, 1113, '2022-08-01 11:31:24', null, 2, null);
insert into BORROW values (330, 1113, '2022-08-02 11:31:24', '2022-09-13 16:01:24', 2, null);
insert into BORROW values (330, 1100, '2022-07-14 9:15:07', '2022-08-5 11:11:14', 1, null);
insert into BORROW values (330, 1100, '2022-08-24 8:55:09', null, 2, null);
insert into BORROW values (330, 1106, '2022-05-9 14:00:09', '2022-05-19 17:11:23', 0, null);
insert into BORROW values (330, 1107, '2022-07-29 10:17:45', '2022-08-25 14:36:14', 2, null);