CREATE TABLE `memberlist` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`BodyCode` VARCHAR( 3 ) NOT NULL ,
`GivenName` VARCHAR( 50 ) NOT NULL ,
`Surname` VARCHAR( 50 ) NOT NULL ,
`CSN` VARCHAR( 13 ) NOT NULL ,
`DateBirth` DATE NOT NULL ,
`MemberSince` DATE NOT NULL
) ENGINE = MYISAM ;

INSERT INTO `setup` (`id`, `category`, `Name`, `Value`, `RegEx`, `Explanation`, `ac_view`, `ac_edit`, `ac_audit`, `ac_jc`, `ac_registration`, `ac_localorg`, `ac_chair`, `default`, `empty`) VALUES
(236, 'admin', 'UploadMembersList', '', '[bool]', 'Should it be possible to upload members lists? If not, it will be possible to fill in the number of members by hand.', 'no', 'no', 'view', 'view', 'no', 'view', 'view', '', 'no');

