Hi
Dne Thu, 10 Feb 2011 08:11:23 +0100 Michal Čihař michal@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.