CREATE TABLE bt_severity_codes ( severity_id integer PRIMARY KEY NOT NULL, project_id integer, severity_name varchar(500) NOT NULL, sort_order integer NOT NULL, default_p char(1) DEFAULT 'f'::bpchar NOT NULL ); CREATE UNIQUE INDEX bt_severity_codes_name_un ON bt_severity_codes (project_id, severity_name); CREATE UNIQUE INDEX bt_severity_codes_sort_order_un ON bt_severity_codes (project_id, sort_order); -- Table size: 8,192 bytes -- Table rows: 24