Bug #39699

SQL DDL for TYPO3\FLOW3\Cache\Backend\PdoBackend

Added by Pablo Delgado about 9 years ago. Updated almost 9 years ago.

Status:
Accepted
Priority:
Should have
Category:
Cache
Target version:
-
Start date:
2012-08-11
Due date:
% Done:

0%

Estimated time:
PHP Version:
5.3
Has patch:
No
Complexity:

Description

I could not find any example or script that helped create the tables needed to use TYPO3\FLOW3\Cache\Backend\PdoBackend.
It would be nice if the Backed could generate the tables needed during the execution of flow3:cache:warmup or at the vary least example DDL script that developers can use to generate the tables needed.

Here is the DDL for PostgreSQL (It may work for MYSQL with no changes)

create table cache (
"identifier" varchar primary key, "context" varchar, "cache" text, "created" int, "lifetime" int, "content" varchar);

create table tags (
"identifier"varchar primary key, "context" varchar, "cache" text, "tag" varchar);

#1

Updated by Karsten Dambekalns about 9 years ago

  • Status changed from New to Accepted
  • Assignee set to Karsten Dambekalns
  • Target version deleted (1.1)

Also available in: Atom PDF