[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 :