diff options
| author | Christian Fowler <spider@viovio.com> | 2007-09-27 13:49:15 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-09-27 13:49:15 +0000 |
| commit | 1b4f2b83c10343cfffb7561f8020706259f982a8 (patch) | |
| tree | 57c36da67d67f68c10f629572f7b4e3c3dd39d22 /admin | |
| parent | 5f9a1cb4d4d8bda849896230b9ebbbaca922806c (diff) | |
| download | liberty-1b4f2b83c10343cfffb7561f8020706259f982a8.tar.gz liberty-1b4f2b83c10343cfffb7561f8020706259f982a8.tar.bz2 liberty-1b4f2b83c10343cfffb7561f8020706259f982a8.zip | |
SCHEMA CHANGE: add new liberty_content_data table to hold normalized text data of liberty content. currently only used for a universal 'summary' description, however could be expanded to hold lc.data itself
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 7 | ||||
| -rw-r--r-- | admin/upgrade_inc.php | 10 |
2 files changed, 11 insertions, 6 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 87312a9..6f37cb2 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -44,10 +44,11 @@ $tables = array( , CONSTRAINT liberty_aliases_content_fkey FOREIGN KEY( `content_id` ) REFERENCES `".BIT_DB_PREFIX."liberty_content` ( `content_id` )' ", -'liberty_content_summaries' => " +'liberty_content_data' => " content_id I4 PRIMARY, - summary X NOTNULL - CONSTRAINT ', CONSTRAINT `liberty_content_summaries_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` ( `content_id` )' + data X NOTNULL, + type C(32) NOTNULL + CONSTRAINT ', CONSTRAINT `liberty_content_data_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` ( `content_id` )' ", 'liberty_content_hits' => " diff --git a/admin/upgrade_inc.php b/admin/upgrade_inc.php index 280964c..a4de993 100644 --- a/admin/upgrade_inc.php +++ b/admin/upgrade_inc.php @@ -37,10 +37,11 @@ array( 'DATADICT' => array( 'users_object_permissions' => 'liberty_content_permissions', )), array( 'CREATE' => array ( - 'liberty_content_summaries' => " + 'liberty_content_data' => " content_id I4 PRIMARY, - summary X NOTNULL - CONSTRAINTS ', CONSTRAINT `liberty_content_summaries_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ) ' + summary X NOTNULL, + type C(32) NOTNULL + CONSTRAINTS ', CONSTRAINT `liberty_content_data_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ) ' ", 'liberty_content_hits' => " content_id I4 PRIMARY, @@ -105,6 +106,9 @@ array( 'DATADICT' => array( 'object_id' => array( '`content_id`', 'I4' ), 'is_revoked' => array( '`is_revoked`', 'VARCHAR(1)' ), ), + 'liberty_content_history' => array( + 'summary' => array( '`summary`', 'X' ) + ), )), /* The installer can't add constraints after table creation yet so drop this constraint. array( 'SQL' => array( |