
CREATE TABLE workshops (
	workshop_id INTEGER PRIMARY KEY AUTO_INCREMENT,
	workshop_name VARCHAR(128),
	workshop_limit INTEGER
);

INSERT INTO workshops ( workshop_name, workshop_limit ) VALUES
	( 'Science', 150 ),
	( 'Sport', 150 ),
	( 'Kunst', 150 ),
	( 'Cambridge Engels', 150 ),
	( 'Mens &amp; Maatschappij', 50 );

CREATE TABLE basisscholen (
	basisschool_id INTEGER PRIMARY KEY AUTO_INCREMENT,
	basisschool_name VARCHAR(128)
);

INSERT INTO basisscholen ( basisschool_name ) VALUES
	( '<i>Mijn basisschool staat er niet bij!?!?</i' ),
	( 'Achtbaan' ),
	( 'Al Iman' ),
	( 'Albatros' ),
	( 'Archipel' ),
	( 'Architect' ),
	( 'Argonaut (voorheen Waterhoek en &#39;t Kofschip) Dalton' ),
	( 'Aurora' ),
	( 'Avontuur' ),
	( 'Bombardon' ),
	( 'Bommelstein (Dalton)' ),
	( 'Bongerd' ),
	( 'Boventoon' ),
	( 'Buitenburcht' ),
	( 'Caleidoscoop' ),
	( 'Columbus (NEO)' ),
	( 'Compositie' ),
	( 'Digitalis (stream Jenaplan)' ),
	( 'Drieluik' ),
	( 'Dubbeldekker' ),
	( 'Duizendpoot' ),
	( 'Dukdalf' ),
	( 'Eerste Almeerse Montessori school' ),
	( 'Egelantier' ),
	( 'Egelantier' ),
	( 'Europaschool' ),
	( 'Evangelische Basisschool De Oase' ),
	( 'Flierefluiter (NEO)' ),
	( 'Goede Herder' ),
	( 'Hasselbraam' ),
	( 'Heliotroop' ),
	( 'Ichthus' ),
	( 'Kameleon' ),
	( 'KBS Crescendo' ),
	( 'KBS De Droomspiegel' ),
	( 'Klaverweide' ),
	( 'Kompas' ),
	( 'Kraanvogel' ),
	( 'Kring (Jenaplan en NEO)' ),
	( 'Kristal' ),
	( 'Letterland' ),
	( 'Lettertuin' ),
	( 'Lichtboei' ),
	( 'Manse' ),
	( 'Meesterwerk' ),
	( 'Montessorischool Almere Stad' ),
	( 'Montessorischool Buiten ' ),
	( 'Montessorischool De Poort' ),
	( 'Montessorischool Muziekwijk ' ),
	( 'Olijfboom' ),
	( 'Omnibus' ),
	( 'Ontdekking (Dalton en NEO)' ),
	( 'Optimist' ),
	( 'Palet' ),
	( 'Panta Rhei' ),
	( 'Piramide' ),
	( 'Pirouette' ),
	( 'Polderhof' ),
	( 'Polygoon' ),
	( 'Regenboog' ),
	( 'Samenspel (voorheen Flevoschool)' ),
	( 'Samenspel (voorheen Waterlandschool)' ),
	( 'Spectrum' ),
	( 'Syncope' ),
	( 'Taalcentrum PO' ),
	( 'Taalcentrum PO Almere' ),
	( 'Tjasker' ),
	( 'Torteltuin' ),
	( 'Vedelaar' ),
	( 'Waterspiegel' ),
	( 'Watertuin' ),
	( 'Wierwinde' ),
	( 'Zeetuin' ),
	( 'Zevensprong' ),
	( 'Zonnewiel' );

CREATE TABLE inschrijvingen (
	inschrijving_id INTEGER PRIMARY KEY AUTO_INCREMENT,
	naam0 VARCHAR(128),
	naam1 VARCHAR(64),
	naam2 VARCHAR(16),
	basisschool_id INTEGER NOT NULL,
	workshop_id INTEGER NOT NULL,
	phpsessid VARCHAR(32),
	timestamp_create INTEGER,
	timestamp_delete INTEGER
);
