Bugzilla – Attachment 91596 Details for
Bug 23321
Add 'cash registers' to the accounts system
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23321: Add cash_registers table
Bug-23321-Add-cashregisters-table.patch (text/plain), 3.48 KB, created by
Martin Renvoize (ashimema)
on 2019-07-18 16:12:10 UTC
(
hide
)
Description:
Bug 23321: Add cash_registers table
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-07-18 16:12:10 UTC
Size:
3.48 KB
patch
obsolete
>From 5072415cd8ad96ec8d454f3e7b5306e03eb1653b Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Tue, 16 Jul 2019 15:16:18 +0100 >Subject: [PATCH] Bug 23321: Add cash_registers table > >--- > .../data/mysql/atomicupdate/bug_23321.perl | 21 +++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 18 ++++++++++++++++ > 2 files changed, 39 insertions(+) > create mode 100644 installer/data/mysql/atomicupdate/bug_23321.perl > >diff --git a/installer/data/mysql/atomicupdate/bug_23321.perl b/installer/data/mysql/atomicupdate/bug_23321.perl >new file mode 100644 >index 0000000000..db8044cafc >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_23321.perl >@@ -0,0 +1,21 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if ( CheckVersion($DBversion) ) { >+ >+ $dbh->do(qq{ >+CREATE TABLE `cash_registers` ( >+ `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register >+ `name` varchar(24) NOT NULL, -- the user friendly identifier for each account register >+ `description` longtext NOT NULL, -- the user friendly description for each account register >+ `branch` varchar(10) NOT NULL, -- the foreign key the library this account register belongs >+ `branch_default` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote that this till is the branch default >+ `starting_float` decimal(28, 6), -- the starting float this account register should be assigned >+ `archived` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote if this till is archived or not >+ PRIMARY KEY (`id`), >+ UNIQUE KEY `name` (`name`,`branch`), >+ CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; >+ }); >+ >+ SetVersion($DBversion); >+ print "Upgrade to $DBversion done (Bug 23321 - Add cash_registers table)\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 2c7f361f9b..235521f48f 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -2655,6 +2655,24 @@ CREATE TABLE `account_offsets` ( > CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > >+-- >+-- Table structure for table `cash_registers` >+-- >+ >+DROP TABLE IF EXISTS `cash_registers`; >+CREATE TABLE `cash_registers` ( >+ `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register >+ `name` varchar(24) NOT NULL, -- the user friendly identifier for each account register >+ `description` longtext NOT NULL, -- the user friendly description for each account register >+ `branch` varchar(10) NOT NULL, -- the foreign key the library this account register belongs >+ `branch_default` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote that this till is the branch default >+ `starting_float` decimal(28, 6), -- the starting float this account register should be assigned >+ `archived` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote if this till is archived or not >+ PRIMARY KEY (`id`), >+ UNIQUE KEY `name` (`name`,`branch`), >+ CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE >+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; >+ > -- > -- Table structure for table `action_logs` > -- >-- >2.20.1
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 23321
:
91596
|
91597
|
91598
|
91599
|
91600
|
91601
|
91602
|
91621
|
92057
|
92058
|
92059
|
92060
|
92061
|
92062
|
92063
|
92064
|
92065
|
92083
|
92084
|
92085
|
92086
|
92087
|
92088
|
92089
|
92090
|
92091
|
92394
|
92395
|
92396
|
92397
|
92398
|
92399
|
92400
|
92401
|
92402
|
92467
|
92468
|
92469
|
92470
|
92471
|
92472
|
92473
|
92474
|
92475
|
92803
|
92804
|
92805
|
92806
|
92807
|
92808
|
92809
|
92810
|
92811
|
92812
|
92813
|
92814
|
92829
|
92879
|
92880
|
92881
|
92882
|
92883
|
92884
|
92885
|
92886
|
92887
|
92888
|
92889
|
93019
|
93020
|
93021
|
93022
|
93023
|
93024
|
93025
|
93026
|
93027
|
93028
|
93029
|
93030
|
93031
|
93032
|
93033
|
93034
|
93035
|
93188