Recount ID's on Catalog_items Query

[Biblioteca13]

Hello RageZone.
As this is my first post in here , i hope i don't make anything wrong.

Today , i came here to release a small query that recounts the ID's on the Catalog_Items table.

For those that keep adding furni that has got ID's like 1000000 or so , you can use this query , to recount all id's on catalog_items make it more organized.

Is this NECESSARY or DOES IT make diffrence on your hotel?

IT ISN'T NECESSARY, i'm just posting this for the ones that like to keep things organized.
Feel free to comment!

ALTER TABLE  `catalog_items`
DROP `id`;
ALTER TABLE `catalog_items`
ADD  `id` INT( 10 ) unsigned NOT NULL AUTO_INCREMENT FIRST,  
ADD PRIMARY KEY (  `id` );

Edit : 23:04 GMT+0 Added "unsigned" because an issue with Phoenix Emulator 3.8.1

Tested on Uber/Phoenix database.

OBS : If you have any php that relies on catalog_items ID's DO NOT USE THIS.

Thanks for reading!
Biblioteca13

[MentaL]

[The General]

Thanks I was looking for this. I'll test tomorrow!

[PRIZM]

Actually a pretty good idea
Thanks!

[Yannickzz]

Used it, and can't reload my catalogue after doing that, weird.

[Biblioteca13]

I edited it because there was an issue with Phoenix Emulator 3.8.1 here.

I added the "unsigned" part.

Don't forget to use it with unsigned!

Hubbo-Hotel , do it again , with that query , as i edited it on this minute because there was an issue with Phoenix Emulator. It should do it.

[Yannickzz]

Allright, it works now. Thanks a lot!

[Biblioteca13]

Allright, it works now. Thanks a lot!

Okay! If you need any SQL help just ask ^^

[Yannickzz]

Okay! If you need any SQL help just ask ^^

It would be great to rearrange all the furniture ID's and update them to the new ones in the catalog_items table, but that would be impossible i guess.

[Biblioteca13]

It would be great to rearrange all the furniture ID's and update them to the new ones in the catalog_items table, but that would be impossible i guess.

It is possible , but a query that does all on one, i don't know how to make it xD
But furniture ID's you can change it when you are adding the furniture.

When adding the query if it has like 3000000 just take out some zeros leave it 30000 or 3000 , do the same on item_ids
If you're adding alot of furniture , it will take you alot of time.

[Edit : My next project that i will be releasing it's MAYBE a Visual Basic program that makes voucher querys
It is ready maybe tomorrow i release it.]

[JustTime]

Thank you ! I have search for this.

[Spheral]

Aah, i made my catalogue manually, but this is what i was looking for, thanks for this anyway.