Custom field system

Starting to work on adding a new feature called Custom field system

these are the db tables i have come up with so far:

custom_field
- custom_field_id
- location (customer / address)
- type
- value
- required
- position
- date_added

custom_field_description
- custom_field_id
- language_id
- name

custom_field_value
- custom_field_value_id
- custom_field_id
- sort_order

custom_field_value_description
- custom_field_value_id
- language_id
- custom_field_id
- name

custom_field_to_customer_group
- custom_field_id
- customer_group_id

customer_field
- customer_id
- custom_field_id
- custom_field_value_id
- name
- value
- sort_order

address_field
- address_id
- custom_field_id
- custom_field_value_id
- name
- value
- sort_order

order_field
- order_id
- custom_field_id
- custom_field_value_id
- name
- value
- sort_order

custom_field_description
- custom_field_id
- language_id
- name

custom_field_value
- custom_field_value_id
- custom_field_id
- sort_order

custom_field_value_description
- custom_field_value_id
- language_id
- custom_field_id
- name

custom_field_to_customer_group
- custom_field_id
- customer_group_id

Only one table seem to be missing: custom_field (the main table to handle custom fields).

just added it.

i need to finish the upgrade system before continuing with this.

Daniel wrote:just added it.

i need to finish the upgrade system before continuing with this.

While indicating:
from the custom_field table, perhaps a more reliable approach could be used with:

What about this custom field system? There are some traces of it in 1.5.5.1... but as far as I understand it is not yet a fully working feature, am I right?

M

Daniel wrote:just added it.

i need to finish the upgrade system before continuing with this.