SQLite Forum

oh right..my sqlite3 version is this: SQLite version 3.32.2

and as far as I know, sqlite does know boolean as datatype so i used boolean when i created the table.

CREATE TABLE IF NOT EXISTS Pruefung
(
	PruefungsID					int			not null primary key check(PruefungsID > 0) ,
	Theorie						boolean		not null,
	Gebuehr						float 		not null check(Gebuehr > 0 and round(Gebuehr, 2) = Gebuehr),
	Bestanden					boolean		not null,
	Email						varchar[50]	not null collate nocase,
	
	foreign key(Email) references Schueler(Email) on update cascade on delete cascade
);