2. PHPRunner General questions
  3. unable to add auto-increment primary key field to existing table
This topic is locked

unable to add auto-increment primary key field to existing table

 		5/9/2007 1:17:38 PM
PHPRunner General questions
H
 howong author

I am using:
PHPRunner 4.0 (build 241)

mysql Ver 14.12 Distrib 5.0.37, for Win32 (ia32)
I noticed that upon table creation if I don't specify an auto-increment primary key field before I save, I can't do it later. You can specify it through the UI but it doesn't make the modifications to the table. I got around this by modifying the table definition directly.
J
 		Jane 5/10/2007

Hi,
thank you for pointing me to this bug.

In the next PHPRunner update program will add auto-increment field for the new table automatically.
Alexey admin 5/10/2007

Hi,
PHPRunner doesn't allow modifying primary keys and autoincremented fields because this process is quite complex and there are many restrictions.

Specialized software would handle this better.
If you don't create a primary key in your table PHPRunner will add an autoincremented key automatically.