# Structure of Exported Files: `DDL` Files

+ **`{schema}-schema-create.sql`**: The `SQL` file that can create the schema
+ **`{schema}.{table}-schema.sql`**: The `SQL` file that can create the table

```
$ cat ~!@universe-schema-create.sql@!~ 
/*!40101 SET NAMES binary*/;
~!@CREATE DATABASE@!~ `universe` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

$ cat ~!@universe.planets-schema.sql@!~ 
/*!40101 SET NAMES binary*/;
~!@CREATE TABLE@!~ `planets` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` char(20) NOT NULL DEFAULT '',
  `mass` float NOT NULL DEFAULT '0.0' COMMENT '10**24 kg',
  ...
  `sun_id` bigint(20) NOT NULL,
  `category_id` int(11) NOT NULL,
  `discover_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
  KEY `name` (`name`),
  CONSTRAINT `planet_sun_fk` FOREIGN KEY (`sun_id`) REFERENCES `stars` (`id`),
  CONSTRAINT `planet_cat_fk` FOREIGN KEY (`category_id`) REFERENCES `planet_categories` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=280557;
```
----------------------------------------------------------------------------------------------
[no notes]