)
WITH (fillfactor='50');
+ALTER TABLE planets ADD COLUMN id text UNIQUE NOT NULL;
+
ALTER TABLE planets OWNER TO ndawn;
id text DEFAULT md5(((now() + (random() * '100 years'::interval)))::text) NOT NULL,
uid integer NOT NULL,
email text NOT NULL,
- confirmed boolean DEFAULT false NOT NULL
+ confirmed boolean DEFAULT false NOT NULL,
+ time timestamptz DEFAULT now()
);
-
ALTER TABLE email_change OWNER TO ndawn;
--
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
--
CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
+CREATE TRIGGER update_user_planet_check BEFORE UPDATE ON users FOR EACH ROW WHEN (NEW.pid IS NOT NULL AND OLD.pid IS NULL) EXECUTE PROCEDURE update_user_planet_check();
+
--
-- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn