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

-- DROP TABLE IF EXISTS ct_plan;
CREATE  TABLE ct_plan
(
	caso_testeo INTEGER NOT NULL DEFAULT nextval('ct_plan_seq'::text) ,
	plan_version Integer NOT NULL,
	nombre Varchar(100) NOT NULL,
	descripcion Text,
	fecha_creacion Date DEFAULT CURRENT_DATE
);

-- ALTER TABLE ct_plan DROP CONSTRAINT pk_ct_plan;
ALTER TABLE ct_plan ADD CONSTRAINT pk_ct_plan PRIMARY KEY (caso_testeo);

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