text: -- phpMyAdmin SQL Dump
  -- version 3.4.5
  -- http://www.phpmyadmin.net
  --
  -- ホスト: localhost
  -- 生成時間: 2012 年 9 月 05 日 06:56
  -- サーバのバージョン: 5.5.16
  -- PHP のバージョン: 5.3.8
  
  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 */;
  
  --
  -- データベース: `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;
  
  --
  -- テーブルのデータをダンプしています `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 AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `created` datetime DEFAULT NULL,
    `modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 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 AUTO_INCREMENT,
    `name` varchar(255) DEFAULT NULL,
    `created` datetime DEFAULT NULL,
    `modified` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=97 ;
  
  --
  -- テーブルのデータをダンプしています `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');
  
  -- --------------------------------------------------------
  
  --
  -- テーブルの構造 `tag`
  --
  
  CREATE TABLE IF NOT EXISTS `tag` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `japanese` varchar(100) NOT NULL,
    `created` datetime NOT NULL,
    `modified` datetime NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 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');
  
  /*!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 */;
  