diff options
| author | Christian Fowler <spider@viovio.com> | 2007-03-27 13:25:33 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-03-27 13:25:33 +0000 |
| commit | bff58a69fc52297f86deb0841270b058caae14b7 (patch) | |
| tree | 14288a08bd5a1b4e8a1f3949372f9d1abd687a29 /admin | |
| parent | 535396202bc61d60c948913f4f2f41187e926260 (diff) | |
| download | blogs-bff58a69fc52297f86deb0841270b058caae14b7.tar.gz blogs-bff58a69fc52297f86deb0841270b058caae14b7.tar.bz2 blogs-bff58a69fc52297f86deb0841270b058caae14b7.zip | |
move constraints to liberty_content because content_id is not primary on teh secondary tables
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index ddc76d4..118f70a 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -28,13 +28,12 @@ $tables = array( ", 'blogs_posts_map' => " - crosspost_note X, 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`) - , CONSTRAINT `blogs_posts_map_blog_ref` FOREIGN KEY (`blog_content_id`) REFERENCES `".BIT_DB_PREFIX."blogs` (`content_id`)' + date_added I4, + crosspost_note X + CONSTRAINT ', CONSTRAINT `blogs_posts_map_post_ref` FOREIGN KEY (`post_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`) + , CONSTRAINT `blogs_posts_map_blog_ref` FOREIGN KEY (`blog_content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' ", ); |