DROP TABLE roster_duties;

CREATE TABLE roster_duties(
	duty_no		number(20)		not null,
	kitchen		varchar2(20)		null,
	rec_room	varchar2(20)		null,
	house		varchar2(20)		null,
	appliances	varchar2(20)		null,
	engine_rm	varchar2(20)		null,
	other		varchar2(20)		NULL,		
	CONSTRAINT con_duties_no PRIMARY KEY (duty_no) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;