[prev in list] [next in list] [prev in thread] [next in thread] 

List:       rt-devel
Subject:    [rt-devel] MySQL tables problem
From:       "Ben Carter (Lists)" <ben-lists () aoncue ! net>
Date:       2001-02-23 15:47:55
[Download RAW message or body]

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




[prev in list] [next in list] [prev in thread] [next in thread]