[Koha-cvs] CVS: koha/updater updatedatabase,1.113,1.114

[Paul POULAIN]

Update of /cvsroot/koha/koha/updater
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9468/updater

Modified Files:
	updatedatabase 
Log Message:
Introducing new "Letters" system : Letters will be used everytime you want to sent something to someone (through mail or paper). For example, sending a mail for overdues use letter that you can put as parameters. Sending a mail to a borrower when a suggestion is validated uses a letter too.
the letter table contains 3 fields :
* code => the code of the letter
* name => the complete name of the letter
* content => the complete text. It's a TEXT field type, so has no limits.

My next goal now is to work on point 2-I "serial issue alert"
With this feature, in serials, a user can subscribe the "issue alert". For every issue arrived/missing, a mail is sent to all subscribers of this list. The mail warns the user that the issue is arrive or missing. Will be in head.
(see mail on koha-devel, 2005/04/07)

The "serial issue alert" will be the 1st to use this letter system that probably needs some tweaking ;-)

Once it will be stabilised default letters (in any languages) could be added during installer to help the library begin with this new feature.

Index: updatedatabase
===================================================================
RCS file: /cvsroot/koha/koha/updater/updatedatabase,v
retrieving revision 1.113
retrieving revision 1.114
diff -C2 -r1.113 -r1.114
*** updatedatabase	28 Jul 2005 08:38:41 -0000	1.113
--- updatedatabase	28 Jul 2005 15:10:13 -0000	1.114
***************
*** 73,76 ****
--- 73,82 ----
  				    PRIMARY KEY ( `timestamp` , `user` )
  			    )",
+ 	letter		=> "(
+ 					code varchar(20) NOT NULL,
+ 					name varchar(100) NOT NULL,
+ 					content TEXT,
+ 					PRIMARY KEY (code)
+ 				)",
  );
  
***************
*** 351,354 ****
--- 357,375 ----
  
  # $Log$
+ # Revision 1.114  2005/07/28 15:10:13  tipaul
+ # Introducing new "Letters" system : Letters will be used everytime you want to sent something to someone (through mail or paper). For example, sending a mail for overdues use letter that you can put as parameters. Sending a mail to a borrower when a suggestion is validated uses a letter too.
+ # the letter table contains 3 fields :
+ # * code => the code of the letter
+ # * name => the complete name of the letter
+ # * content => the complete text. It's a TEXT field type, so has no limits.
+ #
+ # My next goal now is to work on point 2-I "serial issue alert"
+ # With this feature, in serials, a user can subscribe the "issue alert". For every issue arrived/missing, a mail is sent to all subscribers of this list. The mail warns the user that the issue is arrive or missing. Will be in head.
+ # (see mail on koha-devel, 2005/04/07)
+ #
+ # The "serial issue alert" will be the 1st to use this letter system that probably needs some tweaking ;-)
+ #
+ # Once it will be stabilised default letters (in any languages) could be added during installer to help the library begin with this new feature.
+ #
  # Revision 1.113  2005/07/28 08:38:41  tipaul
  # For instance, the return date does not rely on the borrower expiration date. A systempref will be added in Koha, to modify return date calculation schema :
***************
*** 717,720 ****
--- 738,756 ----
  
  # $Log$
+ # Revision 1.114  2005/07/28 15:10:13  tipaul
+ # Introducing new "Letters" system : Letters will be used everytime you want to sent something to someone (through mail or paper). For example, sending a mail for overdues use letter that you can put as parameters. Sending a mail to a borrower when a suggestion is validated uses a letter too.
+ # the letter table contains 3 fields :
+ # * code => the code of the letter
+ # * name => the complete name of the letter
+ # * content => the complete text. It's a TEXT field type, so has no limits.
+ #
+ # My next goal now is to work on point 2-I "serial issue alert"
+ # With this feature, in serials, a user can subscribe the "issue alert". For every issue arrived/missing, a mail is sent to all subscribers of this list. The mail warns the user that the issue is arrive or missing. Will be in head.
+ # (see mail on koha-devel, 2005/04/07)
+ #
+ # The "serial issue alert" will be the 1st to use this letter system that probably needs some tweaking ;-)
+ #
+ # Once it will be stabilised default letters (in any languages) could be added during installer to help the library begin with this new feature.
+ #
  # Revision 1.113  2005/07/28 08:38:41  tipaul
  # For instance, the return date does not rely on the borrower expiration date. A systempref will be added in Koha, to modify return date calculation schema :