Query used to create this table - show create index statements

[Nicholas Schild]

Hello,

It would be great if the "Query used to create this table" section included the "create index" statements. It would make it a lot easier to have access to the whole table schema vs dropping the table, only to find out that you forgot to note how the indexes were constructed.

[phpLiteAdmin]

You can export the table as SQL to get the whole SQL to recreate the schema. If you don't want the data in the dump, uncheck the "Export with data" checkbox.

• click on the table on the left
• click on the export tab
• make sure "SQL" is selected
• make sure "Export with structure" is selected
• uncheck "Export with data" as needed
• click Export

[phpLiteAdmin]

Query used to create this table: show create index and trigger statements fixes issue #356

→ <<cset f1a445d5b7e5>>