Hi,

I’m running 4.1.10. I will try to add this table manually.

Boon

Building Towards A Better Tomorrow Together

You Ask Me To Fight For You, I Give You Freedom & Protection And Then You Question The Manner In Which I Provide It, I'd Rather You Just Said -- "Thank You" --

_____

From: Mart...@mysql.com [mailto:Mart...@mysql.com] Sent: Tuesday, April 12, 2005 5:05 PM To: WB Ng Cc: mik...@mysql.com; clus...@lists.mysql.com Subject: Re: Error when batch creating new tables for engine=ndbcluster

I had no problem creating this table separately (on 5.0, but nothing has changed here compared to 4.0).

What release are you using, and have you verified by trying to define this table separately?

BR -- Martin

wb...@dynacraft.com wrote:

Hi,

This is my schema for the said table. I do have the primary key. Pls advice.

CREATE TABLE prate_section_user ( cat_n tinyint(2) unsigned NOT NULL auto_increment, category_c varchar(30) default '0', supp_code_c varchar(10) NOT NULL default '', supp_alt_name_c varchar(35) default NULL, sec1_user_c varchar(6) default '0', sec1_user_name_c varchar(50) default NULL, sec2_user_c varchar(6) default '0', sec2_user_name_c varchar(50) default NULL, sec3_user_c varchar(6) default '0', sec3_user_name_c varchar(50) default NULL, sec4_user_c varchar(6) default '0', sec4_user_name_c varchar(50) default NULL, end_user_mgr_c varchar(6) default NULL, end_user_mgr_name_c varchar(50) default NULL, signature_flag_c char(1) default NULL, rpt_type_e enum('A','B') NOT NULL default 'A', delete_c char(1) default NULL, PRIMARY KEY dept_name_c (cat_n) ) engine=ndbcluster COMMENT='eSupp Performance Rating - commodity configuration.';

Boon Building Towards A Better Tomorrow Together You Ask Me To Fight For You, I Give You Freedom & Protection And Then You Question The Manner In Which I Provide It, I'd Rather You Just Said -- "Thank You" --