This worked
CREATE TABLE builds (
id number(10) default(0) NOT NULL,
product varchar(50) ,
branch varchar(100) ,
type varchar(20) ,
release varchar(20) ,
change_number number(10),
build_date date ,
status varchar(20) default('succeeded'),
saved varchar(1),
build_source varchar(20) default('vmware'),
PRIMARY KEY (id),
CONSTRAINT CC_STATUS CHECK(status in('succeeded','failed')),
CONSTRAINT CC_BUILD_SOURCE CHECK(build_source
in('vmware','community')),
CONSTRAINT CC_SAVED CHECK(saved in ('y','n'))
)
Received on Wed Mar 22 2006 - 17:53:24 CST
