Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot, bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010

Links

XODOX
Impressum

#1: Please help me.

Posted on 2009-03-18 19:27:14 by Valentin Ionescu

Hi!=0AMy name is Valentin and I am writing to you for the following problem=
:=0AI created a database containing the table:  =0ACREATE TABLE `docume=
nts_ex` (   `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,   `Journ=
al_ex_ID` int(10) unsigned DEFAULT NULL,   `Documents_ID` int(10) unsig=
ned DEFAULT NULL,   `Data` datetime DEFAULT NULL,   `Nr` varchar(50=
) DEFAULT NULL,   PRIMARY KEY (`ID`),   UNIQUE KEY `Journal_ex_ID` =
(`Journal_ex_ID`,`Documents_ID`,`Data`,`Nr`),   KEY `Documents_ID` (`Do=
cuments_ID`),   CONSTRAINT `documents_ex_ibfk_1` FOREIGN KEY (`Journal_=
ex_ID`) REFERENCES `journal_ex` (`ID`) ON DELETE CASCADE,   CONSTRAINT =
`documents_ex_ibfk_2` FOREIGN KEY (`Documents_ID`) REFERENCES `documents` (=
`ID`) ON DELETE CASCADE=0A) ENGINE=3DInnoDB DEFAULT CHARSET=3Dlatin1  =
=0AAfter some time I decided to drop 'Journal_ex_ID' column and all its env=
ironment from this non empty table.=0AAll I tried to do like:  =0Aalter=
table documents_ex drop column Journal_ex_ID=0Aor=0Aalter table documents_=
ex drop foreign key=A0 Journal_ex_ID=0Aor =0Aalter table documents_ex drop=
=A0 key=A0 Journal_ex_ID    I receive the same error 150 and I don'=
t know what to do.  =0APlease help me.  Best regards. =0A =


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Report this message