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

-- DROP TABLE IF EXISTS ct_plan_actividades;
CREATE  TABLE ct_plan_actividades
(
	test_actividad INTEGER NOT NULL DEFAULT nextval('ct_plan_actividades_seq'::text) ,
	caso_testeo Integer NOT NULL,
	elemento Integer NOT NULL,
	cursada Char(1) NOT NULL DEFAULT 'N',
	cursada_fecha Date,
	aprobada Char(1) NOT NULL DEFAULT 'N',
	aprobada_fecha Date,
	inscripto_cursada Char(1) NOT NULL DEFAULT 'N',
	inscripto_cursada_fecha Date
);

-- ALTER TABLE ct_plan_actividades DROP CONSTRAINT pk_ct_plan_actividades;
ALTER TABLE ct_plan_actividades ADD CONSTRAINT pk_ct_plan_actividades PRIMARY KEY (test_actividad);

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