Bug 2176 (1/5): database update: adding message_queue table and tables to hold patron...
authorAndrew Moore <andrew.moore@liblime.com>
Fri, 20 Jun 2008 15:58:31 +0000 (10:58 -0500)
committerJoshua Ferraro <jmf@liblime.com>
Fri, 20 Jun 2008 17:54:52 +0000 (12:54 -0500)
commitd8654344fa806d4a8ce7d675ae396b4016877ec2
tree6006b0479d18c7ee77b2499632cceecb006e1b69
parent3cb7a9ac281d33fcc643e09db00bc6efca8e6490
Bug 2176 (1/5): database update: adding message_queue table and tables to hold patron messaging preferences

Updates to kohastructure.sql and updatedatabase.pl:
- add new message_queue table
- add message_transport_types table
- add message_attributes table
- add message_transports table
- add borrower_message_preferences table
- add borrower_message_transport_preferences table
- adding EnhancedMessagingPreferenes to sysprefs SQL.

Added column to borrowers table to hold SMS Alert Number.
Added some more sample notices (letters) that will be sent for patron alerts
added some sample SQL to configure messaging.

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
installer/data/mysql/en/mandatory/message_transport_types.sql [new file with mode: 0644]
installer/data/mysql/en/mandatory/message_transport_types.txt [new file with mode: 0644]
installer/data/mysql/en/mandatory/sysprefs.sql
installer/data/mysql/en/optional/sample_notices.sql
installer/data/mysql/en/optional/sample_notices_message_attributes.sql [new file with mode: 0644]
installer/data/mysql/en/optional/sample_notices_message_attributes.txt [new file with mode: 0644]
installer/data/mysql/en/optional/sample_notices_message_transports.sql [new file with mode: 0644]
installer/data/mysql/en/optional/sample_notices_message_transports.txt [new file with mode: 0644]
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl
kohaversion.pl