Revision 6383
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: source: Made shortname NOT NULL to ensure that all datasources have a globally-unique short name