1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
#
# Alternate titles for all Types
#
#
# Ignore DUPLICATE error if it already exists!!!
#
INSERT INTO s_attribute_type (s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type) VALUES ( 'ALT_TITLE', 'Alternate Title', 'Alternate Title', 'text(50)', '%display%', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'DVD', 'ALT_TITLE', '5', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'VCD', 'ALT_TITLE', '5', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'VHS', 'ALT_TITLE', '5', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'LD', 'ALT_TITLE', '5', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'CD', 'ALT_TITLE', '5', NULL, NULL);
# DIVX was not supported before Alternate titles were introduced, which is why the order_no is 10.
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'DIVX', 'ALT_TITLE', '10', NULL, NULL);
|
