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
| create table personnes
(
id varchar(3)
, categorie varchar(2)
, col1 int
, col2 int
);
insert into personnes (id, categorie, col1, col2)
select 'A1', 'S1', 6, 4 union all
select 'A1', 'S2', 5, 8 union all
select 'A2', 'S1', 5, 7 union all
select 'A2', 'S2', 4, 9;
create table modification_id
(
id_origine varchar(2)
, id_destination varchar(3)
, categorie_origine varchar(2)
, categorie_destination varchar(2)
, etat int
);
insert into modification_id (id_origine, id_destination, categorie_origine, categorie_destination, etat)
select 'A1', 'AD1', 'S1', 'S2', 0 union all
select 'A2', 'AD2', 'S1', 'S2', 0 union all
select 'A3', 'AD3', 'S1', 'S2', 0 union all
select 'A4', 'AD4', 'S1', 'S2', 1 union all
select 'A5', 'AD5', 'S1', 'S2', 0; |
Partager