Revision 13157
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 23 | 23 |
|
| 24 | 24 |
|
| 25 | 25 |
|
| 26 |
USE default_schema; |
|
| 26 | 27 |
|
| 27 |
|
|
| 28 | 28 |
-- |
| 29 | 29 |
-- Name: accesslevel; Type: TYPE; Schema: public; Owner: - |
| 30 | 30 |
-- |
| ... | ... | |
| 207 | 207 |
|
| 208 | 208 |
|
| 209 | 209 |
|
| 210 |
USE public_validations; |
|
| 210 | 211 |
|
| 211 |
|
|
| 212 | 212 |
-- |
| 213 | 213 |
-- Name: keys_~type._plots_01_count_of_projects; Type: TYPE; Schema: public_validations; Owner: - |
| 214 | 214 |
-- |
| ... | ... | |
| 1147 | 1147 |
|
| 1148 | 1148 |
|
| 1149 | 1149 |
|
| 1150 |
USE default_schema; |
|
| 1150 | 1151 |
|
| 1151 |
|
|
| 1152 | 1152 |
-- |
| 1153 | 1153 |
-- Name: _cm_to_m(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 1154 | 1154 |
-- |
| ... | ... | |
| 1803 | 1803 |
|
| 1804 | 1804 |
|
| 1805 | 1805 |
|
| 1806 |
USE public_validations; |
|
| 1806 | 1807 |
|
| 1807 |
|
|
| 1808 | 1808 |
-- |
| 1809 | 1809 |
-- Name: ~type._plots_01_count_of_projects; Type: TABLE; Schema: public_validations; Owner: -; Tablespace: |
| 1810 | 1810 |
-- |
| ... | ... | |
| 3112 | 3112 |
|
| 3113 | 3113 |
|
| 3114 | 3114 |
|
| 3115 |
USE default_schema; |
|
| 3115 | 3116 |
|
| 3116 |
|
|
| 3117 | 3117 |
-- |
| 3118 | 3118 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 3119 | 3119 |
-- |
| ... | ... | |
| 5730 | 5730 |
|
| 5731 | 5731 |
|
| 5732 | 5732 |
|
| 5733 |
USE public_validations; |
|
| 5733 | 5734 |
|
| 5734 |
|
|
| 5735 | 5735 |
-- |
| 5736 | 5736 |
-- Name: _plots_01_count_of_projects; Type: VIEW; Schema: public_validations; Owner: - |
| 5737 | 5737 |
-- |
| ... | ... | |
| 6159 | 6159 |
|
| 6160 | 6160 |
|
| 6161 | 6161 |
|
| 6162 |
USE default_schema; |
|
| 6162 | 6163 |
|
| 6163 |
|
|
| 6164 | 6164 |
-- |
| 6165 | 6165 |
-- Name: address_id; Type: DEFAULT; Schema: public; Owner: - |
| 6166 | 6166 |
-- |
| ... | ... | |
| 8955 | 8955 |
|
| 8956 | 8956 |
|
| 8957 | 8957 |
|
| 8958 |
USE public_validations; |
|
| 8958 | 8959 |
|
| 8959 |
|
|
| 8960 | 8960 |
-- |
| 8961 | 8961 |
-- Data for Name: ~type._plots_01_count_of_projects; Type: TABLE DATA; Schema: public_validations; Owner: - |
| 8962 | 8962 |
-- |
| ... | ... | |
| 9239 | 9239 |
|
| 9240 | 9240 |
|
| 9241 | 9241 |
|
| 9242 |
USE default_schema; |
|
| 9242 | 9243 |
|
| 9243 |
|
|
| 9244 | 9244 |
-- |
| 9245 | 9245 |
-- Name: address_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 9246 | 9246 |
-- |
| ... | ... | |
| 13106 | 13106 |
CREATE SCHEMA geoscrub; |
| 13107 | 13107 |
|
| 13108 | 13108 |
|
| 13109 |
USE `TNRS`; |
|
| 13109 | 13110 |
|
| 13110 |
|
|
| 13111 | 13111 |
-- |
| 13112 | 13112 |
-- Name: batch__fill(); Type: FUNCTION; Schema: TNRS; Owner: - |
| 13113 | 13113 |
-- |
| ... | ... | |
| 13150 | 13150 |
|
| 13151 | 13151 |
|
| 13152 | 13152 |
|
| 13153 |
USE geoscrub; |
|
| 13153 | 13154 |
|
| 13154 |
|
|
| 13155 | 13155 |
-- |
| 13156 | 13156 |
-- Name: map_coord_validity(int(11)); Type: FUNCTION; Schema: geoscrub; Owner: - |
| 13157 | 13157 |
-- |
| ... | ... | |
| 13166 | 13166 |
|
| 13167 | 13167 |
|
| 13168 | 13168 |
|
| 13169 |
USE `TNRS`; |
|
| 13169 | 13170 |
|
| 13170 | 13171 |
|
| 13171 | 13172 |
|
| 13172 | 13173 |
|
| 13173 | 13174 |
|
| 13174 |
|
|
| 13175 | 13175 |
-- |
| 13176 | 13176 |
-- Name: tnrs; Type: TABLE; Schema: TNRS; Owner: -; Tablespace: |
| 13177 | 13177 |
-- |
| ... | ... | |
| 13356 | 13356 |
|
| 13357 | 13357 |
|
| 13358 | 13358 |
|
| 13359 |
USE geoscrub; |
|
| 13359 | 13360 |
|
| 13360 |
|
|
| 13361 | 13361 |
-- |
| 13362 | 13362 |
-- Name: county_centroids; Type: TABLE; Schema: geoscrub; Owner: -; Tablespace: |
| 13363 | 13363 |
-- |
| ... | ... | |
| 13398 | 13398 |
); |
| 13399 | 13399 |
|
| 13400 | 13400 |
|
| 13401 |
USE `TNRS`; |
|
| 13401 | 13402 |
|
| 13402 |
|
|
| 13403 | 13403 |
-- |
| 13404 | 13404 |
-- Name: batch_download_settings_pkey; Type: CONSTRAINT; Schema: TNRS; Owner: -; Tablespace: |
| 13405 | 13405 |
-- |
| ... | ... | |
| 13448 | 13448 |
ADD CONSTRAINT tnrs_pkey PRIMARY KEY (batch, `Name_number`); |
| 13449 | 13449 |
|
| 13450 | 13450 |
|
| 13451 |
USE geoscrub; |
|
| 13451 | 13452 |
|
| 13452 |
|
|
| 13453 | 13453 |
-- |
| 13454 | 13454 |
-- Name: county_centroids_pkey; Type: CONSTRAINT; Schema: geoscrub; Owner: -; Tablespace: |
| 13455 | 13455 |
-- |
| ... | ... | |
| 13466 | 13466 |
ADD CONSTRAINT geoscrub_output_pkey PRIMARY KEY (`*row_num`); |
| 13467 | 13467 |
|
| 13468 | 13468 |
|
| 13469 |
USE `TNRS`; |
|
| 13469 | 13470 |
|
| 13470 |
|
|
| 13471 | 13471 |
-- |
| 13472 | 13472 |
-- Name: batch_client_version_idx; Type: INDEX; Schema: TNRS; Owner: -; Tablespace: |
| 13473 | 13473 |
-- |
| ... | ... | |
| 13482 | 13482 |
|
| 13483 | 13483 |
|
| 13484 | 13484 |
|
| 13485 |
USE geoscrub; |
|
| 13485 | 13486 |
|
| 13486 |
|
|
| 13487 | 13487 |
-- |
| 13488 | 13488 |
-- Name: geoscrub_output__unique; Type: INDEX; Schema: geoscrub; Owner: -; Tablespace: |
| 13489 | 13489 |
-- |
| ... | ... | |
| 13491 | 13491 |
|
| 13492 | 13492 |
|
| 13493 | 13493 |
|
| 13494 |
USE `TNRS`; |
|
| 13494 | 13495 |
|
| 13495 |
|
|
| 13496 | 13496 |
-- |
| 13497 | 13497 |
-- Name: batch__fill; Type: TRIGGER; Schema: TNRS; Owner: - |
| 13498 | 13498 |
-- |
| trunk/lib/PostgreSQL-MySQL.csv | ||
|---|---|---|
| 1 | 1 |
PostgreSQL,MySQL,Comments |
| 2 |
,,syntax changes |
|
| 3 |
"(?s)^SET search_path = (.*?), pg_catalog;$",USE \1;, |
|
| 4 |
(?s)(?<=^USE )public(?=;$),default_schema, |
|
| 2 | 5 |
,,PostgreSQL-only features |
| 3 | 6 |
(?s)^SET\b.*?;$,, |
| 4 | 7 |
(?s)^(?:GRANT|REVOKE)\b.*?;$,, |
Also available in: Unified diff
fix: lib/PostgreSQL-MySQL.csv: preserve schema assignments by translating `SET search_path` to `USE`