DDL for a very basic SQL table.

generic-table.sql

CREATE TABLE ExampleTable (
    `id` INT UNSIGNED NOT NULL
        AUTO_INCREMENT
        PRIMARY KEY
        COMMENT 'An unsigned integer value that uniquely identifies this row among those in this table.',
    `uuid` CHAR(36) NOT NULL
        DEFAULT UUID()
        COMMENT 'A UUID (''universally unique identifier'') that can uniquely identify this row in any context.',
    `modifiedAt` DATETIME NOT NULL
        DEFAULT CURRENT_TIMESTAMP
        ON UPDATE CURRENT_TIMESTAMP
        COMMENT 'A datetime representing the moment at which this row was most recently modified.',
    `createdAt` DATETIME NOT NULL
        DEFAULT CURRENT_TIMESTAMP
        COMMENT 'A datetime representing the moment at which this row was initially created.',
    CONSTRAINT `uuid_uindex`
        UNIQUE (`uuid`)
) COMMENT 'A description of this table.'