Translations:Manual:Database access/58/en

When writing MySQL table definitions or upgrade patches, it is important to remember that SQLite shares MySQL's schema, but that works only if definitions are written in a specific way:
 * Primary keys must be declared within main table declaration, but normal keys should be added separately with CREATE INDEX: