Revision 9905
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 11 | 11 |
*/ |
| 12 | 12 |
CREATE TABLE tnrs |
| 13 | 13 |
( |
| 14 |
"Time_submitted" timestamp with time zone DEFAULT now(), |
|
| 15 |
"Name_number" text, |
|
| 14 |
"Time_submitted" timestamp with time zone NOT NULL DEFAULT now(),
|
|
| 15 |
"Name_number" text NOT NULL,
|
|
| 16 | 16 |
"Name_submitted" text NOT NULL, |
| 17 | 17 |
"Overall_score" text, |
| 18 | 18 |
"Name_matched" text, |
Also available in: Unified diff
inputs/.TNRS/schema.sql: Time_submitted, Name_number: added NOT NULL constraints so that they can be used in a unique constraint