URL:
<http://gna.org/bugs/?func=detailitem&item_id=2171>
Summary: Probleme sur les champs uniques sur certaines
versions de mysql
Project: GLPI
Submitted by: baaz
Submitted on: Sat 03/26/05 at 17:35
Category: None
Severity: 3 - Normal
Priority: 1 - Later
Status: None
Privacy: Public
Assigned to: None
Originator Email:
Open/Closed: Open
_______________________________________________________
Details:
A priori les int que l'on met en key (donc unique) doivent aussi etre NOT NULL
sinon mysql crie...
A corriger dans l'update et les dumps.
***********************
Erreur
requête SQL :
CREATE TABLE glpi_cartridges(
ID int( 11 ) NOT NULL AUTO_INCREMENT ,
FK_glpi_cartridges_type int( 11 ) ,
FK_glpi_printers int( 11 ) ,
date_in date,
date_use date,
date_out date,
pages varchar( 30 ) ,
PRIMARY KEY ( ID ) ,
KEY FK_glpi_cartridges_type( FK_glpi_cartridges_type ) ,
KEY FK_glpi_printers( FK_glpi_printers ) ,
KEY date_in( date_in ) ,
KEY date_use( date_use ) ,
KEY date_out( date_out )
)
MySQL a répondu:
#1121 - Column 'FK_glpi_cartridges_type' is used with UNIQUE or INDEX but is
not defined as NOT NULL
*********************************
_______________________________________________________
Reply to this item at:
<http://gna.org/bugs/?func=detailitem&item_id=2171>
_______________________________________________
Message sent via/by Gna!
http://gna.org/
