Revision 2338
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 140 | 140 |
|
| 141 | 141 |
CREATE TABLE `_toGrowthform` ( |
| 142 | 142 |
result text, |
| 143 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 143 | 144 |
value text |
| 144 | 145 |
); |
| 145 | 146 |
|
| ... | ... | |
| 150 | 151 |
|
| 151 | 152 |
CREATE TABLE `_toPlacerank` ( |
| 152 | 153 |
result text, |
| 154 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 153 | 155 |
value text |
| 154 | 156 |
); |
| 155 | 157 |
|
| ... | ... | |
| 160 | 162 |
|
| 161 | 163 |
CREATE TABLE `_toTaxonrank` ( |
| 162 | 164 |
result text, |
| 165 |
not_null int(1) DEFAULT true NOT NULL, |
|
| 163 | 166 |
value text |
| 164 | 167 |
); |
| 165 | 168 |
|
| schemas/functions.sql | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
CREATE TABLE "_toBool" ( |
| 72 | 72 |
result boolean, |
| 73 |
not_null boolean DEFAULT true NOT NULL, |
|
| 73 | 74 |
value text |
| 74 | 75 |
); |
| 75 | 76 |
|
| ... | ... | |
| 80 | 81 |
|
| 81 | 82 |
CREATE TABLE "_toDouble" ( |
| 82 | 83 |
result double precision, |
| 84 |
not_null boolean DEFAULT true NOT NULL, |
|
| 83 | 85 |
value text |
| 84 | 86 |
); |
| 85 | 87 |
|
| ... | ... | |
| 90 | 92 |
|
| 91 | 93 |
CREATE TABLE "_toTimestamp" ( |
| 92 | 94 |
result timestamp with time zone, |
| 95 |
not_null boolean DEFAULT true NOT NULL, |
|
| 93 | 96 |
value text |
| 94 | 97 |
); |
| 95 | 98 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 356 | 356 |
|
| 357 | 357 |
CREATE TABLE "_toGrowthform" ( |
| 358 | 358 |
result growthform, |
| 359 |
not_null boolean DEFAULT true NOT NULL, |
|
| 359 | 360 |
value text |
| 360 | 361 |
); |
| 361 | 362 |
|
| ... | ... | |
| 366 | 367 |
|
| 367 | 368 |
CREATE TABLE "_toPlacerank" ( |
| 368 | 369 |
result placerank, |
| 370 |
not_null boolean DEFAULT true NOT NULL, |
|
| 369 | 371 |
value text |
| 370 | 372 |
); |
| 371 | 373 |
|
| ... | ... | |
| 376 | 378 |
|
| 377 | 379 |
CREATE TABLE "_toTaxonrank" ( |
| 378 | 380 |
result taxonrank, |
| 381 |
not_null boolean DEFAULT true NOT NULL, |
|
| 379 | 382 |
value text |
| 380 | 383 |
); |
| 381 | 384 |
|
Also available in: Unified diff
schemas/vegbien.sql, schemas/functions.sql: Relational functions: Added dummy not_null column to provide a column to use in LEFT JOIN filter-out filters