Add scheduled payments feature

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

diff --git a/galette/install/scripts/sql/upgrade-to-1.10-mysql.sql b/galette/install/scripts/sql/upgrade-to-1.10-mysql.sql
index 3112cda18ecc11bf1e48b25d7e258eca74caee55..3a0b7abd0d703a83dd4707bca271b2b7b4bcc542 100644 (file)
--- a/galette/install/scripts/sql/upgrade-to-1.10-mysql.sql
+++ b/galette/install/scripts/sql/upgrade-to-1.10-mysql.sql
@@ -62,6 +62,26 @@ CREATE TABLE galette_documents (
 ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
 
 
+-- change fields types and default values
+ALTER TABLE galette_cotisations CHANGE montant_cotis montant_cotis decimal(15,2) NOT NULL;
+ALTER TABLE galette_transactions CHANGE trans_amount trans_amount decimal(15,2) NOT NULL;
+
+-- table for payments schedules
+DROP TABLE IF EXISTS galette_payments_schedules;
+CREATE TABLE galette_payments_schedules (
+  id_schedule int(10) unsigned NOT NULL auto_increment,
+  id_cotis int(10) unsigned NOT NULL,
+  id_paymenttype int(10) unsigned NOT NULL,
+  creation_date datetime NOT NULL,
+  scheduled_date datetime NOT NULL,
+  amount decimal(15,2) NOT NULL,
+  paid tinyint(1) DEFAULT FALSE,
+  comment text,
+  PRIMARY KEY (id_schedule),
+  FOREIGN KEY (id_cotis) REFERENCES galette_cotisations (id_cotis) ON DELETE CASCADE ON UPDATE CASCADE,
+  FOREIGN KEY (id_paymenttype) REFERENCES galette_paymenttypes (type_id) ON DELETE CASCADE ON UPDATE CASCADE
+);
+
 -- change fields types and default values
 ALTER TABLE galette_cotisations CHANGE montant_cotis montant_cotis decimal(15,2) NOT NULL;
 ALTER TABLE galette_transactions CHANGE trans_amount trans_amount decimal(15,2) NOT NULL;