-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 15, 2008 at 08:57 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `hapes_market`
--

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

--
-- Table structure for table `gm_auctions`
--

CREATE TABLE `gm_auctions` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(100) NOT NULL default '',
  `price` varchar(50) NOT NULL default '',
  `increaseby` int(11) NOT NULL default '0',
  `currentOffer` varchar(80) NOT NULL default '0',
  `currentBidder` varchar(150) NOT NULL default '',
  `saleType` varchar(50) NOT NULL default '0',
  `saleItem` varchar(50) NOT NULL default '0',
  `saleImage` varchar(250) NOT NULL default '',
  `comments` text NOT NULL,
  `intro` varchar(255) NOT NULL default '',
  `externUrl` int(11) NOT NULL default '0',
  `validfor` varchar(80) NOT NULL default '',
  `sellPending` int(11) NOT NULL default '0',
  `sellBuyer` varchar(150) NOT NULL default '',
  `sixhourremind` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '1',
  `lastHit` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=270 ;

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

--
-- Table structure for table `gm_auctions_sil`
--

CREATE TABLE `gm_auctions_sil` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(100) NOT NULL default '',
  `price` varchar(50) NOT NULL default '',
  `increaseby` int(11) NOT NULL default '0',
  `currentOffer` varchar(80) NOT NULL default '0',
  `currentBidder` varchar(150) NOT NULL default '',
  `saleType` varchar(50) NOT NULL default '0',
  `saleItem` varchar(50) NOT NULL default '0',
  `saleImage` varchar(250) NOT NULL default '',
  `comments` text NOT NULL,
  `intro` varchar(255) NOT NULL default '',
  `externUrl` int(11) NOT NULL default '0',
  `validfor` varchar(80) NOT NULL default '',
  `sellPending` int(11) NOT NULL default '0',
  `sellBuyer` varchar(150) NOT NULL default '',
  `sixhourremind` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '1',
  `lastHit` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=164 ;

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

--
-- Table structure for table `gm_casino`
--

