21wenju.rar

# MySQL-Front Dump 2.5

#

# Host: localhost   Database: 21wenju

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

# Server version 4.0.14-nt

 

 

#

# Table structure for table 'productfirstlevel'

#

 

CREATE TABLE productfirstlevel (
  Id int(6) unsigned NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  memo varchar(250) default NULL,
  asIndex int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'productsecondlevel'

#

 

CREATE TABLE productsecondlevel (
  FirstID int(6) unsigned NOT NULL default '0',
  Id int(6) unsigned NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  memo varchar(250) default NULL,
  asIndex int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'users'

#

 

CREATE TABLE users (
  Id int(10) unsigned NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  PASSWORD varchar(50) NOT NULL default '',
  AccountStatus char(2) default NULL,
  type char(1) default NULL,
  PRIMARY KEY  (Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_area'

#

 

CREATE TABLE wj_area (
  AreaNo varchar(8) NOT NULL default '',
  AreaName varchar(40) NOT NULL default '',
  PRIMARY KEY  (AreaNo)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_brand'

#

 

CREATE TABLE wj_brand (
  BrandID varchar(20) NOT NULL default '',
  UserID int(10) unsigned default NULL,
  FirstID int(6) unsigned default NULL,
  BrandChName varchar(50) NOT NULL default '',
  BrandEnName varchar(50) NOT NULL default '',
  BrandDate datetime NOT NULL default '0000-00-00 00:00:00',
  BrandPicture varchar(30) NOT NULL default '',
  LogoPicture varchar(30) default NULL,
  BrandRecommand char(1) NOT NULL default '',
  BrandDetail text NOT NULL,
  PRIMARY KEY  (BrandID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_bu_basket'

#

 

CREATE TABLE wj_bu_basket (
  UserID int(10) unsigned NOT NULL default '0',
  BasketID varchar(20) NOT NULL default '',
  BasketType char(1) NOT NULL default '',
  BasketQueryID varchar(20) NOT NULL default '',
  BasketQueryType varchar(6) default NULL,
  BasketTopic varchar(50) NOT NULL default '',
  BasketStatus char(1) NOT NULL default '',
  BasketDate datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (UserID,BasketID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_bu_card'

#

 

CREATE TABLE wj_bu_card (
  UserID int(10) unsigned NOT NULL default '0',
  GroupID varchar(20) NOT NULL default '',
  username varchar(50) NOT NULL default '',
  PRIMARY KEY  (UserID,GroupID,username)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_bu_card_group'

#

 

CREATE TABLE wj_bu_card_group (
  UserID int(10) unsigned NOT NULL default '0',
  GroupID varchar(20) NOT NULL default '',
  GroupName varchar(40) NOT NULL default '',
  GroupCanUpdate char(1) NOT NULL default '',
  PRIMARY KEY  (UserID,GroupID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_bu_message_inbox'

#

 

CREATE TABLE wj_bu_message_inbox (
  UserID int(10) unsigned NOT NULL default '0',
  username varchar(50) NOT NULL default '',
  MessageID varchar(20) NOT NULL default '',
  MessageType char(3) NOT NULL default '',
  MessageTitle varchar(100) NOT NULL default '',
  MessageDetail text NOT NULL,
  MessageSendDate datetime NOT NULL default '0000-00-00 00:00:00',
  MessageRead char(1) default NULL,
  PRIMARY KEY  (MessageID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_bu_message_outbox'

#

 

CREATE TABLE wj_bu_message_outbox (
  UserID int(10) unsigned NOT NULL default '0',
  username varchar(50) NOT NULL default '',
  MessageID varchar(20) NOT NULL default '',
  MessageType char(3) NOT NULL default '',
  MessageTitle varchar(100) NOT NULL default '',
  MessageDetail text NOT NULL,
  MessageSendDate datetime NOT NULL default '0000-00-00 00:00:00',
  MessageRead char(1) default NULL,
  PRIMARY KEY  (MessageID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_certification'

#

 

CREATE TABLE wj_certification (
  CertificationId varchar(20) NOT NULL default '',
  UserID int(10) unsigned default NULL,
  CertificateBaseType char(2) NOT NULL default '',
  CertificateType char(2) NOT NULL default '',
  CertificateName varchar(100) NOT NULL default '',
  CertificateUpDate datetime NOT NULL default '0000-00-00 00:00:00',
  BeginDate date NOT NULL default '0000-00-00',
  EndDate date NOT NULL default '0000-00-00',
  Institute varchar(100) NOT NULL default '',
  InstitutePhone varchar(30) NOT NULL default '',
  InstituteWeb varchar(100) NOT NULL default '',
  CertificateNo varchar(100) NOT NULL default '',
  Picture varchar(30) NOT NULL default '',
  Content text NOT NULL,
  PRIMARY KEY  (CertificationId)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_certification_info'

#

 

CREATE TABLE wj_certification_info (
  UserID int(10) unsigned default NULL,
  CertificateID varchar(10) default NULL,
  Score float default NULL
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_certification_ref'

#

 

CREATE TABLE wj_certification_ref (
  CertificateID char(3) NOT NULL default '',
  CertificateName varchar(50) NOT NULL default '',
  Score float NOT NULL default '0',
  PRIMARY KEY  (CertificateID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_commodity'

#

 

CREATE TABLE wj_commodity (
  COMM_ID varchar(50) NOT NULL default '',
  Id int(10) unsigned NOT NULL default '0',
  COMM_NAME varchar(60) NOT NULL default '',
  Score int(10) unsigned NOT NULL default '0',
  UNIT_NAME varchar(4) NOT NULL default '',
  COMM_STOP char(1) NOT NULL default '',
  COMM_RANK_ONE varchar(40) NOT NULL default '',
  COMM_RANK_TWO varchar(40) NOT NULL default '',
  COMM_VIEW_NUMBER int(10) unsigned NOT NULL default '0',
  COMM_MARK varchar(20) NOT NULL default '',
  COMM_BUILDER_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  COMM_ORDER int(10) unsigned NOT NULL default '0',
  COMM_HOME varchar(20) NOT NULL default '',
  COMM_MARKET_PRICE double NOT NULL default '0',
  COMM_SEND_PAY_TYPE varchar(50) NOT NULL default '',
  COMM_CLASS varchar(50) NOT NULL default '',
  COMM_MUMBER_PRICE double NOT NULL default '0',
  COMM_VIP_PRICE double NOT NULL default '0',
  COMM_LIB_NUMBER int(10) unsigned NOT NULL default '0',
  COMM_SCOPE varchar(40) NOT NULL default '',
  COMM_DESC text NOT NULL,
  COMM_RECOMMAND char(1) NOT NULL default '',
  COMM_PIC varchar(40) NOT NULL default '',
  PRIMARY KEY  (COMM_ID,Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_commodity_comment'

#

 

CREATE TABLE wj_commodity_comment (
  COMMENT_ID varchar(50) NOT NULL default '',
  COMM_ID varchar(50) default NULL,
  Id int(10) unsigned default NULL,
  COMMENT_NAME varchar(20) NOT NULL default '',
  COMMENT_RANK int(10) unsigned NOT NULL default '0',
  COMMENT_TITLE varchar(40) NOT NULL default '',
  COMMENT_IP varchar(20) NOT NULL default '',
  COMMENT_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  COMMENT_CONTENT text NOT NULL,
  PRIMARY KEY  (COMMENT_ID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_company_business'

#

 

CREATE TABLE wj_company_business (
  UserID int(10) unsigned default NULL,
  FirstID int(6) unsigned default NULL,
  SecondID int(6) unsigned default NULL
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_company_info'

#

 

CREATE TABLE wj_company_info (
  UserID int(10) unsigned NOT NULL default '0',
  CompanyName varchar(50) NOT NULL default '',
  CompanyRegister char(1) NOT NULL default '',
  Score float NOT NULL default '0',
  CompanyIndustry varchar(10) NOT NULL default '',
  CompanyDelegate varchar(40) default NULL,
  CompanyCharacter char(2) NOT NULL default '',
  CompanyPinpai varchar(40) NOT NULL default '',
  CompanyType char(2) NOT NULL default '',
  CompanyMoney varchar(20) default NULL,
  CompanyBuilderDate date default NULL,
  CompanyRegisterDate datetime default NULL,
  CompanyNumber varchar(11) default NULL,
  ComapnyEarn varchar(20) default NULL,
  CompanyMarket varchar(20) NOT NULL default '',
  CompanyOtherMarket varchar(40) default NULL,
  CompanyDetail text NOT NULL,
  Companylogo varchar(30) default NULL,
  Companypicture varchar(30) default NULL,
  PRIMARY KEY  (UserID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_country'

#

 

CREATE TABLE wj_country (
  CounryShortName varchar(30) NOT NULL default '',
  CountryName varchar(50) NOT NULL default '',
  PhoneCode varchar(8) NOT NULL default '',
  PRIMARY KEY  (CounryShortName)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_domain'

#

 

CREATE TABLE wj_domain (
  DomainName varchar(50) NOT NULL default '',
  UserID int(10) unsigned NOT NULL default '0',
  Style char(3) NOT NULL default '',
  ViewNumber int(10) unsigned NOT NULL default '0',
  BuilderDate datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (UserID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_exhi_product'

#

 

CREATE TABLE wj_exhi_product (
  ProductID varchar(20) NOT NULL default '',
  FirstID int(6) unsigned NOT NULL default '0',
  SecondID int(6) unsigned NOT NULL default '0',
  UserID int(10) unsigned default NULL,
  Score float NOT NULL default '0',
  ClassID varchar(20) default NULL,
  ProductName varchar(40) NOT NULL default '',
  ProductViewNumber int(10) unsigned NOT NULL default '0',
  ProductOrder int(10) unsigned NOT NULL default '0',
  ProductStatus char(1) NOT NULL default '',
  ProdocutRecommand char(1) NOT NULL default '',
  ProductRand varchar(40) NOT NULL default '',
  ProductSourcePlace varchar(80) NOT NULL default '',
  ProductRefPrice varchar(20) NOT NULL default '',
  ProductSupplyAbility varchar(20) NOT NULL default '',
  ProductKeyWords varchar(80) NOT NULL default '',
  ProductBuilderDate datetime NOT NULL default '0000-00-00 00:00:00',
  ProductPicture varchar(40) NOT NULL default '',
  ProductDesc text,
  PRIMARY KEY  (ProductID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_exhi_product_class'

#

 

CREATE TABLE wj_exhi_product_class (
  ClassID varchar(20) NOT NULL default '',
  UserID int(10) unsigned default NULL,
  ClassName varchar(40) NOT NULL default '',
  ClassDesc text,
  PRIMARY KEY  (ClassID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_expo'

#

 

CREATE TABLE wj_expo (
  ExpoID varchar(20) NOT NULL default '',
  UserID int(10) unsigned default NULL,
  ContributeID varchar(20) default NULL,
  ExpoDate datetime NOT NULL default '0000-00-00 00:00:00',
  IsRecommand char(1) NOT NULL default '',
  ExpoArea char(3) NOT NULL default '',
  ExpoName varchar(100) NOT NULL default '',
  BeginDate datetime NOT NULL default '0000-00-00 00:00:00',
  EndDate datetime NOT NULL default '0000-00-00 00:00:00',
  Area varchar(200) NOT NULL default '',
  Place varchar(200) NOT NULL default '',
  MainSupport varchar(200) NOT NULL default '',
  DoSupport varchar(200) NOT NULL default '',
  WithSupport varchar(200) NOT NULL default '',
  ExpoType varchar(100) NOT NULL default '',
  Scope text NOT NULL,
  Detail text NOT NULL,
  OtherExplain text NOT NULL,
  Contacter varchar(50) NOT NULL default '',
  Phone varchar(50) NOT NULL default '',
  Fax varchar(50) NOT NULL default '',
  Address varchar(100) NOT NULL default '',
  Postal varchar(8) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  WebSite varchar(100) NOT NULL default '',
  PRIMARY KEY  (ExpoID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_expo_contribute'

#

 

CREATE TABLE wj_expo_contribute (
  UserID int(10) unsigned NOT NULL default '0',
  ContributeID varchar(20) NOT NULL default '',
  ContributeDate datetime NOT NULL default '0000-00-00 00:00:00',
  ExpoArea char(3) NOT NULL default '',
  ExpoName varchar(50) NOT NULL default '',
  BeginDate datetime NOT NULL default '0000-00-00 00:00:00',
  EndDate datetime NOT NULL default '0000-00-00 00:00:00',
  Area varchar(100) NOT NULL default '',
  Place varchar(100) NOT NULL default '',
  MainSupport varchar(100) NOT NULL default '',
  DoSupport varchar(100) NOT NULL default '',
  WithSupport varchar(100) NOT NULL default '',
  ExpoType varchar(50) NOT NULL default '',
  Scope text NOT NULL,
  Detail text NOT NULL,
  OtherExplain text NOT NULL,
  Contacter varchar(50) NOT NULL default '',
  Phone varchar(50) NOT NULL default '',
  Fax varchar(50) NOT NULL default '',
  Address varchar(100) NOT NULL default '',
  Postal varchar(8) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  WebSite varchar(100) NOT NULL default '',
  PRIMARY KEY  (UserID,ContributeID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_favorite'

#

 

CREATE TABLE wj_favorite (
  FAVORITE_ID varchar(40) NOT NULL default '',
  COMM_NAME varchar(60) NOT NULL default '',
  Id int(10) unsigned NOT NULL default '0',
  COMM_ID varchar(50) default NULL,
  COMM_USER_ID int(10) unsigned default NULL,
  FAVORITE_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (FAVORITE_ID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_admin'

#

 

CREATE TABLE wj_forum_admin (
  AdminID int(10) unsigned NOT NULL auto_increment,
  UserID int(10) unsigned default NULL,
  ForumID int(10) unsigned default NULL,
  PRIMARY KEY  (AdminID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_answer'

#

 

CREATE TABLE wj_forum_answer (
  ReplyID varchar(20) NOT NULL default '',
  ReplyType int(10) unsigned NOT NULL default '0',
  ForumID int(10) unsigned NOT NULL default '0',
  TopicID varchar(20) NOT NULL default '',
  RRID varchar(20) default NULL,
  OwnerType char(2) default NULL,
  UserID int(10) unsigned NOT NULL default '0',
  IP varchar(64) NOT NULL default '',
  Topic varchar(50) NOT NULL default '',
  ReplyDate datetime NOT NULL default '0000-00-00 00:00:00',
  Face char(2) NOT NULL default '',
  ShowSign char(1) NOT NULL default '',
  ReplyInfoType int(10) unsigned NOT NULL default '0',
  Content text NOT NULL,
  PRIMARY KEY  (ReplyID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_apply'

#

 

CREATE TABLE wj_forum_apply (
  ApplyID int(10) unsigned NOT NULL auto_increment,
  ForumID int(10) unsigned NOT NULL default '0',
  UserID int(10) unsigned NOT NULL default '0',
  ApplyDate datetime NOT NULL default '0000-00-00 00:00:00',
  Handle char(1) default NULL,
  PRIMARY KEY  (ApplyID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_bulliten'

#

 

CREATE TABLE wj_forum_bulliten (
  BulletinID int(10) unsigned NOT NULL auto_increment,
  ForumID int(10) unsigned NOT NULL default '0',
  TopicID varchar(20) default NULL,
  BuilderDate datetime NOT NULL default '0000-00-00 00:00:00',
  ToAll char(1) NOT NULL default '',
  PRIMARY KEY  (BulletinID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_class'

#

 

CREATE TABLE wj_forum_class (
  ForumID int(10) unsigned NOT NULL auto_increment,
  FormName varchar(50) NOT NULL default '',
  FormOrder int(10) unsigned NOT NULL default '0',
  FormOpen char(1) NOT NULL default '',
  Detail varchar(200) default NULL,
  PRIMARY KEY  (ForumID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_person_info'

#

 

CREATE TABLE wj_forum_person_info (
  UserID int(10) unsigned NOT NULL default '0',
  NickName varchar(50) NOT NULL default '',
  Age int(10) unsigned NOT NULL default '0',
  Eduction varchar(20) NOT NULL default '',
  Job varchar(20) NOT NULL default '',
  Score float NOT NULL default '0',
  sheng varchar(10) NOT NULL default '',
  city varchar(10) NOT NULL default '',
  MSN varchar(50) NOT NULL default '',
  QQ varchar(20) NOT NULL default '',
  WebSite varchar(50) NOT NULL default '',
  SelfDefine char(1) NOT NULL default '',
  Header varchar(30) NOT NULL default '',
  Sign text,
  Introduce text NOT NULL,
  Photo varchar(30) NOT NULL default '',
  PRIMARY KEY  (UserID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_forum_topic'

#

 

CREATE TABLE wj_forum_topic (
  UserID int(10) unsigned NOT NULL default '0',
  TopicID varchar(20) NOT NULL default '',
  ForumID int(10) unsigned NOT NULL default '0',
  OwnerType int(10) unsigned NOT NULL default '0',
  Topic varchar(100) NOT NULL default '',
  IP varchar(64) NOT NULL default '',
  Face varchar(20) NOT NULL default '',
  ShowSign char(1) NOT NULL default '',
  BuilderDate datetime NOT NULL default '0000-00-00 00:00:00',
  Best char(1) NOT NULL default '',
  IsTop int(10) unsigned NOT NULL default '0',
  ReplyInfoType int(10) unsigned NOT NULL default '0',
  BrowserNumber int(10) unsigned NOT NULL default '0',
  Content text NOT NULL,
  LastReplyDate datetime NOT NULL default '0000-00-00 00:00:00',
  IsBuliten char(1) NOT NULL default '',
  PRIMARY KEY  (TopicID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_job'

#

 

CREATE TABLE wj_job (
  UserID int(10) unsigned NOT NULL default '0',
  JobID varchar(30) NOT NULL default '',
  JobDate datetime NOT NULL default '0000-00-00 00:00:00',
  JobStatus char(1) NOT NULL default '',
  JobName varchar(50) default NULL,
  Number varchar(8) NOT NULL default '',
  Sex varchar(4) default NULL,
  Age varchar(20) default NULL,
  Professional varchar(30) default NULL,
  Degree varchar(10) default NULL,
  Language varchar(10) default NULL,
  ComputerAbility varchar(20) default NULL,
  BirthSheng varchar(10) default NULL,
  BirthCity varchar(10) default NULL,
  WorkSheng varchar(10) default NULL,
  WorkCity varchar(10) default NULL,
  Sarlary varchar(20) default NULL,
  WorkCharacter varchar(10) default NULL,
  Days int(10) unsigned default NULL,
  Detail text,
  PRIMARY KEY  (UserID,JobID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_mail_config'

#

 

CREATE TABLE wj_mail_config (
  Account varchar(50) NOT NULL default '',
  MailPwd varchar(50) NOT NULL default '',
  Smtp varchar(50) NOT NULL default '',
  Sign varchar(50) NOT NULL default '',
  HomePage varchar(50) NOT NULL default ''
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_market_info'

#

 

CREATE TABLE wj_market_info (
  FirstID int(6) unsigned NOT NULL default '0',
  SecondID int(6) unsigned NOT NULL default '0',
  MarketID varchar(20) NOT NULL default '',
  use_Id int(10) unsigned default NULL,
  MarketViewNumber int(10) unsigned NOT NULL default '0',
  Score float NOT NULL default '0',
  MarketType char(1) NOT NULL default '',
  MarketStatus char(1) NOT NULL default '',
  MarketOnlyVip char(1) NOT NULL default '',
  MarketTopic varchar(100) NOT NULL default '',
  MarketKeyWords varchar(100) NOT NULL default '',
  MarketDate datetime NOT NULL default '0000-00-00 00:00:00',
  MarketResendDate datetime NOT NULL default '0000-00-00 00:00:00',
  MarketKeyDays int(10) unsigned NOT NULL default '0',
  MarketProductDetail text,
  MarketPicture varchar(30) default NULL,
  PRIMARY KEY  (MarketID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_mien'

#

 

CREATE TABLE wj_mien (
  MienID varchar(20) NOT NULL default '',
  UserID int(10) unsigned NOT NULL default '0',
  Topic varchar(50) NOT NULL default '',
  ViewNumber int(10) unsigned NOT NULL default '0',
  Builder datetime NOT NULL default '0000-00-00 00:00:00',
  Picture varchar(30) NOT NULL default '',
  Content text NOT NULL,
  PRIMARY KEY  (MienID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_news'

#

 

CREATE TABLE wj_news (
  NewsTypeID varchar(20) NOT NULL default '',
  NewsID varchar(20) NOT NULL default '',
  ContributeID varchar(20) default NULL,
  IsTitleNews char(1) default NULL,
  IsHomeRecommand char(1) NOT NULL default '',
  TitleNewsAddress varchar(200) default NULL,
  IsFromMember char(1) default NULL,
  IsHotNews char(1) NOT NULL default '',
  IsRecommandNews char(1) default NULL,
  HotNewsPicture varchar(30) default NULL,
  ViewNumber int(10) unsigned NOT NULL default '0',
  Source varchar(50) default NULL,
  Title varchar(200) default NULL,
  Author varchar(40) default NULL,
  Content text,
  BuilderDate datetime default NULL,
  Newsdate datetime default NULL,
  keywords varchar(100) default NULL,
  PRIMARY KEY  (NewsID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_news_contribute'

#

 

CREATE TABLE wj_news_contribute (
  ContributeID varchar(20) NOT NULL default '',
  NewsTypeID varchar(20) NOT NULL default '',
  UserID int(10) unsigned NOT NULL default '0',
  Title varchar(50) NOT NULL default '',
  ContributeDate datetime NOT NULL default '0000-00-00 00:00:00',
  Source varchar(50) NOT NULL default '',
  AttachOne varchar(30) default NULL,
  AttachTwo varchar(30) default NULL,
  AttachThree varchar(30) default NULL,
  isHotNews char(1) NOT NULL default '',
  Picture varchar(30) default NULL,
  content text NOT NULL,
  PRIMARY KEY  (ContributeID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_news_type'

#

 

CREATE TABLE wj_news_type (
  NewsTypeID varchar(20) NOT NULL default '',
  NewsTypeName varchar(50) NOT NULL default '',
  PRIMARY KEY  (NewsTypeID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_order_form'

#

 

CREATE TABLE wj_order_form (
  ORDER_NO varchar(50) NOT NULL default '',
  Id int(10) unsigned NOT NULL default '0',
  PAY_NAME varchar(50) default NULL,
  SEND_TYPE varchar(50) default NULL,
  ORDER_STATUS int(11) NOT NULL default '0',
  ORDER_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  ORDER_RECEIVER varchar(20) NOT NULL default '',
  ORDER_RECEIVER_SEX varchar(4) default NULL,
  ORDER_ADDRESS varchar(100) NOT NULL default '',
  ORDER_POSTAL varchar(6) NOT NULL default '',
  ORDER_PHONE varchar(20) NOT NULL default '',
  ORDER_EMAIL varchar(80) NOT NULL default '',
  ORDER_NEED_INVOICE char(1) NOT NULL default '',
  ORDER_LEAVE_WORD varchar(250) default NULL,
  PRIMARY KEY  (ORDER_NO)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_order_info'

#

 

CREATE TABLE wj_order_info (
  ORDER_NO varchar(50) NOT NULL default '',
  COMM_ID varchar(50) NOT NULL default '',
  Id int(10) unsigned NOT NULL default '0',
  ORDER_NUMBER int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (ORDER_NO,COMM_ID,Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_pay_type'

#

 

CREATE TABLE wj_pay_type (
  PAY_NAME varchar(50) NOT NULL default '',
  PRIMARY KEY  (PAY_NAME)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_resume'

#

 

CREATE TABLE wj_resume (
  UserID int(10) unsigned NOT NULL default '0',
  ResumeID varchar(20) NOT NULL default '',
  RegDate datetime default NULL,
  Open char(1) default NULL,
  RealName varchar(50) default NULL,
  Sex varchar(4) default NULL,
  Married char(1) default NULL,
  BirthDay datetime default NULL,
  Height float default NULL,
  Card varchar(20) default NULL,
  Job varchar(20) default NULL,
  HomeTown varchar(50) default NULL,
  WishWorkPlace varchar(50) default NULL,
  WishWork varchar(20) default NULL,
  WisthPay varchar(20) default NULL,
  NeedHouse char(1) default NULL,
  Eduction varchar(10) default NULL,
  School varchar(50) default NULL,
  Professional varchar(50) default NULL,
  Language varchar(20) default NULL,
  ComputerAbility varchar(20) default NULL,
  GoodAt varchar(50) default NULL,
  Detail text,
  Photo varchar(30) default NULL,
  PRIMARY KEY  (UserID,ResumeID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_send_resume'

#

 

CREATE TABLE wj_send_resume (
  ID varchar(20) NOT NULL default '',
  JobUserID int(10) unsigned NOT NULL default '0',
  JobID varchar(30) NOT NULL default '',
  UserID int(10) unsigned default NULL,
  SendDate datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (ID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_send_type'

#

 

CREATE TABLE wj_send_type (
  SEND_TYPE varchar(50) NOT NULL default '',
  PRIMARY KEY  (SEND_TYPE)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_shop'

#

 

CREATE TABLE wj_shop (
  SHOP_NAME varchar(50) NOT NULL default '',
  ShopStatus char(2) NOT NULL default '',
  Id int(10) unsigned NOT NULL default '0',
  Score int(10) unsigned NOT NULL default '0',
  SHOP_PIC varchar(40) default NULL,
  SHOP_CREATE_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  BankReceiver varchar(50) default NULL,
  Bank varchar(100) default NULL,
  BankAccount varchar(100) default NULL,
  PostReceiver varchar(50) default NULL,
  PostAddress varchar(100) default NULL,
  PostPostal varchar(10) default NULL,
  PRIMARY KEY  (SHOP_NAME,Id)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_shop_bulletin'

#

 

CREATE TABLE wj_shop_bulletin (
  BULLE_ID varchar(40) NOT NULL default '',
  SHOP_NAME varchar(50) default NULL,
  Id int(10) unsigned default NULL,
  BULLE_TITLE varchar(50) default NULL,
  BULLE_DATE datetime default NULL,
  BULLE_CONTENT text,
  pictrue varchar(30) default NULL,
  PRIMARY KEY  (BULLE_ID)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_trust_remark'

#

 

CREATE TABLE wj_trust_remark (
  RemarkNo varchar(20) NOT NULL default '',
  UserID int(10) unsigned NOT NULL default '0',
  OwerID int(10) unsigned default NULL,
  Rank char(2) NOT NULL default '',
  Topic varchar(50) NOT NULL default '',
  Content text NOT NULL,
  RemarkDate datetime NOT NULL default '0000-00-00 00:00:00',
  ViewNumber int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (RemarkNo)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_unit'

#

 

CREATE TABLE wj_unit (
  UNIT_NAME varchar(4) NOT NULL default '',
  UNIT_ORDER int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (UNIT_NAME)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_user_info'

#

 

CREATE TABLE wj_user_info (
  username varchar(50) NOT NULL default '',
  USER_LOGIN_TIME int(10) unsigned NOT NULL default '0',
  USER_NAME varchar(40) NOT NULL default '',
  USER_SEX varchar(4) NOT NULL default '',
  USER_VIP_BEGIN datetime default NULL,
  USER_VIP_DAYS int(10) unsigned default NULL,
  USER_JOB varchar(20) NOT NULL default '',
  USER_LAST_LOGIN datetime NOT NULL default '0000-00-00 00:00:00',
  USER_WANT_INFO char(1) NOT NULL default '',
  USER_COUNTRY varchar(20) NOT NULL default '',
  USER_SHENG varchar(20) default NULL,
  USER_CITY varchar(20) default NULL,
  USER_XIAN varchar(20) default NULL,
  USER_STREET_ADDRESS varchar(80) NOT NULL default '',
  USER_PHONE_COUNTRY_NO varchar(4) default NULL,
  USER_PHONE_CITY_NO varchar(4) default NULL,
  USER_PHONE_PHONE_NO varchar(8) NOT NULL default '',
  USER_FAX_COUNTRY_NO varchar(4) default NULL,
  USER_FAX_CITY_NO varchar(4) default NULL,
  USER_FAX_FAX_NO varchar(8) default NULL,
  USER_HANDSET varchar(50) default NULL,
  qq varchar(20) default NULL,
  msn varchar(40) default NULL,
  USER_POSTAL varchar(6) default NULL,
  USER_EMAIL varchar(40) NOT NULL default '',
  USER_WEBSITE varchar(50) default NULL,
  PRIMARY KEY  (username)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_user_pic_lib'

#

 

CREATE TABLE wj_user_pic_lib (
  Id int(10) unsigned default NULL,
  LIB_PIC_NAME varchar(40) NOT NULL default '',
  LIB_UPLOAD_DATE datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (LIB_PIC_NAME)
) TYPE=MyISAM;

 

 

 

#

# Table structure for table 'wj_vip_apply'

#

 

CREATE TABLE wj_vip_apply (
  UserID int(10) unsigned NOT NULL default '0',
  ApplyID varchar(20) NOT NULL default '',
  ApplyDate datetime NOT NULL default '0000-00-00 00:00:00',
  ApplyType char(1) NOT NULL default '',
  ApplyDays int(10) unsigned NOT NULL default '0',
  Applyed char(1) NOT NULL default '',
  PRIMARY KEY  (ApplyID)
) TYPE=MyISAM;