1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
#
# Add GAMEREGION to Game type. (Author: Thomas Btzler)
# Warning: Be sure to install GAME type first.
#
INSERT INTO s_attribute_type (s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type) VALUES ( 'GAMEREGION','Game Region','Region','single_select(%display%)','display(%display%, list-link)', NULL, NULL);
#
# s_item_attribute_type relationships
#
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'GAME', 'GAMEREGION', '43', NULL, NULL);
#
# s_attribute_type_lookup values
#
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ('GAMEREGION',NULL,'US','United States','usa.gif',NULL);
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ('GAMEREGION',NULL,'JP','Japan','japanese.gif',NULL);
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ('GAMEREGION',NULL,'EU_DE','Germany','german.gif',NULL);
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ('GAMEREGION',NULL,'EU_UK','England','english.gif',NULL);
INSERT INTO s_attribute_type_lookup (s_attribute_type, order_no, value, display, img, checked_ind) VALUES ('GAMEREGION',NULL,'EU_FR','France','french.gif',NULL);
|
