SQLite DDL Generation: missing NOT NULL

[bw1d670c]

Hi,

I am trying to generate SQLite DDL statements from my logical table model in Enterprise Architect 9.3. Everything works so far, except the NOT NULL checkboxes in the column properties do not seem to be considered, so no column has NOT NULL constraints. However, if I change the database type of the table to something other like Oracle or MySQL, the according NOT NULL statements appear in the generated SQL DDL code. Is this desired behaviour for SQLite, or is this a bug? (Or am I doing it completely wrong, or is it because I only have the trial version? ;-))

On a completely unrelated note, is it possible for the user to have any control over the DDL generation, like the template mechanism which is used for the generation of program code? I could not find any such templates which would be used for the DDL generation, so I'm guessing this process is somehow hard-coded for the different SQL dialects.

[hd]

http://www.sparxsystems.com/support/bug_report.html