-- we don't know how to generate root <with-no-name> (class Root) :(
create table PIT_COMMENT
(
	ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_F08A3C00_FD23_4A69_B5EC_A65E71BDAA06) auto_increment
		primary key,
	COMMENT VARCHAR(2000) not null,
	TEAM_NUMBER INTEGER not null,
	TIMESTAMP TIMESTAMP(26,6) not null
);

create table PIT_PICTURE
(
	ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_B1A1A664_1B88_4915_B704_B17861D23518) auto_increment
		primary key,
	PICTURE VARCHAR(2000) not null,
	TEAM_NUMBER INTEGER not null,
	TIMESTAMP TIMESTAMP(26,6) not null
);

create table SCOUTING_FORM
(
	ID BIGINT default (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_A90377FB_2364_49D3_ABF9_367643638CAB) auto_increment
		primary key,
	CROSS_HABITAT_LINE BOOLEAN not null,
	MATCH_NUMBER INTEGER not null,
	SANDSTORM_CARGO_BALL_COUNT INTEGER not null,
	SANDSTORM_CARGO_HATCH_PANEL_COUNT INTEGER not null,
	SANDSTORM_ROCKET_BALL_COUNT INTEGER not null,
	SANDSTORM_ROCKET_HATCH_PANEL_COUNT INTEGER not null,
	TEAM_NUMBER INTEGER not null
);

create table TEAM
(
	TEAM_NUMBER INTEGER not null
		primary key,
	TEAM_NAME VARCHAR(255) not null
);