Jpv0e015

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Tracking`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Tracking` (
21  `tracking_id` INT NULL,
22  `user_id` VARCHAR(45) NOT NULL,
23  `tracking_Sequence` INT NOT NULL,
24  `distance` DOUBLE NULL,
25  `X` DOUBLE NULL,
26  `Y` DOUBLE NULL,
27  `Z` DOUBLE NULL,
28  `height` DOUBLE NULL,
29  `speed` INT NULL,
30  `duration` DOUBLE NULL,
31  `sys_date` DATE NULL,
32  PRIMARY KEY (`tracking_id`, `user_id`, `tracking_Sequence`))
33ENGINE = InnoDB;
34
35
36SET SQL_MODE=@OLD_SQL_MODE;
37SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
38SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;