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

(-)a/installer/data/mysql/atomicupdate/bug_XXXXX.sql (-2 / +2 lines)
Lines 1-5 Link Here
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
1
ALTER TABLE issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(16) DEFAULT NULL AFTER auto_renew;
2
ALTER TABLE old_issues ADD COLUMN auto_renew_error VARCHAR(32) DEFAULT NULL AFTER auto_renew;
3
3
4
INSERT INTO letter (module, code, name, title, content, message_transport_type, is_tt) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
4
INSERT INTO letter (module, code, name, title, content, message_transport_type, is_tt) VALUES ('circulation', 'AUTO_RENEWALS', 'notification on auto renewing', 'Auto renewals',
5
"Dear [% borrower.firstname %] [% borrower.surname %],
5
"Dear [% borrower.firstname %] [% borrower.surname %],
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 1741-1747 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1741
  `return` varchar(4) default NULL,
1741
  `return` varchar(4) default NULL,
1742
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1742
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1743
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1743
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1744
  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1744
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1745
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1745
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1746
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1746
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1747
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1747
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
Lines 1771-1777 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1771
  `return` varchar(4) default NULL,
1771
  `return` varchar(4) default NULL,
1772
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1772
  `renewals` tinyint(4) default NULL, -- lists the number of times the item was renewed
1773
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1773
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1774
  `auto_renew_error` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1774
  `auto_renew_error` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, -- automatic renewal error
1775
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1775
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1776
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1776
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1777
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1777
  `onsite_checkout` int(1) NOT NULL default 0, -- in house use flag
1778
- 

Return to bug 15705