Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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;