PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; INSERT INTO ELEMENT VALUES(1,'renault, rouge, 2000'); INSERT INTO ELEMENT VALUES(2,'renault, bleu, 2000'); INSERT INTO ELEMENT VALUES(3,'renault, 2000'); INSERT INTO ELEMENT VALUES(4,'peugeot, 2000'); INSERT INTO LABEL VALUES(1,'annee',NULL); INSERT INTO LABEL VALUES(2,'2000',1); INSERT INTO LABEL VALUES(3,'2017',1); INSERT INTO LABEL VALUES(4,'marque',NULL); INSERT INTO LABEL VALUES(5,'renault',4); INSERT INTO LABEL VALUES(6,'peugeot',4); INSERT INTO LABEL VALUES(7,'couleur',NULL); INSERT INTO LABEL VALUES(8,'rouge',7); INSERT INTO LABEL VALUES(9,'bleu',7); INSERT INTO ALIAS VALUES('millesime',1); INSERT INTO ALIAS VALUES('le nouveau millenaire',2); INSERT INTO ALIAS VALUES('y a pas longtemps',3); INSERT INTO ELEMENT_LABEL VALUES(1,1); INSERT INTO ELEMENT_LABEL VALUES(1,2); INSERT INTO ELEMENT_LABEL VALUES(1,4); INSERT INTO ELEMENT_LABEL VALUES(1,5); INSERT INTO ELEMENT_LABEL VALUES(1,7); INSERT INTO ELEMENT_LABEL VALUES(1,8); INSERT INTO ELEMENT_LABEL VALUES(2,1); INSERT INTO ELEMENT_LABEL VALUES(2,2); INSERT INTO ELEMENT_LABEL VALUES(2,4); INSERT INTO ELEMENT_LABEL VALUES(2,5); INSERT INTO ELEMENT_LABEL VALUES(2,7); INSERT INTO ELEMENT_LABEL VALUES(2,9); INSERT INTO ELEMENT_LABEL VALUES(3,1); INSERT INTO ELEMENT_LABEL VALUES(3,2); INSERT INTO ELEMENT_LABEL VALUES(3,4); INSERT INTO ELEMENT_LABEL VALUES(3,5); INSERT INTO ELEMENT_LABEL VALUES(4,1); INSERT INTO ELEMENT_LABEL VALUES(4,2); INSERT INTO ELEMENT_LABEL VALUES(4,4); INSERT INTO ELEMENT_LABEL VALUES(4,6); COMMIT;