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.