Attachment #82456 for bug #20581

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

Lines 223-229 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Aqbasket.pm (-3 / +3 lines)
223	{	223	{
224	is_deferrable => 1,	224	is_deferrable => 1,
225	join_type => "LEFT",	225	join_type => "LEFT",
226	on_delete => "RESTRICT",	226	on_delete => "SET NULL",
227	on_update => "CASCADE",	227	on_update => "CASCADE",
228	},	228	},
229	);	229	);
Lines 309-316 Composing rels: L</aqbasketusers> -> borrowernumber Link Here
309	__PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber");	309	__PACKAGE__->many_to_many("borrowernumbers", "aqbasketusers", "borrowernumber");
310		310
311		311
312	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	312	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
313	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gSw/f4JmMBzEssEFRg2fAQ	313	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j41n7K4Pygo6KvdmRKaggA
314		314
315		315
316	# You can replace this text with custom code or comments, and it will be preserved on regeneration	316	# You can replace this text with custom code or comments, and it will be preserved on regeneration




=head2 billingplace

  data_type: 'varchar'
  is_nullable: 0
  size: 10

=cut

  "deliverycomment",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "billingplace",
  { data_type => "varchar", is_nullable => 0, size => 10 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LE9jdrqhTciPR6UG+PnIXQ


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 currency

  data_type: 'varchar'
  is_nullable: 1
  is_nullable: 0
  size: 10

=head2 booksellerfax

  data_type: 'tinyint'
  is_nullable: 1

=head2 tax_rate

  data_type: 'decimal'
  is_nullable: 1
  size: [6,4]

=head2 discount

  data_type: 'float'

  is_nullable: 1
  size: 50

=head2 tax_rate

  data_type: 'decimal'
  is_nullable: 1
  size: [6,4]

=head2 deliverytime

  data_type: 'integer'

  "othersupplier",
  { data_type => "longtext", is_nullable => 1 },
  "currency",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "booksellerfax",
  { data_type => "longtext", is_nullable => 1 },
  "notes",

  { data_type => "tinyint", is_nullable => 1 },
  "invoiceincgst",
  { data_type => "tinyint", is_nullable => 1 },
  "tax_rate",
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
  "discount",
  { data_type => "float", is_nullable => 1, size => [6, 4] },
  "fax",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "tax_rate",
  { data_type => "decimal", is_nullable => 1, size => [6, 4] },
  "deliverytime",
  { data_type => "integer", is_nullable => 1 },
);

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i1MBNQ/K1Rh4wMZDnFCEzw

__PACKAGE__->add_columns(
    '+active' => { is_boolean => 1 },





=head1 ACCESSORS

=head2 budget_code

  data_type: 'varchar'
  is_nullable: 1
  size: 30

=head2 budget_amount

  data_type: 'decimal'
  default_value: 0.000000
  is_nullable: 0
  size: [28,6]

=head2 budget_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 budget_branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 budget_parent_id

  data_type: 'integer'
  is_nullable: 1
  size: 30

=head2 budget_name


  is_nullable: 1
  size: 80

=head2 budget_branchcode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 budget_amount

  data_type: 'decimal'
  default_value: 0.000000
  is_nullable: 1
  size: [28,6]

=head2 budget_encumb

  data_type: 'decimal'

=head2 budget_period_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 sort1_authcat

=cut

__PACKAGE__->add_columns(
  "budget_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "budget_parent_id",
  { data_type => "integer", is_nullable => 1 },
  "budget_code",
  { data_type => "varchar", is_nullable => 1, size => 30 },
  "budget_name",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "budget_branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "budget_amount",
  {
    data_type => "decimal",
    default_value => "0.000000",
    is_nullable => 0,
    size => [28, 6],
  },
  "budget_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "budget_branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "budget_parent_id",
  { data_type => "integer", is_nullable => 1 },
  "budget_name",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "budget_encumb",
  {
    data_type => "decimal",

    is_nullable => 0,
  },
  "budget_period_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "sort1_authcat",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "sort2_authcat",

  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 budget_period

Type: belongs_to

Related object: L<Koha::Schema::Result::Aqbudgetperiod>

=cut

__PACKAGE__->belongs_to(
  "budget_period",
  "Koha::Schema::Result::Aqbudgetperiod",
  { budget_period_id => "budget_period_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);

=head2 suggestions

Type: has_many

__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oAGvpiU7zjOnpWEfpOMmDw


# You can replace this text with custom content, and it will be preserved on regeneration




  data_type: 'longtext'
  is_nullable: 1

=head2 budget_period_total

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 budget_period_locked

  data_type: 'tinyint'

  is_nullable: 1
  size: 10

=head2 budget_period_total

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=cut

__PACKAGE__->add_columns(

  { data_type => "tinyint", default_value => 0, is_nullable => 1 },
  "budget_period_description",
  { data_type => "longtext", is_nullable => 1 },
  "budget_period_total",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "budget_period_locked",
  { data_type => "tinyint", is_nullable => 1 },
  "sort1_authcat",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "sort2_authcat",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "budget_period_total",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
);

=head1 PRIMARY KEY


__PACKAGE__->set_primary_key("budget_period_id");

=head1 RELATIONS

=head2 aqbudgets

Type: has_many

Related object: L<Koha::Schema::Result::Aqbudget>

=cut

__PACKAGE__->has_many(
  "aqbudgets",
  "Koha::Schema::Result::Aqbudget",
  { "foreign.budget_period_id" => "self.budget_period_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V7R0Zdn1ZrQoRIcib6LUIw


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 message_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=cut

  "shipmentcost_budgetid",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "message_id",
  { data_type => "integer", is_nullable => 1 },
);

=head1 PRIMARY KEY

  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 message

Type: belongs_to

Related object: L<Koha::Schema::Result::EdifactMessage>

=cut

__PACKAGE__->belongs_to(
  "message",
  "Koha::Schema::Result::EdifactMessage",
  { id => "message_id" },
  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "RESTRICT",
  },
);

=head2 shipmentcost_budgetid

Type: belongs_to

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vt50GepELpI7iE49C9dTJA


# You can replace this text with custom content, and it will be preserved on regeneration




  is_nullable: 1
  size: [13,2]

=head2 replacementprice

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=head2 rrp_tax_excluded

  data_type: 'decimal'

  is_nullable: 1
  size: [6,4]

=head2 budget_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 budgetdate

  data_type: 'date'

  is_nullable: 1
  size: 80

=head2 uncertainprice

  data_type: 'tinyint'
  is_nullable: 1

=head2 budget_id

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 sort1_authcat

  data_type: 'varchar'

  is_nullable: 1
  size: 10

=head2 uncertainprice

  data_type: 'tinyint'
  is_nullable: 1

=head2 claims_count

  data_type: 'integer'

  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 parent_ordernumber

  data_type: 'integer'

  is_nullable: 1
  size: 16

=head2 subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 1

=head2 line_item_id

  data_type: 'varchar'

  data_type: 'mediumtext'
  is_nullable: 1

=head2 replacementprice

  data_type: 'decimal'
  is_nullable: 1
  size: [28,6]

=cut

__PACKAGE__->add_columns(

  },
  "rrp",
  { data_type => "decimal", is_nullable => 1, size => [13, 2] },
  "replacementprice",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "rrp_tax_excluded",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "rrp_tax_included",

  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "discount",
  { data_type => "float", is_nullable => 1, size => [6, 4] },
  "budget_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "budgetdate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "sort1",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "sort2",
  { data_type => "varchar", is_nullable => 1, size => 80 },
  "uncertainprice",
  { data_type => "tinyint", is_nullable => 1 },
  "budget_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "sort1_authcat",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "sort2_authcat",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "uncertainprice",
  { data_type => "tinyint", is_nullable => 1 },
  "claims_count",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "claimed_date",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "subscriptionid",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "parent_ordernumber",
  { data_type => "integer", is_nullable => 1 },
  "orderstatus",

    is_nullable => 1,
    size => 16,
  },
  "subscriptionid",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "line_item_id",
  { data_type => "varchar", is_nullable => 1, size => 35 },
  "suppliers_reference_number",

  { data_type => "varchar", is_nullable => 1, size => 3 },
  "suppliers_report",
  { data_type => "mediumtext", is_nullable => 1 },
  "replacementprice",
  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
);

=head1 PRIMARY KEY

    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "SET NULL",
    on_update     => "SET NULL",
  },
);


__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y7OfxpCVrDFw2JQU4SErew

sub koha_objects_class {
    'Koha::Acquisition::Orders';




=head2 frameworkcode

  data_type: 'varchar'
  is_nullable: 1
  is_nullable: 0
  size: 10

=head2 defaultvalue

  "kohafield",
  { data_type => "varchar", default_value => "", is_nullable => 1, size => 45 },
  "frameworkcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "defaultvalue",
  { data_type => "mediumtext", is_nullable => 1 },
);

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:htwTatj58OlWarcF1/9pSA


# You can replace this text with custom content, and it will be preserved on regeneration




  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 illrequests

Type: has_many

Related object: L<Koha::Schema::Result::Illrequest>

=cut

__PACKAGE__->has_many(
  "illrequests",
  "Koha::Schema::Result::Illrequest",
  { "foreign.status_alias" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKwmasD8ufV5zuXcklRE3A


# You can replace this text with custom code or comments, and it will be preserved on regeneration




=head2 category_name

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 32



__PACKAGE__->add_columns(
  "category_name",
  { data_type => "varchar", is_nullable => 0, size => 32 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mEZUVKQXHKTLVfXoeMHosw


# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 242-247 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Biblio.pm (-2 / +27 lines)
242	{ cascade_copy => 0, cascade_delete => 0 },	242	{ cascade_copy => 0, cascade_delete => 0 },
243	);	243	);
244		244
		245	=head2 oai_sets_biblios
		246
		247	Type: has_many
		248
		249	Related object: L<Koha::Schema::Result::OaiSetsBiblio>
		250
		251	=cut
		252
		253	__PACKAGE__->has_many(
		254	"oai_sets_biblios",
		255	"Koha::Schema::Result::OaiSetsBiblio",
		256	{ "foreign.biblionumber" => "self.biblionumber" },
		257	{ cascade_copy => 0, cascade_delete => 0 },
		258	);
		259
245	=head2 old_reserves	260	=head2 old_reserves
246		261
247	Type: has_many	262	Type: has_many
Lines 347-354 __PACKAGE__->has_many( Link Here
347	{ cascade_copy => 0, cascade_delete => 0 },	362	{ cascade_copy => 0, cascade_delete => 0 },
348	);	363	);
349		364
		365	=head2 sets
		366
		367	Type: many_to_many
		368
		369	Composing rels: L</oai_sets_biblios> -> set
		370
		371	=cut
		372
		373	__PACKAGE__->many_to_many("sets", "oai_sets_biblios", "set");
		374
350		375
351	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	376	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
352	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bUv00JjY09Hj2Zj4klqyxA	377	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:blPsfdnQ/MXZMBtIhnjKJg
353		378
354	1;	379	1;





=head2 state

  data_type: 'longtext'
  is_nullable: 1

=head2 zipcode

=head2 B_state

  accessor: 'b_state'
  data_type: 'longtext'
  is_nullable: 1

=head2 B_zipcode

  is_nullable: 1
  size: 100

=head2 ethnicity

  data_type: 'varchar'
  is_nullable: 1
  size: 50

=head2 ethnotes

  data_type: 'varchar'
  is_nullable: 1
  size: 255

=head2 sex

  data_type: 'varchar'


=head2 altcontactstate

  data_type: 'longtext'
  is_nullable: 1

=head2 altcontactzipcode

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 1

=head2 lastseen


=head2 login_attempts

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 overdrive_auth_token

  "city",
  { data_type => "longtext", is_nullable => 1 },
  "state",
  { data_type => "longtext", is_nullable => 1 },
  "zipcode",
  { data_type => "varchar", is_nullable => 1, size => 25 },
  "country",

  "B_city",
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
  "B_state",
  { accessor => "b_state", data_type => "longtext", is_nullable => 1 },
  "B_zipcode",
  {
    accessor => "b_zipcode",

  { data_type => "longtext", is_nullable => 1 },
  "relationship",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "ethnicity",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "ethnotes",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "sex",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "password",

  "altcontactaddress3",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "altcontactstate",
  { data_type => "longtext", is_nullable => 1 },
  "altcontactzipcode",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "altcontactcountry",

    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 1,
  },
  "lastseen",
  {

    size => 25,
  },
  "login_attempts",
  { data_type => "integer", is_nullable => 1 },
  "overdrive_auth_token",
  { data_type => "mediumtext", is_nullable => 1 },
);


__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);

=head2 C<userid>

=over 4

=item * L</userid>

=back

=cut

__PACKAGE__->add_unique_constraint("userid", ["userid"]);

=head1 RELATIONS

=head2 accountlines

__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kjQnCBqkdXvkJl4NeA+rgQ

__PACKAGE__->belongs_to(
    "guarantor",

Lines 48-53 __PACKAGE__->table("borrower_attributes"); Link Here

(-)a/Koha/Schema/Result/BorrowerAttribute.pm (-2 / +10 lines)
48	is_nullable: 1	48	is_nullable: 1
49	size: 255	49	size: 255
50		50
		51	=head2 password
		52
		53	data_type: 'varchar'
		54	is_nullable: 1
		55	size: 64
		56
51	=cut	57	=cut
52		58
53	__PACKAGE__->add_columns(	59	__PACKAGE__->add_columns(
Lines 59-64 __PACKAGE__->add_columns( Link Here
59	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },	65	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 10 },
60	"attribute",	66	"attribute",
61	{ data_type => "varchar", is_nullable => 1, size => 255 },	67	{ data_type => "varchar", is_nullable => 1, size => 255 },
		68	"password",
		69	{ data_type => "varchar", is_nullable => 1, size => 64 },
62	);	70	);
63		71
64	=head1 PRIMARY KEY	72	=head1 PRIMARY KEY
Lines 106-113 __PACKAGE__->belongs_to( Link Here
106	);	114	);
107		115
108		116
109	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-12-08 04:41:27	117	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
110	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EarETnedFsmRmAAJAUrKGg	118	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0mr7/SGK5wcxA3/hNok5Gg
111		119
112		120
113	# You can replace this text with custom content, and it will be preserved on regeneration	121	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 59-64 __PACKAGE__->table("borrower_attribute_types"); Link Here

(-)a/Koha/Schema/Result/BorrowerAttributeType.pm (-3 / +32 lines)
59	default_value: 0	59	default_value: 0
60	is_nullable: 0	60	is_nullable: 0
61		61
		62	=head2 password_allowed
		63
		64	data_type: 'tinyint'
		65	default_value: 0
		66	is_nullable: 0
		67
62	=head2 staff_searchable	68	=head2 staff_searchable
63		69
64	data_type: 'tinyint'	70	data_type: 'tinyint'
Lines 80-85 __PACKAGE__->table("borrower_attribute_types"); Link Here
80	=head2 category_code	86	=head2 category_code
81		87
82	data_type: 'varchar'	88	data_type: 'varchar'
		89	is_foreign_key: 1
83	is_nullable: 1	90	is_nullable: 1
84	size: 10	91	size: 10
85		92
Lines 105-110 __PACKAGE__->add_columns( Link Here
105	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	112	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
106	"opac_editable",	113	"opac_editable",
107	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	114	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		115	"password_allowed",
		116	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
108	"staff_searchable",	117	"staff_searchable",
109	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	118	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
110	"authorised_value_category",	119	"authorised_value_category",
Lines 112-118 __PACKAGE__->add_columns( Link Here
112	"display_checkout",	121	"display_checkout",
113	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	122	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
114	"category_code",	123	"category_code",
115	{ data_type => "varchar", is_nullable => 1, size => 10 },	124	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
116	"class",	125	"class",
117	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },	126	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
118	);	127	);
Lines 161-169 __PACKAGE__->has_many( Link Here
161	{ cascade_copy => 0, cascade_delete => 0 },	170	{ cascade_copy => 0, cascade_delete => 0 },
162	);	171	);
163		172
		173	=head2 category_code
		174
		175	Type: belongs_to
		176
		177	Related object: L<Koha::Schema::Result::Category>
		178
		179	=cut
		180
		181	__PACKAGE__->belongs_to(
		182	"category_code",
		183	"Koha::Schema::Result::Category",
		184	{ categorycode => "category_code" },
		185	{
		186	is_deferrable => 1,
		187	join_type => "LEFT",
		188	on_delete => "RESTRICT",
		189	on_update => "RESTRICT",
		190	},
		191	);
		192
