Revision 10342
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/util.sql | ||
|---|---|---|
| 1806 | 1806 |
|
| 1807 | 1807 |
|
| 1808 | 1808 |
-- |
| 1809 |
-- Name: map_pkey; Type: CONSTRAINT; Schema: util; Owner: -; Tablespace:
|
|
| 1809 |
-- Name: map__unique__from; Type: CONSTRAINT; Schema: util; Owner: -; Tablespace:
|
|
| 1810 | 1810 |
-- |
| 1811 | 1811 |
|
| 1812 | 1812 |
ALTER TABLE ONLY map |
| 1813 |
ADD CONSTRAINT map_pkey PRIMARY KEY ("from");
|
|
| 1813 |
ADD CONSTRAINT map__unique__from UNIQUE ("from");
|
|
| 1814 | 1814 |
|
| 1815 | 1815 |
|
| 1816 | 1816 |
-- |
Also available in: Unified diff
schemas/util.sql: map table: changed pkey to a unique constraint so pgAdmin would sort the entries in table order (matching the order they are in the staging table) instead of alphabetized by the pkey