   ) ;
 
   
-DROP TABLE ID EXISTS PERSON_DIM;
+DROP TABLE IF EXISTS PERSON_DIM;
 CREATE TABLE PERSON_DIM
   (
     PERSON_ID     SERIAL NOT NULL PRIMARY KEY ,
     BIRTHDATE     DATE 
   ) ;
 
+DROP SEQUENCE IF EXISTS PERSON_SEQUENCE;
 CREATE SEQUENCE PERSON_SEQUENCE;
 
 

CREATE INDEX MAILING_ADDR_ZIP_IDX on MAILING_ADDRESS_DIM(ZIP_CODE);


DROP TABLE IF EXISTS VOTER_REPORT_FACT;
CREATE TABLE VOTER_REPORT_FACT
  (
    VOTER_REPORT_ID       	SERIAL NOT NULL PRIMARY KEY , 




DROP TABLE IF EXISTS STAFFER_DIM;
CREATE TABLE STAFFER_DIM
  (
    STAFFER_ID INTEGER NOT NULL PRIMARY KEY,
    FIRST_NAME VARCHAR(45) ,
    LAST_NAME  VARCHAR(45) ,
    USERNAME   VARCHAR(25)
  );
