DROP TABLE trainings_general;

CREATE TABLE trainings_general(
	badge		number(10)		not null,
	extinguisher	varchar2(100)		null,
	rescue_equip	varchar2(100)		null,
	small_gear	varchar2(100)		null,
	foam		varchar2(100)		null,
	lines		varchar2(100)		null,
	decontamination	varchar2(100)		null,
	ppc		varchar2(100)		null,
	first_aid	varchar2(100)		null,
	rescue_methods	varchar2(100)		null,
	comms		varchar2(100)		null,
	CONSTRAINT cons_tgbadge 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;