#
# Patch for 0.62 - 0.80
# Item Attribute lookup field functionality.
#

#
# Item Attribute functionality
# 
RENAME TABLE item_attribute TO item_attribute_old;

CREATE TABLE item_attribute (
  item_id			integer(10) unsigned NOT NULL,
  s_attribute_type	varchar(10) NOT NULL,
  order_no			tinyint(3) unsigned NOT NULL,
  lookup_attribute_val varchar(50) NOT NULL,
  attribute_val		text,
  update_on			timestamp(14) NOT NULL,
  PRIMARY KEY ( item_id, s_attribute_type, order_no, lookup_attribute_val )
) TYPE=MyISAM COMMENT='Item Attribute table';