-- phpMyAdmin SQL Dump
-- version 4.2.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: 2014 年 8 月 13 日 09:12
-- サーバのバージョン： 5.6.20
-- PHP Version: 5.6.0RC3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `acbox`
--

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

--
-- テーブルの構造 `employee`
--

CREATE TABLE IF NOT EXISTS `employee` (
  `id` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `post` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;

--
-- テーブルのデータのダンプ `employee`
--

INSERT INTO `employee` (`id`, `name`, `post`, `position`) VALUES
('A001', 'Adams', 'Sales', 'The rank and file'),
('A002', 'Darling', 'Sales', 'The rank and file'),
('A003', 'Kingston', 'General Affairs', 'Chief clerk'),
('A004', 'Darling', 'General Affairs', 'Section chief'),
('A005', 'Adams', 'Personnel', 'The rank and file'),
('A006', 'Kingston', 'Sales', 'Director'),
('A007', 'Kingston', 'Sales', 'Section chief'),
('A008', 'Darling', 'Personnel', 'Chief'),
('A009', 'Adams', 'Personnel', 'Chief'),
('A010', 'Adams', 'General Affairs', 'The rank and file'),
('A011', 'Darling', 'General Affairs', 'The rank and file'),
('A012', 'Kingston', 'Sales', 'The rank and file'),
('A013', 'MacKenzie', 'Sales', 'Chief clerk'),
('A014', 'Darling', 'Sales', 'Vice-chief'),
('A015', 'MacKenzie', 'General Affairs', 'Vice-chief'),
('A016', 'Kingston', 'Personnel', 'Director'),
('A017', 'MacKenzie', 'Personnel', 'Section chief'),
('A018', 'MacKenzie', 'Sales', 'Chief');

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

--
-- テーブルの構造 `name`
--

CREATE TABLE IF NOT EXISTS `name` (
`id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=254 ;

--
-- テーブルのデータのダンプ `name`
--

INSERT INTO `name` (`id`, `name`, `created`, `modified`) VALUES
(1, '垣内', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(2, '友田', '2008-11-15 22:22:22', '2008-11-15 19:59:50'),
(3, '井香保', '2008-11-15 22:22:22', '2008-11-15 20:00:05'),
(4, '新庄', '2008-11-15 22:22:22', '2008-11-15 20:00:19'),
(5, '佐伯', '2008-11-15 22:22:22', '2008-11-15 20:00:28'),
(6, '吉田', '2008-11-15 22:22:22', '2008-11-15 20:00:40'),
(7, '井出', '2008-11-15 22:22:22', '2008-11-16 14:51:53'),
(8, '佐藤', '2008-11-15 13:49:11', '2008-11-15 13:49:11'),
(9, '田崎', '2008-11-15 15:02:51', '2008-11-15 15:02:51'),
(10, '牧田', '2008-11-15 15:41:35', '2008-11-15 15:41:35'),
(11, '皆藤', '2008-11-22 22:05:23', '2008-11-22 22:05:23'),
(12, 'andrew', '2008-11-22 22:05:23', '2008-11-22 22:05:23'),
(13, '新井', '2008-11-22 00:00:00', '2008-11-22 00:00:00'),
(14, '安藤', '2008-11-22 00:00:00', '2008-11-22 00:00:00'),
(15, '安西', '2008-11-22 00:00:00', '2008-11-22 00:00:00'),
(16, '藤吉', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(17, '恩田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(18, '陸田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(19, '佐々木', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(20, '佐久間', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(21, '岩佐', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(22, '岩井', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(23, '岩田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(24, '吉野', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(25, '野田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(26, '出口', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(27, '小出', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(28, '生野', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(29, 'Basil', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(30, 'Bush', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(31, 'Berton', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(32, 'Chris', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(33, 'Smith', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(34, 'Jachson', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(35, 'Jhonson', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(36, 'Vichard', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(37, '北田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(38, '北島', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(39, '島田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(40, '島井', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(41, '井手口', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(42, '西田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(43, '宮崎', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(44, '宮口', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(45, '宮本', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(46, '宮島', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(47, '宮田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(48, '田宮', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(49, '東島', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(50, '西島', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(51, '南田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(52, '東田', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(53, '西口', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(54, '西大路', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(55, '寺西', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(56, '阿南\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(57, '沼田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(58, '田沼\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(59, '田沖\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(60, '沖田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(61, '置田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(62, '五反田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(63, '反田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(64, '田町\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(65, '町田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(66, '埼田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(67, '横田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(68, '太井田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(69, '大仁田\n', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(70, 'Anderson', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(71, 'Bobby', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(72, 'あそう', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(73, 'アソウ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(74, 'おざわ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(75, 'オザワ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(76, 'おおた', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(77, 'オオタ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(78, 'ふくしま', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(79, 'フクシマ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(80, 'しい', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(81, 'シイ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(82, 'わたぬき', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(83, 'ワタヌキ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(84, 'たなか', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(85, 'タナカ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(86, 'すずき', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(87, 'スズキ', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(88, 'Abigail', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(89, 'Adela', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(90, 'Adelaide', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(91, 'Adele', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(92, 'Adeline', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(93, 'Agatha', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(94, 'Agnes', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(95, 'Aileen', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(96, 'Alberta', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(97, 'Alda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(98, 'Alexandra', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(99, 'Alice', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(100, 'Alison', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(101, 'Alma', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(102, 'Althea', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(103, 'Amanda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(104, 'Amelia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(105, 'Amy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(106, 'Angela', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(107, 'Angelia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(108, 'Barbara', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(109, 'Beatrice', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(110, 'Beatrix', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(111, 'Becky', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(112, 'Belinda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(113, 'Bella', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(114, 'Bertha', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(115, 'Bettina', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(116, 'Bianca', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(117, 'Bonnie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(118, 'Brenda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(119, 'Bridget', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(120, 'Brigid', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(121, 'Catharine', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(122, 'Catherine', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(123, 'Cecilia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(124, 'Cecily', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(125, 'Celeste', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(126, 'Celia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(127, 'Charlotte', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(128, 'Chere', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(129, 'Cherie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(130, 'Cherry', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(131, 'Chloe', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(132, 'Christian', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(133, 'Christiana', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(134, 'Diane', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(135, 'Dolly', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(136, 'Dominica', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(137, 'Donna', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(138, 'Doreen', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(139, 'Doris', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(140, 'Dorothy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(141, 'Dulcie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(142, 'Edith', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(143, 'Emilia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(144, 'Emily', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(145, 'Emma', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(146, 'Emmelina', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(147, 'Emmeline', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(148, 'Emmy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(149, 'Enola', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(150, 'Erica', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(151, 'Flora', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(152, 'Florence', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(153, 'Frances', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(154, 'Francisca', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(155, 'Freddie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(156, 'Gail', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(157, 'Georgiana', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(158, 'Georgie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(159, 'Georgina', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(160, 'Geraldine', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(161, 'Gertrud', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(162, 'Hermione', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(163, 'Hester', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(164, 'Hettie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(165, 'Hilary', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(166, 'Hilda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(167, 'Holly', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(168, 'Ingrid', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(169, 'Iris', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(170, 'Irma', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(171, 'Isabel', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(172, 'Isabella', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(173, 'Isadora', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(174, 'Joanna', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(175, 'Jody', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(176, 'Johanna', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(177, 'Josephine', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(178, 'Joyce', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(179, 'Judith', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(180, 'Judy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(181, 'Julia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(182, 'Kayleigh', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(183, 'Kim', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(184, 'Kitty', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(185, 'Laila', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(186, 'Lana', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(187, 'Laura', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(188, 'Laurel', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(189, 'Lauren', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(190, 'Lavinia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(191, 'Moira', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(192, 'Molly', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(193, 'Monica', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(194, 'Muriel', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(195, 'Myra', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(196, 'Nadine', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(197, 'Nancy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(198, 'Naomi', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(199, 'Natalia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(200, 'Natalie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(201, 'Nathalia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(202, 'Nathalie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(203, 'Nellie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(204, 'Olive', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(205, 'Olivia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(206, 'Ophelia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(207, 'Oriana', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(208, 'Pamela', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(209, 'Pansy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(210, 'Pat', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(211, 'Patricia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(212, 'Patsy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(213, 'Patty', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(214, 'Roberta', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(215, 'Romy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(216, 'Rosa', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(217, 'Rose', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(218, 'Rosemary', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(219, 'Ruby', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(220, 'Ruth', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(221, 'Sadie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(222, 'Samantha', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(223, 'Thelma', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(224, 'Theresa', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(225, 'Tiffany', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(226, 'Ursula', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(227, 'Valeria', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(228, 'Valerie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(229, 'Vera', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(230, 'Veronica', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(231, 'Wanda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(232, 'Wendy', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(233, 'Yvonne', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(234, 'Zelda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(235, 'Zenobia', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(236, 'Zillah', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(237, 'Zoe', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(238, 'bertha', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(239, 'bettina', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(240, 'bianca', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(241, 'bonnie', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(242, 'brenda', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(243, 'bridget', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(244, 'brigid', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(245, 'moira', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(246, 'molly', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(247, 'monica', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(248, 'muriel', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(249, 'myra', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(250, '田中田中田中田中田中', '2008-11-15 00:00:00', '2008-11-15 00:00:00'),
(251, '10%foo''bar\\', '2012-07-16 00:00:00', '2012-07-16 00:00:00'),
(252, '20%foo`bar_', NULL, NULL),
(253, '30%foo"bar&', NULL, NULL);

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

--
-- テーブルの構造 `nation`
--

CREATE TABLE IF NOT EXISTS `nation` (
`id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=98 ;

--
-- テーブルのデータのダンプ `nation`
--

INSERT INTO `nation` (`id`, `name`, `created`, `modified`) VALUES
(1, 'Azerbaijan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(2, 'Bahrain', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(3, 'Belarus', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(4, 'Belgium', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(5, 'Canada', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(6, 'Croatia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(7, 'Denmark', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(8, 'Ecuador', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(9, 'Egypt', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(10, 'England', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(11, 'Estonia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(12, 'Ethiopia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(13, 'Finland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(14, 'France', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(15, 'Georgia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(16, 'Germany', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(17, 'Great Britain', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(18, 'Greece', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(19, 'Grenada', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(20, 'Guinea', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(21, 'Guyana', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(22, 'Iceland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(23, 'India', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(24, 'Indonesia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(25, 'Ireland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(26, 'Italy', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(27, 'Jamaica', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(28, 'Japan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(29, 'Jordan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(30, 'Korea', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(31, 'Kyrgyzstan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(32, 'Libya', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(33, 'Liechtenstein', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(34, 'Lithuania', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(35, 'Luxembourg', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(36, 'Luxemburg', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(37, 'Macedonia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(38, 'Malaysia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(39, 'Montenegro', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(40, 'Netherlands', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(41, 'New Zealand', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(42, 'Nicaragua', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(43, 'Nigeria', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(44, 'North Korea', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(45, 'Northern Ireland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(46, 'Norway', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(47, 'Oman', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(48, 'Pakistan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(49, 'Philippines', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(50, 'Phoenicia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(51, 'Portugal', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(52, 'Republic of Macedonia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(53, 'Romania', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(54, 'Russia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(55, 'Scotland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(56, 'Sierra Leone', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(57, 'Slovenia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(58, 'South Korea', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(59, 'Soviet Union', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(60, 'Spain', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(61, 'Sweden', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(62, 'Switzerland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(63, 'Syria', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(64, 'Tajikistan', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(65, 'Thailand', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(66, 'Tunisia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(67, 'Turkey', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(68, 'Uganda', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(69, 'Ukraine', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(70, 'United Kingdom', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(71, 'United Kingdom of Great Britain and Northern Ireland', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(72, 'United States', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(73, 'United States of America', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(74, 'Albania', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(75, 'Argentina', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(76, 'Armenia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(77, 'Australia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(78, 'Austria', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(79, 'Botswana', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(80, 'Bulgaria', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(81, 'Burkina Faso', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(82, 'Chile', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(83, 'China', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(84, 'Colombia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(85, 'Fiji', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(86, 'Iran', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(87, 'Laos', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(88, 'Mongolia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(89, 'Paraguay', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(90, 'Rwanda', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(91, 'Seychelles', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(92, 'Venezuela', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(93, 'Wales', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(94, 'Yemen', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(95, 'Zaire', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(96, 'Zambia', '2009-01-01 00:00:00', '2009-01-01 00:00:00'),
(97, 'Brazil', '2009-01-01 00:00:00', '2009-01-01 00:00:00');

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

--
-- テーブルの構造 `tag`
--

CREATE TABLE IF NOT EXISTS `tag` (
`id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `japanese` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=20 ;

--
-- テーブルのデータのダンプ `tag`
--

INSERT INTO `tag` (`id`, `name`, `japanese`, `created`, `modified`) VALUES
(1, 'PhysicalEducation', '体育学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Musicology', '音楽学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Mathematics', '数学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Biology', '生物学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Chemistry', '化学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'Sociology', '社会学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'Linguistics', '言語学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'Anthropology', '人類学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Philosophy', '哲学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'Geometry', '幾何学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'Architecture', '建築学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'PoliticalScience', '政治学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'Jurisprudence', '法律学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'Archaeology', '考古学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 'History', '歴史学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'Psychology', '心理学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'MedicalScience', '医学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'Literature', '文学', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'Astronomy', '天文学', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `name`
--
ALTER TABLE `name`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nation`
--
ALTER TABLE `nation`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tag`
--
ALTER TABLE `tag`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `name`
--
ALTER TABLE `name`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=254;
--
-- AUTO_INCREMENT for table `nation`
--
ALTER TABLE `nation`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=98;
--
-- AUTO_INCREMENT for table `tag`
--
ALTER TABLE `tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
