Revision 5871
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2046 | 2046 |
placename_id int(11) NOT NULL, |
| 2047 | 2047 |
parent_id int(11), |
| 2048 | 2048 |
rank text NOT NULL, |
| 2049 |
placename text NOT NULL, |
|
| 2050 |
placecode text, |
|
| 2051 |
accessioncode text |
|
| 2049 |
placename text NOT NULL |
|
| 2052 | 2050 |
); |
| 2053 | 2051 |
|
| 2054 | 2052 |
|
| ... | ... | |
| 4129 | 4127 |
|
| 4130 | 4128 |
|
| 4131 | 4129 |
-- |
| 4132 |
-- Name: placename_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4133 |
-- |
|
| 4134 |
|
|
| 4135 |
CREATE UNIQUE INDEX placename_accessioncode_index ON placename (accessioncode); |
|
| 4136 |
|
|
| 4137 |
|
|
| 4138 |
-- |
|
| 4139 | 4130 |
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4140 | 4131 |
-- |
| 4141 | 4132 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2736 | 2736 |
placename_id integer NOT NULL, |
| 2737 | 2737 |
parent_id integer, |
| 2738 | 2738 |
rank placerank NOT NULL, |
| 2739 |
placename text NOT NULL, |
|
| 2740 |
placecode text, |
|
| 2741 |
accessioncode text |
|
| 2739 |
placename text NOT NULL |
|
| 2742 | 2740 |
); |
| 2743 | 2741 |
|
| 2744 | 2742 |
|
| ... | ... | |
| 4975 | 4973 |
|
| 4976 | 4974 |
|
| 4977 | 4975 |
-- |
| 4978 |
-- Name: placename_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4979 |
-- |
|
| 4980 |
|
|
| 4981 |
CREATE UNIQUE INDEX placename_accessioncode_index ON placename USING btree (accessioncode); |
|
| 4982 |
|
|
| 4983 |
|
|
| 4984 |
-- |
|
| 4985 | 4976 |
-- Name: placename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4986 | 4977 |
-- |
| 4987 | 4978 |
|
Also available in: Unified diff
schemas/vegbien.sql: placename: Removed non-name-related fields, because placename is designed only to store a hierarchy of placenames, not additional place information