@@ -, +, @@ - Run all patron modification / attributes and verify nothing breaks - Sign off :-D --- .../mysql/atomicupdate/bug_17813_borrower_attributes_pk.sql | 11 +++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 12 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_17813_borrower_attributes_pk.sql --- a/installer/data/mysql/atomicupdate/bug_17813_borrower_attributes_pk.sql +++ a/installer/data/mysql/atomicupdate/bug_17813_borrower_attributes_pk.sql @@ -0,0 +1,11 @@ +ALTER TABLE `borrower_attributes` ADD `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; + +-- $DBversion = "16.12.00.XXX"; +-- if(CheckVersion($DBversion)) { +-- $dbh->do(q{ +-- ALTER TABLE `borrower_attributes` ADD `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST +-- }); +-- +-- print "Upgrade to $DBversion done (Bug 17813: Table borrower_attributes needs a primary key\n"; +-- SetVersion ($DBversion); +-- } --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -1676,6 +1676,7 @@ CREATE TABLE `borrowers` ( -- this table includes information about your patrons DROP TABLE IF EXISTS `borrower_attributes`; CREATE TABLE `borrower_attributes` ( -- values of custom patron fields known as extended patron attributes linked to patrons/borrowers + `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, -- Row id field `borrowernumber` int(11) NOT NULL, -- foreign key from the borrowers table, defines which patron/borrower has this attribute `code` varchar(10) NOT NULL, -- foreign key from the borrower_attribute_types table, defines which custom field this value was entered for `attribute` varchar(255) default NULL, -- custom patron field value --