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 )