| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -630,3 +630,24 @@ |
| 631 | 631 | ); |
| 632 | 632 | CREATE UNIQUE INDEX iwl_from ON iwlinks (iwl_from, iwl_prefix, iwl_title); |
| 633 | 633 | CREATE UNIQUE INDEX iwl_prefix_title_from ON iwlinks (iwl_prefix, iwl_title, iwl_from); |
| | 634 | + |
| | 635 | +CREATE TABLE msg_resource ( |
| | 636 | + mr_resource TEXT NOT NULL, |
| | 637 | + mr_lang TEXT NOT NULL, |
| | 638 | + mr_blob TEXT NOT NULL, |
| | 639 | + mr_timestamp TIMESTAMPTZ NOT NULL |
| | 640 | +); |
| | 641 | +CREATE UNIQUE INDEX mr_resource_lang ON msg_resource (mr_resource, mr_lang); |
| | 642 | + |
| | 643 | +CREATE TABLE msg_resource_links ( |
| | 644 | + mrl_resource TEXT NOT NULL, |
| | 645 | + mrl_message TEXT NOT NULL |
| | 646 | +); |
| | 647 | +CREATE UNIQUE INDEX mrl_message_resource ON msg_resource_links (mrl_message, mrl_resource); |
| | 648 | + |
| | 649 | +CREATE TABLE module_deps ( |
| | 650 | + md_module TEXT NOT NULL, |
| | 651 | + md_skin TEXT NOT NULL, |
| | 652 | + md_deps TEXT NOT NULL |
| | 653 | +); |
| | 654 | +CREATE UNIQUE INDEX md_module_skin ON module_deps (md_module, md_skin); |