-- ABS-82905/ ABS-84257

-------- PLPCEXTRAINFO TABLE ------------
CREATE TABLE PLPCEXTRAINFO
(
  PRODUCTLISTPERCUSTOMER_ID NUMBER NOT NULL,
  GALAXIEINCINLOSSPOOLWS    VARCHAR2(1) DEFAULT 'N' NOT NULL
                            CONSTRAINT CHK_PLPCEXTRAINFO_GALAXIEINC CHECK (GALAXIEINCINLOSSPOOLWS IN ('Y', 'N')),
  SYSTEMUSER_ID             NUMBER NOT NULL,
  TIMESTAMP                 DATE NOT NULL
)
;

COMMENT ON COLUMN PLPCEXTRAINFO.GALAXIEINCINLOSSPOOLWS
  IS 'The attribute is only relevant when module GALAXIE is active';

ALTER TABLE PLPCEXTRAINFO
  ADD CONSTRAINT XPKPLPCEXTRAINFO PRIMARY KEY (PRODUCTLISTPERCUSTOMER_ID);

ALTER TABLE PLPCEXTRAINFO
  ADD CONSTRAINT FK_PLPCEXTRAINFO_PLPCID FOREIGN KEY (PRODUCTLISTPERCUSTOMER_ID)
  REFERENCES PRODUCTLISTPERCUSTOMER (PRODUCTLISTPERCUSTOMER_ID) ON DELETE CASCADE;