Bugzilla – Attachment 79035 Details for
Bug 17015
New Koha Calendar
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 17015: (follow-up) keep kohastructure.sql clean to avoid bugs when installing a fresh koha directly over this patchset
Bug-17015-follow-up-keep-kohastructuresql-clean-to.patch (text/plain), 3.50 KB, created by
Charles Farmer
on 2018-09-17 18:21:34 UTC
(
hide
)
Description:
Bug 17015: (follow-up) keep kohastructure.sql clean to avoid bugs when installing a fresh koha directly over this patchset
Filename:
MIME Type:
Creator:
Charles Farmer
Created:
2018-09-17 18:21:34 UTC
Size:
3.50 KB
patch
obsolete
>From 17aebfc868f332b57dd70b39d99d876e651b7984 Mon Sep 17 00:00:00 2001 >From: Charles Farmer <charles.farmer@inLibro.com> >Date: Mon, 17 Sep 2018 11:59:59 -0400 >Subject: [PATCH] Bug 17015: (follow-up) keep kohastructure.sql clean to avoid > bugs when installing a fresh koha directly over this patchset > >--- > installer/data/mysql/kohastructure.sql | 49 +++++++++++++++++++++++----------- > 1 file changed, 33 insertions(+), 16 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 941390e..3048ade 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -683,22 +683,6 @@ CREATE TABLE `deleteditems` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >--- Table structure for table `discrete_calendar` >--- >- >-DROP TABLE IF EXISTS `discrete_calendar`; >-CREATE TABLE `discrete_calendar` ( >- `date` datetime NOT NULL, >- `branchcode` varchar(10) NOT NULL, >- `is_opened` tinyint(1) DEFAULT 1, >- `holiday_type` varchar(1) DEFAULT '', >- `note` varchar(30) DEFAULT '', >- `open_hour` time NOT NULL, >- `close_hour` time NOT NULL, >- PRIMARY KEY (`branchcode`,`date`) >-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >- >--- > -- Table structure for table `export_format` > -- > >@@ -1398,6 +1382,22 @@ CREATE TABLE `printers_profile` ( > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >+-- Table structure for table `repeatable_holidays` >+-- >+ >+DROP TABLE IF EXISTS `repeatable_holidays`; >+CREATE TABLE `repeatable_holidays` ( -- information for the days the library is closed >+ `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha >+ `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for >+ `weekday` smallint(6) default NULL, -- day of the week (0=Sunday, 1=Monday, etc) this closing is repeated on >+ `day` smallint(6) default NULL, -- day of the month this closing is on >+ `month` smallint(6) default NULL, -- month this closing is in >+ `title` varchar(50) NOT NULL default '', -- title of this closing >+ `description` MEDIUMTEXT NOT NULL, -- description for this closing >+ PRIMARY KEY (`id`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ >+-- > -- Table structure for table `reports_dictionary` > -- > >@@ -1955,6 +1955,23 @@ CREATE TABLE `reviews` ( -- patron opac comments > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > > -- >+-- Table structure for table `special_holidays` >+-- >+ >+DROP TABLE IF EXISTS `special_holidays`; >+CREATE TABLE `special_holidays` ( -- non repeatable holidays/library closings >+ `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha >+ `branchcode` varchar(10) NOT NULL default '', -- foreign key from the branches table, defines which branch this closing is for >+ `day` smallint(6) NOT NULL default 0, -- day of the month this closing is on >+ `month` smallint(6) NOT NULL default 0, -- month this closing is in >+ `year` smallint(6) NOT NULL default 0, -- year this closing is in >+ `isexception` smallint(1) NOT NULL default 1, -- is this a holiday exception to a repeatable holiday (1 for yes, 0 for no) >+ `title` varchar(50) NOT NULL default '', -- title for this closing >+ `description` MEDIUMTEXT NOT NULL, -- description of this closing >+ PRIMARY KEY (`id`) >+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; >+ >+-- > -- Table structure for table `statistics` > -- > >-- >2.7.4
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 17015
:
53859
|
54318
|
54419
|
59166
|
59167
|
59168
|
59169
|
59170
|
59171
|
59267
|
59268
|
59269
|
59270
|
59271
|
59463
|
59516
|
59517
|
59518
|
59519
|
59520
|
59561
|
59562
|
59586
|
59587
|
59888
|
59889
|
60902
|
60903
|
60904
|
60905
|
60906
|
60986
|
61737
|
62375
|
62376
|
62380
|
63257
|
63282
|
63362
|
63363
|
63364
|
63365
|
63366
|
63367
|
64235
|
65073
|
65074
|
65075
|
65076
|
65077
|
67721
|
67722
|
67723
|
67724
|
67725
|
67879
|
67929
|
67930
|
67931
|
67932
|
67933
|
67934
|
68392
|
68393
|
68394
|
68395
|
68396
|
68397
|
71634
|
71635
|
71636
|
71637
|
71638
|
72890
|
73145
|
74859
|
74860
|
74861
|
74862
|
74863
|
74864
|
74865
|
74866
|
75444
|
75479
|
76594
|
77249
|
77250
|
77607
|
77608
|
77609
|
77610
|
77611
|
77612
|
77613
|
77770
|
77771
|
77772
|
77773
|
77774
|
79035
|
80523
|
80524
|
80525
|
80526
|
80527
|
80528
|
80529
|
80530
|
80531
|
80532
|
80533
|
80534
|
80535
|
83547
|
85394
|
85677
|
85678
|
85679
|
85680
|
85681
|
85682
|
85683
|
85684
|
85685
|
85686
|
85687
|
85688
|
85689
|
85690
|
85691
|
92595
|
92596
|
92597
|
92598
|
100079
|
110383
|
110384
|
110386
|
110387
|
110388
|
110389
|
113541
|
113905
|
115501
|
115502
|
115503
|
115504
|
115505
|
115506
|
115507
|
115508
|
115509
|
115510
|
115511
|
118554
|
118555
|
118556
|
118557
|
118558
|
118559
|
119095
|
119097
|
119099
|
119100
|
119101
|
119102
|
131619
|
131620
|
131621
|
131622
|
131623
|
131624
|
131625
|
131626
|
131634
|
131635
|
131636
|
131637
|
131638
|
131639
|
131640
|
131641
|
131667
|
132199
|
133596
|
133597
|
133598
|
133599
|
133600
|
133601
|
133602
|
133603
|
133604
|
133605
|
133678
|
137219
|
137220
|
137221
|
137222
|
137223
|
137224
|
137225
|
137226
|
137227
|
137228
|
137229
|
139378
|
139379
|
139380
|
139381
|
139382
|
139599
|
139600
|
139601
|
139602
|
139603
|
139851
|
140150
|
141176
|
144257
|
144258
|
144259
|
144260
|
144261
|
144262
|
144264
|
144268
|
144269
|
144270
|
144271
|
144272
|
144273
|
151438
|
151439
|
151440
|
151441
|
151442
|
151443
|
151444
|
151445
|
151446
|
151447
|
151448
|
151449
|
151450
|
156340
|
156341
|
156342
|
156343
|
156344
|
156345
|
156346
|
156347
|
156348
|
156349
|
156350
|
156351
|
156352
|
156353
|
156354
|
156355
|
157656
|
157657
|
157658
|
157659
|
157660
|
157661
|
157662
|
157663
|
157664
|
157665
|
157666
|
157667
|
157668
|
157669
|
157670
|
157671
|
157672
|
167805
|
167806
|
167807
|
167808
|
167809