im trying to convert this table for a friend
1CREATE TABLE adminmessage (2adminmessageidINT UNSIGNEDNOT NULL AUTO_INCREMENT,3varnamevarchar(250)NOT NULLDEFAULT'',4dismissableSMALLINT UNSIGNEDNOT NULLDEFAULT'0',5scriptvarchar(50)NOT NULLDEFAULT'',6actionvarchar(20)NOT NULLDEFAULT'',7execurl mediumtextNOT NULL,8method enum('get','post')NOT NULLDEFAULT'post',9datelineINT UNSIGNEDNOT NULLDEFAULT'0',10status enum('undone','done','dismissed')NOT NULLdefault'undone',11statususeridINT UNSIGNEDNOT NULLDEFAULT'0',12PRIMARY KEY (adminmessageid),13KEY script_action (script, action),14KEY varname (varname)15) and was wondering how to do it when mssql doesn't have enums :(You can useCHECK CONSTRAINTS to limit the field to some particular values.
