chore(sql): align column data types and length

related to CAM-1908
feat(cycle/sql): use custom sql scripts for cycle

- move sql script generation into own profile
- add constant sql scripts
- change generated FKs to custom ones

related to CAM-1782