Add scheduled payments feature

[galette.git] / galette / install / scripts / sql / upgrade-to-1.10-pgsql.sql

diff --git a/galette/install/scripts/sql/upgrade-to-1.10-pgsql.sql b/galette/install/scripts/sql/upgrade-to-1.10-pgsql.sql
index c4cbe2faaee62007a70eaa2d07262114b60a2d8a..df6bcd8b7165cdacd5017b777ea2dd2288f523b2 100644 (file)
--- a/galette/install/scripts/sql/upgrade-to-1.10-pgsql.sql
+++ b/galette/install/scripts/sql/upgrade-to-1.10-pgsql.sql
@@ -40,6 +40,36 @@ CREATE TABLE galette_documents (
 -- add index on table to look for type
 CREATE INDEX galette_documents_idx ON galette_documents (type);
 
+-- change fields types and default values
+ALTER TABLE galette_cotisations ALTER COLUMN montant_cotis TYPE decimal(15,2);
+ALTER TABLE galette_cotisations ALTER COLUMN montant_cotis DROP DEFAULT;
+ALTER TABLE galette_cotisations ALTER COLUMN montant_cotis SET NOT NULL;
+ALTER TABLE galette_transactions ALTER COLUMN trans_amount TYPE decimal(15,2);
+ALTER TABLE galette_transactions ALTER COLUMN trans_amount DROP DEFAULT;
+ALTER TABLE galette_transactions ALTER COLUMN trans_amount SET NOT NULL;
+
+-- sequence for payments schedules
+DROP SEQUENCE IF EXISTS galette_payments_schedules_id_seq;
+CREATE SEQUENCE galette_payments_schedules_id_seq
+    START 1
+    INCREMENT 1
+    MAXVALUE 2147483647
+    MINVALUE 1
+    CACHE 1;
+
+-- table for payments schedules
+DROP TABLE IF EXISTS galette_payments_schedules CASCADE;
+CREATE TABLE galette_payments_schedules (
+  id_schedule integer DEFAULT nextval('galette_payments_schedules_id_seq'::text) NOT NULL,
+  id_cotis integer REFERENCES galette_cotisations (id_cotis) ON DELETE CASCADE ON UPDATE CASCADE,
+  id_paymenttype integer REFERENCES galette_paymenttypes (type_id) ON DELETE RESTRICT ON UPDATE CASCADE,
+  creation_date date NOT NULL,
+  scheduled_date date NOT NULL,
+  amount decimal(15,2) NOT NULL,
+  paid boolean DEFAULT FALSE,
+  comment text,
+  PRIMARY KEY (id_schedule)
+);
 -- change fields types and default values
 ALTER TABLE galette_cotisations ALTER COLUMN montant_cotis TYPE decimal(15,2);
 ALTER TABLE galette_cotisations ALTER COLUMN montant_cotis DROP DEFAULT;