rendered paste bodyCREATE TABLE hulpverlening (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, incidentid INT UNSIGNED DEFAULT 0 NOT NULL, sessieid INT UNSIGNED DEFAULT NULL, loos CHAR(1) DEFAULT '0' NOT NULL, politieaanwezig CHAR(1) DEFAULT '0', politiehulp CHAR(1) DEFAULT '0', objecthulpverlening TINYINT UNSIGNED DEFAULT NULL, specgebouw TINYINT UNSIGNED DEFAULT NULL, specgeengebouw TINYINT UNSIGNED DEFAULT NULL, gevaarlijkestoffen CHAR(1) DEFAULT '0', sitwater CHAR(1) DEFAULT '0' NOT NULL, sitbeknelling CHAR(1) DEFAULT '0' NOT NULL, sitinsluiting CHAR(1) DEFAULT '0' NOT NULL, sitbuitensluiting CHAR(1) DEFAULT '0' NOT NULL, sitvervuiling CHAR(1) DEFAULT '0' NOT NULL, sitblokkering CHAR(1) DEFAULT '0' NOT NULL, sitwateroverlast CHAR(1) DEFAULT '0' NOT NULL, sitstormschade CHAR(1) DEFAULT '0' NOT NULL, sitdieren CHAR(1) DEFAULT '0' NOT NULL, sitandere CHAR(1) DEFAULT '0' NOT NULL, sitonbekend CHAR(1) DEFAULT '0' NOT NULL, werkgeen CHAR(1) DEFAULT '0' NOT NULL, werkbevrijden CHAR(1) DEFAULT '0' NOT NULL, werkbergen CHAR(1) DEFAULT '0' NOT NULL, werkreinigen CHAR(1) DEFAULT '0' NOT NULL, werkopenen CHAR(1) DEFAULT '0' NOT NULL, werkbestrwater CHAR(1) DEFAULT '0' NOT NULL, werkbestrstorm CHAR(1) DEFAULT '0' NOT NULL, werkbevrdier CHAR(1) DEFAULT '0' NOT NULL, werkbergenlijk CHAR(1) DEFAULT '0' NOT NULL, werkandere CHAR(1) DEFAULT '0' NOT NULL, werkonbekend CHAR(1) DEFAULT '0' NOT NULL, stof1gi SMALLINT UNSIGNED DEFAULT NULL, stof2gi SMALLINT UNSIGNED DEFAULT NULL, stof1vn SMALLINT UNSIGNED DEFAULT NULL, stof2vn SMALLINT UNSIGNED DEFAULT NULL, stof1hoeveelheid SMALLINT UNSIGNED DEFAULT NULL, stof2hoeveelheid SMALLINT UNSIGNED DEFAULT NULL, milieueffecten CHAR(1) DEFAULT '0', milieueffectief TINYINT UNSIGNED DEFAULT NULL, milieumaatregel TINYINT UNSIGNED DEFAULT NULL, persbetrokken CHAR(1) DEFAULT '0', beknellingbrw TINYINT UNSIGNED DEFAULT NULL, beknellingburger TINYINT UNSIGNED DEFAULT NULL, beknellingaankomst TINYINT UNSIGNED DEFAULT NULL, verdrinkingbrw TINYINT UNSIGNED DEFAULT NULL, verdrinkingburger TINYINT UNSIGNED DEFAULT NULL, verdrinkingaankomst TINYINT UNSIGNED DEFAULT NULL, overlandersbrw TINYINT UNSIGNED DEFAULT NULL, overlandersburger TINYINT UNSIGNED DEFAULT NULL, overlandersaankomst TINYINT UNSIGNED DEFAULT NULL, gewbreukenbrw TINYINT UNSIGNED DEFAULT NULL, gewbreukenanders TINYINT UNSIGNED DEFAULT NULL, gewbreukenaankomst TINYINT UNSIGNED DEFAULT NULL, gewsnijbrw TINYINT UNSIGNED DEFAULT NULL, gewsnijburger TINYINT UNSIGNED DEFAULT NULL, gewsnijaankomst TINYINT UNSIGNED DEFAULT NULL, gewbedwemeldbrw TINYINT UNSIGNED DEFAULT NULL, gewbedwemeldburger TINYINT UNSIGNED DEFAULT NULL, gewbedwemeldaankomst TINYINT UNSIGNED DEFAULT NULL, gewoverigbrw TINYINT UNSIGNED DEFAULT NULL, gewoverigburger TINYINT UNSIGNED DEFAULT NULL, gewoverigaankomst TINYINT UNSIGNED DEFAULT NULL, ongedeerd TINYINT UNSIGNED DEFAULT NULL, geredbrwbrw TINYINT UNSIGNED DEFAULT NULL, geredbrwandere TINYINT UNSIGNED DEFAULT NULL, geredanderebrw TINYINT UNSIGNED DEFAULT NULL, geredandereandere TINYINT UNSIGNED DEFAULT NULL, ehbrwbrw TINYINT UNSIGNED DEFAULT NULL, ehbrwandere TINYINT UNSIGNED DEFAULT NULL, ehambubrw TINYINT UNSIGNED DEFAULT NULL, ehambuandere TINYINT UNSIGNED DEFAULT NULL, ehanderebrw TINYINT UNSIGNED DEFAULT NULL, ehandereandere TINYINT UNSIGNED DEFAULT NULL, tijdaankomstafvoer TINYINT UNSIGNED DEFAULT NULL, tijdincidentmelding TINYINT UNSIGNED DEFAULT NULL, opmerkingen VARCHAR(65532) DEFAULT NULL, gevalideerd CHAR(1) DEFAULT '0' NOT NULL, compleet CHAR(1) DEFAULT '0' NOT NULL, spoedhulpverlening CHAR(1) DEFAULT '0' NOT NULL, melder TINYINT UNSIGNED DEFAULT 88 NOT NULL)