summaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
authorRamón M. Gómez <ramongomez@us.es>2020-01-27 11:34:19 +0100
committerRamón M. Gómez <ramongomez@us.es>2020-01-27 11:34:19 +0100
commit45e3244cd69944ddf4246996539dacd1caa14bd9 (patch)
tree1dac735393cb33a1422bcd6f095312ce6d5570c1 /admin
parent5969a131491786738a52790a0fa82105c7d41c55 (diff)
#951: Review default settings of non-null fields in the SQL file.
Diffstat (limited to 'admin')
-rw-r--r--admin/Database/ogAdmBD.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql
index 607382a9..77e0f0ce 100644
--- a/admin/Database/ogAdmBD.sql
+++ b/admin/Database/ogAdmBD.sql
@@ -496,7 +496,7 @@ CREATE TABLE `nombresos` (
DROP TABLE IF EXISTS `ogagent_queue`;
CREATE TABLE `ogagent_queue` (
`id` int(11) NOT NULL AUTO_INCREMENT,
- `clientid` int(11) NOT NULL,
+ `clientid` int(11) NOT NULL DEFAULT 0,
`exectime` datetime DEFAULT NULL,
`operation` varchar(25),
-- `parameters` varchar(100),
@@ -788,7 +788,7 @@ CREATE TABLE `programaciones` (
DROP TABLE IF EXISTS `remotepc`;
CREATE TABLE `remotepc` (
- `id` int(11) NOT NULL,
+ `id` int(11) NOT NULL DEFAULT 0,
`reserved` datetime DEFAULT NULL,
`urllogin` varchar(100),
`urllogout` varchar(100),
@@ -1010,7 +1010,7 @@ INSERT INTO `tiposos` (`idtiposo`, `tiposo`, `idplataforma`) VALUES
DROP TABLE IF EXISTS `tipospar`;
CREATE TABLE `tipospar` (
- `codpar` int(8) NOT NULL,
+ `codpar` int(8) NOT NULL DEFAULT 0,
`tipopar` varchar(250) NOT NULL DEFAULT '',
`clonable` tinyint(4) NOT NULL DEFAULT '0',
UNIQUE KEY `codpar` (`codpar`)