Bug #21569 » 12613.diff
| t3lib/stddb/tables.sql (working copy) | ||
|---|---|---|
|
CREATE TABLE cache_hash (
|
||
|
id int(11) unsigned NOT NULL auto_increment,
|
||
|
hash varchar(32) DEFAULT '' NOT NULL,
|
||
|
content mediumtext,
|
||
|
content mediumblob,
|
||
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
ident varchar(32) DEFAULT '' NOT NULL,
|
||
|
PRIMARY KEY (id),
|
||
| ... | ... | |
|
id int(11) unsigned NOT NULL auto_increment,
|
||
|
identifier varchar(128) DEFAULT '' NOT NULL,
|
||
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
content mediumtext,
|
||
|
content mediumblob,
|
||
|
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (id),
|
||
|
KEY cache_id (identifier)
|
||
| typo3/sysext/cms/ext_tables.sql (working copy) | ||
|---|---|---|
|
hash varchar(32) DEFAULT '' NOT NULL,
|
||
|
page_id int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
reg1 int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
HTML mediumtext,
|
||
|
HTML mediumblob,
|
||
|
temp_content int(1) DEFAULT '0' NOT NULL,
|
||
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
expires int(10) unsigned DEFAULT '0' NOT NULL,
|
||
|
cache_data mediumtext,
|
||
|
cache_data mediumblob,
|
||
|
KEY page_id (page_id),
|
||
|
KEY sel (hash,page_id),
|
||
|
PRIMARY KEY (id)
|
||
| ... | ... | |
|
CREATE TABLE cache_pagesection (
|
||
|
page_id int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
mpvar_hash int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
content text,
|
||
|
content mediumblob,
|
||
|
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (page_id,mpvar_hash)
|
||
|
) ENGINE=InnoDB;
|
||
| ... | ... | |
|
id int(11) unsigned NOT NULL auto_increment,
|
||
|
identifier varchar(128) DEFAULT '' NOT NULL,
|
||
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
content mediumtext,
|
||
|
content mediumblob,
|
||
|
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (id),
|
||
|
KEY cache_id (identifier)
|
||
| ... | ... | |
|
id int(11) unsigned NOT NULL auto_increment,
|
||
|
identifier varchar(128) DEFAULT '' NOT NULL,
|
||
|
crdate int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
content mediumtext,
|
||
|
content mediumblob,
|
||
|
lifetime int(11) unsigned DEFAULT '0' NOT NULL,
|
||
|
PRIMARY KEY (id),
|
||
|
KEY cache_id (identifier)
|
||