1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
#
# Add DVD Type attribute to DVD
#
#
# Attribute Type
#
INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type )
VALUES ( 'DVD_TYPE', 'Type of DVD', 'Type','single_select(%display%)', 'display(%display%, list-link)', NULL, NULL );
#
# Item Attribute Type
#
INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, compulsory_ind ) VALUES ( 'DVD', 'DVD_TYPE', '121', '', 'N' );
#
# Attribute Type Lookup (DVD_TYPE)
#
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ( 'DVD_TYPE', '1', 'PRESSED', 'Normal / Pressed', '', 'Y');
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ( 'DVD_TYPE', '2', 'DVD-R', 'DVD-R', '', '');
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ( 'DVD_TYPE', '3', 'DVD+R', 'DVD+R', '', '');
|
