map.sql

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

USE PRRM;

## ----------------- Map Detail ------------------------------------------------
CREATE TABLE IF NOT EXISTS MAP_DETAIL (
  NAME VARCHAR(50) NOT NULL PRIMARY KEY,
  VERSION INT(11) NOT NULL DEFAULT '0',
  CONTEXTFILE VARCHAR(100) NOT NULL DEFAULT '',
  LOCATORCONTEXTFILE VARCHAR(100) NOT NULL DEFAULT '',
  READONLY TINYINT(1) NOT NULL DEFAULT '0',
  DESCRIPTION VARCHAR(100) DEFAULT ''
) ENGINE=INNODB
;