diff options
author | ramon <ramongomez@us.es> | 2017-12-12 16:28:56 +0000 |
---|---|---|
committer | ramon <ramongomez@us.es> | 2017-12-12 16:28:56 +0000 |
commit | b46042c67f764c242943be42e2fd20eb65fbd4a1 (patch) | |
tree | 56dc1d9acd31ae726791efa5ac17d09f8d3f3443 /admin/Database | |
parent | 30492e97bb7855c682412d02b402881112d00ef7 (diff) |
#708: API REST guarda idioma de la sesiĆ³n para adaptar los mensajes de fin de acceso remoto.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5529 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database')
-rw-r--r-- | admin/Database/ogAdmBD-1.1.0pre.sql | 9 | ||||
-rw-r--r-- | admin/Database/ogAdmBD.sql | 1 |
2 files changed, 6 insertions, 4 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0pre.sql b/admin/Database/ogAdmBD-1.1.0pre.sql index e9ec87e6..8b68899d 100644 --- a/admin/Database/ogAdmBD-1.1.0pre.sql +++ b/admin/Database/ogAdmBD-1.1.0pre.sql @@ -223,16 +223,17 @@ ALTER TABLE aulas MODIFY puestos SMALLINT DEFAULT NULL; # Nuevas tablas para datos del proyecto Remote PC y operaciones de OGAgent (ticket #708). -CREATE TABLE IF NOT EXISTS remotepc ( +DROP TABLE IF EXISTS remotepc; +CREATE TABLE remotepc ( id INT(11) NOT NULL, reserved DATETIME DEFAULT NULL, urllogin VARCHAR(100), urllogout VARCHAR(100), + language VARCHAR(5), PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -ALTER TABLE remotepc - MODIFY reserved DATETIME DEFAULT NULL; -CREATE TABLE IF NOT EXISTS ogagent_queue ( +DROP TABLE IF EXISTS ogagent_queue; +CREATE TABLE ogagent_queue ( id INT(11) NOT NULL AUTO_INCREMENT, clientid INT(11) NOT NULL, exectime DATETIME DEFAULT NULL, diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 55f11a2b..c126f63c 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -791,6 +791,7 @@ CREATE TABLE `remotepc` ( `reserved` datetime DEFAULT NULL, `urllogin` varchar(100), `urllogout` varchar(100), + `language` varchar(5), PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |