question: what’s the best way to create a column like this using prisma models?:

CREATE TABLE color (
    color_id INT GENERATED BY DEFAULT AS IDENTITY 
    (START WITH 10 INCREMENT BY 10), // <- this column
    color_name VARCHAR NOT NULL
);

Hey Chris 👋 That’s true, you would need to manually update the migration file, you would need to use

--create-only

flag to just create the migration file and then update it as mentioned in the comment, and there should be no issue in keeping INT.