-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 11, 2008 at 12:50 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `accoguid_acguide`
--

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

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

CREATE TABLE `region` (
  `RegionID` int(10) NOT NULL auto_increment,
  `StateID` int(10) NOT NULL default '0',
  `Name` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`RegionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=87 ;

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

--
-- Table structure for table `suburb`
--

CREATE TABLE `suburb` (
  `SuburbID` int(10) NOT NULL auto_increment,
  `RegionID` int(10) NOT NULL default '0',
  `Name` varchar(128) NOT NULL default '',
  `Major` int(1) NOT NULL default '0',
  `Postcode` int(5) default NULL,
  PRIMARY KEY  (`SuburbID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1474 ;