CREATE TABLE yourTABLE_table_nameNAME (
`id` bigint(20) NOT idNULL INT AUTO_INCREMENT,
PRIMARY KEY,
user_id INT `user_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`domain_id` int(11) NOT NULL, DEFAULT 1,
domain `doc_id INTid` bigint(20) NOT NULL,
`json` longtext COLLATE doc_id INTutf8mb4_unicode_ci NOT NULL,
`created_at` datetime NOT NULL json JSON NOT NULL,
create_at DATETIME DEFAULT CURRENT_TIMESTAMP
)DEFAULT current_timestamp(),
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=671 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|