-- 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 `address`,`stats`
--

CREATE TABLE `address` (
  `NAME` varchar(100) NOT NULL,
  `ADDRESS` varchar(100) NOT NULL,
  `BLOCK` varchar(100) NOT NULL,
  `POSTCODE` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `stats` (
  `NUMBER` bigint(20) NOT NULL,
  `NAME` varchar(100) NOT NULL,
  `CODE` varchar(10) NOT NULL,
  `GENDER` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `address`,`stats`
--

INSERT INTO `address` (`NAME`, `ADDRESS`, `BLOCK`, `POSTCODE`) VALUES
('Alice Doodle', '119 Tyler Avenue', 'Cabramatta, NSW', '2166'),
('Barry King', '1/45 Yardley Circuit', 'Launceston, Tas', '7250'),
('Frances Sidler', '12 Prospect Road', 'Subiaco, WA', '6008'),
('Sharon Wylie', '43 Young Street', 'Glenelg, SA', '5045'),
('Tom Piper', '83 Essex Street', 'Graceville, Qld', '4075'),
('Helen Maxwell', '50 Queens Road', 'Collingwood, Vic', '3066');

INSERT INTO `stats` (`NUMBER`, `NAME`, `CODE`, `GENDER`) VALUES
(392484360, 'Alice Doodle', '13.05.61', 'F'),
(918468592, 'Barry King', '04.17.66', 'M'),
(416879225, 'Frances Sidler', '03.26.33', 'F'),
(281082274, 'Sharon Wylie', '11.20.58', 'F'),
(561911803, 'Tom Piper', '02.28.60', 'M'),
(408119165, 'Helen Maxwell', '61.28.02', 'F');