This is the default PMA output of an export:
CREATE TABLE `foo` (
`id` int(11) UNSIGNED NOT NULL,
`fk_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `foo`
ADD PRIMARY KEY (`id`);
ALTER TABLE `foo`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `foo`
ADD CONSTRAINT `foo_ibfk_1` FOREIGN KEY (`fk_id`) REFERENCES `bar` (`id`),
...
Is there a way to get an export where all of the following ALTER TABLE
are merged into the CREATE TABLE
statement?
Best Answer
I shows all changes you have made, as you can see in the example
Schema (MySQL v8.0)
Query #1
View on DB Fiddle