Postgresql Table Definition

Tested in postgresql 8.1.

CREATE TABLE taxonomy_block (
  description text NOT NULL default '',
  teaser integer NOT NULL default 0,
  name text NOT NULL default '',
  length integer NOT NULL default 1,
  bid serial NOT NULL ,
  type text check (type in ('vocabulary'::text,'term'::text)) default 'vocabulary',
  tid integer NOT NULL default 0,
  PRIMARY KEY  (bid)
);