Add Timestamp to attributes

[AururNeves]

Hello,

I want to add a timestamp to attributes, so i can find out when a value für an attributes was created.

I tried to just add a column in the database table "catalog_product_entity_varchar" but only got an error because there were too many columns in the table:

Cardinality violation: 1222 The used SELECT statements have a different number of columns

I'm using CE 1.9.

Thank you for your help

[Magikvishal]

Hi Aurur

Can you tell how to column in database table using code or direst create column into database.

[AururNeves · Accepted solution]

Hi Magikvishal,

I tried both. 

But I found a solution:

the problem wasn't that i added a column to "catalog_product_entity_varchar" but that i didn't add the column to the 4 other attribute-value tables.

After i added the column to the following tables via install script it worked perfectly:

catalog_product_entity_varchar

catalog_product_entity_text

catalog_product_entity_datetime

catalog_product_entity_decimal

catalog_product_entity_int

Thank you for looking into it.