File: item_attribute.sql

package info (click to toggle)
opendb 0.81p18-2
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 4,716 kB
  • ctags: 6,787
  • sloc: php: 50,213; sql: 3,098; sh: 272; makefile: 54; xml: 48
file content (19 lines) | stat: -rw-r--r-- 546 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
#
# 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';