[Koha-bugs] [Bug 30571] Table z3950servers: which fields should be NOT NULL ?

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30571

Marcel de Rooy <m.de.rooy at rijksmuseum.nl> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|30486                       |

--- Comment #3 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
Here is the first kohastructure.sql from our git repo for z3950servers:

DROP TABLE IF EXISTS `z3950servers`;
CREATE TABLE `z3950servers` (
  `host` varchar(255) default NULL,
  `port` int(11) default NULL,
  `db` varchar(255) default NULL,
  `userid` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `name` mediumtext,
  `id` int(11) NOT NULL auto_increment,
  `checked` smallint(6) default NULL,
  `rank` int(11) default NULL,
  `syntax` varchar(80) default NULL,
  `icon` text,
  `position` enum('primary','secondary','') NOT NULL default 'primary',
  `type` enum('zed','opensearch') NOT NULL default 'zed',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Encoding was added later:
$DBversion = "3.00.00.049";
    $dbh->do("ALTER TABLE `z3950servers` ADD `encoding` text default NULL AFTER
type ");

Conclusion: I must have changed these fields myself somehow. Although it seems
the right thing, it is NOT a sync problem.
Removing the omnibus reference.


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30486
[Bug 30486] [OMNIBUS] Synchronize database schema with (older) database
revisions
-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.