$--$ Create Users

INSERT INTO Users $($user$\_$id$,$ name, email, phone$\_$number, password, user$\_$type$)$

VALUES

$(1,$ 'Admin$\_1\text{'},$ 'admin$1$@example.com', $\text{'}1234567890\text{'},$ 'admin$1$password', 'Admin'$),$

$(2,$ 'Admin$\_2\text{'},$ 'admin$2$@example.com', $\text{'}1234567891\text{'},$ 'admin$2$password', 'Admin'$),$

$(3,$ 'Admin$\_3\text{'},$ 'admin$3$@example.com', $\text{'}1234567892\text{'},$ 'admin$3$password', 'Admin'$),$

$(4,$ 'Admin$\_4\text{'},$ 'admin$4$@example.com', $\text{'}1234567893\text{'},$ 'admin$4$password', 'Admin'$),$

$(5,$ 'Admin$\_5\text{'},$ 'admin$5$@example.com', $\text{'}1234567894\text{'},$ 'admin$5$password', 'Admin'$)$;

$--$ Create Appointments

INSERT INTO Appointments $($appointment$\_$id$,$ user$\_$id$,$ service$\_$type, appointment$\_$date, appointment$\_$time$)$

VALUES

$(1,1,$ 'manicure', $\text{'}2024-05-15\text{'},\text{'}09$:$00$:$00\text{'}),$

$(2,2,$ 'pedicure', $\text{'}2024-05-16\text{'},\text{'}10$:$00$:$00\text{'}),$

$(3,3,$ 'hair', $\text{'}2024-05-17\text{'},\text{'}11$:$00$:$00\text{'}),$

$(4,4,$ 'beauty treatment', $\text{'}2024-05-18\text{'},\text{'}12$:$00$:$00\text{'}),$

$(5,5,$ 'manicure', $\text{'}2024-05-19\text{'},\text{'}13$:$00$:$00\text{'}),$

$(6,1,$ 'pedicure', $\text{'}2024-05-20\text{'},\text{'}14$:$00$:$00\text{'}),$

$(7,2,$ 'hair', $\text{'}2024-05-21\text{'},\text{'}15$:$00$:$00\text{'}),$

$(8,3,$ 'beauty treatment', $\text{'}2024-05-22\text{'},\text{'}16$:$00$:$00\text{'}),$

$(9,4,$ 'manicure', $\text{'}2024-05-23\text{'},\text{'}17$:$00$:$00\text{'}),$

$(10,5,$ 'pedicure', $\text{'}2024-05-24\text{'},\text{'}18$:$00$:$00\text{'})$;

$--$ Create Services

INSERT INTO Services $($service$\_$id$,$ service$\_$name, service$\_$type, price$)$

VALUES

$(1,$ 'Manicure $1\text{'},$ 'manicure', $20),$

$(2,$ 'Manicure $2\text{'},$ 'manicure', $25),$

$(3,$ 'Manicure $3\text{'},$ 'manicure', $30),$

$--$ Repeat for pedicure, hair, and beauty treatment services $--$

$--$ Create Notifications to Users

INSERT INTO Notifications $($notification$\_$id$,$ notification$\_$type, notification$\_$message, notification$\_$date, is$\_$read$)$

SELECT

notification$\_$id$,$

'upcoming appointment',

CONCAT$(\text{'}$Your upcoming appointment is on $\text{'},$ appointment$\_$date, $\text{'}$ at $\text{'},$ appointment$\_$time$),$

NOW$(),$

$0$

FROM

Appointments

LIMIT

$30$;

$--$ Create Notifications to Admins

INSERT INTO Notifications $($notification$\_$id$,$ notification$\_$type, notification$\_$message, notification$\_$date, is$\_$read$)$

SELECT

notification$\_$id$,$

'new appointment',

'A new appointment has been scheduled',

NOW$(),$

$0$

FROM

Appointments

LIMIT

$15$;

can you please do this in a json file