# CocoaMySQL dump
# Version 0.7b5
# http://cocoamysql.sourceforge.net
#
# Host: db.myhighcountry.info (MySQL 5.0.24a-standard-log)
# Database: hilts
# Generation Time: 2007-10-23 01:49:55 -0400
# ************************************************************

# Dump of table my_business
# ------------------------------------------------------------

CREATE TABLE `my_business` (
  `id` mediumint(6) unsigned zerofill NOT NULL auto_increment,
  `name` varchar(55) NOT NULL default 'Unnamed Business',
  `owner` int(11) default '0',
  `verified` enum('yes','no') NOT NULL default 'no',
  `rating` enum('0','1','2','3','4','5') NOT NULL default '0',
  `class` enum('free','advertiser','premium') NOT NULL default 'free',
  `county` enum('Alleghany','Ashe','Avery','Watauga','Wilkes') default NULL,
  `address` varchar(120) NOT NULL,
  `city` varchar(35) default NULL,
  `state` varchar(4) NOT NULL default 'NC',
  `zip` int(5) unsigned NOT NULL default '0',
  `phone` varchar(14) NOT NULL default '',
  `tollfree` varchar(14) default NULL,
  `fax` varchar(14) default NULL,
  `mobile` varchar(14) default NULL,
  `www` varchar(300) default NULL,
  `email` varchar(35) default NULL,
  `description` text,
  `primary_category` varchar(35) default NULL,
  `secondary_category` varchar(35) default NULL,
  `tag_1` varchar(14) default NULL,
  `tag_2` varchar(14) default NULL,
  `tag_3` varchar(14) default NULL,
  `tag_4` varchar(14) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;



# Dump of table my_category
# ------------------------------------------------------------

CREATE TABLE `my_category` (
  `id` smallint(3) unsigned zerofill NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `is_master` enum('0','1','2','3') NOT NULL default '0',
  `parent` smallint(3) unsigned zerofill default NULL,
  `uri_node` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;