表结构如下:
CREATE TABLE terminalGps(
termiGpsId INT AUTO_INCREMENT PRIMARY KEY,
termiGpsLng VARCHAR(20),
termiGpsLat VARCHAR(20),
termiGpsDate VARCHAR(20),
termiId INT,
termiRemark VARCHAR(100)
)ENGINE=INNODB;
插入的数据:
insert into `terminalGps` (`termiGpsId`, `termiGpsLng`, `termiGpsLat`, `termiGpsDate`, `termiId`, `termiRemark`) values('1','106.540983','29.560692','2013-04-22 12:20:30','4',NULL);
insert into `terminalGps` (`termiGpsId`, `termiGpsLng`, `termiGpsLat`, `termiGpsDate`, `termiId`, `termiRemark`) values('2','106.556956','29.556587','2013-04-22 12:20:30','3',NULL);
insert into `terminalGps` (`termiGpsId`, `termiGpsLng`, `termiGpsLat`, `termiGpsDate`, `termiId`, `termiRemark`) values('3','106.554477','29.563624','2013-04-22 13:20:30','3',NULL);
insert into `terminalGps` (`termiGpsId`, `termiGpsLng`, `termiGpsLat`, `termiGpsDate`, `termiId`, `termiRemark`) values('4','106.548332','29.560231','2013-04-22 12:50:30','2',NULL);##终端表
DROP TABLE IF EXISTS terminal;
CREATE TABLE terminal(
termiId int auto_increment primary key,
termiMachineId varchar(20),#终端唯一标识
termiName varchar(20),#名称
termiOs varchar(20),#操作系统
termiMacAdress varchar(20),#终端的mac地址
termiPort varchar(20),#端口
termiIp varchar(20),#ip
termiRemark varchar(100)
)ENGINE=InnoDB;
insert into `terminal` (`termiId`, `termiMachineId`, `termiName`, `termiOs`, `termiMacAdress`, `termiRemark`, `termiPort`, `termiIp`) values('3','htc2457884','htcName','Anroid','tt','remark',NULL,NULL);
insert into `terminal` (`termiId`, `termiMachineId`, `termiName`, `termiOs`, `termiMacAdress`, `termiRemark`, `termiPort`, `termiIp`) values('4','nokia14754','nokiaName','Anroid','aa','remark',NULL,NULL);
insert into `terminal` (`termiId`, `termiMachineId`, `termiName`, `termiOs`, `termiMacAdress`, `termiRemark`, `termiPort`, `termiIp`) values('5','ipad31547','ipad3','IOS','541','remark',NULL,NULL);
insert into `terminal` (`termiId`, `termiMachineId`, `termiName`, `termiOs`, `termiMacAdress`, `termiRemark`, `termiPort`, `termiIp`) values('6','hase2541','hase','Android','dsf54','remark',NULL,NULL);
insert into `terminal` (`termiId`, `termiMachineId`, `termiName`, `termiOs`, `termiMacAdress`, `termiRemark`, `termiPort`, `termiIp`) values('7','htc324','htc','Android','dsf5421','remark',NULL,NULL);##终端与员工关系表
DROP TABLE IF EXISTS termAndEmpRelation;
CREATE TABLE termAndEmpRelation(
taerId VARCHAR(20) PRIMARY KEY,
termiId INT,#终端表Id
taerDoDate VARCHAR(20),#被分配日期
taerBeginDate VARCHAR(20),#开始使用日期
taerEndDate VARCHAR(20),#结束使用日期
emplId VARCHAR(20),#人员表id
termiRemark VARCHAR(60) #备注
)ENGINE=INNODB;
insert into `termAndEmpRelation` (`taerId`, `termiId`, `taerDoDate`, `taerBeginDate`, `taerEndDate`, `emplId`, `termiRemark`) values('t41475543','3','2013-1-4','2013-1-4 12:10:20','2013-1-4 18:10:20','345345435346','sdf');
insert into `termAndEmpRelation` (`taerId`, `termiId`, `taerDoDate`, `taerBeginDate`, `taerEndDate`, `emplId`, `termiRemark`) values('t41475544','3','2013-1-4','2013-1-4 12:10:20','2013-1-4 18:10:20','345345435345','sdf');