SQL Script - Course Manager Data

course_manager_data.sql

-- INSERT DATA

INSERT INTO `course` (`id`, `title`)
VALUES
	(1,'Cooking for Fun'),
	(2,'Arduin and Automation'),
	(3,'Education for Life'),
	(4,'Modern PHP Definitive Guide');

INSERT INTO `course_application`
(`id`, `id_user`, `id_course`, `application_date`)
VALUES
	(1,1,2,'2020-09-24 17:44:36'),
	(2,1,3,'2020-09-24 16:34:32'),
	(3,2,3,'2020-09-24 18:14:06');

INSERT INTO `user` (`id`, `email`, `name`)
VALUES
	(1,'edward@foo.com','Edward'),
	(2,'john@foo.com','John'),
	(3,'Clair','cliar@foo.com'),
	(4,'Margareth','margot@foo.com');