fyp/database_info.txt at master · abcumpanici/fyp · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
// the user credentials used by the NodeJS server to connect to the MySQL databases
CREATE USER 'fyp_user'@'localhost' IDENTIFIED BY 'fyp_password@my123!';
GRANT ALL PRIVILEGES ON * . * TO 'fyp_user'@'localhost';
FLUSH PRIVILEGES;
CREATE DATABASE fyp;

CREATE TABLE `car_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `car_reg` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `valid_permit` varchar(255) DEFAULT NULL,
  `gps_coord` varchar(255) DEFAULT NULL,
  `nct` varchar(255) DEFAULT NULL,
  `altitude` varchar(255) DEFAULT NULL,
  `car_make` varchar(255) DEFAULT NULL,
  `car_body` varchar(255) DEFAULT NULL,
  `car_colour` varchar(255) DEFAULT NULL,
  `car_year` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=457 DEFAULT CHARSET=latin1;


CREATE TABLE `drone_telemetry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `timestamp` varchar(255) DEFAULT NULL,
  `altitude` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=latin1;


CREATE TABLE `valid_permits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,s
  `car_reg` varchar(255) DEFAULT NULL,
  `paidDate` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;