-- MySQL dump 8.21
--
-- Host: localhost    Database: fateups
---------------------------------------------------------
-- Server version	3.23.49

--
-- Table structure for table 'eq'
--

CREATE TABLE eq (
  id int(11) NOT NULL auto_increment,
  zone varchar(20) default NULL,
  descr blob,
  days int(11) default NULL,
  min_bid int(11) default NULL,
  bid_type enum('store','bid') default NULL,
  bidder varchar(20) default NULL,
  bid int(11) default NULL,
  cur_bid_time datetime default NULL,
  prev_bid_time datetime default NULL,
  first_bid_time datetime default NULL,
  add_time datetime default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'eq'
--



--
-- Table structure for table 'incoming_eq'
--

CREATE TABLE incoming_eq (
  id int(11) NOT NULL auto_increment,
  runid int(11) default NULL,
  descr char(200) default NULL,
  days int(11) default NULL,
  min_bid int(11) default NULL,
  bid_type enum('bid','store') default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'incoming_eq'
--



--
-- Table structure for table 'log'
--

CREATE TABLE log (
  id int(11) NOT NULL auto_increment,
  time timestamp(14) NOT NULL,
  user int(11) default NULL,
  action varchar(20) default NULL,
  cdata1 varchar(20) default NULL,
  cdata2 varchar(20) default NULL,
  idata1 int(11) default NULL,
  idata2 int(11) default NULL,
  bigdata blob,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'log'
--



--
-- Table structure for table 'outgoing_eq'
--

CREATE TABLE outgoing_eq (
  id int(11) NOT NULL auto_increment,
  descr char(200) default NULL,
  bidder char(20) default NULL,
  bidtype enum('store','bid') default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'outgoing_eq'
--



--
-- Table structure for table 'runs'
--

CREATE TABLE runs (
  id int(11) NOT NULL auto_increment,
  zone int(11) default NULL,
  day int(11) default NULL,
  leader varchar(20) default NULL,
  run_type enum('keychar','self') default NULL,
  status enum('pending','rejected') default NULL,
  points blob,
  date_added datetime default NULL,
  last_mod_time datetime default NULL,
  comments blob,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'runs'
--



--
-- Table structure for table 'users'
--

CREATE TABLE users (
  id int(11) NOT NULL auto_increment,
  name varchar(20) default NULL,
  pass varchar(16) default NULL,
  points blob,
  bids blob,
  access enum('user','gate','admin') NOT NULL default 'user',
  magic int(11) default NULL,
  last_session datetime default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'users'
--


INSERT INTO users VALUES (1,'fedaklyn','1c597f2b6c8c9253','^Data::Dumper|||hex|^7b27456c647269636b7327203d3e20273137272c2753746f6e6527203d3e202732322e35272c27416c707327203d3e202738372e35277d',NULL,'admin',0,'2002-09-28 17:51:27');
INSERT INTO users VALUES (2,'agria','51e3b632390d449a',NULL,NULL,'admin',8,'2002-09-29 21:31:34');

--
-- Table structure for table 'zones'
--

CREATE TABLE zones (
  id int(11) NOT NULL auto_increment,
  name varchar(20) default NULL,
  percent int(11) default NULL,
  num_days int(11) default NULL,
  points blob,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'zones'
--


INSERT INTO zones VALUES (14,'stonetest',75,6,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273130272c276e616d6527203d3e20274170702c204744277d2c7b2776616c756527203d3e20273130272c276e616d6527203d3e20274e4d42277d2c7b2776616c756527203d3e20273135272c276e616d6527203d3e2027484c2c20417a757265277d2c7b2776616c756527203d3e20273230272c276e616d6527203d3e20275665636e61277d2c7b2776616c756527203d3e20273130272c276e616d6527203d3e2027444b277d2c7b2776616c756527203d3e20273130272c276e616d6527203d3e2027476c6162277d5d');
INSERT INTO zones VALUES (15,'Stone',75,8,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273135272c276e616d6527203d3e202764617931277d2c7b2776616c756527203d3e20273232272c276e616d6527203d3e202764617932277d2c7b2776616c756527203d3e20273134272c276e616d6527203d3e202764617933277d2c7b2776616c756527203d3e20273233272c276e616d6527203d3e202764617934277d2c7b2776616c756527203d3e20273130272c276e616d6527203d3e2027676c6162277d2c7b2776616c756527203d3e20273130272c276e616d6527203d3e2027646b277d2c7b2776616c756527203d3e202734272c276e616d6527203d3e20276c6c6f7468277d2c7b2776616c756527203d3e202737272c276e616d6527203d3e202764726f6c656d277d5d');
INSERT INTO zones VALUES (16,'Ely',50,2,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273235272c276e616d6527203d3e2027456c7931277d2c7b2776616c756527203d3e20273236272c276e616d6527203d3e2027456c7932277d5d');
INSERT INTO zones VALUES (17,'Tomb',15,4,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273136272c276e616d6527203d3e202744617931277d2c7b2776616c756527203d3e20273133272c276e616d6527203d3e202742726f6e7a65277d2c7b2776616c756527203d3e20273230272c276e616d6527203d3e202753696c766572277d2c7b2776616c756527203d3e20273232272c276e616d6527203d3e2027476f6c64277d5d');
INSERT INTO zones VALUES (18,'Kalata',25,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273139272c276e616d6527203d3e20274b616c617461277d5d');
INSERT INTO zones VALUES (19,'Lyranoth',10,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273135272c276e616d6527203d3e20274c7972277d5d');
INSERT INTO zones VALUES (20,'Demonforge',20,3,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273133272c276e616d6527203d3e20276b616e63682d656c69746573277d2c7b2776616c756527203d3e20273138272c276e616d6527203d3e202774696c612d646861756c277d2c7b2776616c756527203d3e20273134272c276e616d6527203d3e2027646179312e35277d5d');
INSERT INTO zones VALUES (21,'Coliseum',25,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273137272c276e616d6527203d3e2027436f6c69277d5d');
INSERT INTO zones VALUES (22,'Alps',50,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273335272c276e616d6527203d3e2027416c7073277d5d');
INSERT INTO zones VALUES (23,'Condemed',10,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273133272c276e616d6527203d3e2027436f6e64656d6564277d5d');
INSERT INTO zones VALUES (24,'Eldricks',15,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273137272c276e616d6527203d3e2027456c647269636b73277d5d');
INSERT INTO zones VALUES (25,'Veriguard',10,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273132272c276e616d6527203d3e202756657269277d5d');
INSERT INTO zones VALUES (26,'Estate',10,1,'^Data::Dumper|||hex|^5b756e6465662c7b2776616c756527203d3e20273139272c276e616d6527203d3e2027457374617465277d5d');