164		193
165	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-25 20:32:12	194	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
166	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gsPR8PuUUZHFUkr3MIbTpw	195	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c2Iz8s/2wOnRUAeMdx8Dag
167		196
168		197
169	# You can replace this text with custom content, and it will be preserved on regeneration	198	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 301-306 __PACKAGE__->table("borrower_modifications"); Link Here

(-)a/Koha/Schema/Result/BorrowerModification.pm (-2 / +18 lines)
301	is_nullable: 1	301	is_nullable: 1
302	size: 100	302	size: 100
303		303
		304	=head2 ethnicity
		305
		306	data_type: 'varchar'
		307	is_nullable: 1
		308	size: 50
		309
		310	=head2 ethnotes
		311
		312	data_type: 'varchar'
		313	is_nullable: 1
		314	size: 255
		315
304	=head2 sex	316	=head2 sex
305		317
306	data_type: 'varchar'	318	data_type: 'varchar'
Lines 547-552 __PACKAGE__->add_columns( Link Here
547	{ data_type => "longtext", is_nullable => 1 },	559	{ data_type => "longtext", is_nullable => 1 },
548	"relationship",	560	"relationship",
549	{ data_type => "varchar", is_nullable => 1, size => 100 },	561	{ data_type => "varchar", is_nullable => 1, size => 100 },
		562	"ethnicity",
		563	{ data_type => "varchar", is_nullable => 1, size => 50 },
		564	"ethnotes",
		565	{ data_type => "varchar", is_nullable => 1, size => 255 },
550	"sex",	566	"sex",
551	{ data_type => "varchar", is_nullable => 1, size => 1 },	567	{ data_type => "varchar", is_nullable => 1, size => 1 },
552	"password",	568	"password",
Lines 610-617 __PACKAGE__->add_columns( Link Here
610	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");	626	__PACKAGE__->set_primary_key("verification_token", "borrowernumber");
611		627
612		628
613	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-20 13:00:20	629	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
614	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qQ0BWngri+79YvK9S8zZPg	630	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ejtbPFBzRooWpYI6cFZoHg
615		631
616		632
617	# You can replace this text with custom content, and it will be preserved on regeneration	633	# You can replace this text with custom content, and it will be preserved on regeneration




  default_value: 0
  is_nullable: 0

=head2 illlimit

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

=head2 category_type

  data_type: 'varchar'

  is_nullable: 0
  size: 1

=head2 BlockExpiredPatronOpacActions

  accessor: 'block_expired_patron_opac_actions'
  data_type: 'tinyint'
  default_value: -1
  is_nullable: 0

=head2 default_privacy

  data_type: 'enum'

  is_nullable: 0
  size: 7

=head2 BlockExpiredPatronOpacActions

  accessor: 'block_expired_patron_opac_actions'
  data_type: 'tinyint'
  default_value: -1
  is_nullable: 0

=cut

__PACKAGE__->add_columns(

  { data_type => "decimal", is_nullable => 1, size => [28, 6] },
  "hidelostitems",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "illlimit",
  { data_type => "smallint", default_value => 0, is_nullable => 1 },
  "category_type",
  { data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
  "BlockExpiredPatronOpacActions",
  {
    accessor      => "block_expired_patron_opac_actions",
    data_type     => "tinyint",
    default_value => -1,
    is_nullable   => 0,
  },
  "default_privacy",
  {
    data_type => "enum",

    is_nullable => 0,
    size => 7,
  },
  "BlockExpiredPatronOpacActions",
  {
    accessor      => "block_expired_patron_opac_actions",
    data_type     => "tinyint",
    default_value => -1,
    is_nullable   => 0,
  },
);

=head1 PRIMARY KEY


=head1 RELATIONS

=head2 borrower_attribute_types

Type: has_many

Related object: L<Koha::Schema::Result::BorrowerAttributeType>

=cut

__PACKAGE__->has_many(
  "borrower_attribute_types",
  "Koha::Schema::Result::BorrowerAttributeType",
  { "foreign.category_code" => "self.categorycode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 borrower_message_preferences

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L6F4lG7nQiXzCz5Eee0mtw


# You can replace this text with custom content, and it will be preserved on regeneration




  is_nullable: 1
  size: 100

=head2 city_zipcode

  data_type: 'varchar'
  is_nullable: 1
  size: 20

=head2 city_country

  data_type: 'varchar'
  is_nullable: 1
  size: 100

=cut


  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
  "city_state",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "city_country",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "city_zipcode",
  { data_type => "varchar", is_nullable => 1, size => 20 },
  "city_country",
  { data_type => "varchar", is_nullable => 1, size => 100 },
);

=head1 PRIMARY KEY

__PACKAGE__->set_primary_key("cityid");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aOIpsiZF15Qzurb4NNUZZQ


# You can replace this text with custom content, and it will be preserved on regeneration





=head2 holdallowed

  data_type: 'tinyint'
  is_nullable: 1

=head2 hold_fulfillment_policy

  "maxonsiteissueqty",
  { data_type => "integer", is_nullable => 1 },
  "holdallowed",
  { data_type => "tinyint", is_nullable => 1 },
  "hold_fulfillment_policy",
  {
    data_type => "enum",

__PACKAGE__->set_primary_key("singleton");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ttOioXaCXJKF52QQcOUlOQ


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 biblionumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 frameworkcode


__PACKAGE__->add_columns(
  "biblionumber",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "frameworkcode",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
  "author",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xbFngDcDw22QzSI9NgqvtQ


# You can replace this text with custom content, and it will be preserved on regeneration





=head2 state

  data_type: 'longtext'
  is_nullable: 1

=head2 zipcode

=head2 B_state

  accessor: 'b_state'
  data_type: 'longtext'
  is_nullable: 1

=head2 B_zipcode

=head2 categorycode

  data_type: 'varchar'
  is_nullable: 1
  is_nullable: 0
  size: 10

=head2 dateenrolled

  is_nullable: 1
  size: 100

=head2 ethnicity

  data_type: 'varchar'
  is_nullable: 1
  size: 50

=head2 ethnotes

  data_type: 'varchar'
  is_nullable: 1
  size: 255

=head2 sex

  data_type: 'varchar'


=head2 altcontactstate

  data_type: 'longtext'
  is_nullable: 1

=head2 altcontactzipcode

=head2 privacy

  data_type: 'integer'
  is_nullable: 1
  is_nullable: 0

=head2 privacy_guarantor_checkouts


  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 1

=head2 lastseen


=head2 login_attempts

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 overdrive_auth_token

  "city",
  { data_type => "longtext", is_nullable => 1 },
  "state",
  { data_type => "longtext", is_nullable => 1 },
  "zipcode",
  { data_type => "varchar", is_nullable => 1, size => 25 },
  "country",

  "B_city",
  { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
  "B_state",
  { accessor => "b_state", data_type => "longtext", is_nullable => 1 },
  "B_zipcode",
  {
    accessor => "b_zipcode",

  "branchcode",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
  "categorycode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "dateenrolled",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "dateexpiry",

  { data_type => "longtext", is_nullable => 1 },
  "relationship",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "ethnicity",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "ethnotes",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "sex",
  { data_type => "varchar", is_nullable => 1, size => 1 },
  "password",

  "altcontactaddress3",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "altcontactstate",
  { data_type => "longtext", is_nullable => 1 },
  "altcontactzipcode",
  { data_type => "varchar", is_nullable => 1, size => 50 },
  "altcontactcountry",

  "sms_provider_id",
  { data_type => "integer", is_nullable => 1 },
  "privacy",
  { data_type => "integer", is_nullable => 1 },
  "privacy_guarantor_checkouts",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "checkprevcheckout",

    data_type => "timestamp",
    datetime_undef_if_invalid => 1,
    default_value => \"current_timestamp",
    is_nullable => 1,
  },
  "lastseen",
  {

    size => 25,
  },
  "login_attempts",
  { data_type => "integer", is_nullable => 1 },
  "overdrive_auth_token",
  { data_type => "mediumtext", is_nullable => 1 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BEq3IZzmy8La8NnwPCbV1Q


# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 276-281 __PACKAGE__->table("deleteditems"); Link Here

(-)a/Koha/Schema/Result/Deleteditem.pm (-2 / +18 lines)
276	is_nullable: 1	276	is_nullable: 1
277	size: 32	277	size: 32
278		278
		279	stores the inventory number of deleted items
		280
279	=head2 new_status	281	=head2 new_status
280		282
281	data_type: 'varchar'	283	data_type: 'varchar'
Lines 406-414 __PACKAGE__->add_columns( Link Here
406		408
407	__PACKAGE__->set_primary_key("itemnumber");	409	__PACKAGE__->set_primary_key("itemnumber");
408		410
		411	=head1 UNIQUE CONSTRAINTS
		412
		413	=head2 C<deleteditemsstocknumberidx>
		414
		415	=over 4
		416
		417	=item * L</stocknumber>
		418
		419	=back
		420
		421	=cut
		422
		423	__PACKAGE__->add_unique_constraint("deleteditemsstocknumberidx", ["stocknumber"]);
		424
409		425
410	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-09-26 16:15:09	426	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
411	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L7G0HG5gvgyhfpKb7LcUFw	427	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lvAfwRdG2uylRDO5dxJEdQ
412		428
413		429
414	# You can replace this text with custom content, and it will be preserved on regeneration	430	# You can replace this text with custom content, and it will be preserved on regeneration





=head1 RELATIONS

=head2 aqinvoices

Type: has_many

Related object: L<Koha::Schema::Result::Aqinvoice>

=cut

__PACKAGE__->has_many(
  "aqinvoices",
  "Koha::Schema::Result::Aqinvoice",
  { "foreign.message_id" => "self.id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 basketno

Type: belongs_to

  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "RESTRICT",
    on_update     => "RESTRICT",
  },
);


  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "RESTRICT",
    on_update     => "RESTRICT",
  },
);


  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "RESTRICT",
    on_update     => "RESTRICT",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f90XogVNxT1OZtN5s02KAQ


1;




use utf8;
package Koha::Schema::Result::Ethnicity;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::Ethnicity

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<ethnicity>

=cut

__PACKAGE__->table("ethnicity");

=head1 ACCESSORS

=head2 code

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 10

=head2 name

  data_type: 'varchar'
  is_nullable: 1
  size: 255

=cut

__PACKAGE__->add_columns(
  "code",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
  "name",
  { data_type => "varchar", is_nullable => 1, size => 255 },
);

=head1 PRIMARY KEY

=over 4

=item * L</code>

=back

=cut

__PACKAGE__->set_primary_key("code");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qu8cssBwlX7MIpoFZ6Xvlg


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;




use utf8;
package Koha::Schema::Result::Housebound;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::Housebound

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<housebound>

=cut

__PACKAGE__->table("housebound");

=head1 ACCESSORS

=head2 hbnumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 day

  data_type: 'mediumtext'
  is_nullable: 0

=head2 frequency

  data_type: 'mediumtext'
  is_nullable: 1

=head2 borrowernumber

  data_type: 'integer'
  is_nullable: 1

=head2 Itype_quant

  accessor: 'itype_quant'
  data_type: 'varchar'
  is_nullable: 1
  size: 10

=head2 Item_subject

  accessor: 'item_subject'
  data_type: 'mediumtext'
  is_nullable: 1

=head2 Item_authors

  accessor: 'item_authors'
  data_type: 'mediumtext'
  is_nullable: 1

=head2 referral

  data_type: 'mediumtext'
  is_nullable: 1

=head2 notes

  data_type: 'mediumtext'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "hbnumber",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "day",
  { data_type => "mediumtext", is_nullable => 0 },
  "frequency",
  { data_type => "mediumtext", is_nullable => 1 },
  "borrowernumber",
  { data_type => "integer", is_nullable => 1 },
  "Itype_quant",
  {
    accessor => "itype_quant",
    data_type => "varchar",
    is_nullable => 1,
    size => 10,
  },
  "Item_subject",
  { accessor => "item_subject", data_type => "mediumtext", is_nullable => 1 },
  "Item_authors",
  { accessor => "item_authors", data_type => "mediumtext", is_nullable => 1 },
  "referral",
  { data_type => "mediumtext", is_nullable => 1 },
  "notes",
  { data_type => "mediumtext", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</hbnumber>

=back

=cut

__PACKAGE__->set_primary_key("hbnumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KfWOT6B9V4lGTxfWOE+QTQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;




use utf8;
package Koha::Schema::Result::HouseboundInstance;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::HouseboundInstance

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<housebound_instance>

=cut

__PACKAGE__->table("housebound_instance");

=head1 ACCESSORS

=head2 instanceid

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 hbnumber

  data_type: 'integer'
  is_nullable: 0

=head2 dmy

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 time

  data_type: 'mediumtext'
  is_nullable: 1

=head2 borrowernumber

  data_type: 'integer'
  is_nullable: 0

=head2 volunteer

  data_type: 'integer'
  is_nullable: 1

=head2 chooser

  data_type: 'integer'
  is_nullable: 1

=head2 deliverer

  data_type: 'integer'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "instanceid",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "hbnumber",
  { data_type => "integer", is_nullable => 0 },
  "dmy",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "time",
  { data_type => "mediumtext", is_nullable => 1 },
  "borrowernumber",
  { data_type => "integer", is_nullable => 0 },
  "volunteer",
  { data_type => "integer", is_nullable => 1 },
  "chooser",
  { data_type => "integer", is_nullable => 1 },
  "deliverer",
  { data_type => "integer", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</instanceid>

=back

=cut

__PACKAGE__->set_primary_key("instanceid");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hi6YuuVAE9fKyyEi8DPhUA


# You can replace this text with custom code or comments, and it will be preserved on regeneration
1;

Lines 54-59 __PACKAGE__->table("illrequests"); Link Here

(-)a/Koha/Schema/Result/Illrequest.pm (-10 / +38 lines)
54	is_nullable: 1	54	is_nullable: 1
55	size: 50	55	size: 50
56		56
		57	=head2 status_alias
		58
		59	data_type: 'integer'
		60	is_foreign_key: 1
		61	is_nullable: 1
		62
57	=head2 placed	63	=head2 placed
58		64
59	data_type: 'date'	65	data_type: 'date'
Lines 97-108 __PACKAGE__->table("illrequests"); Link Here
97	is_nullable: 1	103	is_nullable: 1
98	size: 20	104	size: 20
99		105
100	=head2 price_paid
101
102	data_type: 'varchar'
103	is_nullable: 1
104	size: 20
105
106	=head2 notesopac	106	=head2 notesopac
107		107
108	data_type: 'mediumtext'	108	data_type: 'mediumtext'
Lines 125-130 __PACKAGE__->table("illrequests"); Link Here
125	is_nullable: 1	125	is_nullable: 1
126	size: 20	126	size: 20
127		127
		128	=head2 price_paid
		129
		130	data_type: 'varchar'
		131	is_nullable: 1
		132	size: 20
		133
128	=cut	134	=cut
129		135
130	__PACKAGE__->add_columns(	136	__PACKAGE__->add_columns(
Lines 143-148 __PACKAGE__->add_columns( Link Here
143	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },	149	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 0, size => 50 },
144	"status",	150	"status",
145	{ data_type => "varchar", is_nullable => 1, size => 50 },	151	{ data_type => "varchar", is_nullable => 1, size => 50 },
		152	"status_alias",
		153	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
146	"placed",	154	"placed",
147	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	155	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
148	"replied",	156	"replied",
Lines 162-169 __PACKAGE__->add_columns( Link Here
162	{ data_type => "varchar", is_nullable => 1, size => 500 },	170	{ data_type => "varchar", is_nullable => 1, size => 500 },
163	"cost",	171	"cost",
164	{ data_type => "varchar", is_nullable => 1, size => 20 },	172	{ data_type => "varchar", is_nullable => 1, size => 20 },
165	"price_paid",
166	{ data_type => "varchar", is_nullable => 1, size => 20 },
167	"notesopac",	173	"notesopac",
168	{ data_type => "mediumtext", is_nullable => 1 },	174	{ data_type => "mediumtext", is_nullable => 1 },
169	"notesstaff",	175	"notesstaff",
Lines 172-177 __PACKAGE__->add_columns( Link Here
172	{ data_type => "varchar", is_nullable => 1, size => 50 },	178	{ data_type => "varchar", is_nullable => 1, size => 50 },
173	"backend",	179	"backend",
174	{ data_type => "varchar", is_nullable => 1, size => 20 },	180	{ data_type => "varchar", is_nullable => 1, size => 20 },
		181	"price_paid",
		182	{ data_type => "varchar", is_nullable => 1, size => 20 },
175	);	183	);
176		184
177	=head1 PRIMARY KEY	185	=head1 PRIMARY KEY
Lines 253-261 __PACKAGE__->has_many( Link Here
253	{ cascade_copy => 0, cascade_delete => 0 },	261	{ cascade_copy => 0, cascade_delete => 0 },
254	);	262	);
255		263
		264	=head2 status_alias
		265
		266	Type: belongs_to
		267
		268	Related object: L<Koha::Schema::Result::AuthorisedValue>
		269
		270	=cut
		271
		272	__PACKAGE__->belongs_to(
		273	"status_alias",
		274	"Koha::Schema::Result::AuthorisedValue",
		275	{ id => "status_alias" },
		276	{
		277	is_deferrable => 1,
		278	join_type => "LEFT",
		279	on_delete => "SET NULL",
		280	on_update => "CASCADE",
		281	},
		282	);
		283
256		284
257	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48	285	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
258	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rv6QyhxEah2r/rDcz3aOOw	286	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kib9BcMRy/expyGSm9sMbQ
259		287
260		288
261	# You can replace this text with custom code or comments, and it will be preserved on regeneration	289	# You can replace this text with custom code or comments, and it will be preserved on regeneration




  extra: {list => ["batch","z3950","webservice"]}
  is_nullable: 0

=head2 record_type

  data_type: 'enum'
  default_value: 'biblio'
  extra: {list => ["biblio","auth","holdings"]}
  is_nullable: 0

=head2 file_name

  data_type: 'varchar'

  data_type: 'longtext'
  is_nullable: 1

=head2 record_type

  data_type: 'enum'
  default_value: 'biblio'
  extra: {list => ["biblio","auth","holdings"]}
  is_nullable: 0

=cut

__PACKAGE__->add_columns(

    extra => { list => ["batch", "z3950", "webservice"] },
    is_nullable => 0,
  },
  "file_name",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "comments",
  { data_type => "longtext", is_nullable => 1 },
  "record_type",
  {
    data_type => "enum",

    extra => { list => ["biblio", "auth", "holdings"] },
    is_nullable => 0,
  },
  "file_name",
  { data_type => "varchar", is_nullable => 1, size => 100 },
  "comments",
  { data_type => "longtext", is_nullable => 1 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QuFcB7fNnk3jCFKgi8m7fg


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 date_due


  "issue_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "borrowernumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "itemnumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "date_due",
  {
    data_type => "datetime",

  "borrowernumber",
  "Koha::Schema::Result::Borrower",
  { borrowernumber => "borrowernumber" },
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "RESTRICT",
    on_update     => "CASCADE",
  },
);

=head2 itemnumber

  "itemnumber",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "RESTRICT",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AauWRMNJsFZYKjUkeqtycg

__PACKAGE__->belongs_to(
    "borrower",

Lines 150-161 __PACKAGE__->table("items"); Link Here

(-)a/Koha/Schema/Result/Item.pm (-25 / +12 lines)
150	is_nullable: 1	150	is_nullable: 1
151	size: 255	151	size: 255
152		152
153	=head2 coded_location_qualifier
154
155	data_type: 'varchar'
156	is_nullable: 1
157	size: 10
158
159	=head2 issues	153	=head2 issues
160		154
161	data_type: 'smallint'	155	data_type: 'smallint'
Lines 280-291 __PACKAGE__->table("items"); Link Here
280	is_nullable: 1	274	is_nullable: 1
281	size: 32	275	size: 32
282		276
		277	stores the inventory number
		278
283	=head2 new_status	279	=head2 new_status
284		280
285	data_type: 'varchar'	281	data_type: 'varchar'
286	is_nullable: 1	282	is_nullable: 1
287	size: 32	283	size: 32
288		284
		285	=head2 coded_location_qualifier
		286
		287	data_type: 'varchar'
		288	is_nullable: 1
		289	size: 10
		290
289	=cut	291	=cut
290		292
291	__PACKAGE__->add_columns(	293	__PACKAGE__->add_columns(
Lines 353-360 __PACKAGE__->add_columns( Link Here
353	},	355	},
354	"itemcallnumber",	356	"itemcallnumber",
355	{ data_type => "varchar", is_nullable => 1, size => 255 },	357	{ data_type => "varchar", is_nullable => 1, size => 255 },
356	"coded_location_qualifier",
357	{ data_type => "varchar", is_nullable => 1, size => 10 },
358	"issues",	358	"issues",
359	{ data_type => "smallint", is_nullable => 1 },	359	{ data_type => "smallint", is_nullable => 1 },
360	"renewals",	360	"renewals",
Lines 406-411 __PACKAGE__->add_columns( Link Here
406	{ data_type => "varchar", is_nullable => 1, size => 32 },	406	{ data_type => "varchar", is_nullable => 1, size => 32 },
407	"new_status",	407	"new_status",
408	{ data_type => "varchar", is_nullable => 1, size => 32 },	408	{ data_type => "varchar", is_nullable => 1, size => 32 },
		409	"coded_location_qualifier",
		410	{ data_type => "varchar", is_nullable => 1, size => 10 },
409	);	411	);
410		412
411	=head1 PRIMARY KEY	413	=head1 PRIMARY KEY
Lines 671-691 __PACKAGE__->has_many( Link Here
671	{ cascade_copy => 0, cascade_delete => 0 },	673	{ cascade_copy => 0, cascade_delete => 0 },
672	);	674	);
673		675
674	=head2 serialitem
675
676	Type: might_have
677
678	Related object: L<Koha::Schema::Result::Serialitem>
679
680	=cut
681
682	__PACKAGE__->might_have(
683	"serialitem",
684	"Koha::Schema::Result::Serialitem",
685	{ "foreign.itemnumber" => "self.itemnumber" },
686	{ cascade_copy => 0, cascade_delete => 0 },
687	);
688
689	=head2 stockrotationitem	676	=head2 stockrotationitem
690		677
691	Type: might_have	678	Type: might_have
Lines 702-709 __PACKAGE__->might_have( Link Here
702	);	689	);
703		690
704		691
705	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-09 15:50:42	692	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
706	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:PQvA8qoxvTe4In5/oa5WIQ	693	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yCRbfTRcR9gxcdNqyOxNpg
707		694
708	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );	695	__PACKAGE__->belongs_to( biblioitem => "Koha::Schema::Result::Biblioitem", "biblioitemnumber" );
709		696




  "message_transport_type",
  "Koha::Schema::Result::MessageTransportType",
  { message_transport_type => "message_transport_type" },
  { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XDq2o0wNUEkPuLtfPZiomA


# You can replace this text with custom content, and it will be preserved on regeneration





  data_type: 'enum'
  extra: {list => ["delete_field","add_field","update_field","move_field","copy_field","copy_and_replace_field"]}
  is_nullable: 1

=head2 field_number


        "copy_and_replace_field",
      ],
    },
    is_nullable => 1,
  },
  "field_number",
  { data_type => "smallint", default_value => 0, is_nullable => 0 },

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l5ezpD4DzfzsLV+WhOYpAQ


# You can replace this text with custom code or comments, and it will be preserved on regeneration




=head2 message_name

  data_type: 'varchar'
  is_nullable: 1
  is_nullable: 0
  size: 40

=head2 takes_days

  "message_attribute_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "message_name",
  { data_type => "varchar", is_nullable => 1, size => 40 },
  "takes_days",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0UOXJDFio/WUDUbc67P1WQ


# You can replace this text with custom content, and it will be preserved on regeneration

Lines 44-49 __PACKAGE__->table("need_merge_authorities"); Link Here

(-)a/Koha/Schema/Result/NeedMergeAuthority.pm (-10 / +10 lines)
44	data_type: 'mediumtext'	44	data_type: 'mediumtext'
45	is_nullable: 1	45	is_nullable: 1
46		46
		47	=head2 done
		48
		49	data_type: 'tinyint'
		50	default_value: 0
		51	is_nullable: 1
		52
47	=head2 timestamp	53	=head2 timestamp
48		54
49	data_type: 'timestamp'	55	data_type: 'timestamp'
Lines 51-62 __PACKAGE__->table("need_merge_authorities"); Link Here
51	default_value: current_timestamp	57	default_value: current_timestamp
52	is_nullable: 0	58	is_nullable: 0
53		59
54	=head2 done
55
56	data_type: 'tinyint'
57	default_value: 0
58	is_nullable: 1
59
60	=cut	60	=cut
61		61
62	__PACKAGE__->add_columns(	62	__PACKAGE__->add_columns(
Lines 68-73 __PACKAGE__->add_columns( Link Here
68	{ data_type => "bigint", is_nullable => 1 },	68	{ data_type => "bigint", is_nullable => 1 },
69	"reportxml",	69	"reportxml",
70	{ data_type => "mediumtext", is_nullable => 1 },	70	{ data_type => "mediumtext", is_nullable => 1 },
		71	"done",
		72	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },
71	"timestamp",	73	"timestamp",
72	{	74	{
73	data_type => "timestamp",	75	data_type => "timestamp",
Lines 75-82 __PACKAGE__->add_columns( Link Here
75	default_value => \"current_timestamp",	77	default_value => \"current_timestamp",
76	is_nullable => 0,	78	is_nullable => 0,
77	},	79	},
78	"done",
79	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },
80	);	80	);
81		81
82	=head1 PRIMARY KEY	82	=head1 PRIMARY KEY
Lines 92-99 __PACKAGE__->add_columns( Link Here
92	__PACKAGE__->set_primary_key("id");	92	__PACKAGE__->set_primary_key("id");
93		93
94		94
95	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	95	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
96	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7LzwIYvExKvNgr8/HDZlsg	96	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/QuLsg1gd9kWNnugkDmSBA
97		97
98		98
99	# You can replace this text with custom content, and it will be preserved on regeneration	99	# You can replace this text with custom content, and it will be preserved on regeneration




  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 biblionumbers

Type: many_to_many

Composing rels: L</oai_sets_biblios> -> biblionumber

=cut

__PACKAGE__->many_to_many("biblionumbers", "oai_sets_biblios", "biblionumber");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7zp9hrwat3SmXgRedYcXgQ


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 biblionumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 set_id


__PACKAGE__->add_columns(
  "biblionumber",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
  "set_id",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
);


=head1 RELATIONS

=head2 biblionumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Biblio>

=cut

__PACKAGE__->belongs_to(
  "biblionumber",
  "Koha::Schema::Result::Biblio",
  { biblionumber => "biblionumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 set

Type: belongs_to

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X8R6Odd2qZpvrY09Z3LOhw


# You can replace this text with custom content, and it will be preserved on regeneration




  is_nullable: 0
  size: 1

=head2 operator

  data_type: 'varchar'
  default_value: 'equal'
  is_nullable: 0
  size: 8

=head2 marcvalue

  data_type: 'varchar'

  { data_type => "char", is_nullable => 0, size => 3 },
  "marcsubfield",
  { data_type => "char", is_nullable => 0, size => 1 },
  "operator",
  {
    data_type => "varchar",
    default_value => "equal",
    is_nullable => 0,
    size => 8,
  },
  "marcvalue",
  { data_type => "varchar", is_nullable => 0, size => 80 },
);

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ISJose/oSjtuVo3EXLzPxA


# You can replace this text with custom content, and it will be preserved on regeneration




  {
    is_deferrable => 1,
    join_type     => "LEFT",
    on_delete     => "CASCADE",
    on_update     => "CASCADE",
  },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VFAvF0fzXCBuzgK+hE3eHA


# You can replace this text with custom content, and it will be preserved on regeneration

Lines 26-31 __PACKAGE__->table("patronimage"); Link Here

(-)a/Koha/Schema/Result/Patronimage.pm (-3 / +9 lines)
26	=head2 borrowernumber	26	=head2 borrowernumber
27		27
28	data_type: 'integer'	28	data_type: 'integer'
		29	default_value: 0
29	is_foreign_key: 1	30	is_foreign_key: 1
30	is_nullable: 0	31	is_nullable: 0
31		32
Lines 44-50 __PACKAGE__->table("patronimage"); Link Here
44		45
45	__PACKAGE__->add_columns(	46	__PACKAGE__->add_columns(
46	"borrowernumber",	47	"borrowernumber",
47	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },	48	{
		49	data_type => "integer",
		50	default_value => 0,
		51	is_foreign_key => 1,
		52	is_nullable => 0,
		53	},
48	"mimetype",	54	"mimetype",
49	{ data_type => "varchar", is_nullable => 0, size => 15 },	55	{ data_type => "varchar", is_nullable => 0, size => 15 },
50	"imagefile",	56	"imagefile",
Lines 81-88 __PACKAGE__->belongs_to( Link Here
81	);	87	);
82		88
83		89
84	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	90	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
85	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uuRGyWlemwOH1PCkvhqxdQ	91	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FlZ4R0S51TTSASvOPzqmrg
86		92
87		93
88	# You can replace this text with custom content, and it will be preserved on regeneration	94	# You can replace this text with custom content, and it will be preserved on regeneration




=head2 itemnumber

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=head2 serialid


__PACKAGE__->add_columns(
  "itemnumber",
  { data_type => "integer", is_nullable => 0 },
  "serialid",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
);


=head1 RELATIONS

=head2 itemnumber

Type: belongs_to

Related object: L<Koha::Schema::Result::Item>

=cut

__PACKAGE__->belongs_to(
  "itemnumber",
  "Koha::Schema::Result::Item",
  { itemnumber => "itemnumber" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 serialid

Type: belongs_to

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qAF0pJF5e8AJzxaZqlg13w


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 a_session

  data_type: 'longtext'
  is_nullable: 1

=cut


  "id",
  { data_type => "varchar", is_nullable => 0, size => 32 },
  "a_session",
  { data_type => "longtext", is_nullable => 1 },
);

=head1 PRIMARY KEY

__PACKAGE__->set_primary_key("id");


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Y/66MvcHQG0Urlv4Q+7ItQ


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 description

  data_type: 'text'
  is_nullable: 1

=head2 cyclical


  "title",
  { data_type => "varchar", is_nullable => 0, size => 100 },
  "description",
  { data_type => "text", is_nullable => 1 },
  "cyclical",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "active",


__PACKAGE__->set_primary_key("rota_id");

=head1 UNIQUE CONSTRAINTS

=head2 C<stockrotationrotas_title>

=over 4

=item * L</title>

=back

=cut

__PACKAGE__->add_unique_constraint("stockrotationrotas_title", ["title"]);

=head1 RELATIONS

=head2 stockrotationstages

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HrZO2r+/Warg22jZTBH6YQ

__PACKAGE__->add_columns(
  '+cyclical' => { is_boolean => 1 },




  data_type: 'integer'
  is_nullable: 1

=head2 lastvalue2

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 innerloop1

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 innerloop2

  default_value: 0
  is_nullable: 1

=head2 innerloop3

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 lastvalue3

  data_type: 'integer'
  default_value: 0
  is_nullable: 1

=head2 firstacquidate

  { data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
  "lastvalue1",
  { data_type => "integer", is_nullable => 1 },
  "innerloop1",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "lastvalue2",
  { data_type => "integer", is_nullable => 1 },
  "innerloop1",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "innerloop2",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "lastvalue3",
  { data_type => "integer", is_nullable => 1 },
  "innerloop3",
  { data_type => "integer", default_value => 0, is_nullable => 1 },
  "lastvalue3",
  { data_type => "integer", is_nullable => 1 },
  "firstacquidate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "manualhistory",

  },
);

=head2 subscriptionroutinglists

Type: has_many

Related object: L<Koha::Schema::Result::Subscriptionroutinglist>

=cut

__PACKAGE__->has_many(
  "subscriptionroutinglists",
  "Koha::Schema::Result::Subscriptionroutinglist",
  { "foreign.subscriptionid" => "self.subscriptionid" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YEnhBEHShtX7EOGZ72E3tg


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 subscriptionid

  data_type: 'integer'
  is_foreign_key: 1
  is_nullable: 0

=cut

  "ranking",
  { data_type => "integer", is_nullable => 1 },
  "subscriptionid",
  { data_type => "integer", is_nullable => 0 },
);

=head1 PRIMARY KEY

  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);

=head2 subscriptionid

Type: belongs_to

Related object: L<Koha::Schema::Result::Subscription>

=cut

__PACKAGE__->belongs_to(
  "subscriptionid",
  "Koha::Schema::Result::Subscription",
  { subscriptionid => "subscriptionid" },
  { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AWnpmHLU+knqkuZiPbiWxQ


# You can replace this text with custom content, and it will be preserved on regeneration




  default_value: 0
  is_nullable: 0

=head2 suggesteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 0

=head2 managedby

  data_type: 'integer'
  is_nullable: 1

=head2 manageddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 acceptedby

  data_type: 'integer'
  is_nullable: 1

=head2 accepteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 rejectedby

  data_type: 'integer'
  is_nullable: 1

=head2 rejecteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 STATUS

  accessor: 'status'

  is_nullable: 1
  size: 10

=head2 acceptedby

  data_type: 'integer'
  is_nullable: 1

=head2 accepteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 suggesteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 0

=head2 manageddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 rejectedby

  data_type: 'integer'
  is_nullable: 1

=head2 rejecteddate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

=head2 collectiontitle

  data_type: 'mediumtext'

  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "suggestedby",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "suggesteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
  "managedby",
  { data_type => "integer", is_nullable => 1 },
  "manageddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "acceptedby",
  { data_type => "integer", is_nullable => 1 },
  "accepteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "rejectedby",
  { data_type => "integer", is_nullable => 1 },
  "rejecteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "STATUS",
  {
    accessor => "status",

  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "branchcode",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "acceptedby",
  { data_type => "integer", is_nullable => 1 },
  "accepteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "suggesteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
  "manageddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "rejectedby",
  { data_type => "integer", is_nullable => 1 },
  "rejecteddate",
  { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
  "collectiontitle",
  { data_type => "mediumtext", is_nullable => 1 },
  "itemtype",

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9ovjDSyWFUtxt4qShR1RiA


# You can replace this text with custom content, and it will be preserved on regeneration




=head2 plugin

  data_type: 'varchar'
  default_value: (empty string)
  is_nullable: 0
  size: 256


  "shipment_budget",
  { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  "plugin",
  { data_type => "varchar", is_nullable => 0, size => 256 },
);

=head1 PRIMARY KEY

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QPYU9DYwSAyCFB99vrAMzA


# You can replace this text with custom code or comments, and it will be preserved on regeneration
- 

Return to bug 20581

Lines 66-72 __PACKAGE__->table("aqbasketgroups"); Link Here

(-)a/Koha/Schema/Result/Aqbasketgroup.pm (-4 / +4 lines)
66	=head2 billingplace	66	=head2 billingplace
67		67
68	data_type: 'varchar'	68	data_type: 'varchar'
69	is_nullable: 1	69	is_nullable: 0
70	size: 10	70	size: 10
71		71
72	=cut	72	=cut
Lines 87-93 __PACKAGE__->add_columns( Link Here
87	"deliverycomment",	87	"deliverycomment",
88	{ data_type => "varchar", is_nullable => 1, size => 255 },	88	{ data_type => "varchar", is_nullable => 1, size => 255 },
89	"billingplace",	89	"billingplace",
90	{ data_type => "varchar", is_nullable => 1, size => 10 },	90	{ data_type => "varchar", is_nullable => 0, size => 10 },
91	);	91	);
92		92
93	=head1 PRIMARY KEY	93	=head1 PRIMARY KEY
Lines 135-142 __PACKAGE__->belongs_to( Link Here
135	);	135	);
136		136
137		137
138	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	138	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
139	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9cEWAMwcFKPYPEG1CaaD3w	139	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LE9jdrqhTciPR6UG+PnIXQ
140		140
141		141
142	# You can replace this text with custom content, and it will be preserved on regeneration	142	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 73-80 __PACKAGE__->table("aqbooksellers"); Link Here

(-)a/Koha/Schema/Result/Aqbookseller.pm (-13 / +12 lines)
73	=head2 currency	73	=head2 currency
74		74
75	data_type: 'varchar'	75	data_type: 'varchar'
76	default_value: (empty string)	76	is_nullable: 1
77	is_nullable: 0
78	size: 10	77	size: 10
79		78
80	=head2 booksellerfax	79	=head2 booksellerfax
Lines 142-153 __PACKAGE__->table("aqbooksellers"); Link Here
142	data_type: 'tinyint'	141	data_type: 'tinyint'
143	is_nullable: 1	142	is_nullable: 1
144		143
145	=head2 tax_rate
146
147	data_type: 'decimal'
148	is_nullable: 1
149	size: [6,4]
150
151	=head2 discount	144	=head2 discount
152		145
153	data_type: 'float'	146	data_type: 'float'
Lines 160-165 __PACKAGE__->table("aqbooksellers"); Link Here
160	is_nullable: 1	153	is_nullable: 1
161	size: 50	154	size: 50
162		155
		156	=head2 tax_rate
		157
		158	data_type: 'decimal'
		159	is_nullable: 1
		160	size: [6,4]
		161
163	=head2 deliverytime	162	=head2 deliverytime
164		163
165	data_type: 'integer'	164	data_type: 'integer'
Lines 187-193 __PACKAGE__->add_columns( Link Here
187	"othersupplier",	186	"othersupplier",
188	{ data_type => "longtext", is_nullable => 1 },	187	{ data_type => "longtext", is_nullable => 1 },
189	"currency",	188	"currency",
190	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },	189	{ data_type => "varchar", is_nullable => 1, size => 10 },
191	"booksellerfax",	190	"booksellerfax",
192	{ data_type => "longtext", is_nullable => 1 },	191	{ data_type => "longtext", is_nullable => 1 },
193	"notes",	192	"notes",
Lines 212-223 __PACKAGE__->add_columns( Link Here
212	{ data_type => "tinyint", is_nullable => 1 },	211	{ data_type => "tinyint", is_nullable => 1 },
213	"invoiceincgst",	212	"invoiceincgst",
214	{ data_type => "tinyint", is_nullable => 1 },	213	{ data_type => "tinyint", is_nullable => 1 },
215	"tax_rate",
216	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },
217	"discount",	214	"discount",
218	{ data_type => "float", is_nullable => 1, size => [6, 4] },	215	{ data_type => "float", is_nullable => 1, size => [6, 4] },
219	"fax",	216	"fax",
220	{ data_type => "varchar", is_nullable => 1, size => 50 },	217	{ data_type => "varchar", is_nullable => 1, size => 50 },
		218	"tax_rate",
		219	{ data_type => "decimal", is_nullable => 1, size => [6, 4] },
221	"deliverytime",	220	"deliverytime",
222	{ data_type => "integer", is_nullable => 1 },	221	{ data_type => "integer", is_nullable => 1 },
223	);	222	);
Lines 382-389 __PACKAGE__->has_many( Link Here
382	);	381	);
383		382
384		383
385	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	384	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
386	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DyaF9RbcNAOjPQ1lrxHV3A	385	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i1MBNQ/K1Rh4wMZDnFCEzw
387		386
388	__PACKAGE__->add_columns(	387	__PACKAGE__->add_columns(
389	'+active' => { is_boolean => 1 },	388	'+active' => { is_boolean => 1 },

Lines 23-44 __PACKAGE__->table("aqbudgets"); Link Here

(-)a/Koha/Schema/Result/Aqbudget.pm (-30 / +51 lines)
23		23
24	=head1 ACCESSORS	24	=head1 ACCESSORS
25		25
		26	=head2 budget_code
		27
		28	data_type: 'varchar'
		29	is_nullable: 1
		30	size: 30
		31
		32	=head2 budget_amount
		33
		34	data_type: 'decimal'
		35	default_value: 0.000000
		36	is_nullable: 0
		37	size: [28,6]
		38
26	=head2 budget_id	39	=head2 budget_id
27		40
28	data_type: 'integer'	41	data_type: 'integer'
29	is_auto_increment: 1	42	is_auto_increment: 1
30	is_nullable: 0	43	is_nullable: 0
31		44
32	=head2 budget_parent_id	45	=head2 budget_branchcode
33		46
34	data_type: 'integer'	47	data_type: 'varchar'
35	is_nullable: 1	48	is_nullable: 1
		49	size: 10
36		50
37	=head2 budget_code	51	=head2 budget_parent_id
38		52
39	data_type: 'varchar'	53	data_type: 'integer'
40	is_nullable: 1	54	is_nullable: 1
41	size: 30
42		55
43	=head2 budget_name	56	=head2 budget_name
44		57
Lines 46-64 __PACKAGE__->table("aqbudgets"); Link Here
46	is_nullable: 1	59	is_nullable: 1
47	size: 80	60	size: 80
48		61
49	=head2 budget_branchcode
50
51	data_type: 'varchar'
52	is_nullable: 1
53	size: 10
54
55	=head2 budget_amount
56
57	data_type: 'decimal'
58	default_value: 0.000000
59	is_nullable: 1
60	size: [28,6]
61
62	=head2 budget_encumb	62	=head2 budget_encumb
63		63
64	data_type: 'decimal'	64	data_type: 'decimal'
Lines 88-93 __PACKAGE__->table("aqbudgets"); Link Here
88	=head2 budget_period_id	88	=head2 budget_period_id
89		89
90	data_type: 'integer'	90	data_type: 'integer'
		91	is_foreign_key: 1
91	is_nullable: 1	92	is_nullable: 1
92		93
93	=head2 sort1_authcat	94	=head2 sort1_authcat
Lines 116-138 __PACKAGE__->table("aqbudgets"); Link Here
116	=cut	117	=cut
117		118
118	__PACKAGE__->add_columns(	119	__PACKAGE__->add_columns(
119	"budget_id",
120	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
121	"budget_parent_id",
122	{ data_type => "integer", is_nullable => 1 },
123	"budget_code",	120	"budget_code",
124	{ data_type => "varchar", is_nullable => 1, size => 30 },	121	{ data_type => "varchar", is_nullable => 1, size => 30 },
125	"budget_name",
126	{ data_type => "varchar", is_nullable => 1, size => 80 },
127	"budget_branchcode",
128	{ data_type => "varchar", is_nullable => 1, size => 10 },
129	"budget_amount",	122	"budget_amount",
130	{	123	{
131	data_type => "decimal",	124	data_type => "decimal",
132	default_value => "0.000000",	125	default_value => "0.000000",
133	is_nullable => 1,	126	is_nullable => 0,
134	size => [28, 6],	127	size => [28, 6],
135	},	128	},
		129	"budget_id",
		130	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
		131	"budget_branchcode",
		132	{ data_type => "varchar", is_nullable => 1, size => 10 },
		133	"budget_parent_id",
		134	{ data_type => "integer", is_nullable => 1 },
		135	"budget_name",
		136	{ data_type => "varchar", is_nullable => 1, size => 80 },
136	"budget_encumb",	137	"budget_encumb",
137	{	138	{
138	data_type => "decimal",	139	data_type => "decimal",
Lines 157-163 __PACKAGE__->add_columns( Link Here
157	is_nullable => 0,	158	is_nullable => 0,
158	},	159	},
159	"budget_period_id",	160	"budget_period_id",
160	{ data_type => "integer", is_nullable => 1 },	161	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
161	"sort1_authcat",	162	"sort1_authcat",
162	{ data_type => "varchar", is_nullable => 1, size => 80 },	163	{ data_type => "varchar", is_nullable => 1, size => 80 },
163	"sort2_authcat",	164	"sort2_authcat",
Lines 257-262 __PACKAGE__->has_many( Link Here
257	{ cascade_copy => 0, cascade_delete => 0 },	258	{ cascade_copy => 0, cascade_delete => 0 },
258	);	259	);
259		260
		261	=head2 budget_period
		262
		263	Type: belongs_to
		264
		265	Related object: L<Koha::Schema::Result::Aqbudgetperiod>
		266
		267	=cut
		268
		269	__PACKAGE__->belongs_to(
		270	"budget_period",
		271	"Koha::Schema::Result::Aqbudgetperiod",
		272	{ budget_period_id => "budget_period_id" },
		273	{
		274	is_deferrable => 1,
		275	join_type => "LEFT",
		276	on_delete => "CASCADE",
		277	on_update => "CASCADE",
		278	},
		279	);
		280
260	=head2 suggestions	281	=head2 suggestions
261		282
262	Type: has_many	283	Type: has_many
Lines 298-305 Composing rels: L</aqbudgetborrowers> -> borrowernumber Link Here
298	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");	319	__PACKAGE__->many_to_many("borrowernumbers", "aqbudgetborrowers", "borrowernumber");
299		320
300		321
301	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45	322	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
302	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zB7ox8a4KdDGq5fsbQfLGQ	323	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oAGvpiU7zjOnpWEfpOMmDw
303		324
304		325
305	# You can replace this text with custom content, and it will be preserved on regeneration	326	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 52-63 __PACKAGE__->table("aqbudgetperiods"); Link Here

(-)a/Koha/Schema/Result/Aqbudgetperiod.pm (-10 / +27 lines)
52	data_type: 'longtext'	52	data_type: 'longtext'
53	is_nullable: 1	53	is_nullable: 1
54		54
55	=head2 budget_period_total
56
57	data_type: 'decimal'
58	is_nullable: 1
59	size: [28,6]
60
61	=head2 budget_period_locked	55	=head2 budget_period_locked
62		56
63	data_type: 'tinyint'	57	data_type: 'tinyint'
Lines 75-80 __PACKAGE__->table("aqbudgetperiods"); Link Here
75	is_nullable: 1	69	is_nullable: 1
76	size: 10	70	size: 10
77		71
		72	=head2 budget_period_total
		73
		74	data_type: 'decimal'
		75	is_nullable: 1
		76	size: [28,6]
		77
78	=cut	78	=cut
79		79
80	__PACKAGE__->add_columns(	80	__PACKAGE__->add_columns(
Lines 88-101 __PACKAGE__->add_columns( Link Here
88	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },	88	{ data_type => "tinyint", default_value => 0, is_nullable => 1 },
89	"budget_period_description",	89	"budget_period_description",
90	{ data_type => "longtext", is_nullable => 1 },	90	{ data_type => "longtext", is_nullable => 1 },
91	"budget_period_total",
92	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
93	"budget_period_locked",	91	"budget_period_locked",
94	{ data_type => "tinyint", is_nullable => 1 },	92	{ data_type => "tinyint", is_nullable => 1 },
95	"sort1_authcat",	93	"sort1_authcat",
96	{ data_type => "varchar", is_nullable => 1, size => 10 },	94	{ data_type => "varchar", is_nullable => 1, size => 10 },
97	"sort2_authcat",	95	"sort2_authcat",
98	{ data_type => "varchar", is_nullable => 1, size => 10 },	96	{ data_type => "varchar", is_nullable => 1, size => 10 },
		97	"budget_period_total",
		98	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
99	);	99	);
100		100
101	=head1 PRIMARY KEY	101	=head1 PRIMARY KEY
Lines 110-118 __PACKAGE__->add_columns( Link Here
110		110
111	__PACKAGE__->set_primary_key("budget_period_id");	111	__PACKAGE__->set_primary_key("budget_period_id");
112		112
		113	=head1 RELATIONS
		114
		115	=head2 aqbudgets
		116
		117	Type: has_many
		118
		119	Related object: L<Koha::Schema::Result::Aqbudget>
		120
		121	=cut
		122
		123	__PACKAGE__->has_many(
		124	"aqbudgets",
		125	"Koha::Schema::Result::Aqbudget",
		126	{ "foreign.budget_period_id" => "self.budget_period_id" },
		127	{ cascade_copy => 0, cascade_delete => 0 },
		128	);
		129
113		130
114	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	131	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
115	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M13qdhmXgKilais2IFkXFw	132	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:V7R0Zdn1ZrQoRIcib6LUIw
116		133
117		134
118	# You can replace this text with custom content, and it will be preserved on regeneration	135	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 73-79 __PACKAGE__->table("aqinvoices"); Link Here

(-)a/Koha/Schema/Result/Aqinvoice.pm (-24 / +3 lines)
73	=head2 message_id	73	=head2 message_id
74		74
75	data_type: 'integer'	75	data_type: 'integer'
76	is_foreign_key: 1
77	is_nullable: 1	76	is_nullable: 1
78		77
79	=cut	78	=cut
Lines 96-102 __PACKAGE__->add_columns( Link Here
96	"shipmentcost_budgetid",	95	"shipmentcost_budgetid",
97	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	96	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
98	"message_id",	97	"message_id",
99	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	98	{ data_type => "integer", is_nullable => 1 },
100	);	99	);
101		100
102	=head1 PRIMARY KEY	101	=head1 PRIMARY KEY
Lines 158-183 __PACKAGE__->belongs_to( Link Here
158	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	157	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
159	);	158	);
160		159
161	=head2 message
162
163	Type: belongs_to
164
165	Related object: L<Koha::Schema::Result::EdifactMessage>
166
167	=cut
168
169	__PACKAGE__->belongs_to(
170	"message",
171	"Koha::Schema::Result::EdifactMessage",
172	{ id => "message_id" },
173	{
174	is_deferrable => 1,
175	join_type => "LEFT",
176	on_delete => "SET NULL",
177	on_update => "RESTRICT",
178	},
179	);
180
181	=head2 shipmentcost_budgetid	160	=head2 shipmentcost_budgetid
182		161
183	Type: belongs_to	162	Type: belongs_to
Lines 199-206 __PACKAGE__->belongs_to( Link Here
199	);	178	);
200		179
201		180
202	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-16 13:50:45	181	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
203	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mpdxTbkz/8WInG5Wp4q7Ug	182	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Vt50GepELpI7iE49C9dTJA
204		183
205		184
206	# You can replace this text with custom content, and it will be preserved on regeneration	185	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 152-163 __PACKAGE__->table("aqorders"); Link Here

(-)a/Koha/Schema/Result/Aqorder.pm (-34 / +34 lines)
152	is_nullable: 1	152	is_nullable: 1
153	size: [13,2]	153	size: [13,2]
154		154
155	=head2 replacementprice
156
157	data_type: 'decimal'
158	is_nullable: 1
159	size: [28,6]
160
161	=head2 rrp_tax_excluded	155	=head2 rrp_tax_excluded
162		156
163	data_type: 'decimal'	157	data_type: 'decimal'
Lines 230-241 __PACKAGE__->table("aqorders"); Link Here
230	is_nullable: 1	224	is_nullable: 1
231	size: [6,4]	225	size: [6,4]
232		226
233	=head2 budget_id
234
235	data_type: 'integer'
236	is_foreign_key: 1
237	is_nullable: 0
238
239	=head2 budgetdate	227	=head2 budgetdate
240		228
241	data_type: 'date'	229	data_type: 'date'
Lines 254-259 __PACKAGE__->table("aqorders"); Link Here
254	is_nullable: 1	242	is_nullable: 1
255	size: 80	243	size: 80
256		244
		245	=head2 uncertainprice
		246
		247	data_type: 'tinyint'
		248	is_nullable: 1
		249
		250	=head2 budget_id
		251
		252	data_type: 'integer'
		253	is_foreign_key: 1
		254	is_nullable: 0
		255
257	=head2 sort1_authcat	256	=head2 sort1_authcat
258		257
259	data_type: 'varchar'	258	data_type: 'varchar'
Lines 266-276 __PACKAGE__->table("aqorders"); Link Here
266	is_nullable: 1	265	is_nullable: 1
267	size: 10	266	size: 10
268		267
269	=head2 uncertainprice
270
271	data_type: 'tinyint'
272	is_nullable: 1
273
274	=head2 claims_count	268	=head2 claims_count
275		269
276	data_type: 'integer'	270	data_type: 'integer'
Lines 283-294 __PACKAGE__->table("aqorders"); Link Here
283	datetime_undef_if_invalid: 1	277	datetime_undef_if_invalid: 1
284	is_nullable: 1	278	is_nullable: 1
285		279
286	=head2 subscriptionid
287
288	data_type: 'integer'
289	is_foreign_key: 1
290	is_nullable: 1
291
292	=head2 parent_ordernumber	280	=head2 parent_ordernumber
293		281
294	data_type: 'integer'	282	data_type: 'integer'
Lines 301-306 __PACKAGE__->table("aqorders"); Link Here
301	is_nullable: 1	289	is_nullable: 1
302	size: 16	290	size: 16
303		291
		292	=head2 subscriptionid
		293
		294	data_type: 'integer'
		295	is_foreign_key: 1
		296	is_nullable: 1
		297
304	=head2 line_item_id	298	=head2 line_item_id
305		299
306	data_type: 'varchar'	300	data_type: 'varchar'
Lines 324-329 __PACKAGE__->table("aqorders"); Link Here
324	data_type: 'mediumtext'	318	data_type: 'mediumtext'
325	is_nullable: 1	319	is_nullable: 1
326		320
		321	=head2 replacementprice
		322
		323	data_type: 'decimal'
		324	is_nullable: 1
		325	size: [28,6]
		326
327	=cut	327	=cut
328		328
329	__PACKAGE__->add_columns(	329	__PACKAGE__->add_columns(
Lines 376-383 __PACKAGE__->add_columns( Link Here
376	},	376	},
377	"rrp",	377	"rrp",
378	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },	378	{ data_type => "decimal", is_nullable => 1, size => [13, 2] },
379	"replacementprice",
380	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
381	"rrp_tax_excluded",	379	"rrp_tax_excluded",
382	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	380	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
383	"rrp_tax_included",	381	"rrp_tax_included",
Lines 402-427 __PACKAGE__->add_columns( Link Here
402	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	400	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
403	"discount",	401	"discount",
404	{ data_type => "float", is_nullable => 1, size => [6, 4] },	402	{ data_type => "float", is_nullable => 1, size => [6, 4] },
405	"budget_id",
406	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
407	"budgetdate",	403	"budgetdate",
408	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	404	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
409	"sort1",	405	"sort1",
410	{ data_type => "varchar", is_nullable => 1, size => 80 },	406	{ data_type => "varchar", is_nullable => 1, size => 80 },
411	"sort2",	407	"sort2",
412	{ data_type => "varchar", is_nullable => 1, size => 80 },	408	{ data_type => "varchar", is_nullable => 1, size => 80 },
		409	"uncertainprice",
		410	{ data_type => "tinyint", is_nullable => 1 },
		411	"budget_id",
		412	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
413	"sort1_authcat",	413	"sort1_authcat",
414	{ data_type => "varchar", is_nullable => 1, size => 10 },	414	{ data_type => "varchar", is_nullable => 1, size => 10 },
415	"sort2_authcat",	415	"sort2_authcat",
416	{ data_type => "varchar", is_nullable => 1, size => 10 },	416	{ data_type => "varchar", is_nullable => 1, size => 10 },
417	"uncertainprice",
418	{ data_type => "tinyint", is_nullable => 1 },
419	"claims_count",	417	"claims_count",
420	{ data_type => "integer", default_value => 0, is_nullable => 1 },	418	{ data_type => "integer", default_value => 0, is_nullable => 1 },
421	"claimed_date",	419	"claimed_date",
422	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	420	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
423	"subscriptionid",
424	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
425	"parent_ordernumber",	421	"parent_ordernumber",
426	{ data_type => "integer", is_nullable => 1 },	422	{ data_type => "integer", is_nullable => 1 },
427	"orderstatus",	423	"orderstatus",
Lines 431-436 __PACKAGE__->add_columns( Link Here
431	is_nullable => 1,	427	is_nullable => 1,
432	size => 16,	428	size => 16,
433	},	429	},
		430	"subscriptionid",
		431	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
434	"line_item_id",	432	"line_item_id",
435	{ data_type => "varchar", is_nullable => 1, size => 35 },	433	{ data_type => "varchar", is_nullable => 1, size => 35 },
436	"suppliers_reference_number",	434	"suppliers_reference_number",
Lines 439-444 __PACKAGE__->add_columns( Link Here
439	{ data_type => "varchar", is_nullable => 1, size => 3 },	437	{ data_type => "varchar", is_nullable => 1, size => 3 },
440	"suppliers_report",	438	"suppliers_report",
441	{ data_type => "mediumtext", is_nullable => 1 },	439	{ data_type => "mediumtext", is_nullable => 1 },
		440	"replacementprice",
		441	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
442	);	442	);
443		443
444	=head1 PRIMARY KEY	444	=head1 PRIMARY KEY
Lines 551-557 __PACKAGE__->belongs_to( Link Here
551	is_deferrable => 1,	551	is_deferrable => 1,
552	join_type => "LEFT",	552	join_type => "LEFT",
553	on_delete => "SET NULL",	553	on_delete => "SET NULL",
554	on_update => "CASCADE",	554	on_update => "SET NULL",
555	},	555	},
556	);	556	);
557		557
Lines 661-668 Composing rels: L</aqorder_users> -> borrowernumber Link Here
661	__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");	661	__PACKAGE__->many_to_many("borrowernumbers", "aqorder_users", "borrowernumber");
662		662
663		663
664	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-08-31 11:51:37	664	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
665	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GQEXetlivZm7buQohl8m4A	665	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:y7OfxpCVrDFw2JQU4SErew
666		666
667	sub koha_objects_class {	667	sub koha_objects_class {
668	'Koha::Acquisition::Orders';	668	'Koha::Acquisition::Orders';

Lines 121-128 __PACKAGE__->table("auth_subfield_structure"); Link Here

(-)a/Koha/Schema/Result/AuthSubfieldStructure.pm (-5 / +4 lines)
121	=head2 frameworkcode	121	=head2 frameworkcode
122		122
123	data_type: 'varchar'	123	data_type: 'varchar'
124	default_value: (empty string)	124	is_nullable: 1
125	is_nullable: 0
126	size: 10	125	size: 10
127		126
128	=head2 defaultvalue	127	=head2 defaultvalue
Lines 170-176 __PACKAGE__->add_columns( Link Here
170	"kohafield",	169	"kohafield",
171	{ data_type => "varchar", default_value => "", is_nullable => 1, size => 45 },	170	{ data_type => "varchar", default_value => "", is_nullable => 1, size => 45 },
172	"frameworkcode",	171	"frameworkcode",
173	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },	172	{ data_type => "varchar", is_nullable => 1, size => 10 },
174	"defaultvalue",	173	"defaultvalue",
175	{ data_type => "mediumtext", is_nullable => 1 },	174	{ data_type => "mediumtext", is_nullable => 1 },
176	);	175	);
Lines 209-216 __PACKAGE__->belongs_to( Link Here
209	);	208	);
210		209
211		210
212	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	211	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
213	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5Prv/DCQk32mTQaqtYhUuA	212	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:htwTatj58OlWarcF1/9pSA
214		213
215		214
216	# You can replace this text with custom content, and it will be preserved on regeneration	215	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 129-137 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/AuthorisedValue.pm (-2 / +17 lines)
129	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	129	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
130	);	130	);
131		131
		132	=head2 illrequests
132		133
133	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-26 16:13:07	134	Type: has_many
134	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YwvGOd/jzk71ekWfO56xrw	135
		136	Related object: L<Koha::Schema::Result::Illrequest>
		137
		138	=cut
		139
		140	__PACKAGE__->has_many(
		141	"illrequests",
		142	"Koha::Schema::Result::Illrequest",
		143	{ "foreign.status_alias" => "self.id" },
		144	{ cascade_copy => 0, cascade_delete => 0 },
		145	);
		146
		147
		148	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
		149	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RKwmasD8ufV5zuXcklRE3A
135		150
136		151
137	# You can replace this text with custom code or comments, and it will be preserved on regeneration	152	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 26-32 __PACKAGE__->table("authorised_value_categories"); Link Here

(-)a/Koha/Schema/Result/AuthorisedValueCategory.pm (-4 / +3 lines)
26	=head2 category_name	26	=head2 category_name
27		27
28	data_type: 'varchar'	28	data_type: 'varchar'
29	default_value: (empty string)
30	is_nullable: 0	29	is_nullable: 0
31	size: 32	30	size: 32
32		31
Lines 34-40 __PACKAGE__->table("authorised_value_categories"); Link Here
34		33
35	__PACKAGE__->add_columns(	34	__PACKAGE__->add_columns(
36	"category_name",	35	"category_name",
37	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 32 },	36	{ data_type => "varchar", is_nullable => 0, size => 32 },
38	);	37	);
39		38
40	=head1 PRIMARY KEY	39	=head1 PRIMARY KEY
Lines 97-104 __PACKAGE__->has_many( Link Here
97	);	96	);
98		97
99		98
100	# Created by DBIx::Class::Schema::Loader v0.07045 @ 2016-08-30 11:59:31	99	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
101	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6vToj9pUcIv8Jio38rNE4g	100	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mEZUVKQXHKTLVfXoeMHosw
102		101
103		102
104	# You can replace this text with custom code or comments, and it will be preserved on regeneration	103	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 89-95 __PACKAGE__->table("borrowers"); Link Here

(-)a/Koha/Schema/Result/Borrower.pm (-24 / +27 lines)
89		89
90	=head2 state	90	=head2 state
91		91
92	data_type: 'mediumtext'	92	data_type: 'longtext'
93	is_nullable: 1	93	is_nullable: 1
94		94
95	=head2 zipcode	95	=head2 zipcode
Lines 170-176 __PACKAGE__->table("borrowers"); Link Here
170	=head2 B_state	170	=head2 B_state
171		171
172	accessor: 'b_state'	172	accessor: 'b_state'
173	data_type: 'mediumtext'	173	data_type: 'longtext'
174	is_nullable: 1	174	is_nullable: 1
175		175
176	=head2 B_zipcode	176	=head2 B_zipcode
Lines 291-296 __PACKAGE__->table("borrowers"); Link Here
291	is_nullable: 1	291	is_nullable: 1
292	size: 100	292	size: 100
293		293
		294	=head2 ethnicity
		295
		296	data_type: 'varchar'
		297	is_nullable: 1
		298	size: 50
		299
		300	=head2 ethnotes
		301
		302	data_type: 'varchar'
		303	is_nullable: 1
		304	size: 255
		305
294	=head2 sex	306	=head2 sex
295		307
296	data_type: 'varchar'	308	data_type: 'varchar'
Lines 369-375 __PACKAGE__->table("borrowers"); Link Here
369		381
370	=head2 altcontactstate	382	=head2 altcontactstate
371		383
372	data_type: 'mediumtext'	384	data_type: 'longtext'
373	is_nullable: 1	385	is_nullable: 1
374		386
375	=head2 altcontactzipcode	387	=head2 altcontactzipcode
Lines 425-431 __PACKAGE__->table("borrowers"); Link Here
425	data_type: 'timestamp'	437	data_type: 'timestamp'
426	datetime_undef_if_invalid: 1	438	datetime_undef_if_invalid: 1
427	default_value: current_timestamp	439	default_value: current_timestamp
428	is_nullable: 0	440	is_nullable: 1
429		441
430	=head2 lastseen	442	=head2 lastseen
431		443
Lines 443-449 __PACKAGE__->table("borrowers"); Link Here
443	=head2 login_attempts	455	=head2 login_attempts
444		456
445	data_type: 'integer'	457	data_type: 'integer'
446	default_value: 0
447	is_nullable: 1	458	is_nullable: 1
448		459
449	=head2 overdrive_auth_token	460	=head2 overdrive_auth_token
Lines 479-485 __PACKAGE__->add_columns( Link Here
479	"city",	490	"city",
480	{ data_type => "longtext", is_nullable => 1 },	491	{ data_type => "longtext", is_nullable => 1 },
481	"state",	492	"state",
482	{ data_type => "mediumtext", is_nullable => 1 },	493	{ data_type => "longtext", is_nullable => 1 },
483	"zipcode",	494	"zipcode",
484	{ data_type => "varchar", is_nullable => 1, size => 25 },	495	{ data_type => "varchar", is_nullable => 1, size => 25 },
485	"country",	496	"country",
Lines 522-528 __PACKAGE__->add_columns( Link Here
522	"B_city",	533	"B_city",
523	{ accessor => "b_city", data_type => "longtext", is_nullable => 1 },	534	{ accessor => "b_city", data_type => "longtext", is_nullable => 1 },
524	"B_state",	535	"B_state",
525	{ accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },	536	{ accessor => "b_state", data_type => "longtext", is_nullable => 1 },
526	"B_zipcode",	537	"B_zipcode",
527	{	538	{
528	accessor => "b_zipcode",	539	accessor => "b_zipcode",
Lines 580-585 __PACKAGE__->add_columns( Link Here
580	{ data_type => "longtext", is_nullable => 1 },	591	{ data_type => "longtext", is_nullable => 1 },
581	"relationship",	592	"relationship",
582	{ data_type => "varchar", is_nullable => 1, size => 100 },	593	{ data_type => "varchar", is_nullable => 1, size => 100 },
		594	"ethnicity",
		595	{ data_type => "varchar", is_nullable => 1, size => 50 },
		596	"ethnotes",
		597	{ data_type => "varchar", is_nullable => 1, size => 255 },
583	"sex",	598	"sex",
584	{ data_type => "varchar", is_nullable => 1, size => 1 },	599	{ data_type => "varchar", is_nullable => 1, size => 1 },
585	"password",	600	"password",
Lines 607-613 __PACKAGE__->add_columns( Link Here
607	"altcontactaddress3",	622	"altcontactaddress3",
608	{ data_type => "varchar", is_nullable => 1, size => 255 },	623	{ data_type => "varchar", is_nullable => 1, size => 255 },
609	"altcontactstate",	624	"altcontactstate",
610	{ data_type => "mediumtext", is_nullable => 1 },	625	{ data_type => "longtext", is_nullable => 1 },
611	"altcontactzipcode",	626	"altcontactzipcode",
612	{ data_type => "varchar", is_nullable => 1, size => 50 },	627	{ data_type => "varchar", is_nullable => 1, size => 50 },
613	"altcontactcountry",	628	"altcontactcountry",
Lines 634-640 __PACKAGE__->add_columns( Link Here
634	data_type => "timestamp",	649	data_type => "timestamp",
635	datetime_undef_if_invalid => 1,	650	datetime_undef_if_invalid => 1,
636	default_value => \"current_timestamp",	651	default_value => \"current_timestamp",
637	is_nullable => 0,	652	is_nullable => 1,
638	},	653	},
639	"lastseen",	654	"lastseen",
640	{	655	{
Lines 650-656 __PACKAGE__->add_columns( Link Here
650	size => 25,	665	size => 25,
651	},	666	},
652	"login_attempts",	667	"login_attempts",
653	{ data_type => "integer", default_value => 0, is_nullable => 1 },	668	{ data_type => "integer", is_nullable => 1 },
654	"overdrive_auth_token",	669	"overdrive_auth_token",
655	{ data_type => "mediumtext", is_nullable => 1 },	670	{ data_type => "mediumtext", is_nullable => 1 },
656	);	671	);
Lines 681-698 __PACKAGE__->set_primary_key("borrowernumber"); Link Here
681		696
682	__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);	697	__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
683		698
684	=head2 C<userid>
685
686	=over 4
687
688	=item * L</userid>
689
690	=back
691
692	=cut
693
694	__PACKAGE__->add_unique_constraint("userid", ["userid"]);
695
696	=head1 RELATIONS	699	=head1 RELATIONS
697		700
698	=head2 accountlines	701	=head2 accountlines
Lines 1431-1438 Composing rels: L</aqorder_users> -> ordernumber Link Here
1431	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");	1434	__PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1432		1435
1433		1436
1434	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48	1437	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
1435	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c3Tb59Kku0Hh+tsVV5eCDg	1438	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kjQnCBqkdXvkJl4NeA+rgQ
1436		1439
1437	__PACKAGE__->belongs_to(	1440	__PACKAGE__->belongs_to(
1438	"guarantor",	1441	"guarantor",

Lines 95-100 __PACKAGE__->table("categories"); Link Here

(-)a/Koha/Schema/Result/Category.pm (-16 / +39 lines)
95	default_value: 0	95	default_value: 0
96	is_nullable: 0	96	is_nullable: 0
97		97
		98	=head2 illlimit
		99
		100	data_type: 'smallint'
		101	default_value: 0
		102	is_nullable: 1
		103
98	=head2 category_type	104	=head2 category_type
99		105
100	data_type: 'varchar'	106	data_type: 'varchar'
Lines 102-114 __PACKAGE__->table("categories"); Link Here
102	is_nullable: 0	108	is_nullable: 0
103	size: 1	109	size: 1
104		110
105	=head2 BlockExpiredPatronOpacActions
106
107	accessor: 'block_expired_patron_opac_actions'
108	data_type: 'tinyint'
109	default_value: -1
110	is_nullable: 0
111
112	=head2 default_privacy	111	=head2 default_privacy
113		112
114	data_type: 'enum'	113	data_type: 'enum'
Lines 123-128 __PACKAGE__->table("categories"); Link Here
123	is_nullable: 0	122	is_nullable: 0
124	size: 7	123	size: 7
125		124
		125	=head2 BlockExpiredPatronOpacActions
		126
		127	accessor: 'block_expired_patron_opac_actions'
		128	data_type: 'tinyint'
		129	default_value: -1
		130	is_nullable: 0
		131
126	=cut	132	=cut
127		133
128	__PACKAGE__->add_columns(	134	__PACKAGE__->add_columns(
Lines 152-166 __PACKAGE__->add_columns( Link Here
152	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },	158	{ data_type => "decimal", is_nullable => 1, size => [28, 6] },
153	"hidelostitems",	159	"hidelostitems",
154	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	160	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		161	"illlimit",
		162	{ data_type => "smallint", default_value => 0, is_nullable => 1 },
155	"category_type",	163	"category_type",
156	{ data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },	164	{ data_type => "varchar", default_value => "A", is_nullable => 0, size => 1 },
157	"BlockExpiredPatronOpacActions",
158	{
159	accessor => "block_expired_patron_opac_actions",
160	data_type => "tinyint",
161	default_value => -1,
162	is_nullable => 0,
163	},
164	"default_privacy",	165	"default_privacy",
165	{	166	{
166	data_type => "enum",	167	data_type => "enum",
Lines 175-180 __PACKAGE__->add_columns( Link Here
175	is_nullable => 0,	176	is_nullable => 0,
176	size => 7,	177	size => 7,
177	},	178	},
		179	"BlockExpiredPatronOpacActions",
		180	{
		181	accessor => "block_expired_patron_opac_actions",
		182	data_type => "tinyint",
		183	default_value => -1,
		184	is_nullable => 0,
		185	},
178	);	186	);
179		187
180	=head1 PRIMARY KEY	188	=head1 PRIMARY KEY
Lines 191-196 __PACKAGE__->set_primary_key("categorycode"); Link Here
191		199
192	=head1 RELATIONS	200	=head1 RELATIONS
193		201
		202	=head2 borrower_attribute_types
		203
		204	Type: has_many
		205
		206	Related object: L<Koha::Schema::Result::BorrowerAttributeType>
		207
		208	=cut
		209
		210	__PACKAGE__->has_many(
		211	"borrower_attribute_types",
		212	"Koha::Schema::Result::BorrowerAttributeType",
		213	{ "foreign.category_code" => "self.categorycode" },
		214	{ cascade_copy => 0, cascade_delete => 0 },
		215	);
		216
194	=head2 borrower_message_preferences	217	=head2 borrower_message_preferences
195		218
196	Type: has_many	219	Type: has_many
Lines 282-289 __PACKAGE__->might_have( Link Here
282	);	305	);
283		306
284		307
285	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-05 14:29:17	308	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
286	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yvHcgnSv1RXNMXJixVtt0Q	309	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L6F4lG7nQiXzCz5Eee0mtw
287		310
288		311
289	# You can replace this text with custom content, and it will be preserved on regeneration	312	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 42-58 __PACKAGE__->table("cities"); Link Here

(-)a/Koha/Schema/Result/City.pm (-8 / +8 lines)
42	is_nullable: 1	42	is_nullable: 1
43	size: 100	43	size: 100
44		44
45	=head2 city_country	45	=head2 city_zipcode
46		46
47	data_type: 'varchar'	47	data_type: 'varchar'
48	is_nullable: 1	48	is_nullable: 1
49	size: 100	49	size: 20
50		50
51	=head2 city_zipcode	51	=head2 city_country
52		52
53	data_type: 'varchar'	53	data_type: 'varchar'
54	is_nullable: 1	54	is_nullable: 1
55	size: 20	55	size: 100
56		56
57	=cut	57	=cut
58		58
Lines 63-72 __PACKAGE__->add_columns( Link Here
63	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },	63	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
64	"city_state",	64	"city_state",
65	{ data_type => "varchar", is_nullable => 1, size => 100 },	65	{ data_type => "varchar", is_nullable => 1, size => 100 },
66	"city_country",
67	{ data_type => "varchar", is_nullable => 1, size => 100 },
68	"city_zipcode",	66	"city_zipcode",
69	{ data_type => "varchar", is_nullable => 1, size => 20 },	67	{ data_type => "varchar", is_nullable => 1, size => 20 },
		68	"city_country",
		69	{ data_type => "varchar", is_nullable => 1, size => 100 },
70	);	70	);
71		71
72	=head1 PRIMARY KEY	72	=head1 PRIMARY KEY
Lines 82-89 __PACKAGE__->add_columns( Link Here
82	__PACKAGE__->set_primary_key("cityid");	82	__PACKAGE__->set_primary_key("cityid");
83		83
84		84
85	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	85	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
86	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zEjfS65sp13yF7dH8/ojZQ	86	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aOIpsiZF15Qzurb4NNUZZQ
87		87
88		88
89	# You can replace this text with custom content, and it will be preserved on regeneration	89	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 42-48 __PACKAGE__->table("default_circ_rules"); Link Here

(-)a/Koha/Schema/Result/DefaultCircRule.pm (-4 / +4 lines)
42		42
43	=head2 holdallowed	43	=head2 holdallowed
44		44
45	data_type: 'integer'	45	data_type: 'tinyint'
46	is_nullable: 1	46	is_nullable: 1
47		47
48	=head2 hold_fulfillment_policy	48	=head2 hold_fulfillment_policy
Lines 73-79 __PACKAGE__->add_columns( Link Here
73	"maxonsiteissueqty",	73	"maxonsiteissueqty",
74	{ data_type => "integer", is_nullable => 1 },	74	{ data_type => "integer", is_nullable => 1 },
75	"holdallowed",	75	"holdallowed",
76	{ data_type => "integer", is_nullable => 1 },	76	{ data_type => "tinyint", is_nullable => 1 },
77	"hold_fulfillment_policy",	77	"hold_fulfillment_policy",
78	{	78	{
79	data_type => "enum",	79	data_type => "enum",
Lines 98-105 __PACKAGE__->add_columns( Link Here
98	__PACKAGE__->set_primary_key("singleton");	98	__PACKAGE__->set_primary_key("singleton");
99		99
100		100
101	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-04-29 10:32:00	101	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
102	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fqBrj0c9h9c0eBlC0kG51w	102	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ttOioXaCXJKF52QQcOUlOQ
103		103
104		104
105	# You can replace this text with custom content, and it will be preserved on regeneration	105	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 26-32 __PACKAGE__->table("deletedbiblio"); Link Here

(-)a/Koha/Schema/Result/Deletedbiblio.pm (-4 / +4 lines)
26	=head2 biblionumber	26	=head2 biblionumber
27		27
28	data_type: 'integer'	28	data_type: 'integer'
29	is_auto_increment: 1	29	default_value: 0
30	is_nullable: 0	30	is_nullable: 0
31		31
32	=head2 frameworkcode	32	=head2 frameworkcode
Lines 93-99 __PACKAGE__->table("deletedbiblio"); Link Here
93		93
94	__PACKAGE__->add_columns(	94	__PACKAGE__->add_columns(
95	"biblionumber",	95	"biblionumber",
96	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	96	{ data_type => "integer", default_value => 0, is_nullable => 0 },
97	"frameworkcode",	97	"frameworkcode",
98	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },	98	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
99	"author",	99	"author",
Lines 153-160 __PACKAGE__->has_many( Link Here
153	);	153	);
154		154
155		155
156	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	156	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
157	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dP0HOIp/+I93Y/u92TDI1g	157	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xbFngDcDw22QzSI9NgqvtQ
158		158
159		159
160	# You can replace this text with custom content, and it will be preserved on regeneration	160	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 89-95 __PACKAGE__->table("deletedborrowers"); Link Here

(-)a/Koha/Schema/Result/Deletedborrower.pm (-18 / +31 lines)
89		89
90	=head2 state	90	=head2 state
91		91
92	data_type: 'mediumtext'	92	data_type: 'longtext'
93	is_nullable: 1	93	is_nullable: 1
94		94
95	=head2 zipcode	95	=head2 zipcode
Lines 170-176 __PACKAGE__->table("deletedborrowers"); Link Here
170	=head2 B_state	170	=head2 B_state
171		171
172	accessor: 'b_state'	172	accessor: 'b_state'
173	data_type: 'mediumtext'	173	data_type: 'longtext'
174	is_nullable: 1	174	is_nullable: 1
175		175
176	=head2 B_zipcode	176	=head2 B_zipcode
Lines 214-221 __PACKAGE__->table("deletedborrowers"); Link Here
214	=head2 categorycode	214	=head2 categorycode
215		215
216	data_type: 'varchar'	216	data_type: 'varchar'
217	default_value: (empty string)	217	is_nullable: 1
218	is_nullable: 0
219	size: 10	218	size: 10
220		219
221	=head2 dateenrolled	220	=head2 dateenrolled
Lines 289-294 __PACKAGE__->table("deletedborrowers"); Link Here
289	is_nullable: 1	288	is_nullable: 1
290	size: 100	289	size: 100
291		290
		291	=head2 ethnicity
		292
		293	data_type: 'varchar'
		294	is_nullable: 1
		295	size: 50
		296
		297	=head2 ethnotes
		298
		299	data_type: 'varchar'
		300	is_nullable: 1
		301	size: 255
		302
292	=head2 sex	303	=head2 sex
293		304
294	data_type: 'varchar'	305	data_type: 'varchar'
Lines 367-373 __PACKAGE__->table("deletedborrowers"); Link Here
367		378
368	=head2 altcontactstate	379	=head2 altcontactstate
369		380
370	data_type: 'mediumtext'	381	data_type: 'longtext'
371	is_nullable: 1	382	is_nullable: 1
372		383
373	=head2 altcontactzipcode	384	=head2 altcontactzipcode
Lines 401-408 __PACKAGE__->table("deletedborrowers"); Link Here
401	=head2 privacy	412	=head2 privacy
402		413
403	data_type: 'integer'	414	data_type: 'integer'
404	default_value: 1	415	is_nullable: 1
405	is_nullable: 0
406		416
407	=head2 privacy_guarantor_checkouts	417	=head2 privacy_guarantor_checkouts
408		418
Lines 422-428 __PACKAGE__->table("deletedborrowers"); Link Here
422	data_type: 'timestamp'	432	data_type: 'timestamp'
423	datetime_undef_if_invalid: 1	433	datetime_undef_if_invalid: 1
424	default_value: current_timestamp	434	default_value: current_timestamp
425	is_nullable: 0	435	is_nullable: 1
426		436
427	=head2 lastseen	437	=head2 lastseen
428		438
Lines 440-446 __PACKAGE__->table("deletedborrowers"); Link Here
440	=head2 login_attempts	450	=head2 login_attempts
441		451
442	data_type: 'integer'	452	data_type: 'integer'
443	default_value: 0
444	is_nullable: 1	453	is_nullable: 1
445		454
446	=head2 overdrive_auth_token	455	=head2 overdrive_auth_token
Lines 476-482 __PACKAGE__->add_columns( Link Here
476	"city",	485	"city",
477	{ data_type => "longtext", is_nullable => 1 },	486	{ data_type => "longtext", is_nullable => 1 },
478	"state",	487	"state",
479	{ data_type => "mediumtext", is_nullable => 1 },	488	{ data_type => "longtext", is_nullable => 1 },
480	"zipcode",	489	"zipcode",
481	{ data_type => "varchar", is_nullable => 1, size => 25 },	490	{ data_type => "varchar", is_nullable => 1, size => 25 },
482	"country",	491	"country",
Lines 519-525 __PACKAGE__->add_columns( Link Here
519	"B_city",	528	"B_city",
520	{ accessor => "b_city", data_type => "longtext", is_nullable => 1 },	529	{ accessor => "b_city", data_type => "longtext", is_nullable => 1 },
521	"B_state",	530	"B_state",
522	{ accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },	531	{ accessor => "b_state", data_type => "longtext", is_nullable => 1 },
523	"B_zipcode",	532	"B_zipcode",
524	{	533	{
525	accessor => "b_zipcode",	534	accessor => "b_zipcode",
Lines 538-544 __PACKAGE__->add_columns( Link Here
538	"branchcode",	547	"branchcode",
539	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },	548	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
540	"categorycode",	549	"categorycode",
541	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },	550	{ data_type => "varchar", is_nullable => 1, size => 10 },
542	"dateenrolled",	551	"dateenrolled",
543	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	552	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
544	"dateexpiry",	553	"dateexpiry",
Lines 565-570 __PACKAGE__->add_columns( Link Here
565	{ data_type => "longtext", is_nullable => 1 },	574	{ data_type => "longtext", is_nullable => 1 },
566	"relationship",	575	"relationship",
567	{ data_type => "varchar", is_nullable => 1, size => 100 },	576	{ data_type => "varchar", is_nullable => 1, size => 100 },
		577	"ethnicity",
		578	{ data_type => "varchar", is_nullable => 1, size => 50 },
		579	"ethnotes",
		580	{ data_type => "varchar", is_nullable => 1, size => 255 },
568	"sex",	581	"sex",
569	{ data_type => "varchar", is_nullable => 1, size => 1 },	582	{ data_type => "varchar", is_nullable => 1, size => 1 },
570	"password",	583	"password",
Lines 592-598 __PACKAGE__->add_columns( Link Here
592	"altcontactaddress3",	605	"altcontactaddress3",
593	{ data_type => "varchar", is_nullable => 1, size => 255 },	606	{ data_type => "varchar", is_nullable => 1, size => 255 },
594	"altcontactstate",	607	"altcontactstate",
595	{ data_type => "mediumtext", is_nullable => 1 },	608	{ data_type => "longtext", is_nullable => 1 },
596	"altcontactzipcode",	609	"altcontactzipcode",
597	{ data_type => "varchar", is_nullable => 1, size => 50 },	610	{ data_type => "varchar", is_nullable => 1, size => 50 },
598	"altcontactcountry",	611	"altcontactcountry",
Lines 604-610 __PACKAGE__->add_columns( Link Here
604	"sms_provider_id",	617	"sms_provider_id",
605	{ data_type => "integer", is_nullable => 1 },	618	{ data_type => "integer", is_nullable => 1 },
606	"privacy",	619	"privacy",
607	{ data_type => "integer", default_value => 1, is_nullable => 0 },	620	{ data_type => "integer", is_nullable => 1 },
608	"privacy_guarantor_checkouts",	621	"privacy_guarantor_checkouts",
609	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	622	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
610	"checkprevcheckout",	623	"checkprevcheckout",
Lines 619-625 __PACKAGE__->add_columns( Link Here
619	data_type => "timestamp",	632	data_type => "timestamp",
620	datetime_undef_if_invalid => 1,	633	datetime_undef_if_invalid => 1,
621	default_value => \"current_timestamp",	634	default_value => \"current_timestamp",
622	is_nullable => 0,	635	is_nullable => 1,
623	},	636	},
624	"lastseen",	637	"lastseen",
625	{	638	{
Lines 635-648 __PACKAGE__->add_columns( Link Here
635	size => 25,	648	size => 25,
636	},	649	},
637	"login_attempts",	650	"login_attempts",
638	{ data_type => "integer", default_value => 0, is_nullable => 1 },	651	{ data_type => "integer", is_nullable => 1 },
639	"overdrive_auth_token",	652	"overdrive_auth_token",
640	{ data_type => "mediumtext", is_nullable => 1 },	653	{ data_type => "mediumtext", is_nullable => 1 },
641	);	654	);
642		655
643		656
644	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	657	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
645	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:DNkNHNcv0lkMH6/seu89hg	658	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BEq3IZzmy8La8NnwPCbV1Q
646		659
647		660
648	# You can replace this text with custom code or comments, and it will be preserved on regeneration	661	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 119-139 __PACKAGE__->set_primary_key("id"); Link Here

(-)a/Koha/Schema/Result/EdifactMessage.pm (-23 / +8 lines)
119		119
120	=head1 RELATIONS	120	=head1 RELATIONS
121		121
122	=head2 aqinvoices
123
124	Type: has_many
125
126	Related object: L<Koha::Schema::Result::Aqinvoice>
127
128	=cut
129
130	__PACKAGE__->has_many(
131	"aqinvoices",
132	"Koha::Schema::Result::Aqinvoice",
133	{ "foreign.message_id" => "self.id" },
134	{ cascade_copy => 0, cascade_delete => 0 },
135	);
136
137	=head2 basketno	122	=head2 basketno
138		123
139	Type: belongs_to	124	Type: belongs_to
Lines 149-156 __PACKAGE__->belongs_to( Link Here
149	{	134	{
150	is_deferrable => 1,	135	is_deferrable => 1,
151	join_type => "LEFT",	136	join_type => "LEFT",
152	on_delete => "CASCADE",	137	on_delete => "RESTRICT",
153	on_update => "CASCADE",	138	on_update => "RESTRICT",
154	},	139	},
155	);	140	);
156		141
Lines 169-176 __PACKAGE__->belongs_to( Link Here
169	{	154	{
170	is_deferrable => 1,	155	is_deferrable => 1,
171	join_type => "LEFT",	156	join_type => "LEFT",
172	on_delete => "CASCADE",	157	on_delete => "RESTRICT",
173	on_update => "CASCADE",	158	on_update => "RESTRICT",
174	},	159	},
175	);	160	);
176		161
Lines 189-202 __PACKAGE__->belongs_to( Link Here
189	{	174	{
190	is_deferrable => 1,	175	is_deferrable => 1,
191	join_type => "LEFT",	176	join_type => "LEFT",
192	on_delete => "CASCADE",	177	on_delete => "RESTRICT",
193	on_update => "CASCADE",	178	on_update => "RESTRICT",
194	},	179	},
195	);	180	);
196		181
197		182
198	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	183	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
199	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JHUEsQ+kXjGTRxxc2FFSjQ	184	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f90XogVNxT1OZtN5s02KAQ
200		185
201		186
202	1;	187	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/Ethnicity.pm (+66 lines)
		1	use utf8;
		2	package Koha::Schema::Result::Ethnicity;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::Ethnicity
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<ethnicity>
		19
		20	=cut
		21
		22	__PACKAGE__->table("ethnicity");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 code
		27
		28	data_type: 'varchar'
		29	default_value: (empty string)
		30	is_nullable: 0
		31	size: 10
		32
		33	=head2 name
		34
		35	data_type: 'varchar'
		36	is_nullable: 1
		37	size: 255
		38
		39	=cut
		40
		41	__PACKAGE__->add_columns(
		42	"code",
		43	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
		44	"name",
		45	{ data_type => "varchar", is_nullable => 1, size => 255 },
		46	);
		47
		48	=head1 PRIMARY KEY
		49
		50	=over 4
		51
		52	=item * L</code>
		53
		54	=back
		55
		56	=cut
		57
		58	__PACKAGE__->set_primary_key("code");
		59
		60
		61	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
		62	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qu8cssBwlX7MIpoFZ6Xvlg
		63
		64
65	# You can replace this text with custom code or comments, and it will be preserved on regeneration
66	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/Housebound.pm (+122 lines)
		1	use utf8;
		2	package Koha::Schema::Result::Housebound;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::Housebound
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<housebound>
		19
		20	=cut
		21
		22	__PACKAGE__->table("housebound");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 hbnumber
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 day
		33
		34	data_type: 'mediumtext'
		35	is_nullable: 0
		36
		37	=head2 frequency
		38
		39	data_type: 'mediumtext'
		40	is_nullable: 1
		41
		42	=head2 borrowernumber
		43
		44	data_type: 'integer'
		45	is_nullable: 1
		46
		47	=head2 Itype_quant
		48
		49	accessor: 'itype_quant'
		50	data_type: 'varchar'
		51	is_nullable: 1
		52	size: 10
		53
		54	=head2 Item_subject
		55
		56	accessor: 'item_subject'
		57	data_type: 'mediumtext'
		58	is_nullable: 1
		59
		60	=head2 Item_authors
		61
		62	accessor: 'item_authors'
		63	data_type: 'mediumtext'
		64	is_nullable: 1
65
66	=head2 referral
67
68	data_type: 'mediumtext'
69	is_nullable: 1
70
71	=head2 notes
72
73	data_type: 'mediumtext'
74	is_nullable: 1
75
76	=cut
77
78	__PACKAGE__->add_columns(
79	"hbnumber",
80	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
81	"day",
82	{ data_type => "mediumtext", is_nullable => 0 },
83	"frequency",
84	{ data_type => "mediumtext", is_nullable => 1 },
85	"borrowernumber",
86	{ data_type => "integer", is_nullable => 1 },
87	"Itype_quant",
88	{
89	accessor => "itype_quant",
90	data_type => "varchar",
91	is_nullable => 1,
92	size => 10,
93	},
94	"Item_subject",
95	{ accessor => "item_subject", data_type => "mediumtext", is_nullable => 1 },
96	"Item_authors",
97	{ accessor => "item_authors", data_type => "mediumtext", is_nullable => 1 },
98	"referral",
99	{ data_type => "mediumtext", is_nullable => 1 },
100	"notes",
101	{ data_type => "mediumtext", is_nullable => 1 },
102	);
103
104	=head1 PRIMARY KEY
105
106	=over 4
107
108	=item * L</hbnumber>
109
110	=back
111
112	=cut
113
114	__PACKAGE__->set_primary_key("hbnumber");
115
116
117	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
118	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:KfWOT6B9V4lGTxfWOE+QTQ
119
120
121	# You can replace this text with custom code or comments, and it will be preserved on regeneration
122	1;

Line 0 Link Here

(-)a/Koha/Schema/Result/HouseboundInstance.pm (+107 lines)
		1	use utf8;
		2	package Koha::Schema::Result::HouseboundInstance;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::HouseboundInstance
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<housebound_instance>
		19
		20	=cut
		21
		22	__PACKAGE__->table("housebound_instance");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 instanceid
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 hbnumber
		33
		34	data_type: 'integer'
		35	is_nullable: 0
		36
		37	=head2 dmy
		38
		39	data_type: 'date'
		40	datetime_undef_if_invalid: 1
		41	is_nullable: 1
		42
		43	=head2 time
		44
		45	data_type: 'mediumtext'
		46	is_nullable: 1
		47
		48	=head2 borrowernumber
		49
		50	data_type: 'integer'
		51	is_nullable: 0
		52
		53	=head2 volunteer
		54
		55	data_type: 'integer'
		56	is_nullable: 1
		57
		58	=head2 chooser
		59
		60	data_type: 'integer'
		61	is_nullable: 1
		62
		63	=head2 deliverer
		64
65	data_type: 'integer'
66	is_nullable: 1
67
68	=cut
69
70	__PACKAGE__->add_columns(
71	"instanceid",
72	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
73	"hbnumber",
74	{ data_type => "integer", is_nullable => 0 },
75	"dmy",
76	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
77	"time",
78	{ data_type => "mediumtext", is_nullable => 1 },
79	"borrowernumber",
80	{ data_type => "integer", is_nullable => 0 },
81	"volunteer",
82	{ data_type => "integer", is_nullable => 1 },
83	"chooser",
84	{ data_type => "integer", is_nullable => 1 },
85	"deliverer",
86	{ data_type => "integer", is_nullable => 1 },
87	);
88
89	=head1 PRIMARY KEY
90
91	=over 4
92
93	=item * L</instanceid>
94
95	=back
96
97	=cut
98
99	__PACKAGE__->set_primary_key("instanceid");
100
101
102	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
103	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Hi6YuuVAE9fKyyEi8DPhUA
104
105
106	# You can replace this text with custom code or comments, and it will be preserved on regeneration
107	1;

Lines 99-111 __PACKAGE__->table("import_batches"); Link Here

(-)a/Koha/Schema/Result/ImportBatch.pm (-13 / +13 lines)
99	extra: {list => ["batch","z3950","webservice"]}	99	extra: {list => ["batch","z3950","webservice"]}
100	is_nullable: 0	100	is_nullable: 0
101		101
102	=head2 record_type
103
104	data_type: 'enum'
105	default_value: 'biblio'
106	extra: {list => ["biblio","auth","holdings"]}
107	is_nullable: 0
108
109	=head2 file_name	102	=head2 file_name
110		103
111	data_type: 'varchar'	104	data_type: 'varchar'
Lines 117-122 __PACKAGE__->table("import_batches"); Link Here
117	data_type: 'longtext'	110	data_type: 'longtext'
118	is_nullable: 1	111	is_nullable: 1
119		112
		113	=head2 record_type
		114
		115	data_type: 'enum'
		116	default_value: 'biblio'
		117	extra: {list => ["biblio","auth","holdings"]}
		118	is_nullable: 0
		119
120	=cut	120	=cut
121		121
122	__PACKAGE__->add_columns(	122	__PACKAGE__->add_columns(
Lines 192-197 __PACKAGE__->add_columns( Link Here
192	extra => { list => ["batch", "z3950", "webservice"] },	192	extra => { list => ["batch", "z3950", "webservice"] },
193	is_nullable => 0,	193	is_nullable => 0,
194	},	194	},
		195	"file_name",
		196	{ data_type => "varchar", is_nullable => 1, size => 100 },
		197	"comments",
		198	{ data_type => "longtext", is_nullable => 1 },
195	"record_type",	199	"record_type",
196	{	200	{
197	data_type => "enum",	201	data_type => "enum",
Lines 199-208 __PACKAGE__->add_columns( Link Here
199	extra => { list => ["biblio", "auth", "holdings"] },	203	extra => { list => ["biblio", "auth", "holdings"] },
200	is_nullable => 0,	204	is_nullable => 0,
201	},	205	},
202	"file_name",
203	{ data_type => "varchar", is_nullable => 1, size => 100 },
204	"comments",
205	{ data_type => "longtext", is_nullable => 1 },
206	);	206	);
207		207
208	=head1 PRIMARY KEY	208	=head1 PRIMARY KEY
Lines 235-242 __PACKAGE__->has_many( Link Here
235	);	235	);
236		236
237		237
238	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53	238	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
239	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:41giNJCRD9WXC4IGO/1D3A	239	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QuFcB7fNnk3jCFKgi8m7fg
240		240
241		241
242	# You can replace this text with custom content, and it will be preserved on regeneration	242	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 33-45 __PACKAGE__->table("issues"); Link Here

(-)a/Koha/Schema/Result/Issue.pm (-18 / +8 lines)
33		33
34	data_type: 'integer'	34	data_type: 'integer'
35	is_foreign_key: 1	35	is_foreign_key: 1
36	is_nullable: 1	36	is_nullable: 0
37		37
38	=head2 itemnumber	38	=head2 itemnumber
39		39
40	data_type: 'integer'	40	data_type: 'integer'
41	is_foreign_key: 1	41	is_foreign_key: 1
42	is_nullable: 1	42	is_nullable: 0
43		43
44	=head2 date_due	44	=head2 date_due
45		45
Lines 123-131 __PACKAGE__->add_columns( Link Here
123	"issue_id",	123	"issue_id",
124	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	124	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
125	"borrowernumber",	125	"borrowernumber",
126	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	126	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
127	"itemnumber",	127	"itemnumber",
128	{ data_type => "integer", is_foreign_key => 1, is_nullable => 1 },	128	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
129	"date_due",	129	"date_due",
130	{	130	{
131	data_type => "datetime",	131	data_type => "datetime",
Lines 219-230 __PACKAGE__->belongs_to( Link Here
219	"borrowernumber",	219	"borrowernumber",
220	"Koha::Schema::Result::Borrower",	220	"Koha::Schema::Result::Borrower",
221	{ borrowernumber => "borrowernumber" },	221	{ borrowernumber => "borrowernumber" },
222	{	222	{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
223	is_deferrable => 1,
224	join_type => "LEFT",
225	on_delete => "RESTRICT",
226	on_update => "CASCADE",
227	},
228	);	223	);
229		224
230	=head2 itemnumber	225	=head2 itemnumber
Lines 239-255 __PACKAGE__->belongs_to( Link Here
239	"itemnumber",	234	"itemnumber",
240	"Koha::Schema::Result::Item",	235	"Koha::Schema::Result::Item",
241	{ itemnumber => "itemnumber" },	236	{ itemnumber => "itemnumber" },
242	{	237	{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "CASCADE" },
243	is_deferrable => 1,
244	join_type => "LEFT",
245	on_delete => "RESTRICT",
246	on_update => "CASCADE",
247	},
248	);	238	);
249		239
250		240
251	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40	241	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
252	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mlcId4odhAFp3HHgV/+tg	242	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AauWRMNJsFZYKjUkeqtycg
253		243
254	__PACKAGE__->belongs_to(	244	__PACKAGE__->belongs_to(
255	"borrower",	245	"borrower",

Lines 152-163 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/Letter.pm (-3 / +3 lines)
152	"message_transport_type",	152	"message_transport_type",
153	"Koha::Schema::Result::MessageTransportType",	153	"Koha::Schema::Result::MessageTransportType",
154	{ message_transport_type => "message_transport_type" },	154	{ message_transport_type => "message_transport_type" },
155	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },	155	{ is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
156	);	156	);
157		157
158		158
159	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	159	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
160	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fOuu1Fj8Uo3114QKS2qLkQ	160	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XDq2o0wNUEkPuLtfPZiomA
161		161
162		162
163	# You can replace this text with custom content, and it will be preserved on regeneration	163	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 44-50 __PACKAGE__->table("marc_modification_template_actions"); Link Here

(-)a/Koha/Schema/Result/MarcModificationTemplateAction.pm (-4 / +4 lines)
44		44
45	data_type: 'enum'	45	data_type: 'enum'
46	extra: {list => ["delete_field","add_field","update_field","move_field","copy_field","copy_and_replace_field"]}	46	extra: {list => ["delete_field","add_field","update_field","move_field","copy_field","copy_and_replace_field"]}
47	is_nullable: 0	47	is_nullable: 1
48		48
49	=head2 field_number	49	=head2 field_number
50		50
Lines 161-167 __PACKAGE__->add_columns( Link Here
161	"copy_and_replace_field",	161	"copy_and_replace_field",
162	],	162	],
163	},	163	},
164	is_nullable => 0,	164	is_nullable => 1,
165	},	165	},
166	"field_number",	166	"field_number",
167	{ data_type => "smallint", default_value => 0, is_nullable => 0 },	167	{ data_type => "smallint", default_value => 0, is_nullable => 0 },
Lines 235-242 __PACKAGE__->belongs_to( Link Here
235	);	235	);
236		236
237		237
238	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-19 17:32:57	238	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
239	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dAUr9aGlNZleldYbjJHdmw	239	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l5ezpD4DzfzsLV+WhOYpAQ
240		240
241		241
242	# You can replace this text with custom code or comments, and it will be preserved on regeneration	242	# You can replace this text with custom code or comments, and it will be preserved on regeneration

Lines 32-39 __PACKAGE__->table("message_attributes"); Link Here

(-)a/Koha/Schema/Result/MessageAttribute.pm (-5 / +4 lines)
32	=head2 message_name	32	=head2 message_name
33		33
34	data_type: 'varchar'	34	data_type: 'varchar'
35	default_value: (empty string)	35	is_nullable: 1
36	is_nullable: 0
37	size: 40	36	size: 40
38		37
39	=head2 takes_days	38	=head2 takes_days
Lines 48-54 __PACKAGE__->add_columns( Link Here
48	"message_attribute_id",	47	"message_attribute_id",
49	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },	48	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
50	"message_name",	49	"message_name",
51	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 40 },	50	{ data_type => "varchar", is_nullable => 1, size => 40 },
52	"takes_days",	51	"takes_days",
53	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },	52	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
54	);	53	);
Lines 112-119 __PACKAGE__->has_many( Link Here
112	);	111	);
113		112
114		113
115	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	114	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
116	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N033AvWwG2CDBDuTj2unqQ	115	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0UOXJDFio/WUDUbc67P1WQ
117		116
118		117
119	# You can replace this text with custom content, and it will be preserved on regeneration	118	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 125-133 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/OaiSet.pm (-2 / +12 lines)
125	{ cascade_copy => 0, cascade_delete => 0 },	125	{ cascade_copy => 0, cascade_delete => 0 },
126	);	126	);
127		127
		128	=head2 biblionumbers
