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

(-)a/installer/data/mysql/atomicupdate/bug_23321.perl (-15 / +16 lines)
Lines 1-20 Link Here
1
$DBversion = 'XXX';    # will be replaced by the RM
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
2
if ( CheckVersion($DBversion) ) {
3
3
4
    $dbh->do(qq{
4
    unless ( TableExists( 'cash_registers' ) ) {
5
CREATE TABLE `cash_registers` (
5
        $dbh->do(qq{
6
  `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register
6
    CREATE TABLE `cash_registers` (
7
  `name` varchar(24) NOT NULL, -- the user friendly identifier for each account register
7
    `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register
8
  `description` longtext NOT NULL, -- the user friendly description for each account register
8
    `name` varchar(24) NOT NULL, -- the user friendly identifier for each account register
9
  `branch` varchar(10) NOT NULL, -- the foreign key the library this account register belongs
9
    `description` longtext NOT NULL, -- the user friendly description for each account register
10
  `branch_default` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote that this till is the branch default
10
    `branch` varchar(10) NOT NULL, -- the foreign key the library this account register belongs
11
  `starting_float` decimal(28, 6), -- the starting float this account register should be assigned
11
    `branch_default` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote that this till is the branch default
12
  `archived` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote if this till is archived or not
12
    `starting_float` decimal(28, 6), -- the starting float this account register should be assigned
13
  PRIMARY KEY (`id`),
13
    `archived` tinyint(1) NOT NULL DEFAULT 0, -- boolean flag to denote if this till is archived or not
14
  UNIQUE KEY `name` (`name`,`branch`),
14
    PRIMARY KEY (`id`),
15
  CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE
15
    UNIQUE KEY `name` (`name`,`branch`),
16
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
16
    CONSTRAINT cash_registers_branch FOREIGN KEY (branch) REFERENCES branches (branchcode) ON UPDATE CASCADE ON DELETE CASCADE
17
    });
17
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
18
        });
19
    }
18
20
19
    unless ( column_exists( 'accountlines', 'register_id' ) ) {
21
    unless ( column_exists( 'accountlines', 'register_id' ) ) {
20
        $dbh->do(qq{ALTER TABLE `accountlines` ADD `register_id` int(11) NULL DEFAULT NULL AFTER `manager_id`});
22
        $dbh->do(qq{ALTER TABLE `accountlines` ADD `register_id` int(11) NULL DEFAULT NULL AFTER `manager_id`});
21
- 

Return to bug 23321