Making the accounts field into an auto_increment

[routledge]

Good evening Peeps

Another naggy problem on my sugar road. I must make the accounts.id field into and auto increment. I'm using 5.2ce on a linux box

Regards

John

[Angel]

You'd have to do this via the backend.

See here:

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

and here:

http://dev.mysql.com/doc/refman/5.0/...increment.html

Out of curiosity, why are you doing this? This can cause problems if you to sync the data in the future.

[routledge]

Hi Angel

Its not necessarily what i want to do, however we are linking data via MySQL views and the table that we are viewing uses auto increment integers. The problem is if we use random numbers it could break other applications linked to the database, so its the better of two evils to change sugar . But hey thanks for the tip, i will post my project for the community once i've finished or committed suicide, whichever comes first.

regards

John

[routledge]

Hi Angel

The links that were in your last posting on this topic refer to changing the database, the database i'm linking to already has an auto increment as its id. what I actually want to do is turn off the id creation so that this database can populate its own id, any ideas?

Regards

John

[Angel]

Well, I can only answer based on the information provided.

At some point you'll need to alter the accounts table in order to make the ID column auto_increment, hence my prior references.

In order to keep it from creating ID values, you'd most likely have to change the save() function in SugarBean.php, which wouldn't be upgrade safe.

[routledge]

Well, I can only answer based on the information provided.

At some point you'll need to alter the accounts table in order to make the ID column auto_increment, hence my prior references.

In order to keep it from creating ID values, you'd most likely have to change the save() function in SugarBean.php, which wouldn't be upgrade safe.

Your right Angel it does help to have the info , will look into that and with a bit of luck it will serve my purposes.

Many thanks

John