diff options
| author | ramon <ramongomez@us.es> | 2015-12-16 10:24:35 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2015-12-16 10:24:35 +0000 |
| commit | 56529d24a607c3a027491c42482705d96dc044bc (patch) | |
| tree | b19898fc331f77b2cce9948c871280371280c714 /admin/Database/ogAdmBD.sql | |
| parent | 1893b9d3da7616cfea7ece81ddbff1d2a8a0174e (diff) | |
#678: Modificar BD para separar directorios para distintas unidades organizativas.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@4759 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 1cec7307..5e4b7fbd 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -176,6 +176,7 @@ CREATE TABLE IF NOT EXISTS `centros` ( `nombrecentro` varchar(100) NOT NULL DEFAULT '', `identidad` int(11) DEFAULT NULL, `comentarios` text, + `directorio` varchar(50) DEFAULT '', PRIMARY KEY (`idcentro`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; @@ -244,6 +245,7 @@ CREATE TABLE IF NOT EXISTS `entidades` ( `comentarios` text, `iduniversidad` int(11) DEFAULT NULL, `grupoid` int(11) DEFAULT NULL, + `ogunit` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`identidad`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; |