####################################################################################################
# Record no of discs in item.
#
# by Jason Pell & Eduardo Ediaz
####################################################################################################

# Cleanup first so this can be rerun.
DELETE from s_attribute_type WHERE s_attribute_type = 'NO_DISCS';
DELETE from s_item_attribute_type WHERE s_attribute_type = 'NO_DISCS';
DELETE from s_attribute_type_lookup WHERE s_attribute_type = 'NO_DISCS';

INSERT INTO s_attribute_type (s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type) VALUES ( 'NO_DISCS', 'Records no of Discs', 'Number of Disc(s)', 'value_select("1,2,3,4,5,6")', '%value%', NULL, NULL);

# Insert for DVD, add extra s_item_attribute type inserts for other types.
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'CD', 'NO_DISCS', '45', '', NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'LD', 'NO_DISCS', '115', '', NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'VCD', 'NO_DISCS', '105', '', NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'DVD', 'NO_DISCS', '125', '', NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'DIVX', 'NO_DISCS', '155', '', NULL);

