Revision 13580
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 283 | 283 |
|
| 284 | 284 |
CREATE TABLE tnrs ( |
| 285 | 285 |
batch text DEFAULT now() NOT NULL, |
| 286 |
match_num integer, |
|
| 286 |
match_num integer NOT NULL,
|
|
| 287 | 287 |
"Name_number" integer NOT NULL, |
| 288 | 288 |
"Name_submitted" text NOT NULL, |
| 289 | 289 |
"Overall_score" double precision, |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 13289 | 13289 |
|
| 13290 | 13290 |
CREATE TABLE tnrs ( |
| 13291 | 13291 |
batch varchar(255) NOT NULL, |
| 13292 |
match_num int(11), |
|
| 13292 |
match_num int(11) NOT NULL,
|
|
| 13293 | 13293 |
`Name_number` int(11) NOT NULL, |
| 13294 | 13294 |
`Name_submitted` varchar(255) NOT NULL, |
| 13295 | 13295 |
`Overall_score` double, |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17120 | 17120 |
|
| 17121 | 17121 |
CREATE TABLE tnrs ( |
| 17122 | 17122 |
batch text DEFAULT now() NOT NULL, |
| 17123 |
match_num integer, |
|
| 17123 |
match_num integer NOT NULL,
|
|
| 17124 | 17124 |
"Name_number" integer NOT NULL, |
| 17125 | 17125 |
"Name_submitted" text NOT NULL, |
| 17126 | 17126 |
"Overall_score" double precision, |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs.match_num: made it NOT NULL now that it's populated