Revision 217
Added by Aaron Marcuse-Kubitza about 13 years ago
| mappings/schemas/vegbien.sql | ||
|---|---|---|
| 13 | 13 |
-- Name: vegbien; Type: DATABASE; Schema: -; Owner: postgres |
| 14 | 14 |
-- |
| 15 | 15 |
|
| 16 |
CREATE DATABASE vegbien WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
|
|
| 16 |
CREATE DATABASE vegbien WITH TEMPLATE = template0 ENCODING = 'UTF8'; |
|
| 17 | 17 |
|
| 18 | 18 |
|
| 19 | 19 |
ALTER DATABASE vegbien OWNER TO postgres; |
| mappings/VegBank-VegBIEN.csv | ||
|---|---|---|
| 1 |
"VegBank","VegBIEN" |
|
| 2 |
"vegbank(?=; Type: DATABASE\b)","vegbien" |
|
| 3 |
"(?<=\bDATABASE )vegbank","vegbien" |
|
| 4 |
"(?<=\\connect )vegbank","vegbien" |
|
| 5 |
"vegbank","bien" |
|
| 6 |
"observation","plotevent" |
|
| 7 |
"taxonobservation","taxonoccurrence" |
|
| 8 |
"taxoninterpretation","taxondetermination" |
|
| 9 |
"stemlocation","individual" |
|
| 10 |
"taxonimportance","collectiveobs" |
|
| 11 |
"stratum","taxonbin" |
|
| 1 |
"VegBank","VegBIEN","Comments" |
|
| 2 |
,,"SQL script" |
|
| 3 |
" (?:LC_COLLATE|LC_CTYPE) = '.*?'",,"support PostgreSQL before 8.4" |
|
| 4 |
"vegbank(?=; Type: DATABASE\b)","vegbien", |
|
| 5 |
"(?<=\bDATABASE )vegbank","vegbien", |
|
| 6 |
"(?<=\\connect )vegbank","vegbien", |
|
| 7 |
"vegbank","bien", |
|
| 8 |
,,"table renames" |
|
| 9 |
"observation","plotevent", |
|
| 10 |
"taxonobservation","taxonoccurrence", |
|
| 11 |
"taxoninterpretation","taxondetermination", |
|
| 12 |
"stemlocation","individual", |
|
| 13 |
"taxonimportance","collectiveobs", |
|
| 14 |
"stratum","taxonbin", |
|
| mappings/for_review/VegBank-VegBIEN.csv | ||
|---|---|---|
| 1 |
VegBank,VegBIEN |
|
| 2 |
vegbank(?=; Type: DATABASE\b),vegbien |
|
| 3 |
(?<=\bDATABASE )vegbank,vegbien |
|
| 4 |
(?<=\\connect )vegbank,vegbien |
|
| 5 |
vegbank,bien |
|
| 6 |
observation,plotevent |
|
| 7 |
taxonobservation,taxonoccurrence |
|
| 8 |
taxoninterpretation,taxondetermination |
|
| 9 |
stemlocation,individual |
|
| 10 |
taxonimportance,collectiveobs |
|
| 11 |
stratum,taxonbin |
|
| 1 |
VegBank,VegBIEN,Comments |
|
| 2 |
,,SQL script |
|
| 3 |
(?:LC_COLLATE|LC_CTYPE) = '.*?',,support PostgreSQL before 8.4 |
|
| 4 |
vegbank(?=; Type: DATABASE\b),vegbien, |
|
| 5 |
(?<=\bDATABASE )vegbank,vegbien, |
|
| 6 |
(?<=\\connect )vegbank,vegbien, |
|
| 7 |
vegbank,bien, |
|
| 8 |
,,table renames |
|
| 9 |
observation,plotevent, |
|
| 10 |
taxonobservation,taxonoccurrence, |
|
| 11 |
taxoninterpretation,taxondetermination, |
|
| 12 |
stemlocation,individual, |
|
| 13 |
taxonimportance,collectiveobs, |
|
| 14 |
stratum,taxonbin, |
|
Also available in: Unified diff
VegBank-VegBIEN.csv: Support PostgreSQL before 8.4