summaryrefslogtreecommitdiffstats
path: root/admin/Database
diff options
context:
space:
mode:
authorramon <ramongomez@us.es>2017-12-12 16:28:56 +0000
committerramon <ramongomez@us.es>2017-12-12 16:28:56 +0000
commitb46042c67f764c242943be42e2fd20eb65fbd4a1 (patch)
tree56dc1d9acd31ae726791efa5ac17d09f8d3f3443 /admin/Database
parent30492e97bb7855c682412d02b402881112d00ef7 (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.sql9
-rw-r--r--admin/Database/ogAdmBD.sql1
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;