--Order 20011000.70

ALTER TABLE CUSTOMERRESIDENTIALSETTINGS
	ADD (ENDUSERPRICELIST_ID NUMBER NULL);

CREATE  INDEX XIF8CUSTOMERRESIDENTIALSETTING ON CUSTOMERRESIDENTIALSETTINGS
(ENDUSERPRICELIST_ID   ASC);

ALTER TABLE CUSTOMERRESIDENTIALSETTINGS
ADD CONSTRAINT CUSTRESSETTINGS_GENERALPRICELI FOREIGN KEY (ENDUSERPRICELIST_ID) REFERENCES GENERALPRICELIST (GENERALPRICELIST_ID) ON DELETE SET NULL;
