text: # --- Created by Ebean DDL
  # To stop Ebean DDL generation, remove this comment and start using Evolutions
  
  # --- !Ups
  
  create table gz_cane (
    id                        bigint auto_increment not null,
    device_id                 varchar(255),
    imsi                      varchar(255),
    iccid                     varchar(255),
    sos_one                   varchar(255),
    sos_two                   varchar(255),
    gps_switch                integer,
    has_new_data              integer,
    created                   datetime(6),
    constraint pk_gz_cane primary key (id))
  ;
  
  create table gz_contact (
    id                        bigint auto_increment not null,
    device_id                 varchar(255),
    name                      varchar(255),
    cell_number               varchar(255),
    status                    tinyint(1) default 0,
    created                   datetime(6),
    constraint pk_gz_contact primary key (id))
  ;
  
  create table device_to_sim (
    id                        bigint auto_increment not null,
    device_id                 varchar(255),
    imsi                      varchar(255),
    iccid                     varchar(255),
    phone_num                 varchar(255),
    password                  varchar(255),
    flag                      integer,
    resetcode                 varchar(255),
    created                   datetime(6),
    constraint pk_device_to_sim primary key (id))
  ;
  
  create table gps_collection (
    id                        bigint auto_increment not null,
    device_id                 varchar(255),
    latitude                  varchar(255),
    longitude                 varchar(255),
    acc                       varchar(255),
    cell_id                   varchar(255),
    lac                       varchar(255),
    plmn                      varchar(255),
    orientation               integer,
    flag                      integer,
    created                   datetime(6),
    constraint pk_gps_collection primary key (id))
  ;
  
  create table sos_location (
    id                        bigint auto_increment not null,
    device_id                 varchar(255),
    latitude                  varchar(255),
    longitude                 varchar(255),
    acc                       varchar(255),
    cell_id                   varchar(255),
    lac                       varchar(255),
    plmn                      varchar(255),
    battery                   integer,
    imsi                      varchar(255),
    state                     varchar(255),
    time                      varchar(255),
    constraint pk_sos_location primary key (id))
  ;
  
  
  
  
  # --- !Downs
  
  SET FOREIGN_KEY_CHECKS=0;
  
  drop table gz_cane;
  
  drop table gz_contact;
  
  drop table device_to_sim;
  
  drop table gps_collection;
  
  drop table sos_location;
  
  SET FOREIGN_KEY_CHECKS=1;
  
  