Revision 1317
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1138 | 1138 |
|
| 1139 | 1139 |
CREATE TABLE namedplace ( |
| 1140 | 1140 |
namedplace_id int(11) NOT NULL, |
| 1141 |
placesystem text, |
|
| 1141 |
parent_id int(11), |
|
| 1142 |
rank text, |
|
| 1142 | 1143 |
placename text NOT NULL, |
| 1144 |
placecode text, |
|
| 1143 | 1145 |
placedescription text, |
| 1144 |
placecode text, |
|
| 1145 |
accessioncode text, |
|
| 1146 |
parent_id int(11), |
|
| 1147 |
rank text |
|
| 1146 |
accessioncode text |
|
| 1148 | 1147 |
); |
| 1149 | 1148 |
|
| 1150 | 1149 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1359 | 1359 |
|
| 1360 | 1360 |
CREATE TABLE namedplace ( |
| 1361 | 1361 |
namedplace_id integer NOT NULL, |
| 1362 |
placesystem text, |
|
| 1362 |
parent_id integer, |
|
| 1363 |
rank placerank, |
|
| 1363 | 1364 |
placename text NOT NULL, |
| 1365 |
placecode text, |
|
| 1364 | 1366 |
placedescription text, |
| 1365 |
placecode text, |
|
| 1366 |
accessioncode text, |
|
| 1367 |
parent_id integer, |
|
| 1368 |
rank placerank |
|
| 1367 |
accessioncode text |
|
| 1369 | 1368 |
); |
| 1370 | 1369 |
|
| 1371 | 1370 |
|
Also available in: Unified diff
vegbien.sql: namedplace: Removed no longer needed placesystem, which has been replaced by rank closed list