-- Add new table for allocation notices CREATE TABLE blocknotices ( alloc_id integer NOT NULL, ipflag boolean NOT NULL DEFAULT 'n', notice text NOT NULL DEFAULT '', PRIMARY KEY (alloc_id, ipflag) );