On one of my systems

CREATE TABLE semaphore (
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) NOT NULL DEFAULT '',
  expire double NOT NULL,
  PRIMARY KEY (`name`),
  KEY expire (expire)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



On Sun, Mar 14, 2010 at 8:06 PM, Lanny Trager <lanny@cybernex.net> wrote:
Michel,

Maybe I've been at this too long today.  The following is what I'm running:

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) )

It returns, the following:

-bash: syntax error near unexpected token `('

I'm just not seeing the error of my ways.

Thanks


--
[ Drupal support list | http://lists.drupal.org/ ]



--
Rev. Jim Tarvid, PCA
http://ls.net
http://drupal.ls.net
http://crossleft.org