---SO 20013069 Print unique stockroom location label (to be offered)

------------------------------STOCKROOMLOCATION TABLE---------------------------

ALTER TABLE STOCKROOMLOCATION MODIFY(UNIQUEID VARCHAR2(38));

ALTER TABLE STOCKROOMLOCATION
	ADD (AREACODE VARCHAR2(12));

ALTER TABLE STOCKROOMLOCATION DROP CONSTRAINT XAK1STOCKROOMLOCATION;
DROP INDEX XAK1STOCKROOMLOCATION;

CREATE UNIQUE INDEX XAK1STOCKROOMLOCATION ON STOCKROOMLOCATION
(STOCKROOM_ID   ASC,ROWCODE   ASC,LOCATIONCODE   ASC,AREACODE   ASC);

ALTER TABLE STOCKROOMLOCATION
ADD CONSTRAINT  XAK1STOCKROOMLOCATION UNIQUE (STOCKROOM_ID,ROWCODE,LOCATIONCODE,AREACODE);

