From 30d52f434fb6cc606ab1a1a47041d369e8b4b2d5 Mon Sep 17 00:00:00 2001 From: Jure Kajzer Date: Wed, 26 Aug 2009 14:49:42 +0000 Subject: [PATCH] l10n added to oracle tables.sql --- maintenance/ora/tables.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/maintenance/ora/tables.sql b/maintenance/ora/tables.sql index 4ff9aea9ac..66fc60afd7 100644 --- a/maintenance/ora/tables.sql +++ b/maintenance/ora/tables.sql @@ -46,7 +46,7 @@ CREATE INDEX &mw_prefix.user_newtalk_i02 ON &mw_prefix.user_newtalk (user_ip); CREATE TABLE &mw_prefix.user_properties ( up_user NUMBER NOT NULL, up_property VARCHAR2(32) NOT NULL, - up_value BLOB + up_value CLOB ); CREATE UNIQUE INDEX &mw_prefix.user_properties_u01 on &mw_prefix.user_properties (up_user,up_property); CREATE INDEX &mw_prefix.user_properties_i01 on &mw_prefix.user_properties (up_property); @@ -565,6 +565,13 @@ ALTER TABLE &mw_prefix.valid_tag ADD CONSTRAINT &mw_prefix.valid_tag_pk PRIMARY CREATE INDEX si_title_idx ON &mw_prefix.searchindex(si_title) INDEXTYPE IS ctxsys.context; CREATE INDEX si_text_idx ON &mw_prefix.searchindex(si_text) INDEXTYPE IS ctxsys.context; +CREATE TABLE &mw_prefix.l10n_cache ( + lc_lang varchar2(32) NOT NULL, + lc_key varchar2(255) NOT NULL, + lc_value clob NOT NULL +); +CREATE INDEX &mw_prefix.l10n_cache_u01 ON &mw_prefix.l10n_cache (lc_lang, lc_key); + CREATE TABLE &mw_prefix.wiki_field_info_full ( table_name VARCHAR2(35) NOT NULL, column_name VARCHAR2(35) NOT NULL, -- 2.20.1