Attachment #96096 for bug #15326

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




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

=head2 cms_pages

Type: has_many

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

=cut

__PACKAGE__->has_many(
  "cms_pages",
  "Koha::Schema::Result::CmsPage",
  { "foreign.branchcode" => "self.branchcode" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 collections

Type: has_many

);


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-09 11:09:42
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C1d0CB68P1Cb9BiPsy76NA

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




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

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

=head1 NAME

Koha::Schema::Result::CmsPage

=cut

use strict;
use warnings;

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

=head1 TABLE: C<cms_pages>

=cut

__PACKAGE__->table("cms_pages");

=head1 ACCESSORS

=head2 id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

=head2 parent

  data_type: 'integer'
  is_nullable: 1

=head2 branchcode

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

=head2 lang

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

=head2 title

  data_type: 'varchar'
  is_nullable: 1
  size: 255

=head2 title_link

  data_type: 'varchar'
  is_nullable: 1
  size: 64

=head2 sortorder

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

=head2 location

  data_type: 'tinyint'
  is_nullable: 1

=head2 publish

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

=head2 content

  data_type: 'text'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(
  "id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "parent",
  { data_type => "integer", is_nullable => 1 },
  "branchcode",
  { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
  "lang",
  { data_type => "varchar", default_value => "", is_nullable => 0, size => 25 },
  "title",
  { data_type => "varchar", is_nullable => 1, size => 255 },
  "title_link",
  { data_type => "varchar", is_nullable => 1, size => 64 },
  "sortorder",
  { data_type => "integer", default_value => 0, is_nullable => 0 },
  "location",
  { data_type => "tinyint", is_nullable => 1 },
  "publish",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
  "content",
  { data_type => "text", is_nullable => 1 },
);

=head1 PRIMARY KEY

=over 4

=item * L</id>

=back

=cut

__PACKAGE__->set_primary_key("id");

=head1 RELATIONS

=head2 branchcode

Type: belongs_to

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

=cut

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


# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-09 11:09:42
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H4DgFy4SiqaFdhEm7xA6nw

__PACKAGE__->add_columns (
    '+location' => { is_boolean => 1 },
    '+publish' => { is_boolean => 1 },
);

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

Return to bug 15326

Lines 466-471 __PACKAGE__->has_many( Link Here

(-)a/Koha/Schema/Result/Branch.pm (-2 / +17 lines)
466	{ cascade_copy => 0, cascade_delete => 0 },	466	{ cascade_copy => 0, cascade_delete => 0 },
467	);	467	);
468		468
		469	=head2 cms_pages
		470
		471	Type: has_many
		472
		473	Related object: L<Koha::Schema::Result::CmsPage>
		474
		475	=cut
		476
		477	__PACKAGE__->has_many(
		478	"cms_pages",
		479	"Koha::Schema::Result::CmsPage",
		480	{ "foreign.branchcode" => "self.branchcode" },
		481	{ cascade_copy => 0, cascade_delete => 0 },
		482	);
		483
469	=head2 collections	484	=head2 collections
470		485
471	Type: has_many	486	Type: has_many
Lines 707-714 __PACKAGE__->has_many( Link Here
707	);	722	);
708		723
709		724
710	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-10-14 09:59:52	725	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-09 11:09:42
711	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vWDJAm3K2jiyRS3htyip6A	726	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C1d0CB68P1Cb9BiPsy76NA
712		727
713	__PACKAGE__->add_columns(	728	__PACKAGE__->add_columns(
714	'+pickup_location' => { is_boolean => 1 }	729	'+pickup_location' => { is_boolean => 1 }

Line 0 Link Here

(-)a/Koha/Schema/Result/CmsPage.pm (-1 / +154 lines)
0	-	1	use utf8;
		2	package Koha::Schema::Result::CmsPage;
		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::CmsPage
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<cms_pages>
		19
		20	=cut
		21
		22	__PACKAGE__->table("cms_pages");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	=head2 parent
		33
		34	data_type: 'integer'
		35	is_nullable: 1
		36
		37	=head2 branchcode
		38
		39	data_type: 'varchar'
		40	is_foreign_key: 1
		41	is_nullable: 1
		42	size: 10
		43
		44	=head2 lang
		45
		46	data_type: 'varchar'
		47	default_value: (empty string)
		48	is_nullable: 0
		49	size: 25
		50
		51	=head2 title
		52
		53	data_type: 'varchar'
		54	is_nullable: 1
		55	size: 255
		56
		57	=head2 title_link
		58
		59	data_type: 'varchar'
		60	is_nullable: 1
		61	size: 64
		62
		63	=head2 sortorder
		64
		65	data_type: 'integer'
66	default_value: 0
67	is_nullable: 0
68
69	=head2 location
70
71	data_type: 'tinyint'
72	is_nullable: 1
73
74	=head2 publish
75
76	data_type: 'tinyint'
77	default_value: 0
78	is_nullable: 0
79
80	=head2 content
81
82	data_type: 'text'
83	is_nullable: 1
84
85	=cut
86
87	__PACKAGE__->add_columns(
88	"id",
89	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
90	"parent",
91	{ data_type => "integer", is_nullable => 1 },
92	"branchcode",
93	{ data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
94	"lang",
95	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 25 },
96	"title",
97	{ data_type => "varchar", is_nullable => 1, size => 255 },
98	"title_link",
99	{ data_type => "varchar", is_nullable => 1, size => 64 },
100	"sortorder",
101	{ data_type => "integer", default_value => 0, is_nullable => 0 },
102	"location",
103	{ data_type => "tinyint", is_nullable => 1 },
104	"publish",
105	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
106	"content",
107	{ data_type => "text", is_nullable => 1 },
108	);
109
110	=head1 PRIMARY KEY
111
112	=over 4
113
114	=item * L</id>
115
116	=back
117
118	=cut
119
120	__PACKAGE__->set_primary_key("id");
121
122	=head1 RELATIONS
123
124	=head2 branchcode
125
126	Type: belongs_to
127
128	Related object: L<Koha::Schema::Result::Branch>
129
130	=cut
131
132	__PACKAGE__->belongs_to(
133	"branchcode",
134	"Koha::Schema::Result::Branch",
135	{ branchcode => "branchcode" },
136	{
137	is_deferrable => 1,
138	join_type => "LEFT",
139	on_delete => "CASCADE",
140	on_update => "CASCADE",
141	},
142	);
143
144
145	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-12-09 11:09:42
146	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:H4DgFy4SiqaFdhEm7xA6nw
147
148	__PACKAGE__->add_columns (
149	'+location' => { is_boolean => 1 },
150	'+publish' => { is_boolean => 1 },
151	);
152
153	# You can replace this text with custom code or comments, and it will be preserved on regeneration
154	1;