text: -- Create sequence SEQ_IP_REV_ACTIVITY_ID: 
  
  CREATE SEQUENCE SEQ_IP_REV_ACTIVITY_ID INCREMENT BY 1 START WITH 1 NOCACHE; 
  
  -- Add proposal_id to PROPOSAL_IP_REV_ACTIVITY table 
  
  alter table PROPOSAL_IP_REV_ACTIVITY add PROPOSAL_ID NUMBER(12,0) NOT NULL; 
  
  -- Add FK constraint to PROPOSAL table 
  
  ALTER TABLE PROPOSAL_IP_REV_ACTIVITY 
  ADD CONSTRAINT FK_PROPOSAL_ID 
  FOREIGN KEY (PROPOSAL_ID) 
  REFERENCES PROPOSAL (PROPOSAL_ID); 
  