Login   Register  
PHP Classes
elePHPant
Icontem

File: example-data.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Mariano Iglesias  >  Internationalization and Localization  >  example-data.sql  >  Download  
File: example-data.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL script to insert some example data in the database.
Class: Internationalization and Localization
Get internationalized texts from databases or XML
Author: By
Last change:
Date: 9 years ago
Size: 2,005 bytes
 

Contents

Class file image Download
INSERT INTO i18n_language(iso639_1) VALUES('en');
INSERT INTO i18n_language(iso639_1) VALUES('es');

INSERT INTO i18n_locale(iso3166_1, language) VALUES ('us', 1);
INSERT INTO i18n_locale(iso3166_1, language) VALUES ('uk', 1);

INSERT INTO i18n_language_name(name, language_parent, language) VALUES('English', 1, 1);
INSERT INTO i18n_language_name(name, language_parent, language) VALUES('Inglés', 1, 2);

INSERT INTO i18n_language_name(name, language_parent, language) VALUES('Spanish', 2, 1);
INSERT INTO i18n_language_name(name, language_parent, language) VALUES('Español', 2, 2);

INSERT INTO i18n_locale_name(name, locale, language) VALUES('United States', 1, 1);
INSERT INTO i18n_locale_name(name, locale, language) VALUES('Estados Unidos', 1, 2);

INSERT INTO i18n_locale_name(name, locale, language) VALUES('United Kingdom', 2, 1);
INSERT INTO i18n_locale_name(name, locale, language) VALUES('Reino unido', 2, 2);

INSERT INTO i18n_container(name) VALUES ('language');

INSERT INTO i18n_section(name, container) VALUES('section', 1);
INSERT INTO i18n_section(name, container) VALUES('section1.2', 1);

INSERT INTO i18n_element(name, section) VALUES('element', 1);
INSERT INTO i18n_element(name, section) VALUES('element1.2.1', 2);
INSERT INTO i18n_element(name, section) VALUES('element1.2.2', 2);

INSERT INTO i18n_element_content(content, element, language) VALUES('My Element', 1, 1);
INSERT INTO i18n_element_content(content, element, language, locale) VALUES('My Element (UK)', 1, 1, 2);
INSERT INTO i18n_element_content(content, element, language) VALUES('Mi Elemento', 1, 2);
INSERT INTO i18n_element_content(content, element, language) VALUES('My Element 1.2.1', 2, 1);
INSERT INTO i18n_element_content(content, element, language) VALUES('Mi Elemento 1.2.1', 2, 2);
INSERT INTO i18n_element_content(content, element, language) VALUES('My Element 1.2.2', 3, 1);
INSERT INTO i18n_element_content(content, element, language) VALUES('Mi Elemento 1.2.2', 3, 2);