rendered paste body# 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;