[support] Failed Upgrade to 6.16

[Earnie Boyd]

Lanny Trager wrote:
>  Jim,
>
>  I've run update several times with all but the core modules disabled
>  no luck.
>
>  Ernie,
>
>  Ran drush sqlq CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL
>   DEFAULT '', `value` VARCHAR(255) NOT NULL DEFAULT '', `expire`
>  DOUBLE NOT NULL, PRIMARY KEY (name), INDEX expire (expire) ) /*!40100
>  DEFAULT CHARACTER SET UTF8 */

I've never used drush but this can be done easily in your SQL client.

$ mysql -u root -p
mysql> use mydb
mysql> CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL
mysql> DEFAULT '', `value` VARCHAR(255) NOT NULL DEFAULT '', `expire`
mysql> DOUBLE NOT NULL, PRIMARY KEY (name), INDEX expire (expire) ) /*!40100
mysql> DEFAULT CHARACTER SET UTF8 */;

You can also put the DB command in a sql script, say myscript.sql for 
example, and then source the script into your sql client.

-- 
Earnie
-- http://www.for-my-kids.com