[Phpgroupware-tracker] [Bug #1820] SQL tables creation incompatible with MySQL

[nobody]

=================== BUG #1820: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509

Changes by: Marco Andriolo-Stagno (MAS!) <address@hidden>
Date: 2002-Nov-28 12:03 (Europe/Rome)

------------------ Additional Follow-up Comments ----------------------------
I guess the problem is in the old MySQL version; with the 3.23.53-log (and I 
guess with almost all 3.23.xx version) I didn't find any error (and MySQL 
automagically add 'not null' in the field definition as you can check with a 
'show create' command).
_IMHO_ to keep the full compatibility with the older db version could be a good 
idea to handle that in class.schema_proc_mysql.inc.php.
what about?




=================== BUG #1820: FULL BUG SNAPSHOT ===================


Submitted by: cb                        Project: phpGroupWare                   
Submitted on: 2002-Nov-28 11:39
Category:  chat                         Bug Group:  0.9.14.001 release          
Severity:  5 - Major                    Priority:  High                         
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Component Version:  CVS                 
Platform Version:  Linux - Debian       Reproducibility:  Every Time            

Summary:  SQL tables creation incompatible with MySQL

Original Submission:  When installing table:
CREATE TABLE phpgw_chat_channel (con int(11) auto_increment, name varchar(10) 
NOT NULL, title char(50) NOT NULL, UNIQUE(con))
MySQL complains:
Column 'con' is used with UNIQUE or INDEX but is not defined as NOT NULL

Follow-up Comments
*******************

-------------------------------------------------------
Date: 2002-Nov-28 12:03             By: stagno
I guess the problem is in the old MySQL version; with the 3.23.53-log (and I 
guess with almost all 3.23.xx version) I didn't find any error (and MySQL 
automagically add 'not null' in the field definition as you can check with a 
'show create' command).
_IMHO_ to keep the full compatibility with the older db version could be a good 
idea to handle that in class.schema_proc_mysql.inc.php.
what about?


-------------------------------------------------------
Date: 2002-Nov-28 11:44             By: cb
MySQL version is "3.22.32-log"


CC list is empty


File Attachments
****************

-------------------------------------------------------
Date: 2002-Nov-28 11:39  Name: tables_current.inc.php.patch  Size: 2KB   By: cb
patch to fix bug described here
http://savannah.gnu.org/bugs/download.php?group_id=509&amp;bug_id=1820&amp;bug_file_id=167


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1820&group_id=509