[Task] Start EDAM concept ID from 1 instead of 0

[tschaffter]

What product(s) is this story for?

OpenChallenges

As a user, I want

No response

Description

This is to align with all the other IDs that are generated with AUTO INCREMENT.

References to existing EDAM IDs need to be updated too in input_data_type.csv and challenges.csv (operation_id property).

Depends on #2557

Acceptance criteria

No response

Tasks

No response

Anything else?

No response

Have you linked this story to a GitHub Project?

• [X] I have linked this story to a GitHub Project and set its metadata.

[tschaffter]

The head of the CSV data for input data types:

"id","class_id","preferred_label"
"0","http://edamontology.org/data_0005","Resource type"
"1","http://edamontology.org/data_0006","Data"
"2","http://edamontology.org/data_0007","Tool"

Yet the IDs start with 1 in the SQL table:

UPDATE: I set the value of all the id in the EDAM CSV file to null ("\N") and the table in the DB still has IDs set, so it looks like the IDs specified in the CSV file are overwritten by SQL AUTO_INCREMENT.

[tschaffter]

This ticket will be addressed by #2564

[vpchung]

References to existing EDAM IDs need to be updated too in input_data_type.csv and challenges.csv (operation_id property).

This is already addressed in the OC data sheet.