diff options
| author | Christian Fowler <spider@viovio.com> | 2007-09-15 01:47:17 +0000 |
|---|---|---|
| committer | Christian Fowler <spider@viovio.com> | 2007-09-15 01:47:17 +0000 |
| commit | 9e3ec907fe207eef6f1ab3e7d07bfe2849b130d5 (patch) | |
| tree | 45d2fb9c2e3b65206cf24340b6dbdc0ab0b20af9 /admin | |
| parent | 6838510a82526f67f1517fb788169d66938c91f9 (diff) | |
| download | liberty-9e3ec907fe207eef6f1ab3e7d07bfe2849b130d5.tar.gz liberty-9e3ec907fe207eef6f1ab3e7d07bfe2849b130d5.tar.bz2 liberty-9e3ec907fe207eef6f1ab3e7d07bfe2849b130d5.zip | |
schema clean up to avoid chicken-n-egg constraint violations
Diffstat (limited to 'admin')
| -rw-r--r-- | admin/schema_inc.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/admin/schema_inc.php b/admin/schema_inc.php index f9f1fa3..d26a323 100644 --- a/admin/schema_inc.php +++ b/admin/schema_inc.php @@ -185,9 +185,11 @@ $tables = array( content_id I4 PRIMARY, is_revoked C(1) CONSTRAINT ' - , CONSTRAINT `liberty_content_perm_perm_ref` FOREIGN KEY (`perm_name`) REFERENCES `".BIT_DB_PREFIX."users_permissions` (`perm_name`) , CONSTRAINT `liberty_content_id_ref` FOREIGN KEY (`content_id`) REFERENCES `".BIT_DB_PREFIX."liberty_content` (`content_id`)' ", +/* chicken-and-egg constraint dependencies: Liberty needs user_id, Users needs liberty + , CONSTRAINT `liberty_content_perm_perm_ref` FOREIGN KEY (`perm_name`) REFERENCES `".BIT_DB_PREFIX."users_permissions` (`perm_name`) +*/ 'liberty_content_connection_map' => " from_content_id I4 PRIMARY, |