insertlocale.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
These files no longer in use, they were from earlier failed attempts to insert into the database

  1. … 3 more files in changeset.
encoding for insertLocale.sql changed to utf-8 and cleaned up

Now this actually works, inserts the language valuse if they dont already exist, however it will fail if the number of languages surpass 127, because the locale_id is a tinint(4) and will only go up to 127

Procedure to update locales table in database, calls insertlocalses repeatedly until all languages have been covered

To add a new language, you nee only to add a line:

insertLocal(language_iso_code, country_iso_code, description, direction)

sql code (for language pack) for a procedure to insert locales into the lams_supported_local if they dont already exist.

This procedure is called by updateLocales.sql