#
# Use: cat create_nmapdb | mysql -u root -p
#

CREATE DATABASE IF NOT EXISTS `nmapdb`;

GRANT ALL PRIVILEGES ON nmapdb.* TO 'nmapdb'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

USE `nmapdb`;

GRANT CREATE,INSERT,SELECT,DELETE,UPDATE on nmapdb.* to nmapdb@localhost;

CREATE TABLE `tbl_results` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `date_ins` DATE NOT NULL DEFAULT '0000-00-00',
  `host` VARCHAR( 15 ) NOT NULL ,
  `port` VARCHAR( 5 ) NOT NULL
);

FLUSH PRIVILEGES;

exit