marry5.sql

SMS gateway. SMS protocol for CHINA mobile, unicom, lingtong. Using mysql to exchange message.

--
-- Table structure for table 'MM_UserInfo'
--
drop table MM_UserInfo;
CREATE TABLE MM_UserInfo (
  CustomId int(8) NOT NULL auto_increment,
  UserPhone varchar(15) NOT NULL default '',
  State int(1) NOT NULL default '1', 
  OrderTime varchar(15) NOT NULL default '',
  CancelTime varchar(15),
  PassWord varchar(20) default '',
  UserName varchar(20) NOT NULL default '',
  UserSex int(1), 
  Age int(3),
  LiveCity varchar(20) NOT NULL default '',
  Diploma varchar(20) NOT NULL default '',
  Income varchar(20) NOT NULL default '',
  Introduction varchar(140) NOT NULL default '',
  HomeTown varchar(20) NOT NULL default '',
  XinZuo varchar(8) NOT NULL default '',
  xuexing varchar(2) NOT NULL default '',
  Intrest varchar(20) NOT NULL default '',
  PRIMARY KEY  (CustomId)
) TYPE=MyISAM;

--
-- Dumping data for table 'MM_UserInfo'
--

--
-- Table structure for table 'MM_UserDemand'
--
drop table MM_UserDemand;
CREATE TABLE MM_UserDemand (
  CustomId int(8) NOT NULL,
  UserPhone varchar(15) NOT NULL default '',
  UserSex int(1), 
  MaxAge int(3),
  MinAge int(3),
  LiveCity varchar(20) NOT NULL default '',
  Diploma varchar(20) NOT NULL default '',
  Income varchar(20) NOT NULL default '',
  HomeTown varchar(20) NOT NULL default '',
  XinZuo varchar(8) NOT NULL default '',
  xuexing varchar(2) NOT NULL default '',
  Intrest varchar(20) NOT NULL default '',
  NeedRematch int(1) NOT NULL default '0',
  MatchUser varchar(255) NOT NULL default '',
  Position int(2) NOT NULL default '0',
  MatchNum int(2) NOT NULL default '0',
  Last_Lover_ID int(8), 
  PRIMARY KEY  (CustomId)
) TYPE=MyISAM;

--
-- Dumping data for table 'MM_UserDemand'
--