Revision 10741
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/.TNRS/schema.sql | ||
---|---|---|
24 | 24 |
time_submitted timestamp with time zone DEFAULT now(), |
25 | 25 |
client_version text, |
26 | 26 |
CONSTRAINT batch_pkey PRIMARY KEY (id ), |
27 |
CONSTRAINT batch_download_settings_id_by_time_key UNIQUE (id_by_time ), |
|
28 | 27 |
CONSTRAINT batch_client_version_fkey FOREIGN KEY (client_version) |
29 | 28 |
REFERENCES client_version (id) MATCH SIMPLE |
30 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
29 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
30 |
CONSTRAINT batch_id_by_time_key UNIQUE (id_by_time ) |
|
31 | 31 |
) |
32 | 32 |
WITH ( |
33 | 33 |
OIDS=FALSE |
Also available in: Unified diff
inputs/.TNRS/schema.sql: batch: reset name of id_by_time unique constraint since this field is now in the batch table