项目需要。。找了下,改了下,藏。
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `country`
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
`country_id` tinyint(3) NOT NULL auto_increment,
`code` varchar(16) NOT NULL,
`name_chinese` varchar(128) NOT NULL,
`name_english` varchar(128) NOT NULL,
PRIMARY KEY (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of country
-- ----------------------------
INSERT INTO `country` VALUES ('1', '00', '未知的國家', 'Unknown Country');
INSERT INTO `country` VALUES ('2', 'TT', '千里達與托貝哥共和國 (Trinidad and Tobago)', 'Trinidad and Tobago');
INSERT INTO `country` VALUES ('3', 'TV', '土瓦魯 (Tuvalu)', 'Tuvalu');
INSERT INTO `country` VALUES ('4', 'TR', '土耳其 (Türkiye)', 'T