CODEWITHSUNDEEP
mysqldatabasedatabase-designdatabase-administrationdatabase-management
mllamazares
mllamazares

Reputation: 8196

How to manage eficiently the new products of my database?

I have a database of a store which I have to add new products constantly. But before publish a new product or after r modifying one the admin have to check if it has the correct data.

I thought in two options to do it:

1.-Adding a new field called verified (type boolean) in the product's table. Then when I'll modify or add a new product it'll be set false at default. And turn it to true when the admin check it.

2.-Using another database, and export and import all the content every 5 days.

What do you think is the best way to do it? Do you have another option to get what I'm trying to do?

Any advice, tip or help will be appreciated, and if you need more info let me know and I'll edit the post.

Upvotes: 0

Views: 47

Answers (1)

OffTheFitz
OffTheFitz

Reputation: 81

Option 1 sounds reasonable. Insert product with verified being defaulted to 0, when associate check, Boolean goes to 1 to check for verification. Might even add a verified by column as well with time and date.

Upvotes: 2

Related Questions