Login   Register  
PHP Classes
elePHPant
Icontem

File: i18n.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  >  i18n.sql  >  Download  
File: i18n.sql
Role: Auxiliary data
Content type: text/plain
Description: SQL script to create tables for using a database as a source for the I18N package.
Class: Internationalization and Localization
Get internationalized texts from databases or XML
Author: By
Last change:
Date: 9 years ago
Size: 1,878 bytes
 

Contents

Class file image Download
CREATE TABLE i18n_language (
	id INT NOT NULL AUTO_INCREMENT,
	iso639_1 CHAR(2) NOT NULL,
	active CHAR(1) NOT NULL DEFAULT 'Y',
	
	PRIMARY KEY(id),
	UNIQUE(iso639_1)
);

CREATE TABLE i18n_language_name (
	id INT NOT NULL AUTO_INCREMENT,
	name VARCHAR(255) NOT NULL,
	language_parent INT NOT NULL,
	language INT NOT NULL,

	PRIMARY KEY(id),
	FOREIGN KEY(language_parent) REFERENCES i18n_language(id),
	FOREIGN KEY(language) REFERENCES i18n_language(id)
);

CREATE TABLE i18n_locale (
	id INT NOT NULL AUTO_INCREMENT,
	iso3166_1 CHAR(2) NOT NULL,
	active CHAR(1) NOT NULL DEFAULT 'Y',
	language INT NOT NULL,
	
	PRIMARY KEY(id),
	FOREIGN KEY(language) REFERENCES i18n_language(id),
	UNIQUE(iso3166_1)
);

CREATE TABLE i18n_locale_name (
	id INT NOT NULL AUTO_INCREMENT,
	name VARCHAR(255) NOT NULL,
	locale INT NOT NULL,
	language INT NOT NULL,

	PRIMARY KEY(id),
	FOREIGN KEY(locale) REFERENCES i18n_locale(id),
	FOREIGN KEY(language) REFERENCES i18n_language(id)
);

CREATE TABLE i18n_container (
	id INT NOT NULL AUTO_INCREMENT,
	name VARCHAR(255) NOT NULL,

	PRIMARY KEY(id),
	UNIQUE(name)
);

CREATE TABLE i18n_section (
	id INT NOT NULL AUTO_INCREMENT,
	name VARCHAR(255) NOT NULL,
	container INT NOT NULL,

	PRIMARY KEY(id),
	UNIQUE(name),
	FOREIGN KEY(container) REFERENCES i18n_container(id)
);

CREATE TABLE i18n_element (
	id INT NOT NULL AUTO_INCREMENT,
	name VARCHAR(255) NOT NULL,
	section INT NOT NULL,

	PRIMARY KEY(id),
	UNIQUE(name),
	FOREIGN KEY(section) REFERENCES i18n_section(id)
);

CREATE TABLE i18n_element_content (
	id INT NOT NULL AUTO_INCREMENT,
	content TEXT DEFAULT NULL,
	element INT NOT NULL,
	language INT NOT NULL,
	locale INT DEFAULT NULL,

	PRIMARY KEY(id),
	FOREIGN KEY(element) REFERENCES i18n_element(id),
	FOREIGN KEY(language) REFERENCES i18n_language(id)
);