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: {| class="wikitable" ! Wrong !! Right  CREATE TABLE /*_*/foo (   foo_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,    foo_text VARCHAR(256) ) /*$wgDBTableOptions*/;
 * Primary keys must be declared within main table declaration, but normal keys should be added separately with CREATE INDEX: