Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

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