In-build SQL

['LinKin]

Hello,

Can I declare Primary keys, Foreign keys with the SQL used by MTA? (executeSQLQuery)

[Addlibs]

MTA's executeSQLQuery uses SQLite, I assume anything possible with SQLite is also possible with executeSQLQuery. However, as far as I know, the only primary key in MTA is predefined, 'rowid'.

[JR10]

First of all, do not use executeSQLQuery, it lacks support for callbacks and hangs the whole server till the data is selected. Use the newer db* functions.

Primary and foreign keys should work just fine.