[TYPO3-english] database problems

[Katja Lampela]

Hi,

4.8.2011 11:00, Katja Lampela kirjoitti:
> CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment,
> hash varchar(32) NOT NULL default '', content mediumblob, tstamp int(11)
> unsigned NOT NULL default '0', ident varchar(32) NOT NULL default '',
> PRIMARY KEY (id), KEY hash (hash) ) ENGINE=InnoDB;
>
> But even I hit the update button the tables don't get created.

Can you say if it would be safe to try the following:

DROP TABLE IF EXISTS cache_hash;
CREATE TABLE cache_hash ( id int(11) unsigned NOT NULL auto_increment, 
hash varchar(32) NOT NULL default '', content mediumblob, tstamp int(11) 
unsigned NOT NULL default '0', ident varchar(32) NOT NULL default '', 
PRIMARY KEY (id), KEY hash (hash) ) ENGINE=InnoDB;