Attachment #79887 for bug #17047

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

Lines 105-110 __PACKAGE__->table("saved_sql"); Link Here

(-)a/Koha/Schema/Result/SavedSql.pm (-2 / +9 lines)
105	is_nullable: 1	105	is_nullable: 1
106	size: 80	106	size: 80
107		107
		108	=head2 mana_id
		109
		110	data_type: 'integer'
		111	is_nullable: 1
		112
108	=cut	113	=cut
109		114
110	__PACKAGE__->add_columns(	115	__PACKAGE__->add_columns(
Lines 148-153 __PACKAGE__->add_columns( Link Here
148	{ data_type => "varchar", is_nullable => 1, size => 80 },	153	{ data_type => "varchar", is_nullable => 1, size => 80 },
149	"report_subgroup",	154	"report_subgroup",
150	{ data_type => "varchar", is_nullable => 1, size => 80 },	155	{ data_type => "varchar", is_nullable => 1, size => 80 },
		156	"mana_id",
		157	{ data_type => "integer", is_nullable => 1 },
151	);	158	);
152		159
153	=head1 PRIMARY KEY	160	=head1 PRIMARY KEY
Lines 163-170 __PACKAGE__->add_columns( Link Here
163	__PACKAGE__->set_primary_key("id");	170	__PACKAGE__->set_primary_key("id");
164		171
165		172
166	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	173	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-01 14:59:54
167	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7UCqSsNMGdq+S7MwZulmwA	174	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:LCYejYFk1kh9cXpH5+4GtA
168		175
169		176
170	# You can replace this text with custom content, and it will be preserved on regeneration	177	# You can replace this text with custom content, and it will be preserved on regeneration




  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

  is_nullable: 1
  size: 10

=head2 mana_id

  data_type: 'integer'
  is_nullable: 1

=cut

__PACKAGE__->add_columns(

  { 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",

  { data_type => "varchar", is_nullable => 1, size => 10 },
  "previousitemtype",
  { data_type => "varchar", is_nullable => 1, size => 10 },
  "mana_id",
  { data_type => "integer", is_nullable => 1 },
);

=head1 PRIMARY KEY

  },
);

=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-10-01 14:59:54
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cNB9GuXcgxz0IpepF12FIg


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

Return to bug 17047

Lines 113-127 __PACKAGE__->table("subscription"); Link Here

(-)a/Koha/Schema/Result/Subscription.pm (-28 / +19 lines)
113	data_type: 'integer'	113	data_type: 'integer'
114	is_nullable: 1	114	is_nullable: 1
115		115
116	=head2 innerloop1	116	=head2 lastvalue2
117		117
118	data_type: 'integer'	118	data_type: 'integer'
119	default_value: 0
120	is_nullable: 1	119	is_nullable: 1
121		120
122	=head2 lastvalue2	121	=head2 innerloop1
123		122
124	data_type: 'integer'	123	data_type: 'integer'
		124	default_value: 0
125	is_nullable: 1	125	is_nullable: 1
126		126
127	=head2 innerloop2	127	=head2 innerloop2
Lines 130-144 __PACKAGE__->table("subscription"); Link Here
130	default_value: 0	130	default_value: 0
131	is_nullable: 1	131	is_nullable: 1
132		132
133	=head2 lastvalue3	133	=head2 innerloop3
134		134
135	data_type: 'integer'	135	data_type: 'integer'
		136	default_value: 0
136	is_nullable: 1	137	is_nullable: 1
137		138
138	=head2 innerloop3	139	=head2 lastvalue3
139		140
140	data_type: 'integer'	141	data_type: 'integer'
141	default_value: 0
142	is_nullable: 1	142	is_nullable: 1
143		143
144	=head2 firstacquidate	144	=head2 firstacquidate
Lines 271-276 __PACKAGE__->table("subscription"); Link Here
271	is_nullable: 1	271	is_nullable: 1
272	size: 10	272	size: 10
273		273
		274	=head2 mana_id
		275
		276	data_type: 'integer'
		277	is_nullable: 1
		278
274	=cut	279	=cut
275		280
276	__PACKAGE__->add_columns(	281	__PACKAGE__->add_columns(
Lines 304-319 __PACKAGE__->add_columns( Link Here
304	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },	309	{ data_type => "varchar", default_value => "", is_nullable => 0, size => 100 },
305	"lastvalue1",	310	"lastvalue1",
306	{ data_type => "integer", is_nullable => 1 },	311	{ data_type => "integer", is_nullable => 1 },
307	"innerloop1",
308	{ data_type => "integer", default_value => 0, is_nullable => 1 },
309	"lastvalue2",	312	"lastvalue2",
310	{ data_type => "integer", is_nullable => 1 },	313	{ data_type => "integer", is_nullable => 1 },
		314	"innerloop1",
		315	{ data_type => "integer", default_value => 0, is_nullable => 1 },
311	"innerloop2",	316	"innerloop2",
312	{ data_type => "integer", default_value => 0, is_nullable => 1 },	317	{ data_type => "integer", default_value => 0, is_nullable => 1 },
313	"lastvalue3",
314	{ data_type => "integer", is_nullable => 1 },
315	"innerloop3",	318	"innerloop3",
316	{ data_type => "integer", default_value => 0, is_nullable => 1 },	319	{ data_type => "integer", default_value => 0, is_nullable => 1 },
		320	"lastvalue3",
		321	{ data_type => "integer", is_nullable => 1 },
317	"firstacquidate",	322	"firstacquidate",
318	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },	323	{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
319	"manualhistory",	324	"manualhistory",
Lines 358-363 __PACKAGE__->add_columns( Link Here
358	{ data_type => "varchar", is_nullable => 1, size => 10 },	363	{ data_type => "varchar", is_nullable => 1, size => 10 },
359	"previousitemtype",	364	"previousitemtype",
360	{ data_type => "varchar", is_nullable => 1, size => 10 },	365	{ data_type => "varchar", is_nullable => 1, size => 10 },
		366	"mana_id",
		367	{ data_type => "integer", is_nullable => 1 },
361	);	368	);
362		369
363	=head1 PRIMARY KEY	370	=head1 PRIMARY KEY
Lines 429-452 __PACKAGE__->belongs_to( Link Here
429	},	436	},
430	);	437	);
431		438
432	=head2 subscriptionroutinglists
433
434	Type: has_many
435
436	Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
437
438	=cut
439
440	__PACKAGE__->has_many(
441	"subscriptionroutinglists",
442	"Koha::Schema::Result::Subscriptionroutinglist",
443	{ "foreign.subscriptionid" => "self.subscriptionid" },
444	{ cascade_copy => 0, cascade_delete => 0 },
445	);
446
447		439
448	# Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:54	440	# Created by DBIx::Class::Schema::Loader v0.07046 @ 2018-10-01 14:59:54
449	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZRLfM/4h8VMLTgW7LkUYYA	441	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cNB9GuXcgxz0IpepF12FIg
450		442
451		443
452	# You can replace this text with custom content, and it will be preserved on regeneration	444	# You can replace this text with custom content, and it will be preserved on regeneration
453	-