Engines in create table form

Engines in create table form

I'm using MariaDB. It has storage engine XtraDB. Pity that it is not listed. Also would be greate to skip this option, because MariaDB could has default storage engine, now it's impossible to leave this field empty.

Thanks.

Probably I can add a "Default" option in the engine drop down, which then leaves the ENGINE=xyz clause just away from the CREATE TABLE code.

r5153 adds such a "Server default" drop down item, which then leaves the ENGINE clause away. This is also the new default when creating a new table.

Thanks.

Would it be possible to append "XtraDB" to engines list?

If XtraDB would show up in the result of

SHOW ENGINES;

... then it should already be displayed. But if I understand the documentation right, XtraDB is a drop-in-replacement for the InnoDB engine, and it replaces InnoDB, instead of offering a new engine. With the SHOW ENGINES query, you have to watch out in the Comment field of the InnoDB row, to see whether it's InnoDB or XtraDB. Here's my result on a MariaDB 10.0.25 server, copied to clipboard with HeidiSQL's grid export dialog, in Markdown format:

ENGINES

OK. Thank you.

Hi, I'm using HeidiSQL for PostgreSQL 11 on Windows 10 and am having trouble with the engines. The engine is currently set to <Server defualt> (not sure what that is?) and there are no other options for it. My main problem is that currently foreign keys are not allowed with this server. When I click on the foreign key tab of my table it says "The selected table engine (<server default>) does not support foreign keys.

Is there a way to change this?

Running the query

SHOW ENGINES;

gives the error:

ERROR: unrecognized configuration parameter "engines"

Thanks very much.