From 37783c65aba37464d5c90654b5d7fd9f35f493f4 Mon Sep 17 00:00:00 2001 From: John Beppu Date: Tue, 3 Feb 2009 16:02:11 -0600 Subject: [PATCH] [Checkout Slips Part 3 14/16] SQL - fixed syntax errors (thanks Dan) - made sample_notices.sql mandatory Signed-off-by: Daniel Sweeney Signed-off-by: Galen Charlton --- installer/data/mysql/en/optional/sample_notices.sql | 13 ------------- installer/data/mysql/en/optional/sample_notices.txt | 1 - .../optional/sample_notices_message_transports.sql | 6 ++++++ .../optional/sample_notices_message_transports.sql | 8 ++++++-- 4 files changed, 12 insertions(+), 16 deletions(-) delete mode 100644 installer/data/mysql/en/optional/sample_notices.sql delete mode 100644 installer/data/mysql/en/optional/sample_notices.txt diff --git a/installer/data/mysql/en/optional/sample_notices.sql b/installer/data/mysql/en/optional/sample_notices.sql deleted file mode 100644 index 74349f6dd3..0000000000 --- a/installer/data/mysql/en/optional/sample_notices.sql +++ /dev/null @@ -1,13 +0,0 @@ -INSERT INTO `letter` -(module, code, name, title, content) -VALUES -('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\r\n\r\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return orrenew them as soon as possible.\r\n\r\n<><><><><><><>If you have registered a password with the library, you may use it withyour library card number to renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned. The following item is currently overdue:\r\n\r\n<>'), -('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received','<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received.'), -('serial','RLIST','Routing List','Serial is now available','<> <>,\r\n\r\nThe following issue is now available:\r\n\r\n<>, <> (<>)\r\n\r\nPlease pick it up at your convenience.'), -('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <> <> <>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser: <>\r\nPassword: <>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin@yoursite.org'), -('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear <> <>,\r\n\r\nThe following item is now due:\r\n\r\n<>, <> (<>)'), -('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <> items due'), -('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item Due','Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>, <> (<>)'), -('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <> items due soon'), -('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear <> <>,\r\n\r\nThis is a reminder of an upcoming library event in which you have expressed interest.'), -('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <>', 'Dear <> <>,\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\nLocation: <>\r\n<>\r\n<>\r\n<>'); diff --git a/installer/data/mysql/en/optional/sample_notices.txt b/installer/data/mysql/en/optional/sample_notices.txt deleted file mode 100644 index 82e2ff84d6..0000000000 --- a/installer/data/mysql/en/optional/sample_notices.txt +++ /dev/null @@ -1 +0,0 @@ -Sample Notices diff --git a/installer/data/mysql/en/optional/sample_notices_message_transports.sql b/installer/data/mysql/en/optional/sample_notices_message_transports.sql index bc796dc22e..594da45563 100644 --- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql +++ b/installer/data/mysql/en/optional/sample_notices_message_transports.sql @@ -13,3 +13,9 @@ values (2, 'sms', 1, 'circulation', 'PREDUEDGST'), (3, 'sms', 0, 'circulation', 'EVENT'), (4, 'sms', 0, 'reserves', 'HOLD'); +(4, 'sms', 0, 'reserves', 'HOLD'), +(5, 'email', 0, 'circulation', 'CHECKIN'), +(5, 'sms', 0, 'circulation', 'CHECKIN'), +(6, 'email', 0, 'circulation', 'CHECKOUT'), +(6, 'sms', 0, 'circulation', 'CHECKOUT'); + diff --git a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql index e713319d26..9cbd3e1b69 100644 --- a/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql +++ b/installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql @@ -10,5 +10,9 @@ values (1, 'sms', 1, 'circulation', 'DUEDGST'), (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), -(3, 'sms', 0, 'circulation', 'EVENT'); - +(3, 'sms', 0, 'circulation', 'EVENT'), +(4, 'sms', 0, 'reserves', 'HOLD'), +(5, 'email', 0, 'circulation', 'CHECKIN'), +(5, 'sms', 0, 'circulation', 'CHECKIN'), +(6, 'email', 0, 'circulation', 'CHECKOUT'), +(6, 'sms', 0, 'circulation', 'CHECKOUT'); -- 2.39.5