   modifiedby userid,
   modified   TIMESTAMP,
 
-  CONSTRAINT PK_allowed_drugs PRIMARY KEY (id)
-);
-
-DROP TABLE wnprc_compliance.drug_regimens_to_drugs;
+  CONSTRAINT PK_drugs PRIMARY KEY (id)
+);
+
+DROP TABLE IF EXISTS wnprc_compliance.drug_regimens_to_drugs;
 CREATE TABLE wnprc_compliance.drug_regimens_to_drugs (
   drug_regimen TEXT,
   drug_id TEXT,

DROP TABLE IF EXISTS wnprc_compliance.protocol_revisions;
CREATE TABLE wnprc_compliance.protocol_revisions (
  id TEXT,

  principal_investigator_id TEXT NOT NULL,
  spi_primary_id            TEXT NOT NULL,

  modifiedby userid,
  modified   TIMESTAMP,

  CONSTRAINT PK_drug_regimens PRIMARY KEY (id)
);

DROP TABLE IF EXISTS wnprc_compliance.drug_regimens_to_allowed_procedures;
