#
# Create database 'ACARS'
#
CREATE DATABASE ACARS;

#
# Add user acarsd to the usertable
#
GRANT ALL PRIVILEGES ON ACARS.* TO acarsd@% identified by "Kohf" with grant option;

#
# Reload privileges
#
FLUSH PRIVILEGES;

#
# Next step on ACARS database
#
USE ACARS;

#
# Create table needed by acarsdgui
#
CREATE TABLE ACARS (
  card tinyint(2) default 0,
  channel char(1) default '-',
  link enum('U','D') DEFAULT 'D' NOT NULL,
  time time DEFAULT '0' NOT NULL,
  date date DEFAULT '0' NOT NULL,
  reg varchar(7) DEFAULT '' NOT NULL,
  iata char(2) DEFAULT '' NOT NULL,
  mode char(1) DEFAULT '' NOT NULL,
  label char(2) DEFAULT '' NOT NULL,
  blockid char(1) DEFAULT '' NOT NULL,
  msgno varchar(4) DEFAULT '' NOT NULL,
  flight varchar(6) DEFAULT '' NOT NULL,
  routing varchar(32) DEFAULT '',
  message text,
  PRIMARY KEY (time,date,reg,link,blockid,flight)
);