CREATE UNIQUE INDEX ON gcrma_samples(tissue);
CREATE UNIQUE INDEX ON affy_probe(probe);
CREATE UNIQUE INDEX on affy_annotation(probe);
CREATE UNIQUE INDEX ON gcrma_expression(probe,sample);
ALTER TABLE gcrma_samples ADD PRIMARY KEY (id);
ALTER TABLE affy_probe ADD PRIMARY KEY (id);
ALTER TABLE gcrma_expression ADD PRIMARY KEY (id);
ALTER TABLE affy_annotation ADD PRIMARY KEY (id);
ALTER TABLE affy_annotation ADD FOREIGN KEY (id) REFERENCES affy_probe;
ALTER TABLE gcrma_expression ADD FOREIGN KEY (probe) REFERENCES affy_probe;
ALTER TABLE gcrma_expression ADD FOREIGN KEY (sample) REFERENCES gcrma_samples;
