Hi
Dne Thu, 10 Feb 2011 08:11:23 +0100
Michal Čihař <michal(a)cihar.com> napsal(a):
I've just noticed this and don't have time to
debug and the tracker is
not working, so I'm reporting it here.
When trying to browse empty table, I get following error:
#1050 - Table 'ASSIGNMENT' already exists
CREATE TABLE ASSIGNMENT(
ProjectID Int NOT NULL ,
EmployeeNumber Int NOT NULL ,
HoursWorked Numeric( 6, 2 ) NULL ,
CONSTRAINT ASSIGNMENT_PK PRIMARY KEY ( ProjectID, EmployeeNumber ) ,
CONSTRAINT ASSIGN_PROJ_FK FOREIGN KEY ( ProjectID ) REFERENCES
PROJECT( ProjectID ) ON UPDATE NO ACTION ON DELETE CASCADE , CONSTRAINT
ASSIGN_EMP_FK FOREIGN KEY ( EmployeeNumber ) REFERENCES
EMPLOYEE( EmployeeNumber ) ON UPDATE NO ACTION ON DELETE NO ACTION );
Okay, the reason is that there is bookmark with table name, which does
contain this SQL. I think there should be indication that phpMyAdmin is
using bookmarked query and I will work on this.
--
Michal Čihař |
http://cihar.com |
http://blog.cihar.com