-----SO 20014048

ALTER TABLE WORKSTATION
	ADD (CGPWEIGHTLEVELMIN NUMBER(6,2)  DEFAULT 0 NOT NULL,
	            CGPWEIGHTLEVELMAX NUMBER(6,2)  DEFAULT 0 NOT NULL);

ALTER TABLE CGPSORTBOX
	MODIFY(VOLUME NUMBER(15,6));

ALTER TABLE CGPBATCH
	ADD (BATCHNUMBER NUMBER  NOT NULL);

CREATE UNIQUE INDEX XAK1CGPBATCH ON CGPBATCH
(BATCHNUMBER   ASC);

COMMENT ON COLUMN CGPBATCH.BATCHNUMBER IS 'The logical batchnumber
Format YYWWRSSSS
YY = Year number (i.e. 14 means 2014)
WW = Week number
R = Region :
0 = Unknown
1 = North (code ‘NO’)
2 = South-East (code ‘ZO’)
3 = South-West (code ‘ZW’)
4 = Hi-Care (code ‘HC’)
SSSS = Sequence number 0001 - 9999
';

CREATE TABLE PLANTINTERFACESETTINGS
(
	PLANT_ID             NUMBER NOT NULL ,
	WINWASHWSDLLOCATION  VARCHAR2(255) NULL ,
	WINWASHUSERNAME      VARCHAR2(40) NULL ,
	WINWASHPASSWORD      VARCHAR2(40) NULL 
);

COMMENT ON COLUMN PLANTINTERFACESETTINGS.WINWASHWSDLLOCATION IS 'URL used for calling webservices from WinWash
For example:
http://vm-abstest:50331/WinWashServer/WinWashSoap?wsdl
';

ALTER TABLE PLANTINTERFACESETTINGS
ADD CONSTRAINT  XPKPLANTINTERFACESETTINGS PRIMARY KEY (PLANT_ID);

ALTER TABLE PLANTINTERFACESETTINGS
ADD CONSTRAINT PLANTINTERFACESETTINGS_PLANT FOREIGN KEY (PLANT_ID) REFERENCES PLANT (PLANT_ID) ON DELETE CASCADE;
