X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fndawn.sql;h=177a3f9139ea61b381ef72492e0bfc3082bbcdcb;hp=5234e0b3f75caec94663d61bf456d03d670fdb50;hb=5e6cbd6690cb6007e3cadd5b93e93b8b12a09f56;hpb=d786ab3e431fdb29854f4d80fe430c5438d649b6

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 5234e0b..177a3f9 100644
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -773,6 +773,8 @@ CREATE TABLE planets (
 )
 WITH (fillfactor='50');
 
+ALTER TABLE planets ADD COLUMN id text UNIQUE NOT NULL;
+
 
 ALTER TABLE planets OWNER TO ndawn;
 
@@ -3060,14 +3062,6 @@ ALTER TABLE ONLY planets
     ADD CONSTRAINT planets_pkey PRIMARY KEY (pid);
 
 
---
--- Name: planets_ruler_key; Type: CONSTRAINT; Schema: public; Owner: ndawn
---
-
-ALTER TABLE ONLY planets
-    ADD CONSTRAINT planets_ruler_key UNIQUE (ruler, planet);
-
-
 --
 -- Name: raid_access_pkey; Type: CONSTRAINT; Schema: public; Owner: ndawn
 --