 --########################################################################
 
 create table distPoller (
-	dpName			varchar(12),
+	dpName			varchar(12) not null,
 				constraint pk_dpName primary key (dpName),
 	dpIP			varchar(16) not null,
 	dpComment		varchar(256),

create table notifications (
       textMsg      varchar(4000) not null,
       numericMsg   varchar(256),
       notifyID	    integer,
       			constraint pk_notifyID primary key (notifyID),
       pageTime     timestamp without time zone,
       respondTime  timestamp without time zone,


create table outages (

	outageID		integer not null,
				constraint pk_outageID primary key (outageID),
	svcLostEventID		integer,
				constraint fk_eventID1 foreign key (svcLostEventID) references events (eventID) ON DELETE CASCADE,
