DROP TABLE IF EXISTS festivaldb.festival;
DROP SCHEMA IF EXISTS festivaldb;

CREATE SCHEMA IF NOT EXISTS festivaldb;
CREATE TABLE IF NOT EXISTS festivaldb.festival (
	festivalId int PRIMARY KEY auto_increment,
    name varchar(100) NOT NULL,
    location varchar(100) NOT NULL,
    startDate date NOT NULL,
    endDate date NOT NULL,
    province varchar(100) NOT NULL,
    comment varchar(250)
);

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Tomorrowland', 'Boom', '2024-07-16', '2024-07-18', 'Antwerp');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Rock Werchter', 'Werchter', '2024-06-30', '2024-07-03', 'Flemish Brabant');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Pukkelpop', 'Hasselt', '2024-08-19', '2024-08-22', 'Limburg');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Gentse Feesten', 'Ghent', '2024-07-15', '2024-07-24', 'East Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Dour Festival', 'Dour', '2024-07-14', '2024-07-18', 'Hainaut');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Couleur Café', 'Brussels', '2024-06-25', '2024-06-27', 'Brussels');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Graspop Metal Meeting', 'Dessel', '2024-06-17', '2024-06-20', 'Antwerp');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Les Ardentes', 'Liège', '2024-07-08', '2024-07-11', 'Liège');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Ronquières Festival', 'Ronquières', '2024-08-06', '2024-08-07', 'Hainaut');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Cactusfestival', 'Bruges', '2024-07-09', '2024-07-11', 'West Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Cirque Magique', 'Ledegem', '2024-08-06', '2024-08-08', 'West Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Plein Air', 'Houffalize', '2024-07-30', '2024-08-01', 'Luxembourg');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Laundry Day', 'Antwerp', '2024-09-02', '2024-09-02', 'Antwerp');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('I Love Techno Europe', 'Mont-de-l''Enclus', '2024-09-10', '2024-09-12', 'Hainaut');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Gent Jazz Festival', 'Ghent', '2024-07-08', '2024-07-17', 'East Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Couleur Locale', 'Namur', '2024-08-27', '2024-08-29', 'Namur');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Suikerrock', 'Tienen', '2024-07-30', '2024-08-01', 'Flemish Brabant');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Klinkers', 'Bruges', '2024-08-01', '2024-08-10', 'West Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Les Transardentes', 'Liège', '2024-12-28', '2024-12-28', 'Liège');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Leffingeleuren', 'Leffinge', '2024-09-13', '2024-09-15', 'West Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Lokerse Feesten', 'Lokeren', '2024-07-31', '2024-08-09', 'East Flanders');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Les Nuits Botanique', 'Brussels', '2024-05-06', '2024-05-18', 'Brussels');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Reverze', 'Antwerp', '2024-02-23', '2024-02-24', 'Antwerp');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Meadows Festival', 'Brussels', '2024-08-30', '2024-09-01', 'Brussels');

INSERT INTO festivaldb.festival (name, location, startDate, endDate, province)
VALUES ('Deep in the Woods', 'Heer-Sur-Meuse', '2024-09-21', '2024-09-23', 'Namur');
