5 description => "Set pending_offline_operations INNoDB rather than MyISAM",
8 my ($dbh, $out) = @$args{qw(dbh out)};
10 unless( TableExists( 'pending_offline_operations' ) ) {
12 CREATE TABLE `pending_offline_operations` (
13 `operationid` int(11) NOT NULL AUTO_INCREMENT,
14 `userid` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
15 `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
16 `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
17 `action` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
18 `barcode` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
19 `cardnumber` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
20 `amount` decimal(28,6) DEFAULT NULL,
21 PRIMARY KEY (`operationid`)
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
26 ALTER TABLE pending_offline_operations ENGINE = 'InnoDB';