diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2020-01-27 11:34:19 +0100 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2020-01-27 11:34:19 +0100 |
| commit | 45e3244cd69944ddf4246996539dacd1caa14bd9 (patch) | |
| tree | 1dac735393cb33a1422bcd6f095312ce6d5570c1 /admin/Database/ogAdmBD.sql | |
| parent | 5969a131491786738a52790a0fa82105c7d41c55 (diff) | |
#951: Review default settings of non-null fields in the SQL file.
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 6 |
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`) |