-- source: reduced from go-zero tools/goctl/model/sql/parser/testdata/user.sql for rs-zero compatibility tests.
CREATE TABLE `user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary id',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'display name, can contain comma',
  `email` varchar(255) NOT NULL COMMENT 'login email',
  `mobile` varchar(32) DEFAULT NULL COMMENT 'mobile phone',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'update time',
  `profile` text COMMENT 'line one
line two',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_email_mobile` (`email`,`mobile`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='user table';
