CREATE TABLE click (
id INT AUTO_INCREMENT NOT NULL,
abonent_uuid CHAR(36) NOT NULL,
transport_type VARCHAR(255) NOT NULL,
sender VARCHAR(255) NOT NULL,
text VARCHAR(4096) NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
CONSTRAINT IDX_96042B4AA3ECEA29 FOREIGN KEY (abonent_uuid) REFERENCES abonents (uuid),
PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB
SQL;
SELECT * FROM click;