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

(-)a/installer/data/mysql/kohastructure.sql (-14 / +15 lines)
Lines 1362-1381 CREATE TABLE pending_offline_operations ( Link Here
1362
  PRIMARY KEY (operationid)
1362
  PRIMARY KEY (operationid)
1363
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1363
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1364
1364
1365
--
1366
-- Table structure for table `pos_terminal_transactions`
1367
--
1368
1369
CREATE TABLE `pos_terminal_transactions` (
1370
  `id` int(11) NOT NULL AUTO_INCREMENT,
1371
  `accountlines_id` int(11) NOT NULL,
1372
  `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
1373
  `response_code` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1374
  `message_log` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1375
  PRIMARY KEY (`id`),
1376
  KEY `accountlines_id` (`accountlines_id`),
1377
  CONSTRAINT `pos_terminal_transactions_ibfk1` FOREIGN KEY (`accountlines_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE
1378
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1379
1365
1380
--
1366
--
1381
-- Table structure for table `printers`
1367
-- Table structure for table `printers`
Lines 2737-2742 CREATE TABLE `accountoffsets` ( Link Here
2737
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2723
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2738
2724
2739
--
2725
--
2726
-- Table structure for table `pos_terminal_transactions`
2727
--
2728
2729
CREATE TABLE `pos_terminal_transactions` (
2730
  `id` int(11) NOT NULL AUTO_INCREMENT,
2731
  `accountlines_id` int(11) NOT NULL,
2732
  `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
2733
  `response_code` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
2734
  `message_log` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
2735
  PRIMARY KEY (`id`),
2736
  KEY `accountlines_id` (`accountlines_id`),
2737
  CONSTRAINT `pos_terminal_transactions_ibfk1` FOREIGN KEY (`accountlines_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE
2738
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2739
2740
--
2740
-- Table structure for table `action_logs`
2741
-- Table structure for table `action_logs`
2741
--
2742
--
2742
2743
(-)a/installer/data/mysql/sysprefs.sql (-2 / +1 lines)
Lines 410-416 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
410
('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
410
('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
411
('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
411
('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
412
('Persona','0','','Use Mozilla Persona for login','YesNo'),
412
('Persona','0','','Use Mozilla Persona for login','YesNo'),
413
('PosTerminalCurrencyCode',  '', NULL ,  'POS Terminal currency code number',  'Integer')
413
('PosTerminalCurrencyCode',  '', NULL ,  'POS Terminal currency code number',  'Integer'),
414
('PosTerminalIP',  '', NULL ,  'POS Terminal IP address',  'Free'),
414
('PosTerminalIP',  '', NULL ,  'POS Terminal IP address',  'Free'),
415
('PosTerminalPort',  '', NULL ,  'POS Terminal port',  'Integer'),
415
('PosTerminalPort',  '', NULL ,  'POS Terminal port',  'Integer'),
416
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
416
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
417
- 

Return to bug 17705