From: Nahuel ANGELINETTI Date: Tue, 23 Mar 2010 15:40:54 +0000 (+0100) Subject: (bug #4334) create needed sample datas X-Git-Tag: v3.00.06~29 X-Git-Url: http://git.rot13.org/?p=koha.git;a=commitdiff_plain;h=a1eea8846b78542441f4d0b3cc19a808a752f9f3 (bug #4334) create needed sample datas This add samplenotices.sql that disappear, and add in fr-FR: * sample_notices_message_attributes.sql * sample_notices_message_transports.sql --- diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql new file mode 100644 index 0000000000..25be5d7f67 --- /dev/null +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -0,0 +1,52 @@ +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\nkohaad...@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<>'), +('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following +items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.'), +('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following +items have been checked out:\r\n----\r\n<>\r\n----\r\nThank you +for visiting <>.'); + diff --git a/installer/data/mysql/en/mandatory/sample_notices.txt b/installer/data/mysql/en/mandatory/sample_notices.txt new file mode 100644 index 0000000000..6f87af8317 --- /dev/null +++ b/installer/data/mysql/en/mandatory/sample_notices.txt @@ -0,0 +1 @@ +Sample Notices \ No newline at end of file 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 594da45563..5aa2996419 100644 --- a/installer/data/mysql/en/optional/sample_notices_message_transports.sql +++ b/installer/data/mysql/en/optional/sample_notices_message_transports.sql @@ -12,7 +12,7 @@ values (2, 'sms', 0, 'circulation', 'PREDUE'), (2, 'sms', 1, 'circulation', 'PREDUEDGST'), (3, 'sms', 0, 'circulation', 'EVENT'), -(4, 'sms', 0, 'reserves', 'HOLD'); +(4, 'sms', 0, 'reserves', 'HOLD'), (4, 'sms', 0, 'reserves', 'HOLD'), (5, 'email', 0, 'circulation', 'CHECKIN'), (5, 'sms', 0, 'circulation', 'CHECKIN'), diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql new file mode 100644 index 0000000000..25be5d7f67 --- /dev/null +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.sql @@ -0,0 +1,52 @@ +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\nkohaad...@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<>'), +('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following +items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.'), +('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following +items have been checked out:\r\n----\r\n<>\r\n----\r\nThank you +for visiting <>.'); + diff --git a/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt new file mode 100644 index 0000000000..6f87af8317 --- /dev/null +++ b/installer/data/mysql/fr-FR/1-Obligatoire/sample_notices.txt @@ -0,0 +1 @@ +Sample Notices \ No newline at end of file diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql new file mode 100644 index 0000000000..8f89ff7250 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.sql @@ -0,0 +1,8 @@ +insert into `message_attributes` +(`message_attribute_id`, message_name, `takes_days`) +values +(1, 'Item DUE', 0), +(2, 'Advance Notice', 1), +(3, 'Upcoming Events', 1), +(4, 'Hold Filled', 0); + diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt new file mode 100644 index 0000000000..770bcac2b5 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_attributes.txt @@ -0,0 +1,2 @@ +defines default messages for items due, advance notices, and upcoming library events. + diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql new file mode 100644 index 0000000000..5aa2996419 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.sql @@ -0,0 +1,21 @@ +insert into `message_transports` +(`message_attribute_id`, `message_transport_type`, `is_digest`, `letter_module`, `letter_code`) +values +(1, 'email', 0, 'circulation', 'DUE'), +(1, 'email', 1, 'circulation', 'DUEDGST'), +(2, 'email', 0, 'circulation', 'PREDUE'), +(2, 'email', 1, 'circulation', 'PREDUEDGST'), +(3, 'email', 0, 'circulation', 'EVENT'), +(4, 'email', 0, 'reserves', 'HOLD'), +(1, 'sms', 0, 'circulation', 'DUE'), +(1, 'sms', 1, 'circulation', 'DUEDGST'), +(2, 'sms', 0, 'circulation', 'PREDUE'), +(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/fr-FR/2-Optionel/sample_notices_message_transports.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt new file mode 100644 index 0000000000..18e3431361 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_notices_message_transports.txt @@ -0,0 +1,3 @@ +Defines default message transports for sending item due messages, +advance notice messages, and library event messages through email +and SMS.