Revision 6383
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1194 | 1194 |
source_id int(11) NOT NULL, |
| 1195 | 1195 |
matched_source_id int(11), |
| 1196 | 1196 |
parent_id int(11), |
| 1197 |
shortname text, |
|
| 1197 |
shortname text NOT NULL,
|
|
| 1198 | 1198 |
citation text, |
| 1199 | 1199 |
sourcetype text, |
| 1200 | 1200 |
accesslevel text, |
| ... | ... | |
| 5032 | 5032 |
-- Name: source_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5033 | 5033 |
-- |
| 5034 | 5034 |
|
| 5035 |
CREATE UNIQUE INDEX source_unique ON source (shortname); |
|
| 5035 | 5036 |
|
| 5036 | 5037 |
|
| 5037 |
|
|
| 5038 | 5038 |
-- |
| 5039 | 5039 |
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5040 | 5040 |
-- |
| schemas/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