X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fndawn.sql;h=5567337c58914e035be38b2d174c2ef4a6cc7702;hb=d8c6f0648fbd22c5c71163d3e712ae16c969e376;hp=40722c273a4661093ab401d87bf6a81519e9f909;hpb=76887e53c27118fe04ae8fe75dce610a398b5853;p=ndwebbie.git

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 40722c2..5567337 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;
 
@@ -1001,7 +1003,7 @@ CREATE TABLE users (
     uid integer NOT NULL,
     username citext NOT NULL,
     pid integer,
-    password text NOT NULL,
+    password text,
     attack_points numeric(3,0) DEFAULT 0 NOT NULL,
     defense_points numeric(4,1) DEFAULT 0 NOT NULL,
     scan_points numeric(5,0) DEFAULT 0 NOT NULL,