 , endTime         timestamp with time zone
 );
 
-CREATE INDEX nodes_id_start on Nodes (nodeId, startTime);
-CREATE INDEX nodes_end on Nodes (endTime);
-
-CREATE SEQUENCE MigrationEventLogId start 1;
+CREATE INDEX nodes_id_start ON Nodes (nodeId, startTime);
+CREATE INDEX nodes_end      ON Nodes (endTime);
 
 /*
  *************************************************************************************

, modificationid text
);

create sequence ChangeRequestId start 1;

CREATE TABLE ChangeRequest(
  id        integer PRIMARY KEY default(nextval('ChangeRequestId'))

-- Create the sequences
CREATE SEQUENCE ruleSerialId START 1;

-- that sequence is used for nodeJoinKey value
CREATE SEQUENCE ruleVersionId START 1;


-- Create the table for the reports information
CREATE TABLE expectedReports (
  pkId                       integer PRIMARY KEY DEFAULT nextval('ruleSerialId')
, nodeJoinKey                integer NOT NULL
, ruleId                     text NOT NULL CHECK (ruleId <> '')
, serial                     integer NOT NULL
, directiveId                text NOT NULL CHECK (directiveId <> '')
, component                  text NOT NULL CHECK (component <> '')
