Bugzilla – Attachment 101580 Details for
Bug 15326
Add CMS feature
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15326: DO NOT PUSH - Schema changes
Bug-15326-DO-NOT-PUSH---Schema-changes.patch (text/plain), 4.24 KB, created by
Nick Clemens (kidclamp)
on 2020-03-24 13:40:35 UTC
(
hide
)
Description:
Bug 15326: DO NOT PUSH - Schema changes
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2020-03-24 13:40:35 UTC
Size:
4.24 KB
patch
obsolete
>From 36e9e9ccf500ae3bd2d6bb3ae8a151243841422d Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Tue, 24 Mar 2020 12:13:27 +0000 >Subject: [PATCH] Bug 15326: DO NOT PUSH - Schema changes > >--- > Koha/Schema/Result/Branch.pm | 19 +++++- > Koha/Schema/Result/CmsPage.pm | 150 ++++++++++++++++++++++++++++++++++++++++++ > 2 files changed, 167 insertions(+), 2 deletions(-) > create mode 100644 Koha/Schema/Result/CmsPage.pm > >diff --git a/Koha/Schema/Result/Branch.pm b/Koha/Schema/Result/Branch.pm >index 92aa05b220..8e14817b11 100644 >--- a/Koha/Schema/Result/Branch.pm >+++ b/Koha/Schema/Result/Branch.pm >@@ -458,6 +458,21 @@ __PACKAGE__->has_many( > { 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 >@@ -729,8 +744,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-10 09:57:08 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:juk2V/100I2EIrxFNhjI7A >+# Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-24 11:48:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o2D3F6aSr3Hs5TU6A2DAuQ > > __PACKAGE__->add_columns( > '+pickup_location' => { is_boolean => 1 } >diff --git a/Koha/Schema/Result/CmsPage.pm b/Koha/Schema/Result/CmsPage.pm >new file mode 100644 >index 0000000000..d5f71e30ff >--- /dev/null >+++ b/Koha/Schema/Result/CmsPage.pm >@@ -0,0 +1,150 @@ >+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 @ 2020-03-24 11:48:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3dEBop3bV7JUyl768HVlbg >+ >+ >+# You can replace this text with custom code or comments, and it will be preserved on regeneration >+1; >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 15326
:
45621
|
58272
|
58607
|
58608
|
58609
|
58787
|
63904
|
63905
|
64241
|
64941
|
64942
|
66255
|
70866
|
70867
|
70868
|
70869
|
70870
|
70871
|
76387
|
76388
|
76389
|
76390
|
76391
|
76392
|
78232
|
78233
|
78234
|
78235
|
78236
|
78237
|
78238
|
78240
|
79269
|
83318
|
83319
|
83320
|
83321
|
83322
|
83323
|
83324
|
83325
|
83326
|
83404
|
83405
|
83406
|
83407
|
83408
|
83409
|
83410
|
83411
|
83412
|
84682
|
84683
|
84684
|
84685
|
84686
|
84687
|
84688
|
84689
|
84690
|
84691
|
87494
|
87495
|
87496
|
87497
|
87498
|
87499
|
87500
|
87501
|
87502
|
87503
|
87608
|
87609
|
87610
|
87617
|
96084
|
96085
|
96086
|
96087
|
96088
|
96089
|
96090
|
96091
|
96092
|
96093
|
96094
|
96095
|
96096
|
96097
|
96098
|
97237
|
101565
|
101566
|
101567
|
101568
|
101569
|
101570
|
101571
|
101572
|
101573
|
101574
|
101575
|
101576
|
101577
|
101578
|
101579
|
101580
|
128341
|
128342
|
128343
|
128344
|
128345
|
128346
|
128347
|
128348
|
128349
|
128350
|
128351
|
128352
|
128353
|
128354
|
128355
|
128356
|
128357
|
128585
|
128642
|
136432
|
136757
|
136768
|
138489
|
138493
|
139028
|
139029
|
139030
|
139031
|
139111
|
139123
|
139124
|
139125
|
139172
|
139173
|
139174