Travel_Distance_Log

PROJECT : log_travel_distance

CREATE TABLE IF NOT EXISTS travel_log (
sno int(11) NOT NULL AUTO_INCREMENT,
date date NOT NULL,
imei varchar(50) NOT NULL,
travel_duration varchar(1000) NOT NULL,
travel_distance_km text NOT NULL,
PRIMARY KEY (sno),
KEY date (date),
KEY imei (imei)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS distance_log (
sno int(11) NOT NULL AUTO_INCREMENT,
imei varchar(20) NOT NULL,
date date NOT NULL,
HR_01 float NOT NULL,
HR_02 float NOT NULL,
HR_03 float NOT NULL,
HR_04 float NOT NULL,
HR_05 float NOT NULL,
HR_06 float NOT NULL,
HR_07 float NOT NULL,
HR_08 float NOT NULL,
HR_09 float NOT NULL,
HR_10 float NOT NULL,
HR_11 float NOT NULL,
HR_12 float NOT NULL,
HR_13 float NOT NULL,
HR_14 float NOT NULL,
HR_15 float NOT NULL,
HR_16 float NOT NULL,
HR_17 float NOT NULL,
HR_18 float NOT NULL,
HR_19 float NOT NULL,
HR_20 float NOT NULL,
HR_21 float NOT NULL,
HR_22 float NOT NULL,
HR_23 float NOT NULL,
HR_24 float NOT NULL,
PRIMARY KEY (sno),
KEY imei (imei),
KEY date (date)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS flag_data_gap (
sno int(11) NOT NULL AUTO_INCREMENT,
imei varchar(50) NOT NULL,
date date NOT NULL,
PRIMARY KEY (sno),
KEY imei (imei)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;