diff options
| author | Jams H Thompson <jht001@users.sourceforge.net> | 2006-02-21 11:16:50 +0000 |
|---|---|---|
| committer | Jams H Thompson <jht001@users.sourceforge.net> | 2006-02-21 11:16:50 +0000 |
| commit | 747ea54175104bda02512fc0c5bb329ec8a099c5 (patch) | |
| tree | 0280fbc6209e3ee89cc328877fd76578b84570ad /admin/schema_inc.php | |
| parent | f1e200231b47cc36d5c90b7615c304880270c8b4 (diff) | |
| download | liberty-747ea54175104bda02512fc0c5bb329ec8a099c5.tar.gz liberty-747ea54175104bda02512fc0c5bb329ec8a099c5.tar.bz2 liberty-747ea54175104bda02512fc0c5bb329ec8a099c5.zip | |
Add title to liberty_content_links, fixes backlinks on newly created pages, and improves performance
Diffstat (limited to 'admin/schema_inc.php')
| -rw-r--r-- | admin/schema_inc.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 7a51026..7d2632d 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -76,9 +76,10 @@ $tables = array( 'liberty_content_links' => " from_content_id I4 PRIMARY, - to_content_id I4 PRIMARY + to_content_id I4 PRIMARY, + to_title C(160) PRIMARY CONSTRAINT ', CONSTRAINT `lib_content_links_from_ref` FOREIGN KEY (`from_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`) - , CONSTRAINT `lib_content_link_to_ref` FOREIGN KEY (`to_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' + ' ", 'liberty_content_prefs' => " |