All pastes #564304 Raw Edit

rlazo

public sql v1 · immutable
·published 2007-06-13 15:06 UTC
rendered paste body
DROP TABLE IF EXISTS jobs_clients;CREATE TABLE jobs_clients (  jobid INT NOT NULL,  clientid INT,  groupid INT,  PRIMARY KEY (jobid, clientid, groupid),  FOREIGN KEY (jobid) REFERENCES jobs.jobid,  FOREIGN KEY (groupid) REFERENCES groups.gropuid, --Where is this groups table?... GLI_profile maybe? gacl?  FOREIGN KEY (clientid) REFERENCES clients.clientid) ENGINE = MyISAM;