> David,
>
> > active NUMERIC(1,0) NOT NULL
> > DEFAULT 1
> > CONSTRAINT ck_sd_tile__active
> > CHECK (active IN (0,1)),
>
> Why is this field NUMERIC if it only accepts 0 or 1? NUMERIC takes
> up seven times the storage and memory as INT2 would.
Or for that matter, use BOOL and save another byte as BOOL is only one
byte on disk. -sc
--
Sean Chittenden