-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-- SIU-GUARANI 3 - Sistema de Gestión Académica
-- Versión 3.0.0
-- Tabla: mce_caminos
-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

-- DROP TABLE IF EXISTS mce_caminos;
CREATE  TABLE mce_caminos
(
	camino INTEGER NOT NULL DEFAULT nextval('mce_caminos_seq'::text) ,
	circuito Integer NOT NULL,
	accion Integer NOT NULL,
	estado_inicial Integer,
	estado_final Integer NOT NULL,
	recalcular_histacad Char(1) NOT NULL DEFAULT 'N',
	enviar_aviso_alumno Char(1) NOT NULL DEFAULT 'N',
	controlar_pago Char(1) NOT NULL DEFAULT 'N'
);

-- ALTER TABLE mce_caminos DROP CONSTRAINT pk_mce_caminos;
ALTER TABLE mce_caminos ADD CONSTRAINT pk_mce_caminos PRIMARY KEY (camino);

Revoke all ON mce_caminos FROM public;
-- ++++++++++++++++++++++++++ Fin tabla mce_caminos +++++++++++++++++++++++++++++