diff options
| author | Christian Fowler <spider@viovio.com> | 2007-11-18 06:29:35 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-11-18 06:29:35 +0000 |
| commit | ff69f5fd81c7c836a32b14b7b8d504db44c4a083 (patch) | |
| tree | 95de67c69d74cbef5e50ae9c8a82496c7e268a45 /admin | |
| parent | dfaf3f490f18ff058895d0b6f0dedfcd6572f16b (diff) | |
| download | tags-ff69f5fd81c7c836a32b14b7b8d504db44c4a083.tar.gz tags-ff69f5fd81c7c836a32b14b7b8d504db44c4a083.tar.bz2 tags-ff69f5fd81c7c836a32b14b7b8d504db44c4a083.zip | |
fix foreign key
Diffstat (limited to 'admin')
| -rwxr-xr-x | admin/schema_inc.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 31880f1..3c79fae 100755 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -10,9 +10,9 @@ $tables = array( content_id I4 NOTNULL, tagger_id I4 NOTNULL, tagged_on I8 NOTNULL - CONSTRAINT ', CONSTRAINT `tags_content_map_tag_ref` FOREIGN KEY (`tag_id`) REFERENCES `".BIT_DB_PREFIX."tags`( `tag_id` ) - , CONSTRAINT `tags_content_map_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ) - , CONSTRAINT `tags_content_map_tagger_id_ref` FOREIGN KEY (`tagger_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` )' + CONSTRAINT ', CONSTRAINT `tags_content_map_tag_ref` FOREIGN KEY (`tag_id`) REFERENCES `".BIT_DB_PREFIX."tags` ( `tag_id` ) + , CONSTRAINT `tags_content_map_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` ( `content_id` ) + , CONSTRAINT `tags_content_map_tagger_id_ref` FOREIGN KEY (`tagger_id`) REFERENCES `".BIT_DB_PREFIX."users_users` ( `user_id` )' " ); @@ -54,4 +54,4 @@ $gBitInstaller->registerUserPermissions( TAGS_PKG_NAME, array( array( 'p_tags_edit', 'Can edit tags', 'editors', TAGS_PKG_NAME ), array( 'p_tags_remove', 'Can delete tags', 'admin', TAGS_PKG_NAME ), ) ); -?>
\ No newline at end of file +?> |