--
-- Table structure for table `prefectures`
--

CREATE TABLE IF NOT EXISTS `prefectures` (
  `prefectures_id` tinyint(3) unsigned NOT NULL auto_increment,
  `region_id` int(11) NOT NULL,
  `prefectures_name` varchar(20) NOT NULL,
  `prefectures_priority` tinyint(3) unsigned NOT NULL default '0',
  `prefectures_sort` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prefectures_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

--
-- Dumping data for table `prefectures`
--

INSERT INTO `prefectures` (`prefectures_id`, `region_id`, `prefectures_name`, `prefectures_priority`, `prefectures_sort`) VALUES
(1, 1, '�k�C��', 41, 0),
(2, 2, '�X��', 20, 0),
(3, 2, '��茧', 18, 0),
(4, 2, '�{�錧', 33, 0),
(5, 2, '�H�c��', 12, 0),
(6, 2, '�R�`��', 15, 0),
(7, 2, '������', 30, 0),
(8, 3, '��錧', 37, 0),
(9, 3, '�Ȗ،�', 28, 0),
(10, 3, '�Q�n��', 29, 0),
(11, 3, '��ʌ�', 43, 0),
(12, 3, '��t��', 42, 0),
(13, 3, '�����s', 47, 0),
(14, 3, '�_�ސ쌧', 45, 0),
(15, 4, '�V����', 34, 0),
(16, 4, '�x�R��', 10, 0),
(17, 4, '�ΐ쌧', 13, 0),
(18, 4, '���䌧', 5, 0),
(19, 4, '�R����', 7, 0),
(20, 4, '���쌧', 32, 0),
(21, 5, '�򕌌�', 31, 0),
(22, 4, '����', 38, 0),
(23, 4, '���m��', 44, 0),
(24, 4, '�O�d��', 26, 0),
(25, 5, '���ꌧ', 17, 0),
(26, 5, '���s�{', 35, 0),
(27, 5, '���{', 46, 0),
(28, 5, '���Ɍ�', 40, 0),
(29, 5, '�ޗnj�', 19, 0),
(30, 5, '�a�̎R��', 9, 0),
(31, 6, '���挧', 1, 0),
(32, 6, '������', 2, 0),
(33, 6, '���R��', 27, 0),
(34, 6, '�L����', 36, 0),
(35, 6, '�R����', 23, 0),
(36, 7, '������', 4, 0),
(37, 7, '���쌧', 8, 0),
(38, 7, '���Q��', 21, 0),
(39, 7, '���m��', 3, 0),
(40, 8, '������', 39, 0),
(41, 8, '���ꌧ', 6, 0),
(42, 8, '���茧', 22, 0),
(43, 8, '�F�{��', 25, 0),
(44, 8, '�啪��', 14, 0),
(45, 8, '�{�茧', 11, 0),
(46, 8, '��������', 24, 0),
(47, 9, '���ꌧ', 16, 0);

-- --------------------------------------------------------

--
-- Table structure for table `region`
--

CREATE TABLE IF NOT EXISTS `region` (
  `region_id` int(11) NOT NULL auto_increment,
  `region_name` varchar(255) NOT NULL,
  `region_sort` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`region_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `region`
--

INSERT INTO `region` (`region_id`, `region_name`, `region_sort`) VALUES
(1, '�k�C��', 0),
(2, '���k', 0),
(3, '�֓�', 0),
(4, '����', 0),
(5, '�ߋE', 0),
(6, '����', 0),
(7, '�l��', 0),
(8, '��B', 0),
(9, '����', 0)
;