create table for pois

points_of_interest-emma.sql

CREATE TABLE points_of_interest(
   id          BIGINT(20) UNSIGNED  NOT NULL PRIMARY KEY 
  ,type_id     BIGINT(20) UNSIGNED  NOT NULL
  ,name        VARCHAR(77) NOT NULL
  ,latitude    FLOAT NOT NULL
  ,longitude   FLOAT NOT NULL
  ,active      BIT  NOT NULL
  ,created_at  DATETIME  NOT NULL
  ,updated_at  DATETIME  NOT NULL
  ,description VARCHAR(85) NOT NULL
  ,tel         VARCHAR(50)
  ,fax         VARCHAR(38)
  ,mail        VARCHAR(81)
  ,website     VARCHAR(50)
);