| Index: trunk/phase3/maintenance/ora/tables.sql |
| — | — | @@ -46,7 +46,7 @@ |
| 47 | 47 | CREATE TABLE &mw_prefix.user_properties ( |
| 48 | 48 | up_user NUMBER NOT NULL, |
| 49 | 49 | up_property VARCHAR2(32) NOT NULL, |
| 50 | | - up_value BLOB |
| | 50 | + up_value CLOB |
| 51 | 51 | ); |
| 52 | 52 | CREATE UNIQUE INDEX &mw_prefix.user_properties_u01 on &mw_prefix.user_properties (up_user,up_property); |
| 53 | 53 | CREATE INDEX &mw_prefix.user_properties_i01 on &mw_prefix.user_properties (up_property); |
| — | — | @@ -565,6 +565,13 @@ |
| 566 | 566 | CREATE INDEX si_title_idx ON &mw_prefix.searchindex(si_title) INDEXTYPE IS ctxsys.context; |
| 567 | 567 | CREATE INDEX si_text_idx ON &mw_prefix.searchindex(si_text) INDEXTYPE IS ctxsys.context; |
| 568 | 568 | |
| | 569 | +CREATE TABLE &mw_prefix.l10n_cache ( |
| | 570 | + lc_lang varchar2(32) NOT NULL, |
| | 571 | + lc_key varchar2(255) NOT NULL, |
| | 572 | + lc_value clob NOT NULL |
| | 573 | +); |
| | 574 | +CREATE INDEX &mw_prefix.l10n_cache_u01 ON &mw_prefix.l10n_cache (lc_lang, lc_key); |
| | 575 | + |
| 569 | 576 | CREATE TABLE &mw_prefix.wiki_field_info_full ( |
| 570 | 577 | table_name VARCHAR2(35) NOT NULL, |
| 571 | 578 | column_name VARCHAR2(35) NOT NULL, |