DROP TABLE trainings_pump;

CREATE TABLE trainings_pump(
	badge		number(10)		not null,
	hydrant		varchar2(100)		null,
	open_source	varchar2(100)		null,
	portable_pump	varchar2(100)		null,
	water_relay	varchar2(100)		null,
	CONSTRAINT cons_tpbadge PRIMARY KEY (badge) USING INDEX TABLESPACE INDX
)
TABLESPACE USERS
PCTFREE 10
PCTUSED 70
STORAGE (INITIAL 16K NEXT 16K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) NOLOGGING;

COMMIT;