File: data/JSDropDown.sql

# phpMyAdmin MySQL-Dump
# version 2.5.0
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Server version: 4.0.12
# PHP Version: 4.3.3
# --------------------------------------------------------

#
# Table structure for table `citymaster`
#
# Creation: Jan 07, 2005 at 12:49 AM
# Last update: Jan 07, 2005 at 12:49 AM
#

CREATE TABLE `citymaster` (
  `city_id` int(11) NOT NULL auto_increment,
  `cityname` varchar(100) default NULL,
  PRIMARY KEY  (`city_id`),
  UNIQUE KEY `city_id` (`city_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Dumping data for table `citymaster`
#

INSERT INTO `citymaster` VALUES (1, 'Raleigh');
INSERT INTO `citymaster` VALUES (2, 'Durham');
INSERT INTO `citymaster` VALUES (3, 'Hillsborough');
INSERT INTO `citymaster` VALUES (4, 'Chapell Hill');
INSERT INTO `citymaster` VALUES (5, 'Cary');


# Table structure for table `region`
#
# Creation: Jan 07, 2005 at 12:49 AM
# Last update: Jan 07, 2005 at 12:49 AM
#

CREATE TABLE `region` (
  `rid` int(11) NOT NULL auto_increment,
  `city_id` int(11) NOT NULL default '0',
  `region_name` varchar(250) NOT NULL default '',
  PRIMARY KEY  (`rid`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Dumping data for table `region`
#

INSERT INTO `region` VALUES (1, 4, 'NC');
INSERT INTO `region` VALUES (2, 1, 'North Raleigh');
INSERT INTO `region` VALUES (3, 1, 'Northwest Raleigh');
INSERT INTO `region` VALUES (4, 1, 'Downtown Raleigh');
INSERT INTO `region` VALUES (5, 1, 'SouthEast Raleigh');