DROP TABLE IF EXISTS releases;
CREATE TABLE releases (
version DECIMAL PRIMARY KEY,
message TEXT
) DEFAULT CHARSET UTF8;
SHOW CREATE TABLE releases;
Table	Create Table
releases	CREATE TABLE `releases` (
  `version` decimal(10,0) NOT NULL,
  `message` text,
  PRIMARY KEY (`version`)
) ENGINE=mroonga DEFAULT CHARSET=utf8
INSERT INTO releases (version, message) VALUES (1, "the first release!!!");
INSERT INTO releases (version, message) VALUES (10, "10th release!");
INSERT INTO releases (version, message) VALUES (999, "the last release!");
SELECT * FROM releases;
version	message
1	the first release!!!
10	10th release!
999	the last release!
SELECT * FROM releases WHERE version BETWEEN "1" AND "10";
version	message
1	the first release!!!
10	10th release!
DROP TABLE releases;
