[TYPO3-core] database indexes

Peter Niederlag peter.niederlag at typo3.org
Mon Aug 19 13:42:09 CEST 2013


Hello Steffen,

works here, see below. Maybe the charset is not loadad/available? Maybe
any other required module for mysql is not loadad? Other than that:
check filesystem permissions (again).

Greets and hth,
Peter

P.S.:
mysql> create database foo;
Query OK, 1 row affected (0.00 sec)

mysql> use foo
Database changed
mysql>
mysql> CREATE TABLE `cf_extbase_reflection` (
    ->  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    ->  `identifier` varchar(250) NOT NULL DEFAULT '',
    ->  `expires` int(11) unsigned NOT NULL DEFAULT '0',
    ->  `content` mediumblob,
    ->  PRIMARY KEY (`id`),
    ->  KEY `cache_id` (`identifier`,`expires`)
    -> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.05 sec)

mysql>

On 19.08.2013 13:21, Steffen Kamper wrote:
> 
> CREATE TABLE `cf_extbase_reflection` (
>  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
>  `identifier` varchar(250) NOT NULL DEFAULT '',
>  `expires` int(11) unsigned NOT NULL DEFAULT '0',
>  `content` mediumblob,
>  PRIMARY KEY (`id`),
>  KEY `cache_id` (`identifier`,`expires`)
> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;



More information about the TYPO3-team-core mailing list