128		129
129	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22	130	Type: many_to_many
130	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ju63fVMgLPbeFxeZJsQHRQ	131
		132	Composing rels: L</oai_sets_biblios> -> biblionumber
		133
		134	=cut
		135
		136	__PACKAGE__->many_to_many("biblionumbers", "oai_sets_biblios", "biblionumber");
		137
		138
		139	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
		140	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7zp9hrwat3SmXgRedYcXgQ
131		141
132		142
133	# You can replace this text with custom content, and it will be preserved on regeneration	143	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 26-31 __PACKAGE__->table("oai_sets_biblios"); Link Here

(-)a/Koha/Schema/Result/OaiSetsBiblio.pm (-3 / +19 lines)
26	=head2 biblionumber	26	=head2 biblionumber
27		27
28	data_type: 'integer'	28	data_type: 'integer'
		29	is_foreign_key: 1
29	is_nullable: 0	30	is_nullable: 0
30		31
31	=head2 set_id	32	=head2 set_id
Lines 38-44 __PACKAGE__->table("oai_sets_biblios"); Link Here
38		39
39	__PACKAGE__->add_columns(	40	__PACKAGE__->add_columns(
40	"biblionumber",	41	"biblionumber",
41	{ data_type => "integer", is_nullable => 0 },	42	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
42	"set_id",	43	"set_id",
43	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },	44	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
44	);	45	);
Lines 59-64 __PACKAGE__->set_primary_key("biblionumber", "set_id"); Link Here
59		60
60	=head1 RELATIONS	61	=head1 RELATIONS
61		62
		63	=head2 biblionumber
		64
		65	Type: belongs_to
		66
		67	Related object: L<Koha::Schema::Result::Biblio>
		68
		69	=cut
		70
		71	__PACKAGE__->belongs_to(
		72	"biblionumber",
		73	"Koha::Schema::Result::Biblio",
		74	{ biblionumber => "biblionumber" },
		75	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
		76	);
		77
