country.sql

来自「Java的框架」· SQL 代码 · 共 10 行

USE PRRM;

CREATE TABLE `COUNTRY` (
  `ISO` CHAR(2) NOT NULL,
  `NAME` VARCHAR(80) NOT NULL,
  `PRINTABLE_NAME` VARCHAR(80) NOT NULL,
  `ISO3` CHAR(3) DEFAULT NULL,
  `NUMCODE` SMALLINT(6) DEFAULT NULL,
  PRIMARY KEY  (`ISO`)
) ENGINE=INNODB;