MySql建表实例

DROP TABLE IF EXISTS `T_CHATDETAIL`;
create table T_CHATDETAIL
(
  CHATID      int unsigned not null AUTO_INCREMENT,
  TRAVELID    int,
  FROMUSERID  int,
  TOUSERID    int,
  CHATCONTENT VARCHAR(200),
  CHATTIME    DATE,
  PRIMARY KEY (`CHATID`)
) AUTO_INCREMENT=0  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELINFO`;
create table T_TRAVELINFO
(
  TRAVELID    int unsigned not null AUTO_INCREMENT,
  BUILDERID   int not null,
  LEADERID    int not null,
  TRAVELNAME  VARCHAR(20) not null,
  STARTPLACE  VARCHAR(50) not null,
  DESTINATION VARCHAR(50) not null,
  STARTTIME   DATE not null,
  ENDTIME     DATE not null,
  PUBLICFLAG  CHAR(1) not null,
  DELETEFLAG  CHAR(1) not null,
  REMARK      VARCHAR(200),
  STARTFLG    CHAR(1) default 0 not null,
  PRIMARY KEY (`TRAVELID`)
)AUTO_INCREMENT=0  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELLINE`;
create table T_TRAVELLINE
(
  TRAVELLINEID int unsigned not null AUTO_INCREMENT,
  TRAVELID     int not null,
  LEADERID     int,
  LONGITUDE    VARCHAR(30),
  LATITUDE     VARCHAR(30),
  INDEXID      int,
  PRIMARY KEY (`TRAVELLINEID`)
)AUTO_INCREMENT=0  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_TRAVELMEMBERS`;
create table T_TRAVELMEMBERS
(
  TRAVELID         int,
  USERID           int,
  LONGITUDE        VARCHAR(30),
  LATITUDE         VARCHAR(30),
  STATUSFLAG       CHAR(1),
  SHOWLOCATIONFLAG CHAR(1)
) DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_USERINFO`;
create table T_USERINFO
(
  USERID        int unsigned not null AUTO_INCREMENT,
  USERNICKNAME  VARCHAR(20),
  PHONENO       VARCHAR(20),
  LOGINNAME     VARCHAR(20) not null,
  LOGINPASSWORD VARCHAR(20) not null,
  CARNO         VARCHAR(15),
  USERPHOTO     VARCHAR(4000),
  PRIMARY KEY (`USERID`)
)AUTO_INCREMENT=0  DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `T_USERSET`;
create table T_USERSET
(
  USERID       int,
  AUTOLOGIN    VARCHAR(1) default 0,
  SAVEPASSWORD VARCHAR(1) default 0,
  BACKUP1      VARCHAR(1) default 0,
  BACKUP2      VARCHAR(1) default 0,
  BACKUP3      VARCHAR(1) default 0,
  BACKUP4      VARCHAR(1) default 0,
  BACKUP5      VARCHAR(1) default 0,
  BACKUP6      VARCHAR(1) default 0,
  BACKUP7      VARCHAR(1) default 0,
  BACKUP8      VARCHAR(1) default 0,
  BACKUP9      VARCHAR(1) default 0,
  BACKUP10     VARCHAR(1) default 0
)