diff options
author | ramon <ramongomez@us.es> | 2017-03-31 10:37:08 +0000 |
---|---|---|
committer | ramon <ramongomez@us.es> | 2017-03-31 10:37:08 +0000 |
commit | 2b2311f9baacd6701aa06ff40b5ef1b71d24e4d8 (patch) | |
tree | cdb38d2913a86c59f775c0158d7c43ceb04d63ff /admin/Database/ogAdmBD.sql | |
parent | 43b6d0b8bbc33e0562ec2ca543fa39f658cb52da (diff) |
#778: Modificar BD para guardar clave de usuario codificada con funciĆ³n AES2 de 224 bits.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5253 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
-rw-r--r-- | admin/Database/ogAdmBD.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 0e5546fc..7d0aeca3 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -1076,7 +1076,7 @@ CREATE TABLE IF NOT EXISTS `urlimagesitems` ( CREATE TABLE IF NOT EXISTS `usuarios` ( `idusuario` int(11) NOT NULL AUTO_INCREMENT, `usuario` varchar(50) NOT NULL DEFAULT '', - `pasguor` varchar(50) NOT NULL DEFAULT '', + `pasguor` varchar(56) NOT NULL DEFAULT '', `nombre` varchar(200) DEFAULT NULL, `email` varchar(200) DEFAULT NULL, `ididioma` int(11) DEFAULT NULL, @@ -1090,6 +1090,6 @@ CREATE TABLE IF NOT EXISTS `usuarios` ( -- INSERT INTO `usuarios` (`idusuario`, `usuario`, `pasguor`, `nombre`, `email`, `ididioma`, `idtipousuario`, `apikey`) VALUES -(1, 'DBUSER', 'DBPASSWORD', 'Usuario de la base de datos MySql', '', 1, 1, 'APIKEY'); +(1, 'DBUSER', SHA2('DBPASSWORD', 224) 'Usuario de la base de datos MySql', '', 1, 1, 'APIKEY'); |