Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

dbf2mysql parameter, WWWXXXAPC, wwwxxxAPC, How to unsubscrube from dategen spam, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text

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