| Oh it's even worse: https://developer.wordpress.org/plugins/creating-tables-with... >Rather than executing an SQL query directly, we’ll use the dbDelta function >Note that the dbDelta function is rather picky, however. For instance: >You must put each field on its own line in your SQL statement. >You must have two spaces between the words PRIMARY KEY and the definition of your primary key. >You must use the key word KEY rather than its synonym INDEX and you must include at least one KEY. >KEY must be followed by a SINGLE SPACE then the key name then a space then open parenthesis with the field name then a closed parenthesis. >You must not use any apostrophes or backticks around field names. >Field types must be all lowercase. >SQL keywords, like CREATE TABLE and UPDATE, must be uppercase. >You must specify the length of all fields that accept a length parameter. int(11), for example. |