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

(-)a/installer/data/mysql/atomicupdate/bug_14826.sql (-3 / +4 lines)
Lines 1-4 Link Here
1
CREATE TABLE `account_offset_types` (
1
DROP TABLE IF EXISTS `accountoffsets`;
2
3
CREATE TABLE IF NOT EXISTS `account_offset_types` (
2
  `type` varchar(16) NOT NULL, -- The type of offset this is
4
  `type` varchar(16) NOT NULL, -- The type of offset this is
3
  PRIMARY KEY (`type`)
5
  PRIMARY KEY (`type`)
4
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
6
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Lines 16-22 CREATE TABLE IF NOT EXISTS `account_offsets` ( Link Here
16
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
18
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
17
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
18
20
19
INSERT INTO account_offset_types ( type ) VALUES
21
INSERT IGNORE INTO account_offset_types ( type ) VALUES
20
('Writeoff'),
22
('Writeoff'),
21
('Payment'),
23
('Payment'),
22
('Lost Item'),
24
('Lost Item'),
23
- 

Return to bug 14826