/*==============================================================*/ /* 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;