-- MySQL dump 10.9
--
-- Host: localhost    Database: walleyec
-- ------------------------------------------------------
-- Server version	4.1.12

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `EventLog`
--

DROP TABLE IF EXISTS `EventLog`;
CREATE TABLE `EventLog` (
  `LogID` int(10) unsigned NOT NULL auto_increment,
  `AD_ID` int(10) unsigned NOT NULL default '0',
  `Trancode` int(10) unsigned NOT NULL default '0',
  `TransTime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`LogID`),
  KEY `ix_AD_ID` (`AD_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `admaster`
--

DROP TABLE IF EXISTS `admaster`;
CREATE TABLE `admaster` (
  `Ad_ID` int(10) unsigned NOT NULL auto_increment,
  `UserKey` int(10) unsigned NOT NULL default '0',
  `Title` varchar(45) NOT NULL default '',
  `StartDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Item_Desc` text NOT NULL,
  `SellersName` varchar(50) NOT NULL default '',
  `LocationCity` varchar(25) NOT NULL default '',
  `LocationState` char(2) NOT NULL default '',
  `Ad_Category` int(10) unsigned NOT NULL default '0',
  `NumAdWeeks` int(10) unsigned NOT NULL default '0',
  `CC_Type` char(1) NOT NULL default '',
  `CC_Name` varchar(75) NOT NULL default '',
  `CC_Expiration_MM` int(10) unsigned NOT NULL default '0',
  `CC_Expiration_YYYY` int(10) unsigned NOT NULL default '0',
  `Last_PaymentDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Current_Status` varchar(10) default NULL,
  `active_end_date` datetime default NULL,
  `CC_Number` varchar(200) default NULL,
  `Migrated_AdKey` varchar(50) default NULL,
  `listcount` bigint(20) unsigned NOT NULL default '0',
  `viewcount` bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Ad_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `adphotos`
--

DROP TABLE IF EXISTS `adphotos`;
CREATE TABLE `adphotos` (
  `photoID` int(10) unsigned NOT NULL auto_increment,
  `AD_ID` int(10) unsigned NOT NULL default '0',
  `FileName` varchar(45) NOT NULL default '',
  `DateUploaded` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`photoID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `descripfix`
--

DROP TABLE IF EXISTS `descripfix`;
CREATE TABLE `descripfix` (
  `AdNumber` varchar(15) default NULL,
  `Description` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `paytrans`
--

DROP TABLE IF EXISTS `paytrans`;
CREATE TABLE `paytrans` (
  `payTransID` int(10) unsigned NOT NULL auto_increment,
  `UserKey` int(10) unsigned NOT NULL default '0',
  `AD_ID` int(10) unsigned NOT NULL default '0',
  `AD_Version` int(10) unsigned NOT NULL default '0',
  `CC_Number` varchar(45) NOT NULL default '',
  `CC_Expiration` varchar(45) NOT NULL default '',
  `CC_AuthorizationCode` varchar(55) NOT NULL default '',
  `Billing_Description` text NOT NULL,
  `Date_Submitted` datetime NOT NULL default '0000-00-00 00:00:00',
  `CC_Type` char(1) NOT NULL default '',
  `CC_Cardholder` varchar(55) NOT NULL default '',
  `PreviousPicCount` int(10) unsigned NOT NULL default '0',
  `PriorExpirationDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `CurrentPicCount` int(10) unsigned NOT NULL default '0',
  `PreviousWeekCount` int(10) unsigned NOT NULL default '0',
  `CurrentWeekCount` int(10) unsigned NOT NULL default '0',
  `NewEndDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `CC_AuthorizationDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Amount` decimal(10,0) NOT NULL default '0',
  PRIMARY KEY  (`payTransID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Table structure for table `wcu`
--

DROP TABLE IF EXISTS `wcu`;
CREATE TABLE `wcu` (
  `UserKey` int(10) unsigned NOT NULL auto_increment,
  `emailaddr` varchar(45) NOT NULL default '',
  `password` varchar(45) NOT NULL default '',
  `address1` varchar(100) NOT NULL default '',
  `city` varchar(45) NOT NULL default '',
  `state` char(2) NOT NULL default '',
  `zipcode` varchar(15) NOT NULL default '',
  `country` varchar(15) NOT NULL default '',
  `phone` varchar(15) NOT NULL default '',
  `username` varchar(60) NOT NULL default '',
  `isadmin` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`UserKey`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='WalleyeCentralUsers';

--
-- Table structure for table `xref`
--

DROP TABLE IF EXISTS `xref`;
CREATE TABLE `xref` (
  `OldCode` varchar(100) default NULL,
  `NewKey` varchar(100) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;