Subject | Re: [firebird-support] Re: FB 1.5 to 2.1 question |
---|---|
Author | Helen Borrie |
Post date | 2008-09-12T21:23:54Z |
At 02:59 13/09/2008, you wrote:
./heLen
>As for primary keys...my table create is:Yes and Yes.
>
>
>/* Table: OWNERS */
>CREATE TABLE OWNERS (
> OWNERNAME VARCHAR(50),
> NOTES BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
> UNIQUEKEY VARCHAR(20) NOT NULL,
> CREATEDATE VARCHAR(10),
> EDITDATE VARCHAR(10),
>(etc)
> RECPOSTEDBY VARCHAR(20),
> CONSTRAINT PK_OWNERS PRIMARY KEY (UNIQUEKEY)
>);
>
>CREATE INDEX AK_OWNERSOWNER ON OWNERS(OWNERNAME);
>
>
>Is this valid and proper for FB2.1? Is this what you meant
>by "putting a primary key on the table"?
./heLen