From 45e3244cd69944ddf4246996539dacd1caa14bd9 Mon Sep 17 00:00:00 2001
From: "Ramón M. Gómez" <ramongomez@us.es>
Date: Mon, 27 Jan 2020 11:34:19 +0100
Subject: #951: Review default settings of non-null fields in the SQL file.

---
 admin/Database/ogAdmBD.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

(limited to 'admin/Database')

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`)
-- 
cgit v1.2.3-18-g5258