use allskreen;
delete from
    languages;
delete from
    authors_type;
delete from
    genre;
ALTER TABLE
    languages AUTO_INCREMENT = 1;
ALTER TABLE
    authors_type AUTO_INCREMENT = 1;
ALTER TABLE
    genre AUTO_INCREMENT = 1;
    /* Table Languages */
insert into
    languages (shortlabel, longlabel)
values
    ('fr', 'Français');
insert into
    languages (shortlabel, longlabel)
values
    ('en', 'English');
    /* Table Authors_Type */
insert into
    authors_type (label)
values
    ('Scénario');
insert into
    authors_type (label)
values
    ('Dessin');
insert into
    authors_type (label)
values
    ('Couleur');
insert into
    authors_type (label)
values
    ('Storyboard');
insert into
    authors_type (label)
values
    ('Illustration');
insert into
    authors_type (label)
values
    ('Encrage');
insert into
    authors_type (label)
values
    ('Dialogues');
insert into
    authors_type (label)
values
    ('Dessin et Scénario');
insert into
    authors_type (label)
values
    ('Scénario et Storyboard');
insert into
    authors_type (label)
values
    ('Dessin et Storyboard');
    /* table Genre*/
insert into
    genre (label)
values('Manga');
insert into
    genre (label)
values('Comics');
insert into
    genre (label)
values('BD');
insert into
    genre (label)
values('Science-Fiction');
insert into
    genre (label)
values('Fantastique');
insert into
    genre (label)
values('Horreur');
insert into
    genre (label)
values('Suspense');
insert into
    genre (label)
values('Historique');
insert into
    genre (label)
values('Romantique');
insert into
    genre (label)
values('Anticipation');
insert into
    genre (label)
values('Biographique');
insert into
    genre (label)
values('Thriller');
insert into
    genre (label)
values('Reportage');
insert into
    genre (label)
values('Humour');
insert into
    genre (label)
values('Action');
insert into
    genre (label)
values('Aventure');
insert into
    genre (label)
values('Heroic Fantasy');
insert into
    genre (label)
values('Érotique');
insert into
    genre (label)
values('Réaliste');
insert into
    genre (label)
values('Drame');
insert into
    genre (label)
values('Pirates');
insert into
    genre (label)
values('Péplum');
insert into
    genre (label)
values('Guerre');
insert into
    genre (label)
values('Policier');
insert into
    genre (label)
values('Commercial');
insert into
    genre (label)
values('Anthropomorphique');
insert into
    genre (label)
values('Espionnage');
insert into
    genre (label)
values('Intimiste');
insert into
    genre (label)
values('Super-héros');
insert into
    genre (label)
values('Western');
insert into
    genre (label)
values('Futuriste');
insert into
    genre (label)
values('Cartoon');
insert into
    genre (label)
values('Politique');
insert into
    genre (label)
values('Combat');
insert into
    genre (label)
values('Road-Movie');
insert into
    genre (label)
values('Burlesque');
insert into
    genre (label)
values('Shonen');
insert into
    genre (label)
values('Huis-clos');
insert into
    genre (label)
values('Catastrophe');
insert into
    genre (label)
values('Blog');
insert into
    genre (label)
values('Moyen-Âge');
insert into
    genre (label)
values('Arthurien');
insert into
    genre (label)
values('Contemporain');