# phpMyAdmin SQL Dump
# version 2.5.5-rc2
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 10, 2004 at 09:23 AM
# Server version: xxx
# PHP Version: xxx
# 
# Database : `phpyellow`
# 

# --------------------------------------------------------

#
# Table structure for table `p4_acl_page`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_acl_page` (
  `id` int(2) NOT NULL auto_increment,
  `label` varchar(80) default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_acl_user`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_acl_user` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `password` varchar(40) default NULL,
  `level` int(2) default '0',
  `admin_comment` varchar(255) default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  `fkid` int(6) default NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_cat_naics`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_cat_naics` (
  `category` varchar(80) default NULL,
  `id` int(5) unsigned NOT NULL auto_increment,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_category_popular`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:49 AM
#

CREATE TABLE `p4_category_popular` (
  `category` varchar(160) default NULL,
  `id` int(5) unsigned NOT NULL auto_increment,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_click_category`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_click_category` (
  `id` mediumint(10) unsigned NOT NULL auto_increment,
  `ip` varchar(15) default NULL,
  `port` varchar(10) default NULL,
  `category` varchar(120) default NULL,
  `referer` varchar(120) default NULL,
  `hiton` date default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_click_website`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_click_website` (
  `id` mediumint(10) unsigned NOT NULL auto_increment,
  `ip` varchar(15) default NULL,
  `port` varchar(10) default NULL,
  `website` varchar(120) default NULL,
  `referer` varchar(120) default NULL,
  `hiton` date default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  PRIMARY KEY (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_contact`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jul 02, 2004 at 02:06 PM
#

CREATE TABLE `p4_contact` (
  `customerid` mediumint(9) unsigned NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `password` varchar(40) default NULL,
  `acl_user` int(2) default NULL,
  `email` varchar(80) default NULL,
  `organization` varchar(45) default NULL,
  `firstname` varchar(35) default NULL,
  `lastname` varchar(45) default NULL,
  `address` varchar(80) default NULL,
  `address2` varchar(80) default NULL,
  `city` varchar(25) default NULL,
  `county` varchar(80) default NULL,
  `stateprov` varchar(25) NOT NULL default '',
  `country` varchar(40) NOT NULL default 'United States',
  `postalcode` varchar(20) default NULL,
  `phone` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `cellphone` varchar(20) default NULL,
  `website` varchar(140) default NULL,
  `imagecompany` varchar(120) default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  `customersince` date default NULL,
  `position` varchar(30) default NULL,
  `privacy` enum('low','medium','high') default 'medium',
  `news` enum('yes','no') NOT NULL default 'no',
  `newsformat` enum('plain','html') default NULL,
  `extra_1` char(1) default NULL,
  `extra_2` char(1) default NULL,
  `extra_3` char(1) default NULL,
  `extra_4` char(1) default NULL,
  `extra_5` char(1) default NULL,
  PRIMARY KEY (`customerid`),
  KEY `stateprovidx`(`stateprov`(15)),
  KEY `countryidx`(`country`(20)),
  FULLTEXT KEY `wholesite`(`organization`,`firstname`,`lastname`,`address`,`city`,`stateprov`,`country`,`postalcode`,`website`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_listing`
#
# Creation: Jul 10, 2004 at 09:20 AM
# Last update: Jul 10, 2004 at 09:20 AM
# Last check: Jul 10, 2004 at 09:20 AM
#

CREATE TABLE `p4_listing` (
  `ckey` int(9) unsigned NOT NULL auto_increment,
  `fkcustomerid` mediumint(9) unsigned NOT NULL default '0',
  `category` varchar(80) NOT NULL default 'other',
  `description` mediumtext,
  `ad_title` varchar(80) default NULL,
  `rank` tinyint(1) unsigned NOT NULL default '0',
  `selected_rank` tinyint(1) unsigned NOT NULL default '0',
  `status` enum('pending','approved','expired') default 'approved',
  `expires` date default NULL,
  `image2` varchar(120) default NULL,
  `image3` varchar(120) default NULL,
  `website2` varchar(140) default NULL,
  `website3` varchar(140) default NULL,
  `id_ratings` int(9) unsigned default NULL,
  `id_coupon` int(9) unsigned default NULL,
  `id_agent` int(9) unsigned default NULL,
  `id_extra_20` int(9) unsigned default NULL,
  `extra_21` char(1) default NULL,
  `extra_22` char(1) default NULL,
  `lastupdate` timestamp(14) NOT NULL,
  PRIMARY KEY (`ckey`),
  KEY `catidx`(`category`(15)),
  KEY `descidx`(`description`(15)),
  FULLTEXT KEY `catdesckey`(`description`,`category`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_listing_notify`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jun 21, 2004 at 06:26 AM
#

CREATE TABLE `p4_listing_notify` (
  `notify_id` mediumint(10) unsigned NOT NULL auto_increment,
  `fk_ckey` mediumint(9) unsigned NOT NULL default '0',
  `flag30` timestamp(14) NOT NULL,
  `flag15` timestamp(14) NOT NULL,
  `flag7` timestamp(14) NOT NULL,
  `flag2` timestamp(14) NOT NULL,
  `flag1` timestamp(14) NOT NULL,
  `flag_1` timestamp(14) NOT NULL,
  `flag_2` timestamp(14) NOT NULL,
  `flag_7` timestamp(14) NOT NULL,
  `flag_15` timestamp(14) NOT NULL,
  `flag_30` timestamp(14) NOT NULL,
  `flag_180` timestamp(14) NOT NULL,
  `flag_365` timestamp(14) NOT NULL,
  `flag_730` timestamp(14) NOT NULL,
  PRIMARY KEY (`notify_id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `p4_user_notify`
#
# Creation: Jun 21, 2004 at 06:26 AM
# Last update: Jul 02, 2004 at 02:06 PM
#

CREATE TABLE `p4_user_notify` (
  `user_notify_id` mediumint(10) unsigned NOT NULL auto_increment,
  `fk_customerid` mediumint(9) unsigned NOT NULL default '0',
  `flag30` enum('yes','no') NOT NULL default 'yes',
  `flag15` enum('yes','no') NOT NULL default 'yes',
  `flag7` enum('yes','no') NOT NULL default 'yes',
  `flag2` enum('yes','no') NOT NULL default 'yes',
  `flag1` enum('yes','no') NOT NULL default 'yes',
  `flag_1` enum('yes','no') NOT NULL default 'yes',
  `flag_2` enum('yes','no') NOT NULL default 'yes',
  `flag_7` enum('yes','no') NOT NULL default 'yes',
  `flag_15` enum('yes','no') NOT NULL default 'yes',
  `flag_30` enum('yes','no') NOT NULL default 'yes',
  `flag_180` enum('yes','no') NOT NULL default 'yes',
  `flag_365` enum('yes','no') NOT NULL default 'yes',
  `flag_730` enum('yes','no') NOT NULL default 'yes',
  PRIMARY KEY (`user_notify_id`),
  KEY `fk_customerid`(`fk_customerid`)
) TYPE=MyISAM;