62	=head2 set	78	=head2 set
63		79
64	Type: belongs_to	80	Type: belongs_to
Lines 75-82 __PACKAGE__->belongs_to( Link Here
75	);	91	);
76		92
77		93
78	# Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-07-08 15:06:22	94	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
79	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oGVUyyyune8FVOj504xizw	95	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:X8R6Odd2qZpvrY09Z3LOhw
80		96
81		97
82	# You can replace this text with custom content, and it will be preserved on regeneration	98	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 41-53 __PACKAGE__->table("oai_sets_mappings"); Link Here

(-)a/Koha/Schema/Result/OaiSetsMapping.pm (-16 / +2 lines)
41	is_nullable: 0	41	is_nullable: 0
42	size: 1	42	size: 1
43		43
44	=head2 operator
45
46	data_type: 'varchar'
47	default_value: 'equal'
48	is_nullable: 0
49	size: 8
50
51	=head2 marcvalue	44	=head2 marcvalue
52		45
53	data_type: 'varchar'	46	data_type: 'varchar'
Lines 63-75 __PACKAGE__->add_columns( Link Here
63	{ data_type => "char", is_nullable => 0, size => 3 },	56	{ data_type => "char", is_nullable => 0, size => 3 },
64	"marcsubfield",	57	"marcsubfield",
65	{ data_type => "char", is_nullable => 0, size => 1 },	58	{ data_type => "char", is_nullable => 0, size => 1 },
66	"operator",
67	{
68	data_type => "varchar",
69	default_value => "equal",
70	is_nullable => 0,
71	size => 8,
72	},
73	"marcvalue",	59	"marcvalue",
74	{ data_type => "varchar", is_nullable => 0, size => 80 },	60	{ data_type => "varchar", is_nullable => 0, size => 80 },
75	);	61	);
Lines 92-99 __PACKAGE__->belongs_to( Link Here
92	);	78	);
93		79
94		80
95	# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21	81	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
96	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:A2fchnI85JftSuruZ1CykQ	82	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ISJose/oSjtuVo3EXLzPxA
97		83
98		84
99	# You can replace this text with custom content, and it will be preserved on regeneration	85	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 283-296 __PACKAGE__->belongs_to( Link Here

