--Order 20014386.140

ALTER TABLE SQITEMINCIRCULATION
	ADD (QTYRENTEDMINRENT NUMBER NULL);

ALTER TABLE SQITEMINCIRCULATION
	ADD (VARIATIONQTYRENTEDMINRENT NUMBER NULL);

ALTER TABLE CUSTOMER
	ADD (ALLOWCHARGEMINRENT NUMBER  DEFAULT 0 NOT NULL CONSTRAINT ALLOWCHARGEMINRENT_valid1_1 CHECK (ALLOWCHARGEMINRENT IN (0, 1)));

ALTER TABLE CUSTOMER
	ADD (MINRENTWEEKS NUMBER  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN CUSTOMER.ALLOWCHARGEMINRENT IS 'Flag that indicates whether min rent should be charged for this customer. Possible values:
0 = Do not charge return rent
1 = Do charge return rent';

COMMENT ON COLUMN CUSTOMER.MINRENTWEEKS IS 'This attribute indicates the minimum number of weeks that rent will be charged for this customer. When an item has been taken out of circulation prior to reaching this number of weeks then still rent will be charged (as compensation) during this period.';