INSERT INTO library_management (
 institution_id, branch_id, class_id, subject_id,
 barcode, book_name, book_number, author, genre,
 date_of_purchase, bill, bill_reference, book_reference,
 opening_quantity, current_quantity, year_of_publication,
 price, language, publisher,
 added_by, last_modified_by, date_added, time_created, status
) VALUES
(
1,
1,
NULL,
NULL,
'B42451',
'Library Book 42451',
42451,
'Author 42451',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42451',
'BR42451',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42452',
'Library Book 42452',
42452,
'Author 42452',
'Science',
'2026-02-01',
NULL,
'REF42452',
'BR42452',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42453',
'Library Book 42453',
42453,
'Author 42453',
'History',
'2026-02-01',
NULL,
'REF42453',
'BR42453',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42454',
'Library Book 42454',
42454,
'Author 42454',
'Fiction',
'2026-02-01',
NULL,
'REF42454',
'BR42454',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42455',
'Library Book 42455',
42455,
'Author 42455',
'Study Material',
'2026-02-01',
NULL,
'REF42455',
'BR42455',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42456',
'Library Book 42456',
42456,
'Author 42456',
'Biography',
'2026-02-01',
NULL,
'REF42456',
'BR42456',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42457',
'Library Book 42457',
42457,
'Author 42457',
'Literature',
'2026-02-01',
NULL,
'REF42457',
'BR42457',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42458',
'Library Book 42458',
42458,
'Author 42458',
'Psychology',
'2026-02-01',
NULL,
'REF42458',
'BR42458',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42459',
'Library Book 42459',
42459,
'Author 42459',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42459',
'BR42459',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42460',
'Library Book 42460',
42460,
'Author 42460',
'Science',
'2026-02-01',
NULL,
'REF42460',
'BR42460',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42461',
'Library Book 42461',
42461,
'Author 42461',
'History',
'2026-02-01',
NULL,
'REF42461',
'BR42461',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42462',
'Library Book 42462',
42462,
'Author 42462',
'Fiction',
'2026-02-01',
NULL,
'REF42462',
'BR42462',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42463',
'Library Book 42463',
42463,
'Author 42463',
'Study Material',
'2026-02-01',
NULL,
'REF42463',
'BR42463',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42464',
'Library Book 42464',
42464,
'Author 42464',
'Biography',
'2026-02-01',
NULL,
'REF42464',
'BR42464',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42465',
'Library Book 42465',
42465,
'Author 42465',
'Literature',
'2026-02-01',
NULL,
'REF42465',
'BR42465',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42466',
'Library Book 42466',
42466,
'Author 42466',
'Psychology',
'2026-02-01',
NULL,
'REF42466',
'BR42466',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42467',
'Library Book 42467',
42467,
'Author 42467',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42467',
'BR42467',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42468',
'Library Book 42468',
42468,
'Author 42468',
'Science',
'2026-02-01',
NULL,
'REF42468',
'BR42468',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42469',
'Library Book 42469',
42469,
'Author 42469',
'History',
'2026-02-01',
NULL,
'REF42469',
'BR42469',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42470',
'Library Book 42470',
42470,
'Author 42470',
'Fiction',
'2026-02-01',
NULL,
'REF42470',
'BR42470',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42471',
'Library Book 42471',
42471,
'Author 42471',
'Study Material',
'2026-02-01',
NULL,
'REF42471',
'BR42471',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42472',
'Library Book 42472',
42472,
'Author 42472',
'Biography',
'2026-02-01',
NULL,
'REF42472',
'BR42472',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42473',
'Library Book 42473',
42473,
'Author 42473',
'Literature',
'2026-02-01',
NULL,
'REF42473',
'BR42473',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42474',
'Library Book 42474',
42474,
'Author 42474',
'Psychology',
'2026-02-01',
NULL,
'REF42474',
'BR42474',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42475',
'Library Book 42475',
42475,
'Author 42475',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42475',
'BR42475',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42476',
'Library Book 42476',
42476,
'Author 42476',
'Science',
'2026-02-01',
NULL,
'REF42476',
'BR42476',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42477',
'Library Book 42477',
42477,
'Author 42477',
'History',
'2026-02-01',
NULL,
'REF42477',
'BR42477',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42478',
'Library Book 42478',
42478,
'Author 42478',
'Fiction',
'2026-02-01',
NULL,
'REF42478',
'BR42478',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42479',
'Library Book 42479',
42479,
'Author 42479',
'Study Material',
'2026-02-01',
NULL,
'REF42479',
'BR42479',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42480',
'Library Book 42480',
42480,
'Author 42480',
'Biography',
'2026-02-01',
NULL,
'REF42480',
'BR42480',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42481',
'Library Book 42481',
42481,
'Author 42481',
'Literature',
'2026-02-01',
NULL,
'REF42481',
'BR42481',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42482',
'Library Book 42482',
42482,
'Author 42482',
'Psychology',
'2026-02-01',
NULL,
'REF42482',
'BR42482',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42483',
'Library Book 42483',
42483,
'Author 42483',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42483',
'BR42483',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42484',
'Library Book 42484',
42484,
'Author 42484',
'Science',
'2026-02-01',
NULL,
'REF42484',
'BR42484',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42485',
'Library Book 42485',
42485,
'Author 42485',
'History',
'2026-02-01',
NULL,
'REF42485',
'BR42485',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42486',
'Library Book 42486',
42486,
'Author 42486',
'Fiction',
'2026-02-01',
NULL,
'REF42486',
'BR42486',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42487',
'Library Book 42487',
42487,
'Author 42487',
'Study Material',
'2026-02-01',
NULL,
'REF42487',
'BR42487',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42488',
'Library Book 42488',
42488,
'Author 42488',
'Biography',
'2026-02-01',
NULL,
'REF42488',
'BR42488',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42489',
'Library Book 42489',
42489,
'Author 42489',
'Literature',
'2026-02-01',
NULL,
'REF42489',
'BR42489',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42490',
'Library Book 42490',
42490,
'Author 42490',
'Psychology',
'2026-02-01',
NULL,
'REF42490',
'BR42490',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42491',
'Library Book 42491',
42491,
'Author 42491',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42491',
'BR42491',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42492',
'Library Book 42492',
42492,
'Author 42492',
'Science',
'2026-02-01',
NULL,
'REF42492',
'BR42492',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42493',
'Library Book 42493',
42493,
'Author 42493',
'History',
'2026-02-01',
NULL,
'REF42493',
'BR42493',
10,
10,
2019,
200,
'English',
'Oxford',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42494',
'Library Book 42494',
42494,
'Author 42494',
'Fiction',
'2026-02-01',
NULL,
'REF42494',
'BR42494',
10,
10,
2019,
200,
'English',
'Bloomsbury',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42495',
'Library Book 42495',
42495,
'Author 42495',
'Study Material',
'2026-02-01',
NULL,
'REF42495',
'BR42495',
10,
10,
2019,
200,
'English',
'McGraw Hill',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42496',
'Library Book 42496',
42496,
'Author 42496',
'Biography',
'2026-02-01',
NULL,
'REF42496',
'BR42496',
10,
10,
2019,
200,
'English',
'Penguin',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42497',
'Library Book 42497',
42497,
'Author 42497',
'Literature',
'2026-02-01',
NULL,
'REF42497',
'BR42497',
10,
10,
2019,
200,
'English',
'HarperCollins',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
3,
NULL,
NULL,
'B42498',
'Library Book 42498',
42498,
'Author 42498',
'Psychology',
'2026-02-01',
NULL,
'REF42498',
'BR42498',
10,
10,
2019,
200,
'English',
'Random House',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
1,
NULL,
NULL,
'B42499',
'Library Book 42499',
42499,
'Author 42499',
'Non-Fiction',
'2026-02-01',
NULL,
'REF42499',
'BR42499',
10,
10,
2019,
200,
'English',
'ABC Pub',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
),
(
1,
2,
NULL,
NULL,
'B42500',
'Library Book 42500',
42500,
'Author 42500',
'Science',
'2026-02-01',
NULL,
'REF42500',
'BR42500',
10,
10,
2019,
200,
'English',
'Pearson',
'admin@school.com',
'admin@school.com',
'2026-02-12',
UNIX_TIMESTAMP(),
1
);