/*==============================================================*/
/* DBMS name:      ORACLE Version 8i2 (8.1.6)                   */
/* Created on:     10/05/2005 02:32:42 p.m.                     */
/*==============================================================*/


drop table PryBitacora cascade constraints;

drop table PryColaborador cascade constraints;

drop table PryDetalleLabor cascade constraints;

drop table PryDetalleProyecto cascade constraints;

drop table PryModulo cascade constraints;

drop table PryParametros cascade constraints;

drop table PryProyecto cascade constraints;

drop table PryReporteLabor cascade constraints;

drop table PryTar cascade constraints;

drop table PryTarEventos cascade constraints;


drop table Bitacora cascade constraints;
drop table Colaborador cascade constraints;
drop table DetalleLabor cascade constraints;
drop table DetalleProyecto cascade constraints;
drop table Modulo cascade constraints;
drop table TarParametros cascade constraints;
drop table Proyecto cascade constraints;
drop table ReporteLabor cascade constraints;
drop table Tar cascade constraints;
drop table TarEventos cascade constraints;


insert into prymodulo select * from prym;
insert into prycolaborador select * from pryc;
insert into pryproyecto select * from pryp;
insert into prydetalleproyecto select * from pryd;
insert into pryparametros values (0,0,0);
commit;


create table prym as select * from prymodulo;
create table pryc as select * from prycolaborador;
create table pryp as select * from pryproyecto;
create table pryd as select * from prydetalleproyecto;