mysql - How to manage eficiently the new products of my database? -


i have database of store have add new products constantly. before publish new product or after r modifying 1 admin have check if has correct data.

i thought in 2 options it:

1.-adding new field called verified (type boolean) in product's table. when i'll modify or add new product it'll set false @ default. , turn true when admin check it.

2.-using database, , export , import content every 5 days.

what think best way it? have option i'm trying do?

any advice, tip or appreciated, , if need more info let me know , i'll edit post.

option 1 sounds reasonable. insert product verified being defaulted 0, when associate check, boolean goes 1 check verification. might add verified column time , date.


Comments

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -