Changeset 1640 for trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

Timestamp:

01/18/16 23:32:48 (8 years ago)

Author:

nanardon

Message:

Add basic functions for anonymous password reset

File:

• trunk/LATMOS-Accounts/bin/la-sql-upgrade.in (modified) (1 diff)

trunk/LATMOS-Accounts/bin/la-sql-upgrade.in

@@ -883 +883 @@
 
         ],
-    }
+    },
+    {
+        ver => 17,
+        sql => [
+            q{
+            CREATE TABLE passwordreset
+            (
+            -- Hérité(e) from table revisions:  rev integer NOT NULL DEFAULT nextval('revisions_rev_seq'::regclass),
+            -- Hérité(e) from table revisions:  date timestamp with time zone NOT NULL DEFAULT now(),
+            -- Hérité(e) from table revisions:  "create" timestamp with time zone NOT NULL DEFAULT now(),
+            -- Hérité(e) from table revisions:  ikey integer NOT NULL DEFAULT nextval('ikey_seq'::regclass),
+            "user" text NOT NULL,
+            id text NOT NULL,
+            CONSTRAINT passwordreset_pkey PRIMARY KEY (id),
+            CONSTRAINT password_reset_user_fkey FOREIGN KEY ("user")
+            REFERENCES "user" (name) MATCH SIMPLE
+            ON UPDATE CASCADE ON DELETE CASCADE
+            )
+            INHERITS (revisions)
+            WITH (
+            OIDS=FALSE
+            );
+            },
+        ],
+    },
 );