Bug 19036: Add ability to auto generate a number for account credits

[koha.git] / installer / data / mysql / kohastructure.sql

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 35c643f..2e3a42a 100644 (file)
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -2723,6 +2723,7 @@ CREATE TABLE `accountlines` (
   `description` LONGTEXT,
   `credit_type_code` varchar(80) default NULL,
   `debit_type_code` varchar(80) default NULL,
+  `credit_number` varchar(20) NULL DEFAULT NULL COMMENT 'autogenerated number for credits',
   `status` varchar(16) default NULL,
   `payment_type` varchar(80) default NULL, -- optional authorised value PAYMENT_TYPE
   `amountoutstanding` decimal(28,6) default NULL,