 #University Map
 CREATE TABLE `system_map_marker` (
   `markerid` INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
-  `marker_name` VARCHAR (70) NOT NULL,
-  `marker_notes` VARCHAR (10000),
-  `marker_url` VARCHAR (300),
+  `marker_name` VARCHAR(70) NOT NULL,
+  `marker_notes` VARCHAR(10000),
+  `marker_url` VARCHAR(300),
   `marker_lat` FLOAT(10,6) NOT NULL,
   `marker_long` FLOAT(10,6) NOT NULL,
-  `marker_category` VARCHAR (70) NOT NULL,
-  `marker_status` VARCHAR (9) NOT NULL,
+  `marker_category` VARCHAR(70) NOT NULL,
+  `marker_status` VARCHAR(9) NOT NULL,
   `created_on` DATETIME NOT NULL,
   `updated_on` DATETIME
 ) ENGINE = InnoDB;

#Transport
CREATE TABLE `tube_line_status_now` (
  `statusid` INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
  `tube_lineid` INT NOT NULL UNIQUE,
  `tube_line` VARCHAR (70) NOT NULL,
  `tube_line_status` VARCHAR (70),
  `tube_line_info` VARCHAR(10000),


#Transport
CREATE TABLE `tube_station_status_now` (
  `statusid` INT(11) NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY,
  `tube_stationid` INT(11) NOT NULL UNIQUE,
  `tube_station` VARCHAR (70) NOT NULL,
  `tube_station_status` VARCHAR (70),
  `tube_station_info` VARCHAR(10000),
