From f505bf65e70d46cc2b0f99dc3f548827f1bfd8c5 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Fri, 5 Jul 2013 14:40:48 +0200 Subject: [PATCH] Bug 10520: Add i18n function to en/mandatory mysql files Main goal: Adds i18n calls around translatable columns. Additionally: Removes backtics. Adds column names in inserts (where missing). Uses consistent style (based on my interpretation of coding guidelines). Test plan: Make sure that you apply this patch on top of the 10509 patches! Run English mysql install. Verify that you include all mandatory files. Check if webinstaller does not report errors. Inspect table contents via interface or mysql. Search for a column not using i18n where you would expect translation. Note: If you prefer to run the mysql files from command line, please make sure now that you define a 'fake' i18n, doing nothing (see Installer.pm code). Signed-off-by: Marcel de Rooy Tested both ways myself. Noticed that I missed one message_transport_type (phone) and one language description (180 vs. 181). If needed, will handle these on a separate report. They do not directly relate to this patch. Signed-off-by: Kyle M Hall --- installer/data/mysql/en/mandatory/auth_values.sql | 8 +- .../data/mysql/en/mandatory/class_sources.sql | 26 +- .../mysql/en/mandatory/message_transport_types.sql | 14 +- .../data/mysql/en/mandatory/sample_notices.sql | 69 +- .../sample_notices_message_attributes.sql | 16 +- .../sample_notices_message_transports.sql | 34 +- installer/data/mysql/en/mandatory/stopwords.sql | 200 ++-- .../data/mysql/en/mandatory/subtag_registry.sql | 1385 ++++++++++++-------- installer/data/mysql/en/mandatory/userflags.sql | 42 +- .../data/mysql/en/mandatory/userpermissions.sql | 127 +- 10 files changed, 1107 insertions(+), 814 deletions(-) mode change 100755 => 100644 installer/data/mysql/en/mandatory/subtag_registry.sql diff --git a/installer/data/mysql/en/mandatory/auth_values.sql b/installer/data/mysql/en/mandatory/auth_values.sql index d7fb280..310bc4c 100644 --- a/installer/data/mysql/en/mandatory/auth_values.sql +++ b/installer/data/mysql/en/mandatory/auth_values.sql @@ -1,2 +1,6 @@ -INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No'); -INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes'); +INSERT +INTO authorised_values (category, authorised_value, lib, lib_opac) +VALUES ('YES_NO', '0', i18n('No'), i18n('No')); +INSERT +INTO authorised_values (category, authorised_value, lib, lib_opac) +VALUES ('YES_NO', '1', i18n('Yes'), i18n('Yes')); diff --git a/installer/data/mysql/en/mandatory/class_sources.sql b/installer/data/mysql/en/mandatory/class_sources.sql index 589ea7a..afdf3d5 100644 --- a/installer/data/mysql/en/mandatory/class_sources.sql +++ b/installer/data/mysql/en/mandatory/class_sources.sql @@ -20,17 +20,21 @@ -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. -- class sorting (filing) rules -INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES - ('dewey', 'Default filing rules for DDC', 'Dewey'), - ('lcc', 'Default filing rules for LCC', 'LCC'), - ('generic', 'Generic call number filing rules', 'Generic'); +INSERT +INTO class_sort_rules (class_sort_rule, description, sort_routine) +VALUES + ('dewey', i18n('Default filing rules for DDC'), 'Dewey'), + ('lcc', i18n('Default filing rules for LCC'), 'LCC'), + ('generic', i18n('Generic call number filing rules'), 'Generic'); -- classification schemes or sources -INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES - ('ddc', 'Dewey Decimal Classification', 1, 'dewey'), - ('lcc', 'Library of Congress Classification', 1, 'lcc'), - ('udc', 'Universal Decimal Classification', 0, 'generic'), - ('sudocs', 'SuDoc Classification (U.S. GPO)', 0, 'generic'), - ('anscr', 'ANSCR (Sound Recordings)', 0, 'generic'), - ('z', 'Other/Generic Classification Scheme', 0, 'generic'); +INSERT +INTO class_sources (cn_source, description, used, class_sort_rule) +VALUES + ('ddc', i18n('Dewey Decimal Classification'), 1, 'dewey'), + ('lcc', i18n('Library of Congress Classification'), 1, 'lcc'), + ('udc', i18n('Universal Decimal Classification'), 0, 'generic'), + ('sudocs', i18n('SuDoc Classification (U.S. GPO)'), 0, 'generic'), + ('anscr', i18n('ANSCR (Sound Recordings)'), 0, 'generic'), + ('z', i18n('Other/Generic Classification Scheme'), 0, 'generic'); diff --git a/installer/data/mysql/en/mandatory/message_transport_types.sql b/installer/data/mysql/en/mandatory/message_transport_types.sql index bbcb64c..94a8de5 100644 --- a/installer/data/mysql/en/mandatory/message_transport_types.sql +++ b/installer/data/mysql/en/mandatory/message_transport_types.sql @@ -1,7 +1,7 @@ -INSERT INTO message_transport_types -(message_transport_type) -values -('email'), -('print'), -('sms'), -('feed'); +INSERT +INTO message_transport_types (message_transport_type) +VALUES + ('email'), + ('print'), + ('sms'), + ('feed'); diff --git a/installer/data/mysql/en/mandatory/sample_notices.sql b/installer/data/mysql/en/mandatory/sample_notices.sql index 2d09971..d7075a8 100644 --- a/installer/data/mysql/en/mandatory/sample_notices.sql +++ b/installer/data/mysql/en/mandatory/sample_notices.sql @@ -1,24 +1,28 @@ -INSERT INTO `letter` (module, code, name, title, content) -VALUES ('circulation','ODUE','Overdue Notice','Item Overdue','Dear <> <>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\n\nIf you have registered a password with the library, and you have a renewal available, you may 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.\n\nThe following item(s) is/are currently overdue:\n\n"<>" by <>, <>, Barcode: <> Fine: <>\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\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','RENEWAL','Item Renewals','Item Renewals','The following items have been renewed:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'), -('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<>\r\n<> <>'), -('reserves', 'HOLD_PRINT', 'Hold Available for Pickup (print notice)', 'Hold Available for Pickup (print notice)', '<>\r\n<>\r\n<>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <> <>\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\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 <>.'), -('reserves', 'HOLDPLACED', 'Hold Placed on Item', 'Hold Placed on Item','A hold has been placed on the following item : <> (<>) by the user <> <> (<>).'), -('suggestions','ACCEPTED','Suggestion accepted', 'Purchase suggestion accepted','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your suggestion today. The item will be ordered as soon as possible. You will be notified by mail when the order is completed, and again when the item arrives at the library.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'), -('suggestions','AVAILABLE','Suggestion available', 'Suggested purchase available','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'), -('suggestions','ORDERED','Suggestion ordered', 'Suggested item ordered','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <>\n\nThank you,\n\n<>'), -('suggestions','REJECTED','Suggestion rejected', 'Purchase suggestion declined','Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>'); -INSERT INTO `letter` (module, code, name, title, content, is_html) -VALUES ('circulation','ISSUESLIP','Issue Slip','Issue Slip', '

<>

+INSERT +INTO letter (module, code, name, title, content) +VALUES + ('circulation', 'ODUE', i18n('Overdue Notice'), i18n('Item Overdue'), i18n('Dear <> <>,\n\nAccording to our current records, you have items that are overdue.Your library does not charge late fines, but please return or renew them at the branch below as soon as possible.\n\n<>\n<>\n<> <>\nPhone: <>\nFax: <>\nEmail: <>\n\nIf you have registered a password with the library, and you have a renewal available, you may 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.\n\nThe following item(s) is/are currently overdue:\n\n"<>" by <>, <>, Barcode: <> Fine: <>\n\nThank-you for your prompt attention to this matter.\n\n<> Staff\n')), + ('claimacquisition', 'ACQCLAIM', i18n('Acquisition Claim'), i18n('Item Not Received'), i18n('<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received.')), + ('serial', 'RLIST', i18n('Routing List'), i18n('Serial is now available'), i18n('<> <>,\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', i18n('Account Details Template - DEFAULT'), i18n('Your new Koha account details.'), i18n('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', i18n('Item Due Reminder'), i18n('Item Due Reminder'), i18n('Dear <> <>,\r\n\r\nThe following item is now due:\r\n\r\n<>, <> (<>)')), + ('circulation', 'DUEDGST', i18n('Item Due Reminder (Digest)'), i18n('Item Due Reminder'), i18n('You have <> items due')), + ('circulation', 'PREDUE', i18n('Advance Notice of Item Due'), i18n('Advance Notice of Item Due'), i18n('Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>, <> (<>)')), + ('circulation', 'PREDUEDGST', i18n('Advance Notice of Item Due (Digest)'), i18n('Advance Notice of Item Due'), i18n('You have <> items due soon')), + ('circulation', 'RENEWAL', i18n('Item Renewals'), i18n('Item Renewals'), i18n('The following items have been renewed:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.')), + ('reserves', 'HOLD', i18n('Hold Available for Pickup'), i18n('Hold Available for Pickup at <>'), i18n('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<>\r\n<> <>')), + ('reserves', 'HOLD_PRINT', i18n('Hold Available for Pickup (print notice)'), i18n('Hold Available for Pickup (print notice)'), i18n('<>\r\n<>\r\n<>\r\n\r\n\r\nChange Service Requested\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <>\r\n<>\r\n<> <>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<> <> <>\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\n')), + ('circulation', 'CHECKIN', i18n('Item Check-in (Digest)'), i18n('Check-ins'), i18n('The following items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.')), + ('circulation', 'CHECKOUT', i18n('Item Check-out (Digest)'), i18n('Checkouts'), i18n('The following items have been checked out:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.')), + ('reserves', 'HOLDPLACED', i18n('Hold Placed on Item'), i18n('Hold Placed on Item'), i18n('A hold has been placed on the following item : <> (<>) by the user <> <> (<>).')), + ('suggestions', 'ACCEPTED', i18n('Suggestion accepted'), i18n('Purchase suggestion accepted'), i18n('Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your suggestion today. The item will be ordered as soon as possible. You will be notified by mail when the order is completed, and again when the item arrives at the library.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>')), + ('suggestions', 'AVAILABLE', i18n('Suggestion available'), i18n('Suggested purchase available'), i18n('Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested is now part of the collection.\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>')), + ('suggestions', 'ORDERED', i18n('Suggestion ordered'), i18n('Suggested item ordered'), i18n('Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nWe are pleased to inform you that the item you requested has now been ordered. It should arrive soon, at which time it will be processed for addition into the collection.\n\nYou will be notified again when the book is available.\n\nIf you have any questions, please email us at <>\n\nThank you,\n\n<>')), + ('suggestions', 'REJECTED', i18n('Suggestion rejected'), i18n('Purchase suggestion declined'), i18n('Dear <> <>,\n\nYou have suggested that the library acquire <> by <>.\n\nThe library has reviewed your request today, and has decided not to accept the suggestion at this time.\n\nThe reason given is: <>\n\nIf you have any questions, please email us at <>.\n\nThank you,\n\n<>')); +INSERT +INTO letter (module, code, name, title, content, is_html) +VALUES + ('circulation', 'ISSUESLIP', i18n('Issue Slip'), i18n('Issue Slip'), i18n('

<>

Checked out to <> <> <> <>
(<>)
@@ -52,8 +56,8 @@ Date due: <>

Posted on <>


-', 1), -('circulation','ISSUEQSLIP','Issue Quick Slip','Issue Quick Slip', '

<>

+'), 1), + ('circulation', 'ISSUEQSLIP', i18n('Issue Quick Slip'), i18n('Issue Quick Slip'), i18n('

<>

Checked out to <> <> <> <>
(<>)
@@ -66,8 +70,8 @@ Checked out to <> <> < Barcode: <>
Date due: <>

-', 1), -('circulation','RESERVESLIP','Reserve Slip','Reserve Slip', '
Date: <>
+'), 1), + ('circulation', 'RESERVESLIP', i18n('Reserve Slip'), i18n('Reserve Slip'), i18n('
Date: <>

Transfer to/Hold in <>

@@ -94,8 +98,8 @@ Date due: <>

Notes:

<>

-', 1), -('circulation','TRANSFERSLIP','Transfer Slip','Transfer Slip', '
Date: <>
+'), 1), + ('circulation', 'TRANSFERSLIP', i18n('Transfer Slip'), i18n('Transfer Slip'), i18n('
Date: <>

Transfer to <>

@@ -105,15 +109,14 @@ Date due: <>
  • <>
  • <>
  • -
', 1); +'), 1); -INSERT INTO `letter` (`module`,`code`,`branchcode`,`name`,`is_html`,`title`,`content`) -VALUES ( -'members', 'OPAC_REG_VERIFY', '', 'Opac Self-Registration Verification Email', '1', 'Verify Your Account', 'Hello! +INSERT +INTO letter (module, code, branchcode, name, is_html, title, content) +VALUES ('members', 'OPAC_REG_VERIFY', '', i18n('Opac Self-Registration Verification Email'), '1', i18n('Verify Your Account'), i18n('Hello! Your library account has been created. Please verify your email address by clicking this link to complete the signup process: http://<>/cgi-bin/koha/opac-registration-verify.pl?token=<> -If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.' -); +If you did not initiate this request, you may safely ignore this one-time message. The request will expire shortly.')); diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql index a7a6032..04eb55c 100644 --- a/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql +++ b/installer/data/mysql/en/mandatory/sample_notices_message_attributes.sql @@ -1,9 +1,9 @@ -insert into `message_attributes` -(`message_attribute_id`, message_name, `takes_days`) -values -(1, 'Item_Due', 0), -(2, 'Advance_Notice', 1), -(4, 'Hold_Filled', 0), -(5, 'Item_Check_in', 0), -(6, 'Item_Checkout', 0); +INSERT +INTO message_attributes (message_attribute_id, message_name, takes_days) +VALUES + (1, 'Item_Due', 0), + (2, 'Advance_Notice', 1), + (4, 'Hold_Filled', 0), + (5, 'Item_Check_in', 0), + (6, 'Item_Checkout', 0); diff --git a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql b/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql index ae68378..a259011 100644 --- a/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql +++ b/installer/data/mysql/en/mandatory/sample_notices_message_transports.sql @@ -1,17 +1,17 @@ -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'), -(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'), -(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'); +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'), + (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'), + (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/en/mandatory/stopwords.sql b/installer/data/mysql/en/mandatory/stopwords.sql index 1bf4725..25f2176 100644 --- a/installer/data/mysql/en/mandatory/stopwords.sql +++ b/installer/data/mysql/en/mandatory/stopwords.sql @@ -1,99 +1,101 @@ -INSERT INTO stopwords VALUES -('a'), -('about'), -('also'), -('an'), -('and'), -('another'), -('any'), -('are'), -('as'), -('at'), -('back'), -('be'), -('because'), -('been'), -('being'), -('but'), -('by'), -('can'), -('could'), -('did'), -('do'), -('each'), -('end'), -('even'), -('for'), -('from'), -('get'), -('go'), -('had'), -('have'), -('he'), -('her'), -('here'), -('his'), -('how'), -('i'), -('if'), -('in'), -('into'), -('is'), -('it'), -('just'), -('may'), -('me'), -('might'), -('much'), -('must'), -('my'), -('no'), -('not'), -('of'), -('off'), -('on'), -('only'), -('or'), -('other'), -('our'), -('out'), -('should'), -('so'), -('some'), -('still'), -('such'), -('than'), -('that'), -('the'), -('their'), -('them'), -('then'), -('there'), -('these'), -('they'), -('this'), -('those'), -('to'), -('too'), -('try'), -('two'), -('under'), -('up'), -('us'), -('was'), -('we'), -('were'), -('what'), -('when'), -('where'), -('which'), -('while'), -('who'), -('why'), -('will'), -('with'), -('within'), -('without'), -('would'), -('you'), -('your'); +INSERT +INTO stopwords (word) +VALUES + (i18n('a')), + (i18n('about')), + (i18n('also')), + (i18n('an')), + (i18n('and')), + (i18n('another')), + (i18n('any')), + (i18n('are')), + (i18n('as')), + (i18n('at')), + (i18n('back')), + (i18n('be')), + (i18n('because')), + (i18n('been')), + (i18n('being')), + (i18n('but')), + (i18n('by')), + (i18n('can')), + (i18n('could')), + (i18n('did')), + (i18n('do')), + (i18n('each')), + (i18n('end')), + (i18n('even')), + (i18n('for')), + (i18n('from')), + (i18n('get')), + (i18n('go')), + (i18n('had')), + (i18n('have')), + (i18n('he')), + (i18n('her')), + (i18n('here')), + (i18n('his')), + (i18n('how')), + (i18n('i')), + (i18n('if')), + (i18n('in')), + (i18n('into')), + (i18n('is')), + (i18n('it')), + (i18n('just')), + (i18n('may')), + (i18n('me')), + (i18n('might')), + (i18n('much')), + (i18n('must')), + (i18n('my')), + (i18n('no')), + (i18n('not')), + (i18n('of')), + (i18n('off')), + (i18n('on')), + (i18n('only')), + (i18n('or')), + (i18n('other')), + (i18n('our')), + (i18n('out')), + (i18n('should')), + (i18n('so')), + (i18n('some')), + (i18n('still')), + (i18n('such')), + (i18n('than')), + (i18n('that')), + (i18n('the')), + (i18n('their')), + (i18n('them')), + (i18n('then')), + (i18n('there')), + (i18n('these')), + (i18n('they')), + (i18n('this')), + (i18n('those')), + (i18n('to')), + (i18n('too')), + (i18n('try')), + (i18n('two')), + (i18n('under')), + (i18n('up')), + (i18n('us')), + (i18n('was')), + (i18n('we')), + (i18n('were')), + (i18n('what')), + (i18n('when')), + (i18n('where')), + (i18n('which')), + (i18n('while')), + (i18n('who')), + (i18n('why')), + (i18n('will')), + (i18n('with')), + (i18n('within')), + (i18n('without')), + (i18n('would')), + (i18n('you')), + (i18n('your')); diff --git a/installer/data/mysql/en/mandatory/subtag_registry.sql b/installer/data/mysql/en/mandatory/subtag_registry.sql old mode 100755 new mode 100644 index 9663c5c..d8e10e6 --- a/installer/data/mysql/en/mandatory/subtag_registry.sql +++ b/installer/data/mysql/en/mandatory/subtag_registry.sql @@ -1,897 +1,1174 @@ -- http://www.w3.org/International/articles/language-tags/ -- BIDI Stuff, Arabic and Hebrew -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Arab', 'rtl'); -INSERT INTO language_script_bidi(rfc4646_subtag,bidi) -VALUES( 'Hebr', 'rtl'); +INSERT +INTO language_script_bidi (rfc4646_subtag, bidi) +VALUES ('Arab', 'rtl'); +INSERT +INTO language_script_bidi (rfc4646_subtag, bidi) +VALUES ('Hebr', 'rtl'); -- Default mappings between script and language subcodes -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'ar', 'Arab'); -INSERT INTO language_script_mapping(language_subtag,script_subtag) -VALUES( 'he', 'Hebr'); +INSERT +INTO language_script_mapping (language_subtag, script_subtag) +VALUES ('ar', 'Arab'); +INSERT +INTO language_script_mapping (language_subtag, script_subtag) +VALUES ('he', 'Hebr'); -- EXTENSIONS -- Interface (i) -- SELECT * FROM language_subtag_registry WHERE type='i'; -- OPAC -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'opac', 'i', 'OPAC','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('opac', 'i', 'OPAC', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'en', 'OPAC'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('opac', 'i', 'en', 'OPAC'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'opac', 'i', 'fr', 'OPAC'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('opac', 'i', 'fr', 'OPAC'); -- Staff Client -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('intranet', 'i', 'Staff Client', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'en', 'Staff Client'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('intranet', 'i', 'en', 'Staff Client'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'intranet', 'i', 'fr', '????'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('intranet', 'i', 'fr', '????'); -- Theme (t) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'prog', 't', 'Prog','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('prog', 't', 'Prog', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'en', 'Prog'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('prog', 't', 'en', 'Prog'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'prog', 't', 'fr', 'Prog'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('prog', 't', 'fr', 'Prog'); -- LANGUAGES -- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ar', 'language', 'Arabic','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ar', 'language', 'Arabic', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ar','ara'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ar', 'ara'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'ar', 'language', 'ar', 'العربية'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ar', 'language', 'ar', 'العربية'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'en', 'Arabic'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ar', 'language', 'en', 'Arabic'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'fr', 'Arabe'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ar', 'language', 'fr', 'Arabe'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ar', 'language', 'de', 'Arabisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ar', 'language', 'de', 'Arabisch'); -- Armenian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('hy', 'language', 'Armenian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hy','arm'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('hy', 'arm'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hy', 'language', 'hy', 'Հայերէն'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'en', 'Armenian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hy', 'language', 'en', 'Armenian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'fr', 'Armenian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hy', 'language', 'fr', 'Armenian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hy', 'language', 'de', 'Armenisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hy', 'language', 'de', 'Armenisch'); -- Bulgarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('bg', 'language', 'Bulgarian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'bg','bul'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('bg', 'bul'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'bg', 'language', 'bg', 'Български'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('bg', 'language', 'bg', 'Български'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'en', 'Bulgarian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('bg', 'language', 'en', 'Bulgarian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'fr', 'Bulgare'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('bg', 'language', 'fr', 'Bulgare'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'bg', 'language', 'de', 'Bulgarisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('bg', 'language', 'de', 'Bulgarisch'); -- Chinese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('zh', 'language', 'Chinese', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'zh','chi'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('zh', 'chi'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'zh', 'language', 'zh', '中文'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('zh', 'language', 'zh', '中文'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'en', 'Chinese'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('zh', 'language', 'en', 'Chinese'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'fr', 'Chinois'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('zh', 'language', 'fr', 'Chinois'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'zh', 'language', 'de', 'Chinesisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('zh', 'language', 'de', 'Chinesisch'); -- Czech -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'cs', 'language', 'Czech','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('cs', 'language', 'Czech', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'cs','cze'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('cs', 'cze'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'cs', 'language', 'cs', 'čeština'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('cs', 'language', 'cs', 'čeština'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'en', 'Czech'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('cs', 'language', 'en', 'Czech'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'fr', 'Tchèque'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('cs', 'language', 'fr', 'Tchèque'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'cs', 'language', 'de', 'Tschechisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('cs', 'language', 'de', 'Tschechisch'); -- Danish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'da', 'language', 'Danish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('da', 'language', 'Danish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'da','dan'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('da', 'dan'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'da', 'language', 'da', 'Dansk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('da', 'language', 'da', 'Dansk'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'en', 'Danish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('da', 'language', 'en', 'Danish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'fr', 'Danois'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('da', 'language', 'fr', 'Danois'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'da', 'language', 'de', 'Dänisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('da', 'language', 'de', 'Dänisch'); -- Dutch, Flemish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('nl', 'language', 'Dutch', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nl','dut'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('nl', 'dut'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'nl', 'language', 'nl', 'Nederlands'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nl', 'language', 'nl', 'Nederlands'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'en', 'Dutch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nl', 'language', 'en', 'Dutch'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'fr', 'Néerlandais'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nl', 'language', 'fr', 'Néerlandais'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nl', 'language', 'de', 'Niederländisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nl', 'language', 'de', 'Niederländisch'); -- English -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'en', 'language', 'English','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('en', 'language', 'English', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'en','eng'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('en', 'eng'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'en', 'English'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('en', 'language', 'en', 'English'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'fr', 'Anglais'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('en', 'language', 'fr', 'Anglais'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'en', 'language', 'de', 'Englisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('en', 'language', 'de', 'Englisch'); -- Finnish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('fi', 'language', 'Finnish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fi','fin'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('fi', 'fin'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'fi', 'suomi'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fi', 'language', 'fi', 'suomi'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'en', 'Finnish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fi', 'language', 'en', 'Finnish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fi', 'language', 'de', 'Finnisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fi', 'language', 'de', 'Finnisch'); -- French -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fr', 'language', 'French','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('fr', 'language', 'French', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fr','fre'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('fr', 'fre'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'en', 'French'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fr', 'language', 'en', 'French'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'fr', 'Français'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fr', 'language', 'fr', 'Français'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fr', 'language', 'de', 'Französisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fr', 'language', 'de', 'Französisch'); -- INSERT INTO language_descriptions(subtag, type, lang, description) -- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); -- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('lo', 'language', 'Lao', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'lo','lao'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('lo', 'lao'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('lo', 'language', 'lo', 'ພາສາລາວ'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'en', 'Lao'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('lo', 'language', 'en', 'Lao'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'fr', 'Laotien'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('lo', 'language', 'fr', 'Laotien'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'lo', 'language', 'de', 'Laotisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('lo', 'language', 'de', 'Laotisch'); -- German -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'de', 'language', 'German','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('de', 'language', 'German', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'de','ger'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('de', 'ger'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'de', 'Deutsch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('de', 'language', 'de', 'Deutsch'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'en', 'German'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('de', 'language', 'en', 'German'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'de', 'language', 'fr', 'Allemand'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('de', 'language', 'fr', 'Allemand'); -- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('el', 'language', 'Greek, Modern [1453- ]', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'el','gre'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('el', 'gre'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'el', 'ελληνικά'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('el', 'language', 'el', 'ελληνικά'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('el', 'language', 'en', 'Greek, Modern [1453- ]'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('el', 'language', 'fr', 'Grec Moderne (Après 1453)'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'el', 'language', 'de', 'Griechisch (Nach 1453)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('el', 'language', 'de', 'Griechisch (Nach 1453)'); -- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('he', 'language', 'Hebrew', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'he','heb'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('he', 'heb'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'he', 'עברית'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('he', 'language', 'he', 'עברית'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'en', 'Hebrew'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('he', 'language', 'en', 'Hebrew'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'fr', 'Hébreu'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('he', 'language', 'fr', 'Hébreu'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'he', 'language', 'de', 'Hebräisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('he', 'language', 'de', 'Hebräisch'); -- Hindi -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hi', 'language', 'Hindi','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('hi', 'language', 'Hindi', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hi','hin'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('hi', 'hin'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'hi', 'हिन्दी'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hi', 'language', 'hi', 'हिन्दी'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'en', 'Hindi'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hi', 'language', 'en', 'Hindi'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'fr', 'Hindi'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hi', 'language', 'fr', 'Hindi'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hi', 'language', 'de', 'Hindi'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hi', 'language', 'de', 'Hindi'); -- Hungarian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('hu', 'language', 'Hungarian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'hu','hun'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('hu', 'hun'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'hu', 'Magyar'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hu', 'language', 'hu', 'Magyar'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'en', 'Hungarian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hu', 'language', 'en', 'Hungarian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'fr', 'Hongrois'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hu', 'language', 'fr', 'Hongrois'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'hu', 'language', 'de', 'Ungarisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('hu', 'language', 'de', 'Ungarisch'); -- Indonesian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('id', 'language', 'Indonesian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'id','ind'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('id', 'ind'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('id', 'language', 'id', 'Bahasa Indonesia'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'en', 'Indonesian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('id', 'language', 'en', 'Indonesian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'fr', 'Indonésien'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('id', 'language', 'fr', 'Indonésien'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'id', 'language', 'de', 'Indonesisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('id', 'language', 'de', 'Indonesisch'); -- Italian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'it', 'language', 'Italian','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('it', 'language', 'Italian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'it','ita'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('it', 'ita'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'it', 'Italiano'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('it', 'language', 'it', 'Italiano'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'en', 'Italian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('it', 'language', 'en', 'Italian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'fr', 'Italien'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('it', 'language', 'fr', 'Italien'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'it', 'language', 'de', 'Italienisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('it', 'language', 'de', 'Italienisch'); -- Japanese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ja', 'language', 'Japanese', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ja','jpn'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ja', 'jpn'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'ja', '日本語'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ja', 'language', 'ja', '日本語'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'en', 'Japanese'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ja', 'language', 'en', 'Japanese'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'fr', 'Japonais'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ja', 'language', 'fr', 'Japonais'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ja', 'language', 'de', 'Japanisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ja', 'language', 'de', 'Japanisch'); -- Korean -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ko', 'language', 'Korean','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ko', 'language', 'Korean', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ko','kor'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ko', 'kor'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'ko', '한국어'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ko', 'language', 'ko', '한국어'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'en', 'Korean'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ko', 'language', 'en', 'Korean'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'fr', 'Coréen'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ko', 'language', 'fr', 'Coréen'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ko', 'language', 'de', 'Koreanisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ko', 'language', 'de', 'Koreanisch'); -- Latin -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'la', 'language', 'Latin','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('la', 'language', 'Latin', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'la','lat'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('la', 'lat'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'la', 'Latina'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('la', 'language', 'la', 'Latina'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'en', 'Latin'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('la', 'language', 'en', 'Latin'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'fr', 'Latin'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('la', 'language', 'fr', 'Latin'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'la', 'language', 'de', 'Latein'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('la', 'language', 'de', 'Latein'); -- Galician -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('gl', 'language', 'Galician', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'gl','glg'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('gl', 'glg'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'gl', 'Galego'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('gl', 'language', 'gl', 'Galego'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'en', 'Galician'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('gl', 'language', 'en', 'Galician'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'gl', 'language', 'fr', 'Galicien'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('gl', 'language', 'fr', 'Galicien'); -- Norwegian (bokmål) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nb', 'language', 'Norwegian bokmål','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('nb', 'language', 'Norwegian bokmål', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nor'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('nb', 'nor'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nb','nob'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('nb', 'nob'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'nb', 'Norsk bokmål'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nb', 'language', 'nb', 'Norsk bokmål'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'en', 'Norwegian bokmål'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nb', 'language', 'en', 'Norwegian bokmål'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'fr', 'Norvégien bokmål'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nb', 'language', 'fr', 'Norvégien bokmål'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nb', 'language', 'de', 'Norwegisch bokmål'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nb', 'language', 'de', 'Norwegisch bokmål'); -- Norwegian (nynorsk) -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'nn', 'language', 'Norwegian nynorsk','2011-02-14' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('nn', 'language', 'Norwegian nynorsk', '2011-02-14'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'nn','nno'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('nn', 'nno'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nb', 'Norsk nynorsk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nn', 'language', 'nb', 'Norsk nynorsk'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'nn', 'Norsk nynorsk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nn', 'language', 'nn', 'Norsk nynorsk'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'en', 'Norwegian nynorsk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nn', 'language', 'en', 'Norwegian nynorsk'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'fr', 'Norvégien nynorsk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nn', 'language', 'fr', 'Norvégien nynorsk'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'nn', 'language', 'de', 'Norwegisch nynorsk'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('nn', 'language', 'de', 'Norwegisch nynorsk'); -- Persian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'fa', 'language', 'Persian','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('fa', 'language', 'Persian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'fa','per'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('fa', 'per'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fa', 'فارسى'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fa', 'language', 'fa', 'فارسى'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'en', 'Persian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fa', 'language', 'en', 'Persian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'fr', 'Persan'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fa', 'language', 'fr', 'Persan'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'fa', 'language', 'de', 'Persisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('fa', 'language', 'de', 'Persisch'); -- Polish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('pl', 'language', 'Polish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pl','pol'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('pl', 'pol'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'pl', 'Polski'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pl', 'language', 'pl', 'Polski'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'en', 'Polish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pl', 'language', 'en', 'Polish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'fr', 'Polonais'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pl', 'language', 'fr', 'Polonais'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pl', 'language', 'de', 'Polnisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pl', 'language', 'de', 'Polnisch'); -- Portuguese -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('pt', 'language', 'Portuguese', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'pt','por'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('pt', 'por'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'pt', 'Português'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pt', 'language', 'pt', 'Português'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'en', 'Portuguese'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pt', 'language', 'en', 'Portuguese'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'fr', 'Portugais'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pt', 'language', 'fr', 'Portugais'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'pt', 'language', 'de', 'Portugiesisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('pt', 'language', 'de', 'Portugiesisch'); -- Romanian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ro', 'language', 'Romanian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ro','rum'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ro', 'rum'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'ro', 'Română'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ro', 'language', 'ro', 'Română'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'en', 'Romanian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ro', 'language', 'en', 'Romanian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'fr', 'Roumain'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ro', 'language', 'fr', 'Roumain'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ro', 'language', 'de', 'Rumänisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ro', 'language', 'de', 'Rumänisch'); -- Russian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ru', 'language', 'Russian','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ru', 'language', 'Russian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ru','rus'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ru', 'rus'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'ru', 'Русский'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ru', 'language', 'ru', 'Русский'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'en', 'Russian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ru', 'language', 'en', 'Russian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'fr', 'Russe'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ru', 'language', 'fr', 'Russe'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ru', 'language', 'de', 'Russisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ru', 'language', 'de', 'Russisch'); -- Serbian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('sr', 'language', 'Serbian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sr','srp'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('sr', 'srp'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'sr', 'српски'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sr', 'language', 'sr', 'српски'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'en', 'Serbian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sr', 'language', 'en', 'Serbian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'fr', 'Serbe'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sr', 'language', 'fr', 'Serbe'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sr', 'language', 'de', 'Serbisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sr', 'language', 'de', 'Serbisch'); -- Spanish, Castilian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('es', 'language', 'Spanish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'es','spa'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('es', 'spa'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'es', 'Español'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('es', 'language', 'es', 'Español'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'en', 'Spanish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('es', 'language', 'en', 'Spanish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'fr', 'Espagnol'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('es', 'language', 'fr', 'Espagnol'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'es', 'language', 'de', 'Spanisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('es', 'language', 'de', 'Spanisch'); -- Spanish, Catalan -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ca', 'language', 'Catalan','2013-01-12' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ca', 'language', 'Catalan', '2013-01-12'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ca','cat'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ca', 'cat'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'es', 'Catalán'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ca', 'language', 'es', 'Catalán'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'en', 'Catalan'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ca', 'language', 'en', 'Catalan'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'fr', 'Catalan'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ca', 'language', 'fr', 'Catalan'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'ca', 'Català'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ca', 'language', 'ca', 'Català'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ca', 'language', 'de', 'Katalanisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ca', 'language', 'de', 'Katalanisch'); -- Swedish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('sv', 'language', 'Swedish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'sv','swe'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('sv', 'swe'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'sv', 'Svenska'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sv', 'language', 'sv', 'Svenska'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'en', 'Swedish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sv', 'language', 'en', 'Swedish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'fr', 'Suédois'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sv', 'language', 'fr', 'Suédois'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'sv', 'language', 'de', 'Schwedisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('sv', 'language', 'de', 'Schwedisch'); -- Tetum -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('tet', 'language', 'Tetum', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tet','tet'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('tet', 'tet'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'tet', 'tetun'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tet', 'language', 'tet', 'tetun'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'en', 'Tetum'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tet', 'language', 'en', 'Tetum'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'fr', 'Tétoum'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tet', 'language', 'fr', 'Tétoum'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tet', 'language', 'de', 'Tetum'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tet', 'language', 'de', 'Tetum'); -- Thai -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'th', 'language', 'Thai','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('th', 'language', 'Thai', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'th','tha'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('th', 'tha'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'th', 'ภาษาไทย'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('th', 'language', 'th', 'ภาษาไทย'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'en', 'Thai'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('th', 'language', 'en', 'Thai'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'fr', 'Thaï'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('th', 'language', 'fr', 'Thaï'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'th', 'language', 'de', 'Thailändisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('th', 'language', 'de', 'Thailändisch'); -- Turkish -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('tr', 'language', 'Turkish', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'tr','tur'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('tr', 'tur'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'tr', 'Türkçe'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tr', 'language', 'tr', 'Türkçe'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'en', 'Turkish'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tr', 'language', 'en', 'Turkish'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'fr', 'Turc'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tr', 'language', 'fr', 'Turc'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'tr', 'language', 'de', 'Türkisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('tr', 'language', 'de', 'Türkisch'); -- Ukranian -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('uk', 'language', 'Ukranian', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'uk','ukr'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('uk', 'ukr'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'uk', 'Українська'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('uk', 'language', 'uk', 'Українська'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'en', 'Ukranian'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('uk', 'language', 'en', 'Ukranian'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'fr', 'Ukrainien'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('uk', 'language', 'fr', 'Ukrainien'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'uk', 'language', 'de', 'Ukrainisch'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('uk', 'language', 'de', 'Ukrainisch'); -- Urdu -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('ur', 'language', 'Urdu', '2005-10-16'); -INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) -VALUES( 'ur','urd'); +INSERT +INTO language_rfc4646_to_iso639 (rfc4646_subtag, iso639_2_code) +VALUES ('ur', 'urd'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'en', 'Urdu'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ur', 'language', 'en', 'Urdu'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'ur', 'اردو'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ur', 'language', 'ur', 'اردو'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'fr', 'Ourdou'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ur', 'language', 'fr', 'Ourdou'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'ur', 'language', 'de', 'Urdu'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('ur', 'language', 'de', 'Urdu'); -- SCRIPTS -- Arabic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Arab', 'script', 'Arabic', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Arab','script', 'Arab', 'العربية'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Arab', 'script', 'Arab', 'العربية'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','en', 'Arabic'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Arab', 'script', 'en', 'Arabic'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Arab', 'script','fr', 'Arabic'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Arab', 'script', 'fr', 'Arabic'); -- Cyrillic -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Cyrl', 'script', 'Cyrillic', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Cyrl', 'script', 'Cyrl', '????'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Cyrl', 'script', 'Cyrl', '????'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Cyrl', 'script', 'en', 'Cyrillic'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Cyrl', 'script', 'fr', 'Cyrillic'); -- Greek -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Grek', 'script', 'Greek', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Grek', 'script', 'Grek', '????'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Grek', 'script', 'Grek', '????'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'en', 'Greek'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Grek', 'script', 'en', 'Greek'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Grek', 'script', 'fr', 'Greek'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Grek', 'script', 'fr', 'Greek'); -- Han - Simplified -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Hans', 'script', 'Han (Simplified variant)', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hans', 'script', 'Hans', 'Han (Simplified variant)'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hans', 'script', 'en', 'Han (Simplified variant)'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hans', 'script', 'fr', 'Han (Simplified variant)'); -- Han - Traditional -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Hant', 'script', 'Han (Traditional variant)', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hant', 'script', 'Hant', 'Han (Traditional variant)'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hant', 'script', 'en', 'Han (Traditional variant)'); -- Hebrew -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Hebr', 'script', 'Hebrew', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hebr', 'script', 'Hebr', 'Hebrew'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Hebr', 'script', 'en', 'Hebrew'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Hebr', 'script', 'en', 'Hebrew'); -- Lao -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('Laoo', 'script', 'Lao', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'Laoo', 'script', 'lo', 'Lao'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Laoo', 'script', 'lo', 'Lao'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'Laoo', 'script', 'en', 'Lao'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('Laoo', 'script', 'en', 'Lao'); -- REGIONS -- Canada -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'CA', 'region', 'Canada','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('CA', 'region', 'Canada', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'CA', 'region', 'en', 'Canada'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('CA', 'region', 'en', 'Canada'); -- Denmark -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'DK', 'region', 'Denmark','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('DK', 'region', 'Denmark', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'DK', 'region', 'dk', 'Danmark'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('DK', 'region', 'dk', 'Danmark'); -- France -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'FR', 'region', 'France','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('FR', 'region', 'France', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'FR', 'region', 'fr', 'France'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('FR', 'region', 'fr', 'France'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'FR', 'region', 'en', 'France'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('FR', 'region', 'en', 'France'); -- New Zealand -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('NZ', 'region', 'New Zealand', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'NZ', 'region', 'en', 'New Zealand'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('NZ', 'region', 'en', 'New Zealand'); -- United Kingdom -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('GB', 'region', 'United Kingdom', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'GB', 'region', 'en', 'United Kingdom'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('GB', 'region', 'en', 'United Kingdom'); -- United States -INSERT INTO language_subtag_registry( subtag, type, description, added) -VALUES ( 'US', 'region', 'United States','2005-10-16'); +INSERT +INTO language_subtag_registry (subtag, type, description, added) +VALUES ('US', 'region', 'United States', '2005-10-16'); -INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES( 'US', 'region', 'en', 'United States'); +INSERT +INTO language_descriptions (subtag, type, lang, description) +VALUES ('US', 'region', 'en', 'United States'); diff --git a/installer/data/mysql/en/mandatory/userflags.sql b/installer/data/mysql/en/mandatory/userflags.sql index c00db34..0a547be 100644 --- a/installer/data/mysql/en/mandatory/userflags.sql +++ b/installer/data/mysql/en/mandatory/userflags.sql @@ -1,20 +1,22 @@ -INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES -(0,'superlibrarian','Access to all librarian functions',0), -(1,'circulate','Check out and check in items',0), -(2,'catalogue','Required for staff login. Staff access, allows viewing of catalogue in staff client.',0), -(3,'parameters','Manage Koha system settings (Administration panel)',0), -(4,'borrowers','Add or modify patrons',0), -(5,'permissions','Set user permissions',0), -(6,'reserveforothers','Place and modify holds for patrons',0), -(7,'borrow','Borrow books',1), -(9,'editcatalogue','Edit Catalog (Modify bibliographic/holdings data)',0), -(10,'updatecharges','Manage patrons fines and fees',0), -(11,'acquisition','Acquisition and/or suggestion management',0), -(12,'management','Set library management parameters (deprecated)',0), -(13,'tools','Use all tools (expand for granular tools permissions)',0), -(14,'editauthorities','Edit Authorities',0), -(15,'serials','Manage serial subscriptions',0), -(16,'reports','Allow access to the reports module',0), -(17,'staffaccess','Allow staff members to modify permissions for other staff members',0), -(18,'coursereserves','Course Reserves',0), -(19, 'plugins', 'Koha plugins', '0'); +INSERT +INTO userflags (bit, flag, flagdesc, defaulton) +VALUES + (0, 'superlibrarian', i18n('Access to all librarian functions'), 0), + (1, 'circulate', i18n('Check out and check in items'), 0), + (2, 'catalogue', i18n('Required for staff login. Staff access, allows viewing of catalogue in staff client.'), 0), + (3, 'parameters', i18n('Manage Koha system settings (Administration panel)'), 0), + (4, 'borrowers', i18n('Add or modify patrons'), 0), + (5, 'permissions', i18n('Set user permissions'), 0), + (6, 'reserveforothers', i18n('Place and modify holds for patrons'), 0), + (7, 'borrow', i18n('Borrow books'), 1), + (9, 'editcatalogue', i18n('Edit Catalog (Modify bibliographic/holdings data)'), 0), + (10, 'updatecharges', i18n('Manage patrons fines and fees'), 0), + (11, 'acquisition', i18n('Acquisition and/or suggestion management'), 0), + (12, 'management', i18n('Set library management parameters (deprecated)'), 0), + (13, 'tools', i18n('Use all tools (expand for granular tools permissions)'), 0), + (14, 'editauthorities', i18n('Edit Authorities'), 0), + (15, 'serials', i18n('Manage serial subscriptions'), 0), + (16, 'reports', i18n('Allow access to the reports module'), 0), + (17, 'staffaccess', i18n('Allow staff members to modify permissions for other staff members'), 0), + (18, 'coursereserves', i18n('Course Reserves'), 0), + (19, 'plugins', i18n('Koha plugins'), '0'); diff --git a/installer/data/mysql/en/mandatory/userpermissions.sql b/installer/data/mysql/en/mandatory/userpermissions.sql index 4fa2a7a..e7d1ad2 100644 --- a/installer/data/mysql/en/mandatory/userpermissions.sql +++ b/installer/data/mysql/en/mandatory/userpermissions.sql @@ -1,63 +1,64 @@ -INSERT INTO permissions (module_bit, code, description) VALUES - ( 1, 'circulate_remaining_permissions', 'Remaining circulation permissions'), - ( 1, 'override_renewals', 'Override blocked renewals'), - ( 1, 'overdues_report', 'Execute overdue items report'), - ( 3, 'parameters_remaining_permissions', 'Remaining system parameters permissions'), - ( 3, 'manage_circ_rules', 'manage circulation rules'), - ( 6, 'place_holds', 'Place holds for patrons'), - ( 6, 'modify_holds_priority', 'Modify holds priority'), - ( 9, 'edit_catalogue', 'Edit catalog (Modify bibliographic/holdings data)'), - ( 9, 'fast_cataloging', 'Fast cataloging'), - ( 9, 'edit_items', 'Edit Items'), - (11, 'vendors_manage', 'Manage vendors'), - (11, 'contracts_manage', 'Manage contracts'), - (11, 'period_manage', 'Manage periods'), - (11, 'budget_manage', 'Manage budgets'), - (11, 'budget_modify', 'Modify budget (can''t create lines, but can modify existing ones)'), - (11, 'planning_manage', 'Manage budget plannings'), - (11, 'order_manage', 'Manage orders & basket'), - (11, 'group_manage', 'Manage orders & basketgroups'), - (11, 'order_receive', 'Manage orders & basket'), - (11, 'budget_add_del', 'Add and delete budgets (but cant modify budgets)'), - (11, 'budget_manage_all', 'Manage all budgets'), - (13, 'edit_news', 'Write news for the OPAC and staff interfaces'), - (13, 'label_creator', 'Create printable labels and barcodes from catalog and patron data'), - (13, 'edit_calendar', 'Define days when the library is closed'), - (13, 'moderate_comments', 'Moderate patron comments'), - (13, 'edit_notices', 'Define notices'), - (13, 'edit_notice_status_triggers', 'Set notice/status triggers for overdue items'), - (13, 'edit_quotes', 'Edit quotes for quote-of-the-day feature'), - (13, 'view_system_logs', 'Browse the system logs'), - (13, 'inventory', 'Perform inventory (stocktaking) of your catalog'), - (13, 'stage_marc_import', 'Stage MARC records into the reservoir'), - (13, 'manage_staged_marc', 'Managed staged MARC records, including completing and reversing imports'), - (13, 'export_catalog', 'Export bibliographic and holdings data'), - (13, 'import_patrons', 'Import patron data'), - (13, 'edit_patrons', 'Perform batch modification of patrons'), - (13, 'delete_anonymize_patrons', 'Delete old borrowers and anonymize circulation history (deletes borrower reading history)'), - (13, 'batch_upload_patron_images', 'Upload patron images in batch or one at a time'), - (13, 'schedule_tasks', 'Schedule tasks to run'), - (13, 'items_batchmod', 'Perform batch modification of items'), - (13, 'items_batchdel', 'Perform batch deletion of items'), - (13, 'manage_csv_profiles', 'Manage CSV export profiles'), - (13, 'moderate_tags', 'Moderate patron tags'), - (13, 'rotating_collections', 'Manage rotating collections'), - (13, 'upload_local_cover_images', 'Upload local cover images'), - (15, 'check_expiration', 'Check the expiration of a serial'), - (15, 'claim_serials', 'Claim missing serials'), - (15, 'create_subscription', 'Create a new subscription'), - (15, 'delete_subscription', 'Delete an existing subscription'), - (15, 'edit_subscription', 'Edit an existing subscription'), - (15, 'receive_serials', 'Serials receiving'), - (15, 'renew_subscription', 'Renew a subscription'), - (15, 'routing', 'Routing'), - (16, 'execute_reports', 'Execute SQL reports'), - (16, 'create_reports', 'Create SQL Reports'), - (18, 'manage_courses', 'Add, edit and delete courses'), - (18, 'add_reserves', 'Add course reserves'), - (18, 'delete_reserves', 'Remove course reserves'), - (19, 'manage', 'Manage plugins ( install / uninstall )'), - (19, 'tool', 'Use tool plugins'), - (19, 'report', 'Use report plugins'), - (19, 'configure', 'Configure plugins') -; +INSERT +INTO permissions (module_bit, code, description) +VALUES + (1, 'circulate_remaining_permissions', i18n('Remaining circulation permissions')), + (1, 'override_renewals', i18n('Override blocked renewals')), + (1, 'overdues_report', i18n('Execute overdue items report')), + (3, 'parameters_remaining_permissions', i18n('Remaining system parameters permissions')), + (3, 'manage_circ_rules', i18n('manage circulation rules')), + (6, 'place_holds', i18n('Place holds for patrons')), + (6, 'modify_holds_priority', i18n('Modify holds priority')), + (9, 'edit_catalogue', i18n('Edit catalog (Modify bibliographic/holdings data)')), + (9, 'fast_cataloging', i18n('Fast cataloging')), + (9, 'edit_items', i18n('Edit Items')), + (11, 'vendors_manage', i18n('Manage vendors')), + (11, 'contracts_manage', i18n('Manage contracts')), + (11, 'period_manage', i18n('Manage periods')), + (11, 'budget_manage', i18n('Manage budgets')), + (11, 'budget_modify', i18n('Modify budget (can''t create lines, but can modify existing ones)')), + (11, 'planning_manage', i18n('Manage budget plannings')), + (11, 'order_manage', i18n('Manage orders & basket')), + (11, 'group_manage', i18n('Manage orders & basketgroups')), + (11, 'order_receive', i18n('Manage orders & basket')), + (11, 'budget_add_del', i18n('Add and delete budgets (but cant modify budgets)')), + (11, 'budget_manage_all', i18n('Manage all budgets')), + (13, 'edit_news', i18n('Write news for the OPAC and staff interfaces')), + (13, 'label_creator', i18n('Create printable labels and barcodes from catalog and patron data')), + (13, 'edit_calendar', i18n('Define days when the library is closed')), + (13, 'moderate_comments', i18n('Moderate patron comments')), + (13, 'edit_notices', i18n('Define notices')), + (13, 'edit_notice_status_triggers', i18n('Set notice/status triggers for overdue items')), + (13, 'edit_quotes', i18n('Edit quotes for quote-of-the-day feature')), + (13, 'view_system_logs', i18n('Browse the system logs')), + (13, 'inventory', i18n('Perform inventory (stocktaking) of your catalog')), + (13, 'stage_marc_import', i18n('Stage MARC records into the reservoir')), + (13, 'manage_staged_marc', i18n('Managed staged MARC records, including completing and reversing imports')), + (13, 'export_catalog', i18n('Export bibliographic and holdings data')), + (13, 'import_patrons', i18n('Import patron data')), + (13, 'edit_patrons', i18n('Perform batch modification of patrons')), + (13, 'delete_anonymize_patrons', i18n('Delete old borrowers and anonymize circulation history (deletes borrower reading history)')), + (13, 'batch_upload_patron_images', i18n('Upload patron images in batch or one at a time')), + (13, 'schedule_tasks', i18n('Schedule tasks to run')), + (13, 'items_batchmod', i18n('Perform batch modification of items')), + (13, 'items_batchdel', i18n('Perform batch deletion of items')), + (13, 'manage_csv_profiles', i18n('Manage CSV export profiles')), + (13, 'moderate_tags', i18n('Moderate patron tags')), + (13, 'rotating_collections', i18n('Manage rotating collections')), + (13, 'upload_local_cover_images', i18n('Upload local cover images')), + (15, 'check_expiration', i18n('Check the expiration of a serial')), + (15, 'claim_serials', i18n('Claim missing serials')), + (15, 'create_subscription', i18n('Create a new subscription')), + (15, 'delete_subscription', i18n('Delete an existing subscription')), + (15, 'edit_subscription', i18n('Edit an existing subscription')), + (15, 'receive_serials', i18n('Serials receiving')), + (15, 'renew_subscription', i18n('Renew a subscription')), + (15, 'routing', i18n('Routing')), + (16, 'execute_reports', i18n('Execute SQL reports')), + (16, 'create_reports', i18n('Create SQL Reports')), + (18, 'manage_courses', i18n('Add, edit and delete courses')), + (18, 'add_reserves', i18n('Add course reserves')), + (18, 'delete_reserves', i18n('Remove course reserves')), + (19, 'manage', i18n('Manage plugins ( install / uninstall )')), + (19, 'tool', i18n('Use tool plugins')), + (19, 'report', i18n('Use report plugins')), + (19, 'configure', i18n('Configure plugins')); -- 1.7.2.5