DROP INDEX FKPLAXXXXXGERACAOCARD_OPER
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_GER
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_SER
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_CUS
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_PRD
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_CVI
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_CEN
/

DROP INDEX FKPLAXXXXXITGERACAOCARD_CPB
/

DROP INDEX FK_LOGOTMPUBLICACAO
/

ALTER TABLE PARAMGERAL DROP CONSTRAINT FK_PARAMGERALGRUPPROD
/

ALTER TABLE GERACAOCARD DROP CONSTRAINT FKPLAXXXXXGERACAOCARD_OPER
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_GER
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_SER
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_CUS
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_PRD
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_CVI
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_CEN
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXITGERACAOCARD_CPB
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXLOGITGERACAO_ITGER
/

ALTER TABLE LOGITGERACAOCARD DROP CONSTRAINT FKPLAXXXXXLOGITGERACAO_ITGER
/

ALTER TABLE ITGERACAOCARD DROP CONSTRAINT FK_LOGOTMPUBLICACAO
/

ALTER TABLE GERACAOCARD ADD 
	CONSTRAINT FKPLA01293GERACAOCARD_OPER FOREIGN KEY (CDOPERADOR)
		REFERENCES OPERADOR (CDOPERADOR)
/
CREATE INDEX FKPLA01293_FK ON GERACAOCARD (CDOPERADOR ASC)
/
ALTER TABLE ITGERACAOCARD ADD
	CONSTRAINT FKPLA01294ITGERACAOCARD_GER FOREIGN KEY (NRGERACAOCARD) 
		REFERENCES GERACAOCARD (NRGERACAOCARD) ON DELETE CASCADE
/
CREATE INDEX FKPLA01294_FK ON ITGERACAOCARD (NRGERACAOCARD ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01295ITGERACAOCARD_SER FOREIGN KEY (CDFILIAL, CDSERVFILI)
		REFERENCES SERVICO (CDFILIAL, CDSERVFILI)
/
CREATE INDEX FKPLA01295_FK ON ITGERACAOCARD (CDFILIAL ASC, CDSERVFILI ASC)
/
ALTER TABLE ITGERACAOCARD ADD
	CONSTRAINT FKPLA01296ITGERACAOCARD_CUS FOREIGN KEY (CDTIPOCUSTO) 
		REFERENCES TIPOCUSTO (CDTIPOCUSTO)
/
CREATE INDEX FKPLA01296_FK ON ITGERACAOCARD (CDTIPOCUSTO ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01297ITGERACAOCARD_PRD FOREIGN KEY (CDGRUPPROD)
		REFERENCES GRUPPROD (CDGRUPPROD)
/
CREATE INDEX FKPLA01297_FK ON ITGERACAOCARD (CDGRUPPROD ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01298ITGERACAOCARD_CVI FOREIGN KEY (NRCENARIOVINCULO)
		REFERENCES CENARIOCARD (NRCENARIOCARD)
/
CREATE INDEX FKPLA01298_FK ON ITGERACAOCARD (NRCENARIOVINCULO ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01299ITGERACAOCARD_CEN FOREIGN KEY (NRCENARIOCARD) 
		REFERENCES CENARIOCARD (NRCENARIOCARD)
/
CREATE INDEX FKPLA01299_FK ON ITGERACAOCARD (NRCENARIOCARD ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01300ITGERACAOCARD_CPB FOREIGN KEY (NRCENARIOPUBLICAR)
		REFERENCES CENARIOCARD (NRCENARIOCARD)
/
CREATE INDEX FKPLA01300_FK ON ITGERACAOCARD (NRCENARIOPUBLICAR ASC)
/

ALTER TABLE LOGITGERACAOCARD ADD 
	CONSTRAINT FKPLA01301LOGITGERACAO_ITGER FOREIGN KEY (NRITGERACAOCARD)
		REFERENCES ITGERACAOCARD (NRITGERACAOCARD) ON DELETE CASCADE
/
CREATE INDEX FKPLA01301_FK ON LOGITGERACAOCARD (NRITGERACAOCARD ASC)
/
ALTER TABLE ITGERACAOCARD ADD 
	CONSTRAINT FKPLA01302LOGOTMPUBLICACAO FOREIGN KEY (NRLOGINTCARDAMES) 
		REFERENCES LOGINTCARDAMES (NRLOGINTCARDAMES) ON DELETE SET NULL
/

CREATE INDEX FKPLA01302_FK ON ITGERACAOCARD(NRLOGINTCARDAMES ASC)
/

ALTER TABLE PARAMGERAL ADD 
	CONSTRAINT FK01303PARAMGERALGRUPPROD FOREIGN KEY (CDGRUPPRODOTMCARD) 
		REFERENCES GRUPPROD (CDGRUPPROD) ON DELETE SET NULL
/
CREATE INDEX FKPLA01303_FK ON PARAMGERAL (CDGRUPPRODOTMCARD ASC) 
/ 