structure.sql in msip-2.2.0.beta1

- old
+ new

@@ -61,26 +61,11 @@
 -- Name: msip_edad_de_fechanac_fecharef(integer, integer, integer, integer, integer, integer); Type: FUNCTION; Schema: public; Owner: -
 --
 
 CREATE FUNCTION public.msip_edad_de_fechanac_fecharef(anionac integer, mesnac integer, dianac integer, anioref integer, mesref integer, diaref integer) RETURNS integer
     LANGUAGE sql IMMUTABLE
-    AS $$
-        SELECT CASE 
-          WHEN anionac IS NULL THEN NULL
-          WHEN anioref IS NULL THEN NULL
-          WHEN mesnac IS NULL OR dianac IS NULL OR mesref IS NULL OR diaref IS NULL THEN 
-            anioref-anionac 
-          WHEN mesnac < mesref THEN
-            anioref-anionac
-          WHEN mesnac > mesref THEN
-            anioref-anionac-1
-          WHEN dianac > diaref THEN
-            anioref-anionac-1
-          ELSE 
-            anioref-anionac
-        END 
-      $$;
+    AS $$ SELECT CASE WHEN anionac IS NULL THEN NULL WHEN anioref IS NULL THEN NULL WHEN anioref < anionac THEN -1 WHEN mesnac IS NOT NULL AND mesnac > 0 AND mesref IS NOT NULL AND mesref > 0 AND mesnac >= mesref THEN CASE WHEN mesnac > mesref OR (dianac IS NOT NULL AND dianac > 0 AND diaref IS NOT NULL AND diaref > 0 AND dianac > diaref) THEN anioref-anionac-1 ELSE anioref-anionac END ELSE anioref-anionac END $$;
 
 
 --
 -- Name: soundexesp(text); Type: FUNCTION; Schema: public; Owner: -
 --
@@ -265,10 +250,15 @@
     created_at timestamp without time zone,
     updated_at timestamp without time zone,
     observaciones character varying(5000) COLLATE public.es_co_utf_8,
     ultvigenciaini date,
     ultvigenciafin date,
+    svgruta character varying,
+    svgcdx integer,
+    svgcdy integer,
+    svgcdancho integer,
+    svgcdalto integer,
     CONSTRAINT clase_check CHECK (((fechadeshabilitacion IS NULL) OR (fechadeshabilitacion >= fechacreacion)))
 );
 
 
 --
@@ -302,10 +292,15 @@
     codiso character varying(6),
     catiso character varying(64),
     codreg integer,
     ultvigenciaini date,
     ultvigenciafin date,
+    svgruta character varying,
+    svgcdx integer,
+    svgcdy integer,
+    svgcdancho integer,
+    svgcdalto integer,
     CONSTRAINT departamento_check CHECK (((fechadeshabilitacion IS NULL) OR (fechadeshabilitacion >= fechacreacion)))
 );
 
 
 --
@@ -338,10 +333,15 @@
     observaciones character varying(5000) COLLATE public.es_co_utf_8,
     codreg integer,
     ultvigenciaini date,
     ultvigenciafin date,
     tipomun character varying(32),
+    svgruta character varying,
+    svgcdx integer,
+    svgcdy integer,
+    svgcdancho integer,
+    svgcdalto integer,
     CONSTRAINT municipio_check CHECK (((fechadeshabilitacion IS NULL) OR (fechadeshabilitacion >= fechacreacion)))
 );
 
 
 --
@@ -902,11 +902,16 @@
     updated_at timestamp without time zone,
     observaciones character varying(5000) COLLATE public.es_co_utf_8,
     nombreiso_ingles character varying(512),
     nombreiso_frances character varying(512),
     ultvigenciaini date,
-    ultvigenciafin date
+    ultvigenciafin date,
+    svgruta character varying,
+    svgcdx integer,
+    svgcdy integer,
+    svgcdancho integer,
+    svgcdalto integer
 );
 
 
 --
 -- Name: msip_pais_histvigencia; Type: TABLE; Schema: public; Owner: -
@@ -1148,11 +1153,12 @@
     formatoregex character varying(500),
     fechacreacion date NOT NULL,
     fechadeshabilitacion date,
     created_at timestamp without time zone,
     updated_at timestamp without time zone,
-    observaciones character varying(5000) COLLATE public.es_co_utf_8
+    observaciones character varying(5000) COLLATE public.es_co_utf_8,
+    ayuda character varying(1000)
 );
 
 
 --
 -- Name: msip_tdocumento_id_seq; Type: SEQUENCE; Schema: public; Owner: -
@@ -2520,8 +2526,19 @@
 ('20220722000850'),
 ('20220722192214'),
 ('20220805181901'),
 ('20220822132754'),
 ('20221024221557'),
-('20221025025402');
+('20221025025402'),
+('20221102144613'),
+('20221102145906'),
+('20221118032223'),
+('20221201143440'),
+('20221201154025'),
+('20221208173349'),
+('20221210155527'),
+('20221211141207'),
+('20221211141208'),
+('20221211141209'),
+('20221212021533');
 
 