ALTER TABLE ISSPRECADASTROENDERECO ADD IDENDERECOCADASTRO NUMERIC(10,0)
#
ALTER TABLE ISSPRECADASTRO ADD CON_TELCOMERCIALCOR VARCHAR(30)
#
ALTER TABLE ISSPRECADASTRO ADD CON_TELCELULARCOR VARCHAR(30)
#
ALTER TABLE ISSPRECADASTRO ADD CON_TELFAXCOR VARCHAR(30)
#
ALTER TABLE ISSPRECADASTRO ADD CON_EMAILCOR VARCHAR(100)
#
ALTER TABLE ISSPRECADASTRO ADD CON_HOMEPAGECOR VARCHAR(100)
#
ALTER TABLE ISSPRECADASTROCNAE ADD HABILITADO CHAR(1) DEFAULT '0'
#
CREATE TABLE ISSPRECADASTROREGIMEFISCAL (

	IDPRECADASTROREGFISCAL NUMERIC (10,0) NOT NULL,
	IDPRECADASTRO NUMERIC(10, 0) NOT NULL,
	RGF_IDREGIMEFISCALPERIODO INT,
	RGF_IDREGIMEFISCAL INT NOT NULL,
	RGF_INICIO DATETIME NOT NULL,
	RGF_FINAL DATETIME,
	RGF_NROOPCAO NUMERIC(9,0),
	
	CONSTRAINT PK_ISSPRECADASTROREGIMEFISCAL PRIMARY KEY (IDPRECADASTROREGFISCAL),
	CONSTRAINT FK_ISSPRECADASTROREGIMEFISCAL FOREIGN KEY (IDPRECADASTRO) REFERENCES ISSPRECADASTRO (IDPRECADASTRO),
	CONSTRAINT FK_ISSPRECADASTRO_REG FOREIGN KEY (RGF_IDREGIMEFISCAL) REFERENCES REGIMEFISCAL (IDREGIMEFISCAL),
	CONSTRAINT FK_ISSPRECADREGFISPERIODO FOREIGN KEY (RGF_IDREGIMEFISCALPERIODO) REFERENCES RegimeFiscalPeriodo (IDREGIMEFISCALPERIODO)
	
)
#
ALTER TABLE ISSPRECADASTRO DROP CONSTRAINT FK_ISSPRECADASTRO_REGIMEFISCAL
#
ALTER TABLE ISSPRECADASTRO DROP COLUMN RGF_IDREGIMEFISCAL, RGF_DATAINICIO
#
ALTER TABLE ISSPRECADASTROSOCIO ALTER COLUMN PES_DATANASCIMENTO DATETIME NULL
#
ALTER TABLE ISSPRECADASTRO ADD CTB_IDCONTADOR INT
#
ALTER TABLE ISSPRECADASTRO ADD CONSTRAINT FK_ISSPRECADASTRO_CONTADOR
FOREIGN KEY (CTB_IDCONTADOR) REFERENCES CONTADOR (IDCONTADOR)
#
ALTER TABLE CONTADOR ADD ATIVO char(1) DEFAULT '1' NOT NULL
#
ALTER TABLE ISSPRECADASTRO ADD ESTABELECIDO CHAR(1) NOT NULL
#
CREATE TABLE ISSPRECADASTROREPRLEGAL (
	IDPRECADASTROREPRLEGAL NUMERIC(10,0) NOT NULL,
    IDPRECADASTRO NUMERIC(10,0) NOT NULL,
    
    REP_IDREPRESENTANTELEGAL INT,
    REP_IDCADASTROGERAL NUMERIC(10,0) NOT NULL,
    REP_DATAAUTORIZACAO DATETIME NOT NULL,
    REP_PESSOA NUMERIC(10,0) NOT NULL,
    REP_TIPOREPRESENTANTE INT NOT NULL,
    
    CONSTRAINT PK_ISSPRECADASTROREPRLEGAL PRIMARY KEY (IDPRECADASTROREPRLEGAL),
    CONSTRAINT FK_ISSPRECADASTROREP_PRECAD FOREIGN KEY (IDPRECADASTRO)
    	REFERENCES ISSPRECADASTRO (IDPRECADASTRO),
    CONSTRAINT FK_ISSPRECADASTROREP_REPRLEGAL FOREIGN KEY (REP_IDREPRESENTANTELEGAL)
    	REFERENCES REPRESENTANTELEGAL (IDREPRESENTANTELEGAL),
    CONSTRAINT FK_ISSPRECADASTROREP_TIPOREPR FOREIGN KEY (REP_TIPOREPRESENTANTE)
    	REFERENCES TIPOREPRESENTANTE (IDTIPOREPRESENTANTE)
)
#
ALTER TABLE ISSPRECADASTROSOCIO ALTER COLUMN CSO_IDTIPOSOCIO numeric(10, 0) NULL
#