Creation d'un CRUD dans api-genesis¶
Migration depuis nextgen¶
On récupère le script SQL de création de la table voulue
create table link_mdr_lines_contracts_lines
(
id int auto_increment primary key,
id_contract_line int not null,
id_mdr_line int not null,
is_active tinyint(1) default 0 null,
created_at datetime default current_timestamp() null,
updated_at datetime null on update current_timestamp(),
constraint fk_contractsLines_on_linkBdrLinesContractsLines_idContractLine
foreign key (id_contract_line) references contracts_lines (id)
)
engine = InnoDB
collate = utf8mb3_uca1400_ai_ci;