-- phpMyAdmin SQL Dump
-- version 2.10.1deb2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 30, 2007 at 05:14 PM
-- Server version: 5.0.38
-- PHP Version: 4.4.6-2+b1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `zythis`
-- 

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

-- 
-- Table structure for table `access`
-- 

CREATE TABLE `access` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_id` int(10) unsigned default NULL,
  `business_id` int(10) unsigned default NULL,
  `coupon_id` int(10) unsigned default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=219 ;

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

-- 
-- Table structure for table `business`
-- 

CREATE TABLE `business` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `tag-line` text,
  `address` text NOT NULL,
  `city` varchar(30) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `comment_phone` varchar(10) default NULL,
  `primary_contact` varchar(10) default NULL,
  `url` text,
  `email` text,
  `information` text,
  `hours` text,
  `menu` text,
  `flags` int(10) unsigned NOT NULL,
  `catid` int(10) unsigned NOT NULL,
  `subcatid` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `city` (`city`),
  FULLTEXT KEY `state` (`state`),
  FULLTEXT KEY `zip` (`zip`),
  FULLTEXT KEY `tag-line` (`tag-line`),
  FULLTEXT KEY `email` (`email`),
  FULLTEXT KEY `information` (`information`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `category`
-- 

CREATE TABLE `category` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `commentary` text NOT NULL,
  `name` varchar(24) NOT NULL default '',
  `parent` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `coupon`
-- 

CREATE TABLE `coupon` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(128) NOT NULL,
  `description_text` text NOT NULL,
  `effective` date NOT NULL default '0000-00-00',
  `expiration` date NOT NULL default '0000-00-00',
  `quantity` int(11) NOT NULL default '0',
  `business_id` int(10) unsigned NOT NULL default '0',
  `category_id` int(10) unsigned NOT NULL,
  `subcategory_id` int(10) unsigned NOT NULL,
  `img_id` int(10) unsigned default NULL,
  `flags` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

-- 
-- Table structure for table `coupon_selected`
-- 

CREATE TABLE `coupon_selected` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user_d` int(10) unsigned NOT NULL default '0',
  `coupon_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `image`
-- 

CREATE TABLE `image` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL default '',
  `caption` varchar(64) NOT NULL default '',
  `width` smallint(5) unsigned NOT NULL default '0',
  `height` smallint(11) unsigned NOT NULL,
  `extension` varchar(4) NOT NULL default '',
  `business_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `notes`
-- 

CREATE TABLE `notes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `body_text` text NOT NULL,
  `subject` varchar(64) NOT NULL,
  `create` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `flags` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `re_table` varchar(128) NOT NULL,
  `meta_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `body_text` (`body_text`,`subject`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

-- 
-- Table structure for table `subcategory`
-- 

CREATE TABLE `subcategory` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL default '',
  `info` text,
  `category_id` int(10) unsigned default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

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

-- 
-- Table structure for table `user`
-- 

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `gender` char(1) NOT NULL default '',
  `email` text,
  `password` varchar(41) default NULL,
  `checksum` varchar(64) default NULL,
  `flags` int(11) unsigned NOT NULL default '0',
  `ip_address` varchar(15) NOT NULL,
  `business_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `ip-address` (`ip_address`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `vote_business`
-- 

CREATE TABLE `vote_business` (
  `id` int(11) NOT NULL auto_increment,
  `business_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

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

-- 
-- Table structure for table `vote_coupon`
-- 

CREATE TABLE `vote_coupon` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `coupon_id` int(10) unsigned default NULL,
  `user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=169 ;