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

(-)a/Koha/Schema/Result/Aqcontact.pm (+8 lines)
Lines 172-177 __PACKAGE__->belongs_to( Link Here
172
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
172
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
173
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2x8Z9Db2oDULEODgLuw8Q
173
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R2x8Z9Db2oDULEODgLuw8Q
174
174
175
__PACKAGE__->add_columns(
176
    '+orderacquisition' => { is_boolean => 1 },
177
    '+claimacquisition' => { is_boolean => 1 },
178
    '+claimissues'      => { is_boolean => 1 },
179
    '+acqprimary'       => { is_boolean => 1 },
180
    '+serialsprimary'   => { is_boolean => 1 },
181
);
182
175
sub koha_object_class {
183
sub koha_object_class {
176
    'Koha::Acquisition::Bookseller::Contact';
184
    'Koha::Acquisition::Bookseller::Contact';
177
}
185
}
(-)a/Koha/Schema/Result/EdifactMessage.pm (+3 lines)
Lines 198-202 __PACKAGE__->belongs_to( Link Here
198
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
198
# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
199
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHUEsQ+kXjGTRxxc2FFSjQ
199
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHUEsQ+kXjGTRxxc2FFSjQ
200
200
201
__PACKAGE__->add_columns(
202
    '+deleted' => { is_boolean => 1 },
203
);
201
204
202
1;
205
1;
(-)a/Koha/Schema/Result/OldReserve.pm (+6 lines)
Lines 301-306 __PACKAGE__->belongs_to( Link Here
301
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
301
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-18 12:43:15
302
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4vMUC/1kSr3vgQ7n0Pmuug
302
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4vMUC/1kSr3vgQ7n0Pmuug
303
303
304
__PACKAGE__->add_columns(
305
    '+item_level_hold' => { is_boolean => 1 },
306
    '+lowestPriority'  => { is_boolean => 1 },
307
    '+suspend'         => { is_boolean => 1 }
308
);
309
304
sub koha_object_class {
310
sub koha_object_class {
305
    'Koha::Old::Hold';
311
    'Koha::Old::Hold';
306
}
312
}
(-)a/Koha/Schema/Result/SavedSql.pm (+4 lines)
Lines 173-178 __PACKAGE__->set_primary_key("id"); Link Here
173
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39
173
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-01-23 12:56:39
174
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A
174
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f7wxGGnBk3z6mw2CkaeD9A
175
175
176
__PACKAGE__->add_columns(
177
    '+public' => { is_boolean => 1 }
178
);
179
176
sub koha_object_class {
180
sub koha_object_class {
177
    'Koha::Report';
181
    'Koha::Report';
178
}
182
}
(-)a/Koha/Schema/Result/SearchMarcToField.pm (-1 / +5 lines)
Lines 131-136 __PACKAGE__->belongs_to( Link Here
131
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-02 12:47:22
131
# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-02 12:47:22
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9mqZ/zrii+Fv+k+eQNHYUw
132
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9mqZ/zrii+Fv+k+eQNHYUw
133
133
134
__PACKAGE__->add_columns(
135
    '+facet' => { is_boolean => 1 },
136
    '+suggestible' => { is_boolean => 1 },
137
    '+sort' => { is_boolean => 1 },
138
);
134
139
135
# You can replace this text with custom code or comments, and it will be preserved on regeneration
136
1;
140
1;
(-)a/Koha/Schema/Result/Subscription.pm (-1 / +2 lines)
Lines 517-523 __PACKAGE__->has_many( Link Here
517
);
517
);
518
518
519
__PACKAGE__->add_columns(
519
__PACKAGE__->add_columns(
520
    '+closed' => { is_boolean => 1 },
520
    '+closed'         => { is_boolean => 1 },
521
    '+skip_serialseq' => { is_boolean => 1 },
521
);
522
);
522
523
523
# You can replace this text with custom content, and it will be preserved on regeneration
524
# You can replace this text with custom content, and it will be preserved on regeneration
(-)a/installer/data/mysql/kohastructure.sql (-18 / +17 lines)
Lines 1326-1332 CREATE TABLE saved_sql ( -- saved sql reports Link Here
1326
   `type` varchar(255) default NULL, -- always 1 for tabular
1326
   `type` varchar(255) default NULL, -- always 1 for tabular
1327
   `notes` MEDIUMTEXT, -- the notes or description given to this report
1327
   `notes` MEDIUMTEXT, -- the notes or description given to this report
1328
   `cache_expiry` int NOT NULL default 300,
1328
   `cache_expiry` int NOT NULL default 300,
1329
   `public` boolean NOT NULL default FALSE,
1329
   `public` tinyint(1) NOT NULL default FALSE,
1330
    report_area varchar(6) default NULL,
1330
    report_area varchar(6) default NULL,
1331
    report_group varchar(80) default NULL,
1331
    report_group varchar(80) default NULL,
1332
    report_subgroup varchar(80) default NULL,
1332
    report_subgroup varchar(80) default NULL,
Lines 1411-1419 CREATE TABLE `search_marc_to_field` ( Link Here
1411
  search tinyint(1) NOT NULL DEFAULT 1,
1411
  search tinyint(1) NOT NULL DEFAULT 1,
1412
  search_marc_map_id int(11) NOT NULL,
1412
  search_marc_map_id int(11) NOT NULL,
1413
  search_field_id int(11) NOT NULL,
1413
  search_field_id int(11) NOT NULL,
1414
  facet boolean DEFAULT FALSE COMMENT 'true if a facet field should be generated for this',
1414
  facet tinyint(1) DEFAULT FALSE COMMENT 'true if a facet field should be generated for this',
1415
  suggestible boolean DEFAULT FALSE COMMENT 'true if this field can be used to generate suggestions for browse',
1415
  suggestible tinyint(1) DEFAULT FALSE COMMENT 'true if this field can be used to generate suggestions for browse',
1416
  sort boolean DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t',
1416
  sort tinyint(1) DEFAULT NULL COMMENT 'true/false creates special sort handling, null doesn''t',
1417
  PRIMARY KEY(search_marc_map_id, search_field_id),
1417
  PRIMARY KEY(search_marc_map_id, search_field_id),
1418
  FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE,
1418
  FOREIGN KEY(search_marc_map_id) REFERENCES search_marc_map(id) ON DELETE CASCADE ON UPDATE CASCADE,
1419
  FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE
1419
  FOREIGN KEY(search_field_id) REFERENCES search_field(id) ON DELETE CASCADE ON UPDATE CASCADE
Lines 1611-1617 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1611
  `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues
1611
  `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues
1612
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1612
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1613
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1613
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1614
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1614
  `auto_renew` tinyint(1) default FALSE, -- automatic renewal
1615
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1615
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1616
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1616
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1617
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1617
  `issuedate` datetime default NULL, -- date the item was checked out or issued
Lines 1643-1649 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1643
  `returndate` datetime default NULL, -- date the item was returned
1643
  `returndate` datetime default NULL, -- date the item was returned
1644
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1644
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1645
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1645
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1646
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1646
  `auto_renew` tinyint(1) default FALSE, -- automatic renewal
1647
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1647
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1648
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1648
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1649
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1649
  `issuedate` datetime default NULL, -- date the item was checked out or issued
Lines 1759-1768 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1759
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1759
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1760
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1760
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1761
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
1761
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
1762
  `suspend` BOOLEAN NOT NULL DEFAULT 0,
1762
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
1763
  `suspend_until` DATETIME NULL DEFAULT NULL,
1763
  `suspend_until` DATETIME NULL DEFAULT NULL,
1764
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1764
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1765
  `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1765
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1766
  PRIMARY KEY (`reserve_id`),
1766
  PRIMARY KEY (`reserve_id`),
1767
  KEY priorityfoundidx (priority,found),
1767
  KEY priorityfoundidx (priority,found),
1768
  KEY `borrowernumber` (`borrowernumber`),
1768
  KEY `borrowernumber` (`borrowernumber`),
Lines 1799-1808 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1799
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1799
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1800
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1800
  `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date)
1801
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1801
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no)
1802
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1802
  `suspend` tinyint(1) NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1803
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1803
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1804
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1804
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1805
  `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1805
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1806
  PRIMARY KEY (`reserve_id`),
1806
  PRIMARY KEY (`reserve_id`),
1807
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1807
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1808
  KEY `old_reserves_biblionumber` (`biblionumber`),
1808
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 1955-1961 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
1955
  `firstacquidate` date default NULL, -- first issue received date
1955
  `firstacquidate` date default NULL, -- first issue received date
1956
  `manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually
1956
  `manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually
1957
  `irregularity` MEDIUMTEXT, -- any irregularities in the subscription
1957
  `irregularity` MEDIUMTEXT, -- any irregularities in the subscription
1958
  skip_serialseq BOOLEAN NOT NULL DEFAULT 0,
1958
  skip_serialseq tinyint(1) NOT NULL DEFAULT 0,
1959
  `letter` varchar(20) default NULL,
1959
  `letter` varchar(20) default NULL,
1960
  `numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id
1960
  `numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id
1961
  locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly
1961
  locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly
Lines 2925-2935 CREATE TABLE aqcontacts ( Link Here
2925
  fax varchar(100) default NULL,  -- contact's fax number
2925
  fax varchar(100) default NULL,  -- contact's fax number
2926
  email varchar(100) default NULL, -- contact's email address
2926
  email varchar(100) default NULL, -- contact's email address
2927
  notes LONGTEXT, -- notes related to the contact
2927
  notes LONGTEXT, -- notes related to the contact
2928
  orderacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisition orders
2928
  orderacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisition orders
2929
  claimacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims
2929
  claimacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims
2930
  claimissues BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive serial claims
2930
  claimissues tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive serial claims
2931
  acqprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages
2931
  acqprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages
2932
  serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
2932
  serialsprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
2933
  booksellerid int(11) not NULL,
2933
  booksellerid int(11) not NULL,
2934
  PRIMARY KEY  (id),
2934
  PRIMARY KEY  (id),
2935
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
2935
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
Lines 3105-3111 CREATE TABLE IF NOT EXISTS edifact_messages ( Link Here
3105
  basketno INT(11) REFERENCES aqbasket( basketno),
3105
  basketno INT(11) REFERENCES aqbasket( basketno),
3106
  raw_msg LONGTEXT,
3106
  raw_msg LONGTEXT,
3107
  filename MEDIUMTEXT,
3107
  filename MEDIUMTEXT,
3108
  deleted BOOLEAN NOT NULL DEFAULT 0,
3108
  deleted tinyint(1) NOT NULL DEFAULT 0,
3109
  PRIMARY KEY  (id),
3109
  PRIMARY KEY  (id),
3110
  KEY vendorid ( vendor_id),
3110
  KEY vendorid ( vendor_id),
3111
  KEY ediacct (edi_acct),
3111
  KEY ediacct (edi_acct),
3112
- 

Return to bug 21294