[rt-devel] MySQL tables problem

[Ben Carter (Lists)]

Hi all,

anyone help with the following error.

Should the Keyword column be NOT NULL??

Ben.



Creating database schema.
CREATE TABLE KeywordSelects (
  id INTEGER NOT NULL  AUTO_INCREMENT,
  Name varchar(255) NULL  ,
  Keyword integer NULL  ,
  Single integer NULL  ,
  Depth integer NOT NULL DEFAULT 0 ,
  ObjectType varchar(32) NOT NULL  ,
  ObjectField varchar(32) NULL  ,
  ObjectValue varchar(255) NULL  ,
  Disabled TINYINT NOT NULL DEFAULT 0 ,
  PRIMARY KEY (id),
  INDEX (Keyword),
  INDEX (ObjectType, ObjectField, ObjectValue)
)
DBD::mysql::st execute failed: Column 'Keyword' is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 69, <STDIN> line 2.
Column 'Keyword' is used with UNIQUE or INDEX but is not defined as NOT NULL
at tools/initdb line 69, <STDIN> line 2.
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect(), <STDIN> line 2.
make: *** [database] Error 255