linux 测试程序..

# SQL Manager 2005 for MySQL 3.6.5.8
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : javatest


SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE `javatest`
    CHARACTER SET 'utf8'
    COLLATE 'utf8_general_ci';

#
# Structure for the `region` table :
#

CREATE TABLE `region` (
  `id` varchar(30) NOT NULL default '',
  `pid` varchar(30) default NULL,
  `name` varchar(50) default NULL,
  `mylevel` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

#
# Data for the `region` table  (LIMIT 0,500)
#

INSERT INTO `region` (`id`, `pid`, `name`, `mylevel`) VALUES
  ('a01','','state1',0),
  ('a01b01','a01','province1',1),
  ('a01b01c01','a01b01','city11',2),
  ('a01b01c01d01','a01b01c01','region1',3),
  ('a01b01c01d01e01','a01b01c01d01','town1',4),
  ('a01b01c01d01e02','a01b01c01d01','town2',4),
  ('a01b01c01d01e02f01','a01b01c01d01e02','village21',5),
  ('a01b01c01d01e02f02','a01b01c01d01e02','village22',5),
  ('a01b01c01d01e02f03','a01b01c01d01e02','village23',5),
  ('a01b01c01d01e02f04','a01b01c01d01e02','village24',5),
  ('a01b01c01d01e03','a01b01c01d01','town3',4),
  ('a01b01c01d01e04','a01b01c01d01','town4',4),
  ('a01b01c01d02','a01b01c01','region2',3),
  ('a01b01c01d03','a01b01c01','region3',3),
  ('a01b01c01d04','a01b01c01','region4',3),
  ('a01b01c02','a01b01','city12',2),
  ('a01b01c03','a01b01','city13',2),
  ('a01b01c03d01','a01b01c03','region31',3),
  ('a01b01c03d02','a01b01c03','region32',3),
  ('a01b01c03d03','a01b01c03','region33',3),
  ('a01b01c03d04','a01b01c03','region34',3),
  ('a01b01c04','a01b01','city14',2),
  ('a01b02','a01','province2',1),
  ('a01b03','a01','province3',1),
  ('a01b04','a01','province4',1),
  ('a02','','state2',0),
  ('a02b01','a02','province21',1),
  ('a02b02','a02','province22',1),
  ('a02b03','a02','province23',1),
  ('a02b04','a02','province24',1),
  ('a03','','state3',0),
  ('a03b01','a03','province31',1),
  ('a03b01c01','a03b01','city31',2),
  ('a03b01c02','a03b01','city32',2),
  ('a03b01c02d01','a03b01c02','region21',3),
  ('a03b01c02d02','a03b01c02','region22',3),
  ('a03b01c02d03','a03b01c02','region23',3),
  ('a03b01c02d04','a03b01c02','region24',3),
  ('a03b01c02d04e01','a03b01c02d04','town21',4),
  ('a03b01c02d04e02','a03b01c02d04','town22',4),
  ('a03b01c02d04e03','a03b01c02d04','town23',4),
  ('a03b01c02d04e04','a03b01c02d04','town24',4),
  ('a03b01c02d04e04f01','a03b01c02d04e04','village41',5),
  ('a03b01c02d04e04f02','a03b01c02d04e04','village42',5),
  ('a03b01c02d04e04f03','a03b01c02d04e04','village43',5),
  ('a03b01c02d04e04f04','a03b01c02d04e04','village44',5),
  ('a03b01c03','a03b01','city33',2),
  ('a03b01c03d01','a03b01c03','region31',3),
  ('a03b01c03d02','a03b01c03','region32',3),
  ('a03b01c03d03','a03b01c03','region33',3),
  ('a03b01c03d04','a03b01c03','region34',3),
  ('a03b01c04','a03b01','city34',2),
  ('a03b01c04d01','a03b01c04','county41',3),
  ('a03b01c04d02','a03b01c04','county42',3),
  ('a03b01c04d03','a03b01c04','county43',3),
  ('a03b01c04d04','a03b01c04','county44',3),
  ('a03b01c04d04e01','a03b01c04d04','town41',4),
  ('a03b01c04d04e01f01','a03b01c04d04e01','village1',5),
  ('a03b01c04d04e01f01g01','a03b01c04d04e01f01','smallvillage1',6),
  ('a03b01c04d04e01f01g02','a03b01c04d04e01f01','smallvillage2',6),
  ('a03b01c04d04e01f01g03','a03b01c04d04e01f01','smallvillage3',6),
  ('a03b01c04d04e01f01g04','a03b01c04d04e01f01','smallvillage4',6),
  ('a03b01c04d04e01f02','a03b01c04d04e01','village2',5),
  ('a03b01c04d04e01f03','a03b01c04d04e01','village3',5),
  ('a03b01c04d04e01f04','a03b01c04d04e01','village4',5),
  ('a03b01c04d04e02','a03b01c04d04','town42',4),
  ('a03b01c04d04e03','a03b01c04d04','town43',4),
  ('a03b01c04d04e04','a03b01c04d04','town44',4),
  ('a03b02','a03','province32',1),
  ('a03b03','a03','province33',1),
  ('a03b04','a03','province34',1),
  ('a04','','state4',0),
  ('a05','','state5',0);

COMMIT;