Index: tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql
===================================================================
--- tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql	(revision 1fa4a387b81361a65c06d7396407d56059e5966c)
+++ tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql	(revision 8d891ee85c875e2693855c08328de416af4defaf)
@@ -14,5 +14,5 @@
   same or another data base server or even in other type of data storement 
   system (BDT, OIS, ...).
-  
+
 ///////////////////////////////////////////////////////////////////////////// */
 
@@ -43,4 +43,5 @@
 ALTER TABLE `bsrhlm_v_obs_transferFunction`     DROP FOREIGN KEY `FK_bsrhlm_v_obs_transferFunction_model_session_node`;
 ALTER TABLE `bsrhlm_v_obs_input`                DROP FOREIGN KEY `FK_bsrhlm_v_obs_input_model_session_node`;
+ALTER TABLE `bsrhlm_v_obs_sigma_block`          DROP FOREIGN KEY `FK_bsrhlm_v_obs_sigma_block_model_session_node`;
 ALTER TABLE `bsrhlm_v_obs_arima_block`          DROP FOREIGN KEY `FK_bsrhlm_v_arima_block_model_session_node`;
 ALTER TABLE `bsrhlm_v_obs_output`               DROP         KEY `UK_bsrhlm_v_obs_output_model_session_node_series`;
@@ -73,4 +74,5 @@
 DROP TABLE IF EXISTS `bsrhlm_v_obs_transferFunction`;
 DROP TABLE IF EXISTS `bsrhlm_v_obs_input`;
+DROP TABLE IF EXISTS `bsrhlm_v_obs_sigma_block`;
 DROP TABLE IF EXISTS `bsrhlm_v_obs_arima_block`;
 DROP TABLE IF EXISTS `bsrhlm_v_obs_output`;
@@ -216,5 +218,5 @@
 
 /* /////////////////////////////////////////////////////////////////////////////
-The user must insert a register for each distinct application of a session tag 
+The user must insert a register for each distinct application of a session tag
 over a model
 ///////////////////////////////////////////////////////////////////////////// */
@@ -258,5 +260,5 @@
 This table is related to mixed nodes.
 The user must insert a register for each variable of all gibbs blocks of all
-nodes of each model-session. 
+nodes of each model-session.
 ///////////////////////////////////////////////////////////////////////////// */
 CREATE TABLE  `bsrhlm_v_mix_parameter` (
@@ -283,5 +285,5 @@
 /* /////////////////////////////////////////////////////////////////////////////
 This table is related to mixed nodes.
-The user must insert a register for each non linear filter. 
+The user must insert a register for each non linear filter.
 ///////////////////////////////////////////////////////////////////////////// */
 CREATE TABLE  `bsrhlm_v_mix_non_lin_filter` (
@@ -357,8 +359,8 @@
 In this table id_node is never the MIXTURE but just one OBS or LAT node where
 the parameter comes from.
-The user must insert a register for each parameter affected by each 
-constraining inequation. Remeber that if 
-   constraint_border.id_node<>'MIXTURE' then 
-   constraint_border.id_node=constraint_lin_cmb.id_node for all 
+The user must insert a register for each parameter affected by each
+constraining inequation. Remeber that if
+   constraint_border.id_node<>'MIXTURE' then
+   constraint_border.id_node=constraint_lin_cmb.id_node for all
    constraint_border.nu_inequation=constraint_lin_cmb.nu_inequation
 ///////////////////////////////////////////////////////////////////////////// */
@@ -401,4 +403,5 @@
   `dh_start` datetime NULL,
   `dh_end`  datetime NULL,
+  `vl_sigma` double  NULL,
   PRIMARY KEY (`id_model`,`id_session`,`id_node`),
   CONSTRAINT `UK_bsrhlm_v_obs_output_model_session_node_series`
@@ -411,8 +414,24 @@
 COMMENT='Stores observational output related information for each model-session';
 
-
 /* /////////////////////////////////////////////////////////////////////////////
 This table is related to observational nodes.
-The user must insert a register for each ARIMA factor attached to an output 
+The user must insert a register for each latent node of each model-session.
+///////////////////////////////////////////////////////////////////////////// */
+CREATE TABLE  `bsrhlm_v_obs_sigma_block` (
+  `id_model` varchar(64) NOT NULL,
+  `id_session` varchar(64) NOT NULL,
+  `id_node` varchar(64) NOT NULL,
+  `vl_sigma` double NULL,
+  PRIMARY KEY (`id_model`,`id_session`,`id_node`),
+  CONSTRAINT `FK_bsrhlm_v_obs_sigma_block_model_session_node`
+    FOREIGN KEY                (`id_model`, `id_session`, `id_node`)
+    REFERENCES `bsrhlm_d_node` (`id_model`, `id_session`, `id_node`)
+    ON UPDATE CASCADE ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
+COMMENT='Stores sigma block information about observational nodes for each model-session. If sigma is null then it will be simulated by Gibbs method';
+
+/* /////////////////////////////////////////////////////////////////////////////
+This table is related to observational nodes.
+The user must insert a register for each ARIMA factor attached to an output
 serie at observation level of each model-session
 AR and MA polinomial are given as text with maximum degree 2 in the standard way
@@ -443,5 +462,5 @@
 /* /////////////////////////////////////////////////////////////////////////////
 This table is related to observational nodes.
-The user must insert a register for each input serie of each observation node of 
+The user must insert a register for each input serie of each observation node of
 each model-session.
 Pair (id_node, id_series) will be used by a NameBlock series.handler to return
@@ -470,5 +489,5 @@
 /* /////////////////////////////////////////////////////////////////////////////
 This table is related to observational nodes.
-The user must insert a register for each transfer function 
+The user must insert a register for each transfer function
   omega(B)*y = delta(B)*x
 of each observation node of each model-session.
@@ -483,5 +502,5 @@
   `id_transferFunction` varchar(64) NOT NULL,
   `te_omega` varchar(1020) NOT NULL,
-  `te_delta` varchar(1020) NOT NULL,  
+  `te_delta` varchar(1020) NOT NULL,
   `id_series` varchar(64) NOT NULL,
   `vl_mis_pri_sig_fac` double  NULL,
@@ -516,7 +535,7 @@
 This table is related to latent nodes.
 The user must insert a register for each regression equation of each latent node
-of each model-session. Each equation is attached to a linear combination of 
-child parameters at left side of equal sign, wich will be defined in 
-bsrhlm_v_lat_output; and other linear combination of father parameters at right 
+of each model-session. Each equation is attached to a linear combination of
+child parameters at left side of equal sign, wich will be defined in
+bsrhlm_v_lat_output; and other linear combination of father parameters at right
 side of equal sign, wich will be defined in bsrhlm_v_lat_input.
 ///////////////////////////////////////////////////////////////////////////// */