Postgres - soduko/schedulemaker GitHub Wiki
Resources:
- https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL
- https://wiki.postgresql.org/wiki/Things_to_find_out_about_when_moving_from_MySQL_to_PostgreSQL
For UNSIGNED either use CHECK in db or remember to check input from front end. (using check in db) Is there a use for the specific constraint names or can I let pg assign anything?
What I changed in the .sql files:-
MySQL -> Postgres
INT AUTO_INCREMENT -> SERIAL
TINYINT -> SMALLINT