)
WITH (fillfactor='50');
+ALTER TABLE planets ADD COLUMN id text UNIQUE NOT NULL;
+
ALTER TABLE planets OWNER TO ndawn;
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,
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
--