github.com/wangyougui/gf/v2@v2.6.5/database/gdb/testdata/reservedwords_table_tpl.sql (about) 1 CREATE TABLE %s ( 2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3 `key` varchar(45) DEFAULT NULL, 4 `category_id` int(10) unsigned NOT NULL, 5 `user_id` int(10) unsigned NOT NULL, 6 `title` varchar(255) NOT NULL, 7 `content` mediumtext NOT NULL, 8 `sort` int(10) unsigned DEFAULT '0', 9 `brief` varchar(255) DEFAULT NULL, 10 `thumb` varchar(255) DEFAULT NULL, 11 `tags` varchar(900) DEFAULT NULL, 12 `referer` varchar(255) DEFAULT NULL, 13 `status` smallint(5) unsigned DEFAULT '0', 14 `view_count` int(10) unsigned DEFAULT '0', 15 `zan_count` int(10) unsigned DEFAULT NULL, 16 `cai_count` int(10) unsigned DEFAULT NULL, 17 `created_at` datetime DEFAULT NULL, 18 `updated_at` datetime DEFAULT NULL, 19 PRIMARY KEY (`id`) 20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;