DROP TABLE IF EXISTS flash_cartes;

CREATE TABLE flash_cartes (
    id		SERIAL PRIMARY KEY,
    recto	VARCHAR(64),
    verso	VARCHAR(64),
    good	INTEGER DEFAULT 0,
    bad		INTEGER DEFAULT 0,
    score	INTEGER DEFAULT 0,
    delta	INTEGER DEFAULT 1,
    learn	INTEGER DEFAULT 1);

INSERT INTO flash_cartes(recto,verso)
    VALUES  ('door','porte'),
	    ('window','fenêtre'),
	    ('table','table'),
	    ('cat','chat'),
	    ('dog','chien'),
	    ('mouse','souris'),
	    ('pig','cochon'),
	    ('red','rouge'),
	    ('green','vert'),
	    ('blue','bleu'),
	    ('white','blanc'),
	    ('yellow','jaune'),
	    ('black','noir'),
	    ('computer','ordinateur'),
	    ('keyboard','clavier'),
	    ('memory','mémoire'),
	    ('magnet','aimant'),
	    ('book','livre'),
	    ('pen','stylo'),
	    ('pencil','crayon'),
	    ('printer','imprimante'),
	    ('file','fichier'),
	    ('browser','navigateur'),
	    ('word','mot'),
	    ('card','carte'),
	    ('compiler','compilateur'),
	    ('mirror','miroir'),
	    ('coin','pièce de monnaie'),
	    ('digit','chiffre'),
	    ('music','musique'),
	    ('display','affichage'),
	    ('letter','lettre'),
	    ('tree','arbre'),
	    ('leaf','feuille');
