DrunkenDroid Server database definition

# Dump of table Call
# ------------------------------------------------------------

DROP TABLE IF EXISTS `PhoneCall`;

CREATE TABLE `PhoneCall` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `trip` int(11) NOT NULL,
  `timeStamp` bigint(20) NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  `caller` varchar(20) NOT NULL,
  `reciever` varchar(20) NOT NULL,
  `endTimeStamp` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25535 DEFAULT CHARSET=utf8


# Dump of table Location
# ------------------------------------------------------------

DROP TABLE IF EXISTS `Location`;

CREATE TABLE `Location` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trip` int NOT NULL,
  `timeStamp` bigint NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;


# Dump of table Mood
# ------------------------------------------------------------

DROP TABLE IF EXISTS `Mood`;

CREATE TABLE `Mood` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trip` int NOT NULL,
  `timeStamp` bigint NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  `mood` smallint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26344 DEFAULT CHARSET=utf8;


# Dump of table SMS
# ------------------------------------------------------------

DROP TABLE IF EXISTS `SMS`;

CREATE TABLE `SMS` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trip` int NOT NULL,
  `timeStamp` bigint NOT NULL,
  `longitude` double NOT NULL,
  `latitude` double NOT NULL,
  `sender` varchar(20) NOT NULL,
  `reciever` varchar(20) NOT NULL,
  `message` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=25535 DEFAULT CHARSET=utf8;



# Dump of table Trip
# ------------------------------------------------------------

DROP TABLE IF EXISTS `Trip`;

CREATE TABLE `Trip` (
  `name` varchar(255) NOT NULL DEFAULT '0',
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `startTimeStamp` bigint NOT NULL,
  `endTimeStamp` bigint NOT NULL,
  `IMEINumber` varchar(17) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=294 DEFAULT CHARSET=utf8;