blr044 Posted March 27, 2008 Share Posted March 27, 2008 I searched through several posting and also the contributions. Before I start, first I have over 1400 products in my store and product ID start at 29 and ends at 1775. What I am asking for, is when deletes product from your store, the description plus image is removed from the store. Do not mean to confuse you all out there. So lets say one deletes like for example: ID #: 23557 - 37162 -33744 But now if you add a new product, an new ID is a-signed , but starts where you left at the last new product. Is there any way one do a mod or a contribution out there that will place this product in a empty area. Or is this not even possible? If you need me to explain this a little better, please let me know what you out there needs. Thanks. blr044 Link to comment Share on other sites More sharing options...
arietis Posted March 27, 2008 Share Posted March 27, 2008 Or is this not even possible? If you need me to explain this a little better, please let me know what you out there needs. not easily. the products_id column in the products table has the 'auto_increment' attribute. this means that every time a new record is inserted into the table, the value of the products_id is incremented. if you change this it could break the database design. designers do this for database integrity reasons - so that *just in case* some other table is referring to the old (now deleted) products_id value it doesn't reappear with a new product. i'm a little unclear as to why you want this? is there some underlying problem that you're trying to solve? it might be better going about it in a different way rather than trying to change the database design. Link to comment Share on other sites More sharing options...
blr044 Posted March 27, 2008 Author Share Posted March 27, 2008 the products_id column in the products table has the 'auto_increment' attribute. this means that every time a new record is inserted into the table, the value of the products_id is incremented. if you change this it could break the database design. designers do this for database integrity reasons - so that *just in case* some other table is referring to the old (now deleted) products_id value it doesn't reappear with a new product. That is fine. I was just curious on how this worked and if anything was possible. Thanks for explaining this. blr044 Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.