[wp-trac] [WordPress Trac] #16698: Better Table field value upgrade check (minor)

[WordPress Trac]

#16698: Better Table field value upgrade check (minor)
-------------------------------------------+------------------------------
 Reporter:  cogmios                        |       Owner:
     Type:  enhancement                    |      Status:  new
 Priority:  normal                         |   Milestone:  Awaiting Review
Component:  Warnings/Notices               |     Version:  3.1
 Severity:  minor                          |  Resolution:
 Keywords:  needs-patch reporter-feedback  |
-------------------------------------------+------------------------------
Changes (by cogmios):

 * cc: deleau@… (added)


Comment:

 this should trigger it:
 {{{
 $sql = "CREATE TABLE $table_name_1 (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  urivarchar(2048) COLLATE utf8_unicode_ci NOT NULL,
  favicon varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  filters varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  content varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  defaulticon tinyint(1) NOT NULL,
  comment varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  icon_parent_id bigint(20) NOT NULL,
  itime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY  (id)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";
 }}}

 :) (no space before varchar, which is a mistake but the error message is
 confusing)

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