From d98587afed65a1d252659870d87b70bfdc2f97ce Mon Sep 17 00:00:00 2001 From: Paul POULAIN Date: Tue, 9 Oct 2007 16:46:41 -0500 Subject: [PATCH] The kohafield in authorities can't be NOT NULL (as it is always null in fact...) Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/kohastructure.sql | 2 +- updater/update22to30.pl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/kohastructure.sql b/installer/kohastructure.sql index 96873575ec..c07a0651a3 100644 --- a/installer/kohastructure.sql +++ b/installer/kohastructure.sql @@ -289,7 +289,7 @@ CREATE TABLE `auth_subfield_structure` ( `isurl` tinyint(1) default NULL, `hidden` tinyint(3) NOT NULL default 0, `linkid` tinyint(1) NOT NULL default 0, - `kohafield` varchar(45) NOT NULL default '', + `kohafield` varchar(45) NULL default '', `frameworkcode` varchar(8) NOT NULL default '', PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), KEY `tab` (`authtypecode`,`tab`) diff --git a/updater/update22to30.pl b/updater/update22to30.pl index 2eed298098..55b65e3cd7 100755 --- a/updater/update22to30.pl +++ b/updater/update22to30.pl @@ -207,7 +207,7 @@ my $DBversion = "3.00.00.000"; aqbookfund => { 'branchcode' => 'varchar(4) NULL'}, aqbudget => { 'branchcode' => 'varchar(4) NULL'}, auth_header => { 'marc' => 'BLOB NOT NULL', 'linkid' => 'BIGINT(20) NULL'}, - auth_subfield_structure =>{ 'hidden' => 'TINYINT(3) NOT NULL default 0', 'kohafield' => 'VARCHAR(45) NOT NULL', 'linkid' => 'TINYINT(1) NOT NULL default 0', 'isurl' => 'TINYINT(1)', 'frameworkcode'=>'VARCHAR(8) NOT NULL'}, + auth_subfield_structure =>{ 'hidden' => 'TINYINT(3) NOT NULL default 0', 'kohafield' => 'VARCHAR(45) NULL', 'linkid' => 'TINYINT(1) NOT NULL default 0', 'isurl' => 'TINYINT(1)', 'frameworkcode'=>'VARCHAR(8) NOT NULL'}, marc_breeding => { 'isbn' => 'varchar(13) NOT NULL'}, serial =>{ 'publisheddate' => 'date', 'claimdate' => 'date', 'itemnumber'=>'text NULL','routingnotes'=>'text NULL',}, statistics => { 'associatedborrower' => 'integer'}, -- 2.39.5