TEST
ppl2altlogin UNIQUE ppl_id

Index: kldv-create.sql
===================================================================
--- kldv-create.sql	(revision 1341)
+++ kldv-create.sql	(working copy)
@@ -1,30 +1,30 @@
 
 CREATE TABLE ppl (
 	ppl_id INTEGER PRIMARY KEY AUTO_INCREMENT,
-	ppl_login VARCHAR(32), -- leerlingnummer of afkorting htmlencoded
-	ppl_forename VARCHAR(64), -- html encoded
-	ppl_prefix VARCHAR(16), -- html encoded
-	ppl_surname VARCHAR(128), -- html encoded
+	ppl_login VARCHAR(32) NOT NULL, -- leerlingnummer of afkorting htmlencoded
+	ppl_forename VARCHAR(64) NOT NULL, -- html encoded
+	ppl_prefix VARCHAR(16) NOT NULL, -- html encoded
+	ppl_surname VARCHAR(128) NOT NULL, -- html encoded
 	ppl_active INTEGER DEFAULT 0, -- 0 means active and NULL means inactive 
 	UNIQUE ( ppl_login, ppl_active ) -- only one ppl_login may be active at any given time
 );
 
 CREATE TABLE grp (
 	grp_id INTEGER PRIMARY KEY AUTO_INCREMENT,
-	grp_name VARCHAR(32), -- html encoded
+	grp_name VARCHAR(32) NOT NULL, -- html encoded
 	grp_home INTEGER, -- boolean, 1: 'stamklas', 0: 'cluster',
 	UNIQUE ( grp_name )
 );
 
 CREATE TABLE subj (
 	subj_id INTEGER PRIMARY KEY AUTO_INCREMENT,
-	subj_abbrev VARCHAR(8), -- html encoded
+	subj_abbrev VARCHAR(8) NOT NULL, -- html encoded
 	UNIQUE ( subj_abbrev )
 );
 
 CREATE TABLE years (
 	year_id INTEGER PRIMARY KEY AUTO_INCREMENT,
-	year_long VARCHAR(9),
+	year_long VARCHAR(9) NOT NULL,
 	UNIQUE (year_long)
 );