(-)a/Koha/Schema/Result/OldReserve.pm (-4 / +4 lines)
283	{	283	{
284	is_deferrable => 1,	284	is_deferrable => 1,
285	join_type => "LEFT",	285	join_type => "LEFT",
286	on_delete => "SET NULL",	286	on_delete => "CASCADE",
287	on_update => "SET NULL",	287	on_update => "CASCADE",
288	},	288	},
289	);	289	);
290		290
291		291
292	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	292	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
293	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ynb6NtiTN8ZZur2YCvxlNg	293	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VFAvF0fzXCBuzgK+hE3eHA
294		294
295		295
296	# You can replace this text with custom content, and it will be preserved on regeneration	296	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 26-32 __PACKAGE__->table("serialitems"); Link Here

(-)a/Koha/Schema/Result/Serialitem.pm (-19 / +3 lines)
26	=head2 itemnumber	26	=head2 itemnumber
27		27
28	data_type: 'integer'	28	data_type: 'integer'
29	is_foreign_key: 1
30	is_nullable: 0	29	is_nullable: 0
31		30
32	=head2 serialid	31	=head2 serialid
Lines 39-45 __PACKAGE__->table("serialitems"); Link Here
39		38
40	__PACKAGE__->add_columns(	39	__PACKAGE__->add_columns(
41	"itemnumber",	40	"itemnumber",
42	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },	41	{ data_type => "integer", is_nullable => 0 },
43	"serialid",	42	"serialid",
44	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },	43	{ data_type => "integer", is_foreign_key => 1, is_nullable => 0 },
45	);	44	);
Lines 58-78 __PACKAGE__->set_primary_key("itemnumber"); Link Here
58		57
59	=head1 RELATIONS	58	=head1 RELATIONS
60		59
61	=head2 itemnumber
62
63	Type: belongs_to
64
65	Related object: L<Koha::Schema::Result::Item>
66
67	=cut
68
69	__PACKAGE__->belongs_to(
70	"itemnumber",
71	"Koha::Schema::Result::Item",
72	{ itemnumber => "itemnumber" },
73	{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
74	);
75
76	=head2 serialid	60	=head2 serialid
77		61
78	Type: belongs_to	62	Type: belongs_to
Lines 89-96 __PACKAGE__->belongs_to( Link Here
89	);	73	);
90		74
91		75
92	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-13 13:53:21	76	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
93	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z43jqmURevaJeui7l8ThlQ	77	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qAF0pJF5e8AJzxaZqlg13w
94		78
95		79
96	# You can replace this text with custom content, and it will be preserved on regeneration	80	# You can replace this text with custom content, and it will be preserved on regeneration