CREATE TABLE `gm_casino` (
  `id` int(11) NOT NULL auto_increment,
  `LOGIN` varchar(50) NOT NULL default '',
  `CHIPS` int(11) NOT NULL default '0',
  `CHIPSout` int(11) NOT NULL default '0',
  `PLAYDATE` varchar(50) NOT NULL default '',
  `PLAYED` varchar(200) NOT NULL default '',
  `PAYOUT` varchar(50) NOT NULL default '',
  `PAYIN` varchar(50) NOT NULL default '',
  `RPLAYED` varchar(50) NOT NULL default '',
  `RPLAYEDSTAMP` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1853 ;

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

--
-- Table structure for table `gm_casino_bonus`
--

CREATE TABLE `gm_casino_bonus` (
  `USER` varchar(150) NOT NULL default '',
  `BONUS` varchar(20) NOT NULL default '',
  `STAMP` varchar(50) NOT NULL default '',
  `ADMIN` varchar(150) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gm_casino_bookkeeping`
--

CREATE TABLE `gm_casino_bookkeeping` (
  `CASHIN` int(50) NOT NULL default '0',
  `CASHOUT` int(50) NOT NULL default '0',
  `THEDATE` varchar(80) NOT NULL default '',
  `PERSON` varchar(100) NOT NULL default '',
  `COMMENTS` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gm_casino_transactions`
--

CREATE TABLE `gm_casino_transactions` (
  `NEWAMOUNT` varchar(50) NOT NULL default '',
  `BET` varchar(100) NOT NULL default '',
  `SENDER` varchar(100) NOT NULL default '',
  `RECEIVER` varchar(100) NOT NULL default '',
  `THETIME` varchar(50) NOT NULL default '',
  `LTIME` varchar(50) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gm_icq`
--

CREATE TABLE `gm_icq` (
  `id` int(11) NOT NULL auto_increment,
  `lookingAt` varchar(150) NOT NULL default '',
  `theLooker` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15262 ;

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

--
-- Table structure for table `gm_ipTracker`
--

CREATE TABLE `gm_ipTracker` (
  `handle` varchar(80) NOT NULL default '',
  `listIP` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `gm_middle`
--

CREATE TABLE `gm_middle` (
  `id` int(11) NOT NULL auto_increment,
  `middle` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

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

--
-- Table structure for table `gm_pending`
--

CREATE TABLE `gm_pending` (
  `id` int(11) NOT NULL auto_increment,
  `buyer` varchar(150) NOT NULL default '',
  `traderName` varchar(150) NOT NULL default '',
  `amount` int(11) NOT NULL default '0',
  `transactionID` int(11) NOT NULL default '0',
  `reminder` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=197 ;

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

--
-- Table structure for table `gm_remind`
--

CREATE TABLE `gm_remind` (
  `id` int(11) NOT NULL auto_increment,
  `traderName` varchar(100) NOT NULL default '',
  `remindType` int(11) NOT NULL default '0',
  `remindID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=352 ;

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

--
-- Table structure for table `gm_sale`
--

CREATE TABLE `gm_sale` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(100) NOT NULL default '',
  `price` int(11) NOT NULL default '0',
  `origAmount` int(11) NOT NULL default '1',
  `amount` int(11) NOT NULL default '1',
  `saleType` varchar(50) NOT NULL default '0',
  `saleItem` varchar(50) NOT NULL default '0',
  `saleImage` varchar(250) NOT NULL default '',
  `comments` text NOT NULL,
  `intro` varchar(255) NOT NULL default '',
  `externUrl` int(11) NOT NULL default '0',
  `sellPending` int(11) NOT NULL default '0',
  `sellBuyer` varchar(150) NOT NULL default '',
  `stamp` varchar(80) NOT NULL default '',
  `location` varchar(150) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `lastHit` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3940 ;

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

--
-- Table structure for table `gm_stats`
--

CREATE TABLE `gm_stats` (
  `cash` int(11) NOT NULL default '0',
  `auctions` int(11) NOT NULL default '0',
  `sales` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

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

--
-- Table structure for table `gm_statsUsers`
--

CREATE TABLE `gm_statsUsers` (
  `id` int(11) NOT NULL auto_increment,
  `traderName` varchar(100) NOT NULL default '',
  `credits` varchar(250) NOT NULL default '0',
  `saleItem` varchar(120) NOT NULL default '0',
  `saleType` varchar(120) NOT NULL default '0',
  `saleImage` varchar(50) NOT NULL default '',
  `externUrl` int(11) NOT NULL default '0',
  `sellerFeedback` varchar(255) NOT NULL default 'open',
  `sellerFeedType` int(11) NOT NULL default '1',
  `buyerFeedback` varchar(255) NOT NULL default 'open',
  `buyerFeedType` int(11) NOT NULL default '1',
  `buyer` varchar(100) NOT NULL default '',
  `stamp` varchar(80) NOT NULL default '',
  `sellingID` varchar(5) NOT NULL default '0',
  `amount` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1793 ;

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

--
-- Table structure for table `gm_thiefs`
--

CREATE TABLE `gm_thiefs` (
  `id` int(11) NOT NULL auto_increment,
  `thief` varchar(150) NOT NULL default '',
  `added` varchar(150) NOT NULL default '',
  `reason` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ;

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

--
-- Table structure for table `gm_trade`
--

CREATE TABLE `gm_trade` (
  `id` int(11) NOT NULL auto_increment,
  `owner` varchar(100) NOT NULL default '',
  `price` varchar(255) NOT NULL default '0',
  `origAmount` int(11) NOT NULL default '1',
  `amount` int(11) NOT NULL default '1',
  `saleType` varchar(50) NOT NULL default '0',
  `saleItem` varchar(50) NOT NULL default '0',
  `saleImage` varchar(250) NOT NULL default '',
  `comments` text NOT NULL,
  `intro` varchar(255) NOT NULL default '',
  `externUrl` int(11) NOT NULL default '0',
  `sellPending` int(11) NOT NULL default '0',
  `sellBuyer` varchar(150) NOT NULL default '',
  `stamp` varchar(80) NOT NULL default '',
  `location` varchar(150) NOT NULL default '',
  `hits` int(11) NOT NULL default '0',
  `lastHit` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;

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

--
-- Table structure for table `gm_users`
--

CREATE TABLE `gm_users` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(250) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `session` varchar(80) NOT NULL default '',
  `admin` int(11) NOT NULL default '0',
  `email` varchar(250) NOT NULL default '',
  `myimage` varchar(250) NOT NULL default 'http://www.hapes.org/gm/images/noImage.gif',
  `icq` varchar(80) NOT NULL default '',
  `msn` varchar(80) NOT NULL default '',
  `LASTLOGIN` varchar(80) NOT NULL default '',
  `LASTLOGINLINUX` varchar(80) NOT NULL default '',
  `LOGGEDIP` varchar(80) NOT NULL default '',
  `LOGGEDHOST` varchar(150) NOT NULL default '',
  `middles` text NOT NULL,
  `intro` varchar(255) NOT NULL default 'Default intro available via Profile!',
  `detailed` text NOT NULL,
  `userAuthed` int(11) NOT NULL default '0',
  `authed` varchar(80) NOT NULL default '',
  `authCode` varchar(150) NOT NULL default '',
  `reminder` int(11) NOT NULL default '2',
  `charDesc` varchar(255) NOT NULL default 'A humble trader',
  `infomail` int(11) NOT NULL default '0',
  `pos` int(11) NOT NULL default '0',
  `neu` int(11) NOT NULL default '0',
  `neg` int(11) NOT NULL default '0',
  `oldgmadded` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1924 ;

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

--
-- Table structure for table `hawk_comunit`
--

CREATE TABLE `hawk_comunit` (
  `RECEIVER` varchar(200) NOT NULL default '',
  `SENDER` varchar(200) NOT NULL default '',
  `FOLDER` varchar(200) NOT NULL default 'Inbox',
  `SUBJECT` varchar(250) NOT NULL default 'no subject',
  `MSG` text NOT NULL,
  `ID` int(11) NOT NULL auto_increment,
  `NEW` int(11) NOT NULL default '1',
  `SENDDATE` varchar(200) NOT NULL default '',
  `PRIORITY` int(11) NOT NULL default '0',
  `REMOVALSTAMP` varchar(80) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=321154 ;

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

--
-- Table structure for table `hawk_comunitfolders`
--

CREATE TABLE `hawk_comunitfolders` (
  `ID` int(11) NOT NULL auto_increment,
  `FOLDER` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Table structure for table `hawk_comunitsent`
--

CREATE TABLE `hawk_comunitsent` (
  `RECEIVER` varchar(200) NOT NULL default '',
  `SENDER` varchar(200) NOT NULL default '',
  `SUBJECT` varchar(250) NOT NULL default 'no subject',
  `MSG` text NOT NULL,
  `ID` int(11) NOT NULL auto_increment,
  `FOLDER` varchar(200) NOT NULL default 'Sent',
  `NEW` int(11) NOT NULL default '1',
  `SENDDATE` varchar(200) NOT NULL default '',
  `PRIORITY` int(11) NOT NULL default '0',
  `REMOVALSTAMP` varchar(80) NOT NULL,
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=44968 ;