[TASK] Relocate cache backend sql resource files
[Packages/TYPO3.CMS.git] / typo3 / sysext / core / Resources / Private / Sql / Cache / Backend / PdoBackendCacheAndTags.sql
1 BEGIN;
2
3 CREATE TABLE "cache" (
4 "identifier" VARCHAR(250) NOT NULL,
5 "cache" VARCHAR(250) NOT NULL,
6 "context" VARCHAR(150) NOT NULL,
7 "created" INTEGER UNSIGNED NOT NULL,
8 "lifetime" INTEGER UNSIGNED DEFAULT '0' NOT NULL,
9 "content" TEXT,
10 PRIMARY KEY ("identifier", "cache", "context")
11 );
12
13 CREATE TABLE "tags" (
14 "identifier" VARCHAR(250) NOT NULL,
15 "cache" VARCHAR(250) NOT NULL,
16 "context" VARCHAR(150) NOT NULL,
17 "tag" VARCHAR(250) NOT NULL
18 );
19 CREATE INDEX "identifier" ON "tags" ("identifier", "cache", "context");
20 CREATE INDEX "tag" ON "tags" ("tag");
21
22 COMMIT;