should I add new table to store new field?

[linjuming]

should I add new table to store new field in zencart db?

zencart original table
table : customers
customers_id | ...
1 | ...
2 | ...

now I need to add a new field for customer
I create a new table
table : customers_extra
customers_id | is_blogger
1 | 0
2 | 1

or directly created in the customers table
table: customers
customers_id | ... | is_blogger
1 | ... | 0
2 | ... | 1

which method should I use ? will add new table be worth to do ? will it slow down the query speed?

[kobra]

What information are you going to store in this??

[linjuming]

is_blogger means that if the customers is a fashion blogger or not.

[schoolboy]

is_blogger means that if the customers is a fashion blogger or not.

And once the field is created, how are you going to load data to it and how are you going to use the data?

It's all very well having the field (that's the easy part)... How you get data into the field and how you use that data is what's complicated.

And is this data really necessary for the effective functioning of the store?

[gjh42]

You might be able to use the customer discount groups feature to store this info. (I am not sure if this would interfere with other uses of discount groups.) Create a "Blogger" discount group and add the appropriate customers to it. You don't have to actually discount anything here. You can then retrieve the info and use it wherever you want.