Yes, we want to use the same script.
initially we had different scripts, but the maintenance was very cumbersome.
Now, we use one script for each database-system for creating the domains. And one script for the whole database on all server.
ALTER TABLE the_table_name ADD CONSTRAINT foreign_key_constraintname
FOREIGN KEY (id)
REFERENCES other_table (other_id)
ON DELETE RESTRICT
ON UPDATE RESTRICT;
ON DELETE NO ACTION
ON UPDATE NO ACTION;
The simplest way is, don't create the last two lines, if no action is desired.
This has been improved internally. Next Data Modeler release will have both "No action" and "Restrict" options, and Postgres and SQLite (the only two supported databases that differentiate both options) will behave accordingly.
Fine, thank you all.