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