Lines 32-38 __PACKAGE__->table("sessions"); Link Here

(-)a/Koha/Schema/Result/Session.pm (-4 / +4 lines)
32	=head2 a_session	32	=head2 a_session
33		33
34	data_type: 'longtext'	34	data_type: 'longtext'
35	is_nullable: 0	35	is_nullable: 1
36		36
37	=cut	37	=cut
38		38
Lines 40-46 __PACKAGE__->add_columns( Link Here
40	"id",	40	"id",
41	{ data_type => "varchar", is_nullable => 0, size => 32 },	41	{ data_type => "varchar", is_nullable => 0, size => 32 },
42	"a_session",	42	"a_session",
43	{ data_type => "longtext", is_nullable => 0 },	43	{ data_type => "longtext", is_nullable => 1 },
44	);	44	);
45		45
46	=head1 PRIMARY KEY	46	=head1 PRIMARY KEY
Lines 56-63 __PACKAGE__->add_columns( Link Here
56	__PACKAGE__->set_primary_key("id");	56	__PACKAGE__->set_primary_key("id");
57		57
58		58
59	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	59	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-11-08 11:09:51
60	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YyoQx5Kb6G7W0CVV96chpQ	60	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Y/66MvcHQG0Urlv4Q+7ItQ
61		61
62		62
63	# You can replace this text with custom content, and it will be preserved on regeneration	63	# You can replace this text with custom content, and it will be preserved on regeneration