Add missing sequence for fields categories table; closes #1378

diff --git a/galette/install/scripts/pgsql.sql b/galette/install/scripts/pgsql.sql
index 55199cbe2e5c15306ad4586ba394d375aa9a320c..0f31e002d14bcb611cebbc05036af0cb862ba53c 100644 (file)
--- a/galette/install/scripts/pgsql.sql
+++ b/galette/install/scripts/pgsql.sql
@@ -120,14 +120,6 @@ CREATE SEQUENCE galette_import_model_id_seq
     MINVALUE 1
     CACHE 1;
 
--- Table for payment types
-DROP TABLE IF EXISTS galette_paymenttypes;
-CREATE TABLE galette_paymenttypes (
-  type_id integer DEFAULT nextval('galette_paymenttypes_id_seq'::text) NOT NULL,
-  type_name character varying(50) NOT NULL,
-  PRIMARY KEY (type_id)
-);
-
 -- sequence for payment types
 DROP SEQUENCE IF EXISTS galette_paymenttypes_id_seq;
 CREATE SEQUENCE galette_paymenttypes_id_seq
@@ -155,8 +147,24 @@ CREATE SEQUENCE galette_texts_id_seq
     MINVALUE 1
     CACHE 1;
 
+-- sequence for fields categories
+DROP SEQUENCE IF EXISTS galette_fields_categories_id_seq;
+CREATE SEQUENCE galette_fields_categories_id_seq
+    START 1
+    INCREMENT 1
+    MAXVALUE 2147483647
+    MINVALUE 1
+    CACHE 1;
+
 -- Schema
 -- REMINDER: Create order IS important, dependencies first !!
+DROP TABLE IF EXISTS galette_paymenttypes;
+CREATE TABLE galette_paymenttypes (
+  type_id integer DEFAULT nextval('galette_paymenttypes_id_seq'::text) NOT NULL,
+  type_name character varying(50) NOT NULL,
+  PRIMARY KEY (type_id)
+);
+
 DROP TABLE IF EXISTS galette_statuts CASCADE;
 CREATE TABLE galette_statuts (
   id_statut integer DEFAULT nextval('galette_statuts_id_seq'::text) NOT NULL,

diff --git a/galette/install/scripts/upgrade-to-0.931-pgsql.sql b/galette/install/scripts/upgrade-to-0.931-pgsql.sql
index 9671644bbcd8f617c959c28b5334c7f5d4d28416..2deefe80bff2bbc85a5cff667f81d9032cfb94dc 100644 (file)
--- a/galette/install/scripts/upgrade-to-0.931-pgsql.sql
+++ b/galette/install/scripts/upgrade-to-0.931-pgsql.sql
@@ -7,4 +7,13 @@ CREATE SEQUENCE galette_texts_id_seq
     MINVALUE 1
     CACHE 1;
 
+-- sequence for fields categories
+DROP SEQUENCE IF EXISTS galette_fields_categories_id_seq;
+CREATE SEQUENCE galette_fields_categories_id_seq
+    START 1
+    INCREMENT 1
+    MAXVALUE 2147483647
+    MINVALUE 1
+    CACHE 1;
+
 UPDATE galette_database SET version = 0.931;