diff options
| author | Christian Fowler <spider@viovio.com> | 2007-03-19 00:01:18 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-03-19 00:01:18 +0000 |
| commit | da070219f3ea64921ad4829c62a6b6261e547e91 (patch) | |
| tree | 451f9a3922c1138a61f9b4fa0cd001165c530240 /admin | |
| parent | 13cdbe4e44888495cb095de79fa3ad03725a2e42 (diff) | |
| download | blogs-da070219f3ea64921ad4829c62a6b6261e547e91.tar.gz blogs-da070219f3ea64921ad4829c62a6b6261e547e91.tar.bz2 blogs-da070219f3ea64921ad4829c62a6b6261e547e91.zip | |
polish up schema_inc for blogs_posts_map changes
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 616c8ea..73a6312 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -28,8 +28,8 @@ $tables = array( ", 'blogs_posts_map' => " - post_content_id I4 NOT NULL, - blog_content_id I4 NOT NULL, + post_content_id I4 NOTNULL, + blog_content_id I4 NOTNULL, date_added I4 CONSTRAINT ' , CONSTRAINT `blogs_posts_map_post_ref` FOREIGN KEY (`post_content_id`) REFERENCES `".BIT_DB_PREFIX."blog_posts` (`content_id`) @@ -52,6 +52,8 @@ $gBitInstaller->registerPackageInfo( BLOGS_PKG_NAME, array( // ### Indexes $indices = array ( 'blog_posts_blog_id_idx' => array( 'table' => 'blog_posts', 'cols' => 'blog_id', 'opts' => NULL ), + 'blogs_content_id_idx' => array( 'table' => 'blogs', 'cols' => 'content_id', 'opts' => array( 'UNIQUE' ) ), + 'blog_posts_content_id_idx' => array( 'table' => 'blog_posts', 'cols' => 'content_id', 'opts' => array( 'UNIQUE' ) ), ); // TODO - SPIDERR - following seems to cause time _decrease_ cause bigint on postgres. need more investigation // 'blog_posts_created_idx' => array( 'table' => 'blog_posts', 'cols' => 'created', 'opts' => NULL ), |