DROP DATABASE `apmap`;

CREATE DATABASE `apmap`;

USE `apmap`;

CREATE TABLE `apmap` (
	`mac_address`	varchar(20) NOT NULL,
	`SSID`		text NOT NULL,
	`channel`	smallint(4) NOT NULL,
	`signal`	smallint(4) NOT NULL,
	`WEP`		varchar(2) NOT NULL,
	`Latitude`	int(10) NOT NULL,
	`Lontitude`	int(10) NOT NULL,
	`date`		date NOT NULL,
	PRIMARY KEY (`mac_address`),
	KEY `Latitude`	(`Latitude`),
	KEY `Lontitude`	(`Lontitude`)
);

GRANT all ON apmap.* To 'apmap'@'localhost' IDENTIFIED BY 'apmap';