--Creates a table for reference in MySQL Workbench 8.0

CREATE DATABASE `trafficactivity` /*!40100 DEFAULT CHARACTER SET utf8 */;
# Titles can be changed based on what you you would like to analyse
CREATE TABLE `maindata` (
  `ID` int(11) DEFAULT NULL,
  `TIME_S` float DEFAULT NULL,
  `VEHICLEID` varchar(50) DEFAULT NULL,
  `VEHTYPE` varchar(45) DEFAULT NULL,
  `XPOS` float DEFAULT NULL,
  `YPOS` float DEFAULT NULL,
  `SPEED` float DEFAULT NULL,
  `ANGLE` float DEFAULT NULL,
  `CO` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
