View | Details | Raw Unified | Return to bug 6536
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-4 / +6 lines)
Lines 1987-2007 CREATE TABLE `virtualshelfcontents` ( Link Here
1987
1987
1988
DROP TABLE IF EXISTS `z3950servers`;
1988
DROP TABLE IF EXISTS `z3950servers`;
1989
CREATE TABLE `z3950servers` (
1989
CREATE TABLE `z3950servers` (
1990
  `host` varchar(255) default NULL,
1990
  `host` varchar(255) NOT NULL,
1991
  `port` int(11) default NULL,
1991
  `port` int(11) default NULL,
1992
  `db` varchar(255) default NULL,
1992
  `db` varchar(255) default NULL,
1993
  `userid` varchar(255) default NULL,
1993
  `userid` varchar(255) default NULL,
1994
  `password` varchar(255) default NULL,
1994
  `password` varchar(255) default NULL,
1995
  `name` mediumtext,
1995
  `name` mediumtext NOT NULL,
1996
  `id` int(11) NOT NULL auto_increment,
1996
  `id` int(11) NOT NULL auto_increment,
1997
  `checked` smallint(6) default NULL,
1997
  `checked` smallint(6) default NULL,
1998
  `rank` int(11) default NULL,
1998
  `rank` int(11) default NULL,
1999
  `syntax` varchar(80) default NULL,
1999
  `syntax` varchar(80) NOT NULL,
2000
  `icon` text,
2000
  `icon` text,
2001
  `position` enum('primary','secondary','') NOT NULL default 'primary',
2001
  `position` enum('primary','secondary','') NOT NULL default 'primary',
2002
  `type` enum('zed','opensearch') NOT NULL default 'zed',
2002
  `type` enum('zed','opensearch') NOT NULL default 'zed',
2003
  `encoding` text default NULL,
2003
  `encoding` text NOT NULL,
2004
  `description` text NOT NULL,
2004
  `description` text NOT NULL,
2005
  `srufields` text,
2006
  `add_xslt` varchar(255),
2005
  PRIMARY KEY  (`id`)
2007
  PRIMARY KEY  (`id`)
2006
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2008
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2007
2009
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 4399-4404 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4399
    SetVersion($DBversion);
4399
    SetVersion($DBversion);
4400
}
4400
}
4401
4401
4402
$DBversion = "3.05.00.XXX"; #FIXME: RM, please remove 1 in the if and the # before SetVersion
4403
if (1||C4::Context->preference("Version") lt TransformToNum($DBversion)) {
4404
  $dbh->do("ALTER TABLE z3950servers MODIFY COLUMN `host` varchar(255) NOT NULL;");
4405
  $dbh->do("ALTER TABLE z3950servers MODIFY COLUMN `name` mediumtext NOT NULL;");
4406
  $dbh->do("ALTER TABLE z3950servers MODIFY COLUMN `syntax` varchar(80) NOT NULL;");
4407
  $dbh->do("ALTER TABLE z3950servers MODIFY COLUMN `encoding` text NOT NULL;");
4408
  $dbh->do("ALTER TABLE z3950servers ADD COLUMN `srufields` text;");
4409
  $dbh->do("ALTER TABLE z3950servers ADD COLUMN `add_xslt` varchar(255);");
4410
  print "Upgrade to $DBversion done (Bug 6536: Z3950 enhancements)\n";
4411
  #SetVersion ($DBversion); #FIXME
4412
}
4413
4402
=head1 FUNCTIONS
4414
=head1 FUNCTIONS
4403
4415
4404
=head2 DropAllForeignKeys($table)
4416
=head2 DropAllForeignKeys($table)
4405
- 

Return to bug 6536