Crear PK, FK e indices Contabilidad - Historial de revisiones

Pablosilva en 19:16 27 nov 2008

2008-11-27T19:16:42Z

← Revisión anterior		Revisión de 19:16 27 nov 2008
Línea 15:		Línea 15:
	ALTER TABLE ONLY contabc1 ADD CONSTRAINT pkcontabc1 PRIMARY KEY (numcom, codcta, numasi);		ALTER TABLE ONLY contabc1 ADD CONSTRAINT pkcontabc1 PRIMARY KEY (numcom, codcta, numasi);

		+
		+	----
		+	FOREING KEY
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodcta FOREIGN KEY (codcta) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctagas FOREIGN KEY (codctagas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaban FOREIGN KEY (codctaban) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaret FOREIGN KEY (codctaret) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaben FOREIGN KEY (codctaben) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaart FOREIGN KEY (codctaart) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctagashas FOREIGN KEY (codctagashas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctabanhas FOREIGN KEY (codctabanhas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctarethas FOREIGN KEY (codctarethas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctabenhas FOREIGN KEY (codctabenhas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaarthas FOREIGN KEY (codctaarthas) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctapageje FOREIGN KEY (codctapageje) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaingdevn FOREIGN KEY (codctaingdevn) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contaba ADD CONSTRAINT fkcontabacodctaingdev FOREIGN KEY (codctaingdev) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contabb1 ADD CONSTRAINT fkcontabb1codcta FOREIGN KEY (codcta) REFERENCES contabb(codcta);
		+
		+	ALTER TABLE ONLY contabc1 ADD CONSTRAINT fkcontabc1codcta FOREIGN KEY (codcta) REFERENCES contabb(codcta);

	----		----

Pablosilva en 19:14 27 nov 2008

2008-11-27T19:14:27Z

← Revisión anterior		Revisión de 19:14 27 nov 2008
Línea 1:		Línea 1:
-
	----		----

	PRIMARY KEY		PRIMARY KEY

-	ALTER TABLE ONLY contaba	+	ALTER TABLE ONLY contaba ADD CONSTRAINT pkcontaba PRIMARY KEY (codemp);
-	ADD CONSTRAINT pkcontaba PRIMARY KEY (codemp);	+

-	ALTER TABLE ONLY contaba1	+	ALTER TABLE ONLY contaba1 ADD CONSTRAINT pkcontaba1 PRIMARY KEY (fecini,feccie,pereje);
-	ADD CONSTRAINT pkcontaba1 PRIMARY KEY (fecini,feccie,pereje);	+

-	ALTER TABLE ONLY contabb	+	ALTER TABLE ONLY contabb ADD CONSTRAINT pkcontabbcodcta PRIMARY KEY (codcta);
-	ADD CONSTRAINT pkcontabbcodcta PRIMARY KEY (codcta);	+

-	ALTER TABLE ONLY contabb1	+	ALTER TABLE ONLY contabb1 ADD CONSTRAINT pk_contabb1 PRIMARY KEY (codcta, fecini, feccie, pereje);
-	ADD CONSTRAINT pk_contabb1 PRIMARY KEY (codcta, fecini, feccie, pereje);	+

-	ALTER TABLE ONLY contabc	+	ALTER TABLE ONLY contabc ADD CONSTRAINT pkcontabc PRIMARY KEY (numcom);
-	ADD CONSTRAINT pkcontabc PRIMARY KEY (numcom);	+

-	ALTER TABLE ONLY contabc1	+	ALTER TABLE ONLY contabc1 ADD CONSTRAINT pkcontabc1 PRIMARY KEY (numcom, codcta, numasi);
-	ADD CONSTRAINT pkcontabc1 PRIMARY KEY (numcom, codcta, numasi);	+

Pablosilva en 19:12 27 nov 2008

2008-11-27T19:12:24Z

← Revisión anterior		Revisión de 19:12 27 nov 2008
Línea 1:		Línea 1:
		+
		+	----
		+
		+	PRIMARY KEY
		+
		+	ALTER TABLE ONLY contaba
		+	ADD CONSTRAINT pkcontaba PRIMARY KEY (codemp);
		+
		+	ALTER TABLE ONLY contaba1
		+	ADD CONSTRAINT pkcontaba1 PRIMARY KEY (fecini,feccie,pereje);
		+
		+	ALTER TABLE ONLY contabb
		+	ADD CONSTRAINT pkcontabbcodcta PRIMARY KEY (codcta);
		+
		+	ALTER TABLE ONLY contabb1
		+	ADD CONSTRAINT pk_contabb1 PRIMARY KEY (codcta, fecini, feccie, pereje);
		+
		+	ALTER TABLE ONLY contabc
		+	ADD CONSTRAINT pkcontabc PRIMARY KEY (numcom);
		+
		+	ALTER TABLE ONLY contabc1
		+	ADD CONSTRAINT pkcontabc1 PRIMARY KEY (numcom, codcta, numasi);
		+
		+
		+	----
		+
	--INDICES		--INDICES
-	~~-- Definition for index i01cfbalcom (OID = 53042) :~~	+
	CREATE INDEX i01cfbalcom ON cfbalcom USING btree (orden);		CREATE INDEX i01cfbalcom ON cfbalcom USING btree (orden);

-	~~-- Definition for index i01contabb1 (OID = 53043) :~~
	CREATE INDEX i01contabb1 ON contabb1 USING btree (codcta);		CREATE INDEX i01contabb1 ON contabb1 USING btree (codcta);

-	~~-- Definition for index i01contabc1 (OID = 53044) :~~
	CREATE INDEX i01contabc1 ON contabc1 USING btree (numcom);		CREATE INDEX i01contabc1 ON contabc1 USING btree (numcom);

-	~~-- Definition for index i02contabb (OID = 53045) :~~
	CREATE INDEX i02contabb ON contabb USING btree (codcta, fecini, feccie);		CREATE INDEX i02contabb ON contabb USING btree (codcta, fecini, feccie);

-	~~-- Definition for index i02contabb1 (OID = 53046) :~~
	CREATE INDEX i02contabb1 ON contabb1 USING btree (codcta, fecini, feccie);		CREATE INDEX i02contabb1 ON contabb1 USING btree (codcta, fecini, feccie);

-	~~-- Definition for index i02contabc1 (OID = 53048) :~~
	CREATE INDEX i02contabc1 ON contabc1 USING btree (codcta);		CREATE INDEX i02contabc1 ON contabc1 USING btree (codcta);

-	~~-- Definition for index i03contabc (OID = 53049) :~~
	CREATE INDEX i03contabc ON contabc USING btree (stacom);		CREATE INDEX i03contabc ON contabc USING btree (stacom);

-	~~-- Definition for index i05contabb1 (OID = 53050) :~~
	CREATE INDEX i05contabb1 ON contabb1 USING btree (codcta, pereje);		CREATE INDEX i05contabb1 ON contabb1 USING btree (codcta, pereje);

-	~~-- Definition for index i06contabb1 (OID = 53051) :~~
	CREATE INDEX i06contabb1 ON contabb1 USING btree (codcta, pereje, fecini, feccie);		CREATE INDEX i06contabb1 ON contabb1 USING btree (codcta, pereje, fecini, feccie);

-	~~-- Definition for index i10contabb (OID = 53052) :~~
	CREATE INDEX i10contabb ON contabb USING btree (codcta, cargab);		CREATE INDEX i10contabb ON contabb USING btree (codcta, cargab);

Pablosilva: New page: --INDICES -- Definition for index i01cfbalcom (OID = 53042) : CREATE INDEX i01cfbalcom ON cfbalcom USING btree (orden); -- Definition for index i01contabb1 (OID = 53043) : CREATE INDEX ...

2008-11-27T19:09:19Z

New page: --INDICES -- Definition for index i01cfbalcom (OID = 53042) : CREATE INDEX i01cfbalcom ON cfbalcom USING btree (orden); -- Definition for index i01contabb1 (OID = 53043) : CREATE INDEX ...

Página nueva

--INDICES
-- Definition for index i01cfbalcom (OID = 53042) :
CREATE INDEX i01cfbalcom ON cfbalcom USING btree (orden);

-- Definition for index i01contabb1 (OID = 53043) :
CREATE INDEX i01contabb1 ON contabb1 USING btree (codcta);

-- Definition for index i01contabc1 (OID = 53044) :
CREATE INDEX i01contabc1 ON contabc1 USING btree (numcom);

-- Definition for index i02contabb (OID = 53045) :
CREATE INDEX i02contabb ON contabb USING btree (codcta, fecini, feccie);

-- Definition for index i02contabb1 (OID = 53046) :
CREATE INDEX i02contabb1 ON contabb1 USING btree (codcta, fecini, feccie);

-- Definition for index i02contabc1 (OID = 53048) :
CREATE INDEX i02contabc1 ON contabc1 USING btree (codcta);

-- Definition for index i03contabc (OID = 53049) :
CREATE INDEX i03contabc ON contabc USING btree (stacom);

-- Definition for index i05contabb1 (OID = 53050) :
CREATE INDEX i05contabb1 ON contabb1 USING btree (codcta, pereje);

-- Definition for index i06contabb1 (OID = 53051) :
CREATE INDEX i06contabb1 ON contabb1 USING btree (codcta, pereje, fecini, feccie);

-- Definition for index i10contabb (OID = 53052) :
CREATE INDEX i10contabb ON contabb USING btree (codcta, cargab);