GRANT ALL ON *.* TO 'root'@'10.0.0.2';

CREATE LOGFILE GROUP lg_1
    ADD UNDOFILE 'undo_1.log'
    INITIAL_SIZE 2G
    UNDO_BUFFER_SIZE 2M
    ENGINE NDBCLUSTER;

CREATE TABLESPACE ts_1
    ADD DATAFILE 'data_1.dat'
    USE LOGFILE GROUP lg_1
    INITIAL_SIZE 2G
    ENGINE NDBCLUSTER;

ALTER LOGFILE GROUP lg_1
    ADD UNDOFILE 'undo_2.log'
    INITIAL_SIZE 2G
    ENGINE NDBCLUSTER;

ALTER TABLESPACE ts_1
    ADD DATAFILE 'data_2.dat'
    INITIAL_SIZE 2G
    ENGINE NDBCLUSTER;


SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE `essids` (
  `essid_id` int(11) NOT NULL auto_increment,
  `essid` tinyblob NOT NULL,
  `uid` varchar(32) NOT NULL,
  PRIMARY KEY  (`essid_id`),
  UNIQUE KEY `uid` (`uid`)
) DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
  TABLESPACE ts_1 STORAGE DISK
  ENGINE NDBCLUSTER;

CREATE TABLE `passwords` (
  `_key` varchar(32) NOT NULL,
  `h1` varchar(2) NOT NULL,
  `numElems` int(11) NOT NULL,
  `collection_buffer` mediumblob NOT NULL,
  PRIMARY KEY  (`_key`)
)  DEFAULT CHARSET=latin1 
   TABLESPACE ts_1 STORAGE DISK
   ENGINE NDBCLUSTER;

CREATE TABLE `results` (
  `_key` varchar(32) NOT NULL,
  `essid_id` int(11) NOT NULL,
  `numElems` int(11) NOT NULL,
  `results_buffer` mediumblob NOT NULL,
  PRIMARY KEY  (`_key`,`essid_id`),
  KEY `essid_id` (`essid_id`)
) DEFAULT CHARSET=latin1 
  TABLESPACE ts_1 STORAGE DISK
  ENGINE NDBCLUSTER;

ALTER TABLE `results`
  ADD CONSTRAINT `results_ibfk_1` FOREIGN KEY (`_key`) REFERENCES `passwords` (`_key`),
  ADD CONSTRAINT `results_ibfk_2` FOREIGN KEY (`essid_id`) REFERENCES `essids` (`essid_id`);

CREATE INDEX myrescueidx ON results (essid_id, _key);