-- -- An OpenACS locale is identified by a language and country. -- Locale definitions in Oracle consist of a language, and optionally -- territory and character set. (Languages are associated with default -- territories and character sets when not defined). The formats -- for numbers, currency, dates, etc. are determined by the territory. -- language is the shortest ISO 639 code (lowercase). -- country is two letter (uppercase) abbrev is ISO 3166 country code -- mime_charset is IANA charset name -- nls_charset is Oracle charset name -- CREATE TABLE ad_locales ( locale varchar(30) PRIMARY KEY NOT NULL, language varchar(3) NOT NULL, country char(2) NOT NULL, variant varchar(30), label varchar(200) NOT NULL, nls_language varchar(30) NOT NULL, nls_territory varchar(30), nls_charset varchar(30), mime_charset varchar(30), default_p bool DEFAULT false, enabled_p bool DEFAULT true ); CREATE UNIQUE INDEX ad_locale_name_unq ON ad_locales (label); CREATE TRIGGER RI_ConstraintTrigger_a_341092 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341093 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341117 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341118 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341157 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341158 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341172 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341173 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342557 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342558 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342577 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342578 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342597 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342598 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343012 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343013 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343037 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343038 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ad_locales: --ad_locale_user_prefs(ad_locale_abbrev_pk) --ad_locale_user_prefs(ad_locale_name_unq) --category_search(ad_locale_abbrev_pk) --category_search(ad_locale_name_unq) --category_synonyms(ad_locale_abbrev_pk) --category_synonyms(ad_locale_name_unq) --category_translations(ad_locale_abbrev_pk) --category_translations(ad_locale_name_unq) --category_tree_translations(ad_locale_abbrev_pk) --category_tree_translations(ad_locale_name_unq) --lang_messages(ad_locale_abbrev_pk) --lang_messages(ad_locale_name_unq) --lang_messages_audit(ad_locale_abbrev_pk) --lang_messages_audit(ad_locale_name_unq) --lang_translation_registry(ad_locale_abbrev_pk) --lang_translation_registry(ad_locale_name_unq) --user_preferences(ad_locale_abbrev_pk) --user_preferences(ad_locale_name_unq) -- Table size: 8,192 bytes -- Table rows: 60
Begin main content
