-- phpMyAdmin SQL Dump
-- version 2.11.2.1
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生成日期: 2010 年 08 月 13 日 11:33
-- 服务器版本: 5.0.45
-- PHP 版本: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 数据库: `weabid_db`
--

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

--
-- 表的结构 `auction`
--

CREATE TABLE `auction` (
  `auction_code` varchar(10) NOT NULL default '',
  `auctionID` int(11) NOT NULL auto_increment,
  `categoryID` int(11) NOT NULL default '0',
  `productID` int(11) NOT NULL default '0',
  `auc_start_price` float(20,2) NOT NULL default '0.00',
  `auc_final_price` float(20,2) NOT NULL default '0.00',
  `auc_final_end_date` varchar(50) NOT NULL default '0000-00-00 00:00:00',
  `auc_start_date` date NOT NULL default '0000-00-00',
  `auc_end_date` varchar(30) NOT NULL default '0000-00-00',
  `auc_start_time` varchar(50) NOT NULL default '00:00:00',
  `auc_end_time` varchar(50) NOT NULL default '00:00:00',
  `auc_status` int(11) NOT NULL default '2',
  `auc_type` varchar(50) NOT NULL default '',
  `fixedpriceauction` int(11) NOT NULL default '0',
  `pennyauction` int(11) NOT NULL default '0',
  `nailbiterauction` int(11) NOT NULL default '0',
  `offauction` int(11) NOT NULL default '0',
  `nightauction` int(11) NOT NULL default '0',
  `openauction` int(11) NOT NULL default '0',
  `time_duration` varchar(10) NOT NULL default '',
  `auc_recurr` varchar(20) NOT NULL default '',
  `buy_user` int(11) NOT NULL default '0',
  `total_time` int(20) NOT NULL default '0',
  `pause_status` int(2) NOT NULL default '0',
  `shipping_id` int(11) NOT NULL default '0',
  `featured_flag` enum('0','1') NOT NULL default '0',
  `featured_picture1` varchar(255) NOT NULL default '',
  `future_tstamp` double default '0',
  `auction_min_price` float(20,2) NOT NULL default '0.00',
  `min_win_price` float(20,2) NOT NULL,
  `vip_id` int(11) default NULL,
  `is_close` tinyint(1) NOT NULL default '0',
  `is_hot` tinyint(1) NOT NULL,
  `is_exprice` tinyint(1) NOT NULL,
  `showpoint` int(11) NOT NULL default '0',
  PRIMARY KEY  (`auctionID`),
  KEY `auctionID` (`auctionID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `auction_admin`
--

CREATE TABLE `auction_admin` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `pass` varchar(30) NOT NULL default '',
  `firstname` varchar(255) NOT NULL default '',
  `lastname` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `phoneno` varchar(20) NOT NULL default '',
  `type` int(3) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `auction_management`
--

CREATE TABLE `auction_management` (
  `id` int(11) NOT NULL auto_increment,
  `auc_title` varchar(255) NOT NULL default '',
  `auc_plus_price` float(20,2) NOT NULL default '0.00',
  `auc_plus_time` int(20) NOT NULL default '0',
  `auc_manage` varchar(20) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `auction_sms`
--

CREATE TABLE `auction_sms` (
  `id` int(11) NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `sms_count` int(11) NOT NULL default '0',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `auc_due_table`
--

CREATE TABLE `auc_due_table` (
  `id` int(11) NOT NULL auto_increment,
  `auction_id` int(11) NOT NULL default '0',
  `auc_due_time` int(20) NOT NULL default '0',
  `auc_due_price` float(20,2) NOT NULL default '0.00',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `auc_show`
--

CREATE TABLE `auc_show` (
  `id` mediumint(11) unsigned NOT NULL auto_increment,
  `username` char(20) NOT NULL,
  `headering` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `detail` text,
  `market_price` float(8,2) unsigned default '0.00',
  `spread_price` float(8,2) unsigned default '0.00',
  `end_time` int(11) unsigned default '0',
  `ip` varchar(50) default NULL,
  `reply_count` smallint(11) unsigned default '0',
  `addtime` int(11) unsigned default '0',
  `is_audit` tinyint(1) NOT NULL default '0',
  `bid_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  `money` int(11) NOT NULL default '0',
  `replynum` int(11) NOT NULL default '0',
  `clicknum` int(11) NOT NULL default '0',
  `is_top` tinyint(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `bidpack`
--

CREATE TABLE `bidpack` (
  `id` int(11) NOT NULL auto_increment,
  `bidpack_name` varchar(100) NOT NULL default '',
  `bid_size` int(10) NOT NULL default '0',
  `bid_price` float(20,2) NOT NULL default '0.00',
  `bidpack_price` float(20,2) NOT NULL default '0.00',
  `bidpack_banner` varchar(255) NOT NULL default '',
  `cn_bidpack_banner` varchar(255) NOT NULL default '',
  `cn_bidpack_name` varchar(255) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `bidsinfo`
--

CREATE TABLE `bidsinfo` (
  `auctionID` int(11) NOT NULL,
  `bids_info` varchar(100) default NULL,
  PRIMARY KEY  (`auctionID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- 表的结构 `bid_account`
--

CREATE TABLE `bid_account` (
  `id` int(1) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `bidpack_id` int(11) NOT NULL default '0',
  `bidpack_buy_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `bid_count` int(20) NOT NULL default '0',
  `auction_id` int(11) NOT NULL default '0',
  `product_id` int(11) NOT NULL default '0',
  `bid_flag` varchar(10) NOT NULL default '',
  `bidding_price` float(20,2) NOT NULL default '0.00',
  `bidding_type` varchar(10) NOT NULL default '',
  `recharge_type` varchar(10) NOT NULL default '',
  `referer_id` int(11) NOT NULL default '0',
  `bidding_time` int(11) NOT NULL default '0',
  `credit_description` text,
  `cn_credit_description` varchar(255) default NULL,
  `read_flag` tinyint(4) default '0',
  KEY `id` (`id`),
  KEY `user_id` (`user_id`),
  KEY `auction_id` (`auction_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `categories`
--

CREATE TABLE `categories` (
  `categoryID` int(11) NOT NULL auto_increment,
  `language_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `products_count` int(11) NOT NULL default '0',
  `description` text NOT NULL,
  `picture` varchar(100) NOT NULL default '',
  `status` int(11) NOT NULL default '0',
  `cn_name` varchar(100) NOT NULL default '',
  `cn_description` varchar(255) NOT NULL,
  KEY `categoryID` (`categoryID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `chat`
--

CREATE TABLE `chat` (
  `id` int(11) NOT NULL auto_increment,
  `bid` int(11) NOT NULL,
  `content` varchar(255) default NULL,
  `addtime` varchar(50) default NULL,
  `username` varchar(59) default NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `countries`
--

CREATE TABLE `countries` (
  `countryId` int(11) NOT NULL auto_increment,
  `iso` char(2) NOT NULL default '',
  `printable_name` varchar(80) NOT NULL default '',
  `iso3` char(3) default NULL,
  `numcode` smallint(6) default NULL,
  PRIMARY KEY  (`iso`),
  KEY `id` (`countryId`),
  KEY `id_2` (`countryId`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `faq`
--

CREATE TABLE `faq` (
  `id` int(11) NOT NULL auto_increment,
  `que_content` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `general_setting`
--

CREATE TABLE `general_setting` (
  `id` int(11) NOT NULL auto_increment,
  `euro` float(20,2) NOT NULL default '0.00',
  `dinars` float(20,2) NOT NULL default '0.00',
  `smsrateincl` float(20,2) NOT NULL default '0.00',
  `smsrateexcl` float(20,2) NOT NULL default '0.00',
  `mobileoperator` float(20,2) NOT NULL default '0.00',
  `smsgateway` float(20,2) NOT NULL default '0.00',
  `othercost` float(20,2) NOT NULL default '0.00',
  `totaldetraction` float(20,2) NOT NULL default '0.00',
  `netsave` float(20,2) NOT NULL default '0.00',
  `ccgatewayfixfees` float(20,2) NOT NULL default '0.00',
  `ccgatewayvariablefees` float(20,2) NOT NULL default '0.00',
  `perday_sms` int(11) NOT NULL default '0',
  `perday_sms_flag` enum('0','1') NOT NULL default '0',
  `min_bid_price` float(20,2) NOT NULL,
  `sysbid_flag` tinyint(4) default '1',
  `stop_flag` int(1) NOT NULL default '0',
  `is_mutex` int(1) NOT NULL default '0' COMMENT '0 no instance\r\n1 one instance',
  `smtpserver` varchar(255) character set gb2312 default NULL,
  `smtpserverport` int(11) default NULL,
  `smtpusermail` varchar(255) default NULL,
  `smtpuser` varchar(255) default NULL,
  `smtppass` varchar(20) default NULL,
  `ipban` text,
  `can_banip` tinyint(4) default NULL,
  `logo_pic` varchar(255) default NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- 表的结构 `language`
--

CREATE TABLE `language` (
  `id` int(6) NOT NULL auto_increment,
  `language_prefix` varchar(255) NOT NULL default '',
  `language_name` varchar(255) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=2 ;

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

--
-- 表的结构 `login_logout`
--

CREATE TABLE `login_logout` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL default '0',
  `ipaddress` varchar(50) NOT NULL default '',
  `login_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `logout_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `load_time` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `news_title` varchar(100) NOT NULL default '',
  `news_type` char(1) NOT NULL default '1',
  `news_date` date NOT NULL default '0000-00-00',
  `news_short_content` text NOT NULL,
  `news_long_content` text NOT NULL,
  `cn_news_title` varchar(100) NOT NULL default '',
  `cn_news_short_content` text NOT NULL,
  `cn_news_long_content` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

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

--
-- 表的结构 `newslatter_email`
--

CREATE TABLE `newslatter_email` (
  `id` int(11) NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `subject` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `cn_subject` varchar(255) NOT NULL default '',
  `cn_content` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `payment_detail`
--

CREATE TABLE `payment_detail` (
  `id` int(11) NOT NULL auto_increment,
  `transaction_id` varchar(100) NOT NULL default '',
  `user_id` int(11) NOT NULL default '0',
  `bidpack_id` int(11) NOT NULL default '0',
  `auction_id` int(11) NOT NULL default '0',
  `temp_data` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `paypal_info`
--

CREATE TABLE `paypal_info` (
  `id` int(11) NOT NULL auto_increment,
  `business_id` varchar(100) NOT NULL default '',
  `token` varchar(255) NOT NULL default '',
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `products`
--

CREATE TABLE `products` (
  `productID` int(11) NOT NULL auto_increment,
  `categoryID` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `custmer_rating` float(20,2) NOT NULL default '0.00',
  `price` float(20,2) NOT NULL default '0.00',
  `enabled` int(10) NOT NULL default '0',
  `product_code` varchar(25) NOT NULL default '',
  `short_desc` text NOT NULL,
  `long_desc` text NOT NULL,
  `picture1` varchar(255) NOT NULL default '',
  `picture2` varchar(255) NOT NULL default '',
  `picture3` varchar(255) NOT NULL default '',
  `picture4` varchar(255) NOT NULL default '',
  `picture_thumb` varchar(255) NOT NULL default '',
  `picture_popup` varchar(255) NOT NULL default '',
  `metatags` text NOT NULL,
  `metadescription` text NOT NULL,
  `actual_cost` double(20,2) NOT NULL default '0.00',
  `product_qty` int(11) NOT NULL default '0',
  `qty_flag` enum('0','1') NOT NULL default '0',
  `cn_name` varchar(255) NOT NULL default '',
  `cn_short_desc` text NOT NULL,
  `cn_long_desc` text NOT NULL,
  PRIMARY KEY  (`productID`),
  KEY `productID` (`productID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `registration`
--

CREATE TABLE `registration` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(100) NOT NULL default '',
  `firstname` varchar(100) NOT NULL default '',
  `lastname` varchar(100) NOT NULL default '',
  `sex` varchar(10) NOT NULL default '',
  `birth_date` varchar(50) NOT NULL default '',
  `addressline1` varchar(255) NOT NULL default '',
  `addressline2` varchar(255) NOT NULL default '',
  `city` varchar(100) NOT NULL default '',
  `state` varchar(100) NOT NULL default '',
  `country` varchar(100) NOT NULL default '',
  `postcode` varchar(50) NOT NULL default '',
  `phone` varchar(50) NOT NULL default '',
  `mobile_no` varchar(20) NOT NULL default '',
  `full_mobileno` varchar(20) NOT NULL default '',
  `email` varchar(150) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `delivery_name` varchar(100) NOT NULL default '',
  `delivery_addressline1` varchar(255) NOT NULL default '',
  `delivery_addressline2` varchar(255) NOT NULL default '',
  `delivery_city` varchar(100) NOT NULL default '',
  `delivery_state` varchar(100) NOT NULL default '',
  `delivery_country` varchar(100) NOT NULL default '',
  `delivery_postcode` varchar(50) NOT NULL default '',
  `delivery_phone` varchar(50) NOT NULL default '',
  `terms_condition` int(5) NOT NULL default '0',
  `privacy` int(5) NOT NULL default '0',
  `newsletter_email` varchar(100) NOT NULL default '',
  `newslatter` int(5) NOT NULL default '0',
  `final_bids` int(10) NOT NULL default '0',
  `account_status` int(2) NOT NULL default '0',
  `member_status` enum('0','1') NOT NULL default '0',
  `user_delete_flag` varchar(10) NOT NULL default '',
  `sponser` int(11) NOT NULL default '0',
  `register_date` date NOT NULL default '0000-00-00',
  `sms_flag` enum('0','1') NOT NULL default '0',
  `admin_user_flag` enum('0','1') NOT NULL default '0',
  `verify_code` varchar(100) NOT NULL,
  `can_send_gift` varchar(100) NOT NULL default '0',
  `sent_gift` varchar(100) NOT NULL default '0',
  `header` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `shipping`
--

CREATE TABLE `shipping` (
  `id` int(11) NOT NULL auto_increment,
  `shipping_title` varchar(255) NOT NULL default '',
  `shippingcharge` double(10,2) NOT NULL default '0.00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `shops_orders`
--

CREATE TABLE `shops_orders` (
  `oid` varchar(80) NOT NULL,
  `userid` int(10) NOT NULL,
  `pid` int(10) NOT NULL default '0',
  `paytype` tinyint(2) NOT NULL default '1',
  `cartcount` int(10) NOT NULL default '0',
  `dprice` float(13,2) NOT NULL default '0.00',
  `price` float(13,2) NOT NULL default '0.00',
  `priceCount` float(13,2) NOT NULL,
  `state` tinyint(1) NOT NULL default '0',
  `ip` char(15) NOT NULL default '',
  `stime` datetime NOT NULL default '0000-00-00 00:00:00',
  `aid` int(11) default NULL,
  PRIMARY KEY  (`oid`),
  KEY `stime` (`stime`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

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

--
-- 表的结构 `shops_userinfo`
--

CREATE TABLE `shops_userinfo` (
  `userid` int(10) NOT NULL,
  `oid` varchar(80) NOT NULL default '',
  `consignee` char(15) NOT NULL default '',
  `address` varchar(255) NOT NULL default '',
  `zip` int(10) NOT NULL default '0',
  `tel` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `des` varchar(255) NOT NULL default '',
  KEY `oid` (`oid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

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

--
-- 表的结构 `show_photo`
--

CREATE TABLE `show_photo` (
  `id` smallint(11) unsigned NOT NULL auto_increment,
  `detail_img` varchar(250) default NULL,
  `show_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `show_reply`
--

CREATE TABLE `show_reply` (
  `id` mediumint(11) unsigned NOT NULL auto_increment,
  `show_key` varchar(100) NOT NULL,
  `username` char(20) default NULL,
  `headering` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `detail` text,
  `ip` varchar(50) default NULL,
  `region` varchar(255) default NULL,
  `state` tinyint(1) unsigned default '0',
  `addtime` int(11) unsigned default '0',
  `show_id` int(11) NOT NULL,
  `member_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `smsbid_data`
--

CREATE TABLE `smsbid_data` (
  `id` int(11) NOT NULL auto_increment,
  `messagedata` varchar(100) NOT NULL default '',
  `message_time` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
-- 表的结构 `static_pages`
--

CREATE TABLE `static_pages` (
  `id` int(11) NOT NULL auto_increment,
  `content` text NOT NULL,
  `cn_content` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


CREATE TABLE `won_auctions` (
  `id` int(11) NOT NULL auto_increment,
  `auction_id` int(11) NOT NULL default '0',
  `accept_denied` varchar(100) NOT NULL default '',
  `userid` int(11) NOT NULL default '0',
  `won_date` varchar(50) NOT NULL default '0000-00-00 00:00:00',
  `accept_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `payment_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `invoice_flag` enum('0','1') NOT NULL default '0',
  `mail_flag` tinyint(4) NOT NULL default '0',
  `show_flag` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- 表的结构 `auction_pause_management`
--

CREATE TABLE `auction_pause_management` (
  `id` int(11) NOT NULL auto_increment,
  `pause_start_time` time NOT NULL default '00:00:00',
  `pause_end_time` time NOT NULL default '00:00:00',
  `smsbid_data` varchar(50) NOT NULL default '',
  `auction_end` enum('0','1') NOT NULL default '0',
  `referral_bids` int(10) NOT NULL default '0',
  `pause_start_timestamp` double NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=5 ;
INSERT INTO `auction_pause_management` (`id`, `pause_start_time`, `pause_end_time`, `smsbid_data`, `auction_end`, `referral_bids`, `pause_start_timestamp`) VALUES
(2, '00:00:00', '00:00:00', '', '0', 10, 0);


INSERT INTO `language` (`id`, `language_prefix`, `language_name`) VALUES
(1, 'cn', 'China');

INSERT INTO `auction_admin` (`id`, `username`, `pass`, `firstname`, `lastname`, `email`, `phoneno`, `type`) VALUES
(1, 'admin', 'admin', '', '', '', '', 1);

INSERT INTO `general_setting` (`id`, `euro`, `dinars`, `smsrateincl`, `smsrateexcl`, `mobileoperator`, `smsgateway`, `othercost`, `totaldetraction`, `netsave`, `ccgatewayfixfees`, `ccgatewayvariablefees`, `perday_sms`, `perday_sms_flag`, `min_bid_price`, `sysbid_flag`, `stop_flag`, `is_mutex`, `smtpserver`, `smtpserverport`, `smtpusermail`, `smtpuser`, `smtppass`, `ipban`, `can_banip`, `logo_pic`) VALUES
(1, 1.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10, '1', 1.00, 1, 0, 1, 'smtp.qq.com', 25, '1490724@qq.com', '1490724@qq.com', 'zcwisheo', NULL, 0, 'logo.gif');
