Hi. One of my friend, with MySQL v. 3.22.32 and with this commands :
CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) NOT NULL, title char(50) NOT NULL, UNIQUE(con)) have this error: MySQL complains: Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL I have v. 3.23.53-log and with the same statment I have no error; I guess because the new version add 'not null' automagically. Is it right? Can someone tell me from which version is it true? thank you in advance! bye bye! MAS! -- Marco Andriolo-Stagno (MAS!) <[EMAIL PROTECTED]> PROSA - free software - http://www.prosa.it FreeGO! - free software news - http://www.freego.it --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php