[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