title: phpMyAdmin error 1005
body: <p>this is my code...i have no idea what i am doing wrong because i am new to this. i am getting an 1005 error saying that i cannot create the table bookauthor.</p>
  
  <pre><code>CREATE TABLE Book_Author(
      BID INTEGER(7) NOT NULL,
      B_TITLE VARCHAR(25) NOT NULL,
      AID INTEGER(7) NOT NULL,
      A_NAME VARCHAR(25) NOT NULL,
          CONSTRAINT PRIMARY KEY(BID),
          CONSTRAINT BID_FK
            FOREIGN KEY(BID)
            REFERENCES Book_Info(BID)
            ON DELETE CASCADE
  );
  </code></pre>