also:

DORD VARCHAR (1) NOT NULL

I can't think of any reason to have a varchar(1) rather than a char(1)


--
Nick
-----We Solve your Computer Problems---
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: 22 November 2005 11:38
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Primary Key Size Error

> CREATE TABLE ispFmt10 (RCA SMALLINT DEFAULT 1 NOT NULL,DORD VARCHAR
> (1) NOT NULL,DNME VARCHAR(100),MMOD VARCHAR(50) NOT NULL,MODL VARCHAR
> (50) NOT NULL,SMOD VARCHAR(50) NOT NULL,CurrOpt VARCHAR(1) NOT
> NULL,DTYP VARCHAR(3) NOT NULL,SID INTEGER DEFAULT 0 NOT NULL,SNODE
> VARCHAR(50),FL1 VARCHAR(50),FLDFR VARCHAR(50),MDBN VARCHAR(50),LnkMdb
> VARCHAR(50),LKT VARCHAR(50) PRIMARY KEY
> (RCA,DORD,MODL,MMOD,SMOD,DTYP,SID))

[Non-text portions of this message have been removed]