country.sql

Java的框架

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;