[wp-trac] [WordPress Trac] #12773: dbDelta fails to create multiple tables with IF NOT EXISTS

[WordPress Trac]

#12773: dbDelta fails to create multiple tables with IF NOT EXISTS
-----------------------------------------+----------------------------------
 Reporter:  scibuff                      |        Owner:            
     Type:  defect (bug)                 |       Status:  closed    
 Priority:  normal                       |    Milestone:            
Component:  General                      |      Version:  2.9.2     
 Severity:  normal                       |   Resolution:  worksforme
 Keywords:  dbDelta, wpdb, create table  |  
-----------------------------------------+----------------------------------
Changes (by nacin):

  * status:  new => closed
  * resolution:  => worksforme
  * milestone:  Unassigned =>


Comment:

 dbDelta takes a standard CREATE TABLE definition and compares it with the
 schema.

 If the table, field, or index doesn't exist, it adds it, or the reverse,
 if a field or index is removed, it removes it.

 Additionally, the table definition must be written to very careful
 specifications (consult wp-admin/includes/schema.php's table definitions
 as an example) for dbDelta to work completely.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/12773#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software