Revision 6383
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.sql | ||
|---|---|---|
| 1891 | 1891 |
source_id integer NOT NULL, |
| 1892 | 1892 |
matched_source_id integer, |
| 1893 | 1893 |
parent_id integer, |
| 1894 |
shortname text, |
|
| 1894 |
shortname text NOT NULL,
|
|
| 1895 | 1895 |
citation text, |
| 1896 | 1896 |
sourcetype sourcetype, |
| 1897 | 1897 |
accesslevel accesslevel, |
| ... | ... | |
| 6030 | 6030 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6031 | 6031 |
-- |
| 6032 | 6032 |
|
| 6033 |
CREATE UNIQUE INDEX source_unique ON source USING btree ((COALESCE(shortname, '\N'::text)));
|
|
| 6033 |
CREATE UNIQUE INDEX source_unique ON source USING btree (shortname);
|
|
| 6034 | 6034 |
|
| 6035 | 6035 |
|
| 6036 | 6036 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: source: Made shortname NOT NULL to ensure that all datasources have a globally-unique short name