PDA

View Full Version : delete from payment list


dargre
06-18-2006, 09:20 PM
I wanna ask 'bout the part of Admin area. From SYSTEM menu I choose Payment. And ...

I have some items that I want to remove. I click DELETE icon and the link is removed from PLD_LINK table but not from PLD_PAYMENT table.
Ok, I can write a little script to remove unwanted items from PLD_PAYMENT but what about PLD_PAYMENT_SEQ table? What for is this table?

Can someone explain this?

Boby
06-18-2006, 09:29 PM
PLD_PAYMENT_SEQ is the table that stores the next ID of the PLD_PAYMENT table. It's used because some databases do not have the auto_increment feature.
Other DB's than MySQL are no longer supported, so in one of the next versions of phpLD we will remove this tables ;)

Boby

dargre
06-18-2006, 09:45 PM
I use MySQL ofcourse.
So I understood I don't have to worry about PLD_PAYMENT_SEQ if I manually remove something from PLD_PAYMENT?

Is it same with PLD_LINK_SEQ, PLD_CATEGORY_SEQ ?

Boby
06-18-2006, 09:50 PM
Content visible to registered users only.
Don't worry about this table, just make sure the value PLD_PAYMENT_SEQ is greater than the maximum ID in PLD_PAYMENT. You don't have to check this usually, only if you add new rows with an external script or manually.

Content visible to registered users only.
Yep ;)

Boby