Changeset 39b143a in tol

Timestamp:

Nov 5, 2008, 9:24:09 AM (18 years ago)

Author:

Víctor de Buen <vdebuen@…>

Branches:

1941-docker-image-to-test, devel, master

Children:

47f88e4

Parents:

098bb4d

Message:

Removing table "bsrhlm_v_obs_sigma_block"

git-svn-id: ​https://www.tol-project.org/svn/tolp/trunk@123 be4846ae-f051-483a-831f-b64e7d08527f

File:

• tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql (modified) (3 diffs)

tol/stdlib/math/stat/models/bayesian/bysMcmc/bsr/dynhlm/db_bsrhlm_mysql.sql

@@ -43 +43 @@
 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`;
@@ -74 +73 @@
 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`;
@@ -414 +412 @@
 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 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';
 
 /* /////////////////////////////////////////////////////////////////////////////