Bug #39699

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

Added by Pablo Delgado 10 months ago. Updated 6 months ago.

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

0%
Category:Cache
Target version:-
PHP Version:5.3 Complexity:
Has patch:No FLOW3 version affected:Git master
Votes: 0

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 10 months ago

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

#2
Updated by Karsten Dambekalns 6 months ago

  • FLOW3 version affected changed from Git 1.2 (master) to Git master

Also available in: Atom PDF