Bug #39699

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

Added by Pablo Delgado almost 3 years ago. Updated over 2 years ago.

Status:Accepted Start date:2012-08-11
Priority:Should have Due date:
Assigned To:Karsten Dambekalns % Done:

0%
Category:Cache
Target version:-
PHP Version:5.3 Complexity:
Has patch:No Affected Flow version:Git master

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);

History

#1 Updated by Karsten Dambekalns almost 3 years ago

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

#2 Updated by Karsten Dambekalns over 2 years ago

  • Affected Flow version changed from Git 1.2 (master) to Git master

Also available in: Atom PDF