-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 22, 2013 at 07:10 AM
-- Server version: 5.5.29
-- PHP Version: 5.4.10

--
-- Table structure for tables `file1`,`file2`,`file3`
--

CREATE TABLE `file1` (
  `NUMBER` bigint(20) NOT NULL,
  `NAME` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `file2` (
  `NUMBER` bigint(20) NOT NULL,
  `TYPE` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `file3` (
  `TYPE` varchar(100) NOT NULL,
  `NUMBER` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `file1`,`file2`,`file3`
--

INSERT INTO `file1` (`NUMBER`, `NAME`) VALUES
(1000, 'Cedric Smithers'),
(2000, 'Michael Jacob'),
(3000, 'Johnathon Murray'),
(4000, 'Samantha Cage'),
(5000, 'Henry Younger'),
(6000, 'Simon Wills');

INSERT INTO `file2` (`NUMBER`, `TYPE`) VALUES
(1000, 'tights'),
(2000, 'caps'),
(3000, 'overcoats'),
(4000, 'scarves'),
(5000, 'underwear'),
(6000, 'jumpers');

INSERT INTO `file3` (`TYPE`, `NUMBER`) VALUES
('tights', 1000),('caps', 2000),('overcoats', 3000),
('scarves', 4000),('underwear', 5000),('jumpers', 6000);