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 472-478 __PACKAGE__->has_many( Link Here
472
);
472
);
473
473
474
__PACKAGE__->add_columns(
474
__PACKAGE__->add_columns(
475
    '+closed' => { is_boolean => 1 },
475
    '+closed'         => { is_boolean => 1 },
476
    '+skip_serialseq' => { is_boolean => 1 },
476
);
477
);
477
478
478
# You can replace this text with custom content, and it will be preserved on regeneration
479
# 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 1635-1641 CREATE TABLE `issues` ( -- information related to check outs or issues Link Here
1635
  `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues
1635
  `returndate` datetime default NULL, -- date the item was returned, will be NULL until moved to old_issues
1636
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1636
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1637
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1637
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1638
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1638
  `auto_renew` tinyint(1) default FALSE, -- automatic renewal
1639
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1639
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1640
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1640
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1641
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1641
  `issuedate` datetime default NULL, -- date the item was checked out or issued
Lines 1667-1673 CREATE TABLE `old_issues` ( -- lists items that were checked out and have been r Link Here
1667
  `returndate` datetime default NULL, -- date the item was returned
1667
  `returndate` datetime default NULL, -- date the item was returned
1668
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1668
  `lastreneweddate` datetime default NULL, -- date the item was last renewed
1669
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1669
  `renewals` tinyint(4) NOT NULL default 0, -- lists the number of times the item was renewed
1670
  `auto_renew` BOOLEAN default FALSE, -- automatic renewal
1670
  `auto_renew` tinyint(1) default FALSE, -- automatic renewal
1671
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1671
  `auto_renew_error` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL, -- automatic renewal error
1672
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1672
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this record was last touched
1673
  `issuedate` datetime default NULL, -- date the item was checked out or issued
1673
  `issuedate` datetime default NULL, -- date the item was checked out or issued
Lines 1783-1792 CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha Link Here
1783
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1783
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1784
  `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)
1784
  `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)
1785
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
1785
  `lowestPriority` tinyint(1) NOT NULL DEFAULT 0,
1786
  `suspend` BOOLEAN NOT NULL DEFAULT 0,
1786
  `suspend` tinyint(1) NOT NULL DEFAULT 0,
1787
  `suspend_until` DATETIME NULL DEFAULT NULL,
1787
  `suspend_until` DATETIME NULL DEFAULT NULL,
1788
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1788
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1789
  `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1789
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1790
  PRIMARY KEY (`reserve_id`),
1790
  PRIMARY KEY (`reserve_id`),
1791
  KEY priorityfoundidx (priority,found),
1791
  KEY priorityfoundidx (priority,found),
1792
  KEY `borrowernumber` (`borrowernumber`),
1792
  KEY `borrowernumber` (`borrowernumber`),
Lines 1823-1832 CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b Link Here
1823
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1823
  `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library
1824
  `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)
1824
  `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)
1825
  `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)
1825
  `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)
1826
  `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1826
  `suspend` tinyint(1) NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no)
1827
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1827
  `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely)
1828
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1828
  `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting
1829
  `item_level_hold` BOOLEAN NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1829
  `item_level_hold` tinyint(1) NOT NULL DEFAULT 0, -- Is the hpld placed at item level
1830
  PRIMARY KEY (`reserve_id`),
1830
  PRIMARY KEY (`reserve_id`),
1831
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1831
  KEY `old_reserves_borrowernumber` (`borrowernumber`),
1832
  KEY `old_reserves_biblionumber` (`biblionumber`),
1832
  KEY `old_reserves_biblionumber` (`biblionumber`),
Lines 1979-1985 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
1979
  `firstacquidate` date default NULL, -- first issue received date
1979
  `firstacquidate` date default NULL, -- first issue received date
1980
  `manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually
1980
  `manualhistory` tinyint(1) NOT NULL default 0, -- yes or no to managing the history manually
1981
  `irregularity` MEDIUMTEXT, -- any irregularities in the subscription
1981
  `irregularity` MEDIUMTEXT, -- any irregularities in the subscription
1982
  skip_serialseq BOOLEAN NOT NULL DEFAULT 0,
1982
  skip_serialseq tinyint(1) NOT NULL DEFAULT 0,
1983
  `letter` varchar(20) default NULL,
1983
  `letter` varchar(20) default NULL,
1984
  `numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id
1984
  `numberpattern` integer default null, -- the numbering pattern used links to subscription_numberpatterns.id
1985
  locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly
1985
  locale VARCHAR(80) DEFAULT NULL, -- for foreign language subscriptions to display months, seasons, etc correctly
Lines 2922-2932 CREATE TABLE aqcontacts ( Link Here
2922
  fax varchar(100) default NULL,  -- contact's fax number
2922
  fax varchar(100) default NULL,  -- contact's fax number
2923
  email varchar(100) default NULL, -- contact's email address
2923
  email varchar(100) default NULL, -- contact's email address
2924
  notes LONGTEXT, -- notes related to the contact
2924
  notes LONGTEXT, -- notes related to the contact
2925
  orderacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisition orders
2925
  orderacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisition orders
2926
  claimacquisition BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims
2926
  claimacquisition tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive acquisitions claims
2927
  claimissues BOOLEAN NOT NULL DEFAULT 0, -- should this contact receive serial claims
2927
  claimissues tinyint(1) NOT NULL DEFAULT 0, -- should this contact receive serial claims
2928
  acqprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages
2928
  acqprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for acquisitions messages
2929
  serialsprimary BOOLEAN NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
2929
  serialsprimary tinyint(1) NOT NULL DEFAULT 0, -- is this the primary contact for serials messages
2930
  booksellerid int(11) not NULL,
2930
  booksellerid int(11) not NULL,
2931
  PRIMARY KEY  (id),
2931
  PRIMARY KEY  (id),
2932
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
2932
  CONSTRAINT booksellerid_aqcontacts_fk FOREIGN KEY (booksellerid)
Lines 3102-3108 CREATE TABLE IF NOT EXISTS edifact_messages ( Link Here
3102
  basketno INT(11) REFERENCES aqbasket( basketno),
3102
  basketno INT(11) REFERENCES aqbasket( basketno),
3103
  raw_msg LONGTEXT,
3103
  raw_msg LONGTEXT,
3104
  filename MEDIUMTEXT,
3104
  filename MEDIUMTEXT,
3105
  deleted BOOLEAN NOT NULL DEFAULT 0,
3105
  deleted tinyint(1) NOT NULL DEFAULT 0,
3106
  PRIMARY KEY  (id),
3106
  PRIMARY KEY  (id),
3107
  KEY vendorid ( vendor_id),
3107
  KEY vendorid ( vendor_id),
3108
  KEY ediacct (edi_acct),
3108
  KEY ediacct (edi_acct),
3109
- 

Return to bug 21294