#528 Transpose cache table columns to rows.

[Stéphane Aulery]

Transpose cache table columns to rows. and add a primary key like temp_storage table.

CREATE TABLE IF NOT EXISTS `cache` (
  `cacheId` varchar(256) NOT NULL,
  -- Data serialized with serialize()
  `cacheData` LONGBLOB DEFAULT NULL,
  `cacheTimestamp` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`cacheId`),
  KEY (`cacheTimestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;

[Stéphane Aulery]

Implemented by revision [r3870].

[Mark Grimshaw]

Confirming that this works for upgrade and a new installation.

Mark

[Stéphane Aulery]

Ok, thanks. Without an id tools like phpMyAdmin or Adminer cannot edit the fields.

[Stéphane Aulery]

Tested and OK.