PGDMP 9lpeople8.3.08.3.0c 00ENCODINGENCODING SET client_encoding = 'LATIN1'; falsed 00 STDSTRINGS STDSTRINGS)SET standard_conforming_strings = 'off'; falsee 126285389peopleDATABASEFCREATE DATABASE people WITH TEMPLATE = template0 ENCODING = 'LATIN1'; DROP DATABASE people; davidfalse26152200publicSCHEMACREATE SCHEMA public; DROP SCHEMA public; postgresfalsef 00 SCHEMA publicCOMMENT6COMMENT ON SCHEMA public IS 'standard public schema'; postgresfalse6g 00publicACLREVOKE ALL ON SCHEMA public FROM PUBLIC; REVOKE ALL ON SCHEMA public FROM postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; GRANT ALL ON SCHEMA public TO empresa; GRANT ALL ON SCHEMA public TO afiliados; postgresfalse6N261263797plpgsqlPROCEDURAL LANGUAGE$CREATE PROCEDURAL LANGUAGE plpgsql; "DROP PROCEDURAL LANGUAGE plpgsql; postgresfalse125963798item_movimientoTABLEyCREATE TABLE item_movimiento ( imv_id character varying(20) NOT NULL, mv_id character varying(20) NOT NULL, cc_id character varying(20), te_id character varying(20), puc_codigo character varying(20), pe_id character varying(20), imv_numero character varying(20), imv_descripcion text, imv_db double precision, imv_cr double precision ); #DROP TABLE public.item_movimiento; publicpostgrestrue6h 00TABLE item_movimientoCOMMENT{COMMENT ON TABLE item_movimiento IS 'Esta tabla relaciona todos los conceptos descritos en un comprobante o movimiento. '; publicpostgresfalse1762i 00item_movimientoACLREVOKE ALL ON TABLE item_movimiento FROM PUBLIC; REVOKE ALL ON TABLE item_movimiento FROM postgres; GRANT ALL ON TABLE item_movimiento TO postgres; GRANT ALL ON TABLE item_movimiento TO empresa; publicpostgresfalse1762125963804 movimientoTABLECREATE TABLE movimiento ( mv_id character varying(20) NOT NULL, tm_tipo_movimiento character varying(20) NOT NULL, es_id character varying(20) NOT NULL, mv_fecha_preparacion timestamp without time zone, us_preparo character varying(20), mv_fecha_aprobacion timestamp without time zone, us_aprobo character varying(20), us_contabilizo character varying(20), pe_id character varying(20), mv_fecha_auditoria timestamp without time zone, mv_numero character varying(20), mv_plantilla character varying(50), mv_db double precision NOT NULL, mv_cr double precision NOT NULL, mv_iva double precision, mv_subt double precision, mv_total double precision, mv_observaciones text, us_anulo character varying(20), mv_fecha_anulo timestamp without time zone, mv_dia_contabilizacion character varying(2), mo_sigla character varying(20), mv_tasa character varying(20), mv_devolucion character varying(20) ); DROP TABLE public.movimiento; publicpostgrestrue6j 00TABLE movimientoCOMMENTCOMMENT ON TABLE movimiento IS 'Esta tabla almacena los elementos generales que describen un documento contable de cualquier tipo'; publicpostgresfalse1763k 00 movimientoACLREVOKE ALL ON TABLE movimiento FROM PUBLIC; REVOKE ALL ON TABLE movimiento FROM postgres; GRANT ALL ON TABLE movimiento TO postgres; GRANT ALL ON TABLE movimiento TO empresa; publicpostgresfalse1763125963810terceroTABLECREATE TABLE tercero ( tt_id character varying(20) NOT NULL, te_id character varying(20) NOT NULL, te_nombre character varying(120), te_pais character varying(15), te_ciudad text, te_direccion text, te_telefonos text, te_mail character varying(40), te_fax text, te_tipofiscal character varying(60), te_actividad character varying(10), te_comision character(3), te_descuentos character(3), te_observaciones text, te_apellido character varying(40), te_password text ); DROP TABLE public.tercero; publicpostgrestrue6l 00 TABLE terceroCOMMENTCOMMENT ON TABLE tercero IS 'Los terceros son todas aquellas personas naturales o juridicas que tienen relacion con la empresa. Aqui se almacenan sus datos mas importantes.'; publicpostgresfalse1764m 00terceroACLREVOKE ALL ON TABLE tercero FROM PUBLIC; REVOKE ALL ON TABLE tercero FROM postgres; GRANT ALL ON TABLE tercero TO postgres; GRANT ALL ON TABLE tercero TO empresa; publicpostgresfalse1764125963816MOVIMIENTOS EXOGENAVIEW CREATE VIEW "MOVIMIENTOS EXOGENA" AS SELECT i.puc_codigo, (((t.te_nombre)::text || ' '::text) || (t.te_apellido)::text) AS te_nombre, i.te_id, sum(i.imv_db) AS debitos, sum(i.imv_cr) AS creditos, (sum(i.imv_db) - sum(i.imv_cr)) AS saldo FROM ((movimiento m LEFT JOIN item_movimiento i USING (mv_id)) LEFT JOIN tercero t USING (te_id)) WHERE ((m.es_id)::text = '03'::text) GROUP BY i.puc_codigo, i.te_id, t.te_nombre, t.te_apellido ORDER BY i.puc_codigo, (((t.te_nombre)::text || ' '::text) || (t.te_apellido)::text); (DROP VIEW public."MOVIMIENTOS EXOGENA"; publicjulianfalse19466125963821accionesTABLECREATE TABLE acciones ( ac_id integer DEFAULT 1 NOT NULL, ac_nombre character varying(70) NOT NULL, ac_valor boolean DEFAULT false NOT NULL, pf_id character varying(20) DEFAULT '00000001'::character varying NOT NULL ); DROP TABLE public.acciones; publicpostgresfalse2140214121426n 00accionesACLREVOKE ALL ON TABLE acciones FROM PUBLIC; REVOKE ALL ON TABLE acciones FROM postgres; GRANT ALL ON TABLE acciones TO postgres; GRANT ALL ON TABLE acciones TO empresa; publicpostgresfalse1766125963827activosTABLEICREATE TABLE activos ( ac_id character varying(20) NOT NULL, ac_nombre character varying(60), ac_valori double precision, ac_anios double precision, ac_cactivo character varying(20), ac_cgasto character varying(20), ac_fecha_adquisicion timestamp without time zone, cc_id character varying(20) ); DROP TABLE public.activos; publicpostgresfalse6o 00activosACLREVOKE ALL ON TABLE activos FROM PUBLIC; REVOKE ALL ON TABLE activos FROM postgres; GRANT ALL ON TABLE activos TO postgres; GRANT ALL ON TABLE activos TO empresa; publicpostgresfalse1767125963830ajustesxinflacionTABLECREATE TABLE ajustesxinflacion ( aj_id character varying(20) NOT NULL, aj_cbase character varying(20), aj_cdebito character varying(20), aj_ccredito character varying(20), cc_id character varying(20) ); %DROP TABLE public.ajustesxinflacion; publicpostgresfalse6p 00ajustesxinflacionACLREVOKE ALL ON TABLE ajustesxinflacion FROM PUBLIC; REVOKE ALL ON TABLE ajustesxinflacion FROM postgres; GRANT ALL ON TABLE ajustesxinflacion TO postgres; GRANT ALL ON TABLE ajustesxinflacion TO empresa; publicpostgresfalse1768125963833 cancelacionesTABLECREATE TABLE cancelaciones ( ca_id character varying(20) NOT NULL, pen_id character varying(20), mv_id character varying(20), ca_valor double precision ); !DROP TABLE public.cancelaciones; publicpostgrestrue6q 00 cancelacionesACLREVOKE ALL ON TABLE cancelaciones FROM PUBLIC; REVOKE ALL ON TABLE cancelaciones FROM postgres; GRANT ALL ON TABLE cancelaciones TO postgres; GRANT ALL ON TABLE cancelaciones TO empresa; publicpostgresfalse1769125963836categoria_reglaTABLECREATE TABLE categoria_regla ( cr_id character varying(20) NOT NULL, cr_nombre text NOT NULL, cr_visible boolean DEFAULT true NOT NULL, ca_aplica character varying(10) ); #DROP TABLE public.categoria_regla; publicpostgrestrue21436r 00categoria_reglaACLREVOKE ALL ON TABLE categoria_regla FROM PUBLIC; REVOKE ALL ON TABLE categoria_regla FROM postgres; GRANT ALL ON TABLE categoria_regla TO postgres; GRANT ALL ON TABLE categoria_regla TO empresa; publicpostgresfalse1770125963843ccostoTABLE,CREATE TABLE ccosto ( cc_id character varying(20) NOT NULL, cc_id_sup character varying(20), cc_nombre text NOT NULL, cc_pais text, cc_ciudad text, cc_direccion text, cc_sucursal boolean, cc_r_nombre text, cc_r_tel text, cc_r_movil text, cc_r_mail text ); DROP TABLE public.ccosto; publicpostgrestrue6s 00 TABLE ccostoCOMMENTuCOMMENT ON TABLE ccosto IS 'Esta tabla lista todos los centros de costos de una empresa. Estra tabla es recursiva.'; publicpostgresfalse1771t 00ccostoACLxREVOKE ALL ON TABLE ccosto FROM PUBLIC; REVOKE ALL ON TABLE ccosto FROM postgres; GRANT ALL ON TABLE ccosto TO empresa; publicpostgresfalse1771125963849cicloTABLECREATE TABLE ciclo ( ci_id character varying(20) NOT NULL, ci_fecha_incio date NOT NULL, ci_fecha_cierre date, ci_anio character varying(4) NOT NULL, ci_actual boolean DEFAULT true NOT NULL ); DROP TABLE public.ciclo; publicpostgrestrue21446u 00 TABLE cicloCOMMENTCOMMENT ON TABLE ciclo IS 'Las empresas manejan ciclos contables de por lo menos un ao. Aqui se almacenan datos relativos a los ciclos cursados por las empresas, y cual de esos ciclos estan activos en el momento.'; publicpostgresfalse1772v 00cicloACLuREVOKE ALL ON TABLE ciclo FROM PUBLIC; REVOKE ALL ON TABLE ciclo FROM postgres; GRANT ALL ON TABLE ciclo TO empresa; publicpostgresfalse1772125963853conceptos_nominaTABLECREATE TABLE conceptos_nomina ( co_id character varying(20) NOT NULL, co_nombre text NOT NULL, co_debito character varying(20) NOT NULL, co_credito character varying(20) NOT NULL, co_obligatorio boolean DEFAULT false NOT NULL, co_adicional boolean DEFAULT false NOT NULL, co_activo boolean DEFAULT true NOT NULL, co_orden bigint DEFAULT 0 NOT NULL ); $DROP TABLE public.conceptos_nomina; publicpostgrestrue21452146214721486w 00conceptos_nominaACLREVOKE ALL ON TABLE conceptos_nomina FROM PUBLIC; REVOKE ALL ON TABLE conceptos_nomina FROM postgres; GRANT ALL ON TABLE conceptos_nomina TO postgres; GRANT ALL ON TABLE conceptos_nomina TO empresa; publicpostgresfalse1773125963863cuentasTABLECREATE TABLE cuentas ( puc_codigo character varying(20) NOT NULL, pe_id character varying(20) NOT NULL, puc_debito double precision DEFAULT 0, puc_credito double precision DEFAULT 0 ); DROP TABLE public.cuentas; publicpostgrestrue214921506x 00 TABLE cuentasCOMMENTCOMMENT ON TABLE cuentas IS 'Aqui se almacenan los saldos de las cuentas sobre los comprobantes contabilizados. Esta tabla tiene como llave primaria el cdigo de la cuenta concatenado con el ciclo actual.'; publicpostgresfalse1774y 00cuentasACL{REVOKE ALL ON TABLE cuentas FROM PUBLIC; REVOKE ALL ON TABLE cuentas FROM postgres; GRANT ALL ON TABLE cuentas TO empresa; publicpostgresfalse1774125963868 cuentas_infoTABLECREATE TABLE cuentas_info ( puc_codigo character varying(20) NOT NULL, pe_id character varying(20) NOT NULL, puc_debito double precision, puc_credito double precision, cc_id character varying(20) NOT NULL ); DROP TABLE public.cuentas_info; publicpostgresfalse6z 00 cuentas_infoACLREVOKE ALL ON TABLE cuentas_info FROM PUBLIC; REVOKE ALL ON TABLE cuentas_info FROM postgres; GRANT ALL ON TABLE cuentas_info TO postgres; GRANT ALL ON TABLE cuentas_info TO empresa; publicpostgresfalse1775125963871cuentas_monedasTABLE$CREATE TABLE cuentas_monedas ( cm_id character varying(20) NOT NULL, cm_corigen character varying(20), cm_corden character varying(20), cm_corden_contra character varying(20), cm_ingreso_correccion character varying(20), cm_perdida_correccion character varying(20) ); #DROP TABLE public.cuentas_monedas; publicpostgresfalse6{ 00cuentas_monedasACLREVOKE ALL ON TABLE cuentas_monedas FROM PUBLIC; REVOKE ALL ON TABLE cuentas_monedas FROM postgres; GRANT ALL ON TABLE cuentas_monedas TO postgres; GRANT ALL ON TABLE cuentas_monedas TO empresa; publicpostgresfalse1776125963874empresaTABLElCREATE TABLE empresa ( em_codigo character varying(70) NOT NULL, em_valor character varying(100) ); DROP TABLE public.empresa; publicpostgrestrue6| 00 TABLE empresaCOMMENTyCOMMENT ON TABLE empresa IS 'Aqui se almacena la informacion general de la empresa. Esta tabla solo almacena un campo.'; publicpostgresfalse1777} 00empresaACLREVOKE ALL ON TABLE empresa FROM PUBLIC; REVOKE ALL ON TABLE empresa FROM postgres; GRANT ALL ON TABLE empresa TO postgres; GRANT ALL ON TABLE empresa TO afiliados; GRANT ALL ON TABLE empresa TO empresa; publicpostgresfalse1777125963877estadoTABLECREATE TABLE estado ( es_id character varying(20) NOT NULL, es_nombre character varying(20) NOT NULL, es_descripcion text ); DROP TABLE public.estado; publicpostgrestrue6~ 00 TABLE estadoCOMMENTCOMMENT ON TABLE estado IS 'El estado describe en que situacion se encuentra un movimiento de contabilidad, por ejemplo, pendiente o contabilizado '; publicpostgresfalse1778 00estadoACLxREVOKE ALL ON TABLE estado FROM PUBLIC; REVOKE ALL ON TABLE estado FROM postgres; GRANT ALL ON TABLE estado TO empresa; publicpostgresfalse1778125963883estado_cperiodoTABLECREATE TABLE estado_cperiodo ( ec_id integer NOT NULL, pe_id character varying(20), ec_estado boolean DEFAULT false ); #DROP TABLE public.estado_cperiodo; publicpostgresfalse21516 00estado_cperiodoACLdREVOKE ALL ON TABLE estado_cperiodo FROM PUBLIC; REVOKE ALL ON TABLE estado_cperiodo FROM postgres; GRANT ALL ON TABLE estado_cperiodo TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE estado_cperiodo TO PUBLIC; GRANT ALL ON TABLE estado_cperiodo TO david; GRANT ALL ON TABLE estado_cperiodo TO julian; GRANT ALL ON TABLE estado_cperiodo TO empresa; publicpostgresfalse1779125963887exogenaVIEWCREATE VIEW exogena AS SELECT i.puc_codigo, (((t.te_nombre)::text || ' '::text) || (t.te_apellido)::text) AS te_nombre, i.te_id, sum(i.imv_db) AS debitos, sum(i.imv_cr) AS creditos, (sum(i.imv_db) - sum(i.imv_cr)) AS saldo FROM ((movimiento m LEFT JOIN item_movimiento i USING (mv_id)) LEFT JOIN tercero t USING (te_id)) WHERE ((m.es_id)::text = '03'::text) GROUP BY i.puc_codigo, i.te_id, t.te_nombre, t.te_apellido ORDER BY i.puc_codigo, (((t.te_nombre)::text || ' '::text) || (t.te_apellido)::text); DROP VIEW public.exogena; publicjulianfalse19476125963892fac_item_movimientoTABLEKCREATE TABLE fac_item_movimiento ( imv_id character varying(20) NOT NULL, mv_id character varying(20) NOT NULL, pro_id character varying(20), bo_id character varying(20), imv_cantidad double precision NOT NULL, imv_valor double precision NOT NULL, imv_dcto double precision, imv_descripcion text ); 'DROP TABLE public.fac_item_movimiento; publicpostgrestrue6 00fac_item_movimientoACLREVOKE ALL ON TABLE fac_item_movimiento FROM PUBLIC; REVOKE ALL ON TABLE fac_item_movimiento FROM postgres; GRANT ALL ON TABLE fac_item_movimiento TO postgres; GRANT ALL ON TABLE fac_item_movimiento TO empresa; publicpostgresfalse1781125963898fac_item_pagosTABLECREATE TABLE fac_item_pagos ( imv_id character varying(20) NOT NULL, mv_id character varying(20) NOT NULL, cc_id character varying(20), mv_origen character varying(20), puc_codigo character varying(20), ip_valor double precision ); "DROP TABLE public.fac_item_pagos; publicjulianfalse6 00fac_item_pagosACLREVOKE ALL ON TABLE fac_item_pagos FROM PUBLIC; REVOKE ALL ON TABLE fac_item_pagos FROM julian; GRANT ALL ON TABLE fac_item_pagos TO julian; GRANT ALL ON TABLE fac_item_pagos TO empresa; publicjulianfalse1782125963901fac_movimientoTABLECREATE TABLE fac_movimiento ( mv_id character varying(20) NOT NULL, tm_id character varying(20) NOT NULL, us_id character varying(20), pe_id character varying(20), mv_fecha_preparacion timestamp without time zone, mv_dia_contabilizacion character varying(2) NOT NULL, mv_total double precision, mv_observaciones text, mv_recibido text, mv_entregado text, mv_revisado text, mv_numero character varying(20), mv_terceronombre character varying(100), mv_terceronit character varying(20), mv_ciudad character varying(50), mv_direccion character varying(100), mv_estado boolean DEFAULT false, mv_mvinventario character varying(20), cc_id character varying(20), mo_sigla character varying(20), mv_mvcontabilidad character varying(20), mv_tasa character varying(20), mv_tipofac character varying(50), mv_adelanto double precision ); "DROP TABLE public.fac_movimiento; publicpostgrestrue21536 00fac_movimientoACLREVOKE ALL ON TABLE fac_movimiento FROM PUBLIC; REVOKE ALL ON TABLE fac_movimiento FROM postgres; GRANT ALL ON TABLE fac_movimiento TO postgres; GRANT ALL ON TABLE fac_movimiento TO empresa; publicpostgresfalse1783125963908fac_numeracionTABLECREATE TABLE fac_numeracion ( nu_id character varying(20) NOT NULL, tm_id character varying(20), nu_prefijo character varying(10) NOT NULL, nu_descripcion text, nu_inicio character varying(20), nu_final character varying(20) ); "DROP TABLE public.fac_numeracion; publicpostgrestrue6 00fac_numeracionACLREVOKE ALL ON TABLE fac_numeracion FROM PUBLIC; REVOKE ALL ON TABLE fac_numeracion FROM postgres; GRANT ALL ON TABLE fac_numeracion TO postgres; GRANT ALL ON TABLE fac_numeracion TO empresa; publicpostgresfalse1784125963914 fac_pagosTABLE0CREATE TABLE fac_pagos ( mv_id character varying(20) NOT NULL, tm_id character varying(20) NOT NULL, us_id character varying(20), pe_id character varying(20), mv_fecha_preparacion timestamp without time zone, mv_dia_contabilizacion character varying(2) NOT NULL, mv_total double precision, mv_observaciones text, mv_autorizado text, mv_revisado text, mv_numero character varying(20), mv_terceronombre character varying(100), mv_terceronit character varying(20), mv_estado boolean DEFAULT false, cc_id character varying(20), mv_mvcontabilidad character varying(20), mv_tipo_pago character varying(2), mv_soporte character varying(50), mv_cuenta character varying(20), mo_sigla character varying(20), mo_tasa character varying(20) ); DROP TABLE public.fac_pagos; publicjuliantrue21546 00 fac_pagosACLREVOKE ALL ON TABLE fac_pagos FROM PUBLIC; REVOKE ALL ON TABLE fac_pagos FROM julian; GRANT ALL ON TABLE fac_pagos TO julian; GRANT ALL ON TABLE fac_pagos TO empresa; publicjulianfalse1785125963921fac_reglas_productoTABLECREATE TABLE fac_reglas_producto ( re_id character varying(20), pro_id character varying(20), imv_id character varying(20), mv_id character varying(20), rp_valoru double precision NOT NULL, id integer NOT NULL ); 'DROP TABLE public.fac_reglas_producto; publicpostgrestrue6 00fac_reglas_productoACLREVOKE ALL ON TABLE fac_reglas_producto FROM PUBLIC; REVOKE ALL ON TABLE fac_reglas_producto FROM postgres; GRANT ALL ON TABLE fac_reglas_producto TO postgres; GRANT ALL ON TABLE fac_reglas_producto TO empresa; publicpostgresfalse1786125963924fac_tipo_movimientoTABLECREATE TABLE fac_tipo_movimiento ( tm_id character varying(20) NOT NULL, tm_nombre character varying(100) NOT NULL, tm_descripcion text, tm_prefijo_default character varying(10), tm_tipo character varying(10) ); 'DROP TABLE public.fac_tipo_movimiento; publicpostgrestrue6 00fac_tipo_movimientoACLREVOKE ALL ON TABLE fac_tipo_movimiento FROM PUBLIC; REVOKE ALL ON TABLE fac_tipo_movimiento FROM postgres; GRANT ALL ON TABLE fac_tipo_movimiento TO postgres; GRANT ALL ON TABLE fac_tipo_movimiento TO empresa; publicpostgresfalse1787125963930 funcionesTABLECREATE TABLE funciones ( fu_id character varying(20) NOT NULL, fu_nombre character varying(50) NOT NULL, fu_descripcion text, fu_prototipo character varying(200), fu_archivo character varying(50) NOT NULL, fu_tipo character varying(10) ); DROP TABLE public.funciones; publicpostgrestrue6 00TABLE funcionesCOMMENTCOMMENT ON TABLE funciones IS 'Esta tabla relaciona la lista de funciones disponibles para la aplicacion. Entre las funciones se pueden considerar desde los calculos de IVA y retefuente hasta los calculos de depreciacion acumulada y ajustes por inflacion al final del periodo.'; publicpostgresfalse1788 00 funcionesACLREVOKE ALL ON TABLE funciones FROM PUBLIC; REVOKE ALL ON TABLE funciones FROM postgres; GRANT ALL ON TABLE funciones TO empresa; publicpostgresfalse1788125963936 inv_bodegasTABLECREATE TABLE inv_bodegas ( bo_id character varying(20) NOT NULL, bo_nombre character varying(50) NOT NULL, bo_descripcion text, bo_punto_venta boolean ); DROP TABLE public.inv_bodegas; publicpostgrestrue6 00 inv_bodegasACLREVOKE ALL ON TABLE inv_bodegas FROM PUBLIC; REVOKE ALL ON TABLE inv_bodegas FROM postgres; GRANT ALL ON TABLE inv_bodegas TO postgres; GRANT ALL ON TABLE inv_bodegas TO empresa; publicpostgresfalse1789125963942inv_categoriasTABLE?CREATE TABLE inv_categorias ( ca_id character varying(20) NOT NULL, puc_inventario character varying(20), puc_gasto character varying(20), puc_ingreso character varying(20), puc_costo character varying(20), puc_dev_des character varying(20), puc_proveedor character varying(20), puc_cliente character varying(20), ca_nombre text NOT NULL, ca_ctr_inventario boolean, ca_ctr_consumo boolean, ca_ctr_venta boolean, puc_aprove character varying(20), puc_perdida character varying(20), puc_caja character varying(20) ); "DROP TABLE public.inv_categorias; publicpostgrestrue6 00inv_categoriasACLREVOKE ALL ON TABLE inv_categorias FROM PUBLIC; REVOKE ALL ON TABLE inv_categorias FROM postgres; GRANT ALL ON TABLE inv_categorias TO postgres; GRANT ALL ON TABLE inv_categorias TO empresa; publicpostgresfalse1790125963948 inv_familiasTABLECREATE TABLE inv_familias ( fa_id character varying(20) NOT NULL, inv_fa_id character varying(20), fa_nombre character varying(80) NOT NULL, fa_descripcion text ); DROP TABLE public.inv_familias; publicpostgrestrue6 00 inv_familiasACLREVOKE ALL ON TABLE inv_familias FROM PUBLIC; REVOKE ALL ON TABLE inv_familias FROM postgres; GRANT ALL ON TABLE inv_familias TO postgres; GRANT ALL ON TABLE inv_familias TO empresa; publicpostgresfalse1791125963954inv_formas_pagoTABLECREATE TABLE inv_formas_pago ( fp_id character varying(20) NOT NULL, fp_nombre character varying(50) NOT NULL, fp_termino bigint, fp_descuento double precision, fp_interes_mes double precision ); #DROP TABLE public.inv_formas_pago; publicpostgrestrue6 00inv_formas_pagoACLREVOKE ALL ON TABLE inv_formas_pago FROM PUBLIC; REVOKE ALL ON TABLE inv_formas_pago FROM postgres; GRANT ALL ON TABLE inv_formas_pago TO postgres; GRANT ALL ON TABLE inv_formas_pago TO empresa; publicpostgresfalse1792125963957inv_item_movimientoTABLECREATE TABLE inv_item_movimiento ( imv_id character varying(20) NOT NULL, mv_id character varying(20) NOT NULL, pro_id character varying(20), bo_id character varying(20), imv_cantidad double precision NOT NULL, imv_valor double precision NOT NULL, imv_entrada boolean NOT NULL, imv_nacionalizada boolean, imv_umedida double precision, imv_serial character varying, imv_ubicacion text ); 'DROP TABLE public.inv_item_movimiento; publicpostgrestrue6 00inv_item_movimientoACLREVOKE ALL ON TABLE inv_item_movimiento FROM PUBLIC; REVOKE ALL ON TABLE inv_item_movimiento FROM postgres; GRANT ALL ON TABLE inv_item_movimiento TO postgres; GRANT ALL ON TABLE inv_item_movimiento TO empresa; publicpostgresfalse1793125963963inv_item_tarjaTABLECREATE TABLE inv_item_tarja ( imv_id character varying(20) NOT NULL, mv_tarja character varying(20) NOT NULL, mv_inventario character varying(20) NOT NULL, mv_item_inventario character varying(20) NOT NULL ); "DROP TABLE public.inv_item_tarja; publicpostgrestrue6 00inv_item_tarjaACLREVOKE ALL ON TABLE inv_item_tarja FROM PUBLIC; REVOKE ALL ON TABLE inv_item_tarja FROM postgres; GRANT ALL ON TABLE inv_item_tarja TO postgres; GRANT ALL ON TABLE inv_item_tarja TO empresa; publicpostgresfalse1794125963966inv_items_portafolioTABLECREATE TABLE inv_items_portafolio ( ip_id character varying(20) NOT NULL, pp_id character varying(20) NOT NULL, pro_id character varying(20) NOT NULL ); (DROP TABLE public.inv_items_portafolio; publicpostgrestrue6 00inv_items_portafolioACLREVOKE ALL ON TABLE inv_items_portafolio FROM PUBLIC; REVOKE ALL ON TABLE inv_items_portafolio FROM postgres; GRANT ALL ON TABLE inv_items_portafolio TO postgres; GRANT ALL ON TABLE inv_items_portafolio TO empresa; publicpostgresfalse1795125963969inv_listas_preciosTABLECREATE TABLE inv_listas_precios ( lp_id character varying(20) NOT NULL, lp_nombre character varying(100) NOT NULL, lp_descripcion text ); &DROP TABLE public.inv_listas_precios; publicpostgrestrue6 00inv_listas_preciosACLREVOKE ALL ON TABLE inv_listas_precios FROM PUBLIC; REVOKE ALL ON TABLE inv_listas_precios FROM postgres; GRANT ALL ON TABLE inv_listas_precios TO postgres; GRANT ALL ON TABLE inv_listas_precios TO empresa; publicpostgresfalse1796125963975inv_movimientoTABLECREATE TABLE inv_movimiento ( mv_id character varying(20) NOT NULL, tm_id character varying(20) NOT NULL, us_preparo character varying(20) NOT NULL, pe_id character varying(20), mv_fecha_preparacion timestamp without time zone, mv_dia_contabilizacion character varying(2) NOT NULL, mv_total double precision, mv_observaciones text, mv_recibido text, mv_entregado text, mv_revisado text, mv_numero character varying(20), mv_mvcontabilidad character varying(20), mv_terceronombre character varying(120), mv_terceronit character varying(20), us_aprobo character varying(20), mv_fecha_aprobacion time without time zone ); "DROP TABLE public.inv_movimiento; publicpostgrestrue6 00inv_movimientoACLREVOKE ALL ON TABLE inv_movimiento FROM PUBLIC; REVOKE ALL ON TABLE inv_movimiento FROM postgres; GRANT ALL ON TABLE inv_movimiento TO postgres; GRANT ALL ON TABLE inv_movimiento TO empresa; publicpostgresfalse1797125963981inv_numeracionTABLECREATE TABLE inv_numeracion ( nu_id character varying(20) NOT NULL, tm_id character varying(20), nu_prefijo character varying(10) NOT NULL, nu_descripcion text, nu_inicio character varying(20), nu_final character varying(20) ); "DROP TABLE public.inv_numeracion; publicpostgrestrue6 00inv_numeracionACLREVOKE ALL ON TABLE inv_numeracion FROM PUBLIC; REVOKE ALL ON TABLE inv_numeracion FROM postgres; GRANT ALL ON TABLE inv_numeracion TO postgres; GRANT ALL ON TABLE inv_numeracion TO empresa; publicpostgresfalse1798125963987inv_portafoliosTABLECREATE TABLE inv_portafolios ( pp_id character varying(20) NOT NULL, pp_nombre character varying(100) NOT NULL, pp_descripcion text ); #DROP TABLE public.inv_portafolios; publicpostgrestrue6 00inv_portafoliosACLREVOKE ALL ON TABLE inv_portafolios FROM PUBLIC; REVOKE ALL ON TABLE inv_portafolios FROM postgres; GRANT ALL ON TABLE inv_portafolios TO postgres; GRANT ALL ON TABLE inv_portafolios TO empresa; publicpostgresfalse1799125963993 inv_preciosTABLECREATE TABLE inv_precios ( pro_id character varying(20) NOT NULL, lp_id character varying(20) NOT NULL, pr_precio double precision, pr_porcentaje double precision, pr_por_costo boolean ); DROP TABLE public.inv_precios; publicpostgrestrue6 00 inv_preciosACLREVOKE ALL ON TABLE inv_precios FROM PUBLIC; REVOKE ALL ON TABLE inv_precios FROM postgres; GRANT ALL ON TABLE inv_precios TO postgres; GRANT ALL ON TABLE inv_precios TO empresa; publicpostgresfalse1800 125963996 inv_productosTABLERCREATE TABLE inv_productos ( pro_id character varying(20) NOT NULL, fa_id character varying(20), un_id character varying(20), ca_id character varying(20), tp_id character varying(20), pro_nombre text NOT NULL, pro_descripcion text, pro_tiempodevida integer, pro_stock_max double precision, pro_stock_min double precision, pro_presentacion text, pro_marca text, pro_serial character varying(100), pro_cod_barras character varying(50), pro_estado text, pro_costo_base double precision, pro_maneja_kilos boolean DEFAULT false ); !DROP TABLE public.inv_productos; publicpostgrestrue21566 00 inv_productosACLREVOKE ALL ON TABLE inv_productos FROM PUBLIC; REVOKE ALL ON TABLE inv_productos FROM postgres; GRANT ALL ON TABLE inv_productos TO postgres; GRANT ALL ON TABLE inv_productos TO empresa; publicpostgresfalse1801 125964003inv_propiedades_productoTABLECREATE TABLE inv_propiedades_producto ( prop_id character varying(20) NOT NULL, pro_id character varying(20) NOT NULL, prop_nombre text NOT NULL, prop_valor text ); ,DROP TABLE public.inv_propiedades_producto; publicpostgrestrue6 00inv_propiedades_productoACLREVOKE ALL ON TABLE inv_propiedades_producto FROM PUBLIC; REVOKE ALL ON TABLE inv_propiedades_producto FROM postgres; GRANT ALL ON TABLE inv_propiedades_producto TO postgres; GRANT ALL ON TABLE inv_propiedades_producto TO empresa; publicpostgresfalse1802 125964009inv_reglas_productoTABLECREATE TABLE inv_reglas_producto ( re_id character varying(20) NOT NULL, pro_id character varying(20) NOT NULL, rp_compra boolean NOT NULL ); 'DROP TABLE public.inv_reglas_producto; publicpostgrestrue6 00inv_reglas_productoACLREVOKE ALL ON TABLE inv_reglas_producto FROM PUBLIC; REVOKE ALL ON TABLE inv_reglas_producto FROM postgres; GRANT ALL ON TABLE inv_reglas_producto TO postgres; GRANT ALL ON TABLE inv_reglas_producto TO empresa; publicpostgresfalse1803 125964012inv_reglas_terceroTABLECREATE TABLE inv_reglas_tercero ( te_id character varying(20) NOT NULL, re_id character varying(20) NOT NULL, rt_compra boolean NOT NULL ); &DROP TABLE public.inv_reglas_tercero; publicpostgrestrue6 00inv_reglas_terceroACLREVOKE ALL ON TABLE inv_reglas_tercero FROM PUBLIC; REVOKE ALL ON TABLE inv_reglas_tercero FROM postgres; GRANT ALL ON TABLE inv_reglas_tercero TO postgres; GRANT ALL ON TABLE inv_reglas_tercero TO empresa; publicpostgresfalse1804 125964015 inv_saldosTABLE CREATE TABLE inv_saldos ( sa_id character varying(20) NOT NULL, imv_id character varying(20), mv_id character varying(20), bo_id character varying(20), pro_id character varying(20), sa_cantidad double precision NOT NULL, sa_valoru double precision NOT NULL ); DROP TABLE public.inv_saldos; publicpostgrestrue6 00 inv_saldosACLREVOKE ALL ON TABLE inv_saldos FROM PUBLIC; REVOKE ALL ON TABLE inv_saldos FROM postgres; GRANT ALL ON TABLE inv_saldos TO postgres; GRANT ALL ON TABLE inv_saldos TO empresa; publicpostgresfalse1805125964018inv_subproductosTABLECREATE TABLE inv_subproductos ( pro_id character varying(20) NOT NULL, inv_pro_id character varying(20) NOT NULL, pa_porcentaje_costo double precision, pa_cantidad double precision ); $DROP TABLE public.inv_subproductos; publicpostgrestrue6 00inv_subproductosACLREVOKE ALL ON TABLE inv_subproductos FROM PUBLIC; REVOKE ALL ON TABLE inv_subproductos FROM postgres; GRANT ALL ON TABLE inv_subproductos TO postgres; GRANT ALL ON TABLE inv_subproductos TO empresa; publicpostgresfalse1806125964021 inv_tarjaTABLECREATE TABLE inv_tarja ( mv_id character varying(20) NOT NULL, us_preparo character varying(20) NOT NULL, pe_id character varying(20), mv_fecha_preparacion timestamp without time zone, mv_dia_contabilizacion character varying(2) NOT NULL, mv_observaciones text, mv_numero character varying(20), mv_terceronombre character varying(120), mv_terceronit character varying(20), mv_num_transporte character varying(50), mv_tip_transporte character varying(10), mv_hora_llegada interval, mv_hora_inicio interval, mv_hora_final interval, mv_hora_salida interval, mv_empresa text, mv_placa text, mv_tipo_carroceria text, mv_contenedor text, mv_l_carpa text, mv_l_techo text, mv_l_piso text, mv_l_paredes text, mv_l_puertas text, mv_l_aseo text, mv_l_precintos text, mv_l_embalaje text, mv_l_producto text, mv_l_clima text, bo_id character varying(20), mv_funcionario text, mv_conductor text, mv_tipo character varying(20) ); DROP TABLE public.inv_tarja; publicpostgrestrue6 00 inv_tarjaACLREVOKE ALL ON TABLE inv_tarja FROM PUBLIC; REVOKE ALL ON TABLE inv_tarja FROM postgres; GRANT ALL ON TABLE inv_tarja TO postgres; GRANT ALL ON TABLE inv_tarja TO empresa; publicpostgresfalse1807125964027inv_tipo_movimientoTABLECREATE TABLE inv_tipo_movimiento ( tm_id character varying(20) NOT NULL, tm_nombre character varying(100) NOT NULL, tm_descripcion text, tm_prefijo_default character varying(10), tm_tipo character varying(10) ); 'DROP TABLE public.inv_tipo_movimiento; publicpostgrestrue6 00inv_tipo_movimientoACLREVOKE ALL ON TABLE inv_tipo_movimiento FROM PUBLIC; REVOKE ALL ON TABLE inv_tipo_movimiento FROM postgres; GRANT ALL ON TABLE inv_tipo_movimiento TO postgres; GRANT ALL ON TABLE inv_tipo_movimiento TO empresa; publicpostgresfalse1808125964033inv_tipo_productoTABLECREATE TABLE inv_tipo_producto ( tp_id character varying(20) NOT NULL, tp_nombre character varying(50) NOT NULL, tp_descripcion text ); %DROP TABLE public.inv_tipo_producto; publicpostgrestrue6 00inv_tipo_productoACLREVOKE ALL ON TABLE inv_tipo_producto FROM PUBLIC; REVOKE ALL ON TABLE inv_tipo_producto FROM postgres; GRANT ALL ON TABLE inv_tipo_producto TO postgres; GRANT ALL ON TABLE inv_tipo_producto TO empresa; publicpostgresfalse1809125964039 inv_unidadesTABLECREATE TABLE inv_unidades ( un_id character varying(20) NOT NULL, un_nombre character varying(50) NOT NULL, un_sigla character varying(5) NOT NULL, un_descripcion text ); DROP TABLE public.inv_unidades; publicpostgrestrue6 00 inv_unidadesACLREVOKE ALL ON TABLE inv_unidades FROM PUBLIC; REVOKE ALL ON TABLE inv_unidades FROM postgres; GRANT ALL ON TABLE inv_unidades TO postgres; GRANT ALL ON TABLE inv_unidades TO empresa; publicpostgresfalse1810125964045 item_nominasTABLECREATE TABLE item_nominas ( in_id character varying(20) NOT NULL, no_id character varying(20), co_id character varying(20), in_valor double precision ); DROP TABLE public.item_nominas; publicpostgresfalse6 00 item_nominasACLREVOKE ALL ON TABLE item_nominas FROM PUBLIC; REVOKE ALL ON TABLE item_nominas FROM postgres; GRANT ALL ON TABLE item_nominas TO postgres; GRANT ALL ON TABLE item_nominas TO empresa; publicpostgresfalse1811125964048logsTABLE CREATE TABLE logs ( log_id character varying(20) NOT NULL, log_error_cod text, us_id character varying(20), log_timestamp timestamp without time zone DEFAULT ('now'::text)::timestamp(6) without time zone NOT NULL, log_msj text, log_pag text ); DROP TABLE public.logs; publicpostgrestrue21576 00 TABLE logsCOMMENTCOMMENT ON TABLE logs IS 'En esta tabla se almacena el historial de movimientos contables realizados en el sistema y el historial de errores realizados por los usuarios'; publicpostgresfalse1812 00logsACLrREVOKE ALL ON TABLE logs FROM PUBLIC; REVOKE ALL ON TABLE logs FROM postgres; GRANT ALL ON TABLE logs TO empresa; publicpostgresfalse1812125964055listado de cambios en productosVIEWCREATE VIEW "listado de cambios en productos" AS SELECT logs.log_msj FROM logs WHERE (((logs.log_timestamp > '2007-03-30 00:00:00'::timestamp without time zone) AND (logs.log_msj ~~ '%inv_productos%'::text)) AND (logs.log_msj !~~ '%ERROR%'::text)) ORDER BY logs.log_timestamp; 4DROP VIEW public."listado de cambios en productos"; publicjulianfalse19486125964059monedaTABLECREATE TABLE moneda ( mo_id date NOT NULL, mo_nativa_nombre character varying(3) NOT NULL, mo_nativa_valor numeric(9,2), mo_usd numeric(9,2), mo_eur numeric(9,2) ); DROP TABLE public.moneda; publicpostgrestrue6 00monedaACLREVOKE ALL ON TABLE moneda FROM PUBLIC; REVOKE ALL ON TABLE moneda FROM postgres; GRANT ALL ON TABLE moneda TO postgres; GRANT ALL ON TABLE moneda TO empresa; publicpostgresfalse1814125964062monedasTABLECREATE TABLE monedas ( mo_sigla character varying(10) NOT NULL, mo_nombre text, mo_local boolean DEFAULT false NOT NULL ); DROP TABLE public.monedas; publicpostgrestrue21586 00 TABLE monedasCOMMENTICOMMENT ON TABLE monedas IS 'Tabla para manejar la gestion de monedas.'; publicpostgresfalse1815 00monedasACLREVOKE ALL ON TABLE monedas FROM PUBLIC; REVOKE ALL ON TABLE monedas FROM postgres; GRANT ALL ON TABLE monedas TO postgres; GRANT ALL ON TABLE monedas TO empresa; publicpostgresfalse1815125964069movi_depreciacionTABLECREATE TABLE movi_depreciacion ( md_id character varying(20) NOT NULL, mv_id character varying(20), ac_id character varying(20) ); %DROP TABLE public.movi_depreciacion; publicpostgresfalse6 00movi_depreciacionACLREVOKE ALL ON TABLE movi_depreciacion FROM PUBLIC; REVOKE ALL ON TABLE movi_depreciacion FROM postgres; GRANT ALL ON TABLE movi_depreciacion TO postgres; GRANT ALL ON TABLE movi_depreciacion TO empresa; publicpostgresfalse1816125964072nominasTABLECREATE TABLE nominas ( no_id character varying(20) NOT NULL, te_id character varying(20), no_cargo character varying(50), no_observaciones text, cc_id character varying(20) ); DROP TABLE public.nominas; publicpostgresfalse6 00nominasACLREVOKE ALL ON TABLE nominas FROM PUBLIC; REVOKE ALL ON TABLE nominas FROM postgres; GRANT ALL ON TABLE nominas TO postgres; GRANT ALL ON TABLE nominas TO empresa; publicpostgresfalse1817125964078 numeracionTABLECREATE TABLE numeracion ( nu_id character varying(20) NOT NULL, nu_prefijo character varying(10) NOT NULL, nu_descripcion text, tm_id character varying(20), nu_inicio character varying(20) NOT NULL, nu_final character varying(20) ); DROP TABLE public.numeracion; publicpostgrestrue6 00TABLE numeracionCOMMENTzCOMMENT ON TABLE numeracion IS 'Tabla que se encarga de establecer la numeracion de los diferentes documentos contables'; publicpostgresfalse1818 00 numeracionACLREVOKE ALL ON TABLE numeracion FROM PUBLIC; REVOKE ALL ON TABLE numeracion FROM postgres; GRANT ALL ON TABLE numeracion TO postgres; GRANT ALL ON TABLE numeracion TO empresa; publicpostgresfalse1818125964084 op_adjuntosTABLE8CREATE TABLE op_adjuntos ( ad_id bigint NOT NULL, ad_nombre text, ad_tipo text NOT NULL, ad_path text NOT NULL, me_fecha timestamp without time zone NOT NULL, of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL ); DROP TABLE public.op_adjuntos; publicpostgrestrue6 00 op_adjuntosACLREVOKE ALL ON TABLE op_adjuntos FROM PUBLIC; REVOKE ALL ON TABLE op_adjuntos FROM postgres; GRANT ALL ON TABLE op_adjuntos TO postgres; publicpostgresfalse1819125964090op_cargaTABLEvCREATE TABLE op_carga ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, ca_id bigint NOT NULL, tco_id character varying(20), ca_numero character varying(11) NOT NULL, ca_peso double precision, ca_descripcion text, ca_desc_dtm text, te_id character varying(20) ); DROP TABLE public.op_carga; publicpostgrestrue6 00op_cargaACLREVOKE ALL ON TABLE op_carga FROM PUBLIC; REVOKE ALL ON TABLE op_carga FROM postgres; GRANT ALL ON TABLE op_carga TO postgres; publicpostgresfalse1820125964096 op_ciudadesTABLE~CREATE TABLE op_ciudades ( ci_id character varying(20) NOT NULL, ci_nombre text, ci_pais character varying(50) ); DROP TABLE public.op_ciudades; publicpostgrestrue6 00 op_ciudadesACLREVOKE ALL ON TABLE op_ciudades FROM PUBLIC; REVOKE ALL ON TABLE op_ciudades FROM postgres; GRANT ALL ON TABLE op_ciudades TO postgres; publicpostgresfalse1821125964102op_contabilidadTABLECREATE TABLE op_contabilidad ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, imv_id character varying(20) NOT NULL, mv_id character varying(20) NOT NULL ); #DROP TABLE public.op_contabilidad; publicpostgresfalse6 00TABLE op_contabilidadCOMMENTCOMMENT ON TABLE op_contabilidad IS 'Permite relacionar las ordenes de operaciones (DO) con los comprobantes de contabilidad'; publicpostgresfalse1822 00op_contabilidadACLREVOKE ALL ON TABLE op_contabilidad FROM PUBLIC; REVOKE ALL ON TABLE op_contabilidad FROM postgres; GRANT ALL ON TABLE op_contabilidad TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_contabilidad TO empresa; publicpostgresfalse1822125964105 op_diarioTABLECREATE TABLE op_diario ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, of_puerto character varying(20) NOT NULL ); DROP TABLE public.op_diario; publicjuliantrue6 00 op_diarioACL~REVOKE ALL ON TABLE op_diario FROM PUBLIC; REVOKE ALL ON TABLE op_diario FROM julian; GRANT ALL ON TABLE op_diario TO julian; publicjulianfalse1823 125964108op_dtmTABLECREATE TABLE op_dtm ( od_id character varying(20) NOT NULL, of_id character varying(20), do_anio character varying(2), do_numero character varying(20), od_numero character varying(20), od_consignor text, od_shipping text, od_dir_consignor text, od_dir_shipping text, od_modorgdest1 text, od_modorgdest2 text, od_modorgdest3 text, od_modorgdest4 text, od_intruc_manejo text, od_fecha_entrega date, od_originaldtm text, od_tipocarga character varying(20), od_lugarentrega text, od_valor text, od_observaciones text, od_prepaid text, od_currencypre text, od_collect text, od_currencycoll text, od_lugarexp text, od_firma text, od_fechaexp date ); DROP TABLE public.op_dtm; publicpostgresfalse6 00op_dtmACLyREVOKE ALL ON TABLE op_dtm FROM PUBLIC; REVOKE ALL ON TABLE op_dtm FROM postgres; GRANT ALL ON TABLE op_dtm TO postgres; publicpostgresfalse1824!125964114 op_estadosTABLEZCREATE TABLE op_estados ( es_id character varying(20) NOT NULL, es_nombre text ); DROP TABLE public.op_estados; publicpostgrestrue6 00 op_estadosACLREVOKE ALL ON TABLE op_estados FROM PUBLIC; REVOKE ALL ON TABLE op_estados FROM postgres; GRANT ALL ON TABLE op_estados TO postgres; publicpostgresfalse1825"125964120 op_etapasTABLEtCREATE TABLE op_etapas ( et_id bigint NOT NULL, se_id character varying(20) NOT NULL, et_nombre text ); DROP TABLE public.op_etapas; publicpostgrestrue6 00 op_etapasACLREVOKE ALL ON TABLE op_etapas FROM PUBLIC; REVOKE ALL ON TABLE op_etapas FROM postgres; GRANT ALL ON TABLE op_etapas TO postgres; publicpostgresfalse1826#125964126 op_etapas_doTABLECREATE TABLE op_etapas_do ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, et_id bigint NOT NULL, et_nombre text, et_actual boolean DEFAULT false ); DROP TABLE public.op_etapas_do; publicpostgrestrue21596 00 op_etapas_doACLREVOKE ALL ON TABLE op_etapas_do FROM PUBLIC; REVOKE ALL ON TABLE op_etapas_do FROM postgres; GRANT ALL ON TABLE op_etapas_do TO postgres; publicpostgresfalse1827$125964133op_facturacionTABLECREATE TABLE op_facturacion ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, mv_id character varying(20) NOT NULL ); "DROP TABLE public.op_facturacion; publicpostgresfalse6 00op_facturacionACLREVOKE ALL ON TABLE op_facturacion FROM PUBLIC; REVOKE ALL ON TABLE op_facturacion FROM postgres; GRANT ALL ON TABLE op_facturacion TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_facturacion TO empresa; publicpostgresfalse1828%125964136op_hitosTABLECREATE TABLE op_hitos ( hi_id bigint NOT NULL, et_id bigint NOT NULL, se_id character varying(20) NOT NULL, hi_nombre text, hi_responsable text, hi_duracion integer ); DROP TABLE public.op_hitos; publicpostgrestrue6 00op_hitosACLREVOKE ALL ON TABLE op_hitos FROM PUBLIC; REVOKE ALL ON TABLE op_hitos FROM postgres; GRANT ALL ON TABLE op_hitos TO postgres; publicpostgresfalse1829&125964142 op_hitos_doTABLECREATE TABLE op_hitos_do ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, et_id bigint NOT NULL, hi_id bigint NOT NULL, hi_nombre text, hi_responsable text, hi_cumplido boolean DEFAULT false NOT NULL, hi_fecha timestamp without time zone, hi_alarma boolean, hi_alarmas_no integer ); DROP TABLE public.op_hitos_do; publicpostgrestrue21606 00 op_hitos_doACLREVOKE ALL ON TABLE op_hitos_do FROM PUBLIC; REVOKE ALL ON TABLE op_hitos_do FROM postgres; GRANT ALL ON TABLE op_hitos_do TO postgres; publicpostgresfalse1830'125964149op_informacion_despachoTABLECREATE TABLE op_informacion_despacho ( ca_id bigint NOT NULL, of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, id_carpo timestamp without time zone, id_cargue timestamp without time zone, id_despa timestamp without time zone, id_placa text, id_conduc text, id_peso text, id_placaesc text, id_conducesc text, id_transportador text ); +DROP TABLE public.op_informacion_despacho; publicpostgrestrue6 00op_informacion_despachoACLREVOKE ALL ON TABLE op_informacion_despacho FROM PUBLIC; REVOKE ALL ON TABLE op_informacion_despacho FROM postgres; GRANT ALL ON TABLE op_informacion_despacho TO postgres; publicpostgresfalse1831(125964155op_informacion_puertoTABLECREATE TABLE op_informacion_puerto ( do_numero character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, of_id character varying(20) NOT NULL, ip_eta_a boolean DEFAULT false, ip_eta_f timestamp without time zone, ip_veb_a boolean DEFAULT true, ip_veb_f timestamp without time zone, ip_ved_a boolean DEFAULT true, ip_ved_f timestamp without time zone, ip_rso_a boolean DEFAULT false, ip_rso_f timestamp without time zone, ip_dco_a boolean DEFAULT false, ip_dco_f timestamp without time zone, ip_rad_a boolean DEFAULT false, ip_rad_f timestamp without time zone, ip_lin_a boolean DEFAULT false, ip_lin_f timestamp without time zone, ip_con_a boolean DEFAULT false, ip_con_f timestamp without time zone, ip_rab_a boolean DEFAULT false, ip_rab_f timestamp without time zone, ip_not_a boolean DEFAULT false, ip_not_f timestamp without time zone, ip_rei_a boolean DEFAULT false, ip_rei_f timestamp without time zone, ip_num_dtm text ); )DROP TABLE public.op_informacion_puerto; publicpostgrestrue216121622163216421652166216721682169217021716 00op_informacion_puertoACLREVOKE ALL ON TABLE op_informacion_puerto FROM PUBLIC; REVOKE ALL ON TABLE op_informacion_puerto FROM postgres; GRANT ALL ON TABLE op_informacion_puerto TO postgres; publicpostgresfalse1832)125964172 op_inventarioTABLECREATE TABLE op_inventario ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, mv_id character varying(20) NOT NULL ); !DROP TABLE public.op_inventario; publicpostgresfalse6 00 op_inventarioACLREVOKE ALL ON TABLE op_inventario FROM PUBLIC; REVOKE ALL ON TABLE op_inventario FROM postgres; GRANT ALL ON TABLE op_inventario TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_inventario TO empresa; publicpostgresfalse1833*125964175op_item_agenteTABLE0CREATE TABLE op_item_agente ( ia_id character varying(20) NOT NULL, so_id character varying(20), ia_concepto text, ia_resposable character varying(20), ia_costo double precision, ia_venta double precision, ia_profit_glo double precision, ia_profit_age double precision ); "DROP TABLE public.op_item_agente; publicpostgresfalse6 00op_item_agenteACLREVOKE ALL ON TABLE op_item_agente FROM PUBLIC; REVOKE ALL ON TABLE op_item_agente FROM postgres; GRANT ALL ON TABLE op_item_agente TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_item_agente TO PUBLIC; publicpostgresfalse1834+125964181op_item_liquidacionTABLE!CREATE TABLE op_item_liquidacion ( il_id character varying(20) NOT NULL, il_concepto text, il_cantidad integer, il_tarifa double precision, so_id character varying(20), il_estado integer DEFAULT 1, mo_sigla character varying DEFAULT 'COP'::character varying ); 'DROP TABLE public.op_item_liquidacion; publicpostgresfalse217221736 00op_item_liquidacionACLREVOKE ALL ON TABLE op_item_liquidacion FROM PUBLIC; REVOKE ALL ON TABLE op_item_liquidacion FROM postgres; GRANT ALL ON TABLE op_item_liquidacion TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_item_liquidacion TO PUBLIC; publicpostgresfalse1835,125964189 op_mensajesTABLECREATE TABLE op_mensajes ( me_fecha timestamp without time zone NOT NULL, tm_id character varying(20), of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, me_texto text, us_id_preparo character varying(20) NOT NULL, us_id_from character varying(20), us_id_to character varying(20), me_tecopia boolean, me_ccotros text ); DROP TABLE public.op_mensajes; publicpostgrestrue6 00 op_mensajesACLREVOKE ALL ON TABLE op_mensajes FROM PUBLIC; REVOKE ALL ON TABLE op_mensajes FROM postgres; GRANT ALL ON TABLE op_mensajes TO postgres; publicpostgresfalse1836-125964195op_mensajes_externos_msj_id_seqSEQUENCECREATE SEQUENCE op_mensajes_externos_msj_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; 6DROP SEQUENCE public.op_mensajes_externos_msj_id_seq; publicpostgresfalse6 00op_mensajes_externos_msj_id_seq SEQUENCE SETGSELECT pg_catalog.setval('op_mensajes_externos_msj_id_seq', 1, false); publicpostgresfalse1837 00op_mensajes_externos_msj_id_seqACLREVOKE ALL ON SEQUENCE op_mensajes_externos_msj_id_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE op_mensajes_externos_msj_id_seq FROM postgres; GRANT ALL ON SEQUENCE op_mensajes_externos_msj_id_seq TO postgres; GRANT ALL ON SEQUENCE op_mensajes_externos_msj_id_seq TO afiliados; publicpostgresfalse1837.125964197op_mensajes_externosTABLECREATE TABLE op_mensajes_externos ( msj_id integer DEFAULT nextval('op_mensajes_externos_msj_id_seq'::regclass) NOT NULL, msj_txt text ); (DROP TABLE public.op_mensajes_externos; publicpostgresfalse21746 00op_mensajes_externosACLREVOKE ALL ON TABLE op_mensajes_externos FROM PUBLIC; REVOKE ALL ON TABLE op_mensajes_externos FROM postgres; GRANT ALL ON TABLE op_mensajes_externos TO postgres; publicpostgresfalse1838/125964204 op_oficinasTABLECREATE TABLE op_oficinas ( of_id character varying(20) NOT NULL, cc_id character varying(20), of_nombre text, of_tipo character varying(20) ); DROP TABLE public.op_oficinas; publicpostgrestrue6 00 op_oficinasACLREVOKE ALL ON TABLE op_oficinas FROM PUBLIC; REVOKE ALL ON TABLE op_oficinas FROM postgres; GRANT ALL ON TABLE op_oficinas TO postgres; publicpostgresfalse18390125964210 op_ordenesTABLEtCREATE TABLE op_ordenes ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, pu_origen character varying(20), pu_destino character varying(20), ci_origen character varying(20), ci_destino character varying(20), se_id character varying(20), do_num_transporte character varying(50), do_tip_transporte character varying(10), do_fecha_preparacion timestamp without time zone NOT NULL, do_cont_nombre text, do_cont_telefono text, do_cont_celular text, do_cont_email text, do_cont_dir text, do_cont_obs text, do_dir_origen text, do_dir_destino text, do_carga_valor double precision, do_vendedor text, do_tipo_carga character varying(3), do_cont_nit character varying(20), op_lclnobultos bigint, op_lclpeso double precision, op_lcldesc text, op_cargaobs text, es_id character varying(20), us_preparo character varying(20), op_lclvolumen double precision, op_lclcarpo timestamp without time zone, op_lclcargue timestamp without time zone, op_lcldespa timestamp without time zone, op_lclplaca text, op_lclconduc text, op_lcldpeso text, mv_cotizacion character varying(20), op_observaciones text, op_ttarifa text, op_vflete_maritimo double precision, op_vflete_terrestre double precision, op_tcflete_maritimo character varying, op_tcflete_terrestre character varying, op_fchflete_maritimo date, op_fchflete_terrestre date, op_tcmflete_maritimo character varying, op_tcmflete_terrestre character varying ); DROP TABLE public.op_ordenes; publicpostgrestrue6 00 op_ordenesACLREVOKE ALL ON TABLE op_ordenes FROM PUBLIC; REVOKE ALL ON TABLE op_ordenes FROM postgres; GRANT ALL ON TABLE op_ordenes TO postgres; GRANT ALL ON TABLE op_ordenes TO empresa; publicpostgresfalse18401125964216op_pagosTABLECREATE TABLE op_pagos ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, imv_id character varying(20) NOT NULL ); DROP TABLE public.op_pagos; publicpostgresfalse6 00op_pagosACLREVOKE ALL ON TABLE op_pagos FROM PUBLIC; REVOKE ALL ON TABLE op_pagos FROM postgres; GRANT ALL ON TABLE op_pagos TO postgres; publicpostgresfalse18412125964219 op_puertosTABLECREATE TABLE op_puertos ( pu_id character varying(20) NOT NULL, pu_nombre text, pu_tipo character varying(30), pu_pais character varying(50) ); DROP TABLE public.op_puertos; publicpostgrestrue6 00 op_puertosACLREVOKE ALL ON TABLE op_puertos FROM PUBLIC; REVOKE ALL ON TABLE op_puertos FROM postgres; GRANT ALL ON TABLE op_puertos TO postgres; publicpostgresfalse18423125964225op_seguimiento_se_id_seqSEQUENCEzCREATE SEQUENCE op_seguimiento_se_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; /DROP SEQUENCE public.op_seguimiento_se_id_seq; publicpostgresfalse6 00op_seguimiento_se_id_seq SEQUENCE SET@SELECT pg_catalog.setval('op_seguimiento_se_id_seq', 1, false); publicpostgresfalse1843 00op_seguimiento_se_id_seqACLREVOKE ALL ON SEQUENCE op_seguimiento_se_id_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE op_seguimiento_se_id_seq FROM postgres; GRANT ALL ON SEQUENCE op_seguimiento_se_id_seq TO postgres; GRANT ALL ON SEQUENCE op_seguimiento_se_id_seq TO afiliados; publicpostgresfalse18434125964227op_seguimientoTABLECREATE TABLE op_seguimiento ( se_id integer DEFAULT nextval('op_seguimiento_se_id_seq'::regclass) NOT NULL, se_fecha timestamp without time zone, se_lugar text, se_contenedor character varying(11), se_descripcion text ); "DROP TABLE public.op_seguimiento; publicpostgrestrue21756 00op_seguimientoACLREVOKE ALL ON TABLE op_seguimiento FROM PUBLIC; REVOKE ALL ON TABLE op_seguimiento FROM postgres; GRANT ALL ON TABLE op_seguimiento TO postgres; publicpostgresfalse18445125964234 op_serviciosTABLECREATE TABLE op_servicios ( se_id character varying(20) NOT NULL, se_nombre text, se_descripcion text, se_tmaritimo boolean, se_tpuerto boolean, se_tterrestre boolean ); DROP TABLE public.op_servicios; publicpostgrestrue6 00 op_serviciosACLREVOKE ALL ON TABLE op_servicios FROM PUBLIC; REVOKE ALL ON TABLE op_servicios FROM postgres; GRANT ALL ON TABLE op_servicios TO postgres; publicpostgresfalse18456125964240op_solicitudesTABLECREATE TABLE op_solicitudes ( of_id character varying(20) NOT NULL, do_anio character varying(2) NOT NULL, do_numero character varying(20) NOT NULL, so_fecha_soli date, us_id character varying(20), so_obs text, so_deposito_1 boolean, so_deposito_2 boolean, so_deposito_3 boolean, so_deposito_4 boolean, so_deposito_5 boolean, so_agente_id character varying(20), so_agente_nombre character varying(50), so_id character varying(20) NOT NULL ); "DROP TABLE public.op_solicitudes; publicpostgresfalse6 00op_solicitudesACLREVOKE ALL ON TABLE op_solicitudes FROM PUBLIC; REVOKE ALL ON TABLE op_solicitudes FROM postgres; GRANT ALL ON TABLE op_solicitudes TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_solicitudes TO PUBLIC; publicpostgresfalse18467125964246op_tipo_mensajeTABLECREATE TABLE op_tipo_mensaje ( tm_id character varying(20) NOT NULL, tm_nombre text NOT NULL, tm_image text, tm_visibilidad text ); #DROP TABLE public.op_tipo_mensaje; publicpostgrestrue6 00op_tipo_mensajeACLREVOKE ALL ON TABLE op_tipo_mensaje FROM PUBLIC; REVOKE ALL ON TABLE op_tipo_mensaje FROM postgres; GRANT ALL ON TABLE op_tipo_mensaje TO postgres; publicpostgresfalse18478125964252op_tipos_cargaTABLEzCREATE TABLE op_tipos_carga ( tca_id character varying(20) NOT NULL, tca_nombre text, tca_descripcion text ); "DROP TABLE public.op_tipos_carga; publicpostgrestrue6 00op_tipos_cargaACLREVOKE ALL ON TABLE op_tipos_carga FROM PUBLIC; REVOKE ALL ON TABLE op_tipos_carga FROM postgres; GRANT ALL ON TABLE op_tipos_carga TO postgres; publicpostgresfalse18489125964258op_tipos_contenedorTABLECREATE TABLE op_tipos_contenedor ( tco_id character varying(20) NOT NULL, tco_nombre text, tco_descripcion text ); 'DROP TABLE public.op_tipos_contenedor; publicpostgrestrue6 00op_tipos_contenedorACLREVOKE ALL ON TABLE op_tipos_contenedor FROM PUBLIC; REVOKE ALL ON TABLE op_tipos_contenedor FROM postgres; GRANT ALL ON TABLE op_tipos_contenedor TO postgres; publicpostgresfalse1849:125964264op_tipos_empaqueTABLECREATE TABLE op_tipos_empaque ( te_id character varying(20) NOT NULL, te_nombre character varying(50), te_sigla character varying(5) ); $DROP TABLE public.op_tipos_empaque; publicpostgresfalse6 00op_tipos_empaqueACLREVOKE ALL ON TABLE op_tipos_empaque FROM PUBLIC; REVOKE ALL ON TABLE op_tipos_empaque FROM postgres; GRANT ALL ON TABLE op_tipos_empaque TO postgres; GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE op_tipos_empaque TO PUBLIC; publicpostgresfalse1850;125964267op_usuarios_oficinasTABLEzCREATE TABLE op_usuarios_oficinas ( of_id character varying(20) NOT NULL, us_id character varying(20) NOT NULL ); (DROP TABLE public.op_usuarios_oficinas; publicpostgrestrue6 00op_usuarios_oficinasACLREVOKE ALL ON TABLE op_usuarios_oficinas FROM PUBLIC; REVOKE ALL ON TABLE op_usuarios_oficinas FROM postgres; GRANT ALL ON TABLE op_usuarios_oficinas TO postgres; publicpostgresfalse1851<125964270paagTABLECREATE TABLE paag ( pa_id character varying(20) NOT NULL, pa_valor double precision, pe_id character varying(20) ); DROP TABLE public.paag; publicpostgresfalse6 00paagACLREVOKE ALL ON TABLE paag FROM PUBLIC; REVOKE ALL ON TABLE paag FROM postgres; GRANT ALL ON TABLE paag TO postgres; GRANT ALL ON TABLE paag TO empresa; publicpostgresfalse1852=125964273 parametrosTABLECREATE TABLE parametros ( pa_id character varying(20) NOT NULL, pa_nombre text NOT NULL, pa_tipo_dato character varying(20), pa_valor double precision, pa_indice integer NOT NULL, pa_confirmacion boolean, re_regla character varying(20) NOT NULL ); DROP TABLE public.parametros; publicpostgrestrue6 00TABLE parametrosCOMMENTCOMMENT ON TABLE parametros IS 'Aqui se listan todos los parametros a ser aplicados en una funcion cualquiera que sea el objetivo de aplicacion.'; publicpostgresfalse1853 00 parametrosACLREVOKE ALL ON TABLE parametros FROM PUBLIC; REVOKE ALL ON TABLE parametros FROM postgres; GRANT ALL ON TABLE parametros TO postgres; GRANT ALL ON TABLE parametros TO empresa; publicpostgresfalse1853>125964279 pendientesTABLECREATE TABLE pendientes ( pen_id character varying(20) NOT NULL, pen_fecha_cumplimiento date, pen_activo boolean DEFAULT true NOT NULL, us_usuario character varying(20) NOT NULL, pen_descripcion text, tp_id character varying(20) NOT NULL, mv_origen character varying(20), pen_numero character varying(20), pen_valor double precision, pen_tercero character varying(20), mv_destino character varying(20) ); DROP TABLE public.pendientes; publicpostgrestrue21766 00TABLE pendientesCOMMENTCOMMENT ON TABLE pendientes IS 'La tabla pendientes lleva el historial de movimientos almacenados como pendientes o como periodicos.'; publicpostgresfalse1854 00 pendientesACLREVOKE ALL ON TABLE pendientes FROM PUBLIC; REVOKE ALL ON TABLE pendientes FROM postgres; GRANT ALL ON TABLE pendientes TO postgres; GRANT ALL ON TABLE pendientes TO empresa; publicpostgresfalse1854?125964286perfilesTABLECREATE TABLE perfiles ( pf_id character varying(20) NOT NULL, pf_nombre character varying(50) DEFAULT 'Contador'::character varying NOT NULL, pf_modulo_def character varying(50) ); DROP TABLE public.perfiles; publicpostgrestrue21776 00TABLE perfilesCOMMENTCOMMENT ON TABLE perfiles IS 'Esta tabla almacena los permisos que posee cada perfil de usuario para la ejecucion de usuarios'; publicpostgresfalse1855 00perfilesACLREVOKE ALL ON TABLE perfiles FROM PUBLIC; REVOKE ALL ON TABLE perfiles FROM postgres; GRANT ALL ON TABLE perfiles TO postgres; GRANT ALL ON TABLE perfiles TO empresa; publicpostgresfalse1855@125964290periodoTABLE CREATE TABLE periodo ( pe_id character varying(20) NOT NULL, pe_mes character varying(10) NOT NULL, pe_anio character varying(4) NOT NULL, pe_actual boolean NOT NULL, ci_id character varying(20) NOT NULL, pe_cerrado boolean DEFAULT false ); DROP TABLE public.periodo; publicpostgrestrue21786 00 TABLE periodoCOMMENTCOMMENT ON TABLE periodo IS 'El periodo hace relacion a el minimo espacio de tiempo que se debe tener en cuenta para llevar la contabilidad, en este caso se toma por un mes.'; publicpostgresfalse1856 00periodoACLREVOKE ALL ON TABLE periodo FROM PUBLIC; REVOKE ALL ON TABLE periodo FROM postgres; GRANT ALL ON TABLE periodo TO postgres; GRANT ALL ON TABLE periodo TO empresa; publicpostgresfalse1856A125964294pucTABLECREATE TABLE puc ( puc_nombre character varying(110) NOT NULL, puc_tercero boolean, puc_ccosto boolean, puc_codigo character varying(20) NOT NULL, puc_naturaleza character varying(20), puc_modificable boolean DEFAULT true NOT NULL ); DROP TABLE public.puc; publicpostgrestrue21796 00 TABLE pucCOMMENTqCOMMENT ON TABLE puc IS 'Aqui se almacena el catalogo de cuentas de contabilidad. (PUC: Plan unico de cuentas)'; publicpostgresfalse1857 00pucACLREVOKE ALL ON TABLE puc FROM PUBLIC; REVOKE ALL ON TABLE puc FROM postgres; GRANT ALL ON TABLE puc TO postgres; GRANT ALL ON TABLE puc TO empresa; publicpostgresfalse1857B125964298recursosTABLECREATE TABLE recursos ( re_id character varying(20) NOT NULL, re_ambito character varying(50) NOT NULL, re_codigo character varying(20), re_tipo character varying(20), re_nombre character varying(255), re_descripcion text ); DROP TABLE public.recursos; publicpostgrestrue6 00recursosACLREVOKE ALL ON TABLE recursos FROM PUBLIC; REVOKE ALL ON TABLE recursos FROM postgres; GRANT ALL ON TABLE recursos TO postgres; GRANT ALL ON TABLE recursos TO empresa; publicpostgresfalse1858C125964304reglasTABLE\CREATE TABLE reglas ( re_id character varying(20) NOT NULL, re_interactividad character varying(20), re_nombre text NOT NULL, tr_tipo_regla character varying(20) NOT NULL, fu_funcion character varying(20) NOT NULL, puc_disparadora character varying(20), puc_debito character varying(20), tm_tipo_movimiento character varying(20), puc_credito character varying(20), cr_categoria character varying(20) NOT NULL, re_activa boolean DEFAULT true NOT NULL, re_visible boolean DEFAULT true, re_inv boolean DEFAULT false, re_cppal character varying(20) ); DROP TABLE public.reglas; publicpostgrestrue2180218121826 00 TABLE reglasCOMMENTCOMMENT ON TABLE reglas IS 'Las reglas son ejemplos instanciables de la aplicacion de funciones sobre ciertos elementos como calculos de iva y generacion de movimiento como los calculos de ajustes por inflacion'; publicpostgresfalse1859 00reglasACLREVOKE ALL ON TABLE reglas FROM PUBLIC; REVOKE ALL ON TABLE reglas FROM postgres; GRANT ALL ON TABLE reglas TO postgres; GRANT ALL ON TABLE reglas TO empresa; publicpostgresfalse1859D125964313 reglas_nominaTABLECREATE TABLE reglas_nomina ( rn_id character varying(20) NOT NULL, re_id character varying(20), te_id character varying(20), no_id character varying(20) ); !DROP TABLE public.reglas_nomina; publicpostgresfalse6 00 reglas_nominaACLREVOKE ALL ON TABLE reglas_nomina FROM PUBLIC; REVOKE ALL ON TABLE reglas_nomina FROM postgres; GRANT ALL ON TABLE reglas_nomina TO postgres; GRANT ALL ON TABLE reglas_nomina TO empresa; publicpostgresfalse1860E125964316reglas_nomina_basesTABLECREATE TABLE reglas_nomina_bases ( rnb_id character varying(20) NOT NULL, re_id character varying(20) NOT NULL, co_id character varying(20) NOT NULL, rnb_base boolean NOT NULL ); 'DROP TABLE public.reglas_nomina_bases; publicpostgresfalse6 00reglas_nomina_basesACLREVOKE ALL ON TABLE reglas_nomina_bases FROM PUBLIC; REVOKE ALL ON TABLE reglas_nomina_bases FROM postgres; GRANT ALL ON TABLE reglas_nomina_bases TO postgres; GRANT ALL ON TABLE reglas_nomina_bases TO empresa; publicpostgresfalse1861F125964319 tasas_cambioTABLECREATE TABLE tasas_cambio ( tc_sigla character varying(10) NOT NULL, tc_nombre text NOT NULL, mo_sigla character varying(10) NOT NULL ); DROP TABLE public.tasas_cambio; publicpostgrestrue6 00TABLE tasas_cambioCOMMENTYCOMMENT ON TABLE tasas_cambio IS 'Tabla para almacenar las diferentes tasas de cambio.'; publicpostgresfalse1862 00 tasas_cambioACLREVOKE ALL ON TABLE tasas_cambio FROM PUBLIC; REVOKE ALL ON TABLE tasas_cambio FROM postgres; GRANT ALL ON TABLE tasas_cambio TO postgres; GRANT ALL ON TABLE tasas_cambio TO empresa; publicpostgresfalse1862G125964325tasas_cambio_diaTABLECREATE TABLE tasas_cambio_dia ( td_fecha date NOT NULL, td_valor numeric(20,5), tc_sigla character varying(20) NOT NULL ); $DROP TABLE public.tasas_cambio_dia; publicpostgrestrue6 00tasas_cambio_diaACLREVOKE ALL ON TABLE tasas_cambio_dia FROM PUBLIC; REVOKE ALL ON TABLE tasas_cambio_dia FROM postgres; GRANT ALL ON TABLE tasas_cambio_dia TO postgres; GRANT ALL ON TABLE tasas_cambio_dia TO empresa; publicpostgresfalse1863H125964328tipo_movimientoTABLECREATE TABLE tipo_movimiento ( tm_id character varying(20) NOT NULL, tm_nombre character varying(50) NOT NULL, tm_descripcion text, tm_prefijo_default character varying(10) ); #DROP TABLE public.tipo_movimiento; publicpostgrestrue6 00TABLE tipo_movimientoCOMMENTCOMMENT ON TABLE tipo_movimiento IS 'Los tipos de movimientos clasifican los movimientos de acuerdo con su naturaleza, por ejemplo: Comprobante de contabilidad y Factura de Venta.'; publicpostgresfalse1864 00tipo_movimientoACLREVOKE ALL ON TABLE tipo_movimiento FROM PUBLIC; REVOKE ALL ON TABLE tipo_movimiento FROM postgres; GRANT ALL ON TABLE tipo_movimiento TO postgres; GRANT ALL ON TABLE tipo_movimiento TO empresa; publicpostgresfalse1864I125964334tipo_pendienteTABLECREATE TABLE tipo_pendiente ( tp_id character varying(20) NOT NULL, tp_nombre text NOT NULL, tp_descripcion character varying(20) ); "DROP TABLE public.tipo_pendiente; publicpostgrestrue6 00tipo_pendienteACLREVOKE ALL ON TABLE tipo_pendiente FROM PUBLIC; REVOKE ALL ON TABLE tipo_pendiente FROM postgres; GRANT ALL ON TABLE tipo_pendiente TO postgres; GRANT ALL ON TABLE tipo_pendiente TO empresa; publicpostgresfalse1865J125964340 tipo_reglaTABLECREATE TABLE tipo_regla ( tr_id character varying(20) NOT NULL, tr_descripcion text, tr_nombre character varying(20) NOT NULL ); DROP TABLE public.tipo_regla; publicpostgrestrue6 00TABLE tipo_reglaCOMMENTCOMMENT ON TABLE tipo_regla IS 'Los tipos de regla categorizan las reglas en cuatro elementos, por ejemplo: reglas aritmeticas, reglas de generacion de movimientos, etc. '; publicpostgresfalse1866 00 tipo_reglaACLREVOKE ALL ON TABLE tipo_regla FROM PUBLIC; REVOKE ALL ON TABLE tipo_regla FROM postgres; GRANT ALL ON TABLE tipo_regla TO postgres; GRANT ALL ON TABLE tipo_regla TO empresa; publicpostgresfalse1866K125964346 tipo_terceroTABLECREATE TABLE tipo_tercero ( tt_id character varying(20) NOT NULL, tt_nombre character varying(20) NOT NULL, tt_descripcion text ); DROP TABLE public.tipo_tercero; publicpostgrestrue6 00TABLE tipo_terceroCOMMENTCOMMENT ON TABLE tipo_tercero IS 'Esta tabla almacena la categorizacion de terceros como clientes, provedoores, socios, etc.'; publicpostgresfalse1867 00 tipo_terceroACLREVOKE ALL ON TABLE tipo_tercero FROM PUBLIC; REVOKE ALL ON TABLE tipo_tercero FROM postgres; GRANT ALL ON TABLE tipo_tercero TO postgres; GRANT ALL ON TABLE tipo_tercero TO empresa; publicpostgresfalse1867L125964352usuarioTABLE}CREATE TABLE usuario ( us_id character varying(20) NOT NULL, us_login character varying(20) NOT NULL, us_password character varying(100) NOT NULL, us_nombre character varying(70), us_mail character varying(70), us_nivel character varying(50), us_activo boolean NOT NULL, pf_id character varying(20) DEFAULT '00000001'::character varying NOT NULL ); DROP TABLE public.usuario; publicpostgrestrue21836 00 TABLE usuarioCOMMENTtCOMMENT ON TABLE usuario IS 'Aqui se agrupan todos los posibles usuarios del sistema, inclusive el mismo sistema.'; publicpostgresfalse1868 00usuarioACLREVOKE ALL ON TABLE usuario FROM PUBLIC; REVOKE ALL ON TABLE usuario FROM postgres; GRANT ALL ON TABLE usuario TO postgres; GRANT ALL ON TABLE usuario TO empresa; publicpostgresfalse1868125564356'aumentar_id(character varying, integer)FUNCTIONgCREATE FUNCTION aumentar_id(character varying, integer) RETURNS character varying AS $_$ DECLARE s_id VARCHAR(20); i_id FLOAT8; BEGIN s_id := $1; IF $1 IS NULL OR $1 = '' THEN s_id := 0; END IF; i_id := CAST (s_id AS float8); s_id := lpad(CAST((i_id + 1) AS TEXT),$2,'0'); RETURN s_id; END; $_$ LANGUAGE plpgsql; >DROP FUNCTION public.aumentar_id(character varying, integer); publicpostgresfalse6590125564357cerrarciclo(character varying)FUNCTIONCREATE FUNCTION cerrarciclo(character varying) RETURNS integer AS $_$DECLARE rperiodo RECORD; rcuentas RECORD; aux VARCHAR(20); id_mov VARCHAR(20); id_imov VARCHAR(20); mv_num VARCHAR(20); mv_pre VARCHAR(20); id_tercero VARCHAR(20); ingresos FLOAT8; gastos FLOAT8; costosv FLOAT8; costosp FLOAT8; total FLOAT8; us VARCHAR(20); debito FLOAT8; credito FLOAT8; BEGIN SELECT INTO rperiodo pe_id, pe_mes, ci_id, pe_anio FROM periodo WHERE pe_actual=TRUE; SELECT INTO us us_id FROM usuario WHERE us_login = $1; IF rperiodo.pe_mes = 12 THEN SELECT INTO aux CASE WHEN em_valor < 5 THEN 8 ELSE 6 END FROM empresa WHERE em_codigo = 'em_frm_puca'; SELECT INTO ingresos SUM(c.imv_cr - c.imv_db) FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo > '4' AND it.puc_codigo < '5' AND mv.mv_id = it.mv_id AND mv.es_id = '03' AND mv.pe_id <= rperiodo.pe_id AND p.puc_codigo = it.puc_codigo AND it.cc_id LIKE '%' ORDER BY it.puc_codigo) c; SELECT INTO gastos SUM(c.imv_db - c.imv_cr) FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo > '5' AND it.puc_codigo < '6' AND mv.mv_id = it.mv_id AND mv.es_id = '03' AND mv.pe_id <= rperiodo.pe_id AND p.puc_codigo = it.puc_codigo AND it.cc_id LIKE '%' ORDER BY it.puc_codigo) c; SELECT INTO costosv SUM(c.imv_db - c.imv_cr) FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo > '6' AND it.puc_codigo < '7' AND mv.mv_id = it.mv_id AND mv.es_id = '03' AND mv.pe_id <= rperiodo.pe_id AND p.puc_codigo = it.puc_codigo AND it.cc_id LIKE '%' ORDER BY it.puc_codigo) c; SELECT INTO costosp SUM(c.imv_db - c.imv_cr) FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo > '7' AND it.puc_codigo < '8' AND mv.mv_id = it.mv_id AND mv.es_id = '03' AND mv.pe_id <= rperiodo.pe_id AND p.puc_codigo = it.puc_codigo AND it.cc_id LIKE '%' ORDER BY it.puc_codigo) c; IF costosp ISNULL THEN costosp := 0; END IF; costosp := round(CAST (costosp AS numeric), 2); total := ingresos - gastos - costosv - costosp; RAISE NOTICE 'VALORES %, %, %, %',ingresos, gastos, costosv, costosp; RAISE NOTICE 'TOTAL %',total; SELECT INTO id_mov aumentar_id((SELECT MAX(mv_id) FROM movimiento),8); SELECT INTO mv_num substr(MAX(mv_numero), 3 ,8) FROM movimiento WHERE tm_tipo_movimiento = '10'; SELECT INTO mv_num aumentar_id(mv_num,8); SELECT INTO mv_pre tm_prefijo_default FROM tipo_movimiento WHERE tm_id = '10'; SELECT INTO id_tercero te_id FROM tercero WHERE upper(te_nombre) LIKE upper('%globalog s.a.%'); INSERT INTO movimiento(mv_id, tm_tipo_movimiento, es_id, us_preparo, mv_fecha_preparacion, mv_numero, pe_id, mv_dia_contabilizacion, mv_db, mv_cr, mv_observaciones) VALUES (id_mov, '10', '01', us,CURRENT_DATE, mv_pre||mv_num, rperiodo.pe_id, '31', total, total, 'Cierre de ciclo '||rperiodo.pe_anio); RAISE NOTICE 'MOVIMIENTO %',id_mov; IF total > 0 THEN SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '360505%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 1, 0, total); SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '590505%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 2, total, 0); ELSE SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '361005%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 1, total*(-1), 0); SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '590505%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 2, 0, total*(-1)); END IF; UPDATE movimiento SET es_id = '02', us_aprobo=us, mv_fecha_aprobacion = CURRENT_DATE WHERE mv_id = id_mov; UPDATE movimiento SET es_id = '03', us_contabilizo=us, mv_fecha_auditoria = CURRENT_DATE WHERE mv_id = id_mov; SELECT INTO total imv_cr-imv_db FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo LIKE '36%' AND mv.mv_id = it.mv_id AND mv.es_id = '03' AND mv.pe_id <= rperiodo.pe_id AND p.puc_codigo = it.puc_codigo AND it.cc_id LIKE '%' ORDER BY it.puc_codigo) c; SELECT INTO id_mov aumentar_id((SELECT MAX(mv_id) FROM movimiento),8); SELECT INTO mv_num substr(MAX(mv_numero), 3 ,8) FROM movimiento WHERE tm_tipo_movimiento = '10'; SELECT INTO mv_num aumentar_id(mv_num,8); SELECT INTO mv_pre tm_prefijo_default FROM tipo_movimiento WHERE tm_id = '10'; INSERT INTO movimiento(mv_id, tm_tipo_movimiento, es_id, us_preparo, mv_fecha_preparacion, mv_numero, pe_id, mv_dia_contabilizacion, mv_db, mv_cr, mv_observaciones) VALUES (id_mov, '10', '01', us, CURRENT_DATE, mv_pre||mv_num, rperiodo.pe_id, '31', total, total, 'Cierre de ciclo '||rperiodo.pe_anio); IF total > 0 THEN SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '360505%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 1, total, 0); SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '370501%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 2, 0, total); ELSE SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '361005%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 1, 0, total*(-1)); SELECT INTO id_imov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_db, imv_cr) VALUES(id_imov, id_mov, 'BOGOFI', id_tercero, (SELECT puc_codigo FROM puc WHERE puc_codigo like '371001%' AND char_length(puc_codigo) > aux), rperiodo.pe_id, 2, total*(-1), 0); END IF; UPDATE movimiento SET es_id = '02', us_aprobo=us, mv_fecha_aprobacion = CURRENT_DATE WHERE mv_id = id_mov; UPDATE movimiento SET es_id = '03', us_contabilizo=us, mv_fecha_auditoria = CURRENT_DATE WHERE mv_id = id_mov; IF (SELECT MAX(pe_id) FROM periodo) = rperiodo.pe_id THEN PERFORM cuentasperiodoinicial(); END IF; UPDATE ciclo SET ci_fecha_cierre = rperiodo.pe_anio||'-'||rperiodo.pe_mes||'-31' WHERE ci_actual = true; RETURN 1; END IF; RETURN 0; END; $_$ LANGUAGE plpgsql; 5DROP FUNCTION public.cerrarciclo(character varying); publicpostgresfalse5906125564358consultar_ipuc()FUNCTIONCREATE FUNCTION consultar_ipuc() RETURNS integer AS $$ DECLARE rdatos RECORD; rperiodos RECORD; indice RECORD; codigo VARCHAR; lpuc VARCHAR; str TEXT; BEGIN FOR rperiodos IN SELECT pe_id FROM estado_cperiodo WHERE ec_estado = false LOOP DELETE FROM cuentas_info WHERE pe_id = rperiodos.pe_id; FOR indice IN SELECT DISTINCT char_length(puc_codigo) AS i FROM puc GROUP BY puc_codigo LOOP codigo := 'C'||indice.i; lpuc := 'substring(PUC_CODIGO from '''||lpad('.', indice.i, '.')||''') AS '||codigo; str := 'SELECT '||codigo||' AS codigo, SUM(imv_db) AS imv_db, SUM(imv_cr) AS imv_cr, a.cc_id FROM ( SELECT '||lpuc||', c.imv_db, c.imv_cr, c.cc_id FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE mv.mv_id = it.mv_id AND mv.es_id = ''03'' AND mv.pe_id = '''||rperiodos.pe_id||''' AND p.puc_codigo = it.puc_codigo ORDER BY it.puc_codigo ) c ) a GROUP BY '||codigo||', a.cc_id ORDER BY codigo'; RAISE NOTICE '%',str; FOR rdatos IN EXECUTE str LOOP INSERT INTO cuentas_info values(rdatos.codigo, rperiodos.pe_id, rdatos.imv_db, rdatos.imv_cr, rdatos.cc_id); END LOOP; UPDATE estado_cperiodo SET ec_estado = true WHERE pe_id = rperiodos.pe_id; END LOOP; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; 'DROP FUNCTION public.consultar_ipuc(); publicpostgresfalse6590125564359!consultar_ipuc(character varying)FUNCTIONCREATE FUNCTION consultar_ipuc(pfin character varying) RETURNS integer AS $$ DECLARE rdatos RECORD; rperiodos RECORD; indice RECORD; codigo VARCHAR; lpuc VARCHAR; str TEXT; BEGIN FOR rperiodos IN SELECT pe_id FROM estado_cperiodo WHERE ec_estado = false AND pe_id <= pfin LOOP DELETE FROM cuentas_info WHERE pe_id = rperiodos.pe_id; FOR indice IN SELECT DISTINCT char_length(puc_codigo) AS i FROM puc GROUP BY puc_codigo LOOP codigo := 'C'||indice.i; lpuc := 'substring(PUC_CODIGO from '''||lpad('.', indice.i, '.')||''') AS '||codigo; str := 'SELECT '||codigo||' AS codigo, SUM(imv_db) AS imv_db, SUM(imv_cr) AS imv_cr, a.cc_id FROM ( SELECT '||lpuc||', c.imv_db, c.imv_cr, c.cc_id FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE mv.mv_id = it.mv_id AND mv.es_id = ''03'' AND mv.pe_id = '''||rperiodos.pe_id||''' AND p.puc_codigo = it.puc_codigo ORDER BY it.puc_codigo ) c ) a GROUP BY '||codigo||', a.cc_id ORDER BY codigo'; RAISE NOTICE '%',str; FOR rdatos IN EXECUTE str LOOP INSERT INTO cuentas_info values(rdatos.codigo, rperiodos.pe_id, rdatos.imv_db, rdatos.imv_cr, rdatos.cc_id); END LOOP; UPDATE estado_cperiodo SET ec_estado = true WHERE pe_id = rperiodos.pe_id; END LOOP; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; =DROP FUNCTION public.consultar_ipuc(pfin character varying); publicdavidfalse6590*125564360consultar_puc(character varying, character varying, character varying, character varying, character varying, character varying)FUNCTIONCREATE FUNCTION consultar_puc(ini character varying, fin character varying, p_ini character varying, p_fin character varying, ccosto character varying, length character varying) RETURNS integer AS $$DECLARE rdatos RECORD; codigo VARCHAR; str TEXT; BEGIN FOR i IN 1..6 LOOP codigo := 'C'||i; str := 'SELECT '||codigo||' AS codigo, imv_db, imv_cr FROM ( SELECT substring(PUC_CODIGO from ''.'') AS C1, substring(PUC_CODIGO from ''..'') AS C2, substring(PUC_CODIGO from ''....'') AS C3, substring(PUC_CODIGO from ''......'') AS C4, substring(PUC_CODIGO from ''........'') AS C5, substring(PUC_CODIGO from ''..........'')AS C6, c.puc_nombre, c.imv_db, c.imv_cr FROM ( SELECT it.puc_codigo, p.puc_nombre, it.imv_db, it.imv_cr, it.cc_id FROM item_movimiento it, movimiento mv, puc p WHERE it.puc_codigo > '''||ini||''' AND it.puc_codigo < '''||fin||''' AND mv.mv_id = it.mv_id AND mv.es_id = ''03'' AND mv.pe_id BETWEEN '''||p_ini||''' AND '''||p_fin||''' AND p.puc_codigo = it.puc_codigo'; IF ccosto = '%' THEN str := str||' AND (it.cc_id LIKE '''||ccosto||''' OR it.cc_id ISNULL)'; ELSE str := str||' AND it.cc_id LIKE '''||ccosto||''' '; END IF; str := str||' ORDER BY it.puc_codigo ) c ) a WHERE char_length('||codigo||') <= '''||length||''''; RAISE NOTICE '%',str; FOR rdatos IN EXECUTE str LOOP INSERT INTO temporal values(rdatos.codigo, '00000001', rdatos.imv_db, rdatos.imv_cr); END LOOP; END LOOP; RETURN 0; END;$$ LANGUAGE plpgsql; DROP FUNCTION public.consultar_puc(ini character varying, fin character varying, p_ini character varying, p_fin character varying, ccosto character varying, length character varying); publicpostgresfalse6590125564361consultar_puc_do(character varying, character varying, character varying, character varying, character varying, character varying)FUNCTIONCREATE FUNCTION consultar_puc_do(ini character varying, fin character varying, of_id character varying, do_anio character varying, do_numero character varying, length character varying) RETURNS integer AS $$ DECLARE rdatos RECORD; codigo VARCHAR; str TEXT; BEGIN FOR i IN 1..6 LOOP codigo := 'C'||i; str := 'SELECT '||codigo||' AS codigo, imv_db, imv_cr FROM ( SELECT substring(PUC_CODIGO from ''.'') AS C1, substring(PUC_CODIGO from ''..'') AS C2, substring(PUC_CODIGO from ''....'') AS C3, substring(PUC_CODIGO from ''......'') AS C4, substring(PUC_CODIGO from ''........'') AS C5, substring(PUC_CODIGO from ''..........'')AS C6, c.imv_db, c.imv_cr FROM ( SELECT i.puc_codigo, i.imv_db, i.imv_cr FROM movimiento m, item_movimiento i, op_contabilidad o WHERE m.mv_id = i.mv_id AND m.mv_id = o.mv_id AND i.imv_id = o.imv_id AND o.of_id = '''||of_id||''' AND o.do_anio = '''||do_anio||''' AND o.do_numero = '''||do_numero||''' AND i.puc_codigo > '||ini||' AND i.puc_codigo < '||fin||' AND m.es_id = ''03'' ORDER BY i.puc_codigo ) c ) a WHERE char_length('||codigo||') <= '||length; RAISE NOTICE '%',str; FOR rdatos IN EXECUTE str LOOP INSERT INTO temporal values(rdatos.codigo, '00000001', rdatos.imv_db, rdatos.imv_cr); END LOOP; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; DROP FUNCTION public.consultar_puc_do(ini character varying, fin character varying, of_id character varying, do_anio character varying, do_numero character varying, length character varying); publicdavidfalse5906125564362aconsultar_puc_tercero(character varying, character varying, character varying, character varying)FUNCTIONCREATE FUNCTION consultar_puc_tercero(ini character varying, fin character varying, tercero character varying, length character varying) RETURNS integer AS $$ DECLARE rdatos RECORD; codigo VARCHAR; str TEXT; BEGIN FOR i IN 1..6 LOOP codigo := 'C'||i; str := 'SELECT '||codigo||' AS codigo, imv_db, imv_cr FROM ( SELECT substring(PUC_CODIGO from ''.'') AS C1, substring(PUC_CODIGO from ''..'') AS C2, substring(PUC_CODIGO from ''....'') AS C3, substring(PUC_CODIGO from ''......'') AS C4, substring(PUC_CODIGO from ''........'') AS C5, substring(PUC_CODIGO from ''..........'')AS C6, c.imv_db, c.imv_cr FROM ( SELECT i.puc_codigo, i.imv_db, i.imv_cr FROM movimiento m, item_movimiento i, op_contabilidad o WHERE m.mv_id = i.mv_id AND m.mv_id = o.mv_id AND i.imv_id = o.imv_id AND i.puc_codigo > '||ini||' AND i.puc_codigo < '||fin||' AND m.es_id = ''03'' AND i.te_id = '''||tercero||''' ORDER BY i.puc_codigo ) c ) a WHERE char_length('||codigo||') <= '||length; RAISE NOTICE '%',str; FOR rdatos IN EXECUTE str LOOP INSERT INTO temporal values(rdatos.codigo, '00000001', rdatos.imv_db, rdatos.imv_cr); END LOOP; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; DROP FUNCTION public.consultar_puc_tercero(ini character varying, fin character varying, tercero character varying, length character varying); publicdavidfalse5906125564363contabilizar()FUNCTION CREATE FUNCTION contabilizar() RETURNS trigger AS $$ DECLARE nitems RECORD; ncuentas RECORD; BEGIN IF (OLD.es_id = '02' AND NEW.es_id = '03') THEN RAISE NOTICE 'TRIGGER LANZADO! PARA %', OLD.MV_ID; FOR nitems IN SELECT * FROM ITEM_MOVIMIENTO WHERE MV_ID = OLD.MV_ID LOOP SELECT INTO ncuentas substring(PUC_CODIGO from '.') AS C1, substring(PUC_CODIGO from '..') AS C2, substring(PUC_CODIGO from '....') AS C3, substring(PUC_CODIGO from '......') AS C4, substring(PUC_CODIGO from '........') AS C5, substring(PUC_CODIGO from '..........')AS C6 FROM CUENTAS WHERE PUC_CODIGO = nitems.PUC_CODIGO; RAISE NOTICE '%,%,%,%,%,%', ncuentas.C1,ncuentas.C2,ncuentas.C3, ncuentas.C4,ncuentas.C5,ncuentas.C6; PERFORM insertarcadacuenta(ncuentas.C1,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM insertarcadacuenta(ncuentas.C2,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM insertarcadacuenta(ncuentas.C3,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM insertarcadacuenta(ncuentas.C4,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM insertarcadacuenta(ncuentas.C5,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM insertarcadacuenta(ncuentas.C6,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); UPDATE estado_cperiodo SET ec_estado = false WHERE pe_id = nitems.PE_ID; END LOOP; END IF; IF (OLD.es_id = '03' AND (NEW.es_id = '01' OR NEW.es_id = '06')) THEN RAISE NOTICE 'TRIGGER LANZADO! PARA %', OLD.MV_ID; FOR nitems IN SELECT * FROM ITEM_MOVIMIENTO WHERE MV_ID = OLD.MV_ID LOOP SELECT INTO ncuentas substring(PUC_CODIGO from '.') AS C1, substring(PUC_CODIGO from '..') AS C2, substring(PUC_CODIGO from '....') AS C3, substring(PUC_CODIGO from '......') AS C4, substring(PUC_CODIGO from '........') AS C5, substring(PUC_CODIGO from '..........')AS C6 FROM CUENTAS WHERE PUC_CODIGO = nitems.PUC_CODIGO; RAISE NOTICE '%,%,%,%,%,%', ncuentas.C1,ncuentas.C2,ncuentas.C3, ncuentas.C4,ncuentas.C5,ncuentas.C6; PERFORM retirarcadacuenta(ncuentas.C1,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM retirarcadacuenta(ncuentas.C2,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM retirarcadacuenta(ncuentas.C3,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM retirarcadacuenta(ncuentas.C4,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM retirarcadacuenta(ncuentas.C5,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); PERFORM retirarcadacuenta(ncuentas.C6,nitems.IMV_DB,nitems.IMV_CR,nitems.PE_ID); UPDATE estado_cperiodo SET ec_estado = false WHERE pe_id = nitems.PE_ID; END LOOP; END IF; RETURN NEW; END; $$ LANGUAGE plpgsql; %DROP FUNCTION public.contabilizar(); publicpostgresfalse5906125564364 copiarcuentas(character varying)FUNCTIONCCREATE FUNCTION copiarcuentas(character varying) RETURNS integer AS $_$ DECLARE rcuentas RECORD; BEGIN FOR rcuentas IN SELECT puc_codigo FROM puc ORDER BY puc_codigo LOOP INSERT INTO CUENTAS(PUC_CODIGO,PE_ID) VALUES(rcuentas.puc_codigo,$1); END LOOP; RETURN 0; END; $_$ LANGUAGE plpgsql; 7DROP FUNCTION public.copiarcuentas(character varying); publicpostgresfalse6590)125564365crearauxiliares()FUNCTION+CREATE FUNCTION crearauxiliares() RETURNS integer AS $$DECLARE rcuentas RECORD; aux INTEGER; naturaleza VARCHAR(20); BEGIN UPDATE puc SET puc_modificable = FALSE; SELECT into aux CAST(em_valor AS integer) FROM empresa WHERE em_codigo = 'em_frm_puca'; FOR rcuentas IN SELECT puc_codigo, puc_nombre FROM puc WHERE char_length(puc_codigo) >= 6 ORDER BY puc_codigo LOOP IF (rcuentas.puc_codigo < CAST(2 AS character varying) OR (rcuentas.puc_codigo > CAST(5 AS character varying) AND rcuentas.puc_codigo < CAST(9 AS character varying))) THEN naturaleza := 'Debito'; ELSE naturaleza := 'Credito'; END IF; IF aux = 1 THEN INSERT INTO puc(puc_codigo, puc_nombre, puc_naturaleza, puc_modificable) VALUES(rcuentas.puc_codigo || '01',rcuentas.puc_nombre,naturaleza,FALSE); INSERT INTO puc(puc_codigo, puc_nombre, puc_naturaleza) VALUES(rcuentas.puc_codigo || '0101',rcuentas.puc_nombre,naturaleza); END IF; IF aux = 2 THEN INSERT INTO puc(puc_codigo, puc_nombre, puc_naturaleza) VALUES(rcuentas.puc_codigo || '0001',rcuentas.puc_nombre,naturaleza); END IF; IF aux = 5 THEN INSERT INTO puc(puc_codigo, puc_nombre, puc_naturaleza) VALUES(rcuentas.puc_codigo || '01',rcuentas.puc_nombre,naturaleza); END IF; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; (DROP FUNCTION public.crearauxiliares(); publicpostgresfalse6590125564366cuentasnuevoperiodo()FUNCTIONtCREATE FUNCTION cuentasnuevoperiodo() RETURNS integer AS $$ DECLARE rcuentas RECORD; rperiodo RECORD; s_id_periodo VARCHAR; s_mes VARCHAR; BEGIN SELECT INTO rperiodo MAX(P.PE_ID) as A,MAX(P.PE_MES) as B,MAX(P.PE_ANIO) as C,C.CI_ID as D FROM PERIODO P,CICLO C WHERE C.CI_ACTUAL = true AND C.CI_ID=P.CI_ID GROUP BY C.CI_ID; SELECT INTO s_id_periodo aumentar_id(rperiodo.a,8); SELECT INTO s_mes aumentar_id(rperiodo.b,2); UPDATE PERIODO SET PE_ACTUAL = FALSE; INSERT INTO PERIODO (PE_ID,PE_MES,PE_ANIO,PE_ACTUAL,CI_ID) VALUES(s_id_periodo,s_mes,rperiodo.c,true,rperiodo.d); FOR rcuentas IN SELECT puc_codigo FROM puc ORDER BY puc_codigo LOOP INSERT INTO CUENTAS(PUC_CODIGO,PE_ID) VALUES(rcuentas.puc_codigo,s_id_periodo); END LOOP; INSERT INTO estado_cperiodo(pe_id) VALUES(s_id_periodo); RETURN 0; END; $$ LANGUAGE plpgsql; ,DROP FUNCTION public.cuentasnuevoperiodo(); publicpostgresfalse5906125564367cuentasperiodoinicial()FUNCTIONCREATE FUNCTION cuentasperiodoinicial() RETURNS integer AS $$ DECLARE rcuentas RECORD; rperiodo RECORD; s_id_periodo VARCHAR(20); id_ci VARCHAR(20); anio VARCHAR(4); fechaini date; BEGIN UPDATE ciclo SET ci_actual = FALSE; SELECT INTO id_ci aumentar_id((SELECT MAX(ci_id) FROM ciclo),8); SELECT INTO anio aumentar_id((SELECT MAX(ci_anio) FROM ciclo),4); fechaini := anio || '-01-01'; INSERT INTO ciclo(ci_id, ci_fecha_incio, ci_anio) VALUES(id_ci, fechaini, anio); SELECT INTO rperiodo pe_id, ci_id FROM PERIODO WHERE PE_ACTUAL = true; SELECT INTO s_id_periodo aumentar_id(rperiodo.pe_id,8); RAISE NOTICE 'Cerrando el Ciclo %,',rperiodo.ci_id; UPDATE PERIODO SET PE_ACTUAL = FALSE; INSERT INTO PERIODO (PE_ID,PE_MES,PE_ANIO,PE_ACTUAL,CI_ID) VALUES(s_id_periodo,'01',anio,true,id_ci); FOR rcuentas IN SELECT p.puc_codigo, SUM(c.puc_debito) AS debitos, SUM(c.puc_credito) AS creditos FROM puc p , cuentas c, periodo pe WHERE p.puc_codigo = c.puc_codigo AND c.pe_id = pe.pe_id AND pe.ci_id = rperiodo.ci_id GROUP BY p.puc_codigo ORDER BY p.puc_codigo LOOP IF rcuentas.puc_codigo < '4' THEN INSERT INTO CUENTAS(puc_codigo, puc_debito, puc_credito, pe_id) VALUES(rcuentas.puc_codigo,rcuentas.debitos,rcuentas.creditos,s_id_periodo); ELSE INSERT INTO CUENTAS(puc_codigo, pe_id) VALUES(rcuentas.puc_codigo,s_id_periodo); END IF; END LOOP; RETURN 1; END; $$ LANGUAGE plpgsql; .DROP FUNCTION public.cuentasperiodoinicial(); publicpostgresfalse5906125564368equivalenciausd()FUNCTIONCREATE FUNCTION equivalenciausd() RETURNS trigger AS $$ DECLARE nitems RECORD; ncuentas RECORD; s_id_mov VARCHAR; f_tasa FLOAT8; f_valor_db FLOAT8; f_valor_cr FLOAT8; n_result FLOAT8; BEGIN FOR nitems IN SELECT * FROM cuentas_monedas LOOP IF nitems.cm_corigen = NEW.puc_codigo THEN RAISE NOTICE 'Trigger lanzado por el movimiento: %', NEW.mv_id; SELECT INTO f_tasa t.td_valor FROM movimiento m, tasas_cambio_dia t WHERE m.mv_id = NEW.mv_id AND (SELECT pe_anio||'-'||pe_mes FROM periodo WHERE pe_id = m.pe_id)||'-'||m.mv_dia_contabilizacion = t.td_fecha AND t.tc_sigla = m.mv_tasa; IF f_tasa NOTNULL THEN IF NEW.imv_db > 0 THEN n_result := round(CAST ((NEW.imv_db/f_tasa) AS numeric), 2); f_valor_db := n_result; f_valor_cr := 0; ELSE n_result := round(CAST ((NEW.imv_cr/f_tasa) AS numeric), 2); f_valor_db := 0; f_valor_cr := n_result; END IF; SELECT INTO s_id_mov aumentar_id(NEW.imv_id,8); RAISE NOTICE 'El imv_id es: %', s_id_mov; INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_descripcion, imv_db, imv_cr) VALUES(s_id_mov, NEW.mv_id, NEW.cc_id, NEW.te_id, nitems.cm_corden, NEW.pe_id, 'Equivalencia Moneda', f_valor_db,f_valor_cr); SELECT INTO s_id_mov aumentar_id((SELECT MAX(imv_id) FROM item_movimiento),8); RAISE NOTICE 'El imv_id es: %', s_id_mov; INSERT INTO item_movimiento(imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_descripcion, imv_db, imv_cr) VALUES(s_id_mov, NEW.mv_id, NEW.cc_id, NEW.te_id, nitems.cm_corden_contra, NEW.pe_id, 'Equivalencia Moneda', f_valor_cr,f_valor_db); END IF; END IF; END LOOP; RETURN NEW; END; $$ LANGUAGE plpgsql; (DROP FUNCTION public.equivalenciausd(); publicdavidfalse5906125564369\insertarcadacuenta(character varying, double precision, double precision, character varying)FUNCTION,CREATE FUNCTION insertarcadacuenta(cuenta character varying, ndeb double precision, ncre double precision, periodo character varying) RETURNS integer AS $_$ DECLARE debitos ITEM_MOVIMIENTO.IMV_DB%TYPE; creditos ITEM_MOVIMIENTO.IMV_CR%TYPE; BEGIN IF((SELECT PUC_CODIGO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4) IS not null) THEN SELECT INTO debitos PUC_DEBITO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4; SELECT INTO creditos PUC_CREDITO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4; debitos := debitos + $2; creditos := creditos + $3; RAISE NOTICE 'Cuenta a ser actualizada %', $1; UPDATE CUENTAS SET PUC_DEBITO = debitos, PUC_CREDITO = creditos WHERE PUC_CODIGO = $1 AND PE_ID = $4; END IF; RETURN 0; END; $_$ LANGUAGE plpgsql; DROP FUNCTION public.insertarcadacuenta(cuenta character varying, ndeb double precision, ncre double precision, periodo character varying); publicpostgresfalse6590 125564370|insertaritemmovimiento(character varying, character varying, character varying, double precision, double precision, boolean)FUNCTIONCREATE FUNCTION insertaritemmovimiento(character varying, character varying, character varying, double precision, double precision, boolean) RETURNS double precision AS $_$ DECLARE midsaldo RECORD; miditemmov RECORD; saldodis RECORD; idsaldo VARCHAR; iditemmov VARCHAR; cantidad float8; costoAcum float8; kardex RECORD; m_inv VARCHAR; curs1 REFCURSOR; BEGIN costoAcum := 0; SELECT INTO m_inv em_valor FROM empresa WHERE em_codigo = 'inv_valoracion'; IF $6 = true THEN SELECT INTO midsaldo MAX(sa_id) AS m FROM inv_saldos; SELECT INTO idsaldo aumentar_id(midsaldo.m,8); SELECT INTO miditemmov MAX(imv_id) AS m FROM inv_item_movimiento; SELECT INTO iditemmov aumentar_id(miditemmov.m,8); INSERT INTO inv_item_movimiento(imv_id, mv_id, bo_id, pro_id, imv_cantidad, imv_valor, imv_entrada) VALUES(iditemmov, $3, $2, $1, $4, $5, true); INSERT INTO inv_saldos(sa_id, imv_id, mv_id, bo_id, pro_id, sa_cantidad, sa_valoru) VALUES (idsaldo, iditemmov, $3, $2, $1, $4, $5); IF m_inv = '3' THEN SELECT INTO costoAcum sum(sa_cantidad*sa_valoru)/sum(sa_cantidad) FROM inv_saldos WHERE bo_id = $2 AND pro_id = $1; UPDATE inv_saldos SET sa_valoru = costoAcum WHERE bo_id = $2 AND pro_id = $1; END IF; ELSE cantidad = $4; IF m_inv = '1' THEN OPEN curs1 FOR SELECT s.* FROM inv_saldos s,inv_movimiento m WHERE bo_id = $2 AND pro_id = $1 AND m.mv_id = s.mv_id ORDER BY m.mv_fecha_preparacion ASC; ELSIF m_inv = '2' THEN OPEN curs1 FOR SELECT s.* FROM inv_saldos s,inv_movimiento m WHERE bo_id = $2 AND pro_id = $1 AND m.mv_id = s.mv_id ORDER BY m.mv_fecha_preparacion DESC; ELSIF m_inv = '3' THEN SELECT INTO kardex s.pro_id,sum(sa_cantidad) as sa_cantidad,sum(sa_cantidad*sa_valoru)/sum(sa_cantidad) as sa_valoru FROM inv_saldos s WHERE bo_id = $2 AND pro_id = $1 GROUP BY s.pro_id; END IF; IF m_inv = '1' OR m_inv = '2' THEN LOOP FETCH curs1 INTO saldodis; IF NOT FOUND THEN EXIT; -- exit loop END IF; SELECT INTO miditemmov MAX(imv_id) AS m FROM inv_item_movimiento; SELECT INTO iditemmov aumentar_id(miditemmov.m,8); IF cantidad <= saldodis.sa_cantidad AND cantidad > 0 THEN INSERT INTO inv_item_movimiento(imv_id, mv_id, bo_id, pro_id, imv_cantidad, imv_valor, imv_entrada) VALUES(iditemmov, $3, $2, $1, cantidad, saldodis.sa_valoru, false); UPDATE inv_saldos SET sa_cantidad = (saldodis.sa_cantidad - cantidad) WHERE sa_id = saldodis.sa_id; costoAcum := costoAcum + (saldodis.sa_valoru*cantidad); cantidad := 0; END IF; IF cantidad > saldodis.sa_cantidad AND cantidad > 0 THEN INSERT INTO inv_item_movimiento(imv_id, mv_id, bo_id, pro_id, imv_cantidad, imv_valor, imv_entrada) VALUES(iditemmov, $3, $2, $1, saldodis.sa_cantidad, saldodis.sa_valoru, false); UPDATE inv_saldos SET sa_cantidad = 0 WHERE sa_id = saldodis.sa_id; costoAcum := costoAcum + (saldodis.sa_valoru*saldodis.sa_cantidad); cantidad := cantidad - saldodis.sa_cantidad; END IF; END LOOP; ELSIF m_inv = '3' THEN SELECT INTO miditemmov MAX(imv_id) AS m FROM inv_item_movimiento; SELECT INTO iditemmov aumentar_id(miditemmov.m,8); INSERT INTO inv_item_movimiento(imv_id, mv_id, bo_id, pro_id, imv_cantidad, imv_valor, imv_entrada) VALUES(iditemmov, $3, $2, $1, $4, kardex.sa_valoru, false); FOR saldodis IN SELECT s.* FROM inv_saldos s,inv_movimiento m WHERE bo_id = $2 AND pro_id = $1 AND m.mv_id = s.mv_id ORDER BY m.mv_fecha_preparacion LOOP IF cantidad <= saldodis.sa_cantidad AND cantidad > 0 THEN UPDATE inv_saldos SET sa_cantidad = (saldodis.sa_cantidad - cantidad) WHERE sa_id = saldodis.sa_id; costoAcum := costoAcum + (saldodis.sa_valoru*cantidad); cantidad := 0; END IF; IF cantidad > saldodis.sa_cantidad AND cantidad > 0 THEN UPDATE inv_saldos SET sa_cantidad = 0 WHERE sa_id = saldodis.sa_id; costoAcum := costoAcum + (saldodis.sa_valoru*saldodis.sa_cantidad); cantidad := cantidad - saldodis.sa_cantidad; END IF; END LOOP; END IF; costoAcum := costoAcum / $4; IF (cantidad > 0) THEN RAISE EXCEPTION 'No hay disponibilidad del producto % en la bodega % ',$1,$2; END IF; END IF; DELETE FROM inv_saldos WHERE sa_cantidad = 0; RETURN costoAcum; END; $_$ LANGUAGE plpgsql; DROP FUNCTION public.insertaritemmovimiento(character varying, character varying, character varying, double precision, double precision, boolean); publicpostgresfalse6590!125564371lista_correos()FUNCTIONCREATE FUNCTION lista_correos() RETURNS character varying AS $$ DECLARE rcorreos RECORD; correo text; i integer; BEGIN FOR rcorreos IN SELECT me_ccotros FROM op_mensajes WHERE me_ccotros NOTNULL AND me_ccotros != '' LOOP i := 1; correo = split_part(replace(replace(rcorreos.me_ccotros, ',', '~@~'), ';', '~@~'), '~@~', i); WHILE correo <> '' LOOP correo := trim(both ' ' from correo); INSERT INTO temporal VALUES(correo); i := i + 1; correo = split_part(replace(replace(rcorreos.me_ccotros, ',', '~@~'), ';', '~@~'), '~@~', i); END LOOP; END LOOP; RETURN 0; END; $$ LANGUAGE plpgsql; &DROP FUNCTION public.lista_correos(); publicdavidfalse6590"1255643722periodo2date(character varying, character varying)FUNCTIONVCREATE FUNCTION periodo2date(character varying, character varying) RETURNS character varying AS $_$ DECLARE s_fecha VARCHAR(20); rperiodo RECORD; BEGIN SELECT into rperiodo * FROM periodo WHERE pe_id = $1; s_fecha := rperiodo.pe_anio||'-'||rperiodo.pe_mes||'-'||$2; RETURN s_fecha; END; $_$ LANGUAGE plpgsql; IDROP FUNCTION public.periodo2date(character varying, character varying); publicdavidfalse5906#125564373plpgsql_call_handler()FUNCTIONCREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE c; -DROP FUNCTION public.plpgsql_call_handler(); publicpostgresfalse6$125564374plpgsql_validator(oid)FUNCTIONrCREATE FUNCTION plpgsql_validator(oid) RETURNS void AS '$libdir/plpgsql', 'plpgsql_validator' LANGUAGE c; -DROP FUNCTION public.plpgsql_validator(oid); publicpostgresfalse6%125564375[retirarcadacuenta(character varying, double precision, double precision, character varying)FUNCTIONCREATE FUNCTION retirarcadacuenta(character varying, double precision, double precision, character varying) RETURNS integer AS $_$ DECLARE debitos ITEM_MOVIMIENTO.IMV_DB%TYPE; creditos ITEM_MOVIMIENTO.IMV_CR%TYPE; BEGIN IF((SELECT PUC_CODIGO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4) IS not null) THEN SELECT INTO debitos PUC_DEBITO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4; SELECT INTO creditos PUC_CREDITO FROM CUENTAS WHERE PUC_CODIGO = $1 AND PE_ID = $4; debitos := debitos - $2; creditos := creditos - $3; RAISE NOTICE 'Cuenta a ser actualizada %', $1; UPDATE CUENTAS SET PUC_DEBITO = debitos, PUC_CREDITO = creditos WHERE PUC_CODIGO = $1 AND PE_ID = $4; END IF; RETURN 0; END; $_$ LANGUAGE plpgsql; rDROP FUNCTION public.retirarcadacuenta(character varying, double precision, double precision, character varying); publicpostgresfalse6590&125564376xpath_list(text, text)FUNCTIONCREATE FUNCTION xpath_list(text, text) RETURNS text AS $_$SELECT xpath_list($1,$2,',')$_$ LANGUAGE sql IMMUTABLE STRICT; -DROP FUNCTION public.xpath_list(text, text); publicpostgresfalse6'125564377xpath_nodeset(text, text)FUNCTIONCREATE FUNCTION xpath_nodeset(text, text) RETURNS text AS $_$SELECT xpath_nodeset($1,$2,'','')$_$ LANGUAGE sql IMMUTABLE STRICT; 0DROP FUNCTION public.xpath_nodeset(text, text); publicpostgresfalse6(125564378xpath_nodeset(text, text, text)FUNCTIONCREATE FUNCTION xpath_nodeset(text, text, text) RETURNS text AS $_$SELECT xpath_nodeset($1,$2,'',$3)$_$ LANGUAGE sql IMMUTABLE STRICT; 6DROP FUNCTION public.xpath_nodeset(text, text, text); publicpostgresfalse6M125964379estado_cperiodo_ec_id_seqSEQUENCEjCREATE SEQUENCE estado_cperiodo_ec_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; 0DROP SEQUENCE public.estado_cperiodo_ec_id_seq; publicpostgresfalse17796 00estado_cperiodo_ec_id_seqSEQUENCE OWNED BYIALTER SEQUENCE estado_cperiodo_ec_id_seq OWNED BY estado_cperiodo.ec_id; publicpostgresfalse1869 00estado_cperiodo_ec_id_seq SEQUENCE SET@SELECT pg_catalog.setval('estado_cperiodo_ec_id_seq', 2, true); publicpostgresfalse1869 00estado_cperiodo_ec_id_seqACL5REVOKE ALL ON SEQUENCE estado_cperiodo_ec_id_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE estado_cperiodo_ec_id_seq FROM postgres; GRANT ALL ON SEQUENCE estado_cperiodo_ec_id_seq TO postgres; GRANT ALL ON SEQUENCE estado_cperiodo_ec_id_seq TO afiliados; GRANT ALL ON SEQUENCE estado_cperiodo_ec_id_seq TO empresa; publicpostgresfalse1869N125964381fac_reglas_producto_id_seqSEQUENCEkCREATE SEQUENCE fac_reglas_producto_id_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; 1DROP SEQUENCE public.fac_reglas_producto_id_seq; publicpostgresfalse17866 00fac_reglas_producto_id_seqSEQUENCE OWNED BYKALTER SEQUENCE fac_reglas_producto_id_seq OWNED BY fac_reglas_producto.id; publicpostgresfalse1870 00fac_reglas_producto_id_seq SEQUENCE SETBSELECT pg_catalog.setval('fac_reglas_producto_id_seq', 10, true); publicpostgresfalse1870 00fac_reglas_producto_id_seqACLREVOKE ALL ON SEQUENCE fac_reglas_producto_id_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE fac_reglas_producto_id_seq FROM postgres; GRANT ALL ON SEQUENCE fac_reglas_producto_id_seq TO postgres; GRANT ALL ON SEQUENCE fac_reglas_producto_id_seq TO julian; GRANT SELECT,UPDATE ON SEQUENCE fac_reglas_producto_id_seq TO PUBLIC; GRANT SELECT,UPDATE ON SEQUENCE fac_reglas_producto_id_seq TO david; publicpostgresfalse1870h260464383ec_idDEFAULTkALTER TABLE estado_cperiodo ALTER COLUMN ec_id SET DEFAULT nextval('estado_cperiodo_ec_id_seq'::regclass); DALTER TABLE public.estado_cperiodo ALTER COLUMN ec_id DROP DEFAULT; publicpostgresfalse18691779k260464384idDEFAULTmALTER TABLE fac_reglas_producto ALTER COLUMN id SET DEFAULT nextval('fac_reglas_producto_id_seq'::regclass); EALTER TABLE public.fac_reglas_producto ALTER COLUMN id DROP DEFAULT; publicpostgresfalse18701786 063821acciones TABLE DATA>COPY acciones (ac_id, ac_nombre, ac_valor, pf_id) FROM stdin; publicpostgresfalse1766S 063827activos TABLE DATAuCOPY activos (ac_id, ac_nombre, ac_valori, ac_anios, ac_cactivo, ac_cgasto, ac_fecha_adquisicion, cc_id) FROM stdin; publicpostgresfalse1767n 063830ajustesxinflacion TABLE DATAUCOPY ajustesxinflacion (aj_id, aj_cbase, aj_cdebito, aj_ccredito, cc_id) FROM stdin; publicpostgresfalse1768 063833 cancelaciones TABLE DATA@COPY cancelaciones (ca_id, pen_id, mv_id, ca_valor) FROM stdin; publicpostgresfalse1769 063836categoria_regla TABLE DATAKCOPY categoria_regla (cr_id, cr_nombre, cr_visible, ca_aplica) FROM stdin; publicpostgresfalse1770 063843ccosto TABLE DATACOPY ccosto (cc_id, cc_id_sup, cc_nombre, cc_pais, cc_ciudad, cc_direccion, cc_sucursal, cc_r_nombre, cc_r_tel, cc_r_movil, cc_r_mail) FROM stdin; publicpostgresfalse1771 063849ciclo TABLE DATATCOPY ciclo (ci_id, ci_fecha_incio, ci_fecha_cierre, ci_anio, ci_actual) FROM stdin; publicpostgresfalse1772 063853conceptos_nomina TABLE DATACOPY conceptos_nomina (co_id, co_nombre, co_debito, co_credito, co_obligatorio, co_adicional, co_activo, co_orden) FROM stdin; publicpostgresfalse1773 063863cuentas TABLE DATAFCOPY cuentas (puc_codigo, pe_id, puc_debito, puc_credito) FROM stdin; publicpostgresfalse1774" 063868 cuentas_info TABLE DATARCOPY cuentas_info (puc_codigo, pe_id, puc_debito, puc_credito, cc_id) FROM stdin; publicpostgresfalse1775m 063871cuentas_monedas TABLE DATACOPY cuentas_monedas (cm_id, cm_corigen, cm_corden, cm_corden_contra, cm_ingreso_correccion, cm_perdida_correccion) FROM stdin; publicpostgresfalse1776 063874empresa TABLE DATA/COPY empresa (em_codigo, em_valor) FROM stdin; publicpostgresfalse1777 063877estado TABLE DATA;COPY estado (es_id, es_nombre, es_descripcion) FROM stdin; publicpostgresfalse1778  063883estado_cperiodo TABLE DATA;COPY estado_cperiodo (ec_id, pe_id, ec_estado) FROM stdin; publicpostgresfalse1779  063892fac_item_movimiento TABLE DATAxCOPY fac_item_movimiento (imv_id, mv_id, pro_id, bo_id, imv_cantidad, imv_valor, imv_dcto, imv_descripcion) FROM stdin; publicpostgresfalse1781.  063898fac_item_pagos TABLE DATAXCOPY fac_item_pagos (imv_id, mv_id, cc_id, mv_origen, puc_codigo, ip_valor) FROM stdin; publicjulianfalse1782K  063901fac_movimiento TABLE DATAVCOPY fac_movimiento (mv_id, tm_id, us_id, pe_id, mv_fecha_preparacion, mv_dia_contabilizacion, mv_total, mv_observaciones, mv_recibido, mv_entregado, mv_revisado, mv_numero, mv_terceronombre, mv_terceronit, mv_ciudad, mv_direccion, mv_estado, mv_mvinventario, cc_id, mo_sigla, mv_mvcontabilidad, mv_tasa, mv_tipofac, mv_adelanto) FROM stdin; publicpostgresfalse1783h  063908fac_numeracion TABLE DATA`COPY fac_numeracion (nu_id, tm_id, nu_prefijo, nu_descripcion, nu_inicio, nu_final) FROM stdin; publicpostgresfalse1784  063914 fac_pagos TABLE DATA'COPY fac_pagos (mv_id, tm_id, us_id, pe_id, mv_fecha_preparacion, mv_dia_contabilizacion, mv_total, mv_observaciones, mv_autorizado, mv_revisado, mv_numero, mv_terceronombre, mv_terceronit, mv_estado, cc_id, mv_mvcontabilidad, mv_tipo_pago, mv_soporte, mv_cuenta, mo_sigla, mo_tasa) FROM stdin; publicjulianfalse1785  063921fac_reglas_producto TABLE DATASCOPY fac_reglas_producto (re_id, pro_id, imv_id, mv_id, rp_valoru, id) FROM stdin; publicpostgresfalse1786  063924fac_tipo_movimiento TABLE DATAeCOPY fac_tipo_movimiento (tm_id, tm_nombre, tm_descripcion, tm_prefijo_default, tm_tipo) FROM stdin; publicpostgresfalse1787)  063930 funciones TABLE DATAaCOPY funciones (fu_id, fu_nombre, fu_descripcion, fu_prototipo, fu_archivo, fu_tipo) FROM stdin; publicpostgresfalse1788  063936 inv_bodegas TABLE DATAPCOPY inv_bodegas (bo_id, bo_nombre, bo_descripcion, bo_punto_venta) FROM stdin; publicpostgresfalse1789  063942inv_categorias TABLE DATACOPY inv_categorias (ca_id, puc_inventario, puc_gasto, puc_ingreso, puc_costo, puc_dev_des, puc_proveedor, puc_cliente, ca_nombre, ca_ctr_inventario, ca_ctr_consumo, ca_ctr_venta, puc_aprove, puc_perdida, puc_caja) FROM stdin; publicpostgresfalse1790 063948 inv_familias TABLE DATALCOPY inv_familias (fa_id, inv_fa_id, fa_nombre, fa_descripcion) FROM stdin; publicpostgresfalse1791M 063954inv_formas_pago TABLE DATA^COPY inv_formas_pago (fp_id, fp_nombre, fp_termino, fp_descuento, fp_interes_mes) FROM stdin; publicpostgresfalse17927 063957inv_item_movimiento TABLE DATACOPY inv_item_movimiento (imv_id, mv_id, pro_id, bo_id, imv_cantidad, imv_valor, imv_entrada, imv_nacionalizada, imv_umedida, imv_serial, imv_ubicacion) FROM stdin; publicpostgresfalse1793T 063963inv_item_tarja TABLE DATAVCOPY inv_item_tarja (imv_id, mv_tarja, mv_inventario, mv_item_inventario) FROM stdin; publicpostgresfalse1794( 063966inv_items_portafolio TABLE DATA=COPY inv_items_portafolio (ip_id, pp_id, pro_id) FROM stdin; publicpostgresfalse1795( 063969inv_listas_precios TABLE DATAGCOPY inv_listas_precios (lp_id, lp_nombre, lp_descripcion) FROM stdin; publicpostgresfalse1796( 063975inv_movimiento TABLE DATACOPY inv_movimiento (mv_id, tm_id, us_preparo, pe_id, mv_fecha_preparacion, mv_dia_contabilizacion, mv_total, mv_observaciones, mv_recibido, mv_entregado, mv_revisado, mv_numero, mv_mvcontabilidad, mv_terceronombre, mv_terceronit, us_aprobo, mv_fecha_aprobacion) FROM stdin; publicpostgresfalse1797,) 063981inv_numeracion TABLE DATA`COPY inv_numeracion (nu_id, tm_id, nu_prefijo, nu_descripcion, nu_inicio, nu_final) FROM stdin; publicpostgresfalse1798* 063987inv_portafolios TABLE DATADCOPY inv_portafolios (pp_id, pp_nombre, pp_descripcion) FROM stdin; publicpostgresfalse1799=+! 063993 inv_precios TABLE DATAUCOPY inv_precios (pro_id, lp_id, pr_precio, pr_porcentaje, pr_por_costo) FROM stdin; publicpostgresfalse1800Z+" 063996 inv_productos TABLE DATACOPY inv_productos (pro_id, fa_id, un_id, ca_id, tp_id, pro_nombre, pro_descripcion, pro_tiempodevida, pro_stock_max, pro_stock_min, pro_presentacion, pro_marca, pro_serial, pro_cod_barras, pro_estado, pro_costo_base, pro_maneja_kilos) FROM stdin; publicpostgresfalse1801w+# 064003inv_propiedades_producto TABLE DATAUCOPY inv_propiedades_producto (prop_id, pro_id, prop_nombre, prop_valor) FROM stdin; publicpostgresfalse1802?$ 064009inv_reglas_producto TABLE DATA@COPY inv_reglas_producto (re_id, pro_id, rp_compra) FROM stdin; publicpostgresfalse1803@% 064012inv_reglas_tercero TABLE DATA>COPY inv_reglas_tercero (te_id, re_id, rt_compra) FROM stdin; publicpostgresfalse18044@& 064015 inv_saldos TABLE DATAZCOPY inv_saldos (sa_id, imv_id, mv_id, bo_id, pro_id, sa_cantidad, sa_valoru) FROM stdin; publicpostgresfalse1805Q@' 064018inv_subproductos TABLE DATAYCOPY inv_subproductos (pro_id, inv_pro_id, pa_porcentaje_costo, pa_cantidad) FROM stdin; publicpostgresfalse1806S( 064021 inv_tarja TABLE DATACOPY inv_tarja (mv_id, us_preparo, pe_id, mv_fecha_preparacion, mv_dia_contabilizacion, mv_observaciones, mv_numero, mv_terceronombre, mv_terceronit, mv_num_transporte, mv_tip_transporte, mv_hora_llegada, mv_hora_inicio, mv_hora_final, mv_hora_salida, mv_empresa, mv_placa, mv_tipo_carroceria, mv_contenedor, mv_l_carpa, mv_l_techo, mv_l_piso, mv_l_paredes, mv_l_puertas, mv_l_aseo, mv_l_precintos, mv_l_embalaje, mv_l_producto, mv_l_clima, bo_id, mv_funcionario, mv_conductor, mv_tipo) FROM stdin; publicpostgresfalse1807S) 064027inv_tipo_movimiento TABLE DATAeCOPY inv_tipo_movimiento (tm_id, tm_nombre, tm_descripcion, tm_prefijo_default, tm_tipo) FROM stdin; publicpostgresfalse1808T* 064033inv_tipo_producto TABLE DATAFCOPY inv_tipo_producto (tp_id, tp_nombre, tp_descripcion) FROM stdin; publicpostgresfalse1809FU+ 064039 inv_unidades TABLE DATAKCOPY inv_unidades (un_id, un_nombre, un_sigla, un_descripcion) FROM stdin; publicpostgresfalse1810mV 063798item_movimiento TABLE DATACOPY item_movimiento (imv_id, mv_id, cc_id, te_id, puc_codigo, pe_id, imv_numero, imv_descripcion, imv_db, imv_cr) FROM stdin; publicpostgresfalse1762V, 064045 item_nominas TABLE DATA>COPY item_nominas (in_id, no_id, co_id, in_valor) FROM stdin; publicpostgresfalse1811V- 064048logs TABLE DATAVCOPY logs (log_id, log_error_cod, us_id, log_timestamp, log_msj, log_pag) FROM stdin; publicpostgresfalse1812V. 064059moneda TABLE DATASCOPY moneda (mo_id, mo_nativa_nombre, mo_nativa_valor, mo_usd, mo_eur) FROM stdin; publicpostgresfalse1814Xf/ 064062monedas TABLE DATA9COPY monedas (mo_sigla, mo_nombre, mo_local) FROM stdin; publicpostgresfalse1815uf0 064069movi_depreciacion TABLE DATA9COPY movi_depreciacion (md_id, mv_id, ac_id) FROM stdin; publicpostgresfalse1816f 063804 movimiento TABLE DATATCOPY movimiento (mv_id, tm_tipo_movimiento, es_id, mv_fecha_preparacion, us_preparo, mv_fecha_aprobacion, us_aprobo, us_contabilizo, pe_id, mv_fecha_auditoria, mv_numero, mv_plantilla, mv_db, mv_cr, mv_iva, mv_subt, mv_total, mv_observaciones, us_anulo, mv_fecha_anulo, mv_dia_contabilizacion, mo_sigla, mv_tasa, mv_devolucion) FROM stdin; publicpostgresfalse1763f1 064072nominas TABLE DATAKCOPY nominas (no_id, te_id, no_cargo, no_observaciones, cc_id) FROM stdin; publicpostgresfalse1817f2 064078 numeracion TABLE DATA\COPY numeracion (nu_id, nu_prefijo, nu_descripcion, tm_id, nu_inicio, nu_final) FROM stdin; publicpostgresfalse1818g3 064084 op_adjuntos TABLE DATAgCOPY op_adjuntos (ad_id, ad_nombre, ad_tipo, ad_path, me_fecha, of_id, do_anio, do_numero) FROM stdin; publicpostgresfalse1819g4 064090op_carga TABLE DATA}COPY op_carga (of_id, do_anio, do_numero, ca_id, tco_id, ca_numero, ca_peso, ca_descripcion, ca_desc_dtm, te_id) FROM stdin; publicpostgresfalse1820g5 064096 op_ciudades TABLE DATA9COPY op_ciudades (ci_id, ci_nombre, ci_pais) FROM stdin; publicpostgresfalse1821g6 064102op_contabilidad TABLE DATALCOPY op_contabilidad (of_id, do_anio, do_numero, imv_id, mv_id) FROM stdin; publicpostgresfalse1822h7 064105 op_diario TABLE DATABCOPY op_diario (of_id, do_anio, do_numero, of_puerto) FROM stdin; publicjulianfalse18233h8 064108op_dtm TABLE DATACOPY op_dtm (od_id, of_id, do_anio, do_numero, od_numero, od_consignor, od_shipping, od_dir_consignor, od_dir_shipping, od_modorgdest1, od_modorgdest2, od_modorgdest3, od_modorgdest4, od_intruc_manejo, od_fecha_entrega, od_originaldtm, od_tipocarga, od_lugarentrega, od_valor, od_observaciones, od_prepaid, od_currencypre, od_collect, od_currencycoll, od_lugarexp, od_firma, od_fechaexp) FROM stdin; publicpostgresfalse1824Ph9 064114 op_estados TABLE DATA/COPY op_estados (es_id, es_nombre) FROM stdin; publicpostgresfalse1825mh: 064120 op_etapas TABLE DATA5COPY op_etapas (et_id, se_id, et_nombre) FROM stdin; publicpostgresfalse1826h; 064126 op_etapas_do TABLE DATAWCOPY op_etapas_do (of_id, do_anio, do_numero, et_id, et_nombre, et_actual) FROM stdin; publicpostgresfalse1827h< 064133op_facturacion TABLE DATACCOPY op_facturacion (of_id, do_anio, do_numero, mv_id) FROM stdin; publicpostgresfalse1828h= 064136op_hitos TABLE DATAXCOPY op_hitos (hi_id, et_id, se_id, hi_nombre, hi_responsable, hi_duracion) FROM stdin; publicpostgresfalse1829h> 064142 op_hitos_do TABLE DATACOPY op_hitos_do (of_id, do_anio, do_numero, et_id, hi_id, hi_nombre, hi_responsable, hi_cumplido, hi_fecha, hi_alarma, hi_alarmas_no) FROM stdin; publicpostgresfalse1830h? 064149op_informacion_despacho TABLE DATACOPY op_informacion_despacho (ca_id, of_id, do_anio, do_numero, id_carpo, id_cargue, id_despa, id_placa, id_conduc, id_peso, id_placaesc, id_conducesc, id_transportador) FROM stdin; publicpostgresfalse1831i@ 064155op_informacion_puerto TABLE DATA+COPY op_informacion_puerto (do_numero, do_anio, of_id, ip_eta_a, ip_eta_f, ip_veb_a, ip_veb_f, ip_ved_a, ip_ved_f, ip_rso_a, ip_rso_f, ip_dco_a, ip_dco_f, ip_rad_a, ip_rad_f, ip_lin_a, ip_lin_f, ip_con_a, ip_con_f, ip_rab_a, ip_rab_f, ip_not_a, ip_not_f, ip_rei_a, ip_rei_f, ip_num_dtm) FROM stdin; publicpostgresfalse18328iA 064172 op_inventario TABLE DATABCOPY op_inventario (of_id, do_anio, do_numero, mv_id) FROM stdin; publicpostgresfalse1833UiB 064175op_item_agente TABLE DATA}COPY op_item_agente (ia_id, so_id, ia_concepto, ia_resposable, ia_costo, ia_venta, ia_profit_glo, ia_profit_age) FROM stdin; publicpostgresfalse1834riC 064181op_item_liquidacion TABLE DATAnCOPY op_item_liquidacion (il_id, il_concepto, il_cantidad, il_tarifa, so_id, il_estado, mo_sigla) FROM stdin; publicpostgresfalse1835iD 064189 op_mensajes TABLE DATACOPY op_mensajes (me_fecha, tm_id, of_id, do_anio, do_numero, me_texto, us_id_preparo, us_id_from, us_id_to, me_tecopia, me_ccotros) FROM stdin; publicpostgresfalse1836iE 064197op_mensajes_externos TABLE DATA8COPY op_mensajes_externos (msj_id, msj_txt) FROM stdin; publicpostgresfalse1838iF 064204 op_oficinas TABLE DATA@COPY op_oficinas (of_id, cc_id, of_nombre, of_tipo) FROM stdin; publicpostgresfalse1839iG 064210 op_ordenes TABLE DATACOPY op_ordenes (of_id, do_anio, do_numero, pu_origen, pu_destino, ci_origen, ci_destino, se_id, do_num_transporte, do_tip_transporte, do_fecha_preparacion, do_cont_nombre, do_cont_telefono, do_cont_celular, do_cont_email, do_cont_dir, do_cont_obs, do_dir_origen, do_dir_destino, do_carga_valor, do_vendedor, do_tipo_carga, do_cont_nit, op_lclnobultos, op_lclpeso, op_lcldesc, op_cargaobs, es_id, us_preparo, op_lclvolumen, op_lclcarpo, op_lclcargue, op_lcldespa, op_lclplaca, op_lclconduc, op_lcldpeso, mv_cotizacion, op_observaciones, op_ttarifa, op_vflete_maritimo, op_vflete_terrestre, op_tcflete_maritimo, op_tcflete_terrestre, op_fchflete_maritimo, op_fchflete_terrestre, op_tcmflete_maritimo, op_tcmflete_terrestre) FROM stdin; publicpostgresfalse1840jH 064216op_pagos TABLE DATA>COPY op_pagos (of_id, do_anio, do_numero, imv_id) FROM stdin; publicpostgresfalse1841 jI 064219 op_puertos TABLE DATAACOPY op_puertos (pu_id, pu_nombre, pu_tipo, pu_pais) FROM stdin; publicpostgresfalse1842=jJ 064227op_seguimiento TABLE DATA[COPY op_seguimiento (se_id, se_fecha, se_lugar, se_contenedor, se_descripcion) FROM stdin; publicpostgresfalse1844ZjK 064234 op_servicios TABLE DATAjCOPY op_servicios (se_id, se_nombre, se_descripcion, se_tmaritimo, se_tpuerto, se_tterrestre) FROM stdin; publicpostgresfalse1845wjL 064240op_solicitudes TABLE DATACOPY op_solicitudes (of_id, do_anio, do_numero, so_fecha_soli, us_id, so_obs, so_deposito_1, so_deposito_2, so_deposito_3, so_deposito_4, so_deposito_5, so_agente_id, so_agente_nombre, so_id) FROM stdin; publicpostgresfalse1846jM 064246op_tipo_mensaje TABLE DATANCOPY op_tipo_mensaje (tm_id, tm_nombre, tm_image, tm_visibilidad) FROM stdin; publicpostgresfalse1847jN 064252op_tipos_carga TABLE DATAFCOPY op_tipos_carga (tca_id, tca_nombre, tca_descripcion) FROM stdin; publicpostgresfalse1848jO 064258op_tipos_contenedor TABLE DATAKCOPY op_tipos_contenedor (tco_id, tco_nombre, tco_descripcion) FROM stdin; publicpostgresfalse1849jP 064264op_tipos_empaque TABLE DATA?COPY op_tipos_empaque (te_id, te_nombre, te_sigla) FROM stdin; publicpostgresfalse1850kQ 064267op_usuarios_oficinas TABLE DATA5COPY op_usuarios_oficinas (of_id, us_id) FROM stdin; publicpostgresfalse1851%kR 064270paag TABLE DATA/COPY paag (pa_id, pa_valor, pe_id) FROM stdin; publicpostgresfalse1852BkS 064273 parametros TABLE DATAmCOPY parametros (pa_id, pa_nombre, pa_tipo_dato, pa_valor, pa_indice, pa_confirmacion, re_regla) FROM stdin; publicpostgresfalse1853_kT 064279 pendientes TABLE DATACOPY pendientes (pen_id, pen_fecha_cumplimiento, pen_activo, us_usuario, pen_descripcion, tp_id, mv_origen, pen_numero, pen_valor, pen_tercero, mv_destino) FROM stdin; publicpostgresfalse1854|kU 064286perfiles TABLE DATA<COPY perfiles (pf_id, pf_nombre, pf_modulo_def) FROM stdin; publicpostgresfalse1855kV 064290periodo TABLE DATAPCOPY periodo (pe_id, pe_mes, pe_anio, pe_actual, ci_id, pe_cerrado) FROM stdin; publicpostgresfalse18563lW 064294puc TABLE DATAhCOPY puc (puc_nombre, puc_tercero, puc_ccosto, puc_codigo, puc_naturaleza, puc_modificable) FROM stdin; publicpostgresfalse1857dlX 064298recursos TABLE DATA\COPY recursos (re_id, re_ambito, re_codigo, re_tipo, re_nombre, re_descripcion) FROM stdin; publicpostgresfalse1858mY 064304reglas TABLE DATACOPY reglas (re_id, re_interactividad, re_nombre, tr_tipo_regla, fu_funcion, puc_disparadora, puc_debito, tm_tipo_movimiento, puc_credito, cr_categoria, re_activa, re_visible, re_inv, re_cppal) FROM stdin; publicpostgresfalse18595mZ 064313 reglas_nomina TABLE DATA<COPY reglas_nomina (rn_id, re_id, te_id, no_id) FROM stdin; publicpostgresfalse1860Rm[ 064316reglas_nomina_bases TABLE DATAFCOPY reglas_nomina_bases (rnb_id, re_id, co_id, rnb_base) FROM stdin; publicpostgresfalse1861om\ 064319 tasas_cambio TABLE DATA>COPY tasas_cambio (tc_sigla, tc_nombre, mo_sigla) FROM stdin; publicpostgresfalse1862m] 064325tasas_cambio_dia TABLE DATAACOPY tasas_cambio_dia (td_fecha, td_valor, tc_sigla) FROM stdin; publicpostgresfalse1863m 063810tercero TABLE DATACOPY tercero (tt_id, te_id, te_nombre, te_pais, te_ciudad, te_direccion, te_telefonos, te_mail, te_fax, te_tipofiscal, te_actividad, te_comision, te_descuentos, te_observaciones, te_apellido, te_password) FROM stdin; publicpostgresfalse1764m^ 064328tipo_movimiento TABLE DATAXCOPY tipo_movimiento (tm_id, tm_nombre, tm_descripcion, tm_prefijo_default) FROM stdin; publicpostgresfalse1864n_ 064334tipo_pendiente TABLE DATACCOPY tipo_pendiente (tp_id, tp_nombre, tp_descripcion) FROM stdin; publicpostgresfalse1865o` 064340 tipo_regla TABLE DATA?COPY tipo_regla (tr_id, tr_descripcion, tr_nombre) FROM stdin; publicpostgresfalse1866pa 064346 tipo_tercero TABLE DATAACOPY tipo_tercero (tt_id, tt_nombre, tt_descripcion) FROM stdin; publicpostgresfalse1867pb 064352usuario TABLE DATAhCOPY usuario (us_id, us_login, us_password, us_nombre, us_mail, us_nivel, us_activo, pf_id) FROM stdin; publicpostgresfalse1868p260665756ak_unique_index_numer_fac_movi CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT ak_unique_index_numer_fac_movi UNIQUE (mv_numero); ALTER TABLE fac_movimiento CLUSTER ON ak_unique_index_numer_fac_movi; WALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT ak_unique_index_numer_fac_movi; publicpostgresfalse17831783260665758ak_unique_index_numer_fac_pago CONSTRAINTaALTER TABLE ONLY fac_pagos ADD CONSTRAINT ak_unique_index_numer_fac_pago UNIQUE (mv_numero); RALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT ak_unique_index_numer_fac_pago; publicjulianfalse17851785260665760ak_unique_index_numer_inv_movi CONSTRAINTfALTER TABLE ONLY inv_movimiento ADD CONSTRAINT ak_unique_index_numer_inv_movi UNIQUE (mv_numero); WALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT ak_unique_index_numer_inv_movi; publicpostgresfalse17971797260665762ak_unique_index_sigla_inv_unid CONSTRAINTcALTER TABLE ONLY inv_unidades ADD CONSTRAINT ak_unique_index_sigla_inv_unid UNIQUE (un_sigla); UALTER TABLE ONLY public.inv_unidades DROP CONSTRAINT ak_unique_index_sigla_inv_unid; publicpostgresfalse181018108 260665764fk_op_usuarios_oficinas CONSTRAINTmALTER TABLE ONLY op_usuarios_oficinas ADD CONSTRAINT fk_op_usuarios_oficinas PRIMARY KEY (of_id, us_id); VALTER TABLE ONLY public.op_usuarios_oficinas DROP CONSTRAINT fk_op_usuarios_oficinas; publicpostgresfalse185118511851260665766 monedas_pkey CONSTRAINTQALTER TABLE ONLY monedas ADD CONSTRAINT monedas_pkey PRIMARY KEY (mo_sigla); >ALTER TABLE ONLY public.monedas DROP CONSTRAINT monedas_pkey; publicpostgresfalse18151815260665768 pk_acciones CONSTRAINTUALTER TABLE ONLY acciones ADD CONSTRAINT pk_acciones PRIMARY KEY (ac_id, pf_id); >ALTER TABLE ONLY public.acciones DROP CONSTRAINT pk_acciones; publicpostgresfalse176617661766260665770 pk_activos CONSTRAINTLALTER TABLE ONLY activos ADD CONSTRAINT pk_activos PRIMARY KEY (ac_id); <ALTER TABLE ONLY public.activos DROP CONSTRAINT pk_activos; publicpostgresfalse17671767260665772pk_ajustesxinflacion CONSTRAINT`ALTER TABLE ONLY ajustesxinflacion ADD CONSTRAINT pk_ajustesxinflacion PRIMARY KEY (aj_id); PALTER TABLE ONLY public.ajustesxinflacion DROP CONSTRAINT pk_ajustesxinflacion; publicpostgresfalse17681768260665774pk_cancelaciones CONSTRAINTXALTER TABLE ONLY cancelaciones ADD CONSTRAINT pk_cancelaciones PRIMARY KEY (ca_id); HALTER TABLE ONLY public.cancelaciones DROP CONSTRAINT pk_cancelaciones; publicpostgresfalse17691769! 260665776pk_centros_operacion CONSTRAINTZALTER TABLE ONLY op_oficinas ADD CONSTRAINT pk_centros_operacion PRIMARY KEY (of_id); JALTER TABLE ONLY public.op_oficinas DROP CONSTRAINT pk_centros_operacion; publicpostgresfalse18391839260665778pk_conceptos_nomina CONSTRAINT^ALTER TABLE ONLY conceptos_nomina ADD CONSTRAINT pk_conceptos_nomina PRIMARY KEY (co_id); NALTER TABLE ONLY public.conceptos_nomina DROP CONSTRAINT pk_conceptos_nomina; publicpostgresfalse17731773260665780pk_cuentas_info CONSTRAINTiALTER TABLE ONLY cuentas_info ADD CONSTRAINT pk_cuentas_info PRIMARY KEY (puc_codigo, pe_id, cc_id); FALTER TABLE ONLY public.cuentas_info DROP CONSTRAINT pk_cuentas_info; publicpostgresfalse1775177517751775260665782pk_cuentas_monedas CONSTRAINT\ALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT pk_cuentas_monedas PRIMARY KEY (cm_id); LALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT pk_cuentas_monedas; publicpostgresfalse17761776260665784 pk_empresa CONSTRAINTPALTER TABLE ONLY empresa ADD CONSTRAINT pk_empresa PRIMARY KEY (em_codigo); <ALTER TABLE ONLY public.empresa DROP CONSTRAINT pk_empresa; publicpostgresfalse17771777260665786 pk_estado CONSTRAINTJALTER TABLE ONLY estado ADD CONSTRAINT pk_estado PRIMARY KEY (es_id); :ALTER TABLE ONLY public.estado DROP CONSTRAINT pk_estado; publicpostgresfalse17781778260665788pk_estado_cperiodo CONSTRAINT\ALTER TABLE ONLY estado_cperiodo ADD CONSTRAINT pk_estado_cperiodo PRIMARY KEY (ec_id); LALTER TABLE ONLY public.estado_cperiodo DROP CONSTRAINT pk_estado_cperiodo; publicpostgresfalse17791779260665790pk_fac_item_movimiento CONSTRAINTlALTER TABLE ONLY fac_item_movimiento ADD CONSTRAINT pk_fac_item_movimiento PRIMARY KEY (imv_id, mv_id); TALTER TABLE ONLY public.fac_item_movimiento DROP CONSTRAINT pk_fac_item_movimiento; publicpostgresfalse178117811781260665792pk_fac_item_pagos CONSTRAINT[ALTER TABLE ONLY fac_item_pagos ADD CONSTRAINT pk_fac_item_pagos PRIMARY KEY (imv_id); JALTER TABLE ONLY public.fac_item_pagos DROP CONSTRAINT pk_fac_item_pagos; publicjulianfalse17821782260665794pk_fac_movimiento CONSTRAINTZALTER TABLE ONLY fac_movimiento ADD CONSTRAINT pk_fac_movimiento PRIMARY KEY (mv_id); JALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT pk_fac_movimiento; publicpostgresfalse17831783260665796pk_fac_numeracion CONSTRAINTZALTER TABLE ONLY fac_numeracion ADD CONSTRAINT pk_fac_numeracion PRIMARY KEY (nu_id); JALTER TABLE ONLY public.fac_numeracion DROP CONSTRAINT pk_fac_numeracion; publicpostgresfalse17841784260665798 pk_fac_pagos CONSTRAINTPALTER TABLE ONLY fac_pagos ADD CONSTRAINT pk_fac_pagos PRIMARY KEY (mv_id); @ALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT pk_fac_pagos; publicjulianfalse17851785260665800pk_fac_tipo_movimiento CONSTRAINTdALTER TABLE ONLY fac_tipo_movimiento ADD CONSTRAINT pk_fac_tipo_movimiento PRIMARY KEY (tm_id); TALTER TABLE ONLY public.fac_tipo_movimiento DROP CONSTRAINT pk_fac_tipo_movimiento; publicpostgresfalse17871787260665802pk_facturacion CONSTRAINTSALTER TABLE ONLY numeracion ADD CONSTRAINT pk_facturacion PRIMARY KEY (nu_id); CALTER TABLE ONLY public.numeracion DROP CONSTRAINT pk_facturacion; publicpostgresfalse18181818260665804 pk_funciones CONSTRAINTPALTER TABLE ONLY funciones ADD CONSTRAINT pk_funciones PRIMARY KEY (fu_id); @ALTER TABLE ONLY public.funciones DROP CONSTRAINT pk_funciones; publicpostgresfalse17881788260665806pk_inv_bodegas CONSTRAINTTALTER TABLE ONLY inv_bodegas ADD CONSTRAINT pk_inv_bodegas PRIMARY KEY (bo_id); DALTER TABLE ONLY public.inv_bodegas DROP CONSTRAINT pk_inv_bodegas; publicpostgresfalse17891789260665808pk_inv_categorias CONSTRAINTZALTER TABLE ONLY inv_categorias ADD CONSTRAINT pk_inv_categorias PRIMARY KEY (ca_id); JALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT pk_inv_categorias; publicpostgresfalse17901790260665810pk_inv_familias CONSTRAINTVALTER TABLE ONLY inv_familias ADD CONSTRAINT pk_inv_familias PRIMARY KEY (fa_id); FALTER TABLE ONLY public.inv_familias DROP CONSTRAINT pk_inv_familias; publicpostgresfalse17911791260665812pk_inv_formas_pago CONSTRAINT\ALTER TABLE ONLY inv_formas_pago ADD CONSTRAINT pk_inv_formas_pago PRIMARY KEY (fp_id); LALTER TABLE ONLY public.inv_formas_pago DROP CONSTRAINT pk_inv_formas_pago; publicpostgresfalse17921792260665814pk_inv_item_movimiento CONSTRAINTlALTER TABLE ONLY inv_item_movimiento ADD CONSTRAINT pk_inv_item_movimiento PRIMARY KEY (imv_id, mv_id); TALTER TABLE ONLY public.inv_item_movimiento DROP CONSTRAINT pk_inv_item_movimiento; publicpostgresfalse179317931793260665816pk_inv_item_tarja CONSTRAINT[ALTER TABLE ONLY inv_item_tarja ADD CONSTRAINT pk_inv_item_tarja PRIMARY KEY (imv_id); JALTER TABLE ONLY public.inv_item_tarja DROP CONSTRAINT pk_inv_item_tarja; publicpostgresfalse17941794260665818pk_inv_items_portafolio CONSTRAINTuALTER TABLE ONLY inv_items_portafolio ADD CONSTRAINT pk_inv_items_portafolio PRIMARY KEY (pp_id, pro_id, ip_id); VALTER TABLE ONLY public.inv_items_portafolio DROP CONSTRAINT pk_inv_items_portafolio; publicpostgresfalse1795179517951795260665820pk_inv_listas_precios CONSTRAINTbALTER TABLE ONLY inv_listas_precios ADD CONSTRAINT pk_inv_listas_precios PRIMARY KEY (lp_id); RALTER TABLE ONLY public.inv_listas_precios DROP CONSTRAINT pk_inv_listas_precios; publicpostgresfalse17961796260665822pk_inv_movimiento CONSTRAINTZALTER TABLE ONLY inv_movimiento ADD CONSTRAINT pk_inv_movimiento PRIMARY KEY (mv_id); JALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT pk_inv_movimiento; publicpostgresfalse17971797260665824pk_inv_numeracion CONSTRAINTZALTER TABLE ONLY inv_numeracion ADD CONSTRAINT pk_inv_numeracion PRIMARY KEY (nu_id); JALTER TABLE ONLY public.inv_numeracion DROP CONSTRAINT pk_inv_numeracion; publicpostgresfalse17981798260665826pk_inv_portafolios CONSTRAINT\ALTER TABLE ONLY inv_portafolios ADD CONSTRAINT pk_inv_portafolios PRIMARY KEY (pp_id); LALTER TABLE ONLY public.inv_portafolios DROP CONSTRAINT pk_inv_portafolios; publicpostgresfalse17991799260665828pk_inv_precios CONSTRAINT\ALTER TABLE ONLY inv_precios ADD CONSTRAINT pk_inv_precios PRIMARY KEY (pro_id, lp_id); DALTER TABLE ONLY public.inv_precios DROP CONSTRAINT pk_inv_precios; publicpostgresfalse180018001800260665830pk_inv_productos CONSTRAINTYALTER TABLE ONLY inv_productos ADD CONSTRAINT pk_inv_productos PRIMARY KEY (pro_id); HALTER TABLE ONLY public.inv_productos DROP CONSTRAINT pk_inv_productos; publicpostgresfalse18011801260665832pk_inv_propiedades_producto CONSTRAINTxALTER TABLE ONLY inv_propiedades_producto ADD CONSTRAINT pk_inv_propiedades_producto PRIMARY KEY (prop_id, pro_id); ^ALTER TABLE ONLY public.inv_propiedades_producto DROP CONSTRAINT pk_inv_propiedades_producto; publicpostgresfalse180218021802260665834pk_inv_reglas_producto CONSTRAINTlALTER TABLE ONLY inv_reglas_producto ADD CONSTRAINT pk_inv_reglas_producto PRIMARY KEY (re_id, pro_id); TALTER TABLE ONLY public.inv_reglas_producto DROP CONSTRAINT pk_inv_reglas_producto; publicpostgresfalse180318031803260665836pk_inv_reglas_tercero CONSTRAINTiALTER TABLE ONLY inv_reglas_tercero ADD CONSTRAINT pk_inv_reglas_tercero PRIMARY KEY (re_id, te_id); RALTER TABLE ONLY public.inv_reglas_tercero DROP CONSTRAINT pk_inv_reglas_tercero; publicpostgresfalse180418041804260665838 pk_inv_saldos CONSTRAINTRALTER TABLE ONLY inv_saldos ADD CONSTRAINT pk_inv_saldos PRIMARY KEY (sa_id); BALTER TABLE ONLY public.inv_saldos DROP CONSTRAINT pk_inv_saldos; publicpostgresfalse18051805260665840pk_inv_subproductos CONSTRAINTkALTER TABLE ONLY inv_subproductos ADD CONSTRAINT pk_inv_subproductos PRIMARY KEY (pro_id, inv_pro_id); NALTER TABLE ONLY public.inv_subproductos DROP CONSTRAINT pk_inv_subproductos; publicpostgresfalse180618061806260665842 pk_inv_tarja CONSTRAINTPALTER TABLE ONLY inv_tarja ADD CONSTRAINT pk_inv_tarja PRIMARY KEY (mv_id); @ALTER TABLE ONLY public.inv_tarja DROP CONSTRAINT pk_inv_tarja; publicpostgresfalse18071807260665844pk_inv_tipo_movimiento CONSTRAINTdALTER TABLE ONLY inv_tipo_movimiento ADD CONSTRAINT pk_inv_tipo_movimiento PRIMARY KEY (tm_id); TALTER TABLE ONLY public.inv_tipo_movimiento DROP CONSTRAINT pk_inv_tipo_movimiento; publicpostgresfalse18081808260665846pk_inv_tipo_producto CONSTRAINT`ALTER TABLE ONLY inv_tipo_producto ADD CONSTRAINT pk_inv_tipo_producto PRIMARY KEY (tp_id); PALTER TABLE ONLY public.inv_tipo_producto DROP CONSTRAINT pk_inv_tipo_producto; publicpostgresfalse18091809260665848pk_inv_unidades CONSTRAINTVALTER TABLE ONLY inv_unidades ADD CONSTRAINT pk_inv_unidades PRIMARY KEY (un_id); FALTER TABLE ONLY public.inv_unidades DROP CONSTRAINT pk_inv_unidades; publicpostgresfalse18101810 260665850pk_item_liquidacion CONSTRAINTaALTER TABLE ONLY op_item_liquidacion ADD CONSTRAINT pk_item_liquidacion PRIMARY KEY (il_id); QALTER TABLE ONLY public.op_item_liquidacion DROP CONSTRAINT pk_item_liquidacion; publicpostgresfalse18351835260665852pk_item_movimiento CONSTRAINTALTER TABLE ONLY item_movimiento ADD CONSTRAINT pk_item_movimiento PRIMARY KEY (imv_id, mv_id); ALTER TABLE item_movimiento CLUSTER ON pk_item_movimiento; LALTER TABLE ONLY public.item_movimiento DROP CONSTRAINT pk_item_movimiento; publicpostgresfalse176217621762260665854pk_item_nominas CONSTRAINTVALTER TABLE ONLY item_nominas ADD CONSTRAINT pk_item_nominas PRIMARY KEY (in_id); FALTER TABLE ONLY public.item_nominas DROP CONSTRAINT pk_item_nominas; publicpostgresfalse18111811260665856pk_logs CONSTRAINTGALTER TABLE ONLY logs ADD CONSTRAINT pk_logs PRIMARY KEY (log_id); 6ALTER TABLE ONLY public.logs DROP CONSTRAINT pk_logs; publicpostgresfalse18121812260665858 pk_moneda CONSTRAINTJALTER TABLE ONLY moneda ADD CONSTRAINT pk_moneda PRIMARY KEY (mo_id); :ALTER TABLE ONLY public.moneda DROP CONSTRAINT pk_moneda; publicpostgresfalse18141814260665860pk_movi_depreciacion CONSTRAINT`ALTER TABLE ONLY movi_depreciacion ADD CONSTRAINT pk_movi_depreciacion PRIMARY KEY (md_id); PALTER TABLE ONLY public.movi_depreciacion DROP CONSTRAINT pk_movi_depreciacion; publicpostgresfalse18161816260665862 pk_movimiento CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT pk_movimiento PRIMARY KEY (mv_id); ALTER TABLE movimiento CLUSTER ON pk_movimiento; BALTER TABLE ONLY public.movimiento DROP CONSTRAINT pk_movimiento; publicpostgresfalse17631763260665864 pk_nominas CONSTRAINTLALTER TABLE ONLY nominas ADD CONSTRAINT pk_nominas PRIMARY KEY (no_id); <ALTER TABLE ONLY public.nominas DROP CONSTRAINT pk_nominas; publicpostgresfalse18171817260665866pk_op_adjuntos CONSTRAINTTALTER TABLE ONLY op_adjuntos ADD CONSTRAINT pk_op_adjuntos PRIMARY KEY (ad_id); DALTER TABLE ONLY public.op_adjuntos DROP CONSTRAINT pk_op_adjuntos; publicpostgresfalse18191819260665868 pk_op_carga CONSTRAINTiALTER TABLE ONLY op_carga ADD CONSTRAINT pk_op_carga PRIMARY KEY (ca_id, of_id, do_anio, do_numero); >ALTER TABLE ONLY public.op_carga DROP CONSTRAINT pk_op_carga; publicpostgresfalse18201820182018201820 260665870pk_op_ciudades CONSTRAINTTALTER TABLE ONLY op_ciudades ADD CONSTRAINT pk_op_ciudades PRIMARY KEY (ci_id); DALTER TABLE ONLY public.op_ciudades DROP CONSTRAINT pk_op_ciudades; publicpostgresfalse18211821 260665872pk_op_contabilidad CONSTRAINTxALTER TABLE ONLY op_contabilidad ADD CONSTRAINT pk_op_contabilidad PRIMARY KEY (of_id, do_anio, do_numero, imv_id); LALTER TABLE ONLY public.op_contabilidad DROP CONSTRAINT pk_op_contabilidad; publicpostgresfalse18221822182218221822 260665874 pk_op_diario CONSTRAINToALTER TABLE ONLY op_diario ADD CONSTRAINT pk_op_diario PRIMARY KEY (of_puerto, of_id, do_anio, do_numero); @ALTER TABLE ONLY public.op_diario DROP CONSTRAINT pk_op_diario; publicjulianfalse18231823182318231823 260665876 pk_op_dtm CONSTRAINTJALTER TABLE ONLY op_dtm ADD CONSTRAINT pk_op_dtm PRIMARY KEY (od_id); :ALTER TABLE ONLY public.op_dtm DROP CONSTRAINT pk_op_dtm; publicpostgresfalse18241824 260665878 pk_op_estados CONSTRAINTRALTER TABLE ONLY op_estados ADD CONSTRAINT pk_op_estados PRIMARY KEY (es_id); BALTER TABLE ONLY public.op_estados DROP CONSTRAINT pk_op_estados; publicpostgresfalse18251825 260665880 pk_op_etapas CONSTRAINTALTER TABLE ONLY op_etapas ADD CONSTRAINT pk_op_etapas PRIMARY KEY (et_id, se_id); ALTER TABLE op_etapas CLUSTER ON pk_op_etapas; @ALTER TABLE ONLY public.op_etapas DROP CONSTRAINT pk_op_etapas; publicpostgresfalse182618261826 260665882pk_op_etapas_do CONSTRAINTALTER TABLE ONLY op_etapas_do ADD CONSTRAINT pk_op_etapas_do PRIMARY KEY (et_id, of_id, do_anio, do_numero); ALTER TABLE op_etapas_do CLUSTER ON pk_op_etapas_do; FALTER TABLE ONLY public.op_etapas_do DROP CONSTRAINT pk_op_etapas_do; publicpostgresfalse18271827182718271827 260665884pk_op_facturacion CONSTRAINTuALTER TABLE ONLY op_facturacion ADD CONSTRAINT pk_op_facturacion PRIMARY KEY (of_id, do_anio, do_numero, mv_id); JALTER TABLE ONLY public.op_facturacion DROP CONSTRAINT pk_op_facturacion; publicpostgresfalse18281828182818281828 260665886 pk_op_hitos CONSTRAINTALTER TABLE ONLY op_hitos ADD CONSTRAINT pk_op_hitos PRIMARY KEY (hi_id, et_id, se_id); ALTER TABLE op_hitos CLUSTER ON pk_op_hitos; >ALTER TABLE ONLY public.op_hitos DROP CONSTRAINT pk_op_hitos; publicpostgresfalse1829182918291829 260665888pk_op_hitos_do CONSTRAINTALTER TABLE ONLY op_hitos_do ADD CONSTRAINT pk_op_hitos_do PRIMARY KEY (hi_id, et_id, of_id, do_anio, do_numero); ALTER TABLE op_hitos_do CLUSTER ON pk_op_hitos_do; DALTER TABLE ONLY public.op_hitos_do DROP CONSTRAINT pk_op_hitos_do; publicpostgresfalse183018301830183018301830 260665890pk_op_informacion_despacho CONSTRAINTALTER TABLE ONLY op_informacion_despacho ADD CONSTRAINT pk_op_informacion_despacho PRIMARY KEY (ca_id, of_id, do_anio, do_numero); \ALTER TABLE ONLY public.op_informacion_despacho DROP CONSTRAINT pk_op_informacion_despacho; publicpostgresfalse18311831183118311831 260665892pk_op_informacion_puerto CONSTRAINT|ALTER TABLE ONLY op_informacion_puerto ADD CONSTRAINT pk_op_informacion_puerto PRIMARY KEY (do_numero, do_anio, of_id); XALTER TABLE ONLY public.op_informacion_puerto DROP CONSTRAINT pk_op_informacion_puerto; publicpostgresfalse1832183218321832 260665894pk_op_inventario CONSTRAINTsALTER TABLE ONLY op_inventario ADD CONSTRAINT pk_op_inventario PRIMARY KEY (of_id, do_anio, do_numero, mv_id); HALTER TABLE ONLY public.op_inventario DROP CONSTRAINT pk_op_inventario; publicpostgresfalse18331833183318331833 260665896pk_op_item_agente CONSTRAINTZALTER TABLE ONLY op_item_agente ADD CONSTRAINT pk_op_item_agente PRIMARY KEY (ia_id); JALTER TABLE ONLY public.op_item_agente DROP CONSTRAINT pk_op_item_agente; publicpostgresfalse18341834 260665898pk_op_mensajes CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT pk_op_mensajes PRIMARY KEY (me_fecha, of_id, do_anio, do_numero); ALTER TABLE op_mensajes CLUSTER ON pk_op_mensajes; DALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT pk_op_mensajes; publicpostgresfalse18361836183618361836$ 260665900 pk_op_ordenes CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT pk_op_ordenes PRIMARY KEY (do_numero, do_anio, of_id); ALTER TABLE op_ordenes CLUSTER ON pk_op_ordenes; BALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT pk_op_ordenes; publicpostgresfalse1840184018401840& 260665902 pk_op_pagos CONSTRAINTjALTER TABLE ONLY op_pagos ADD CONSTRAINT pk_op_pagos PRIMARY KEY (of_id, do_anio, do_numero, imv_id); >ALTER TABLE ONLY public.op_pagos DROP CONSTRAINT pk_op_pagos; publicpostgresfalse18411841184118411841( 260665904 pk_op_puertos CONSTRAINTRALTER TABLE ONLY op_puertos ADD CONSTRAINT pk_op_puertos PRIMARY KEY (pu_id); BALTER TABLE ONLY public.op_puertos DROP CONSTRAINT pk_op_puertos; publicpostgresfalse18421842* 260665906pk_op_seguimiento CONSTRAINTZALTER TABLE ONLY op_seguimiento ADD CONSTRAINT pk_op_seguimiento PRIMARY KEY (se_id); JALTER TABLE ONLY public.op_seguimiento DROP CONSTRAINT pk_op_seguimiento; publicpostgresfalse18441844, 260665908pk_op_servicios CONSTRAINTVALTER TABLE ONLY op_servicios ADD CONSTRAINT pk_op_servicios PRIMARY KEY (se_id); FALTER TABLE ONLY public.op_servicios DROP CONSTRAINT pk_op_servicios; publicpostgresfalse18451845. 260665910pk_op_solicitudes CONSTRAINTZALTER TABLE ONLY op_solicitudes ADD CONSTRAINT pk_op_solicitudes PRIMARY KEY (so_id); JALTER TABLE ONLY public.op_solicitudes DROP CONSTRAINT pk_op_solicitudes; publicpostgresfalse184618460 260665912pk_op_tipo_mensaje CONSTRAINT\ALTER TABLE ONLY op_tipo_mensaje ADD CONSTRAINT pk_op_tipo_mensaje PRIMARY KEY (tm_id); LALTER TABLE ONLY public.op_tipo_mensaje DROP CONSTRAINT pk_op_tipo_mensaje; publicpostgresfalse184718472 260665914pk_op_tipos_carga CONSTRAINT[ALTER TABLE ONLY op_tipos_carga ADD CONSTRAINT pk_op_tipos_carga PRIMARY KEY (tca_id); JALTER TABLE ONLY public.op_tipos_carga DROP CONSTRAINT pk_op_tipos_carga; publicpostgresfalse184818484 260665916pk_op_tipos_contenedor CONSTRAINTeALTER TABLE ONLY op_tipos_contenedor ADD CONSTRAINT pk_op_tipos_contenedor PRIMARY KEY (tco_id); TALTER TABLE ONLY public.op_tipos_contenedor DROP CONSTRAINT pk_op_tipos_contenedor; publicpostgresfalse184918496 260665918pk_op_tipos_empaque CONSTRAINT^ALTER TABLE ONLY op_tipos_empaque ADD CONSTRAINT pk_op_tipos_empaque PRIMARY KEY (te_id); NALTER TABLE ONLY public.op_tipos_empaque DROP CONSTRAINT pk_op_tipos_empaque; publicpostgresfalse18501850: 260665920pk_paag CONSTRAINTFALTER TABLE ONLY paag ADD CONSTRAINT pk_paag PRIMARY KEY (pa_id); 6ALTER TABLE ONLY public.paag DROP CONSTRAINT pk_paag; publicpostgresfalse18521852< 260665922 pk_parametros CONSTRAINTRALTER TABLE ONLY parametros ADD CONSTRAINT pk_parametros PRIMARY KEY (pa_id); BALTER TABLE ONLY public.parametros DROP CONSTRAINT pk_parametros; publicpostgresfalse18531853> 260665924 pk_pendientes CONSTRAINTSALTER TABLE ONLY pendientes ADD CONSTRAINT pk_pendientes PRIMARY KEY (pen_id); BALTER TABLE ONLY public.pendientes DROP CONSTRAINT pk_pendientes; publicpostgresfalse18541854@ 260665926 pk_perfiles CONSTRAINTNALTER TABLE ONLY perfiles ADD CONSTRAINT pk_perfiles PRIMARY KEY (pf_id); >ALTER TABLE ONLY public.perfiles DROP CONSTRAINT pk_perfiles; publicpostgresfalse18551855B 260665928 pk_periodo CONSTRAINTLALTER TABLE ONLY periodo ADD CONSTRAINT pk_periodo PRIMARY KEY (pe_id); <ALTER TABLE ONLY public.periodo DROP CONSTRAINT pk_periodo; publicpostgresfalse18561856D 260665930pk_puc CONSTRAINTIALTER TABLE ONLY puc ADD CONSTRAINT pk_puc PRIMARY KEY (puc_codigo); 4ALTER TABLE ONLY public.puc DROP CONSTRAINT pk_puc; publicpostgresfalse18571857F 260665932 pk_recursos CONSTRAINTNALTER TABLE ONLY recursos ADD CONSTRAINT pk_recursos PRIMARY KEY (re_id); >ALTER TABLE ONLY public.recursos DROP CONSTRAINT pk_recursos; publicpostgresfalse18581858H 260665934 pk_reglas CONSTRAINTJALTER TABLE ONLY reglas ADD CONSTRAINT pk_reglas PRIMARY KEY (re_id); :ALTER TABLE ONLY public.reglas DROP CONSTRAINT pk_reglas; publicpostgresfalse18591859J 260665936pk_reglas_nomina CONSTRAINTXALTER TABLE ONLY reglas_nomina ADD CONSTRAINT pk_reglas_nomina PRIMARY KEY (rn_id); HALTER TABLE ONLY public.reglas_nomina DROP CONSTRAINT pk_reglas_nomina; publicpostgresfalse18601860L 260665938pk_reglas_nomina_bases CONSTRAINTeALTER TABLE ONLY reglas_nomina_bases ADD CONSTRAINT pk_reglas_nomina_bases PRIMARY KEY (rnb_id); TALTER TABLE ONLY public.reglas_nomina_bases DROP CONSTRAINT pk_reglas_nomina_bases; publicpostgresfalse18611861260665940 pk_tercero CONSTRAINTxALTER TABLE ONLY tercero ADD CONSTRAINT pk_tercero PRIMARY KEY (te_id); ALTER TABLE tercero CLUSTER ON pk_tercero; <ALTER TABLE ONLY public.tercero DROP CONSTRAINT pk_tercero; publicpostgresfalse17641764R 260665942pk_tipo_movimiento CONSTRAINT\ALTER TABLE ONLY tipo_movimiento ADD CONSTRAINT pk_tipo_movimiento PRIMARY KEY (tm_id); LALTER TABLE ONLY public.tipo_movimiento DROP CONSTRAINT pk_tipo_movimiento; publicpostgresfalse18641864T 260665944pk_tipo_pendiente CONSTRAINTZALTER TABLE ONLY tipo_pendiente ADD CONSTRAINT pk_tipo_pendiente PRIMARY KEY (tp_id); JALTER TABLE ONLY public.tipo_pendiente DROP CONSTRAINT pk_tipo_pendiente; publicpostgresfalse18651865V 260665946 pk_tipo_regla CONSTRAINTRALTER TABLE ONLY tipo_regla ADD CONSTRAINT pk_tipo_regla PRIMARY KEY (tr_id); BALTER TABLE ONLY public.tipo_regla DROP CONSTRAINT pk_tipo_regla; publicpostgresfalse18661866X 260665948pk_tipo_tercero CONSTRAINTVALTER TABLE ONLY tipo_tercero ADD CONSTRAINT pk_tipo_tercero PRIMARY KEY (tt_id); FALTER TABLE ONLY public.tipo_tercero DROP CONSTRAINT pk_tipo_tercero; publicpostgresfalse18671867Z 260665950 pk_usuario CONSTRAINTLALTER TABLE ONLY usuario ADD CONSTRAINT pk_usuario PRIMARY KEY (us_id); <ALTER TABLE ONLY public.usuario DROP CONSTRAINT pk_usuario; publicpostgresfalse18681868P 260665952tasas_cambio_dia_pk CONSTRAINTkALTER TABLE ONLY tasas_cambio_dia ADD CONSTRAINT tasas_cambio_dia_pk PRIMARY KEY (td_fecha, tc_sigla); NALTER TABLE ONLY public.tasas_cambio_dia DROP CONSTRAINT tasas_cambio_dia_pk; publicpostgresfalse186318631863N 260665954tasas_cambio_pkey CONSTRAINT[ALTER TABLE ONLY tasas_cambio ADD CONSTRAINT tasas_cambio_pkey PRIMARY KEY (tc_sigla); HALTER TABLE ONLY public.tasas_cambio DROP CONSTRAINT tasas_cambio_pkey; publicpostgresfalse18621862260665956unique_index_numero CONSTRAINTWALTER TABLE ONLY movimiento ADD CONSTRAINT unique_index_numero UNIQUE (mv_numero); HALTER TABLE ONLY public.movimiento DROP CONSTRAINT unique_index_numero; publicpostgresfalse17631763260665958 unique_key_j CONSTRAINT_ALTER TABLE ONLY inv_tarja ADD CONSTRAINT unique_key_j UNIQUE (bo_id, mv_numero, mv_tipo); @ALTER TABLE ONLY public.inv_tarja DROP CONSTRAINT unique_key_j; publicpostgresfalse1807180718071807125965959ack_cuentas_item_movINDEXOCREATE INDEX ack_cuentas_item_mov ON item_movimiento USING btree (puc_codigo); (DROP INDEX public.ack_cuentas_item_mov; publicpostgresfalse1762125965960ack_imv_id_item_movINDEXJCREATE INDEX ack_imv_id_item_mov ON item_movimiento USING btree (imv_id); 'DROP INDEX public.ack_imv_id_item_mov; publicpostgresfalse1762125965961ack_pen_id_cancelacionesINDEXCREATE INDEX ack_pen_id_cancelaciones ON cancelaciones USING btree (pen_id); ALTER TABLE cancelaciones CLUSTER ON ack_pen_id_cancelaciones; ,DROP INDEX public.ack_pen_id_cancelaciones; publicpostgresfalse1769125965962ack_terceros_item_movINDEXKCREATE INDEX ack_terceros_item_mov ON item_movimiento USING btree (te_id); )DROP INDEX public.ack_terceros_item_mov; publicpostgresfalse1762125965963index_item_movimiento_ccINDEXNCREATE INDEX index_item_movimiento_cc ON item_movimiento USING btree (cc_id); ,DROP INDEX public.index_item_movimiento_cc; publicpostgresfalse1762" 125965964 num_trasporteINDEXCREATE UNIQUE INDEX num_trasporte ON op_ordenes USING btree (do_num_transporte, do_tip_transporte) WHERE (((do_num_transporte)::text <> NULL::text) AND ((do_tip_transporte)::text <> NULL::text)); !DROP INDEX public.num_trasporte; publicpostgresfalse1840184018401840125965965pk_fac_reglas_productoINDEXCREATE UNIQUE INDEX pk_fac_reglas_producto ON fac_reglas_producto USING btree (mv_id, imv_id, re_id, pro_id); ALTER TABLE fac_reglas_producto CLUSTER ON pk_fac_reglas_producto; *DROP INDEX public.pk_fac_reglas_producto; publicpostgresfalse1786178617861786 262065966equivalenciausdTRIGGER~CREATE TRIGGER equivalenciausd BEFORE INSERT ON item_movimiento FOR EACH ROW EXECUTE PROCEDURE equivalenciausd(); 8DROP TRIGGER equivalenciausd ON public.item_movimiento; publicpostgresfalse301762 262065967 tcontabilizarTRIGGERsCREATE TRIGGER tcontabilizar AFTER UPDATE ON movimiento FOR EACH ROW EXECUTE PROCEDURE contabilizar(); 1DROP TRIGGER tcontabilizar ON public.movimiento; publicpostgresfalse261763 260665968fk_acciones_reference_tercero FK CONSTRAINTALTER TABLE ONLY nominas ADD CONSTRAINT fk_acciones_reference_tercero FOREIGN KEY (te_id) REFERENCES tercero(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.nominas DROP CONSTRAINT fk_acciones_reference_tercero; publicpostgresfalse219418171764g 260665973fk_activos_reference1_puc FK CONSTRAINTALTER TABLE ONLY activos ADD CONSTRAINT fk_activos_reference1_puc FOREIGN KEY (ac_cgasto) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; KALTER TABLE ONLY public.activos DROP CONSTRAINT fk_activos_reference1_puc; publicpostgresfalse185717672371h 260665978fk_activos_reference_puc FK CONSTRAINTALTER TABLE ONLY activos ADD CONSTRAINT fk_activos_reference_puc FOREIGN KEY (ac_cactivo) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.activos DROP CONSTRAINT fk_activos_reference_puc; publicpostgresfalse185717672371i 260665983#fk_ajustesxinflacion1_reference_puc FK CONSTRAINTALTER TABLE ONLY ajustesxinflacion ADD CONSTRAINT fk_ajustesxinflacion1_reference_puc FOREIGN KEY (aj_cdebito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; _ALTER TABLE ONLY public.ajustesxinflacion DROP CONSTRAINT fk_ajustesxinflacion1_reference_puc; publicpostgresfalse176823711857j 260665988#fk_ajustesxinflacion2_reference_puc FK CONSTRAINTALTER TABLE ONLY ajustesxinflacion ADD CONSTRAINT fk_ajustesxinflacion2_reference_puc FOREIGN KEY (aj_ccredito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; _ALTER TABLE ONLY public.ajustesxinflacion DROP CONSTRAINT fk_ajustesxinflacion2_reference_puc; publicpostgresfalse176818572371k 260665993"fk_ajustesxinflacion_reference_puc FK CONSTRAINTALTER TABLE ONLY ajustesxinflacion ADD CONSTRAINT fk_ajustesxinflacion_reference_puc FOREIGN KEY (aj_cbase) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; ^ALTER TABLE ONLY public.ajustesxinflacion DROP CONSTRAINT fk_ajustesxinflacion_reference_puc; publicpostgresfalse176823711857t 260665998fk_c_monedas1_reference_cuentas FK CONSTRAINTALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT fk_c_monedas1_reference_cuentas FOREIGN KEY (cm_corden) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT fk_c_monedas1_reference_cuentas; publicpostgresfalse177618572371u 260666003fk_c_monedas2_reference_cuentas FK CONSTRAINTALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT fk_c_monedas2_reference_cuentas FOREIGN KEY (cm_corden_contra) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT fk_c_monedas2_reference_cuentas; publicpostgresfalse237118571776v 260666008fk_c_monedas3_reference_cuentas FK CONSTRAINTALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT fk_c_monedas3_reference_cuentas FOREIGN KEY (cm_ingreso_correccion) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT fk_c_monedas3_reference_cuentas; publicpostgresfalse177623711857w 260666013fk_c_monedas4_reference_cuentas FK CONSTRAINTALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT fk_c_monedas4_reference_cuentas FOREIGN KEY (cm_perdida_correccion) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT fk_c_monedas4_reference_cuentas; publicpostgresfalse237118571776x 260666018fk_c_monedas_reference_cuentas FK CONSTRAINTALTER TABLE ONLY cuentas_monedas ADD CONSTRAINT fk_c_monedas_reference_cuentas FOREIGN KEY (cm_corigen) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.cuentas_monedas DROP CONSTRAINT fk_c_monedas_reference_cuentas; publicpostgresfalse185723711776l 260666023&fk_cancelaciones_references_movimiento FK CONSTRAINTALTER TABLE ONLY cancelaciones ADD CONSTRAINT fk_cancelaciones_references_movimiento FOREIGN KEY (mv_id) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE CASCADE; ^ALTER TABLE ONLY public.cancelaciones DROP CONSTRAINT fk_cancelaciones_references_movimiento; publicpostgresfalse219017631769m 260666028&fk_cancelaciones_references_pendientes FK CONSTRAINTALTER TABLE ONLY cancelaciones ADD CONSTRAINT fk_cancelaciones_references_pendientes FOREIGN KEY (pen_id) REFERENCES pendientes(pen_id) ON UPDATE RESTRICT ON DELETE CASCADE; ^ALTER TABLE ONLY public.cancelaciones DROP CONSTRAINT fk_cancelaciones_references_pendientes; publicpostgresfalse185423651769n 260666033fk_conceptos_nomi_reference_puc FK CONSTRAINTALTER TABLE ONLY conceptos_nomina ADD CONSTRAINT fk_conceptos_nomi_reference_puc FOREIGN KEY (co_debito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.conceptos_nomina DROP CONSTRAINT fk_conceptos_nomi_reference_puc; publicpostgresfalse177318572371o 260666038 fk_conceptos_nomi_reference_puc2 FK CONSTRAINTALTER TABLE ONLY conceptos_nomina ADD CONSTRAINT fk_conceptos_nomi_reference_puc2 FOREIGN KEY (co_credito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; [ALTER TABLE ONLY public.conceptos_nomina DROP CONSTRAINT fk_conceptos_nomi_reference_puc2; publicpostgresfalse177318572371r 260666043!fk_cuentas_info_reference_periodo FK CONSTRAINTALTER TABLE ONLY cuentas_info ADD CONSTRAINT fk_cuentas_info_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.cuentas_info DROP CONSTRAINT fk_cuentas_info_reference_periodo; publicpostgresfalse177518562369s 260666048fk_cuentas_info_reference_puc FK CONSTRAINTALTER TABLE ONLY cuentas_info ADD CONSTRAINT fk_cuentas_info_reference_puc FOREIGN KEY (puc_codigo) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; TALTER TABLE ONLY public.cuentas_info DROP CONSTRAINT fk_cuentas_info_reference_puc; publicpostgresfalse177518572371p 260666053fk_cuentas_reference_puc FK CONSTRAINTALTER TABLE ONLY cuentas ADD CONSTRAINT fk_cuentas_reference_puc FOREIGN KEY (puc_codigo) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.cuentas DROP CONSTRAINT fk_cuentas_reference_puc; publicpostgresfalse177418572371q 260666058fk_cuentas_references_periodo FK CONSTRAINTALTER TABLE ONLY cuentas ADD CONSTRAINT fk_cuentas_references_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.cuentas DROP CONSTRAINT fk_cuentas_references_periodo; publicpostgresfalse177418562369y 260666063#fk_estado_periodo_reference_periodo FK CONSTRAINTALTER TABLE ONLY estado_cperiodo ADD CONSTRAINT fk_estado_periodo_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ]ALTER TABLE ONLY public.estado_cperiodo DROP CONSTRAINT fk_estado_periodo_reference_periodo; publicpostgresfalse177918562369} 260666068%fk_fac_item_pago_reference_movimiento FK CONSTRAINTALTER TABLE ONLY fac_item_pagos ADD CONSTRAINT fk_fac_item_pago_reference_movimiento FOREIGN KEY (mv_origen) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ^ALTER TABLE ONLY public.fac_item_pagos DROP CONSTRAINT fk_fac_item_pago_reference_movimiento; publicjulianfalse176317822190~ 260666073fk_fac_item_pago_reference_puc FK CONSTRAINTALTER TABLE ONLY fac_item_pagos ADD CONSTRAINT fk_fac_item_pago_reference_puc FOREIGN KEY (puc_codigo) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.fac_item_pagos DROP CONSTRAINT fk_fac_item_pago_reference_puc; publicjulianfalse178218572371z 260666078fk_fac_item_reference_fac_movi FK CONSTRAINTALTER TABLE ONLY fac_item_movimiento ADD CONSTRAINT fk_fac_item_reference_fac_movi FOREIGN KEY (mv_id) REFERENCES fac_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.fac_item_movimiento DROP CONSTRAINT fk_fac_item_reference_fac_movi; publicpostgresfalse178117832223 260666083fk_fac_item_reference_fac_pagos FK CONSTRAINTALTER TABLE ONLY fac_item_pagos ADD CONSTRAINT fk_fac_item_reference_fac_pagos FOREIGN KEY (mv_id) REFERENCES fac_pagos(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.fac_item_pagos DROP CONSTRAINT fk_fac_item_reference_fac_pagos; publicjulianfalse178217852229{ 260666088fk_fac_item_reference_inv_bode FK CONSTRAINTALTER TABLE ONLY fac_item_movimiento ADD CONSTRAINT fk_fac_item_reference_inv_bode FOREIGN KEY (bo_id) REFERENCES inv_bodegas(bo_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.fac_item_movimiento DROP CONSTRAINT fk_fac_item_reference_inv_bode; publicpostgresfalse178117892236| 260666093fk_fac_item_reference_inv_prod FK CONSTRAINTALTER TABLE ONLY fac_item_movimiento ADD CONSTRAINT fk_fac_item_reference_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; \ALTER TABLE ONLY public.fac_item_movimiento DROP CONSTRAINT fk_fac_item_reference_inv_prod; publicpostgresfalse178118012262 260666098fk_fac_movi_reference_fac_tipo FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_fac_tipo FOREIGN KEY (tm_id) REFERENCES fac_tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_fac_tipo; publicpostgresfalse178317872232 260666103fk_fac_movi_reference_inv_movi FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_inv_movi FOREIGN KEY (mv_mvinventario) REFERENCES inv_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_inv_movi; publicpostgresfalse225417831797 260666108fk_fac_movi_reference_monedas FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_monedas FOREIGN KEY (mo_sigla) REFERENCES monedas(mo_sigla) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_monedas; publicpostgresfalse178318152292 260666113 fk_fac_movi_reference_movimiento FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_movimiento FOREIGN KEY (mv_mvcontabilidad) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_movimiento; publicpostgresfalse178317632190 260666118fk_fac_movi_reference_periodo FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_periodo; publicpostgresfalse178318562369 260666123fk_fac_movi_reference_usuario FK CONSTRAINTALTER TABLE ONLY fac_movimiento ADD CONSTRAINT fk_fac_movi_reference_usuario FOREIGN KEY (us_id) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.fac_movimiento DROP CONSTRAINT fk_fac_movi_reference_usuario; publicpostgresfalse178318682393 260666128#fk_fac_movimiento_reference_monedas FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_movimiento_reference_monedas FOREIGN KEY (mo_sigla) REFERENCES monedas(mo_sigla) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_movimiento_reference_monedas; publicjulianfalse178518152292 260666133fk_fac_nume_reference_fac_tipo FK CONSTRAINTALTER TABLE ONLY fac_numeracion ADD CONSTRAINT fk_fac_nume_reference_fac_tipo FOREIGN KEY (tm_id) REFERENCES fac_tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.fac_numeracion DROP CONSTRAINT fk_fac_nume_reference_fac_tipo; publicpostgresfalse178417872232 260666138fk_fac_pago_reference_fac_tipo FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_pago_reference_fac_tipo FOREIGN KEY (tm_id) REFERENCES fac_tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_pago_reference_fac_tipo; publicjulianfalse178517872232 260666143 fk_fac_pago_reference_movimiento FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_pago_reference_movimiento FOREIGN KEY (mv_mvcontabilidad) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; TALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_pago_reference_movimiento; publicjulianfalse178517632190 260666148fk_fac_pago_reference_periodo FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_pago_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_pago_reference_periodo; publicjulianfalse178518562369 260666153fk_fac_pago_reference_puc FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_pago_reference_puc FOREIGN KEY (mv_cuenta) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; MALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_pago_reference_puc; publicjulianfalse178518572371 260666158fk_fac_pago_reference_usuario FK CONSTRAINTALTER TABLE ONLY fac_pagos ADD CONSTRAINT fk_fac_pago_reference_usuario FOREIGN KEY (us_id) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.fac_pagos DROP CONSTRAINT fk_fac_pago_reference_usuario; publicjulianfalse178518682393 260666163fk_fac_regl_reference_fac_item FK CONSTRAINTALTER TABLE ONLY fac_reglas_producto ADD CONSTRAINT fk_fac_regl_reference_fac_item FOREIGN KEY (imv_id, mv_id) REFERENCES fac_item_movimiento(imv_id, mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.fac_reglas_producto DROP CONSTRAINT fk_fac_regl_reference_fac_item; publicpostgresfalse17861786178117812217 260666168fk_fac_regl_reference_reglas FK CONSTRAINTALTER TABLE ONLY fac_reglas_producto ADD CONSTRAINT fk_fac_regl_reference_reglas FOREIGN KEY (re_id) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.fac_reglas_producto DROP CONSTRAINT fk_fac_regl_reference_reglas; publicpostgresfalse178623751859 260666173fk_imv_paqu_referenc1_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_subproductos ADD CONSTRAINT fk_imv_paqu_referenc1_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; YALTER TABLE ONLY public.inv_subproductos DROP CONSTRAINT fk_imv_paqu_referenc1_inv_prod; publicpostgresfalse180118062262 260666178fk_imv_paqu_referenc2_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_subproductos ADD CONSTRAINT fk_imv_paqu_referenc2_inv_prod FOREIGN KEY (inv_pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; YALTER TABLE ONLY public.inv_subproductos DROP CONSTRAINT fk_imv_paqu_referenc2_inv_prod; publicpostgresfalse180118062262 260666183fk_inv_cate_reference10_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference10_puc FOREIGN KEY (puc_caja) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; TALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference10_puc; publicpostgresfalse237118571790 260666188fk_inv_cate_reference1_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference1_puc FOREIGN KEY (puc_inventario) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference1_puc; publicpostgresfalse185717902371 260666193fk_inv_cate_reference2_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference2_puc FOREIGN KEY (puc_gasto) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference2_puc; publicpostgresfalse185723711790 260666198fk_inv_cate_reference3_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference3_puc FOREIGN KEY (puc_ingreso) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference3_puc; publicpostgresfalse179023711857 260666203fk_inv_cate_reference4_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference4_puc FOREIGN KEY (puc_costo) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference4_puc; publicpostgresfalse185717902371 260666208fk_inv_cate_reference5_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference5_puc FOREIGN KEY (puc_cliente) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference5_puc; publicpostgresfalse179018572371 260666213fk_inv_cate_reference6_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference6_puc FOREIGN KEY (puc_dev_des) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference6_puc; publicpostgresfalse185723711790 260666218fk_inv_cate_reference7_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference7_puc FOREIGN KEY (puc_proveedor) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference7_puc; publicpostgresfalse237118571790 260666223fk_inv_cate_reference8_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference8_puc FOREIGN KEY (puc_aprove) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference8_puc; publicpostgresfalse179023711857 260666228fk_inv_cate_reference9_puc FK CONSTRAINTALTER TABLE ONLY inv_categorias ADD CONSTRAINT fk_inv_cate_reference9_puc FOREIGN KEY (puc_perdida) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_categorias DROP CONSTRAINT fk_inv_cate_reference9_puc; publicpostgresfalse185717902371 260666233fk_inv_fami_reference_inv_fami FK CONSTRAINTALTER TABLE ONLY inv_familias ADD CONSTRAINT fk_inv_fami_reference_inv_fami FOREIGN KEY (inv_fa_id) REFERENCES inv_familias(fa_id) ON UPDATE CASCADE; UALTER TABLE ONLY public.inv_familias DROP CONSTRAINT fk_inv_fami_reference_inv_fami; publicpostgresfalse179122401791 260666238fk_inv_item_reference_inv_bode FK CONSTRAINTALTER TABLE ONLY inv_item_movimiento ADD CONSTRAINT fk_inv_item_reference_inv_bode FOREIGN KEY (bo_id) REFERENCES inv_bodegas(bo_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.inv_item_movimiento DROP CONSTRAINT fk_inv_item_reference_inv_bode; publicpostgresfalse179322361789 260666243fk_inv_item_reference_inv_movi FK CONSTRAINTALTER TABLE ONLY inv_item_movimiento ADD CONSTRAINT fk_inv_item_reference_inv_movi FOREIGN KEY (mv_id) REFERENCES inv_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.inv_item_movimiento DROP CONSTRAINT fk_inv_item_reference_inv_movi; publicpostgresfalse179722541793 260666248fk_inv_item_reference_inv_port FK CONSTRAINTALTER TABLE ONLY inv_items_portafolio ADD CONSTRAINT fk_inv_item_reference_inv_port FOREIGN KEY (pp_id) REFERENCES inv_portafolios(pp_id) ON UPDATE RESTRICT ON DELETE CASCADE; ]ALTER TABLE ONLY public.inv_items_portafolio DROP CONSTRAINT fk_inv_item_reference_inv_port; publicpostgresfalse179517992258 260666253fk_inv_item_reference_inv_pro FK CONSTRAINTALTER TABLE ONLY inv_item_movimiento ADD CONSTRAINT fk_inv_item_reference_inv_pro FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; [ALTER TABLE ONLY public.inv_item_movimiento DROP CONSTRAINT fk_inv_item_reference_inv_pro; publicpostgresfalse180122621793 260666258fk_inv_item_reference_inv_pror FK CONSTRAINTALTER TABLE ONLY inv_items_portafolio ADD CONSTRAINT fk_inv_item_reference_inv_pror FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; ]ALTER TABLE ONLY public.inv_items_portafolio DROP CONSTRAINT fk_inv_item_reference_inv_pror; publicpostgresfalse226218011795 260666263fk_inv_item_tarja_ref_inv_movi FK CONSTRAINTALTER TABLE ONLY inv_item_tarja ADD CONSTRAINT fk_inv_item_tarja_ref_inv_movi FOREIGN KEY (mv_inventario, mv_item_inventario) REFERENCES inv_item_movimiento(mv_id, imv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.inv_item_tarja DROP CONSTRAINT fk_inv_item_tarja_ref_inv_movi; publicpostgresfalse17931794224417931794 260666268fk_inv_item_tarja_ref_tarja FK CONSTRAINTALTER TABLE ONLY inv_item_tarja ADD CONSTRAINT fk_inv_item_tarja_ref_tarja FOREIGN KEY (mv_tarja) REFERENCES inv_tarja(mv_id) ON UPDATE RESTRICT ON DELETE CASCADE; TALTER TABLE ONLY public.inv_item_tarja DROP CONSTRAINT fk_inv_item_tarja_ref_tarja; publicpostgresfalse227417941807 260666273fk_inv_movi_reference_inv_tipo FK CONSTRAINTALTER TABLE ONLY inv_movimiento ADD CONSTRAINT fk_inv_movi_reference_inv_tipo FOREIGN KEY (tm_id) REFERENCES inv_tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT fk_inv_movi_reference_inv_tipo; publicpostgresfalse180822781797 260666278 fk_inv_movi_reference_movimiento FK CONSTRAINTALTER TABLE ONLY inv_movimiento ADD CONSTRAINT fk_inv_movi_reference_movimiento FOREIGN KEY (mv_mvcontabilidad) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE CASCADE; YALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT fk_inv_movi_reference_movimiento; publicpostgresfalse219017631797 260666283fk_inv_movi_reference_periodo FK CONSTRAINTALTER TABLE ONLY inv_movimiento ADD CONSTRAINT fk_inv_movi_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT fk_inv_movi_reference_periodo; publicpostgresfalse179723691856 260666288fk_inv_movi_reference_usuari1 FK CONSTRAINTALTER TABLE ONLY inv_movimiento ADD CONSTRAINT fk_inv_movi_reference_usuari1 FOREIGN KEY (us_preparo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT fk_inv_movi_reference_usuari1; publicpostgresfalse186817972393 260693597#fk_inv_movimiento_reference_usuario FK CONSTRAINTALTER TABLE ONLY inv_movimiento ADD CONSTRAINT fk_inv_movimiento_reference_usuario FOREIGN KEY (us_aprobo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; \ALTER TABLE ONLY public.inv_movimiento DROP CONSTRAINT fk_inv_movimiento_reference_usuario; publicpostgresfalse239317971868 260666298fk_inv_prec_reference_inv_list FK CONSTRAINTALTER TABLE ONLY inv_precios ADD CONSTRAINT fk_inv_prec_reference_inv_list FOREIGN KEY (lp_id) REFERENCES inv_listas_precios(lp_id) ON UPDATE RESTRICT ON DELETE CASCADE; TALTER TABLE ONLY public.inv_precios DROP CONSTRAINT fk_inv_prec_reference_inv_list; publicpostgresfalse180017962250 260666303fk_inv_prec_reference_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_precios ADD CONSTRAINT fk_inv_prec_reference_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; TALTER TABLE ONLY public.inv_precios DROP CONSTRAINT fk_inv_prec_reference_inv_prod; publicpostgresfalse226218001801 260666308fk_inv_prod_reference_inv_cate FK CONSTRAINTALTER TABLE ONLY inv_productos ADD CONSTRAINT fk_inv_prod_reference_inv_cate FOREIGN KEY (ca_id) REFERENCES inv_categorias(ca_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.inv_productos DROP CONSTRAINT fk_inv_prod_reference_inv_cate; publicpostgresfalse180117902238 260666313fk_inv_prod_reference_inv_fami FK CONSTRAINTALTER TABLE ONLY inv_productos ADD CONSTRAINT fk_inv_prod_reference_inv_fami FOREIGN KEY (fa_id) REFERENCES inv_familias(fa_id) ON UPDATE CASCADE; VALTER TABLE ONLY public.inv_productos DROP CONSTRAINT fk_inv_prod_reference_inv_fami; publicpostgresfalse179118012240 260666318fk_inv_prod_reference_inv_tipo FK CONSTRAINTALTER TABLE ONLY inv_productos ADD CONSTRAINT fk_inv_prod_reference_inv_tipo FOREIGN KEY (tp_id) REFERENCES inv_tipo_producto(tp_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.inv_productos DROP CONSTRAINT fk_inv_prod_reference_inv_tipo; publicpostgresfalse180922801801 260666323fk_inv_prod_reference_inv_unid FK CONSTRAINTALTER TABLE ONLY inv_productos ADD CONSTRAINT fk_inv_prod_reference_inv_unid FOREIGN KEY (un_id) REFERENCES inv_unidades(un_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.inv_productos DROP CONSTRAINT fk_inv_prod_reference_inv_unid; publicpostgresfalse181022841801 260666328fk_inv_prop_reference_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_propiedades_producto ADD CONSTRAINT fk_inv_prop_reference_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; aALTER TABLE ONLY public.inv_propiedades_producto DROP CONSTRAINT fk_inv_prop_reference_inv_prod; publicpostgresfalse180218012262 260666333fk_inv_regl_reference_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_reglas_producto ADD CONSTRAINT fk_inv_regl_reference_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; \ALTER TABLE ONLY public.inv_reglas_producto DROP CONSTRAINT fk_inv_regl_reference_inv_prod; publicpostgresfalse180322621801 260666338fk_inv_regl_reference_reglas FK CONSTRAINTALTER TABLE ONLY inv_reglas_producto ADD CONSTRAINT fk_inv_regl_reference_reglas FOREIGN KEY (re_id) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.inv_reglas_producto DROP CONSTRAINT fk_inv_regl_reference_reglas; publicpostgresfalse185923751803 260666343fk_inv_regl_reference_reglas FK CONSTRAINTALTER TABLE ONLY inv_reglas_tercero ADD CONSTRAINT fk_inv_regl_reference_reglas FOREIGN KEY (re_id) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE CASCADE; YALTER TABLE ONLY public.inv_reglas_tercero DROP CONSTRAINT fk_inv_regl_reference_reglas; publicpostgresfalse237518591804 260666353fk_inv_sald_reference_inv_bode FK CONSTRAINTALTER TABLE ONLY inv_saldos ADD CONSTRAINT fk_inv_sald_reference_inv_bode FOREIGN KEY (bo_id) REFERENCES inv_bodegas(bo_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_saldos DROP CONSTRAINT fk_inv_sald_reference_inv_bode; publicpostgresfalse178918052236 260666358fk_inv_sald_reference_inv_item FK CONSTRAINTALTER TABLE ONLY inv_saldos ADD CONSTRAINT fk_inv_sald_reference_inv_item FOREIGN KEY (imv_id, mv_id) REFERENCES inv_item_movimiento(imv_id, mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.inv_saldos DROP CONSTRAINT fk_inv_sald_reference_inv_item; publicpostgresfalse18051805179322441793 260666363fk_inv_sald_reference_inv_prod FK CONSTRAINTALTER TABLE ONLY inv_saldos ADD CONSTRAINT fk_inv_sald_reference_inv_prod FOREIGN KEY (pro_id) REFERENCES inv_productos(pro_id) ON UPDATE CASCADE; SALTER TABLE ONLY public.inv_saldos DROP CONSTRAINT fk_inv_sald_reference_inv_prod; publicpostgresfalse180118052262 260666368fk_inv_tarj_reference_periodo FK CONSTRAINTALTER TABLE ONLY inv_tarja ADD CONSTRAINT fk_inv_tarj_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.inv_tarja DROP CONSTRAINT fk_inv_tarj_reference_periodo; publicpostgresfalse185623691807 260666373fk_inv_tarj_reference_usuari1 FK CONSTRAINTALTER TABLE ONLY inv_tarja ADD CONSTRAINT fk_inv_tarj_reference_usuari1 FOREIGN KEY (us_preparo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.inv_tarja DROP CONSTRAINT fk_inv_tarj_reference_usuari1; publicpostgresfalse186818072393[ 260666378fk_item_mov_reference_movimien FK CONSTRAINTALTER TABLE ONLY item_movimiento ADD CONSTRAINT fk_item_mov_reference_movimien FOREIGN KEY (mv_id) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.item_movimiento DROP CONSTRAINT fk_item_mov_reference_movimien; publicpostgresfalse219017631762\ 260666383fk_item_mov_reference_tercero FK CONSTRAINTALTER TABLE ONLY item_movimiento ADD CONSTRAINT fk_item_mov_reference_tercero FOREIGN KEY (te_id) REFERENCES tercero(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.item_movimiento DROP CONSTRAINT fk_item_mov_reference_tercero; publicpostgresfalse176217642194 260666388*fk_item_nominas_reference_conceptos_nomina FK CONSTRAINTALTER TABLE ONLY item_nominas ADD CONSTRAINT fk_item_nominas_reference_conceptos_nomina FOREIGN KEY (co_id) REFERENCES conceptos_nomina(co_id) ON UPDATE RESTRICT ON DELETE RESTRICT; aALTER TABLE ONLY public.item_nominas DROP CONSTRAINT fk_item_nominas_reference_conceptos_nomina; publicpostgresfalse220518111773 260666393!fk_item_nominas_reference_nominas FK CONSTRAINTALTER TABLE ONLY item_nominas ADD CONSTRAINT fk_item_nominas_reference_nominas FOREIGN KEY (no_id) REFERENCES nominas(no_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.item_nominas DROP CONSTRAINT fk_item_nominas_reference_nominas; publicpostgresfalse181718112296 260666398&fk_movi_depreciacion_reference_activos FK CONSTRAINTALTER TABLE ONLY movi_depreciacion ADD CONSTRAINT fk_movi_depreciacion_reference_activos FOREIGN KEY (ac_id) REFERENCES activos(ac_id) ON UPDATE RESTRICT ON DELETE RESTRICT; bALTER TABLE ONLY public.movi_depreciacion DROP CONSTRAINT fk_movi_depreciacion_reference_activos; publicpostgresfalse176718162198 260666403)fk_movi_depreciacion_reference_movimiento FK CONSTRAINTALTER TABLE ONLY movi_depreciacion ADD CONSTRAINT fk_movi_depreciacion_reference_movimiento FOREIGN KEY (mv_id) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; eALTER TABLE ONLY public.movi_depreciacion DROP CONSTRAINT fk_movi_depreciacion_reference_movimiento; publicpostgresfalse176318162190] 260666408fk_movimien_aprobo_usuario FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_aprobo_usuario FOREIGN KEY (us_aprobo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_aprobo_usuario; publicpostgresfalse186817632393^ 260666413fk_movimien_contabili_usuario FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_contabili_usuario FOREIGN KEY (us_contabilizo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_contabili_usuario; publicpostgresfalse186817632393_ 260666418fk_movimien_preparo_usuario FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_preparo_usuario FOREIGN KEY (us_preparo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; PALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_preparo_usuario; publicpostgresfalse186817632393` 260666423fk_movimien_reference_estado FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_reference_estado FOREIGN KEY (es_id) REFERENCES estado(es_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_reference_estado; publicpostgresfalse177817632213a 260666428fk_movimien_reference_periodo FK CONSTRAINT|ALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id); RALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_reference_periodo; publicpostgresfalse185617632369b 260666433fk_movimien_reference_tipo_mov FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimien_reference_tipo_mov FOREIGN KEY (tm_tipo_movimiento) REFERENCES tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimien_reference_tipo_mov; publicpostgresfalse186417632385c 260666438fk_movimiento_reference_monedas FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimiento_reference_monedas FOREIGN KEY (mo_sigla) REFERENCES monedas(mo_sigla) ON UPDATE RESTRICT ON DELETE RESTRICT; TALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimiento_reference_monedas; publicpostgresfalse181517632292d 260666443"fk_movimiento_reference_movimiento FK CONSTRAINTALTER TABLE ONLY movimiento ADD CONSTRAINT fk_movimiento_reference_movimiento FOREIGN KEY (mv_devolucion) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; WALTER TABLE ONLY public.movimiento DROP CONSTRAINT fk_movimiento_reference_movimiento; publicpostgresfalse219017631763 260666448fk_numer_references_tipo_mov FK CONSTRAINTALTER TABLE ONLY numeracion ADD CONSTRAINT fk_numer_references_tipo_mov FOREIGN KEY (tm_id) REFERENCES tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.numeracion DROP CONSTRAINT fk_numer_references_tipo_mov; publicpostgresfalse181818642385 260666453$fk_op_adjuntos_reference_op_mensajes FK CONSTRAINTALTER TABLE ONLY op_adjuntos ADD CONSTRAINT fk_op_adjuntos_reference_op_mensajes FOREIGN KEY (me_fecha, of_id, do_anio, do_numero) REFERENCES op_mensajes(me_fecha, of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; ZALTER TABLE ONLY public.op_adjuntos DROP CONSTRAINT fk_op_adjuntos_reference_op_mensajes; publicpostgresfalse183618362334183618191819181918191836 260666458fk_op_carga_reference_op_ord FK CONSTRAINTALTER TABLE ONLY op_carga ADD CONSTRAINT fk_op_carga_reference_op_ord FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; OALTER TABLE ONLY public.op_carga DROP CONSTRAINT fk_op_carga_reference_op_ord; publicpostgresfalse1840182018201820184018402339 260666463&fk_op_carga_reference_op_tipos_empaque FK CONSTRAINTALTER TABLE ONLY op_carga ADD CONSTRAINT fk_op_carga_reference_op_tipos_empaque FOREIGN KEY (te_id) REFERENCES op_tipos_empaque(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.op_carga DROP CONSTRAINT fk_op_carga_reference_op_tipos_empaque; publicpostgresfalse185018202357 260666468fk_op_carga_references_op_tco FK CONSTRAINTALTER TABLE ONLY op_carga ADD CONSTRAINT fk_op_carga_references_op_tco FOREIGN KEY (tco_id) REFERENCES op_tipos_contenedor(tco_id) ON UPDATE RESTRICT ON DELETE RESTRICT; PALTER TABLE ONLY public.op_carga DROP CONSTRAINT fk_op_carga_references_op_tco; publicpostgresfalse184918202355 260666473 fk_op_conta_reference_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_contabilidad ADD CONSTRAINT fk_op_conta_reference_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.op_contabilidad DROP CONSTRAINT fk_op_conta_reference_op_ordenes; publicpostgresfalse1840182218221822184023391840 260666478fk_op_dia_reference_op_ord FK CONSTRAINTALTER TABLE ONLY op_diario ADD CONSTRAINT fk_op_dia_reference_op_ord FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; NALTER TABLE ONLY public.op_diario DROP CONSTRAINT fk_op_dia_reference_op_ord; publicjulianfalse1823233918401840184018231823 260666483fk_op_dia_references_op_of FK CONSTRAINTALTER TABLE ONLY op_diario ADD CONSTRAINT fk_op_dia_references_op_of FOREIGN KEY (of_puerto) REFERENCES op_oficinas(of_id) ON UPDATE RESTRICT ON DELETE CASCADE; NALTER TABLE ONLY public.op_diario DROP CONSTRAINT fk_op_dia_references_op_of; publicjulianfalse183918232336 260666488fk_op_dtm_reference_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_dtm ADD CONSTRAINT fk_op_dtm_reference_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero); OALTER TABLE ONLY public.op_dtm DROP CONSTRAINT fk_op_dtm_reference_op_ordenes; publicpostgresfalse1824182423391840184018401824 260666493fk_op_eta_reference_op_ord FK CONSTRAINTALTER TABLE ONLY op_etapas_do ADD CONSTRAINT fk_op_eta_reference_op_ord FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; QALTER TABLE ONLY public.op_etapas_do DROP CONSTRAINT fk_op_eta_reference_op_ord; publicpostgresfalse1827184018271827233918401840 260666498fk_op_etapas_reference_op_ser FK CONSTRAINTALTER TABLE ONLY op_etapas ADD CONSTRAINT fk_op_etapas_reference_op_ser FOREIGN KEY (se_id) REFERENCES op_servicios(se_id) ON UPDATE RESTRICT ON DELETE CASCADE; QALTER TABLE ONLY public.op_etapas DROP CONSTRAINT fk_op_etapas_reference_op_ser; publicpostgresfalse234718451826 260666503fk_op_fact_reference_fac_itm_pa FK CONSTRAINTALTER TABLE ONLY op_pagos ADD CONSTRAINT fk_op_fact_reference_fac_itm_pa FOREIGN KEY (imv_id) REFERENCES fac_item_pagos(imv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.op_pagos DROP CONSTRAINT fk_op_fact_reference_fac_itm_pa; publicpostgresfalse178222191841 260666508fk_op_fact_reference_fac_movi FK CONSTRAINTALTER TABLE ONLY op_facturacion ADD CONSTRAINT fk_op_fact_reference_fac_movi FOREIGN KEY (mv_id) REFERENCES fac_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.op_facturacion DROP CONSTRAINT fk_op_fact_reference_fac_movi; publicpostgresfalse182822231783 260666513fk_op_fact_reference_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_facturacion ADD CONSTRAINT fk_op_fact_reference_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.op_facturacion DROP CONSTRAINT fk_op_fact_reference_op_ordenes; publicpostgresfalse2339184018281828182818401840 260666518fk_op_fact_reference_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_pagos ADD CONSTRAINT fk_op_fact_reference_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.op_pagos DROP CONSTRAINT fk_op_fact_reference_op_ordenes; publicpostgresfalse1840233918401840184118411841 260666523fk_op_hit_reference_op_eta FK CONSTRAINTALTER TABLE ONLY op_hitos_do ADD CONSTRAINT fk_op_hit_reference_op_eta FOREIGN KEY (et_id, of_id, do_anio, do_numero) REFERENCES op_etapas_do(et_id, of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; PALTER TABLE ONLY public.op_hitos_do DROP CONSTRAINT fk_op_hit_reference_op_eta; publicpostgresfalse183018301830183018271827182718272316 260666528fk_op_hitos_reference_op_et FK CONSTRAINTALTER TABLE ONLY op_hitos ADD CONSTRAINT fk_op_hitos_reference_op_et FOREIGN KEY (et_id, se_id) REFERENCES op_etapas(et_id, se_id) ON UPDATE RESTRICT ON DELETE CASCADE; NALTER TABLE ONLY public.op_hitos DROP CONSTRAINT fk_op_hitos_reference_op_et; publicpostgresfalse18291829182618262314 260666533fk_op_infor_reference_op_carga FK CONSTRAINTALTER TABLE ONLY op_informacion_despacho ADD CONSTRAINT fk_op_infor_reference_op_carga FOREIGN KEY (ca_id, of_id, do_anio, do_numero) REFERENCES op_carga(ca_id, of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; `ALTER TABLE ONLY public.op_informacion_despacho DROP CONSTRAINT fk_op_infor_reference_op_carga; publicpostgresfalse183118311831183118201820182018202302 260666538fk_op_infor_reference_op_orden FK CONSTRAINTALTER TABLE ONLY op_informacion_puerto ADD CONSTRAINT fk_op_infor_reference_op_orden FOREIGN KEY (do_numero, do_anio, of_id) REFERENCES op_ordenes(do_numero, do_anio, of_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ^ALTER TABLE ONLY public.op_informacion_puerto DROP CONSTRAINT fk_op_infor_reference_op_orden; publicpostgresfalse1832183218321840184018402339 260666543 fk_op_inventa_reference_inv_movi FK CONSTRAINTALTER TABLE ONLY op_inventario ADD CONSTRAINT fk_op_inventa_reference_inv_movi FOREIGN KEY (mv_id) REFERENCES inv_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.op_inventario DROP CONSTRAINT fk_op_inventa_reference_inv_movi; publicpostgresfalse179718332254 260666548"fk_op_inventa_reference_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_inventario ADD CONSTRAINT fk_op_inventa_reference_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.op_inventario DROP CONSTRAINT fk_op_inventa_reference_op_ordenes; publicpostgresfalse1840183318331833184018402339 260666553fk_op_mensajes_reference_op_ord FK CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT fk_op_mensajes_reference_op_ord FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE CASCADE; UALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT fk_op_mensajes_reference_op_ord; publicpostgresfalse1840183623391840184018361836 260666558&fk_op_mensajes_reference_op_tipo_mensa FK CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT fk_op_mensajes_reference_op_tipo_mensa FOREIGN KEY (tm_id) REFERENCES op_tipo_mensaje(tm_id) ON UPDATE RESTRICT ON DELETE CASCADE; \ALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT fk_op_mensajes_reference_op_tipo_mensa; publicpostgresfalse184718362351 260666563 fk_op_mensajes_reference_us_from FK CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT fk_op_mensajes_reference_us_from FOREIGN KEY (us_id_from) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE CASCADE; VALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT fk_op_mensajes_reference_us_from; publicpostgresfalse239318361868 260666568#fk_op_mensajes_reference_us_preparo FK CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT fk_op_mensajes_reference_us_preparo FOREIGN KEY (us_id_preparo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE CASCADE; YALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT fk_op_mensajes_reference_us_preparo; publicpostgresfalse239318681836 260666573fk_op_mensajes_reference_us_to FK CONSTRAINTALTER TABLE ONLY op_mensajes ADD CONSTRAINT fk_op_mensajes_reference_us_to FOREIGN KEY (us_id_to) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE CASCADE; TALTER TABLE ONLY public.op_mensajes DROP CONSTRAINT fk_op_mensajes_reference_us_to; publicpostgresfalse183618682393 260666578fk_op_oficinas_references_usof FK CONSTRAINTALTER TABLE ONLY op_usuarios_oficinas ADD CONSTRAINT fk_op_oficinas_references_usof FOREIGN KEY (of_id) REFERENCES op_oficinas(of_id) ON UPDATE RESTRICT ON DELETE CASCADE; ]ALTER TABLE ONLY public.op_usuarios_oficinas DROP CONSTRAINT fk_op_oficinas_references_usof; publicpostgresfalse185123361839 260666583fk_op_orden_reference_centros_ FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_centros_ FOREIGN KEY (of_id) REFERENCES op_oficinas(of_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_centros_; publicpostgresfalse183918402336 260666588fk_op_orden_reference_fac_movi FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_fac_movi FOREIGN KEY (mv_cotizacion) REFERENCES fac_movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_fac_movi; publicpostgresfalse184022231783 260666593fk_op_orden_reference_op_ciud1 FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_ciud1 FOREIGN KEY (ci_destino) REFERENCES op_ciudades(ci_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_ciud1; publicpostgresfalse184023041821 260666598fk_op_orden_reference_op_ciud2 FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_ciud2 FOREIGN KEY (ci_origen) REFERENCES op_ciudades(ci_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_ciud2; publicpostgresfalse230418401821 260666603fk_op_orden_reference_op_est FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_est FOREIGN KEY (es_id) REFERENCES op_estados(es_id) ON UPDATE RESTRICT ON DELETE RESTRICT; QALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_est; publicpostgresfalse184018252312 260666608fk_op_orden_reference_op_puer1 FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_puer1 FOREIGN KEY (pu_destino) REFERENCES op_puertos(pu_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_puer1; publicpostgresfalse184023431842 260666613fk_op_orden_reference_op_puer2 FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_puer2 FOREIGN KEY (pu_origen) REFERENCES op_puertos(pu_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_puer2; publicpostgresfalse234318401842 260666618fk_op_orden_reference_op_servi FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_servi FOREIGN KEY (se_id) REFERENCES op_servicios(se_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_servi; publicpostgresfalse234718401845 260666623fk_op_orden_reference_op_terc FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_op_terc FOREIGN KEY (do_cont_nit) REFERENCES tercero(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_op_terc; publicpostgresfalse176421941840 260666628fk_op_orden_reference_usu FK CONSTRAINTALTER TABLE ONLY op_ordenes ADD CONSTRAINT fk_op_orden_reference_usu FOREIGN KEY (us_preparo) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; NALTER TABLE ONLY public.op_ordenes DROP CONSTRAINT fk_op_orden_reference_usu; publicpostgresfalse239318681840 260666633fk_op_solicitudes FK CONSTRAINTALTER TABLE ONLY op_item_agente ADD CONSTRAINT fk_op_solicitudes FOREIGN KEY (so_id) REFERENCES op_solicitudes(so_id) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.op_item_agente DROP CONSTRAINT fk_op_solicitudes; publicpostgresfalse183418462349 2606666380fk_op_solicitudes_references_op_item_liquidacion FK CONSTRAINTALTER TABLE ONLY op_item_liquidacion ADD CONSTRAINT fk_op_solicitudes_references_op_item_liquidacion FOREIGN KEY (so_id) REFERENCES op_solicitudes(so_id) ON UPDATE RESTRICT ON DELETE RESTRICT; nALTER TABLE ONLY public.op_item_liquidacion DROP CONSTRAINT fk_op_solicitudes_references_op_item_liquidacion; publicpostgresfalse184623491835 260666643'fk_op_solicitudes_references_op_ordenes FK CONSTRAINTALTER TABLE ONLY op_solicitudes ADD CONSTRAINT fk_op_solicitudes_references_op_ordenes FOREIGN KEY (of_id, do_anio, do_numero) REFERENCES op_ordenes(of_id, do_anio, do_numero) ON UPDATE RESTRICT ON DELETE RESTRICT; `ALTER TABLE ONLY public.op_solicitudes DROP CONSTRAINT fk_op_solicitudes_references_op_ordenes; publicpostgresfalse1840233918401840184618461846 260666648$fk_op_solicitudes_references_usuario FK CONSTRAINTALTER TABLE ONLY op_solicitudes ADD CONSTRAINT fk_op_solicitudes_references_usuario FOREIGN KEY (us_id) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ]ALTER TABLE ONLY public.op_solicitudes DROP CONSTRAINT fk_op_solicitudes_references_usuario; publicpostgresfalse186818462393 260666653fk_paag_reference_periodo FK CONSTRAINTALTER TABLE ONLY paag ADD CONSTRAINT fk_paag_reference_periodo FOREIGN KEY (pe_id) REFERENCES periodo(pe_id) ON UPDATE RESTRICT ON DELETE RESTRICT; HALTER TABLE ONLY public.paag DROP CONSTRAINT fk_paag_reference_periodo; publicpostgresfalse236918561852 260666658fk_parametros_reference_reglas FK CONSTRAINTALTER TABLE ONLY parametros ADD CONSTRAINT fk_parametros_reference_reglas FOREIGN KEY (re_regla) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE RESTRICT; SALTER TABLE ONLY public.parametros DROP CONSTRAINT fk_parametros_reference_reglas; publicpostgresfalse237518531859 260666663fk_pendientes_reference_usuario FK CONSTRAINTALTER TABLE ONLY pendientes ADD CONSTRAINT fk_pendientes_reference_usuario FOREIGN KEY (us_usuario) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE RESTRICT; TALTER TABLE ONLY public.pendientes DROP CONSTRAINT fk_pendientes_reference_usuario; publicpostgresfalse239318681854 260666668#fk_pendientes_references_movimiento FK CONSTRAINTALTER TABLE ONLY pendientes ADD CONSTRAINT fk_pendientes_references_movimiento FOREIGN KEY (mv_origen) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE RESTRICT; XALTER TABLE ONLY public.pendientes DROP CONSTRAINT fk_pendientes_references_movimiento; publicpostgresfalse219018541763 260666673$fk_pendientes_references_movimiento2 FK CONSTRAINTALTER TABLE ONLY pendientes ADD CONSTRAINT fk_pendientes_references_movimiento2 FOREIGN KEY (mv_destino) REFERENCES movimiento(mv_id) ON UPDATE RESTRICT ON DELETE CASCADE; YALTER TABLE ONLY public.pendientes DROP CONSTRAINT fk_pendientes_references_movimiento2; publicpostgresfalse176321901854 260666678 fk_pendientes_references_tercero FK CONSTRAINTALTER TABLE ONLY pendientes ADD CONSTRAINT fk_pendientes_references_tercero FOREIGN KEY (pen_tercero) REFERENCES tercero(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; UALTER TABLE ONLY public.pendientes DROP CONSTRAINT fk_pendientes_references_tercero; publicpostgresfalse185421941764 260666683!fk_pendientes_references_tipo_pen FK CONSTRAINTALTER TABLE ONLY pendientes ADD CONSTRAINT fk_pendientes_references_tipo_pen FOREIGN KEY (tp_id) REFERENCES tipo_pendiente(tp_id) ON UPDATE RESTRICT ON DELETE RESTRICT; VALTER TABLE ONLY public.pendientes DROP CONSTRAINT fk_pendientes_references_tipo_pen; publicpostgresfalse238718541865f 260666688fk_perfiles_references_acciones FK CONSTRAINTALTER TABLE ONLY acciones ADD CONSTRAINT fk_perfiles_references_acciones FOREIGN KEY (pf_id) REFERENCES perfiles(pf_id) ON UPDATE RESTRICT ON DELETE RESTRICT; RALTER TABLE ONLY public.acciones DROP CONSTRAINT fk_perfiles_references_acciones; publicpostgresfalse176618552367 260666693fk_reglas_nomina_b_ref_concetos FK CONSTRAINTALTER TABLE ONLY reglas_nomina_bases ADD CONSTRAINT fk_reglas_nomina_b_ref_concetos FOREIGN KEY (co_id) REFERENCES conceptos_nomina(co_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ]ALTER TABLE ONLY public.reglas_nomina_bases DROP CONSTRAINT fk_reglas_nomina_b_ref_concetos; publicpostgresfalse220517731861 260666698fk_reglas_nomina_b_ref_reglas FK CONSTRAINTALTER TABLE ONLY reglas_nomina_bases ADD CONSTRAINT fk_reglas_nomina_b_ref_reglas FOREIGN KEY (re_id) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE RESTRICT; [ALTER TABLE ONLY public.reglas_nomina_bases DROP CONSTRAINT fk_reglas_nomina_b_ref_reglas; publicpostgresfalse185918612375 260666703"fk_reglas_nomina_reference_nominas FK CONSTRAINTALTER TABLE ONLY reglas_nomina ADD CONSTRAINT fk_reglas_nomina_reference_nominas FOREIGN KEY (no_id) REFERENCES nominas(no_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.reglas_nomina DROP CONSTRAINT fk_reglas_nomina_reference_nominas; publicpostgresfalse186022961817 260666708!fk_reglas_nomina_reference_reglas FK CONSTRAINTALTER TABLE ONLY reglas_nomina ADD CONSTRAINT fk_reglas_nomina_reference_reglas FOREIGN KEY (re_id) REFERENCES reglas(re_id) ON UPDATE RESTRICT ON DELETE RESTRICT; YALTER TABLE ONLY public.reglas_nomina DROP CONSTRAINT fk_reglas_nomina_reference_reglas; publicpostgresfalse237518591860 260666713"fk_reglas_nomina_reference_tercero FK CONSTRAINTALTER TABLE ONLY reglas_nomina ADD CONSTRAINT fk_reglas_nomina_reference_tercero FOREIGN KEY (te_id) REFERENCES tercero(te_id) ON UPDATE RESTRICT ON DELETE RESTRICT; ZALTER TABLE ONLY public.reglas_nomina DROP CONSTRAINT fk_reglas_nomina_reference_tercero; publicpostgresfalse176418602194 260666718fk_reglas_reference_tipo_regla FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_reference_tipo_regla FOREIGN KEY (tr_tipo_regla) REFERENCES tipo_regla(tr_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_reference_tipo_regla; publicpostgresfalse185918662389 260666723fk_reglas_references1_puc FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_references1_puc FOREIGN KEY (puc_disparadora) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_references1_puc; publicpostgresfalse185918572371 260666728fk_reglas_references2_puc FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_references2_puc FOREIGN KEY (puc_debito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_references2_puc; publicpostgresfalse185918572371 260666733fk_reglas_references3_puc FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_references3_puc FOREIGN KEY (puc_credito) REFERENCES puc(puc_codigo) ON UPDATE RESTRICT ON DELETE RESTRICT; JALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_references3_puc; publicpostgresfalse185918572371 260666738fk_reglas_references_funciones FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_references_funciones FOREIGN KEY (fu_funcion) REFERENCES funciones(fu_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_references_funciones; publicpostgresfalse185917882234 260666743fk_reglas_references_tipo_mov FK CONSTRAINTALTER TABLE ONLY reglas ADD CONSTRAINT fk_reglas_references_tipo_mov FOREIGN KEY (tm_tipo_movimiento) REFERENCES tipo_movimiento(tm_id) ON UPDATE RESTRICT ON DELETE RESTRICT; NALTER TABLE ONLY public.reglas DROP CONSTRAINT fk_reglas_references_tipo_mov; publicpostgresfalse185918642385e 260666748fk_tercero_reference_tipo_ter FK CONSTRAINTALTER TABLE ONLY tercero ADD CONSTRAINT fk_tercero_reference_tipo_ter FOREIGN KEY (tt_id) REFERENCES tipo_tercero(tt_id) ON UPDATE RESTRICT ON DELETE RESTRICT; OALTER TABLE ONLY public.tercero DROP CONSTRAINT fk_tercero_reference_tipo_ter; publicpostgresfalse176418672391 260666753fk_usuario_references_perfiles FK CONSTRAINTALTER TABLE ONLY usuario ADD CONSTRAINT fk_usuario_references_perfiles FOREIGN KEY (pf_id) REFERENCES perfiles(pf_id) ON UPDATE RESTRICT ON DELETE RESTRICT; PALTER TABLE ONLY public.usuario DROP CONSTRAINT fk_usuario_references_perfiles; publicpostgresfalse186818552367 260666758fk_usuarios_references_usof FK CONSTRAINTALTER TABLE ONLY op_usuarios_oficinas ADD CONSTRAINT fk_usuarios_references_usof FOREIGN KEY (us_id) REFERENCES usuario(us_id) ON UPDATE RESTRICT ON DELETE CASCADE; ZALTER TABLE ONLY public.op_usuarios_oficinas DROP CONSTRAINT fk_usuarios_references_usof; publicpostgresfalse239318681851 260666763tasas_cambio_dia_fk FK CONSTRAINTALTER TABLE ONLY tasas_cambio_dia ADD CONSTRAINT tasas_cambio_dia_fk FOREIGN KEY (tc_sigla) REFERENCES tasas_cambio(tc_sigla) ON UPDATE RESTRICT ON DELETE RESTRICT; NALTER TABLE ONLY public.tasas_cambio_dia DROP CONSTRAINT tasas_cambio_dia_fk; publicpostgresfalse186218632381 260666768tasas_cambio_fk FK CONSTRAINTALTER TABLE ONLY tasas_cambio ADD CONSTRAINT tasas_cambio_fk FOREIGN KEY (mo_sigla) REFERENCES monedas(mo_sigla) ON UPDATE RESTRICT ON DELETE RESTRICT; FALTER TABLE ONLY public.tasas_cambio DROP CONSTRAINT tasas_cambio_fk; publicpostgresfalse229218151862 xMr09t^fҏ"j ȵs&MeoGB~%~u^cWۮuwگ^>.+܌~ݾZS?xc]hMmհ:+Y{HogNnۀ-xէjJ6MfwjXǼwySQ;=|zILUGoP{,zIe: _`X*<}x^(cm'S$Uk 6l%I eЛT且`%4:OUR`e&mvʁV%ӘaTV2βtEI!eV|=yhh :A @w8hK `: .dIN+jٳ})b%(4c1Xef6]uTd _`X*cv~qI*ziCS 9Y< tD+ѝv"E:HtR>m2:N=Ә@?k_9tFI 4K%ܒF~IѴOhH/Ѵ`*N5S˩s0F [ X#_';e%ZdYǫ-T]&Zɩc&aZL ?d˨E//PA 'Gy8 =BP)'^TceR: x x x x=@sc[514XXٌ@0Ks{AX;^ޛ0|OIxNcxJpA1KpbJZEVX枕)+6ԁ(;,6 2@  e/}EuD⛷{RU~1Dn;>Qw_w1G!.U#4<O+ %x3000tN+)W!U N $x30CN# ]3]#?0+F s*, x ;x34CNN.CCt)v1,z aULC,fb4C/H ]o% x x fxUN0 S q"#3yRwQtڞsxCĤCā.ԡCt8bT,i%t=5!X<Nd~M]0V[8 ֽ2Dhs ( /z+V4/ x34C4=... x x x Zxu90kcІ:!RPBi(lMai$^'Z .H9A#$6"f]ނ1 x x x]0SN8PXфC}Cpƣ!膠F;KAAOu`r"2 Rg1R9#ƓoBkWnjo ʼnn\pby,T/ xN1O .M!^yEbJ`IO@Чwں % J v:7mUO)OV =EV=0LA A0qlprłX%WZ"!2V7Br 2ύbX;4 Y]sx !jPF2绘b-F%3c5w 6QЌ?3X$aDn7r4r{ vR$/>lV=Ŋ^.v3q\CRƼqD]%Է{b H'5 "S=Ģ- C2k+͛Ak9u.Ɛ!RFP3;gmsv*kwnLzNLL<[ ^W\e}E LeI4晤Tkn$>y\.h(dv*+[ͬ, %$ <x3000twqqTpv qqs,2000BH+y:srqqqq a %x30C?,(9$5=(33 a\1z\\\{7 xeKn1 5s)ڥ񸪫L: B8jԭrxRlJT{D*,R'R$*lT*]g +- ȒO%FIdʷ!.? S}=٣XAeFJ&1vl2;7Ff?&+վa{hrІ5Ƅ>.Kl jk4M/ݝd4 x x][d.B -3Z IǀYy3Q,&GyC<7-=@Ioy".R?wwG\;@ʝR^SR{mY%CEsf@[׬s큹ޠWJ6* JlbU6QM9s6qM 6I" fɰt&jg65W8&j6QZz&;pMB#l* OljiU&Dt8"p9V79+)B[dqp?X`$Ck X_8L6WSh{+!6@D9gSOEp_%^{.6`u s6,i9`Sɬ9̀gtWz&ۜ3ITL^]#lU5f<^l>)GkMzN,k>f l*d1"F0MfL M͜$8V 6M`hsӱئ Zl)T6lGd^`uMN Cã rZeA+I/DN >,xi ƒ rZZ۸Q={%7NaH!/WZ8lMMЬZ 0Y ۛeݖ 4k{h5w2,/g-|mrp:N,Bk`jG}_u0Z=wC7k/V، z̦bF:!{Mn15uɮ"FT Fk=&m(i*OaHI2lJuSM0S6 { ts kM`Mv+uk6NlaJ6YSM4#2ۦdQ4tb84¦֟)&^e Idئ))&a\`"rJ*7l2"N9T0!8!47QFhM#iY F/9-4aZ {-|5 IJ-·P*1TTM^ jœ}=3k*xpmZ$Ng=X, +PZ+hCZc<¬'Tϡ* qg-EP/|-vYKEoDm)Wgi{($Ʊ6wZ:KkɟvցN B-RRdzZ hW y_*6= kemY$RF @g6G0 \N ?UiEZT+8v 5l2~ >bq}uyỹ]wsb,smW]a(fqy;]`eCy{ϐ}#%&;t8-rٌH^2 68-E YW(|-x£εCs ދ F0FʶWhƷHX@ _#e%Gkl#Y5RvPeklWkMl5Ħ*8t( FklþFvn)^Uʛ)bU 5RvP)Yئ6EkFv)3f.eS#4Fެ%HP_#eLfz6qؔE W_#eO 1P}=){wj){+N}EW}M :HH<);hq4R`SꍱJ÷3k#f· dVZ5c?ZMUb^z-| UdZZ-4^ Zqx-| %,$^ nT^ s8ޤ^ BǥTHQ=]BZמrQ4>/|LC[@hMl5`,Gw Ҳ)[HzuFH}m }![juZ+(rQ 9+$x_@d:->VQx8B,,YsZj[KqS$Z깺][G{Ϯ`&@ kh)ܡ"z-|\1Zv{ mkeLR#yZ~2yWr+<. 7 ;-| -U+>/|۫z+i7#. T}-|RI}!4 (k*^BN:OJ\8~  'xD]=+^\=+u5R [PgE`\ *){(a>)[VeT|戴DT%xFj:FZO;@V7+":-|^V?ХN ѫi{h)K8-E|F ЄPꐑN CI_ji%(:>?i{Ӝj4h-;-Sof^W0x N |ޫY+\{YAh=:p}NN68`)+ҙljg739=gS.MN,~(11HQ\c653 Qc6پVV EI3dțM5*^fg ׆}eQq̘&xd8njo`1鲫L9s= JYz[.|*Ó pȳe_s$/%|>Gn2PX;{-#4=1}-l^ :>jk[kCZ>P#ZviF 8Ra3xe%zV.Xy 7WU/Bf`y{10{_y^xF"&P/Tϫ—o,J5݂|U ;-| =W/|_wN 8) _wP-q"8@Q9V#sBJ=MT^k@ox^KDoJ\"zS&_F56ޓLZOЄOZxކ=иύjW-iӓߩ?Sm[٨j<} u6Ͽ|w1ϑ̣V,A۶l}]Y6v{x.e\_ܖmWymr~m޿z'x|jdzAv0}ҼNrL*pOW| lsPr'i~xRr}t4Z}|𔗭Lw:ysXmrek7qÜ~|>TSXn#%Fzڣ([Mm'MJ`&ᳳTO_R'elu S*vuVS1m9S|'/Xޮ _}6rݵ19)$*;Y^{B=}K;P(Oxiۡmיwme׶M~_tkkDž8oh4׍yn|rY浨_ן}n'/H},1>sk׍h2 +ܧ|o+mn/}z_Yxgd@/][svmrmLw<[>Թ|y-Οp;NϢ|8\&^?@яl7҃^k.3ߦPw@?|/ЙA\o_'ZSz[O1eZko*p~ /߾?~Pb'6s~D r&~KYG!;ٌxh3O/br˱ mk\w!4,Tv>Uv]hvRMr3KIvdzF#)>#3JjƝǂ/Ty]dlX#?ܱSКrs? s6HhCH>XG꧀@[|V-w]\t^(@q2}Dݭn{Ւ,]"񝞲\L |yFohG>xv?.WZb\g>tmaz]eLyOew(sNP9w|?:SmxNEb8uضk e`0n-=bῗ)_ڱumg8˶ϼu@lc$Ct\5w򥝧ZXtVl>hlOy˩.??m!pk b<)8Izs` siа-F0loCئ=ܠMWJ*.efpeG˼U_+>@?dQneb?c uR!H.5:)ns-*mx%gTokO[jۈuDnro|Ō.~{^EC϶l..vv_ x x 3x30 LN (JMW(H,JT(O/VԼb=...Tj yx]K0_KXGe]WdnZP:h7k7A H&O9c 觟'c5rB$$aCVX4me;F, 45\gswl c A$.vw-j.D{q# Q~wxhSG[I~q[[aÒt}BqI>КyO(3R=I'ax_)K!F`2W^t/(y{P&T;U@Qp2&v Rn 5V(̟ yqGu\2*歫ڠרU?FEM |󜏊zBNc>歇4Q-_9F1ʨmQ!_9.U-F|2*dKi F|ϨoJbTN Y(F dvw$ܯo( dvJEmN+d@$#\Il:$vcys E83gHѹ[sbs-P)A͹ဈa, qs-ʳ"xؚ{C+,v:nboC`%}-vZDPŮؐ{CLљؓPG aֶİT},bӭCش#b0ZluTyb_E,؊-`]B-ZDf@!]-%Zl*?>zfE^FQ$Ta2 bE"I7`3cy.ΠMm/u ΠZlU__Uz1mV~{yE3SDtJ|! Zbȋ _}ClQohSʹkE@-ՎýH֣[v`$ێn{([J9[})%w_HXS`J뜨'aľܑۀ،;BrH}L=#ڇiV)UDy1.~ C gET1$cĊ:Sڢ LRiv"jU *bM`Lw߾== 0 ;pP`)ޣ.Q((,qPر[-v({`V/V]`[l H{`,~n5vUͻ+"v(^V{VZl @s{S{}j'7{x[}Ԕ~nW.fbbWhbOP O-?=lbbP F'?XX~@-ߏ0 m-vߣnA}j~F5v(P_'6 --Rcۣ؅|Gc)v"ߓ i &Zb_>쟔O s8ۓ[<n-T?;{耺87q)*<3\U22T7Pqp"_4uK×s޳J%qoʤUb g@b fmQMBl(4*5e-D 02UMY-219Õf*/Mg MK­#S2J+.T!8e$5āҒ(qEHìMxr9>ȝwڌJ02lh!V"Lѧ_!> oq^@W 58sE< JLE@ \#N܊) \j41Y*RQ2.ղsl֏dеmmIk qٙZ5Gu]v僜UV 08s^ϑ.;1PЭ UmTuƺP]A`Ҽ ƨ%+h!(`_w@8,*_CQ򌁷oa()iJsS&4 x*4Y*/Z lG|v皰r$#_;Gs\"IB $ }Jj =!qVٵfĬ79vjAھ 8 :D1mf hIL,p*v&`ЏvP. _'8>:B(%8й@=,FY'%":OK`X/=ئ4K;Z,X#{1dy&6j92)^4~s~NTnrJ(q'TMa d) ɰ8Vg!Pi-;k&:{ޛrA;󫨢H9dKgyrda@LQP49*ΜIb [Grch!)s"p.TwhsPs7>`8/3Dm!$"k9sz hgL #ՒVB+MIJɚV[&&T&[]"1+f!1ς^|-M6mWe sG ͅy-\"*vE%SiUz&'!&-e(b~)o+{OPۨ\likd_Ȗmt ͓uI=NuyV4ӈ,# OR :mD =⎽n74lsʫm`q](bSqdymƖ :/rEMhZ'#aK4 X3[ b"i), ج٦HFil_kY[61dYCQk WVEs5vzFJ!DFT6珒!stU&iǺ !J%KzԆ ԨVT4idmW|!fea olUv8؝SĶ}086^$i(&$$vŃ8hC}ah~SPgף,8|2Q 㥙2 oeǗ9e5 \`QF")[|CjHkGADAIP>yKhΆmN&*DOZL);lT٣y"Qg tsmG61pSc׽@즥WJ) Ky LfL>87YB_5pOOl(z˕w`OKW4uPnYk$D94EeMpY$xnSs ;G28نT2:Ĕ,MfR!%ƴf@g~Fߖ8+8URNnҦd[s@d"d M[z'eTӎtTݶHv[{I`>aaɽ/lP&Oz!U0_& "%(/T󷶍:N $w혿^~mC ̟-$p$6Y˴ +m)^Mm[i"4E&KW+%_be8jiǺ66E *5!8)ﲎKiÛ ${tBZw[MWRhHOEπjQ#|7kG5ڴW$L}5I'i&iTK_F҄y1$W=GKiNSO9ChI=OH¯I(N[I4eM8GsKs|&ս[@6TQ!y_ŗy\bo1/´xe;DQ#HiG5@WW->qCS㰽Mbo~¢X'(^)hgb.;!<{y i|~$|?sZzf.=ғ@yAZ(MV` {K}ֻh mq ֗j'$wƮ'vWkƮo_>{ |_-;Vn#d$CV_ZπYYd@x[ɺ,v¬JVu ;R`w,mK[h7#m:=X [`$oJnw #Y^M y $q[5Qf!hf#8R5q$jHIƑ9#!jq$jq$jq$jq$jQBM9JI;G 5i(&%Ԥ5щsD͹st9:Qs9wNԜ;G'jΝ5щs(&e䝣sQw2jQFM9ʨ;G5y(&e䝣sTPSv jQAM9*);G5e稠ԔsTPSv*jQEM9;G5u稢UԝsTQSw*jQEM9Ps]v.\;Gj 5хkB͵st9Ps]vjQCM9ji;G 5m稡5ԴsPvjQCM8d :x'w2g;tN֠w :x'[+I^3(#đ Ju%q:8rAIΠ$\gPG3(#$/Dđ Ju%q:8uH^ q"y!:C$/]g䅸 w!3DBuH^ vc$qd;8AH $lgG3$y! $lgG3#đ Bv!qd;8AH $lgIBAH $lgG3#đ Bv!qd;82C $LgPMgH082a"qd:Dtđ #&G3L$LgHpI^3D%q:}Hd8rAIpߗ $\gQ#đ Ju_$\gN^3L$LgG@tđ #&G3L$LgH082AIB4a"qd:Dtđ #&G3L$LgH082a"qd:y0a"c;y)<tNwW;ق^Ia:Dtđ #&G3L$LgH082a"qd:Dt% #&G3L$LgH082a"qd:Dtđ Bv$/3#đ Bv!qd;8AH $lgG3#xx&G3L$LgH082a"qd:Dtđ #&G3(I^8LgH082a"qd:Dtđ Hv!qd;8đ0gGv>8đ $\g8Hu%q:8rAIΠ$LgPpΠ$LgH082a"qd:Dv282la q:C##đ B&Gn>8rđϠ$|%q3(#7AI JgPGn>gPGn>8rđϠ$|%q3(#7AI JgPGn>H&BrAtNw :K9,Ad :ztNW\gPG3(#đ Ju%q:8Αđ $|!qd3$y! BgGv>8đ $|!qd3#;AH $lgIBAH $lgG3#,đ #&G3L$LgH $y!Π$\gPG3(#đ Ju%q:8rAIΠ$\g\gPG3(#đ Ju%qd:Dtđ #;AH #I^Hv>8đ $|!qd3#;AH BgGv>8rAHBr*##đ Ju%q:8&HȮGv݄8&đ]71:8&đ]7!$ !qdM#nBHuBȮGv݄8&F !qdM#nBHuBȮGv݄8&đ]7!$ !qdM I^8 !c;y)<tNwW;ق^IiM#nBHuBȮGv݄8&đ Bv!qd;8a$ Bv!qd;8AH $lgG3#đ Bv$/3#đ Bv!qd3#;AH BgGv>8&FpuBȮG388rAIΠ$\gPG3(#g$q:8rAH:8I $lgG3#đ Bv!qd;8a$ Bv!q:ÙGG3(#;AH BgGv>8đ0gG e$qd $đ}>8AH $lgG3#$/n݄8r&đ[7QwD^8ݺ %qM(#nBI I^ m&&ܺ %q:Cu%q:8rAIΠ$\gPG3(#đ Ju%q:C]gP2G;3Ad :x'k;y-$/dđ Ju%q:8rAIΠ$\gPG3(#đ B Jvc$qd;8AHuU&[7$ܺ{G&/dnbgB6a"qd:䅼ϐ y7!n>C&/|L^ȶ3#đ Bv!qd;8a$ v!q ]gWdBvAI3>O^v>N 9|!q:!$v2y!3dBg:80 J=a\W u9 Jȭ+y!MdBޭ: u%q:8rAIΠ$\gPG3jH^Ȯ3(3~EZwA,!p_͒Ztif1ֆ֟>vq֟}Ŗ+|Hlš'[8UA}Q| ZC>Olnvý!V֟=|ԆfS y?1Z&e֟-~;`V#75?zdpcCSm"=A/>aG>5C+E"Z%9y-_!1[+F񵦈Bqo "9_/pH.D||_@yA?? b(2 Cw :x'sCNYtctlA[Ё{V%Ζ:B#J=WZETEݷ/sPU?9^ MpZh%.ЦB(qq&Q7jcVs9,tr̦g&LÙчDԱ:گ砘:fS McQuZP\gOMc6uNTDI*9W-|W"+Y[_5h%-ގ~Kr(ka?G[p8.-(kC/~]s~{8?>Q:y85TwkY1(;{Rg jΝ uQ_RYhKOxLVg<*S-G%Ee_s!X(=!\ox?wp4^7tr8־7 ؼ׹y(2l^怌=A0)9ǯVr-gU}I[}M.k.^瞳4q(~lR;k 9NJv_Hl K/m#HԵEױ%y k8'1 Ii4:䴐MJ3'У~VI] Jk34ܭKNYbPz~Q+u -8=gDԖ]aopz>eBK]KF%yyE%ԥc:=#RzK]Kؔ~H?Jrk{9q^=R_aoǢPi/u05Xk8&cqLI\"7+1.Uo(G5Y(] ӵ> =E.i澩y.uGh^xW)3uM4PΥ!1w\7ޯή6)9Gfhz@mCd~F)2uM3_fBP*' x( x) 0xKn0} yEaL)rNuW@@APQZQ9B-;|Ϥr|pr^WZLw=mkGxAxrkg@1  x, x- hx]msHi]Gս䑠fq £i!|{/K -wTd֓Yjr揮CβzF1V?a"kJ Jʙu nB}ۦ}g`4m}1ѭ8,;-ZkH;N̯FzzWn?m.W7T-Vkm|56ue8TTeNJܻ~&Q 2FmVrtIG>`$#jmzh6>gꠙ7Gn?Z.gA\8|0u ^/./eRpN.`E]N˱;'WںٱMI8q8?˴|dZb3L@ym >vAR1Ñ7Fl4PEw]$zsrpzfWC][7.0l۲?tc}=p%s;WM~AwAh<L<,1gS/yWm2]^QDyQ c.""i&bE{=$)~53]ԲL[8k-ڼЭn먭 tNL!3[c;3wc>AvA$JZ36pBC Imi>~.'ʾFjs$r86չ`I ZTvD"TURW쑬`)ukZBm#5 Ǻl8*s0ߋ~AZb:Vϲ 8HO:羁Kbjgi*Ǎ&7"PIR6߇#^[_;=d&1ߠ vV* 2vvvc䚐afdICv?,;}Qfgl'ԼJ9EEGx{UW+ʌ2.Ed^ibUW-n;? WSKo#U5 ~AV%YV=؊' TGƋ#? :D(f$E. SV5[I0k8 OD^‚SCX&+0,{M`%x|j>8<YQ9P@,3YQRʍHD퐬,cO >8| b ڔ&fE>Lh6"8rBpU%Iebdؤz@J31R ksfQy0෱sÉρ_wX˴ pfC01?rp45-w}D`#Q=X(tn :H R& Xq; z^8%Ͳm%Yo3x}E]6юx$_l^ViT_(]"OᠢU'-(MxbEZZ֚Dn2 u0z|jQџ pz?9˛pKf'm`仜b&=cݛfD?¤&دﯾFKAd 2VI o&+nxz @A%bQU66Y{RaZw%_IJ|jFEU:3l/w *kǴt"vao[%œ?xO=0X!*B!M59;*++岲 ߊj >2WҌlc6y617sC 8X D 9nyw؝nxM' >1:83p>t?vV -|;E}g&]KG|/Wed,(XEr .O\H*6 /0rCWg~Jj ZVgWnFj)Xhfܧ3oIklj(&,O)Q#% Pm?gE0\&IM'~!(rMvuJ-(ޏ 4d>Ou7z-)sYJ db@J3 InbHH^ 4ehZ44_DOEMQ@Syܝ^ 4uh".MLD;3di$ I6Q^ TbG&I|ழXe }}b}{aAV4ƪ]a'LWStcyˌ̨OR*MOgWPX~k&x ^R l[4AŢU3lp*W$S)+!ϛ(>4Z[XK 4AcItÖa]:0v#gT4A$yj5iLQ3`?pE;Q/+fR莍q;E/Q ߠ/Y}H''yM=gHjh{BJ 9kr*SioF]8 ?u3#ˢЭ̸KJS$(QQIe5I*<|Q1v{ø2""_*cr痃1N]#HOIɦe3C% 7w0J'JS)jJz?AėFOeiSD_$Z7(bٞ臋xCic˦e AW1< -*{mB30o}жVwowεm$2魞jp;TύQ͝B HX%v?!G#捰f; 6ܪz;;m+wͼp6n݋AS8]_t(I@\6'  ԳF#_#8 ;᧟~=I. x/ @xs H-/VpML/, v ,IMQ.I,I-VHI,L0 x x1 x2 xm= 0 0E@MP|sԑZ4 >!ڋg;WZNXFK֧jMΆ2A>z,o!&͝F&Gk*cSet׶PRTG Y$9M P3 x4 x5 x6 x7 x8 x9 x: x; x< x= x> x? x@ xA xB xC xD xE xF xG xH xI xJ xK xL xM xN xO xP xQ xR xS xT xU x30CNǔ̼⒢Ĕ"?.s~^ 1ciEfNf" Kfz&RSҔ13N׼ĢtR ]Z 3JMKU/ &g#iۋC%Dg^Y*E9Cf$y=...JV !x30CN3N# NPWnW xuA EpД@c\te+7?R@ݟ1jqH)虾]lnTprd :R0B۞5HCBgP)*a7]hLEjz B_(G"Ci% [bˁs0acX xY xZ x[ x\ x] x x0WIZ`#qp% el#.{+ ww/ƞ0fXU |]E2sshfRR8PIq].g߸u7:YvSh>="> UٶDKEn_8bI,4d]npA'h&.Y<L1"KnPC2Ze&X-Q>bwH؇[?a#Y2\"9R cSWjíP i]޹+l]IX(?ţ4 0͎k;DjDM_ <x30tpt.M+IT(/R(HLO,20`7 p H-OL` _x30#?N܂ԬD.!Hб($7$3.l vOK-JLSpp t@Q~rjq~1L$WWX%a Px30CNԼT?.g@Q~YjjJ~1knANjbJ> gXj^ JSLdef%E`=...b 1xMk@HA hBeðTݠRh{0yafwB0i=!Th# J3D$&!B m?6>X=8a5fT]i&a;Q (eYIHL@bJB[!gh Mx)}][Y(mjSLrSiL0$¦h:uAu_MC@On=:Fgʨ"fԓQFrʭ!I y[M\u^uزX“w;~EtZEQY1