Changeset 2094 for trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/upgrade.pm

Timestamp:

09/19/17 19:34:41 (7 years ago)

Author:

nanardon

Message:

Allow to set allowed_values insde database instead config, this work only for SQL base

File:

• trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/upgrade.pm (modified) (1 diff)

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/upgrade.pm

@@ -1137 +1137 @@
                 }
             ],
-        }
+        },
+        {
+            ver => 28,
+            sql => [
+                q{
+                CREATE TABLE attributes_values
+                (
+                -- 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),
+                otype text NOT NULL,
+                attributes text NOT NULL,
+                value text NOT NULL,
+                CONSTRAINT attributes_values_pkey PRIMARY KEY (ikey)
+                )
+                INHERITS (revisions)
+                );
+
+                CREATE UNIQUE INDEX attributes_values_idx
+                ON attributes_values
+                USING btree
+                (otype, attributes, value);
+                }
+            ]
+        };
     );