science-ation/db/db.update.227.sql

6 lines
422 B
SQL

ALTER TABLE `users`
ADD `dateofbirth` DATE NOT NULL DEFAULT '0000-00-00' COMMENT 'student',
ADD `foodreq` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'student',
ADD `tshirt` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'student',
ADD `medicalalert` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'student';