diff options
| author | Christian Fowler <spider@viovio.com> | 2006-02-04 16:56:06 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2006-02-04 16:56:06 +0000 |
| commit | ad0a664fc8b46af019e1e4f57d23fadcf67bbc98 (patch) | |
| tree | 1b81d523976e68d249e1f0b96a586e868f74b72c /admin | |
| parent | fd0d36738afdee0279e95f2ec413ce9cc2a9828f (diff) | |
| download | pigeonholes-ad0a664fc8b46af019e1e4f57d23fadcf67bbc98.tar.gz pigeonholes-ad0a664fc8b46af019e1e4f57d23fadcf67bbc98.tar.bz2 pigeonholes-ad0a664fc8b46af019e1e4f57d23fadcf67bbc98.zip | |
masse fixing of schema CONSTRAINTs. they seem to work now that adodb has decided to change CONSTRAINTS back to CONSTRAINT
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index 7983931..4bc4d76 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -4,16 +4,16 @@ $tables = array( 'pigeonholes' => " content_id I4 NOTNULL PRIMARY, structure_id I4 NOTNULL PRIMARY - CONSTRAINTS ', - CONSTRAINT `pigeonholes_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ), - CONSTRAINT `pigeonholes_ref` FOREIGN KEY (`structure_id`) REFERENCES `".BIT_DB_PREFIX."liberty_structures`( `structure_id` )' + CONSTRAINT ', + CONSTRAINT `pigeonholes_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ), + CONSTRAINT `pigeonholes_structure_ref` FOREIGN KEY (`structure_id`) REFERENCES `".BIT_DB_PREFIX."liberty_structures`( `structure_id` )' ", 'pigeonhole_members' => " parent_id I4 NOTNULL PRIMARY, content_id I4 NOTNULL PRIMARY - CONSTRAINTS ', - CONSTRAINT `pigeonhole_members_ref` FOREIGN KEY (`parent_id`) REFERENCES `".BIT_DB_PREFIX."pigeonholes`( `content_id` ), - CONSTRAINT `pigeonhole_members_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` )' + CONSTRAINT ', + CONSTRAINT `pigeonhole_members_parent_ref` FOREIGN KEY (`parent_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` ), + CONSTRAINT `pigeonhole_members_content_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content`( `content_id` )' " ); |